NPV with Irregular Cash Flows

Enter Initial investment, Discount rate, Year 1 cash flow, Year 2 cash flow, Year 3 cash flow, Year 4 cash flow and Year 5 cash flow to get Net present value — or leave any field blank to solve for it.

The result is —

Inputs

Results

Net present value ($) —

Fill in enough known values and the rest are solved automatically.

Quick answer: With Initial investment = 500,000 $, Discount rate = 10 % and Year 1 cash flow = 120,000 $, Net present value is 166,337 $.

How to use this calculator

  1. Enter Initial investment ($)。
  2. Enter Discount rate (%)。
  3. Enter Year 1 cash flow ($)。
  4. Enter Year 2 cash flow ($)。
  5. Enter Year 3 cash flow ($)。
  6. Enter Year 4 cash flow ($)。
  7. Enter Year 5 cash flow ($)。

Leave any field blank and the calculator solves for it from the remaining values — every quantity is reversible.

The calculator then returns: Net present value。

What is it

NPV with Irregular Cash Flows — Enter Initial investment, Discount rate, Year 1 cash flow, Year 2 cash flow, Year 3 cash flow, Year 4 cash flow and Year 5 cash flow to get Net present value — or leave any field blank to solve for it. Business and operations calculators convert cost, price, volume and efficiency data into profit, break-even points and utilisation rates. The core question it answers is: Net present value. With Initial investment = 500,000 $, Discount rate = 10 % and Year 1 cash flow = 120,000 $, Net present value is 166,337 $.

Formula

VariableInputsUnit
initialInvestmentInitial investment$
discountRateDiscount rate%
cfYear1Year 1 cash flow$
cfYear2Year 2 cash flow$
cfYear3Year 3 cash flow$
cfYear4Year 4 cash flow$
cfYear5Year 5 cash flow$
npvNet present value$
Net present valuecfYear1/(1+discountRate/100) + cfYear2/Math.pow(1+discountRate/100,2) + cfYear3/Math.pow(1+discountRate/100,3) + cfYear4/Math.pow(1+discountRate/100,4) + cfYear5/Math.pow(1+discountRate/100,5) - initialInvestment

The relationship is solved in every direction, so any one unknown field can be derived.

Worked example

Using the default inputs:

Formula used: cfYear1/(1+discountRate/100) + cfYear2/Math.pow(1+discountRate/100,2) + cfYear3/Math.pow(1+discountRate/100,3) + cfYear4/Math.pow(1+discountRate/100,4) + cfYear5/Math.pow(1+discountRate/100,5) - initialInvestment

Answer:

Example 1 (default inputs):Suppose Initial investment = 500,000 $, Discount rate = 10 %, Year 1 cash flow = 120,000 $, Year 2 cash flow = 150,000 $, Year 3 cash flow = 180,000 $, Year 4 cash flow = 200,000 $, Year 5 cash flow = 260,000 $; then giving Net present value = 166,337 $.

Example 2 (one input changed):If you change Initial investment to 375,000,giving Net present value = 291,337 $.

Additional information

Assumptions and limitations

Back to category:Business & Ratios

FAQ

What is NPV with Irregular Cash Flows?

With Initial investment = 500,000 $, Discount rate = 10 % and Year 1 cash flow = 120,000 $, Net present value is 166,337 $.

How do I use the NPV with Irregular Cash Flows?

Enter values for Initial investment, Discount rate, Year 1 cash flow, Year 2 cash flow, Year 3 cash flow, Year 4 cash flow, Year 5 cash flow; the tool instantly computes Net present value.

When should I use the NPV with Irregular Cash Flows?

Enter Initial investment, Discount rate, Year 1 cash flow, Year 2 cash flow, Year 3 cash flow, Year 4 cash flow and Year 5 cash flow to get Net present value — or leave any field blank to solve for it. Use it whenever you need a quick estimate for planning or comparing options. Results are for reference only.

How accurate is this calculator?

The number is the exact solution of the standard formula for your inputs, with no error beyond rounding. How well it matches reality depends on the model's assumptions. These models assume unit variable cost and price stay stable over the relevant range; scale effects, tiered pricing and seasonality push real results away from the linear estimate.

Can I calculate it backwards?

Yes. This is a multi-directional calculator: fill in every field except one, and the blank one — whether Net present value — is solved automatically.

When should I not use it?

using it as the sole basis for a decision, or for official filings, contract pricing and legal documents — those need a full model with your actual clauses and local rules.