Modeling expenses: Multifamily - Comprehensive Guide to Modeling Multifamily Real Estate Expenses

Fundamentals of Multifamily Real Estate Expenses

  • Multifamily Property Characteristics

    • Lease Terms: Generally defined as short-term, typically ranging from 11 to 22 years. While some may be slightly shorter or longer, this range is the standard benchmark.

    • Turnover Rates: Due to short lease durations, multifamily properties experience high turnover, often reaching approximately 50%50\% per year.

    • Asset Class Stability: Despite high turnover, it is viewed as one of the safest and most intuitive asset classes. Investors prioritize it because landlords can drive occupancy quickly by resetting rents almost overnight to meet market demand.

    • Renovation Opportunities: High turnover provides frequent windows for unit renovations. Upgrading units to increase rents is a core business strategy for many multifamily investors.

    • Profit Margins: After all operating expenses (OpEx) are accounted for, multifamily properties typically operate with a margin of 50%50\% to 70%70\%. This variance depends on location (urban vs. suburban) and building type (high-rise vs. low-rise).

The Detailed Expense Build-Out

  • Overview of the Expense Build: A standard model uses approximately nine expense line items. This provides sufficient detail to identify cost drivers without becoming overly complex.

  • 1. Repairs and Maintenance (R&M)

    • Relative Weight: Approximately 15%15\% of total operating expenses.

    • Definition: Includes all ongoing upkeep items required to maintain the property's condition.

    • Examples: Replacing light bulbs, repairing carpets, fixing backup plumbing (e.g., toilets), repairing broken AC units, servicing elevators, maintaining pools, landscaping, and snow removal (geographic dependent).

  • 2. Turnover Costs (Turn Costs)

    • Relative Weight: Approximately 4%4\% of total operating expenses.

    • Definition: Expenses incurred to prepare an apartment for a new tenant following the departure of a previous one, essentially making the unit "like new."

    • Activities: Cleaning carpets, changing locks and keys, touching up paint, and repairing broken appliances.

    • Cost Mitigation Strategies:

      • Reducing turnover by increasing tenant retention.

      • Securing master contracts with paint and cleaning companies to leverage economies of scale.

      • Selecting durable materials, such as choosing hardwood floors over carpet to reduce long-term maintenance costs despite higher upfront investment.

  • 3. Marketing (Leasing Costs)

    • Relative Weight: Approximately 3%3\% of total operating expenses.

    • Definition: Direct costs associated with attracting tenants.

    • Inclusions: Online advertising, physical flyers, promotional events, and referral fees (e.g., paying a tenant for referring a friend).

    • Exclusions: Rent concessions are not included in this bucket; marketing is a strictly operational expense, whereas concessions impact the revenue side (gross potential rent).

  • 4. General and Administrative (G&A)

    • Relative Weight: Approximately 7.5%7.5\% of total operating expenses.

    • Definition: A broad bucket for office-related expenses and professional services.

    • Examples: Computer hardware/software, telephone services, office supplies, staff training, bank charges, meals, entertainment, and recruitment expenses for new hires.

    • Professional Fees: Often includes legal and accounting fees, such as costs for eviction paperwork or annual financial audits.

  • 5. Payroll

    • Relative Weight: Approximately 20%20\% of total operating expenses (one of the largest line items).

    • Components: Salaries, wages, and benefits for on-site staff.

    • Staff Categories: Primarily split into Leasing Staff and Maintenance Staff.

    • Efficiency Strategies:

      • Optimizing staffing schedules (e.g., avoiding over-staffing the leasing office during slow hours).

      • Utilizing technology to automate tasks.

      • Sharing maintenance or leasing staff with nearby buildings managed by the same company to reduce individual property burdens.

  • 6. Management Fees

    • Relative Weight: Approximately 7.5%7.5\% of total operating expenses.

    • Calculation: Typically calculated as a percentage of rental income rather than a per-unit cost.

    • Rule of Thumb: 3%3\% of rental income for larger properties (defined as 100100 units or more). Smaller buildings may see fees range from 10%10\% to 12%12\%.

  • 7. Utilities

    • Relative Weight: Approximately 7.5%7.5\% of total operating expenses.

    • Inclusions: Gas, electricity, water, and sewage. May also include valet trash services, internet, and cable charges.

    • Income Opportunity: Owners may add a processing charge on top of utilities to create additional income. Many utilities are also reimbursable by tenants.

  • 8. Real Estate Taxes

    • Relative Weight: The largest single operating expense for almost any property.

    • Volatility: Highly dependent on local jurisdiction. Assessment values often change significantly upon the sale of a property, meaning historical tax data may not be a reliable predictor of future costs.

    • Expert Analysis: Investors frequently hire third-party tax consultants to estimate adjusted assessed values and determining the "burn-in" schedule (how long before the new tax rate takes effect).

  • 9. Property Insurance

    • Relative Weight: Approximately 3%3\% of total operating expenses.

    • Definition: The fixed cost of insuring the physical asset and liability.

