NPV with Monthly Cash Flows Calculator
Designed for rental properties, SaaS subscriptions, loan amortization, and capital investments where cash flows occur monthly rather than annually.
The project earns less than the required return at the selected discount rate. It does not meet the hurdle rate.
Bars: present value of each period (Year 0 is initial outlay). Polyline: running cumulative total. When the line crosses zero, the project achieves economic break-even in today's money.
| Year | Cash flow | Discount factor | Present value | Running total |
|---|---|---|---|---|
| Year 0 | -$500,000 | 1.0000 | -$500,000 | -$500,000 |
| Year 1 | $45,000 | 0.8929 | $40,179 | -$459,821 |
| Year 2 | $48,000 | 0.7972 | $38,265 | -$421,556 |
| Year 3 | $50,000 | 0.7118 | $35,589 | -$385,967 |
| Year 4 | $52,000 | 0.6355 | $33,047 | -$352,920 |
| Year 5 | $55,000 | 0.5674 | $31,208 | -$321,712 |
| Year 6 | $60,000 | 0.5066 | $30,398 | -$291,314 |
| Year 7 | $62,000 | 0.4523 | $28,046 | -$263,268 |
| Year 8 | $65,000 | 0.4039 | $26,252 | -$237,016 |
| Year 9 | $70,000 | 0.3606 | $25,243 | -$211,773 |
| Year 10 | $75,000 | 0.3220 | $24,148 | -$187,625 |
| Year 11 | $80,000 | 0.2875 | $22,998 | -$164,627 |
| Year 12 | $85,000 | 0.2567 | $21,817 | -$142,810 |
| Discount Rate | Scenario | Net Present Value | Variance vs Base | Viability |
|---|---|---|---|---|
| 6.0%IRR | Break-Even (IRR) | $0 | +$142,810 | Break-Even |
| 8.0% | -400 bps | -$54,910 | +$87,900 | Reject |
| 10.0% | -200 bps | -$102,455 | +$40,354 | Reject |
| 11.0% | -100 bps | -$123,444 | +$19,366 | Reject |
| 12.0%Active | Base Case (Active) | -$142,810 | — (Base) | Reject |
| 13.0% | +100 bps | -$160,704 | -$17,894 | Reject |
| 14.0% | +200 bps | -$177,263 | -$34,453 | Reject |
| 16.0% | +400 bps | -$206,846 | -$64,036 | Reject |
Sensitivity analysis reveals how NPV shifts when corporate borrowing costs or inflation vary. As the discount rate increases, present value decreases.
Formula & Calculation Logic
NPV = -I_0 + Σ [CF_m / (1 + r/12)^m], where m is the month index and r is the annual nominal discount rate.This financial model applies precise periodic compounding to establish the exact present economic value of future cash inflows against the required initial investment.
Key Capabilities & Features
- Supports 12+ month cash-flow series
- Converts annual discount rate to effective monthly rate
- Visualizes monthly payback velocity
- Detailed monthly discount factor schedule
Frequently Asked Questions
What is Net Present Value (NPV)?
Net Present Value (NPV) is a core financial metric used in capital budgeting to analyze the profitability of a projected investment or project. NPV calculations take into account the time value of money by discounting expected future cash flows back to their present value using a specified discount rate (such as WACC or required rate of return). If the NPV is positive, the project is projected to generate surplus value over and above its cost of capital.
How is NPV calculated step-by-step?
To calculate NPV step-by-step: 1. Identify the Year 0 initial investment outlay ($I_0$). 2. Estimate the expected net cash flow ($CF_t$) for each period $t = 1, 2, \dots, n$. 3. Determine the appropriate annual discount rate ($r$). 4. For each period, calculate the discount factor: $1 / (1 + r)^t$. 5. Multiply each cash flow by its discount factor to obtain its Present Value ($PV_t$). 6. Sum all present values: $PV_{\text{inflows}} = \sum PV_t$. 7. Subtract initial investment: $NPV = PV_{\text{inflows}} - I_0$.