NPV Capital Allocator — Free Online Calculator
Free NPV capital allocator determines project viability by discounting multi year variable cash flows. Instant browser results, no signup needed.
Like this tool? Help keep portfolios.tools free forever.
How It Works
Enter discount rate and multiple projects each with name, initial investment, and annual cash flows over the horizon. Net present value sums discounted cash flows minus initial investment for each project. Mutually exclusive projects choose highest NPV not highest IRR when scale differs. NPV is additive across independent projects with unlimited capital. Capital rationing with fixed budget chooses highest profitability index projects until budget exhausted not strictly highest NPV if projects differ in scale and budget constraint binds. Rank independent positive NPV projects by NPV when capital unlimited. Under capital rationing rank by profitability index to maximize value per dollar of scarce budget. Project ranking stability under plus two hundred basis point discount rate stress helps identify borderline investments sensitive to hurdle rate assumption.
Review NPV per project, profitability index, and ranking table sorted by highest NPV. Positive NPV projects add value at your discount rate assumption. When capital is limited, prioritize highest NPV projects first. Sensitivity on discount rate plus two points often reorders borderline projects with similar NPV. Incremental IRR on marginal project compares to hurdle rate when adding one more project to accepted set under budget cap. Stress discount rate plus two hundred basis points to test whether project ranking order remains stable for borderline investments with similar NPV. Capital rationing selects highest profitability index projects until budget exhausted when NPV scale differs across candidates. Profitability index ranks capital constrained portfolios by NPV per dollar invested when projects differ in scale and budget binds. Independent positive NPV projects should all be accepted when capital budget unconstrained per standard corporate finance decision rule application. Capital rationing forces ranking projects by profitability index when total NPV positive spend exceeds budget ceiling in single planning cycle. Incremental IRR on marginal dollar distinguishes borderline expansions from core maintenance capex with near zero growth optionality. Sensitivity tables on discount rate and terminal growth reveal which assumptions drive accept reject boundary for long dated infrastructure assets. Cross border projects require harmonizing nominal cash flows with inflation differential and sovereign risk premium embedded in hurdle rate selection committee process.
Independent positive NPV projects should all be accepted when capital budget unconstrained per standard corporate finance decision rule. Capital rationing forces ranking projects by profitability index when total NPV positive spend exceeds budget ceiling in single planning cycle. Incremental IRR on marginal dollar distinguishes borderline expansions from core maintenance capex with near zero growth optionality. Sensitivity tables on discount rate and terminal growth reveal which assumptions drive accept reject boundary for long dated infrastructure assets. Cross border projects require harmonizing nominal cash flows with inflation differential and sovereign risk premium embedded in hurdle rate selection committee process.
Use NPV Capital Allocator whenever inputs change: after market moves, new contributions, or revised personal assumptions. Bookmark the page for quick reruns without installing software.
Step by step
- Enter discount rate and add projects with investment and cash flow series
- Review NPV ranking and profitability index per project
- Adjust discount rate or cash flows to stress test ranking stability
Worked example
Enter discount rate and multiple projects each with name, initial investment, and annual cash flows over the horizon. Enter the sample inputs described in How it works to reproduce the scenario step by step.
Adjust one input at a time to see sensitivity. NPV Capital Allocator updates instantly so you can stress test optimistic and conservative assumptions before acting.
When to use this calculator
Reach for NPV Capital Allocator when determine project viability by discounting multi year variable cash flows.. It suits quick what if analysis before trades, allocation changes, or plan updates.
Pair with related tools when the decision spans taxes, liquidity, or multi year projections beyond what one formula captures.
Common mistakes
Copying outputs without checking input units or stale market prices is a frequent error with NPV Capital Allocator. Confirm tickers, percentages, and dates before acting.
Running a single baseline scenario ignores tail risks. Stress test with conservative inputs and compare against related tools listed below when the decision is material.
The Formula
For each year t: discountedCF_t = cashFlow_t / (1 + r)^t
NPV = -initialInvestment + sum of all discountedCF_t
Profitability Index = (NPV + initialInvestment) / initialInvestment
IRR = discount rate r where NPV = 0 (found via binary search)
Payback = first year where cumulative discounted CF >= initialInvestment
NPV discounts each period cash flow at constant discount rate. Initial investment at time zero not discounted. Constant discount rate assumed. Variable risk projects need risk adjusted rates per project. Uneven cash flows supported per project row. Salvage in final period cash flow. Uneven cash flow series supported per project with initial investment at time zero not discounted in standard NPV. Mutually exclusive projects require choosing highest NPV not highest IRR when scale differs because IRR ignores absolute dollar value created for shareholders in capital constrained enterprise prioritization exercise each fiscal year planning cycle. Educational estimates only not personalized advice consult qualified professional before major financial decisions.
Limitations and assumptions
NPV discounts each period cash flow at constant discount rate. Initial investment at time zero not discounted. Constant discount rate assumed. Variable risk projects need risk adjusted rates per project. Uneven cash flows supported per project row. Salvage in final period cash flow. Uneven cash flow series supported per project with initial investment at time zero not discounted in standard NPV. Mutually exclusive projects require choosing highest NPV not highest IRR when scale differs because IRR ignores absolute dollar value created for shareholders in capital constrained enterprise prioritization exercise each fiscal year planning cycle. Educational estimates only not personalized advice consult qualified professional before major financial decisions. NPV Capital Allocator does not replace personalized advice. Fees, slippage, account specific rules, and behavioral constraints may change real world outcomes.
Key terms
- What do NPV and IRR tell me
- NPV equals sum of discounted future cash flows minus initial investment.
- What discount rate should I use
- Discount rate should reflect opportunity cost of capital.
- Model assumption
- Profitability index equals present value of inflows divided by investment.
Compare alternatives
Value entire companies with DCF Valuation and find breakeven discount rate with IRR Calculator on portfolios. Use those calculators when npv capital allocator alone does not capture the full decision.
Internal links on portfolios.tools help you chain calculators: run NPV Capital Allocator first, then validate edge cases with a specialized tool from the related section below.
FAQ
What do NPV and IRR tell me?
NPV equals sum of discounted future cash flows minus initial investment. Positive NPV means project earns more than discount rate requirement. Initial investment at time zero is not discounted in standard NPV formulation. NPV additive property holds for independent projects with no resource conflicts. Accept all independent projects with positive NPV when capital unconstrained per standard corporate finance NPV rule. Replacement projects with equal lives compare directly on NPV while unequal lives need equivalent annual annuity conversion or common horizon approach with repeat investment assumptions stated explicitly in committee memo supporting capex authorization request package.
What discount rate should I use?
Discount rate should reflect opportunity cost of capital. Use WACC for average risk projects. Higher discount rate reduces NPV nonlinearly on long dated cash flows. Salvage value can be included as final period cash flow. Real options to defer expansion add value not captured in static NPV without flexibility premium. Discount rate sensitivity plus two hundred basis points often reorders borderline projects with similar headline NPV at base hurdle rate assumption.
What is the profitability index used for?
Profitability index equals present value of inflows divided by investment. Ranks projects by value per dollar invested when capital rationed. PI ranks capital rationed portfolios by NPV per dollar. Mutually exclusive projects pick max NPV even if smaller project has higher IRR. Mutually exclusive project set chooses highest NPV project even when smaller project shows higher IRR percentage headline metric.
What does payback period mean?
Independent projects with positive NPV should all be accepted if funding available. Capital rationing requires ranking by NPV or PI. Real options value of deferring project not captured. Sensitivity table on discount rate shows ranking stability for borderline projects.
What related capital budgeting tools should I use?
Use DCF Valuation for whole company equity value. IRR Calculator finds rate where NPV equals zero. IRR calculator finds breakeven discount rate where NPV equals zero. Payback period supplements NPV when liquidity constraint dominates strategic value. IRR Calculator finds discount rate where project NPV equals zero for hurdle rate comparison.
How do I use this NPV capital allocator on phone or tablet?
Yes. NPV Capital Allocator runs entirely in your mobile browser with the same formulas as desktop. Optional localStorage may remember inputs on your device when enabled in browser settings.
Where is my data stored when I use NPV Capital Allocator?
Nowhere on our servers. Calculations execute locally in your browser. Optional localStorage saves form fields on your device only and never transmits portfolio numbers over the network.
Should I rely on NPV Capital Allocator for tax or legal decisions?
No. NPV Capital Allocator provides educational math only. Tax law, account rules, and personal circumstances vary. Consult a qualified tax or legal professional before transactions with material consequences.
Related Tools
Value entire companies with DCF Valuation and find breakeven discount rate with IRR Calculator on portfolios.tools when comparing discrete project NPV rankings. Pair with IRR Calculator and Payback Period tools on portfolios.tools for full capital budgeting trio. Complete capital budgeting with IRR Calculator, Payback Period, and DCF Valuation on portfolios.tools.