Note: If you already have Free Cash Flow (FCF) values, you can skip the first table and directly enter FCF in the second table. Basic arithmetic operations (+, -, *, /) work inside the cells.
Intrinsic Value Calculation | |
---|---|
Sum of Present Values | - |
Cash & Cash Equivalent | |
Total Debt | |
Total Intrinsic Value | - |
Number of Outstanding Shares | |
Intrinsic Value Per Share | - |
Margin of Safety (%) | |
Buy Price (with Margin of Safety) | - |
A Discounted Cash Flow (DCF) is a valuation methodology used to estimate a company’s intrinsic value by calculating the present value of its projected future cash flows. It determines the present value of projected future cash flows by applying a discount rate that accounts for:
The fundamental principle behind DCF is that a dollar today is worth more than a dollar in the future due to:
Present Value = Future Cash Flow / (1 + Discount Rate)^n
Where:
PV of FCF = FCFYear n / (1 + r)n
Where:
Terminal Value = FCFLast Year × (1 + g) / (r - g)
Where:
PV of Terminal Value = Terminal Value / (1 + r)n
Where:
Intrinsic Value = Σ(PV of FCFs) + PV of Terminal Value + Cash - Debt
Price Per Share = Intrinsic Value / Number of Shares Outstanding
Note: All projected cash flows are discounted to present value using the discount rate (r) to account for the time value of money and risk.
DCF analysis helps investors:
Enter the years that you want to input cash flow for. For example:
The first table shows historical data and is calculated as follows:
Example input and results:
This will generate cash flows for 10 future years:
Note: If you want to use single growth rate, enter values for Stage 1 only
The calculator uses a two-stage growth model for future projections.
If you enter:
Then:
If you enter:
Then:
If your last historical FCF (2025) is $1,000:
Stage 1 (15% growth):
A: The DCF (Discounted Cash Flow) Calculator helps you estimate the intrinsic value of a company by projecting its future cash flows and discounting them back to their present value. It's a widely used valuation method in finance.
A: The DCF Calculator helps you determine whether a stock is overvalued or undervalued, allowing you to make informed investment decisions based on the company's fundamentals.
A: You need:
A: Enter the Operating Cash Flow (OCF) and Capital Expenditures (CapEx) for each year. The calculator automatically computes Free Cash Flow (FCF) as:
FCF = OCF − CapEx
A:
A: The terminal growth rate is the long-term sustainable growth rate (usually 2-3%). It's used to calculate the company's value beyond the projection period.
A: Consider these factors:
Typical range: 8-12%
A: Common reasons include:
A: The DCF model: