NPV Calculator – Net Present Value

Net Present Value (NPV) relies on the principle of the time value of money, which states that a dollar today is worth more than a dollar tomorrow due to its potential earning capacity. The mathematical formula used to determine NPV is expressed as:

NPV = -C₀ + [ C₁ / (1 + r)¹ ] + [ C₂ / (1 + r)² ] + ... + [ C_n / (1 + r)ⁿ ]

Where C₀ represents the initial cash outlay (always a negative value or subtracted), C₁ through C_n are the net cash inflows for each period, and r is the periodic discount rate or hurdle rate.

Imagine you are evaluating a small business expansion project requiring an initial investment (C₀) of $50,000. You project annual cash inflows over the next three years of $20,000, $25,000, and $30,000 respectively. Your required rate of return (discount rate) is 8% (0.08).

1. Year 1 Present Value: $20,000 / (1 + 0.08)¹ = $18,518.52

2. Year 2 Present Value: $25,000 / (1 + 0.08)² = $21,433.47

3. Year 3 Present Value: $30,000 / (1 + 0.08)³ = $23,814.93

Summing these discounted cash flows gives a total Present Value of flows of $63,766.92. Subtracting the initial $50,000 investment leaves an NPV of $13,766.92, indicating a highly profitable venture.

When running your calculations, always ensure your cash flow timelines align consistently with your discount rate period (monthly versus annually). Avoid the common pitfall of ignoring inflation or underestimating future operational costs when projecting cash inflows. Finally, use a sensitivity analysis by adjusting your discount rate up and down to see how resilient your project is to market fluctuations.