Annual Budget Engine

Input Schema

Required Inputs

Recommended Inputs

Optional Inputs

Process

Step 1: Executive Summary

Produce a concise executive summary:

• Total proposed budget, YoY change ($ and %)
• Operating cost per SF/unit
• Top 3 strategic initiatives
• Key assumptions and risks
• Expected NOI impact

Step 2: Line-Item Budget with IREM/BOMA Benchmarks

Build a detailed line-item budget table with columns:

Category | Prior Budget | Prior Actual | Variance ($ / %) | Proposed Budget | YoY Change | IREM Median $/SF | IREM 25th Pctile | Gap vs. Median | Justification

For each line item:

• Show the property's $/SF alongside IREM median $/SF and IREM 25th percentile (best-in-class)
• Flag any item where the property exceeds IREM median by >10% as "ABOVE BENCHMARK -- explanation required"
• Flag any item below IREM 25th percentile as "POTENTIAL UNDER-SPENDING -- service risk"

Note: if user provides actual IREM/BOMA data, use it. Otherwise, use commonly referenced ranges by property type and market tier. Label which figures are user-provided vs. estimated.

Subtotal by category: administrative, maintenance/R&M, utilities, insurance, taxes, management, reserves.

Step 3: Component-Specific Escalators

Replace generic across-the-board escalation with component-specific escalators sourced from relevant indices:

For each line item show: prior year actual, escalation source, escalation rate, proposed budget amount.

Step 4: Variance Analysis

For every line item with >5% or >$10K deviation between prior budget and prior actuals:

• Root cause identification (specific, not generic)
• Controllable vs. uncontrollable classification
• Corrective actions taken or proposed
• Impact on proposed budget assumptions

Step 5: NOI Sensitivity Grid (3x3)

Identify the 3 largest controllable expense categories (typically R&M, contract services, utilities or payroll). Build a 3x3 grid:

Scenario        Cat 1 Impact    Cat 2 Impact    Cat 3 Impact    Total NOI Variance
All at -5%      +$X             +$X             +$X             +$X (+X% NOI)
All at base     $0              $0              $0              $0
All at +5%      -$X             -$X             -$X             -$X (-X% NOI)
Mixed worst     +$X (ok)        -$X (high)      -$X (high)      -$X

Show the range of NOI outcomes from best to worst controllable expense performance.

Step 6: Budget-to-Value Linkage

Translate budget variances into property value impact using the cap rate:

Formula: Value impact = NOI variance / cap rate

Present as: "$1/SF opex overrun at a X% cap rate = $Y/SF value destruction."

Build a table:

Budget Overrun    NOI Impact      Value Impact (at X% cap)    Value Impact/Unit or /SF
+2% opex          -$X/year        -$X                          -$X/unit
+5% opex          -$X/year        -$X                          -$X/unit
+10% opex         -$X/year        -$X                          -$X/unit

Step 7: Reserve Adequacy Test

For each major building system, calculate:

System      Age    EUL    RUL    Replacement Cost    Reserve Needed/yr    Current Reserve    Gap
HVAC        Xyr    20yr   Xyr    $X                  $X/year              $X total           ($X)
Roof        Xyr    25yr   Xyr    $X                  $X/year              $X total           $X
Elevators   Xyr    25yr   Xyr    $X                  $X/year              $X total           ($X)
Parking     Xyr    15yr   Xyr    $X                  $X/year              $X total           $X

• Use ASHRAE expected useful life data for system EUL defaults
• Flag any system where the gap is negative (reserve shortfall)
• Quantify the annual increase needed to close the gap by replacement date
• Use 3% annual cost escalation rate as default for future replacement costs

Step 8: Zero-Based Comparison (Optional)

If zero_based_mode is enabled or if variance analysis reveals systematic over-spending:

Rebuild selected controllable categories from zero:

Category        Prior Actual    Escalated Budget    Zero-Based Budget    Variance    Action
Janitorial      $X              $X (+3%)            $X (re-bid)          -$X         Re-bid contract
Security        $X              $X (+3%)            $X (tech upgrade)    -$X         Camera + reduced guard
Landscaping     $X              $X (+3%)            $X (reduced scope)   -$X         Evaluate scope

Compare the zero-based result to the escalation-based result. Where zero-based is lower, flag legacy inefficiency.

Step 9: Performance Benchmarking

