Operational Stream
Component 3: Project IRR & NPV Table
The NPV Table uses the Discount Factor Method to calculate the Project IRR (Internal Rate of Return). This table consolidates all cash flows from development, pre-operating, and operational phases into a single comprehensive view, enabling investors to assess project viability and compare against required return thresholds.
Overview
The Project IRR represents the unlevered return on the project, independent of financing structure. It answers the fundamental question: "What return does this project generate on every dollar invested, regardless of how it's financed?"
Key Output Metrics
- •Project IRR (%): The annualized return rate that makes NPV = 0
- •Equity Multiple: Total cash returned ÷ Total equity invested
- •Payback Period: Time (in months) until cumulative cash flow turns positive
- •Terminal Value: Exit value at end of hold period
Project Timeline Structure
The NPV Table spans the entire project lifecycle, divided into three distinct phases:
Phase 1: Development (M0–M36)
The construction period where all capital expenditure occurs. Duration is user-defined in Component 1 (typically 24–48 months depending on project scale).
- Land acquisition costs (M0)
- Construction costs (phased via S-Curve)
- Soft costs, FF&E, and POWC
- No operating income during this phase
Phase 2: Pre-Operating (M37–M42)
FIXED ASSUMPTIONFixed 6-Month Buffer: FeasiBuild applies a mandatory 6-month pre-operating period between construction completion and revenue generation. This period is not user-adjustable and represents industry-standard time required for:
- Staff recruitment and training
- Systems commissioning and testing
- Marketing and pre-opening activities
- Regulatory approvals and inspections
- Soft opening and operational readiness
Why Fixed? Industry analysis shows that rushing to revenue without adequate pre-operating preparation leads to operational issues, poor guest experiences, and revenue shortfalls in the critical first year. The 6-month buffer ensures realistic projections.
Phase 3: Operations (M54–M162)
The operational period where the asset generates revenue. Cash flows are shown at year-end months (M54, M66, M78... M162) representing 10 years of stabilized operations.
- Net Income from P&L (Component 2)
- + Depreciation (non-cash add-back)
- - Change in Working Capital
- = Net Cash Flow from Operating Activities
- Terminal Value at M162 (exit)
NPV Table Structure
The table is organized into three main sections, each capturing different types of cash flows:
Cash Flows from Operating Activities
Cash Flows from Development Activities
Summary & Valuation Rows
Terminal Value Calculation
The Terminal Value represents the project's exit value at the end of the hold period (M162 / Year 13). This is typically the largest single cash flow in the model and significantly impacts the Project IRR.
Formula
Example Calculation
⚠️ Important Notes
- Terminal Value is calculated using unlevered NOI (before debt service)
- Exit Cap Rate should reflect market conditions at expected exit date
- Higher cap rates = Lower terminal value (inverse relationship)
- Terminal Value typically represents 60-80% of total project value
- Sensitivity analysis on exit cap rate is critical for risk assessment
Discount Factor Method
The Discount Factor Method converts future cash flows into present value terms, enabling comparison of cash flows occurring at different times.
Formula
How It Works
- The model iteratively tests different IRR rates
- For each rate, it calculates the Discount Factor for every month
- Each month's Net Cash Flow is multiplied by its Discount Factor
- All Discounted Cash Flows are summed to get NPV
- The IRR is the rate where NPV = 0
Example: Month 54 (Year 4 FYE)
Key Assumptions & Inputs
The Project IRR calculation depends on several critical assumptions from previous components:
From Component 1
- Construction period (months)
- Total Development Costs
- S-Curve phasing profile
- FF&E and renovation costs
From Component 2
- 10-year operating P&L
- Net Income by year
- Depreciation schedule
- Working capital changes
From Component 3
- Exit Cap Rate (default: 7%)
- Hold period (years)
- Exit timing
Fixed Assumptions
- 6-month pre-operating buffer
- Year-end operational cash flows
- Monthly discounting (not annual)
Interpreting the Results
Understanding what the Project IRR tells you about your investment:
Project IRR vs. Required Return
Compare your Project IRR against your required return threshold (hurdle rate):
Typical IRR Benchmarks
💡 Pro Tips
- Always run sensitivity analysis on exit cap rate (±50 bps)
- Test construction cost overruns (±10-15%)
- Model revenue shortfalls (Year 1-3 occupancy ramp)
- Consider interest rate sensitivity if using debt
- Compare Project IRR vs. Equity IRR to understand leverage impact