Format Code Now
/
Calculators & unitsDiscounted Cash Flow Calculator Next: Dividend Calculator ›

Discounted Cash Flow Calculator

CU-54

Type your expected cash flows and a discount rate, and the calculator gives their present value today and the net present value after any up-front investment. Add a terminal value if the cash flows continue past the last year.

Runs in your browser. Nothing is uploaded.

Inputs

%
%
x

Result

Net present value (NPV)48,032.61
Present value of cash flows148,032.61
Initial investment100,000.00
Total of cash flows, not discounted200,000.00
Years covered1 to 5 (5 cash flows)

Discounting table (CSV)

Item,Year,Amount,Discount factor,Present value
Initial investment,0,-100000.00,1.000000,-100000.00
Cash flow,1,30000.00,0.909091,27272.73
Cash flow,2,35000.00,0.826446,28925.62
Cash flow,3,40000.00,0.751315,30052.59
Cash flow,4,45000.00,0.683013,30735.61
Cash flow,5,50000.00,0.620921,31046.07

How to use it

  1. Enter the cash flows as a comma list such as 30000, 35000, 40000, or as year rows such as 1: 30000.
  2. Set the discount rate and, if you have one, the initial investment made at year 0.
  3. Choose a terminal value method: none, perpetual growth, an exit multiple, or an amount you type.
  4. Read the net present value and copy or download the discounting table as CSV.

How the discounting works

Each cash flow is divided by (1 + r) raised to its year, where r is the discount rate, and the results are added up. Cash flows are treated as arriving at the end of each year, so the first number in a plain list is year 1. If you need a different timing, write year rows such as 0: -5000, 1: 1200, 3: 2500. A bare number takes the next whole year after the previous entry. An initial investment is subtracted at year 0, with no discounting.

Terminal value options

The terminal value stands in for everything after the last listed year. Perpetual growth uses the last cash flow x (1 + g) / (r - g) and needs g to be lower than r. The exit multiple option multiplies the last cash flow by a number you choose. The amount option takes a figure you have worked out elsewhere. Whichever you pick is discounted from the last year you listed, and the results show how much of the total value comes from it.

A worked example

Three cash flows of 100 at a 10 percent discount rate are worth 90.91 + 82.64 + 75.13 = 248.69 today. Subtract an initial investment of 200 and the net present value is 48.69. Add a perpetual growth terminal value at 2 percent: 100 x 1.02 / 0.08 = 1,275 at year 3, which is worth 957.93 today, so the NPV with the 200 investment becomes 1,006.61.

Error messages and what to do

MessageWhat it meansFix
Terminal growth rate must be lower than the discount rate.The perpetual growth formula divides by the discount rate minus the growth rate, which must stay above zero.Lower the growth rate or raise the discount rate.
Year 1 appears twice. Give each year one cash flow.Two entries use the same year.Add the two amounts together or change one year.
Enter a number for Discount rate.The discount rate box is empty or not a number.Type the rate as a percentage, for example 10.

Questions people ask

What is a discounted cash flow?

It is the value today of money you expect to receive later. Each future amount is shrunk by the discount rate for every year you wait, so a payment further away counts for less than one nearer.

What discount rate should I use?

Use the return you could expect from another investment of similar risk, or a company cost of capital if you have one. The rate is your choice and it moves the answer a lot, so try a few values to see the range.

Can I enter negative cash flows?

Yes. A negative value is an outflow, such as a year of extra spending, and it lowers the result. Put an up-front cost in the initial investment box, or enter it as a year 0 row.

Are cash flows taken at the start or end of the year?

At the end. A cash flow in year 1 is divided by (1 + r) once. If your flows arrive earlier in the year, use year rows with fractional years such as 0.5 to place them.

Does it include taxes or inflation?

Only if your figures do. The calculator discounts exactly the numbers you type, so enter after-tax cash flows and choose a discount rate that matches how you treat inflation.

About this tool

Each cash flow is divided by (1 + r) to the power of its year, where r is the discount rate, and the results are added. Cash flows are treated as received at the end of each year, so the first value in a plain list is year 1. To place flows yourself, write year rows such as 0: -5000, 1: 1200, 3: 2500; a bare number takes the next whole year. An initial investment is taken off at year 0. A terminal value is discounted from the last year you list. With the perpetual growth method it is the last cash flow x (1 + g) / (r - g), which needs g below r. Results ignore taxes and inflation unless your figures already include them, and a model is only as good as the forecast you type. Results are estimates for learning and planning, not investment advice.

Format Code Now: free, no ads, no accounts. Your input stays in your browser.