End-to-End Capital Expenditure Model: 35,000 m² High-Tech Eco-Apparel Plant (48 Modular Lines + Integrated Utilities)
| Scenario | NPV ($) | IRR (%) |
|---|---|---|
| Base Case Model | +$1,845,200 | 15.65% |
| +10% CAPEX ($15.95M) | +$526,400 | 11.82% |
| -10% Garment Margin | +$384,100 | 11.24% |
| 4-Month Launch Delay | +$962,800 | 12.91% |
1. Fundamental Equation: The Internal Rate of Return (IRR) is the unique discount rate r that forces the cumulative Net Present Value (NPV) of all capital cash outflows and operating inflows to equal exactly zero:
2. Numerical Solution via Trial Interpolation: Because r cannot be isolated algebraically from a 7th-degree polynomial, it is solved via numerical iteration or linear interpolation between two trial discount rates:
1. Analytical Objective: Stress testing isolates the project's vulnerability by perturbating the 3 primary independent risk drivers individually while holding all other variables constant.
Impact: NPV declines by $1,318,800 to +$526,400; IRR compresses from 15.65% to 11.82%.
Executive Takeaway: High capital buffer. Even after absorbing a massive $1.45M unbudgeted cost overrun (completely exhausting the $850k contingency and requiring an extra $600k), IRR remains strictly higher than both WACC (10.0%) and the Board hurdle rate (11.5%). The project does not destroy shareholder value.
Impact: NPV contracts by $1,461,100 to +$384,100 (-79.2% drop); IRR drops to 11.24%.
Executive Takeaway: Highest Sensitivity Risk Driver (Tornado Rank 1). Margin deflation degrades returns faster than construction cost overruns. Mitigation requires forward-locking 24-month fixed volume and FOB pricing off-take contracts with Tier-1 buyers before financial close.
Impact: NPV contracts by -$882,400 to +$962,800; project IRR remains robust at 12.91% (safely above the 10.0% WACC hurdle).
Executive Takeaway: Schedule slippage carries lower terminal damage than margin deflation because production cash flows are deferred rather than permanently lost. The project can absorb up to +8.5 Months of launch delay before project NPV breaches zero.
Simultaneous multi-variable sensitivity evaluating Net Present Value (NPV @ 10% WACC) and Internal Rate of Return (IRR). Hover any cell for calculation step breakdown:
| Rank | Risk Variable | Base Value | Tested Variance | Impact on NPV (ΔNPV) | Sensitivity Elasticity (ε) | Switching Value (Breakeven) |
|---|---|---|---|---|---|---|
| 1 | Garment Gross Margin | $1.36 / unit | -10.0% | -$1,461,100 (-79.2%) | +7.92 | -12.6% ($1.19/pc) |
| 2 | Total Greenfield CAPEX | $14,500,000 | +10.0% | -$1,318,800 (-71.5%) | -7.15 | +14.0% ($16.53M) |
| 3 | Commercial Launch Delay | Month 14 COD | +4 Months | -$882,400 (-47.8%) | -$220.6k / mo | +8.5 Months (Mo 22.5) |
| 4 | Biomass vs HFO Savings | $780,000 / yr | -10.0% | -$349,600 (-18.9%) | +1.89 | -52.8% ($368k/yr) |