Net Present Value (NPV) & IRR Capital Budgeting Calculator
Evaluate capital investments, acquisition economics, and project feasibility using institutional Net Present Value (NPV), Internal Rate of Return (IRR), Payback Period, and Profitability Index.
Capital Budgeting Valuation Formulas: NPV, IRR & Payback
Capital Budgeting evaluates whether long-term investments generate adequate returns relative to their cost of capital. Net Present Value (NPV) discounts expected future cash flows back to today's purchasing power using the Weighted Average Cost of Capital (WACC), while Internal Rate of Return (IRR) solves for the exact break-even discount rate where NPV equals zero.
• r = Discount rate (WACC / Hurdle)
• CF_t = Net cash flow in period t
• NPV > 0 creates shareholder value
• Solves rate where NPV = 0
• Accept if IRR > Hurdle Rate
• Discounted rate of return efficiency
• Value generated per $1 invested
• PI > 1.0 = Economically viable
• Capital rationing decision rule
Project Capital Parameters
Outlay & HurdleDiscounted Cash Flow Amortization & Payback Matrix
Annual breakdown showing discount factor 1/(1+r)^t and cumulative present values
| Period | Nominal Cash Flow | Discount Factor | Present Value (PV) | Cumul. Nominal | Cumul. Discounted |
|---|---|---|---|---|---|
| Year 0 | -$100,000 | 1.0000 | -$100,000 | -$100,000 | -$100,000 |
| Year 1 | +$28,000 | 0.9091 | $25,455 | $28,000 | $25,455 |
| Year 2 | +$32,000 | 0.8264 | $26,446 | $60,000 | $51,901 |
| Year 3 | +$38,000 | 0.7513 | $28,550 | $98,000 | $80,451 |
| Year 4 | +$42,000 | 0.683 | $28,687 | $140,000 | $109,137 |
| Year 5 | +$46,000 | 0.6209 | $28,562 | $186,000 | $137,700 |
Capital Budgeting Framework: Resolving the NPV vs. IRR Conflict
Corporate finance directors and private equity partners frequently encounter situations where Net Present Value (NPV) and Internal Rate of Return (IRR) generate contradictory recommendations when selecting between mutually exclusive capital investments. Understanding the mathematical assumptions behind each metric is essential for sound capital allocation.
The Reinvestment Rate Fallacy
The fundamental difference between NPV and IRR lies in their implicit reinvestment rate assumptions:
- NPV Assumption: Assumes that intermediate cash flows generated by the project can be reinvested at the company's realistic Weighted Average Cost of Capital (WACC), such as 9% or 10%.
- IRR Assumption: Mathematically assumes that intermediate cash flows can be continuously reinvested at the project's own internal rate of return (e.g. 45%). In reality, finding recurring 45% reinvestment opportunities is virtually impossible.
Consequently, IRR tends to artificially exaggerate the profitability of high-return, front-loaded projects. When choosing between mutually exclusive projects, NPV always serves as the mathematically authoritative decision rule because it directly measures net dollar addition to firm equity.
Frequently Asked Questions
Capital Budgeting Executive Action Checklist
Ensure cash flow projections reflect incremental after-tax operational cash flows rather than accounting net income. Incorporate initial working capital outlays and salvage recovery values, stress-test your discount rate by at least ±200 basis points to gauge interest rate sensitivity, and prioritize projects with both a positive NPV and a discounted payback period within your organization's risk tolerance window.
Related Financial Tools
Interconnected calculations to validate your business economics
Compound Annual Growth Rate (CAGR) Calculator
Calculate annualized compound returns, doubling horizons via Rule of 72, and year-by-year compounding progression schedules.
ROI & Annualized Return (CAGR) Calculator
Calculate simple ROI percentage, compound annual growth rate (CAGR), net profit, and capital multiple (MOIC).
Business Valuation Engine
Determine enterprise value using Seller’s Discretionary Earnings (SDE), EBITDA, and industry revenue multiples.
DSCR Commercial Loan Calculator
Verify Debt Service Coverage Ratios for commercial financing and SBA debt underwriting.