Discounted Cash Flow Analysis – How to Do It Correctly?

thumbnail
Reading Time: 4 minutes

Article Source link | Facebook Profile

Discounted cash flow

Discounted cash flow is a method of analyzing a company by forecasting its cash flows and discounting the cash flows to arrive at a present value.

It estimates the company’s intrinsic value based on future cash flow. The idea behind the DCF model is that the value of the company is not a function of demand and supply of the stock.

Instead, the value of the company is a function of the ability to generate future cash flow for its shareholders.

 

BASICS OF DISCOUNTED CASH FLOW MODEL

The discounted cash flow method is based on the concept of the time value of money which means, the present value of money is worth more than the same amount in the future.

For example, if you have ten lakhs as a cash balance in your hand that will be worth more than one year later due to interest accrual and inflation.

If an investor is ready to invest one lakh now, he wants to know the return on investment and what its future valuation will be, which can be calculated through the DCF model.

Also Read on FinMedium:  Sterlite Tech 2020 Annual Report Takeaways!

 

HOW TO CALCULATE IT CORRECTLY?

The DCF formula is as follows

DCF = CF1/ (1+R) ^ 2 + CF2 / (1+R) ^2 +… + CFn / (1+R) ^ n

Where

CF = Cash Flow for the upcoming years

R = It denotes the discount rate. (It’s the rate which investors expect to receive on average from a company for financing its assets). In business, it’s Weighted Average Cost of Capital (WACC)

N = denotes the final year

 

For example, Mr. Bhavesh plans to make an investment of ten lakhs in business for a tenure of five years. The WACC of the business is 7%

The estimated cash flow of the business are mentioned below:

YEAR CASH FLOW
1 200000
2 250000
3 175000
4 325000
5 400000

Based on the formula

DCF = [200000/(1+0.07)^1 ] + [250000/(1+0.07)^2] + [175000/(1+0.07)^3] + [325000/(1+0.07)^4 ] + [400000/(1+0.07)^5]

 

YEAR CASH FLOW DCF
1 200000 1,86,915
2 250000 2,18,359
3 175000 1,42,857
4 325000 2,47,959
5 400000 2,85,204

The total discounted cash flow valuation will be 10, 81294. When deducting from the initial investment of ten lakhs, the Net Present Value will be 81,294.

As the NPV is a positive number, Mr. Bhavesh’s investment in the business is attractive.

In case, if he had invested eleven lakh, he would have incurred a loss of 18706 as the NPV would have been negative.

Also Read on FinMedium:  Orient Carbon OCCL Business Analysis

Let us simplify the discounted cash flow techniques, here we will discuss, how to calculate the future value of your investment and present value of that investment.

Assume an individual invests a business for Rs. 15000 in a three year time period at the rate of return will be 8% per annum. Calculate the future value of our investment

FV = PV* (1+R) ^n

Where

FV => Future Value

PV => Present Value

R = > Rate of Return

N => Number of years

 

So what’s our future value of the investment? 

That will be 18895 in three years.  Come to the next scenario company offered you Rs. 15000 in a three years period and they asked how much you are willing to pay for the offer.

To answer this question, we must understand the discounted cash flow model. For a single transaction, we can calculate from the future value formula:

 

PV = FV/ (1+R) ^n 

*here R is the discounted rate or expected rate of return

 

For the above example we take, two different investors expected return

 

FUTURE VALUE EXPECTED RETURN PRESENT VALUE
15000 16% 9610
15000 8% 11907

It’s not a big deal to reach 15000 in three years but how much return investors are expecting.

Also Read on FinMedium:  Is Coromandel International The Best Agriculture Stock in India? - Part 2

If investors looking for high returns (16%) and they believe that the asset has the ability to generate this type of return. They should only offer Rs. 9610 to the business.

 

Also Watch: How to Value a Company Using Discounted Cash Flow Model

 

CONCLUSION

  • If anyone wants to buy a stock or buying a business for that you need to project the expected future cash flows.
  • If our investment is priced below the sum of discounted cash flows, it depicts the undervalue of the stock, and therefore, it’s an attractive investment for the investors.
  • On the other hand, some of the discounted cash flow is high, the assets may be overvalued or our assumption may be wrong.
  • This model is suitable for companies that are larger with relatively steady growth.
  • DCF analysis is useful for mergers and acquisitions.

Read the research and analysis of Indian Companies here.

 

Article Source link | Facebook Profile

Cover Image: Hook Agency

Every Wednesday and Saturday, we send Info-Graphic and FinMedium Weekly Digest newsletters to our 25000+ Subscribers.

Join Them Now!

Please Share :)
Fincare Plan
Fincareplan provides an advisory of financial, investment planning on equity shares, and mutual funds practically.
Back To Top