Net Present Value Calculator

Evaluating Investments in Today's Dollars

Net present value (NPV) converts future cash flows into today's dollars, revealing whether an investment truly creates value. The calculator determines if future returns justify upfront costs by accounting for the time value of money—a dollar today is worth more than a dollar tomorrow.

NPV underpins capital budgeting, real estate analysis, and business investment decisions. Positive NPV means an investment exceeds your required return; negative NPV means it doesn't. Understanding this calculation helps make smarter allocation decisions.

Future promises, present reality.

The NPV Formula

NPV = -Initial Investment + Σ [Cash Flow_t / (1 + r)^t]

Where:

• r = discount rate (required return)
• t = time period
• Cash Flow_t = cash flow in period t

The discount rate reflects your opportunity cost—what you could earn elsewhere.

Basic NPV Calculation

Investment: $100,000 upfront Cash flows: $30,000 annually for 5 years Discount rate: 8%

Year 1: $30,000 / 1.08 = $27,778 Year 2: $30,000 / 1.08² = $25,720 Year 3: $30,000 / 1.08³ = $23,815 Year 4: $30,000 / 1.08⁴ = $22,050 Year 5: $30,000 / 1.08⁵ = $20,417

Total present value: $119,780 NPV: $119,780 - $100,000 = $19,780

Positive NPV means the investment exceeds 8% return.

Interpreting NPV Results

NPV > 0: Investment creates value (accept) NPV = 0: Investment meets required return exactly (indifferent) NPV < 0: Investment destroys value (reject)

A $19,780 NPV means you're $19,780 richer in today's dollars than if you'd invested at 8% elsewhere.

Choosing the Discount Rate

The discount rate represents your required return:

Risk-free rate: Treasury bonds (~4-5%) Cost of capital: Company's borrowing cost Opportunity cost: What you'd earn in alternatives Risk-adjusted rate: Higher for riskier projects

Higher discount rates make future cash flows worth less today.

Discount Rate Sensitivity

Same investment, different discount rates:

At 6%: NPV = $26,371 At 8%: NPV = $19,780 At 10%: NPV = $13,724 At 12%: NPV = $8,143 At 15%: NPV = $557

Higher rates dramatically reduce NPV—discount rate choice matters enormously.

Uneven Cash Flows

Most investments don't produce uniform returns:

Initial investment: $75,000 Year 1: $10,000 (ramp-up period) Year 2: $25,000 Year 3: $35,000 Year 4: $30,000 Year 5: $20,000 (declining) Discount rate: 10%

NPV calculation accounts for timing of each distinct cash flow.

NPV vs. IRR

Both evaluate investments differently:

NPV generally preferred for capital budgeting decisions.

Real Estate NPV Example

Rental property analysis:

Purchase price: $300,000 Annual net rental income: $24,000 Hold period: 10 years Expected sale price: $400,000 Discount rate: 7%

Calculate present value of rental income stream plus discounted sale proceeds minus purchase price.

Business Project NPV

Equipment purchase decision:

Equipment cost: $250,000 Annual cost savings: $65,000 Equipment life: 5 years Salvage value: $25,000 Discount rate: 12%

Does the equipment pay for itself at required return?

NPV with Terminal Value

Many analyses include terminal (continuing) value:

Explicit forecast: Years 1-5 cash flows Terminal value: Perpetuity or exit value

Terminal value often represents majority of total NPV—assumptions about future growth matter significantly.

Perpetuity Valuation

For ongoing cash flows:

Terminal Value = Final Cash Flow × (1 + g) / (r - g)

Where g = growth rate

$35,000 growing at 2% with 10% discount: Terminal Value = $35,000 × 1.02 / (0.10 - 0.02) = $446,250

Incremental NPV

For comparing alternatives:

Option A: NPV = $150,000 Option B: NPV = $200,000 Incremental NPV (B vs A): $50,000

Choose option with higher NPV when mutually exclusive.

Scenario Analysis

Test NPV under different assumptions:

Base case: NPV = $50,000 Optimistic (higher revenue): NPV = $120,000 Pessimistic (lower revenue): NPV = -$30,000

Range helps assess investment risk beyond point estimate.

Common NPV Mistakes

Avoid these errors:

Using nominal rates with real cash flows (or vice versa) Ignoring timing differences between cash flows Choosing arbitrary discount rates Forgetting to include all cash flows (working capital, taxes) Discounting already-discounted values

Inflation Considerations

Two approaches:

Real analysis: Real cash flows + real discount rate Nominal analysis: Nominal cash flows + nominal discount rate

Both yield same NPV when done correctly; don't mix approaches.

Using the Calculator

Enter initial investment, periodic cash flows (or uniform amount), discount rate, and time horizon.

The calculator shows:

• Present value of each cash flow
• Total present value of inflows
• Net present value
• Profitability index (NPV / investment)
• Discount rate sensitivity chart

Model scenarios: What discount rate makes NPV zero (IRR)? How do different growth assumptions affect value? What's the minimum cash flow needed for positive NPV?

Use results to make informed investment and capital allocation decisions.

---

NPV translates future cash flows into today's dollars, enabling rational comparison of investments with different timings and amounts. The calculator reveals whether an investment truly creates value or merely appears attractive due to distant payoffs. Positive NPV means go; negative means pass. Let time-adjusted math guide your decisions.