Capital Budgeting Calculator guide
Capital budgeting combines complementary measures rather than relying on one ratio. NPV measures modeled value, IRR expresses a return rate, payback measures recovery, and profitability index relates benefits to capital required.
A salvage value belongs in the final project-period cash flow and should reflect disposal costs and taxes where relevant.
How to use the capital budgeting calculator
- Enter current amounts: Use current, documented values from the same relevant period.
- Enter assumptions: Use realistic rates, percentages, periods, and costs where applicable.
- Review the full result: Review the primary estimate together with its supporting measures.
- Stress-test risk: Model less favorable timing, value, cost, or rate assumptions.
Formula and variables
The estimate applies the entered values and assumptions to the stated formula.
Project decision combines discounted cash flows, IRR, recovery time, and capital efficiency- Inputs — Entered values
- The amounts, percentages, or periods supplied to the calculator.
- Result — Calculated output
- The estimate produced by applying the formula to the entered values.
Worked example: capital budgeting calculator
A user enters a representative set of values and assumptions.
- Key inputs
- Amounts, percentages, periods, and costs
- Apply the stated formula.
- Include all relevant entered values and constraints.
- Compare the result with an alternative scenario.
Result: Integrated NPV, IRR, payback, profitability index, and total net cash.
Use the estimate as a planning input and verify important decisions with current records or qualified guidance.
Understanding your results
Primary estimate
Integrated NPV, IRR, payback, profitability index, and total net cash.
Risk measures
Use supporting payment, leverage, cost, and cash figures together.
Assumptions
- Entered rates and costs remain constant.
- Payments and cash flows occur on schedule.
Limitations
- Taxes, legal terms, accounting treatment, and transaction-specific costs may differ.
- Future values, timing, and rates are uncertain.
Common mistakes
- Reviewing only the headline result.
- Ignoring relevant costs, timing, or supporting measures.
- Using optimistic timing or value assumptions.
- Treating an estimate as a guaranteed outcome.
Practical use cases
Compare scenarios consistently
Change one assumption at a time or enter each alternative using the same basis.
Plan cash requirements
Estimate funds needed before committing.
Planning and decision guide
Stress-test the assumptions
Model only incremental project cash flows, including working capital, maintenance, taxes, and disposal.
Review the important risks
Use sensitivity and scenarios for volume, price, cost, delay, and discount rate.
Verify the source values
Resolve conflicts between metrics by considering value, scale, constraints, risk, and strategy.
Frequently asked questions
Which metric should lead?
NPV is commonly used for modeled value creation, while other measures add liquidity and efficiency context.
Where does salvage value go?
In the final period, adjusted for expected disposal costs and applicable tax effects.
Why can IRR and NPV disagree?
Projects can differ in scale, timing, duration, and reinvestment assumptions.
Does this include financing?
Use cash flows and discount rates consistently; avoid double-counting financing costs.
Sources and review
- Introduction to investing — U.S. Securities and Exchange Commission. Accessed 2026-07-10.
Reviewed 2026-07-10.