Example: Cash flow projections and value in use under IAS 36
In my last article, I tried to outline the main things to consider and to avoid when preparing the cash flow projections for the impairment tests under IAS 36.
Here let’s illustrate the theory and show the numerical example of making cash flow projections for impairment tests.
Please be warned that there are many variations of the cash flow projections and value in use calculations, and you should always apply your judgment (while following the rules).
And now the small recap:
The impairment testing aims at proving that the carrying amount of an asset or cash-generating unit is LOWER than its recoverable amount.
Recoverable amount is the higher of fair value less costs of disposal and value in use.
We always know the carrying amount – please look to your financial statements or accounting records.
However, in order to determine the recoverable amount, we need to find out either fair value less costs of disposal or value in use.
Single asset or cash generating unit?
The first decision you should make in your impairment test is:
Should you test a single asset or a cash-generating unit?
It depends.
You should test a single asset for impairment when:
- It is possible to determine the asset’s fair value less cost of disposal AND it is greater than the asset’s carrying amount. In this case, you don’t have to calculate value in use, because the asset is not impaired; or
- The asset generates individually identifiable and independent cash inflows.
Based my own experience, vast majority of companies perform impairment tests on cash-generating units, because it is hard to determine fair value of used assets and the assets generate independent cash inflows rarely on its own.
For this reason, this example will show you how to draft the cash flow projections for value in use calculation on cash-generating unit (CGU), not on an individual asset.
Example: Cash flow projections for cash-generating unit
A parent performs an impairment test of its cash-generating unit, which is a whole subsidiary.
The carrying amount of a subsidiary, including allocated goodwill and working capital (current assets and current liabilities), is CU 150 000.
It is not possible to determine its fair value less costs of disposal and therefore the parent determines the subsidiary’s recoverable amount based on its value in use.
At the end of 20X1, the subsidiary reported the following results:
- Revenue from principal activities: CU 50 000
- Fixed costs: CU 25 000
- Variable costs: CU 15 000
- Net profit for the year before taxation: CU 10 000
- Closing working capital (net current asset): CU 1 000
For the purpose of value in use calculation, the parent made the following assumptions:
- Based on information about the subsidiary’s industry, the market expects the growth of 5% per year in average for the next 5 years, and then 2% in the long term. These rates are nominal and include the effect of inflation.
- Pre-tax discount rate determined based on company’s cost of capital is 8% p.a.
- Based on past experience, the company assumes the annual replacement capital expenditure of CU 500 each year net of the inflation effect.
- Fixed costs are the same in real terms (hint: careful about the inflation!). They exclude depreciation and amortization.
- Variable costs are about 30% of the revenue.
- The assumed inflation rate is 1.5% p.a. for the next 10 years.
Step 1 – Starting point: 5-year forecast
When you are testing a whole company or even its part as CGU, it is necessary to draft net pre-tax cash flows generated by that CGU for a maximum of 5 years.
Our starting point is to prepare the forecast of CGU’s profits – not yet cash flows.
Based on the numbers and assumptions above, we can calculate the net profits as follows:
Notes:
- Revenue in the year 20X2 was calculated as revenue in 20X1 of CU 50 000 increased by the growth rate of 5%: 50 000*(1+5%) = 52 500. Revenues in the next years were calculated accordingly.
- Fixed costs were increased by the inflation rate of 1.5% each year. For the year 20X2: CU 25 000*(1+1.5%) = 25 375
- Variable costs are simply 30% of revenue
- EBIDTA = earnings before interest, depreciation, tax and amortization
Now, you might ask: Why did we stop at profit before tax, depreciation, interest and amortization?
The reasons are as follows:
- Depreciation and amortization are not included, because they are NOT the cash items. Our aim is to arrive at pre-tax cash flows.
- Interest is a financing item which is excluded as required by IAS 36;
- Value in use is calculated on a pre-tax basis to avoid complications related to tax losses carried forward, deferred taxation, etc.
Step 2: Adjust EBIDTA to arrive at cash flows
Once you have your EBIDTA forecasts, you need to realize that they do not represent the cash flow projections for value in use calculation.
Not yet.
We have to take a few more items into account:
- Changes in working capital: payments of liabilities and collections of receivables generally do not enter into EBIDTA, but they affect the net cash flows.
Therefore, don’t forget to adjust EBIDTA by the net change in working capital. - There might be some expenditures for replacement of non-current assets in order to maintain the production capacity of CGU. Neither those are included in EBIDTA, because they enter in profit or loss as depreciation or amortization.
With regard to changes in working capital, you need to forecast the net balance of your working capital at the end of each period and then adjust EBIDTA.
For example, if opening net balance of your working capital in 20X2 is CU 1 000 (net asset) and closing balance of your working capital in 20X2 is CU 1 100, then the cash flow change in net working capital is CU -100.
The logic is simple: you have more money tied in a working capital at the end of 20X2 than in the beginning of 20X2, thus the net cash flow change is negative as you have less cash available (CU 1 000-CU 1 100).
Our adjusted cash-flow table is as follows:
Notes:
- Opening and closing net working capital numbers are forecasted, in other words – I made them up in this example.
- Capex is assumed annual 500 increased by the inflation rate.
Step 3: Discount net cash flows with pre-tax discount rate
Now it’s time to select the most appropriate discount rate.
In many cases, companies use their own cost of capital derived by WACC model, which is often OK for auditors, too.
However, be careful, because WACC will give you post-tax rate and you are required to use pre-tax rate here.
You can make an attempt to calculate value in use based on post-tax rate, but in such a case your cash flows need to incorporate tax effects – and that is not a very nice, neat and reliable exercise.
I strongly recommend calculating pre-tax rate from your post-tax rate (e.g. WACC) – here’s an article that can help.
However, let me add here, that this formula not always works well. In other words, pre-tax rate is not always the post-tax rate grossed up by the appropriate tax rate.
But let’s not get into many details here, because that’s the topic for another article.
One more consideration when discounting:
You need to make a good assumption when most of your cash flows happen.
In the beginning of the year? At the year-end? Or are they spread evenly throughout the year?
If they are spread evenly, then you should apply so-called “mid-year convention” in calculating your discount factors.
For example, let’s say that you want to discount cash flows in the year 2 and you assume they are spread evenly throughout the year 2.
Thus you will use the number 1.5 as number of years in the discount factor formula. It indicates, that the cash flows happen in the middle of the year 2.
In the following table, I used the year-end convention. For example, in the year 2, I used number 2 as number of years in the discount factor formula:
Notes:
- Discount factor for the year 20X3 (year 2) = 1/((1+8%) to the power of 2)
- Present value of cash flows in the year 1 = net cash flows in the year 1 of 10 768 multiplied with the discount factor for the year 1
- Net present value = sum of all present values of cash flows in individual years
Step 4: Calculate terminal value
As I explained in the previous article, terminal value is a very important number because it estimates the net cash flows beyond forecasted period of maximum 5 years.
In some cases the terminal value represents the net cash flows to receive from the sale of an asset at the end of its useful life.
However, in this particular case we can reasonably assume that a subsidiary – our CGU in testing – will operate its business for indefinite number of years.
Therefore the terminal value estimates the net cash flows beyond forecasted period.
Two most common methods to calculate it are:
- Exit multiple – this is the multiple of shareholders’ cash flows in the last year of projections.
In our example, we assume to make net cash inflow of 17 032 CU at the end of year 5 in your projections.
Market data say that similar companies sell for multiple of 10 meaning that to sell your company you can ask ten times your net shareholders’ cash flow.In this case, you can estimate your terminal value to be 10 x 17 032 = 170 320.
Then you need to discount it with the pre-tax discount rate: 170 320 * 0,681 = 115 988 and include in the cash flow projections.
- Perpetuity – you would take the last year’s projection and apply perpetuity formula to it.
In this example, we projected the net cash inflow of 17 032 CU at the end of year 5.
We assume the long-term growth rate to be 2% and your pre-tax discount rate is 8%.
Then we can apply the growing perpetuity formula which is the cash flow after the first period divided by the difference between the discount rate and the growth rate.
In fact you are calculating growing perpetuity as a series of periodic payments that grow at a proportionate rate for an infinite amount of time.
So, your terminal value would be:- CU 17 032, being the net cash flow in the last year (year 5) – just note that here it is unadjusted, but you should adjust it for terminal value calculation if needed;
- Increased by the annual rate of 2%: CU 17 032*(1+2%)= 17 373;
- Divided by the difference between the discount rate of 8% and growth rate of 2% = 17 373/(8%-2%) = 289 550;
- Discounted to present value, because you calculate this at the end of year 5 = 289 550 * 0,681= 197 184
As you can see, the two amounts are different when we used different methods:
- Exit multiple method: CU 115 988; and
- Perpetuity method: CU 197 184.
This is quite normal, because perpetuity method assumes to carry on with business and accept business risks beyond 5 years, and exit multiple method assumes selling the business and getting rid of all associated business risks.
Which method to apply?
When the plan is to sell a subsidiary after 5 years, then exit multiple is probably more suitable method.
However, when the plan is to continue the business indefinitely, then perpetuity method is more acceptable.
Step 5: Sum up and calculate value in use
To arrive at value in use, we must sum up the net present value of cash flows in the next 5 years and the present value of terminal value:
- Net present value of cash flows: CU 54 139
- Present value of terminal value (using perpetuity method): CU 197 184
- Value in use: CU 251 323
You can now see why you should get the terminal value right: it represents 78% of value in use.
The carrying amount of CGU was CU 150 000. Value in use is CU 251 391, which is much greater than the carrying amount and thus there’s no impairment.
Final word
Please – if you calculate your value in use very close to the carrying amount, then expect that your auditor will ask a lot of questions and examine your calculations thoroughly.
The reason is that in such a sensitive case, even a slight shift in your assumptions can bring you from “no impairment” to “impairment loss like a hell”.
Did you like this article or do you have any question? Please leave me a comment below. Thanks!
Tags In
JOIN OUR FREE NEWSLETTER AND GET
report "Top 7 IFRS Mistakes" + free IFRS mini-course
Please check your inbox to confirm your subscription.
14 Comments
Leave a Reply Cancel reply
Recent Comments
- Muskan Agarwal on 5-Step Model for Revenue Recognition under IFRS 15 + Journal Entries
- Silvia on Accounting when acquired subsidiary is not a business
- Silvia on What are directly attributable costs?
- swimmer30 on What are directly attributable costs?
- Nik on Accounting when acquired subsidiary is not a business
Categories
- Accounting Policies and Estimates (14)
- Consolidation and Groups (24)
- Current Assets (21)
- Financial Instruments (55)
- Financial Statements (52)
- Foreign Currency (9)
- IFRS Videos (70)
- Insurance (3)
- Most popular (6)
- Non-current Assets (54)
- Other Topics (15)
- Provisions and Other Liabilities (44)
- Revenue Recognition (26)
- Uncategorized (1)
Financial assets and cash and cash equivalent are not considered in the above cashflow projection. These balances should be added back in the value in use amount in order to compared to NAV apple to apple.
Dear Silvia,
Lets assume a business has a concession agreement which will be ending in 2040, so we should calculate the value in use until 2040, my question is which method we should follow to calculate Terminal value, it can’t be either exit multiple nor perpetuity ? can you please provide your suggestion
Thanks
Dear Slivia,
I believe the standard is saying to estimate cash flows up to 5 years without considering the terminal value, can you please confirm this one.
good job. it is very useful.
Dear Silvia,
Thank you for providing me with an important article in my career.
Hi S
you have done a good job. I am preparing to join the IFRS Kit.
well-done
Thank you. you have done a great job. Small clarification, discount rate is 8% and growth rate is 2%. so it should be (8%-2%) and not (8%-1%) as you mention above. correct me if i am wrong
Thank you.
Yes, sure, that was a typo – thank you!
Dear Edmund,
Regarding the estimation on Net Working Capital changes. As such I would use the increase in revenue (5%) as a basis. You can expect an increase in Trade receivables with the same percentage. You can therefore also assume an 5% increase in trade payables (for the variable costs part of your trade payables). Would you agree?
Gr, Wim
Thanks 🙂
Helpful thanks Silvia
Dear Silvia,
Thank you for providing us with such an informative article on impairment testing.
In working it out, it however appears to be rather challenging to estimate the net changes in working capital for each year since we will have to factor in the anticipated changes in both receivables and payables and accruals.
Would you mind advising us whether there would be any straightforward approach for us to take to estimate the changes in working capital for future years in calculating the VIU of the CGU? Additionally, in your adjusted cash flow table, may we know whether the “capex” stands for capital assets?
Hi Edmund, before I advised, Wim made a valuable comment below, you can take this advice. Capex = CAPital EXpenditures.
Hi Edmund, one simple method is the following:
a) calculate DSO – Days Sales Outstanding [(Receivables/Sales)*365], DPO – Days Payable Outstanding [(Payable/Cost of Sales)*365] and DOH – Days on Inventory on Hand [(Inventories/Cost of Sales)*365] for the last 2/3 years;
b) calculate the averages of the results obtained at point a);
c) then, divide the sales or the variable costs described in the article’s example by 365 and multiply the result for the DSO, DPO or DOH calculated above. In this way you will have Receivables, Payables and Inventory for 20X2, 20X3, 20X4, 20X5 and 20X6;
d) finally, calculate the differences in order to define the changes in working capital.