Let's take another look at the relatively simple topic of TAB (Tax Amortization Benefit).
Acquisition accounting requires us to put a fair value on the acquired assets. In case of a share deal which involves internally generated (thus not recognized to this point) intangible assets we need to come up with the valuation.
In the absence of reliable external indicators of value (a market for similar assets) one is required to look at the future cash flows generated from using the assets (for instance sales revenues from products made using the technology behind the asset, net of any COGS, M&D etc, and also net of tax which would be applicable to such income. One should also adopt an "independent valuer" perspective and thus exclude any synergies to be realized from the deal - assumption being an "independent valuer" wouldn't be able to realize similar synergies.)
So far so good - but there is one more thing - namely the TAB.
Conceptually it represents an additional saving realized from deducting the amortization of the asset itself
in arriving at taxable income.
Now - here's where it gets tricky - these additional tax savings are also a part of the ultimate asset value - and thus drive the amortization charge up - which in turn leads to higher tax benefits - which get added to the asset value - which drives the amortization charge up - which in turn... you get the picture. It's a classical circular reference in the making. But it doesn't have to be.
The formula to use is:
TAB =( NPV * (n / ( n - TR * PV of 1$) -1))
where
NPV = Net present value of the future cash flows (net of tax and at a specified Discount rate)
TR = applicable tax rate
PV of 1$ at a specified Discount rate and over a nr of tax amortisation periods of the asset (assumed linear)
n = nr of tax amortisation periods of the asset
assuming NVP is already calculated and entered in cell A1 the Excel formula for TAB at 30% tax rate, 10% discount rate and 10 year amortization would be:
= A1 * ( 10 / ( 10 - 30% * PV (10%, 10, 1)) - 1)
In an extreme case of discount rate of 0% and the tax rate of 50% the TAB = NPV - or in other words one would need to double the NVP amount to arrive at the Fair Value. (seems counterintuitive - but actually is correct - if the original "pre-TAB" NPV was 50 then the ultimate FV is 100 - amortized at 50% tax rate gives us a tax saving of 50 - which added to the original NPV of 50 gives the Fair Value of exactly 100... QED)
And here is a link to a simple excel spreadsheet
Showing posts with label accounting. Show all posts
Showing posts with label accounting. Show all posts
Thursday, 1 March 2012
Wednesday, 9 May 2007
Tax Amortization Benefit - TAB
The idea is simple:
IFRS requires the purchaser (acquirer) to value all the identifiable Intangible Assets at their fair value - and in the absence of an active market (say, the acquired technology is unique) the way to come up with fair value is to discount the future cash flows generated from the use of an asset in question.
Now, in addition, the valuation is to be performed from an "independent purchaser" perspective - and so all the synergies that could be generated by the purchaser are to be excluded from the valuation model.
However, the "independent purchaser" approach stipulates that the tax benefits realised from using the asset in the future (tax amortisation) are to be included in the valuation...Why? Well, typically, in an asset deal scenario, the purchaser would be allowed the tax amortisation and hence would factor it in the purchase price.
What it means is that, on top of the present value of future inflows, you need to put the present value of tax benefits resulting from the asset amortisation...
An interesting thing to realise is that to solve it in excel requires using "circular references". Why? Well, we want to calculate the present value of tax benefits realised on amortising the "entire" value of an asset - which is made of the "original" value calculated using the DCF model and of the tax benefit itself.
In other words - if the original (net of TAB) value of an asset is 100 and the TAB is calculated at 20 for a given tax amortisation period and applicable tax rate (as well as discount rate), the present value of tax amortisation of an asset worth 120 (100+TAB) equals 20 i.e. the TAB itself...
A detailed walk-through on how to calculate TAB at eHow
Here is a more recent take on TAB
Now, in addition, the valuation is to be performed from an "independent purchaser" perspective - and so all the synergies that could be generated by the purchaser are to be excluded from the valuation model.
However, the "independent purchaser" approach stipulates that the tax benefits realised from using the asset in the future (tax amortisation) are to be included in the valuation...Why? Well, typically, in an asset deal scenario, the purchaser would be allowed the tax amortisation and hence would factor it in the purchase price.
What it means is that, on top of the present value of future inflows, you need to put the present value of tax benefits resulting from the asset amortisation...
An interesting thing to realise is that to solve it in excel requires using "circular references". Why? Well, we want to calculate the present value of tax benefits realised on amortising the "entire" value of an asset - which is made of the "original" value calculated using the DCF model and of the tax benefit itself.
In other words - if the original (net of TAB) value of an asset is 100 and the TAB is calculated at 20 for a given tax amortisation period and applicable tax rate (as well as discount rate), the present value of tax amortisation of an asset worth 120 (100+TAB) equals 20 i.e. the TAB itself...
A detailed walk-through on how to calculate TAB at eHow
Here is a more recent take on TAB
Subscribe to:
Posts (Atom)