Capital Budgeting Calculator
How to Use This Calculator
- 1
Enter the project's upfront cost
Type the total initial outlay in Initial Investment ($).
- 2
Set the annual inflow and analysis assumptions
Enter Annual Cash Inflows ($), Discount Rate (%), and Investment Duration (years). The calculator models the same cash inflow in each year.
- 3
Compare the return measures and cash-flow table
Review NPV, IRR, payback, ROI, and profitability index alongside discounted and cumulative cash flows. These measures use different assumptions and answer different questions.
Example Calculation
A project costs $50,000 upfront and is expected to bring in $12,000 at the end of each year for six years. The chosen discount rate is 8%.
Initial Investment ($)
50,000
Annual Cash Inflows ($)
12,000
Discount Rate (%)
8
Investment Duration (years)
6
Results
Net Present Value (NPV)
$5,474.56
Internal Rate of Return (IRR)
11.52%
Payback Period
4.17 yrs
Return on Investment (ROI)
44.00%
Profitability Index
1.11
Total Discounted Inflows
$55,474.56
Insights card shows whether the NPV is positive and how the project's return measures compare with the discount rate.
Tips
A 10% discount rate leaves this project with a positive NPV
Change Discount Rate (%) from 8 to 10 while keeping the other inputs unchanged. The present value of six $12,000 inflows is about $52,261.84, so NPV is about $2,261.84.
A smaller annual inflow can turn NPV negative
Change Annual Cash Inflows ($) from $12,000 to $10,000. At an 8% discount rate, discounted inflows are about $46,228.80, below the $50,000 initial cost.
Payback does not account for the time value of money
Compare the 4.17-year simple payback with the discounted cash-flow table. The payback measure uses undiscounted inflows, while NPV discounts each year's inflow.
What this calculator estimates
Capital budgeting evaluates whether a long-term project can justify its upfront cost through future cash inflows. This calculator estimates NPV, IRR, simple payback, ROI, profitability index, and discounted inflows for a level annual cash-flow pattern; it does not model changing yearly cash flows, taxes, financing, or a terminal asset value.
How the calculation works
NPV = Σ [Cash inflow in year t ÷ (1 + discount rate)^t] − Initial investment
IRR = rate that makes NPV equal 0
Simple payback = Initial investment ÷ Annual cash inflow
ROI = [(Total undiscounted inflows − Initial investment) ÷ Initial investment] × 100
Profitability index = Total discounted inflows ÷ Initial investment
The discount rate is the required return expressed as a decimal in the formula, and t is the year in which an inflow arrives. This calculator assumes the same inflow arrives annually. Its payback calculation divides the initial investment by the annual inflow, effectively treating payback as occurring within a year; actual cash receipts may arrive only at year-end.
For the example, the six $12,000 inflows have present values of $12,000 ÷ 1.08, $12,000 ÷ 1.08², continuing through $12,000 ÷ 1.08⁶. Their sum is $55,474.56. Subtracting the $50,000 initial investment gives an NPV of $5,474.56. Total undiscounted inflows are 6 × $12,000 = $72,000, so ROI is [($72,000 − $50,000) ÷ $50,000] × 100 = 44%. The profitability index is $55,474.56 ÷ $50,000 = 1.11.
How the discount rate affects NPV
A higher discount rate reduces the present value of future cash flows, even when the project forecasts do not change. That makes the discount rate a key decision assumption, not just a setting to copy from another project.
| Discount rate | Discounted value of six inflows | NPV |
|---|---|---|
| 8% | $55,474.56 | $5,474.56 |
| 10% | $52,261.84 | $2,261.84 |
| 12% | $49,335.61 | −$664.39 |
Compare the rate with the project's risk and the cost of capital available to the business. A higher-risk forecast generally requires more scrutiny than a low-risk, well-supported forecast, but the calculator does not determine the appropriate rate for you.
Use multiple measures, not one pass/fail number
NPV measures value added in today's dollars at the selected discount rate. IRR expresses the project's break-even discount rate; for this example it is about 11.52%, above the 8% discount rate. Simple payback shows how long undiscounted inflows take to recover the upfront cost, but it ignores the time value of money and any later cash flows.
ROI is a cumulative, undiscounted percentage, while profitability index compares discounted inflows with initial cost. These measures are not interchangeable. For mutually exclusive projects, compare NPV at a consistent discount rate and consider whether funding limits, timing, and forecast risk change the choice.
When to use a different calculator
This calculator assumes a constant annual inflow. For other analyses:
- Comparing project funding with the cost of capital → opportunity cost of capital calculator
- Projecting an asset's value growth → capital appreciation calculator
- Comparing a lease with an asset purchase → capital lease calculator
- Assigning income and expenses across a budget → zero-based budgeting calculator
Forecast limitations
A useful capital budget depends on cash-flow estimates that reflect realistic operating costs, timing, taxes, and working capital. Stress-test lower inflows, higher costs, and delays; a positive NPV under one forecast does not remove the risk that actual results will differ.
Frequently Asked Questions
What does a positive NPV mean?
A positive net present value means the discounted value of expected inflows exceeds the initial investment at the selected discount rate. It supports accepting a project under those cash-flow and rate assumptions, but it does not guarantee that the forecast will be achieved.
How do I calculate NPV?
1. Discount each future cash flow by dividing it by (1 + discount rate) raised to its year number. 2. Add the discounted cash flows. 3. Subtract the initial investment. A positive result means the discounted inflows exceed the upfront cost.
What is the difference between IRR and the discount rate?
IRR is the rate that makes a project's NPV equal zero; the discount rate is the hurdle used to evaluate the project. An IRR above the discount rate generally corresponds to a positive NPV for the conventional cash-flow pattern modeled here.
Does payback period include discounted cash flows?
No, the payback period is based on undiscounted inflows in this calculator. It also does not account for cash flows after the payback date, so use NPV alongside payback when comparing projects.
What if a project's cash flows vary each year?
This calculator assumes one constant annual inflow, so it cannot represent uneven forecasts, irregular timing, or a terminal sale value. Build a year-by-year forecast separately or use a model that accepts individual cash flows before relying on its NPV or IRR.
Should a business choose the project with the highest IRR?
Not automatically: IRR can rank projects differently from NPV when they differ in scale, timing, or cash-flow pattern. Compare NPV at a consistent cost of capital and account for capital limits, project risk, and strategic constraints.
