Frequently Asked Questions

To calculate Net Present Value (NPV), follow this direct 4-step discounting formula:

1. Forecast cash flows (C_t): Estimate your net expected cash inflows for each period (Year 1, 2, 3...).
2. Pick a discount rate (r): Use your required hurdle rate or alternative return rate (e.g. 6% = 0.06).
3. Discount each year: Divide each year's cash flow by (1 + r)t to convert future money to present value.
4. Subtract initial cost: Add all discounted present values together, then subtract your Year 0 initial cash outlay.

Quick Example: Invest $1,000 today; receive $1,200 after 1 year at a 10% discount rate: NPV = ($1,200 / 1.10) - $1,000 = $1,090.91 - $1,000 = +$90.91 (Profitable!).

To calculate NPV over a 5-year horizon, write out and discount each of the 5 individual years:

Worked 5-Year Example: Upfront investment of $10,000 at an 8% discount rate with returns of $3,000/year for 5 years:

• Year 1: $3,000 / 1.081 = $2,778
• Year 2: $3,000 / 1.082 = $2,572
• Year 3: $3,000 / 1.083 = $2,381
• Year 4: $3,000 / 1.084 = $2,205
• Year 5: $3,000 / 1.085 = $2,042

Total 5-Year Present Value = $11,978. Subtracting initial outlay: NPV = $11,978 - $10,000 = +$1,978.

Constant Payout Shortcut: If annual checks are equal, use the 5-year annuity factor: NPV = Pmt × [ (1 − (1+r)−5) / r ] − C0.

To calculate NPV at a 12% discount rate (r = 0.12), divide each future cash flow by (1.12)t, where t is the year number:

Exact 12% Discount Multipliers:

• Year 1: 1 / 1.121 = 0.8929 (Cash is worth 89.29% of face value)
• Year 2: 1 / 1.122 = 0.7972 (Cash is worth 79.72% of face value)
• Year 3: 1 / 1.123 = 0.7118 (Cash is worth 71.18% of face value)
• Year 4: 1 / 1.124 = 0.6355 (Cash is worth 63.55% of face value)
• Year 5: 1 / 1.125 = 0.5674 (Cash is worth 56.74% of face value)

Concrete Calculation: A $5,000 project yields $7,000 at Year 2 at 12%:
NPV = ($7,000 × 0.7972) − $5,000 = $5,580.40 − $5,000 = +$580.40.

Why 12%? A 12% rate represents higher-risk investments, venture capital hurdle rates, or commercial real estate equity costs.

In Microsoft Excel, calculate NPV using this standard syntax:

Step-by-Step Excel Setup:

1. Enter the discount rate in cell B1 (e.g. 0.08 for 8%).
2. Enter the initial outlay in cell B2 as a negative value (e.g. -10000).
3. Enter cash flows for Years 1 to 5 in cells B3:B7 (e.g. 3000 in each).
4. In cell B8, type: =NPV(B1, B3:B7) + B2.

⚠️ Crucial Warning: Never include cell B2 (Year 0) inside the =NPV() brackets! Excel assumes the first value in the range starts at the end of Year 1, so putting Year 0 inside will wrongly discount your upfront cash. For irregular dates, use =XNPV(rate, values, dates).

Net Present Value (NPV) is the current total dollar value of all future cash inflows minus your initial cash investment, adjusted for the time value of money.

Formula Breakdown & Symbols:

• NPV = Net Present Value in today's dollars
• C_t = Net cash inflow or benefit payment received at period t
• r = Annual discount rate (hurdle rate or cost of capital)
• t = Time period / year (1, 2, 3... n)
• C₀ = Initial cash outlay or purchase price at Year 0
• n = Total number of years in the projection horizon

Expanded Formula: NPV = [ C₁/(1+r)¹ + C₂/(1+r)² + ... + C_n/(1+r)^n ] - C₀.

The NPV Golden Rule (or NPV Decision Rule) provides absolute, mathematically rigorous thresholds for financial decisions:

Application to Pension vs. Lump Sum: If your monthly pension's NPV is greater than an employer's lump-sum buyout check, keep the lifetime pension. If the lump-sum check is greater than the pension's NPV, accept the lump sum.