Discount Factor
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.
Noble Desktop's Financial Analyst Training Program covers financial modeling, valuation, accounting, and Excel for finance.
Dive into the process of calculating an investment's net present value by determining its discount factor and applying it to Free Cash Flow and Terminal Value to compute Enterprise Value.
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)
