Example Data Table
| Input | Example Value | Purpose |
|---|---|---|
| Starting Free Cash Flow | 500 | Base cash flow for year one projection. |
| Forecast Years | 5 | Detailed forecast period. |
| Annual Growth Rate | 8% | Expected yearly free cash flow increase. |
| Discount Rate | 10% | Required return or capital cost. |
| Terminal Growth Rate | 3% | Long-term cash flow growth after forecast. |
| Cash / Debt | 150 / 300 | Adjusts enterprise value into equity value. |
| Shares / Price | 100 / 42 | Finds per share value and upside. |
Formula Used
Projected Free Cash Flow: FCF year n = Starting FCF × (1 + Growth Rate)n
Present Value: PV = Projected FCF ÷ (1 + Discount Rate)n
Terminal Value: TV = Final Year FCF × (1 + Terminal Growth) ÷ (Discount Rate − Terminal Growth)
Enterprise Value: EV = Sum of PV Forecast Cash Flows + PV of Terminal Value
Equity Value: Equity Value = Enterprise Value + Cash − Debt
Intrinsic Value Per Share: Equity Value ÷ Diluted Shares Outstanding
Safety Buy Price: Intrinsic Value Per Share × (1 − Margin of Safety)
How to Use This Calculator
- Enter the company name, ticker, and currency label.
- Add current free cash flow using one consistent unit.
- Choose forecast years and expected annual growth.
- Enter a discount rate that reflects risk.
- Use a terminal growth rate below the discount rate.
- Add cash, debt, diluted shares, and current share price.
- Choose a margin of safety for your target buy price.
- Press calculate, then download CSV or PDF when needed.
Advanced Stock Valuation Overview
A discounted cash flow model helps investors value a stock from expected future free cash flow. It does not chase headlines. It studies the cash a business may create, then discounts that money back to present value. This calculator adds practical stock inputs, including debt, cash, shares, market price, and margin of safety. The result is an estimate, not a promise. It is strongest when your assumptions are realistic.
Why Cash Flow Matters
Earnings can be affected by accounting choices. Free cash flow is often more useful for valuation because it shows cash left after capital spending. A company with steady cash flow can fund growth, reduce debt, or return money to owners. This tool starts with current free cash flow and projects it over a chosen forecast period. Each projected year uses the growth rate you enter.
Discount Rate and Risk
Money expected in the future is worth less than money held today. The discount rate handles that idea. It can represent the investor return requirement or the company cost of capital. A higher discount rate lowers the present value. It also reflects more uncertainty. For stable firms, investors may choose a lower rate. For cyclical or risky firms, a higher rate may be reasonable.
Terminal Value Role
Most company value often comes from cash flows after the forecast period. The terminal value estimates that continuing value. This calculator uses the Gordon growth method. The terminal growth rate should stay below the discount rate. Conservative terminal assumptions are important. Small changes can move the final share value a lot.
Interpreting the Output
The calculator shows enterprise value, equity value, intrinsic value per share, safety price, and upside. Enterprise value comes from operating cash flows. Equity value adjusts that number for cash and debt. The intrinsic value per share divides equity value by diluted shares. Compare this number with the current market price. If intrinsic value is higher, the stock may deserve review. If it is lower, the stock may be expensive. Always compare the model with business quality, balance sheet strength, competition, and management history before making decisions. Use several cases, including base, bear, and bull views, before trusting any single figure too strongly today.
FAQs
What is a discounted cash flow stock calculator?
It estimates a stock value by forecasting free cash flow, discounting it to today, adding terminal value, and dividing equity value by shares outstanding.
Which cash flow should I enter?
Use free cash flow, not revenue. Many investors use trailing twelve month free cash flow or a normalized average from several years.
Why must terminal growth be below the discount rate?
The Gordon growth formula needs the discount rate to exceed terminal growth. If not, the terminal value becomes unrealistic or mathematically invalid.
What does discount rate mean?
It represents required return, risk, or cost of capital. Higher risk usually needs a higher discount rate, which lowers estimated value.
What is margin of safety?
Margin of safety reduces the estimated fair value to create a more cautious buy price. It helps protect against weak assumptions.
Should I use mid-year convention?
Use it when cash flows arrive throughout the year instead of only at year end. It usually raises present value slightly.
Are the inputs in millions or dollars?
You may use either. Keep free cash flow, cash, debt, and shares in the same unit so per share value stays correct.
Can this calculator guarantee stock returns?
No. It is a valuation model based on assumptions. Always review financial statements, competitive position, debt, and market conditions separately.