Financial Statements and the Tagging Exercise

  • The Profit and Loss (P&L) Statement: Modeling typically involves looking at 1212 years of historical financial data. Real-world P&Ls contain hundreds of granular line items that must be "tagged" to fit the simplified model buckets.

  • Tagging Technique:

    • Assign a sequential ID (tag number) to each model category (e.g., Repairs and Maintenance = 77, Turn Costs = 88, etc.).

    • Apply these tags to the total lines in the granular historical P&L.

    • Dynamic Summing: Use the SUMIFS formula in Excel to aggregate all P&L lines marked with a specific tag into the model's simplified categories. This improves efficiency and allows for quick sorting of raw data.

  • Calculation Check: Always build a verification line to ensure the manually calculated Net Operating Income (NOI) matches the source P&L.

    • Formula Logic: IF(\text{Calculated NOI} = \text{P&L NOI}, "OK", "CHECK").

    • Rounding: Utilize the ROUND function to prevent errors caused by infinitesimal decimal differences in Excel.

Modeling Procedures and Financial Calculations

  • Historical Financials Tab

    • Trailing Three Months (T3): Take the sum of the last three months of expenses and multiply by 44 to annualize the figure: (Month 1+Month 2+Month 3)×4(\text{Month } 1 + \text{Month } 2 + \text{Month } 3) \times 4.

    • Trailing Twelve Months (T12): The sum of the last twelve months of data.

  • In-Place Expenses Section

    • Unlike revenues, expenses are informed by historicals but not necessarily driven by them. A new owner might bring in a new property manager or a different operating budget.

    • Per-Unit Calculations: Convert totals to per-unit numbers to compare against industry benchmarks.

      • Per Unit Cost=Annual ExpenseTotal Units\text{Per Unit Cost} = \frac{\text{Annual Expense}}{\text{Total Units}}

    • Standard Assumptions Used in Model:

      • Repairs and Maintenance: $400\$400 per unit.

      • Turnover: $150\$150 per unit.

      • Marketing: $150\$150 per unit (budgeting higher to drive occupancy).

      • G&A: $250\$250 per unit.

      • Payroll: $600\$600 per unit.

      • Utilities: $300\$300 per unit.

      • Property Insurance: $200\$200 per unit.

      • Real Estate Taxes: Hard-coded at $400,000\$400,000 annually based on anticipated assessment changes.

Capital Reserves and Strategic Management

  • Capital Reserves (Replacement Reserves)

    • Definition: Funds set aside periodically for the replacement of short-term capital items like HVAC units, roofs, or parking lot paving.

    • Driver: Often required by lenders.

    • Standard Amount: $200\$200 per unit per year.

    • The Accounting Debate:

      • Sellers/Brokers: Often exclude capital reserves from OpEx to show a higher NOI and higher valuation.

      • Buyers: Often include capital reserves in OpEx to be conservative in their NOI calculation.

    • Compromise: The model includes them in total expenses but keeps them as a separate line item for visibility.

Pro Forma Growth and Forecasting Logic

  • Growth Assumptions

    • Standard Operating Expenses: 0%0\% (Year 1), 2%2\% (Year 2), 3%3\% (Year 3+).

    • Real Estate Taxes: Often grown separately due to their size. Logic: 0%0\% (Year 1), 3%3\% (Year 2+).

  • Growth Frequency: Unlike revenues (which may grow monthly), expenses are modeled to grow annually. This reflects the reality of annual service contracts and tax cycles.

  • Management Fee Forecasting: Driven by a fixed percentage (e.g., 3%3\%) of the forecasted Monthly Total Rental Income.

  • Formula for Pro Forma Growth: Use an INDEX MATCH function to pull the appropriate growth rate based on the model year.

    • New Expense=Previous Expense×(1+Growth Rate)\text{New Expense} = \text{Previous Expense} \times (1 + \text{Growth Rate}).

  • Net Operating Income (NOI) Calculation:

    • NOI=Total Income−Total Operating Expenses\text{NOI} = \text{Total Income} - \text{Total Operating Expenses}