ADVERTISEMENT

Mobile Banner
320×100

Capital Budgeting Calculator

Evaluate investment projects with multiple metrics

Capital Budgeting Formulas

Net Present Value
Loading formula...
Payback Period
Loading formula...
Profitability Index
Loading formula...

Understanding Capital Budgeting

Capital budgeting is the process of evaluating long-term investment projects. It answers: should we spend money today for expected future benefits? Good capital budgeting maximizes firm value.

Multiple metrics are used because each captures different aspects. NPV measures absolute value creation. IRR measures return rate. Payback measures liquidity risk. Together they provide a complete picture.

The discount rate represents the cost of capital—the minimum return required to justify the investment. Projects with NPV > 0 create value; those with NPV < 0 destroy value.

Key Capital Budgeting Metrics

💰

NPV

Present value of all cash flows. Positive = creates value. The gold standard.

📈

IRR

Rate of return that makes NPV = 0. Compare to cost of capital.

⏱️

Payback Period

Years to recover initial investment. Simple liquidity measure.

📊

Profitability Index

NPV per dollar invested. Useful for capital rationing.

Decision Rules

MetricAccept IfReject IfNotes
NPVNPV > 0NPV < 0Best single metric
IRRIRR > Cost of CapitalIRR < CoCUse with caution
Payback< Target Payback> TargetIgnores TVM
PIPI > 1.0PI < 1.0Same as NPV > 0
Disc. Payback< Project Life> LifeIncludes TVM

Capital Budgeting Best Practices

📊

Use Multiple Metrics

No single metric tells the whole story. NPV + payback + sensitivity analysis together.

🎯

Estimate Cash Flows Carefully

Garbage in, garbage out. Be realistic about revenues, costs, and timing.

📈

Run Sensitivity Analysis

What if sales are 20% lower? What if costs rise? Test key assumptions.

💼

Consider Strategic Value

Some projects enable future options (R&D, market entry). Quantify if possible.

How to use this capital budgeting calculator

  1. Enter the Initial Investment ($) — the total upfront cash outflow needed to start the project, including equipment, installation, and working capital.
  2. Enter the Annual Cash Flow ($) — the expected net cash inflow each year (revenue minus operating costs, after tax). Use a realistic base-case estimate, not the optimistic pitch number.
  3. Set the Project Life (years) — how long the asset will generate cash flows before it's retired, replaced, or wound down. Match the economic life, not the accounting depreciation life.
  4. Set the Discount Rate (%) — your weighted average cost of capital (WACC), or WACC plus a risk premium for higher-risk projects.
  5. Optional: enter a Salvage Value ($) — the expected resale or scrap value of the asset at the end of its life. This is discounted to today's dollars before being added to NPV.
  6. Click Evaluate Project. The calculator returns NPV, Payback Period, Profitability Index, and an accept/reject decision based on whether NPV is positive.

Examples

Equipment purchase: $100k machine with steady cash flows

A small manufacturer is evaluating a CNC machine that costs $100,000, is expected to generate $30,000 per year in net cash flow for 5 years, and will be scrapped at the end with no salvage value. The company's cost of capital is 10%.

ResultNPV is about $13,724, Payback Period is 3.33 years, Profitability Index is about 1.14, and the decision is Accept.

Each year's $30,000 inflow is discounted back to today: $30,000 / 1.10, $30,000 / 1.10^2, and so on through year 5. The sum of those present values is roughly $113,724. Subtract the $100,000 initial investment to get NPV ≈ $13,724. Because NPV > 0 and PI > 1.0, the project clears the 10% hurdle and creates value.

Factory expansion with salvage value

A mid-size firm considers a $500,000 production-line expansion expected to generate $150,000 per year for 6 years, with an estimated $50,000 salvage value when sold. Management uses a 12% discount rate to reflect the project's moderate risk.

ResultNPV is about $142,044, Payback Period is 3.33 years, Profitability Index is about 1.28, and the decision is Accept.

Discounted operating cash flows total about $616,712 (the 6-year annuity factor at 12% is roughly 4.111). The salvage value of $50,000 in year 6 is worth about $25,332 today. Total PV of inflows is about $642,044; subtract the $500,000 outlay for NPV ≈ $142,044. Strong positive NPV plus a PI well above 1.0 makes this a clear accept.

