By "Learn a DCF model so you can understand the technical aspects of the time value of money, NPV/IRR/Payback period, and the mechanics to layout cash flows."
— Source: r/FPandA (67 upvotes)
You're running a $5M omnichannel brand. Your 3PL bill is $240K a year and rising with volume. You could buy a warehouse for $500K and run it yourself for about $180K a year. Should you do it?
The answer isn't obvious. The savings start small and grow with volume, but you're investing $500K upfront. That $500K could stay in the bank, go to inventory, or fund marketing. You need a framework to decide: NPV, IRR, and WACC.
These three tools answer: "How much value does this investment create? What return will we make? And is that return high enough to justify the risk?"
This guide walks through NPV, IRR, and WACC with a real warehouse vs 3PL decision. We compute the cash flows, the discount rate, and show how each metric guides the final call.
What is Capital Budgeting?
The 50-word definition
Capital budgeting is the process of evaluating and prioritizing capital investments (CapEx projects, acquisitions, infrastructure). You forecast the cash flows for each project, discount them back to present value at your cost of capital (WACC), and accept projects with positive NPV (or above your IRR hurdle rate).
For consumer brands, capital decisions include:
- Buy warehouse vs stay with 3PL
- Invest in packaging line vs outsource
- Expand to new warehouse vs rent more 3PL space
- Build proprietary software vs buy SaaS
- Acquire smaller brand vs organic growth
Each decision requires a financial framework: NPV, IRR, and WACC.
NPV: Net Present Value
The Formula
NPV = Σ [CF_t / (1+r)^t] − Initial Investment
Where:
CF_t = Cash flow in year t
r = Discount rate (WACC)
t = Year (0, 1, 2, ...)
If NPV > 0: Project creates value. Accept it.
If NPV < 0: Project destroys value. Reject it.
What NPV Means
NPV is the dollar amount of value a project creates (or destroys) after accounting for the time value of money. A positive NPV of $500K means: "After discounting future cash flows back to today at our cost of capital, this project creates $500K of shareholder value."
The discount rate matters enormously. Higher discount rates = lower NPV (because you're more pessimistic about future cash). Lower discount rates = higher NPV (because you're more optimistic or see lower risk).
Why Time Value of Money Matters
$100 today is worth more than $100 in 5 years because today's $100 can be invested and earn returns. If your cost of capital is 10%, $100 in 5 years is worth about $62 today.
Example: A project costs $500K upfront and generates $100K/year for 10 years. Simple math: 10 × $100K = $1M, so profit = $500K. But NPV tells the real story:
| Discount Rate (r) | PV of $100K/year (10 years) | NPV |
|---|---|---|
| 5% | $772.17K | +$272.17K (attractive) |
| 10% | $614.46K | +$114.46K (okay) |
| 15% | $501.88K | +$1.88K (barely worth it) |
| 20% | $419.25K | -$80.75K (destroys value, reject it) |
Same project, same cash flows. But depending on your discount rate, NPV ranges from +$272K to -$81K. The discount rate (WACC) is everything.
IRR: Internal Rate of Return
The Formula
IRR is the discount rate where NPV = 0. It's the "breakeven" return rate for a project.
Solve for r where: Σ [CF_t / (1+r)^t] − Initial Investment = 0
There's no closed-form solution; you solve iteratively or use a financial calculator/spreadsheet (Excel IRR function).
IRR Interpretation
IRR is the annualized return you'll earn on a project. If a project has 22% IRR, you're making a 22% annual return (in present value terms) on your capital.
Decision rule: If IRR > WACC, accept the project. If IRR < WACC, reject it.
If WACC is 12% and a project has 22% IRR, you're earning 10% more than your cost of capital. Good deal.
If WACC is 12% and a project has 8% IRR, you're earning 4% less than your cost of capital. Bad deal.
NPV vs IRR: Which is Better?
Both tell the same story, but NPV is more reliable for capital budgeting. NPV gives a dollar value of value created. IRR gives a percentage return. For most decisions, accept projects with NPV > 0 (equivalently, IRR > WACC). But when ranking multiple projects, NPV is clearer because it shows absolute value creation, not just percentage return.
- Project A: NPV = $100K, IRR = 25%
- Project B: NPV = $500K, IRR = 18%
- Which do you choose? Project B, because it creates more absolute value ($500K > $100K), even though Project A has a higher percentage return.
WACC: Weighted Average Cost of Capital
The Formula
WACC = (E/V × Re) + (D/V × Rd × (1 − Tc))
Where:
E/V = Percentage of capital that is equity
Re = Cost of equity (required return on equity)
D/V = Percentage of capital that is debt
Rd = Cost of debt (interest rate)
Tc = Corporate tax rate
What WACC Means
WACC is the weighted average return your investors (equity holders and debt holders) require. It's your hurdle rate: the minimum return a project must earn to be attractive.
Illustrative example: if equity holders require 12%, lenders charge 6%, and the business is 70% equity and 30% debt, the pre-tax blend is 0.7 × 12% + 0.3 × 6% = 10.2%. After the debt tax shield (21% tax rate), WACC is 0.7 × 12% + 0.3 × 6% × 0.79 = 9.82%. That is the minimum return new investments must earn.
Calculating Cost of Equity (Re)
Use the Capital Asset Pricing Model (CAPM):
Re = Rf + β × (Rm − Rf)
Where:
Rf = Risk-free rate (commonly a long-term Treasury yield; use the current rate)
β (beta) = Systematic risk relative to the market (private brands usually borrow a beta from comparable public companies)
Rm = Expected market return
Illustrative example (assumed inputs, not current market data):
- Rf = 4% (risk-free rate)
- β = 1.3 (assumed)
- Rm = 10% (assumed market return)
- Re = 4% + 1.3 × (10% − 4%) = 4% + 7.8% = 11.8%
Cost of Debt (Rd)
Rd is the interest rate your lenders charge. Illustrative example for a small brand with a bank loan priced at a benchmark rate plus a spread (assumed figures):
- Benchmark rate: 5.5% (assumed)
- Lender spread: 3% (assumed)
- Rd = 5.5% + 3% = 8.5% (before tax benefit)
Tax Adjustment: Why (1 − Tc) Matters
Interest on debt is tax-deductible. If you pay $100K in interest, your taxable income drops $100K. At the 21% US federal corporate rate, a C corporation saves $21K in federal tax. So the true cost of debt is lower:
Rd after tax = 8.5% × (1 − 0.21) = 8.5% × 0.79 = 6.7%
Putting It Together: A WACC Example
Illustrative brand financials:
- Equity value (market cap): $1.5M
- Debt (bank loans): $400K
- Total value (V): $1.9M
- Cost of equity (Re): 11.8%
- Cost of debt (Rd): 8.5% (before tax)
- Tax rate: 21%
WACC = ($1.5M / $1.9M × 11.8%) + ($400K / $1.9M × 8.5% × 0.79)
= (0.7895 × 11.8%) + (0.2105 × 6.7%)
= 9.32% + 1.41%
= 10.73%
This brand's WACC is about 10.7%. Any project with IRR > 10.7% creates value. Projects with IRR < 10.7% destroy value.
Worked Example: Warehouse vs 3PL
Scenario
- Brand Profile: $5M DTC + Amazon brand, currently paying 3PL fees of $240K/year for 1M units
- Growth Projection: Revenue growing 25% YoY; unit volume grows to 2M units by Year 5
- 3PL Costs: Scale with volume (~$0.24/unit); projected to reach $480K/year at 2M units
- Warehouse Option: Buy/build $500K warehouse. Hire 2 FT staff ($120K/year). Operating costs (utilities, maintenance, systems): $60K/year.
- Investment life: 10 years. Warehouse salvage value at Year 10: ~$100K
- Tax rate: 21%
Incremental Annual Cash Benefits (3PL Savings − Warehouse Costs)
| Year | Units | 3PL Cost | Warehouse Cost | Net Savings (pre-tax) | Tax (21%) | After-tax Cash Flow |
|---|---|---|---|---|---|---|
| 1-3 | 1M-1.3M | $240K-$312K | $180K | $60K-$132K | −$12.6-$27.7K | $47.4K-$104.3K |
| 4-5 | 1.5M-2M | $360K-$480K | $180K | $180K-$300K | −$37.8-$63K | $142.2K-$237K |
| 6-10 | 2M (stable) | $480K | $180K | $300K | −$63K | $237K/year |
For simplicity, we'll use conservative average after-tax cash flow: Year 1-5: $120K/year; Year 6-10: $237K/year.
NPV and IRR Calculation: Full Cash Flow Table
Assumptions:
- Initial investment (Year 0): -$500K
- Years 1-5 after-tax cash inflow: $120K/year (conservative; assumes 1.5M average units)
- Years 6-10 after-tax cash inflow: $237K/year (at 2M units)
- Terminal salvage value (Year 10): $100K
- WACC (discount rate): 10.73%
- Depreciation: ignored in these cash flows for simplicity. In a full model, the depreciation tax shield ($50K a year × 21% = $10.5K) would raise each year's cash flow and the NPV.
| Year | Cash Flow | Discount Factor @ 10.73% | Present Value |
|---|---|---|---|
| 0 | −$500K | 1.000 | −$500K |
| 1 | $120K | 0.9031 | $108.4K |
| 2 | $120K | 0.8156 | $97.9K |
| 3 | $120K | 0.7366 | $88.4K |
| 4 | $120K | 0.6652 | $79.8K |
| 5 | $120K | 0.6007 | $72.1K |
| 6 | $237K | 0.5425 | $128.6K |
| 7 | $237K | 0.4899 | $116.1K |
| 8 | $237K | 0.4425 | $104.9K |
| 9 | $237K | 0.3996 | $94.7K |
| 10 | $237K + $100K (salvage) | 0.3609 | $121.6K |
| Total PV | $1,012.4K |
NPV Calculation:
NPV = Total PV of Inflows − Initial Investment
NPV = $1,012.4K − $500K = $512.4K
Interpretation: Positive NPV of $512.4K means the warehouse investment creates about $512K of value at a 10.73% cost of capital. Accept the project.
IRR Calculation
We're solving for the discount rate (r) where NPV = 0:
−$500K + Σ [Cash flows / (1+r)^t] + $100K/(1+r)^10 = 0
Using Excel IRR function or financial calculator on the cash flows above:
IRR ≈ 27.24%
Interpretation: The warehouse project returns about 27.2% a year. This is well above the WACC of 10.73%, so it's an attractive investment.
Payback Period
How long to recover the $500K investment?
Cumulative cash recovery: $120K/year for 5 years = $600K (covers $500K by Year 4.2)
Payback Period ≈ 4.2 years
For a consumer brand capex project, 4+ year payback is reasonable. Not too long; acceptable risk.
Decision Framework Summary
| Metric | Result | Decision |
|---|---|---|
| NPV @ 10.73% WACC | +$512.4K | Positive → Accept |
| IRR | 27.2% | IRR (27.2%) > WACC (10.73%) → Accept |
| Payback Period | 4.2 years | Reasonable for capex → Accept |
| Recommendation | Build the warehouse. Strong positive value creation. |
Common Mistakes in Capital Budgeting
1. Using Wrong Discount Rate (Not Calculating True WACC)
If you underestimate WACC (use 8% instead of true 10.7%), you overestimate NPV and accept mediocre projects. If you overestimate WACC, you reject good projects. Calculate WACC correctly using your actual cost of equity and debt.
2. Ignoring Tax Effects on Depreciation
Depreciation is tax-deductible but not a cash expense. Your after-tax cash flow = (before-tax savings) × (1 − tax rate). Forgetting this overstates cash flows and NPV.
3. Using Historical vs Incremental Cash Flows
Only count incremental cash flows from the project. If the warehouse cannibalizes some 3PL business (you still need 3PL for peak seasons), the true 3PL savings are lower than the headline savings. Don't count cash flows that would happen anyway.
4. Forgetting Working Capital Changes
If the warehouse requires $50K in additional inventory and tools to operate, that's cash you invest upfront. Include it in Year 0 cash flow. Similarly, if the project releases cash (e.g., less safety stock needed), add that back to terminal cash flow.
5. Using IRR Alone (Ignoring NPV When Comparing Projects)
IRR is a percentage; NPV is absolute value. A 30% IRR project that costs $100K creates less value than a 20% IRR project that costs $10M. Use NPV to rank projects.
6. Not Stress-Testing Assumptions
If NPV is $512K but assumes volume reaches 2M units, what if volume only reaches 1.5M? Run sensitivity analysis: vary volume, costs, and discount rate. If NPV stays positive in bad scenarios, the project is robust.
From One-Off Decisions to Repeatable Capital Processes
Most consumer brands make capital decisions ad hoc: "Should we buy the warehouse?" A founder scribbles numbers on a napkin. Some teams do spreadsheets. Very few do rigorous NPV/IRR analysis.
The cost of bad capital decisions is enormous. Overpaying for a warehouse, misjudging the discount rate, or ignoring tax effects can waste hundreds of thousands. The warehouse example showed about $512K of value creation. Get it wrong, and you destroy that value.
To make capital budgeting repeatable and accurate, you need:
- Clear WACC calculation: Based on your actual capital structure and cost of capital, reviewed annually.
- Multi-year cash flow projections: Linked to your revenue/volume forecasts and your operating cost model.
- Sensitivity analysis: What if your growth is 20% slower? What if capex overruns by 15%?
- Consistent discipline: Every capital decision >$100K goes through NPV/IRR review. No exceptions.
Turn capital budgeting from guesswork into financial rigor.
Niblin FP&A models build your cash flow forecast from the bottom up: revenue by channel, unit economics, working capital, capex needs, and terminal value. NPV and IRR follow automatically. When you have a capital decision, you have the analysis ready in days, not weeks.
See how Niblin models it
Key Takeaways
- NPV = present value of all future cash flows minus initial investment. Positive NPV = project creates value. Use NPV as your primary decision metric.
- IRR = the annualized return on a project. Accept projects if IRR > WACC (your cost of capital).
- WACC = (E/V × Cost of Equity) + (D/V × Cost of Debt × (1 − Tax Rate)). It's your hurdle rate for capital decisions.
- Cost of Equity (Re) = Rf + β × (Rm − Rf). Use current market inputs and a beta from comparable public companies.
- Discount rate matters enormously: small changes in WACC swing NPV by 10-20%. Calculate accurately.
- Warehouse vs 3PL illustrative example: $500K capex, 27.2% IRR, $512K NPV at 10.73% WACC → accept.
- Common mistakes: wrong discount rate, ignoring taxes, using historical instead of incremental cash, forgetting working capital, comparing projects by IRR instead of NPV.
Frequently Asked Questions
What is a good NPV for a capital project?
Any positive NPV creates value. But the magnitude matters for priority. Projects with NPV > 20% of initial investment are strong (e.g., $500K investment with $100K+ NPV). Projects with NPV < 5% of investment are marginal; accept only if strategic fit is clear.
How is WACC different from the discount rate I use for NPV?
WACC <strong>is</strong> your discount rate (in most cases). WACC reflects your average cost of capital: what equity investors require plus what debt holders require. Use WACC to discount cash flows in NPV calculations. For risky projects, you might use a higher discount rate (WACC + risk premium), but start with WACC.
How do I calculate cost of equity for a small private brand?
Use CAPM: Re = Rf + β × (Rm − Rf). Take the current risk-free rate, an expected market return, and a beta from comparable public companies. Illustrative example: Rf 4%, β 1.3, Rm 10% gives Re = 4% + 1.3 × 6% = 11.8%. Small private brands often add a size or company-specific premium.
Should I use NPV or IRR to make decisions?
Use NPV as your primary metric. Both say the same thing (accept if NPV > 0, equivalently if IRR > WACC), but NPV shows absolute value created. When ranking multiple projects, NPV is clearer. A 30% IRR project with $50K NPV might rank below a 18% IRR project with $500K NPV.
How do I account for taxes in capital budgeting?
Taxes affect cash flow in two ways: (1) You pay corporate taxes on operating profits, reducing after-tax cash. (2) Depreciation is tax-deductible but not cash, so it reduces taxable income. Use: After-tax Cash = (Savings − Operating Costs) × (1 − Tax Rate) + (Depreciation × Tax Rate). The second term is the tax shield.
What if my NPV is positive but payback period is >5 years?
Positive NPV is still good; accept the project. Payback period tells you how long until you recover cash. If payback is long (7+ years), the project is sensitive to risk: if the business changes or costs increase, you may not break even. Use both NPV and payback as sanity checks. Long payback + low margin of safety = higher risk.