How to use this calculator
- Enter Initial investment ($)。
- Enter Discount rate (%)。
- Enter Year 1 cash flow ($)。
- Enter Year 2 cash flow ($)。
- Enter Year 3 cash flow ($)。
- Enter Year 4 cash flow ($)。
- 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
| Variable | Inputs | Unit |
|---|---|---|
initialInvestment | Initial investment | $ |
discountRate | Discount rate | % |
cfYear1 | Year 1 cash flow | $ |
cfYear2 | Year 2 cash flow | $ |
cfYear3 | Year 3 cash flow | $ |
cfYear4 | Year 4 cash flow | $ |
cfYear5 | Year 5 cash flow | $ |
npv | Net present value | $ |
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) - initialInvestmentThe relationship is solved in every direction, so any one unknown field can be derived.
Worked example
Using the default inputs:
- Initial investment = 500000 $
- Discount rate = 10 %
- Year 1 cash flow = 120000 $
- Year 2 cash flow = 150000 $
- Year 3 cash flow = 180000 $
- Year 4 cash flow = 200000 $
- Year 5 cash flow = 260000 $
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:
- Net present value = 166,336.75 $
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
- 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.
- Good for: getting a directionally correct order of magnitude quickly, or comparing two scenarios.
- Not good for: 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.