--- title: "NPV Calculator - Net Present Value Online" description: "NPV calculator with editable cash flows, a discounted period table and worked net present value result. Free, private and no sign-up required." url: https://candoya.com/tools/npv-calculator/ locale: en type: browser-tool --- # Free NPV Calculator Category: [Calculators](https://candoya.com/tools/calc/) ## What does an NPV calculator do? An NPV calculator converts future cash flows into today's value using a discount rate, then subtracts the initial investment. Enter each end-of-period inflow or outflow to see net present value, the present value of future cash flows, profitability index and a transparent period-by-period calculation. The calculator runs locally in your browser, so the amounts you enter are not uploaded. It assumes equally spaced periods and applies the same discount rate to each one. Match the rate to the period: use an annual rate for annual cash flows or a monthly rate for monthly cash flows. ## How to use it 1. **Enter the initial investment** - Type the time-zero project cost as a positive amount. The calculator treats it as an immediate outflow. 2. **Set the discount rate** - Enter the rate for one cash-flow period. The frequency of the rate and cash flows must match. 3. **Build the cash-flow timeline** - Add one value for each end-of-period cash flow. Use positive amounts for inflows and negative amounts for later outflows. 4. **Review the discounted result** - Read the NPV summary and inspect the discount factor, present value and cumulative NPV for every period. ## Who it's for - **Business owners** comparing a proposed project with its upfront cost and forecast cash generation. - **Finance teams** checking capital-budgeting models with uneven positive and negative cash flows. - **Property analysts** discounting expected rental cash flows and a later sale amount on one timeline. - **Students** verifying an NPV formula against a visible period-by-period solution. - **Product teams** testing how a higher hurdle rate changes the present value of forecast benefits. ## Expert note Excel's NPV function discounts its listed values as end-of-period cash flows, so a time-zero investment is normally added separately. This calculator makes that convention explicit by showing the initial investment as period 0 and discounting only periods 1 onward. ## Frequently asked questions ### Is this NPV calculator free? Yes. The NPV calculator is free, requires no account and has no calculation paywall. You can add up to 50 future cash-flow periods, switch the display currency and repeat calculations as often as needed. The selected currency changes formatting only and does not perform exchange-rate conversion. ### Are my cash-flow figures uploaded? No. The calculation runs locally in your browser, so the initial investment, discount rate and cash-flow forecast are not uploaded by the tool. You can clear the full timeline after use. The page needs no account and the calculation itself makes no network request. ### What are the limits of this NPV calculator? The calculator supports 1 to 50 equally spaced future periods, amounts with an absolute value up to 999,999,999,999,999, and discount rates greater than -100% through 10,000%. It does not calculate date-based XNPV, taxes, inflation, exchange rates or probability-weighted scenarios automatically. ### How is net present value calculated? NPV equals the time-zero cash flow plus each future cash flow divided by one plus the discount rate raised to its period number. This calculator asks for the initial investment as a positive amount and subtracts it, then adds the discounted values for periods 1 through the final period. ### What does a positive or negative NPV mean? A positive NPV means the discounted future cash flows exceed the initial investment at the chosen rate. A negative NPV means they fall short. NPV is one model input, not a guarantee or recommendation, because actual cash flows, timing, risk and the appropriate discount rate may differ. ### Can NPV cash flows be negative? Yes. A later period can contain a negative amount for maintenance, refurbishment, cleanup or another expected outflow. The calculator discounts that negative value in the same way as a positive cash flow and includes it in both the period table and cumulative NPV. ### Why is the initial investment not discounted? The initial investment occurs at period 0, so its discount factor is 1 and its present value equals the amount paid now. Future cash flows start at period 1 and are discounted back to period 0. This also avoids the common spreadsheet mistake of discounting an immediate cost for one extra period. ### What discount rate should I use for NPV? The appropriate rate depends on the project, risk, financing and available alternatives. Organizations may use a required return or a risk-adjusted cost of capital. The rate must match the cash-flow interval: an annual rate with annual flows, or a properly converted monthly rate with monthly flows. ## Related tools - [ROI Calculator](https://candoya.com/tools/roi-calculator/) - [Compound Interest Calculator](https://candoya.com/tools/compound-interest/) - [Break-even Calculator](https://candoya.com/tools/break-even-calculator/) - [Savings Goal Calculator](https://candoya.com/tools/savings-goal-calculator/) - [Profit Margin Calculator](https://candoya.com/tools/profit-margin-calculator/) --- *Markdown edition of , published for AI agents and other automated readers. Index of key pages: .*