Long-lived asset with conservative discount rate

A utility is evaluating $250,000 of grid equipment with a long 8-year service life, expected to deliver $60,000 per year in net cash flow and a $20,000 salvage value. Because the cash flows are highly predictable, an 8% discount rate is used.

ResultNPV is about $105,603, Payback Period is 4.17 years, Profitability Index is about 1.42, and the decision is Accept.

The 8-year annuity factor at 8% is about 5.747, so the $60,000 yearly inflows have a present value near $344,798. The $20,000 salvage discounted 8 years at 8% is worth about $10,805. Total PV of inflows ≈ $355,603; subtract the $250,000 cost for NPV ≈ $105,603. Lower discount rate and longer life amplify the impact of stable cash flows.

How it works

The calculator applies the standard NPV formula NPV=t=1nCFt(1+r)tC0NPV = \sum_{t=1}^{n} \frac{CF_t}{(1+r)^t} - C_0, where C0C_0 is the initial investment, CFtCF_t is the cash flow in year tt, rr is the per-period discount rate, and nn is the project life. Each future cash flow is divided by (1+r)t(1+r)^t to convert it into today's dollars, then summed and reduced by the upfront outlay.

When you supply a Salvage Value, the calculator adds it to the year-nn cash flow and discounts it the same way. Payback Period is computed as Initial Investment divided by Annual Cash Flow, which assumes a uniform inflow; the Profitability Index is the ratio of the present value of future inflows to the initial investment, so PI > 1.0 always implies NPV > 0.

The decision rule is mechanical: accept when NPV > 0, reject when NPV < 0, indifferent at zero. NPV is preferred over IRR for mutually exclusive projects because it measures absolute dollar value created, which is what shareholders actually receive. IRR is useful as a percentage benchmark but can mislead when cash-flow signs change or when comparing projects of different scale.

When to use this calculator

  • Evaluating a single capital project. Decide whether a piece of equipment, software license, building, or product launch will earn back more than your cost of capital before committing budget. A positive NPV at your WACC is the green light.
  • Comparing competing projects with limited capital. When the capital budget can't fund every project with NPV > 0, rank options by Profitability Index to pick the combination that creates the most value per dollar of constrained capital.
  • Stress-testing assumptions before board approval. Run the same project at a higher discount rate, a 20% lower cash flow, or a shorter life to see how sensitive the decision is. If NPV flips sign under modest pessimism, the project is risky even if the base case looks attractive.
  • Replacing or upgrading an existing asset. Model only the incremental cash flows — the difference between keeping the old asset and switching to the new one. Sunk costs of the existing asset don't enter the analysis.

Common mistakes to avoid

  • MistakeUsing accounting profit instead of cash flow.
    FixCapital budgeting uses after-tax operating cash flow: revenue minus cash costs minus taxes, then add back depreciation. Net income includes non-cash charges and miscounts the timing of real cash.
  • MistakeIncluding sunk costs in the analysis.
    FixMoney already spent on feasibility studies, prototypes, or existing equipment is irrelevant. Only incremental future cash flows that change because of the decision belong in the model.
  • MistakePicking the discount rate by gut feel.
    FixStart with the firm's weighted average cost of capital (WACC). Add a risk premium for projects riskier than the firm's average, and use a project-specific cost of capital for new business lines.
  • MistakeIgnoring inflation inconsistency.
    FixEither forecast nominal cash flows and discount at a nominal rate, or forecast real cash flows and discount at a real rate. Mixing the two systematically over- or under-states NPV.
  • MistakeTrusting payback period as the primary metric.
    FixPayback ignores cash flows after recovery and the time value of money. Use it only as a secondary liquidity check; let NPV drive the accept/reject decision.
  • MistakeComparing mutually exclusive projects with different lives using raw NPV.
    FixConvert each project's NPV to an Equivalent Annual Annuity (EAA), or use the replacement-chain method to make the comparison fair when lives differ.

Frequently asked questions

What's the difference between NPV and IRR?