NCREIF NPI Comparison: Compare property-level returns to NPI for same property type and region: total return, income return, capital return, same-store NOI growth. User inputs their NCREIF figures or skill uses commonly published summary statistics.

Same-Store NOI Growth: Calculate YoY same-store NOI growth. Compare to: (a) NCREIF NPI, (b) CPI, (c) property's own 3-year trend. Flag if negative or trailing CPI for 2+ years.

Opex Ratio Trending: Calculate opex/EGI for current year and trailing 3 years. Compare to IREM benchmarks. Decompose trend into revenue-driven vs. expense-driven components.

Capital Intensity: Capex as % of NOI for current year and trailing 3 years. Benchmarks: MF 15-25%, office 10-20%, industrial 5-15%. Flag if >25% for 2+ years.

Obsolescence Test: Score functional and economic obsolescence risk as Low/Moderate/High based on building age, design, and market trends. If Moderate or High, budget should include competitive repositioning reserve.

Marginal Return on Equity: Calculate IRR on each incremental dollar of equity deployed (capex, TI). Compare to property yield and investor opportunity cost. Flag dead equity if marginal return < opportunity cost for 2+ years.

Step 10: IC Challenge Q&A

Pre-build 5 investment committee challenge questions with prepared answers, customized to the property's specific budget drivers:

1. "Why are expenses up X% when inflation is only Y%?" -- Decompose variance into market-driven (insurance, taxes, utilities) vs. controllable. Quantify each driver.

2. "What happens to NOI if occupancy drops 5 points?" -- Show revenue impact, partially offset expense savings, and net NOI impact.

3. "Why is R&M so high compared to BOMA benchmarks?" -- Cite building age, deferred items, specific system issues, and consequence of cutting R&M.

4. "Can we defer $X of capital and still maintain the asset?" -- Identify deferrable (cosmetic, non-critical) vs. non-deferrable (life safety, code, roof/envelope). Quantify deferral value risk.

5. "What is your confidence level in this budget?" -- Assign confidence band (+/- 3% revenue, +/- 5% controllable, +/- 15% insurance/tax if pending). Identify top 2 line items most likely to miss.

Step 11: Strategic Recommendations

Produce 3-5 recommendations, each with:

• Initiative description
• Estimated annual savings
• Implementation cost
• Payback period
• Complexity (low/medium/high)
• Risk to service levels
• Timeline

Output Format

Present results in this order:

1. Executive Summary -- total budget, YoY change, cost per SF/unit, top initiatives
2. Line-Item Budget with Benchmarks -- full table with IREM columns and flags
3. Component-Specific Escalator Detail -- source, rate, rationale per line item
4. Variance Analysis -- root cause for material variances
5. NOI Sensitivity Grid -- 3x3 controllable expense grid
6. Budget-to-Value Linkage -- opex overrun translated to value destruction
7. Reserve Adequacy Test -- system-by-system reserve analysis
8. Zero-Based Comparison (if enabled) -- escalated vs. zero-based side-by-side
9. Performance Benchmarking -- NCREIF, same-store NOI, opex ratio, capital intensity
10. IC Challenge Q&A -- 5 questions with data-backed answers
11. Strategic Recommendations -- initiatives with ROI and payback

Red Flags & Failure Modes

• Generic escalation: never apply "3% across the board." Every line item gets its own sourced escalator.
• Missing benchmarks: if IREM/BOMA data is not available, clearly label estimated ranges. Do not present estimates as authoritative benchmarks.
• Reserve shortfall ignored: if the reserve adequacy test shows a negative gap, the budget must address it. Ignoring reserve shortfalls is the most common path to deferred maintenance crises.
• Opex ratio creep: if the opex ratio is trending up for 3+ years while EGI is stable, the budget has a structural expense problem that escalation-based budgeting will not fix. Recommend zero-based review.
• Value destruction blind spot: every dollar of opex overrun destroys $1/cap_rate of property value. If ownership does not see the budget-to-value linkage, they will not take expense discipline seriously.

Chain Notes

• Upstream: rent-roll-analyzer provides revenue-side data. market-memo-generator provides escalation assumptions.
• Downstream: property-performance-dashboard uses this budget as the variance analysis benchmark. sensitivity-stress-test consumes budget NOI.
• Peer: deal-underwriting-assistant shares T-12 normalization methodology.