Saturday, April 19, 2008

How to calculate discounted cash flow (DCF)

Suppose I offered to give you either $1000 in June 2006 or $150 every June for the next 10 years, starting in 2007. Which offer is worth more? How would you figure this out? The answer is: by calculating discounted cash flows.

Discounted Cash Flow or DCF analysis is one of the first things taught in finance class in an MBA program. It’s a natural consequence of the time value of money, which states essentially that a dollar today is not worth the same as a dollar in the future. Discounted Cash Flow analysis is most commonly used to value a project or company (or lottery payout, as in the simple example above) using a discount rate or weighted average cost of capital, also abbreviated as WACC. (Did I forget to mention finance is big on acronyms?)


Determining an appropriate discount rate or WACC can get complicated, so for now, we’ll just simplify it and call it a percentage rate that we use to “discount” future cash flows to the present. For example, if you earned $100 every year, you can imagine that the $100 you earn 10 years from now won’t be worth the same as the $100 you earn this year. Inflation, the return you could be getting on the $100 during that time, risk, all sorts of aspects can play into evaluating what $100 in 2016 is worth in 2006.

If you’re working in corporate finance, chances are Treasury or some other official department has dictated an “official” cost of capital to use in your analysis. On this site, when I calculate Experiments in Finance’s NPV each month, I choose to use an annual rate of 5% as my discount rate, remembering to change this to its the monthly equivalent rate since I’m calculating monthly cash flows. My reasoning is that the cash flows for this project aren’t large, and a comparable activity of similar risk might be to put the money in a saving’s account instead. This is one of those situations where finance is more like art than science. You could argue ’til you were blue in the face about what the “right” cost of capital to use should be, but in the end it may not matter too much, especially if you conduct a sensitivity analysis using different rates.

Let’s get back to talking about DCFs. Discounted cash flow analysis essentially takes the cash flows for each period and discounts them back to the current moment. So, suppose we have cash flows of $100 starting next year for the next 10 years, and our discount rate is 8%. Then what we’re calculating looks like the following: DCF = $100/(1+0.08) + $100/(1+0.08)2 + $100/(1+0.08)3 + … + $100/(1+0.08)10

(In this particular case, we’ve set a constant $100 per year as our cash flow. If we were receiving different amounts each year instead, say, $100 every year, except for $150 in year 2 and $1000 in year 10, then we’d simply plug in those amounts instead in their respective years.)

What you’re doing is essentially “bringing back” the future cash flow to the present time, using the discount rate of 8%. This means that the value of receiving $100 every year for 10 years isn’t $1000 but $671. In fact, receiving $100 at the end of this year isn’t the same as having the cash in your at the beginning of the year. It’s worth $100 less the amount you would have earned in interest had you had it at the beginning of the year. And the $100 you earn two years from now is worth $100 less the amount you would have earned in compound interest over the two years. And so on. This is why wise articles about how much you need to save for retirement often result in seemingly large amounts.

Getting back to our original example, it turns out that if you assume a discount rate (which might represent the constant interest rate you can earn on your money) of 8%, then having $1000 in your pocket now versus having $150 for the next 10 years is the same. But if you assume that you can only earn 5%, then the stream of income is a better deal ($130 per year is the breakeven).

Discounted cash flow analysis is the basis of many things in finance, including Net Present Value or NPV, bond prices, annuity pricing, and many more. NPV and DCF calculations are one of the most frequently used finance tools for valuation purposes. But, like everything else, they have their limitations and are simply tools. If your numbers aren’t accurate to begin with, adding and dividing them will only result in a worse answer. DCFs and NPVs are also pretty inflexible. If future earnings and cash flows are very uncertain, or management has the option of changing a project midway through, then this type of analysis may not be the best way to go. In those cases, Real options or Monte Carlo might be more complex but better tools to use. Taken from www.experiglot.com where you can find MORE

The three key questions in company valuation can all be answered using discounted cash flow methods.
Value:
How much is a company worth today, based on what it will earn in the future? The company's predicted cash flows (or earnings) are discounted to give a present value.

Rate of return:
What is an investor's expected rate of return, given the amount invested and the company's financial projections? Investors will calculate their rate of return by: discounting the cash flow and the value they will take out of the company; and comparing this amount to what they invested at the beginning.

Equity share:
How much equity will the investor receive for the investment? Dividing the investment by the value of the company will give the percentage of ownership shares the investor will get. But first you need to know the value.
Continue to read on Here

2 comments:

vinod said...

Building on the movement that elected President Obama by empowering communities across the country to bring about an agenda of change.clickhere to know more details about OBAMA

Anonymous said...

Thanks for the helpful post on dcf analysis and modeling. It's helping me work through some models!