Once the assumptions are established, we must compute the free cash flow to the Firm (FCFF). Moving forward, we must only come across data from year six, and thus begin the estimation with EBIT. To account for the tax benefits, we shall factor in its effect on EBIT.
We have not accounted for EBIT in our P&L, so we need to work out the figures quickly. EBIT stands for earnings before interest and taxes; thus, all expenses apart from interest must be subtracted from total income to calculate it.
We factor in the tax shield effect on EBIT after multiplying it with (1-tax rate), then adding all the non-cash charges. We subtract working capital and CAPEX charges to calculate free cash flow to the Firm. I have computed these figures in excel, and my sheet looks like this –
I have created an index for columns E, F, G and H to ensure that the link between columns J to N and years 6 to 10 is consistent with the rest of the sheets. You may arrange this sheet as you find suitable.
EBIT and depreciation figures can be sourced from the P&L. As for working capital and CAPEX, you’ll find them on the cash flow statement. I’ve included a link to download the excel sheet at the end of this chapter, so don’t forget to take a look.
– Terminal Growth value
We now have the free cash flow to the Firm projected up until year 10. We assume that the company will not only survive but also continue to generate free cash flow thereafter. This rate of growth is referred to as the ‘terminal growth rate‘, which is typically equal to the country’s long-term inflation rate.
Using your imagination, fast-forward 5 years. Consider all the cash flows over eternity that your company will generate. Now bring that total up to the present year.
To calculate the terminal growth value, use the formula.
= 5th Year cash flow * (1+terminal growth rate)/(WACC-terminal growth rate)
I won’t go into the details of deriving the formula, but that’s what you use to calculate the cumulative sum of all future cash flows.
Here is the calculated value –
The terminal value plays a crucial role in the ultimate valuation of the company, as it is a considerable figure.
We have the next five year’s free cash flow to the firm numbers, as well as the terminal value. Now, we should discount them all and convert them into present-day terms by computing the present value of all the future cash flows.
Three years from now, in Year 8, the free cash flow amounting to 294.14 Cr can be expected. The present value can be calculated from this figure.
= 294.14/ (1+10.25%)^3
= 219.4923 Cr.
We can do this systematically in excel –
I first calculated a discount factor, which is –
1/(1+WACC) ^ (time)
This example requires a three-year period, and the discount factor for its third year is 0.746. I then have to calculate the present value by multiplying this factor with the free cash flow.
So 0.746 * 294.14 = 219.4923Cr.
I have also taken into account the present worth of the terminal growth value.
© 2021 BP Equities Pvt. Ltd.
All Rights Reserved
By signing up, you agree to receive transactional messages on WhatsApp. You may also receive a call from a BP Wealth representative to help you with the account opening process
Disclosures and Disclaimer: Investment in securities markets are subject to market risks; please read all the related documents carefully before investing. The securities quoted are exemplary and are not recommendatory. Past performance is not indicative of future results. Details provided in the above newsletter are for educational purposes and should not be construed as investment advice by BP Equities Pvt. Ltd. Investors should consult their investment advisor before making any investment decision. BP Equities Pvt Ltd – SEBI Regn No: INZ000176539 (BSE/NSE), IN-DP-CDSL-183-2002 (CDSL), INH000000974 (Research Analyst), CIN: U45200MH1994PTC081564. Please ensure you carefully read the Risk Disclosure Document as prescribed by SEBI | ICF
Attention Investors
Issued in the interest of Investors
Communications: When You use the Website or send emails or other data, information or communication to us, You agree and understand that You are communicating with Us through electronic records and You consent to receive communications via electronic records from Us periodically and as and when required. We may communicate with you by email or by such other mode of communication, electronic or otherwise.
Investor Alert:
BP Equities Pvt Ltd – SEBI Regn No: INZ000176539 (BSE/NSE), INZ000030431 (MCX/NCDEX), IN-DP-CDSL-183-2002 (CDSL),
INH000000974 (Research Analyst) CIN: U45200MH1994PTC081564
BP Comtrade Pvt Ltd – SEBI Regn No: INZ000030431 CIN: U45200MH1994PTC081564
For complaints, send email on investor@bpwealth.com
