Finance
Seller financing calculator
Estimate monthly payment, interest, and an optional balloon on a seller note.
NPV calculator
Evaluate capital investments, machinery upgrades, and business projects using discounted cash flow (DCF) analysis. Enter your upfront initial outlay, discount rate / hurdle rate, and annual cash flows to calculate Net Present Value (NPV), Profitability Index (PI), and payback periods. Features period-by-period discount factor schedules, an internal rate of return (IRR) solver, and CSV export — all computed locally on your device without uploading confidential financial data.
Runs locally · Capital budgeting solver · DCF analysis · Not financial advice
£
Upfront capital expenditure or initial cash cost.
%
WACC, required rate of return, or opportunity cost.
Standard DCF assumes year-end cash realization.
Formatting prefix for outputs.
Net Present Value (NPV)
+£13,293.57
Adds value above 8% discount rate.
Internal Rate of Return (IRR)
17.23%
Exceeds 8% hurdle rate by 9.23%.
Profitability Index (PI)
1.27
PI ≥ 1.0 indicates value creation per pound invested.
Discounted Payback
4.02 yrs
Simple nominal payback: 3.33 yrs
Recommendation: Accept Investment
Economically viable. The project yields a positive Net Present Value of £13,293.57, adding value above the 8% cost of capital.
Cash Flow Schedule by Period
Enter annual cash flows (positive for inflows/savings, negative for ongoing maintenance or future expansions).
| Period | Description / Milestone | Cash Flow (£) | Discount Factor | Present Value | Cumulative NPV | Action |
|---|---|---|---|---|---|---|
| 0 | Initial Outlay (t=0) | −£50,000 | 1.000000 | −£50,000 | −£50,000 | — |
| Year 1 | 0.925926 | +£13,888.89 | −£36,111.11 | |||
| Year 2 | 0.857339 | +£12,860.08 | −£23,251.03 | |||
| Year 3 | 0.793832 | +£11,907.48 | −£11,343.55 | |||
| Year 4 | 0.735030 | +£11,025.45 | −£318.10 | |||
| Year 5 | 0.680583 | +£13,611.66 | +£13,293.57 | |||
| Totals & Net Realization | £30,000.00 | — | £13,293.57 | NPV = £13,293.57 | ||
Pair this analysis with our XIRR calculator for non-periodic, irregularly dated financial flows, or our Break-even calculator to calculate minimum unit sales.
NPV calculator example
£50,000 machinery upgrade at 8% hurdle rate
An initial £50,000 outlay followed by £15,000 annual net savings for 4 years and £20,000 in Year 5 yields an NPV of +£13,493.56 and an IRR of 17.57%. Because NPV > 0 and PI is 1.27, the capital project is financially viable.
NPV calculator how-to
- Convert discount rate percentage to decimal: r = discountRatePercent / 100.
- Treat initial outlay as negative cash flow at period 0 with discount factor 1.0.
- For each period t from 1 to N, calculate discount factor: DF_t = 1 / (1 + r)^t (or t-1 for beginning-of-period).
- Multiply nominal cash flow CF_t by discount factor DF_t to determine Present Value: PV_t = CF_t * DF_t.
- Sum all present values including period 0 to compute Net Present Value: NPV = sum(PV_t).
- Calculate Profitability Index: PI = sum(PV of inflows) / abs(Initial Outlay).
- Track cumulative cash flows to solve exact simple and discounted payback periods.
- Solve for Internal Rate of Return (IRR) where NPV(r) = 0 using numerical iteration.
- Render project schedule table, decision recommendation, and downloadable CSV report.
Related tools
Finance
Owner financing calculator
Calculate monthly payments, total interest, and balloon payoff from the buyer's perspective.
Finance
XIRR calculator
Calculate annualized internal rate of return for irregular, dated investments and cash flows.
Finance
Break even calculator
Calculate how many units you need to sell to cover fixed overhead and reach profit goals.
People also use
Finance
Pool loan calculator
Calculate swimming pool loan monthly payments, total interest, down payment, and payoff schedule.
Finance
Retirement corpus calculator
Calculate the required retirement corpus, future monthly living expenses adjusted for inflation, and required monthly savings.
Finance
GST calculator
Calculate Indian Goods and Services Tax (GST), CGST, SGST, IGST, and net/gross invoice values client-side.
Finance
EMI calculator
Calculate loan EMI, interest payments, and view full amortization schedule with CSV export. Runs client-side.
NPV calculator FAQ
- What is an NPV calculator?
- An NPV calculator discounts future cash flows at a rate to today's value and subtracts the initial investment. A positive NPV means the project beats the required return. This page also works out IRR, profitability index, and simple and discounted payback, and it runs in your browser.
- What is Net Present Value (NPV)?
- Net Present Value (NPV) is a capital budgeting metric that calculates the difference between the present value of cash inflows and the present value of cash outflows over a specific period of time. It accounts for the time value of money by discounting future earnings to today's value.
- How do I interpret a positive versus negative NPV?
- A positive NPV (NPV > 0) means the investment is projected to generate returns exceeding the cost of capital, adding economic value to the business. A negative NPV (NPV < 0) indicates the project falls short of the required hurdle rate and should be rejected or renegotiated.
- What discount rate should I use for NPV?
- The discount rate reflects your opportunity cost of capital or required rate of return (hurdle rate). For corporate projects, companies typically use their Weighted Average Cost of Capital (WACC). For independent investments, use target market returns or commercial borrowing interest rates.
- What is the difference between simple and discounted payback period?
- The simple payback period calculates the number of years required to recover the initial investment from nominal, undiscounted cash flows. The discounted payback period incorporates the time value of money, calculating when cumulative discounted present values fully offset the initial outlay.
- How does this NPV calculator differ from the XIRR calculator?
- This NPV calculator models periodic discounted cash flows (typically annual or monthly periods) at a predetermined discount rate. In contrast, the XIRR calculator solves for the exact annualized rate of return across irregularly dated, specific calendar events.
- What is Profitability Index (PI)?
- Profitability Index (also known as benefit-cost ratio) equals the present value of future cash inflows divided by the initial investment outlay. A PI of 1.0 represents breakeven; values greater than 1.0 indicate value creation per pound or dollar invested.
- How is NPV calculated mathematically?
- Given initial outlay C_0 and future cash flows C_t at discount rate r: NPV = -C_0 + sum_{t=1}^N (C_t / (1 + r)^t). Each period's cash flow is multiplied by its discount factor 1 / (1 + r)^t, and all discounted values are summed.