# Office Building Model Build an office building model for acquisition underwriting, asset management, or refinancing analysis with tenant-level rent rolls, expense recoveries, and capital expenditure scheduling. - Canonical: https://finamodel.com/templates/office-building-model - Excel download: https://finamodel.com/templates/office-building.xlsx - Category: Real Estate - Model type: Underwriting - Difficulty: Intermediate - Audiences: Developers & sponsors, Investors & analysts, Real Estate Investors, Office Landlords, REIT Analysts, Property Managers - Tags: office, commercial-real-estate, noi, cap-rate, lease-up ## Overview An Office Building Investment Model projects the financial performance of a Class A or Class B office asset (100K-500K rentable SF, $20-100M acquisition price) through a multi-year lease-up, stabilization, and exit. The model captures tenant mix (tenant count by lease rate and expiration schedule), rental rate growth (2-4% annually in stable markets, 1-3% in slower submarkets), occupancy (ramping from 70% lease-up year to 95% stabilized), tenant improvement (TI) allowances ($30-60/SF on new leases, a cash cost), and leasing commissions (5-6% of lease value, to brokers). Operating expenses (property tax at 12-15% of revenue, insurance 3-5%, maintenance 4-6%, management 3-5%, utilities 2-4%, other 2-3%) typically stabilize at 35-45% of revenue, yielding 55-65% NOI margin characteristic of institutional office properties. The Tenant_Schedule lists major tenants by unit, SF, lease rate ($/SF/year), and expiration. GPR derives from occupied SF × lease rate; vacancy loss (5% stabilized, 15-20% during lease-up) is applied to produce effective gross income (EGI). TI and leasing costs flow directly to Cash Flow (not capitalized to the asset in this model) and represent cash drains during aggressive lease-up. Operating_Expenses are tied to EGI and escalate annually at 2.5% inflation (CPI-linked). The Debt_Schedule models a senior mortgage (typically 60-70% LTV at stabilized NOI, fixed-rate 5.75-6.75%, 10-year amortization), with annual debt service (interest + principal) flowing from NOI. Exit Value is computed as Year 5+1 forward NOI / exit cap rate (typically 50-100 bps compression from entry cap, reflecting market cycles). Equity returns depend on entry cap, rent growth, expense control, and exit multiple assumptions - all moderately sensitive for office assets (post-2020 working-from-home dynamics have compressed office valuations). This model applies to REIT investors, institutional property managers, and opportunistic buyers evaluating office repositioning. Typical going-in cap rates for Class A stabilized office are 4.5-5.5%; Class B value-add is 5.5-6.5%. Levered IRR targets are 8-12% (mature/stabilized office), while value-add or lease-up scenarios target 12-16%. Key sensitivities include leasing velocity (time to achieve stabilized occupancy), achievable lease rates (tenant demand, local supply), and exit cap rate (sensitive to interest rate cycle and sector health). ## What's included - Multi-tenant rent roll with escalation and rollover logic - Expense recovery modelling for NNN, full service, and modified gross leases - Tenant improvement and leasing commission schedules - Debt service and levered cash flow analysis - Exit cap rate sensitivity and return outputs - Building specifications: rentable area, floor count, amenities - Lease portfolio: tenant mix, lease rates, expiration schedule - Occupancy rates and lease-up assumptions for vacant space - Rental rate growth assumptions by market and tenant strength - Operating expenses: property tax, utilities, maintenance, property management - NOI calculation and cap rate-based valuation ## Office Building Model: How the Multi-Tenant Underwriting Template Works This office building model structures a ten-year institutional hold for a multi-tenant Class A asset, connecting tenant-level rent rolls, expense recoveries, debt sizing, waterfall promotes and after-tax returns. It is designed for readers evaluating how such a template organises acquisition underwriting, asset management and refinancing analysis. ### Operating Drivers Built Into the Assumptions The model centres on a small set of operating drivers. A Rent Roll anchors five tenants, with square footage driven by a tenant mix block, lease escalations, expiry dates, blended rent per square foot and weighted average lease term. - A single scenario switch flexes market rent growth, stabilised occupancy, operating expense escalation and the exit cap rate across base, downside and upside cases. Financing inputs separate loan term from hold period and set an interest-only window, while property tax includes an acquisition-time reassessment multiplier. - Because these drivers sit in one assumptions area, changing a single input flows through the ten-year cash flow rather than being re-keyed sheet by sheet. ### How Rent Rolls, Revenue and Costs Flow Together Revenue builds potential gross income from base rent, then applies downtime loss on expiring space, free rent, recovery income and parking. Vacancy and credit loss are deducted once from that total to reach effective gross income, so the two adjustments cannot double-count individual line items. - Recoverable operating expenses are grossed up toward a target occupancy, with a floor that only ever increases recoveries modestly. On rollover, expiring tenants either renew or step to market rent with a downtime haircut. - Turnover is driven by a single average lease term input that splits space between new and renewal deals, feeding tenant improvements, leasing commissions and reserves. ### Debt Sizing, Cash Flow and Exit Value The debt schedule computes a level-payment annuity once on the original loan, then splits each year between interest and principal, with no principal during the interest-only period. A balloon payoff is forced at loan maturity, and the loan term is independent of the hold period so a refinancing can be represented by extending it. - Debt service coverage, debt yield and current loan-to-value ratios sit alongside the schedule. On the cash flow statement, acquisition costs and initial leasing capital combine with financing and a yearly operating walk. - Exit value is calculated forward off exit-year NOI, with a trailing cap value shown as a memo, and net proceeds feed levered and unlevered IRRs, equity multiples and yield on cost. ### Waterfall, Tax and Sensitivity Analysis A GP/LP waterfall uses three capital-account balances that accrete each year at the preferred rate and two higher hurdle rates, drawn down by distributions so the preferred return accrues on the declining unreturned balance. Distributions are allocated across four tiers: a return of capital plus preferred return shared pro-rata, a catch-up bracket, then 80/20 and 70/30 splits above the higher hurdles. - The promote is carved out of the LP slice, letting the GP recover its co-investment pro-rata and earn promote on top. A tax sheet applies straight-line depreciation over thirty-nine years, interest deductibility, capital gains and depreciation recapture at exit, producing an after-tax IRR. - Sensitivity tables show an analytic levered IRR proxy across exit cap rate and rent growth. ## Built for commercial office underwriting Use this model when you need to evaluate an office acquisition, track tenant rollover risk, or analyse the impact of vacancy and re-leasing on property returns. ## Handles real lease structures A useful office building model should reflect how different lease types, expense recoveries, and tenant improvement costs affect net cash flow at the property level. ## Better for institutional-quality analysis This gives you a structured underwriting framework instead of a simplified NOI spreadsheet that ignores leasing costs and recovery mechanics. ## Built for commercial office underwriting Use this model when you need to evaluate an office acquisition, track tenant rollover risk, or analyse the impact of vacancy and re-leasing on property returns. ## Handles real lease structures A useful office building model should reflect how different lease types, expense recoveries, and tenant improvement costs affect net cash flow at the property level. ## Better for institutional-quality analysis This gives you a structured underwriting framework instead of a simplified NOI spreadsheet that ignores leasing costs and recovery mechanics. ## Features - **Tenant roll analysis:** Track lease expirations year-by-year and model re-leasing rates, renewal at market rates, and tenant turnover costs. - **Expense modeling:** Break out operating expenses by category and apply inflation rates. Benchmark against comparable buildings for realism. - **Exit scenarios:** Model stabilized NOI and apply different exit cap rates (current, underwritten, market) to show value range and sensitivity. ## Use cases - **Acquisition due diligence:** Analyze tenant creditworthiness, lease rates vs. market, and occupancy to assess value and refinancing/sale risk. - **Asset management and value-add:** Identify rent growth, expense control, and lease renewals as levers to increase NOI and building value. - **Financing and refinancing:** Use stabilized NOI to calculate debt service coverage and loan-to-value, informing loan size and rate. ## Frequently asked questions ### What is an office building financial model? It is a model used to forecast rental income, operating expenses, capital costs, and investment returns for commercial office properties. ### What should an office building model include? It should include a tenant-level rent roll, expense recovery logic, TI/LC schedules, debt service, and return metrics such as IRR and equity multiple. ### Who uses office building models? Real estate investors, acquisition teams, asset managers, and lenders use them for underwriting, performance tracking, and refinancing analysis. ### What are TI and LC costs? Tenant improvements (TI) are capital costs to build out a tenant space. Leasing commissions (LC) are fees paid to brokers for securing leases. Both affect net cash flow and returns. ### Can it handle different lease types? Yes. The model supports NNN, full service gross, and modified gross lease structures with appropriate expense recovery logic for each. ## Related templates - [Mixed-Use Real Estate Development](https://finamodel.com/templates/mixed-use-model) - [Retail Centre Operating and Development Model](https://finamodel.com/templates/retail-centre-model) - [Industrial Warehouse and Logistics Real Estate Model](https://finamodel.com/templates/industrial-warehouse-model)