Saved

Press the star next to a tool's name to save it.

All my tools

DCF Calculator

Use this DCF calculator to discount yearly cash flows to today, add a terminal value and find the net present value of a project, investment or business.

Restored your last values ·

%

Enter one cash flow for each year, starting with year 1, separated by spaces or new lines. Negative flows are fine. Add a terminal value for everything after the last year, and an initial investment to see the net present value.

Everything is worked out in your browser. Nothing you type is sent anywhere.

–

–

Fill in the boxes and press Calculate.

A DCF calculator values an investment, project or business by discounting its expected future cash flows back to today. Enter a discount rate and the cash flow you expect in each year. The calculator works out the present value of each year's cash flow and adds them up. You can add a terminal value for the years after your forecast, and an initial investment to see the net present value.

The DCF formula

DCF value = CF₁ ÷ (1 + r)¹ + CF₂ ÷ (1 + r)² + … + CFₙ ÷ (1 + r)ⁿ
Net present value = DCF value − initial investment

OpenStax's Principles of Finance gives this formula, where CF is the estimated cash flow in each year and r is the discount rate or required rate of return. Each future amount is divided by one plus the rate, raised to the number of years until it arrives, because money received later is worth less than money today. When cash flows are expected to keep growing beyond the forecast, the total value is the sum of the discounted cash flows for the forecast years and a terminal value.

How to use the DCF calculator

  1. Enter the discount rate as a percentage, the return you require for the risk.
  2. Enter the cash flows for each year, starting with year 1, separated by spaces or on separate lines.
  3. Optionally enter a terminal value, the value of all cash flows after the last year, as at the end of that year.
  4. Optionally enter the initial investment to see the net present value.
  5. Press Calculate.

Worked example

A project is expected to produce $1,000, $1,200, $1,400, $1,600 and $1,800 over the next five years, and the required return is 10 percent. The present values are $909.09, $991.74, $1,051.84, $1,092.82 and $1,117.66, which add up to $5,163.15. If the project costs $5,000 today, its net present value is $163.15: it earns slightly more than the 10 percent required. If the business were expected to be worth $20,000 at the end of year 5, that terminal value adds $20,000 ÷ 1.1⁵ = $12,418.43 in today's money.

Choosing the discount rate

The discount rate reflects how risky the cash flows are and what else the money could earn. For a whole company, analysts often use the weighted average cost of capital; for an investment funded by shareholders alone, the cost of equity. A higher rate lowers the value, and because later cash flows are discounted more heavily, the rate matters most for long forecasts and large terminal values. Try the WACC calculator and the CAPM calculator to estimate a rate.

Forecasting the cash flows

The cash flows should be the money the investment actually produces each year after running costs and any further investment it needs. Optimistic forecasts are the most common source of error in DCF valuations. It helps to build a cautious, a central and a hopeful set of figures and run all three through the calculator, so you see the range of values rather than one precise-looking number.

The terminal value

For a business expected to keep operating, the cash flows after the forecast years are often worth more than the forecast years themselves. Analysts usually estimate a terminal value from a steady growth rate or from what similar businesses sell for. Enter it as a single amount at the end of the final forecast year; the calculator discounts it back with the same rate. Because it can dominate the result, test how sensitive the value is to different terminal assumptions.

DCF, NPV and IRR

The net present value shown here answers whether an investment beats the required return: positive means yes. The internal rate of return is the discount rate at which the net present value is exactly zero; the IRR calculator finds it. For a single future amount, the present value calculator is quicker.

Uneven and negative cash flows

Real projects rarely produce smooth cash flows. A project might need extra spending in its second year, giving a negative cash flow, before paying back later. Enter negative figures with a minus sign and the calculator discounts them in the same way, reducing the total value. Because later amounts are discounted more, spending that can be delayed costs less in present value terms, while income that arrives sooner is worth more. Comparing two versions of a plan in the calculator, one with income earlier and one later, shows how much timing alone is worth.

Sensitivity to the discount rate

Changing the rate from 10 to 12 percent lowers the value of the five-year example to about $4,884, while lowering it to 8 percent raises the value to about $5,467. Running the calculator at a few rates shows how much of the value depends on that single assumption.

Common mistakes

  • Starting at year 0. The first figure you enter is discounted one full year.
  • Mixing nominal and real figures. Use a rate that matches how the cash flows are measured.
  • Using profit instead of cash flow. DCF needs cash actually received.

Worked example with a terminal value and an investment

Use the same five cash flows at 10 percent, but this time fill in both optional boxes: a terminal value of 20,000 and an initial investment of 5,000. The calculator shows:

  • Present value of the cash flows: $5,163.15
  • Present value of the terminal value: $12,418.43
  • Present value (DCF value): $17,581.57
  • Net present value after the investment: $12,581.57

The terminal value supplies about 70 percent of the total, which is common for a business that keeps going. That is why it deserves the most care. The DCF value here is a cent less than the sum of the two rounded figures above, because the calculator adds the unrounded amounts. If you change the terminal value, only the second line and the totals move: the present value of the five forecast years stays the same.

What next

Use this often? Add DCF to your Home screen.

Frequently asked questions

How does a DCF calculator work?

It divides each year's cash flow by one plus the discount rate raised to that year's number, then adds the results.

What is the DCF value of $1,000 to $1,800 over five years at 10%?

$5,163.15 for cash flows of $1,000, $1,200, $1,400, $1,600 and $1,800.

What discount rate should I use?

One that reflects the risk, often the WACC for a whole business or the cost of equity for shareholders.

What is a terminal value?

The value of all cash flows after the forecast years, as at the end of the last year. The calculator discounts it back to today.

What does a positive NPV mean?

The investment is expected to earn more than the discount rate.

What went wrong?

We only receive the reason you pick, never what you typed into the tool.

Thanks for your feedback.

More Finance Tools