Discounted Cash Flow (DCF) Calculator

Calculate the intrinsic value of an investment or firm based on forecasted cash flows

Beginner Friendly
Downloadable Guide

Calculate DCF Valuation

Enter the base cash flow, growth rate, discount rate, terminal growth rate, shares outstanding, and net debt (for FCFF) to forecast cash flows and estimate the intrinsic value. All monetary values should be in Ghanaian Cedi (GHS). Example: Use base FCFF or FCFE data from Access Bank Ghana (174 million shares).

DCF Formula

DCF = Σ (Cash Flowₜ / (1 + Discount Rate)ᵗ) + Terminal Value / (1 + Discount Rate)ⁿ

Where Cash Flowₜ = Base Cash Flow × (1 + Growth Rate)^t for each year, Terminal Value = (Final Year Cash Flow × (1 + Terminal Growth Rate)) / (Discount Rate - Terminal Growth Rate). For FCFF: Equity Value = DCF - Net Debt, Per-share value = Equity Value ÷ Shares Outstanding. For FCFE: Per-share value = DCF ÷ Shares Outstanding.

Select FCFE for equity valuation or FCFF for firm valuation. FCFF requires net debt input.
Number of years for cash flow projections (1-10).
Current or Year 0 cash flow (e.g., FCFE or FCFF from financial statements).
Annual growth rate for forecasting cash flows (e.g., 5%).
Rate to discount future cash flows (e.g., WACC for FCFF or required return for FCFE, typically 5-12%).
Perpetual growth rate for cash flows after the forecast period (typically 1-3%).
Total number of shares outstanding in millions (e.g., 174 for Access Bank Ghana).

Understanding DCF Valuation

Discounted Cash Flow (DCF) valuation estimates the intrinsic value of an investment (FCFE) or firm (FCFF) by forecasting and discounting projected future cash flows to their present value. FCFF valuations require subtracting net debt to derive equity value.

Intrinsic Value

Assess True Worth

DCF calculates the present value of forecasted future cash flows, reflecting the investment’s or firm’s true value.

Accurate Inputs

Critical for Results

Use reliable base cash flow, growth rates, discount and terminal growth rates, and net debt (for FCFF).

How to Use the DCF Calculator

  1. Select Cash Flow Type

    Choose FCFE for equity valuation or FCFF for firm valuation. FCFF valuations include an additional step to subtract net debt to calculate equity value.

  2. Select Forecast Period

    Choose the number of years (1–10) for which to project future cash flows.

  3. Enter Base Cash Flow and Growth Rate

    Input the current (Year 0) cash flow (FCFE or FCFF) and the annual growth rate (%). The calculator will automatically forecast cash flows for each year using the formula: Cash Flowₜ = Base Cash Flow × (1 + Growth Rate)ᵗ. For example, a base cash flow of GHS 250M with a 5% growth rate will generate Year 1 cash flow of GHS 262.5M, Year 2 of GHS 275.625M, etc.

  4. Enter Discount Rate

    Input the discount rate (%) to calculate the present value of future cash flows. Use the Weighted Average Cost of Capital (WACC) for FCFF (typically 5–12%) or the cost of equity for FCFE (e.g., via CAPM). You can calculate this using the Cost of Equity Calculator or source it from financial websites like Yahoo Finance.

  5. Enter Terminal Growth Rate

    Input the perpetual growth rate (%) for cash flows after the forecast period (typically 1–3%), based on long-term GDP or industry growth rates.

  6. Enter Shares Outstanding

    Input the total number of shares outstanding in millions (e.g., 174 for Access Bank Ghana) to calculate the intrinsic value per share.

  7. Enter Net Debt (for FCFF)

    For FCFF valuations, input net debt (total debt minus cash and cash equivalents) from the company’s balance sheet, sourced from financial websites like Yahoo Finance or gse.com.gh.

  8. Calculate and Review

    Click “Calculate” to forecast cash flows, compute the DCF value (enterprise value for FCFF or equity value for FCFE), and determine the per-share value. Review the results table to see forecasted cash flows and their present values. Compare the intrinsic value per share with the current share price to assess investment opportunities.

Key Applications of DCF

  • Valuing companies or investments based on forecasted future cash flows
  • Assessing intrinsic value for stock investments
  • Comparing investment opportunities
  • Estimating per-share value by dividing equity value (FCFF) or total DCF (FCFE) by shares outstanding