Corporate Finance & Valuation Lab

Capital Budgeting & NPV / IRR Lab

Evaluate CapEx investments, store expansions, and equipment upgrades using Net Present Value (NPV), Internal Rate of Return (IRR), Profitability Index, and discounted payback schedules.

CapEx Model Discounted Cash Flow Schedule Capital Budgeting Theory FAQ

CapEx Project Presets

Load calibrated multi-year investment models.

Step 1: CapEx & Discount Rate Assumptions

Project Investment Parameters

1. Initial Outlay & Hurdle Rate

$
Upfront equipment purchase, installation, and setup costs (Year 0).
%
$
Residual asset sale or scrap value at project end.

2. Annual Net Cash Inflows ($/year)

Net Present Value
+$0
Internal Return (IRR)
0.0%
Profitability Index
0.00x
Simple Payback
0.0 Yrs
Discounted Payback
0.0 Yrs
CapEx Decision
Accept

Step 2: Discounted Cash Flow (DCF) Schedule

Multi-Year Cash Inflows & Present Values

Multiplies nominal annual cash flows by yearly discount factors to calculate present value contributions and cumulative cash recovery.

Timeline Nominal Cash Flow ($) Discount Factor (DF) Present Value (PV) Cumulative Net Balance

Corporate Finance Guide

Understanding capital budgeting rules

Capital budgeting is the process of deciding how to allocate scarce financial resources to long-term investment projects.

  • NPV Rule: Accept projects where NPV > 0. Adding positive NPV projects increases the total intrinsic value of the enterprise.
  • IRR vs. WACC: If the Internal Rate of Return exceeds the cost of capital, the return generated exceeds the financing cost.
  • Payback Pitfall: Simple payback ignores cash flows received after the cutoff year and ignores the time value of money, which is why DCF metrics (NPV and Discounted Payback) are superior.

Explore business valuation multiples in our Business Valuation Lab.

Finance Equations

Capital valuation formulas

NPV = ∑ [CF_t ÷ (1 + r)^t] − Initial Outlay

IRR = Rate (r) where NPV = 0

Profitability Index (PI) = PV of Inflows ÷ Initial Outlay

Discount Factor (DF_t) = 1 ÷ (1 + r)^t

Discounted Cash Flow = Nominal Cash Flow × DF_t

Test 12-month projections in the Financial Model Generator.

FAQ

Capital budgeting questions

What is Net Present Value (NPV) and why is it the gold standard?

NPV measures the net dollar value created by an investment by discounting all expected future cash inflows back to present value and subtracting the upfront initial outlay. Projects with positive NPV (NPV > 0) create shareholder value.

What is the Internal Rate of Return (IRR)?

IRR is the annualized discount rate that makes the NPV of a project equal to exactly zero. If a project's IRR exceeds the company's cost of capital (WACC hurdle rate), the project is economically profitable.

What is the difference between simple payback and discounted payback?

Simple payback calculates how many years it takes for unadjusted cash inflows to recover the initial investment. Discounted payback accounts for the time value of money by discounting each cash flow before tracking cumulative recovery.

What is the Profitability Index (PI)?

Profitability Index (PI) is the ratio of the present value of future cash inflows to the initial capital outlay. A PI greater than 1.0 indicates that a project generates more value than it costs.

Can I export capital budgeting DCF schedules to CSV?

Yes. You can export complete multi-year cash flow projections, discount factors, present values, and return metrics as a UTF-8 CSV spreadsheet with formula injection defense or print an executive CapEx brief.

Are these calculations formal investment underwriting or securities advice?

No. This tool provides simplified educational models for corporate finance and classroom training without formal investment banking opinions, underwriting commitments, or audit certifications.

Continue Exploring Corporate Finance Tools

Explore our Finance Class Simulation Lesson, evaluate deal terms in the Business Valuation Lab, model cash flow timing in the Cash Conversion Cycle Simulator, or simulate price sensitivity in the Pricing Strategy Simulator.