Enter values to see detailed analysis and insights.
How to Use
- 1Enter the initial investment amount
- 2Input your discount rate (required return or cost of capital)
- 3Add expected cash flows for each year (Years 1-5)
- 4Review the NPV - positive means accept, negative means reject
- 5Higher NPV indicates more value creation
Net Present Value (NPV)
NPV = Σ [CFt ÷ (1 + r)^t] - Initial InvestmentVariables:
CF tCash flow in period trDiscount rate (required return)tTime period (year)ΣSum of all periodsExample
Inputs:
Steps:
- 1.PV Year 1: $30,000 ÷ (1.10)¹ = $27,273
- 2.PV Year 2: $35,000 ÷ (1.10)² = $28,926
- 3.PV Year 3: $40,000 ÷ (1.10)³ = $30,053
- 4.PV Year 4: $45,000 ÷ (1.10)⁴ = $30,754
- 5.PV Year 5: $50,000 ÷ (1.10)⁵ = $31,046
- 6.Total PV = $148,052
- 7.NPV = $148,052 - $100,000 = $48,052
