Discover how to calculate an investment's net present value (NPV) using the discount factor method, a vital skill for anyone considering a career in finance or investment. This method takes into account factors like inflation, providing a more realistic view of an investment's future worth.
Key Insights
- The discount factor is used to determine the present value of an investment's future worth.
- The discount factor typically has a value between zero and one, influenced by factors such as inflation.
- Through the application of the discount factor to Free Cash Flow (FCF) and Terminal Value (TV), one can calculate Enterprise Value.
- The formula to calculate the discount factor is: =1/(1+$C$4)^C8.
- The calculation of discounted FCF and TV is performed with this formula: =C24*SUM(C22:C23).
- The Enterprise Value is calculated by summing up the discounted FCF and TV with the formula: =SUM(C25:H25).
Valuation Methods
-
DCF
Project free cash flows, discount at WACC.
-
Comparable Companies
EV/EBITDA, P/E from public peers.
-
Precedent Transactions
Multiples from recent M&A in the industry.
-
LBO Analysis
What sponsor could pay and hit return targets.
To calculate an investment’s net present value (NPV), you must first determine its discount factor. In other words, the discount factor measures the present value of an investment’s future worth.
Any discount factor equation uses the assumption that today’s money will be worth less in the future due to factors like inflation, which gives the discount factor a value between zero and one.
Here’s how by using discount factor and applying it to FCF and TV you can calculate Enterprise Value:
Let’s calculate discount factor in our example: =1/(1+$C$4)^C8
And then discounted FCF and TV: =C24*SUM(C22:C23)
And sum it up to calculate Enterprise Value: =SUM(C25:H25)