NPV is the dollar value a project adds to the firm after discounting all cash flows at your cost of capital. IRR is the discount rate that would make NPV exactly zero. NPV is more reliable for mutually exclusive projects and projects with non-conventional cash flows (where the sign of cash flow changes more than once), because IRR can have multiple solutions or none at all. When the two methods disagree on ranking, follow NPV.

How do I pick a discount rate?

For projects with risk similar to the firm's overall business, use the Weighted Average Cost of Capital (WACC). For riskier projects (new geographies, unproven technology), add a risk premium of 2–5 percentage points. For lower-risk projects (cost-saving investments in core operations), you can use WACC unchanged. Public firms can estimate WACC from their actual capital structure and the CAPM; private firms can benchmark against listed peers.

Is payback period reliable on its own?

No. Payback tells you how quickly you recover the investment, which is a useful liquidity check, but it ignores the time value of money and any cash flows after the payback date. A project with a 3-year payback and zero cash flow after year 3 is far worse than a project with a 4-year payback and 10 more years of strong cash flow. Use payback as a secondary screen, not the primary decision rule.

How do I compare projects with unequal lives?

Raw NPV favors the longer project simply because it accumulates more years of cash flow. To compare fairly, use the Equivalent Annual Annuity (EAA) method — convert each project's NPV into an equivalent level annual cash flow over its life — and pick the higher EAA. Alternatively, use the replacement-chain method, repeating the shorter project until both horizons line up.

How should I handle inflation in the cash flows?

Stay consistent. Either project nominal cash flows (which include expected price increases) and discount at the nominal cost of capital, or project real cash flows (in today's purchasing power) and discount at the real cost of capital. Don't mix nominal cash flows with a real discount rate or vice versa — that's the most common error in long-horizon projects.

What discount rate does this calculator assume?

Whatever you enter in the Discount Rate field. The calculator treats the rate as a constant per-period rate applied to every future cash flow. If you expect the cost of capital to change over time (for example, after a refinancing), this single-rate model is an approximation; for material decisions, build a multi-rate model or run sensitivity at the high and low ends.

Do I need to include taxes in the cash flows?

Yes. Capital-budgeting cash flows should be after-tax: revenue − cash operating costs − cash taxes. Depreciation isn't a cash outflow, but it lowers taxable income, so include the depreciation tax shield (depreciation × tax rate) as part of the cash inflow. Salvage value should be net of any capital gains tax on disposal.

What if my project has a negative NPV but strategic value?

A negative NPV means the base-case financial forecast doesn't cover your cost of capital. Strategic options — entering a new market, blocking a competitor, building capability — can justify proceeding, but quantify them: estimate the expected value of the follow-on opportunities the project unlocks, and add that to NPV. If you can't articulate the strategic value in dollars, scrutinize whether it really exists.

Can I use this calculator for uneven cash flows?

This widget assumes a constant annual cash flow for simplicity. If your project has lumpy or growing cash flows (year 1 = $20k, year 2 = $40k, year 3 = $80k), the single-cash-flow input will misstate NPV. Use the calculator for first-pass screening with an average figure, then build a year-by-year spreadsheet model for final approval.

How does salvage value affect the result?

Salvage value is the asset's expected resale or scrap value at the end of its life. The calculator discounts it back from year n at the same rate as the other cash flows and adds it to the present value of future inflows. A large salvage value can flip a borderline project from reject to accept, so be conservative — used-equipment markets, decommissioning costs, and capital-gains tax on the sale all eat into the headline number.

Sources

Methodology

This calculator computes Net Present Value as NPV = Σ CF_t / (1+r)^t − C_0, where C_0 is the initial investment, CF_t is the constant annual cash flow (with salvage value added to the final year), r is the discount rate, and n is the project life. Payback Period uses the simple formula Initial Investment ÷ Annual Cash Flow. Profitability Index is the present value of future cash flows divided by the initial investment, so PI > 1.0 mirrors NPV > 0. The accept/reject decision is driven by the sign of NPV.

Pro Tips

  • Bookmark this calculator for quick access in the future
  • Use the share button to send your results to others
  • Try different scenarios to compare outcomes
  • Check out our related calculators for more insights

Found this calculator helpful? Share it with others:

Embed this calculator