Mid-America Apartment Communities logo
Mid-America Apartment Communities Financial Model

Real Estate Company Financials Example (Free Excel Download)

Mid-America Apartment Communities, Inc. (MAA) is a self-administered and self-managed real estate investment trust (REIT) that focuses on acquiring, owning, developing, and managing multi-family residential apartment communities primarily in the Sunbelt region of the United States.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model provides a comprehensive equity valuation and operational forecast for Mid-America Apartment Communities (MAA), enabling an equity research analyst to project Funds From Operations (FFO), Adjusted Funds From Operations (AFFO), and Net Asset Value (NAV) based on Sunbelt apartment supply dynamics, lease pricing trends, and development pipeline yields.

Mid-America Apartment Communities, Inc. (MAA) is a self-administered and self-managed real estate investment trust (REIT) that focuses on acquiring, owning, developing, and managing multi-family residential apartment communities primarily in the Sunbelt region of the United States. The company operates an asset-heavy business model, generating returns through rental income and capital appreciation of its real estate portfolio.

Business segments include:

  • Same Store (approximately 95% of total revenues): Established communities owned and stabilised for at least a full year.
  • Non-Same Store and Other (approximately 5% of total revenues): Recently acquired communities, properties in development or lease-up, properties identified for disposition, and non-multifamily commercial activities.

Key geographies include high-growth Sunbelt markets such as Dallas, Atlanta, Orlando, Charlotte, and Tampa. MAA holds a strong competitive position as one of the largest owners of apartments in the United States, competing with other major multi-family REITs like Camden Property Trust, AvalonBay Communities, and Equity Residential. Recent major events include a CEO transition planned for April 2025 and the navigation of peak new apartment supply deliveries in its core markets throughout 2024.

The downloadable Mid-America Apartment Communities financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.

A turnkey financial model

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

Historicals & AssumptionsMid-America Apartment Communities financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$1.78B$2.02B$2.15B$2.19B$2.21B
General and administrative expenses$52.9M$58.8M$58.6M$56.5M$54.8M
Operating expenses, excluding real estate taxes and insurance$404.3M$435.1M$461.5M$502.7M$518.9M
Net income$533.8M$637.4M$552.8M$527.5M$446.9M

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
7.0%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
2.8%
D&A % of revenue
28.8%
Effective tax rate
1.3%
See 8 more
Capex % of revenue
3.0%
Net working capital % of revenue
0.0%
Other assets % of revenue
500.0%
Other liabilities % of revenue
263.7%
Annual debt paydown
0.0%
Interest rate on debt
4.5%
Dividend payout ratio
90.0%
Buybacks % of net income
0.0%

How to build a detailed financial model for Mid-America Apartment Communities

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

Revenue Deep Dive

Same Store Segment

  • Segment name: Same Store
  • Revenue driver formula: Total Same Store Units x Average Physical Occupancy % x Average Effective Rent per Unit x 12 months + Other Property Revenues (fees and reimbursements)
  • Historical growth rate: 0.5% to 13.5% over the last 3 years (highly volatile due to post-pandemic rent surges followed by recent supply-driven cooling; 2024 revenue declined 0.2% in Q4 but grew 0.5% for the full year).
  • Key growth levers and headwinds: Driven by job growth and migration to the Sunbelt (levers) offset by record levels of competing new multi-family supply deliveries (headwinds).
  • Pricing dynamics: Short-term residential leases (typically 12 months). Pricing is highly dynamic, driven by daily pricing software that balances occupancy and rent growth. New lease pricing and renewal lease pricing are tracked separately.
  • Revenue recognition notes: Rental income is recognised on a straight-line basis over the lease term.
  • Seasonality: The spring and summer months (Q2 and Q3) are the strongest for leasing volume and rent growth, while Q4 and Q1 typically see slower traffic and lower pricing power.

Non-Same Store and Other Segment

  • Segment name: Non-Same Store and Other
  • Revenue driver formula: (Development Units in Lease-Up x Occupancy x Rent) + Commercial Revenue
  • Historical growth rate: Varies significantly based on acquisition and disposition volume (e.g., grew 44.7% in 2024 due to new developments stabilising and recent acquisitions).
  • Key growth levers and headwinds: Driven by the timing of development completions, lease-up velocity, and capital deployment into new acquisitions.
  • Pricing dynamics: Lease-up properties often require higher initial concessions (e.g., one month free rent) to drive initial occupancy.
  • Revenue recognition notes: Similar to Same Store, but includes capitalised interest and operating costs during the pre-stabilisation development phase.
  • Seasonality: Less dependent on seasonal leasing and more dependent on the specific delivery dates of construction projects.

Cost Structure

Variable Costs / COGS

As a REIT, MAA does not report traditional COGS. Instead, it reports Property Operating Expenses.

  • Line-by-line breakdown: Real estate taxes, property insurance, personnel costs (on-site staff), repair and maintenance, utilities, and marketing.
  • Gross margin range: Net Operating Income (NOI) margin serves as the equivalent metric, typically ranging from 62% to 65%.
  • Key input costs and commodity exposures: Highly exposed to local property tax assessments and property insurance rates (especially in coastal or storm-prone Sunbelt markets).
  • How COGS scales with revenue: High operating leverage. Real estate taxes and insurance are largely fixed, meaning incremental rent growth drops almost entirely to the NOI line.

Operating Expenses

  • Property Management Expenses: Costs associated with regional supervision and corporate support for properties.
  • General and Administrative (G&A): Corporate overhead, executive compensation, and public company costs. Typically runs at 1.5% to 2.5% of total revenues.
  • Depreciation and Amortisation: Extremely high as a percentage of revenue (often 25% to 30%) due to the asset-heavy nature of real estate. This is a non-cash charge and is added back to calculate FFO.
  • Stock-Based Compensation: Included within G&A; relatively small but must be tracked for Core FFO adjustments.
  • Casualty Losses/Gains: Occasional one-time items related to hurricane or winter storm damage (e.g., clean-up costs).

Margin Profile

  • NOI Margin: 62% to 65% historically.
  • Margin trend: Currently facing slight compression (Same Store NOI projected to decline 1.15% at the midpoint in 2025) because property operating expenses (growing at ~3.2%) are outpacing flat revenue growth (projected at ~0.4%).
  • Segment-level margins: Same Store margins are highly predictable; Non-Same Store margins are lower during lease-up phases due to marketing costs and lower initial occupancy.

Balance Sheet Structure

  • Total assets: Approximately $11 billion to $12 billion, dominated by real estate.
  • Key asset categories: Real estate assets at cost (land, buildings, improvements), less accumulated depreciation. Cash and cash equivalents, and escrow deposits.
  • Goodwill & intangibles: Minimal. REITs typically allocate acquisition purchase prices directly to tangible property and in-place leases.
  • Working capital profile:
  • Days Sales Outstanding (DSO): Near zero. Rent is due on the first of the month.
  • Days Inventory Outstanding (DIO): Not applicable.
  • Days Payable Outstanding (DPO): 15 to 30 days for routine vendor payments.
  • Net working capital: Typically negative. The company collects cash upfront and pays expenses in arrears, providing a slight working capital benefit.
  • PP&E: Represents the core apartment portfolio. Useful lives are typically 40 years for buildings and 5 to 15 years for improvements.
  • Right-of-use assets / operating leases: Immaterial for this business model (MAA owns its real estate fee simple in most cases).

Capital Expenditure & Investment

  • Capex as % of revenue: Typically 8% to 12% in total, but split distinctly between maintenance and growth.
  • Maintenance capex vs. growth capex:
  • *Routine Capital Expenditures*: Turnover costs (carpet, paint) and exterior maintenance.
  • *Redevelopment/Growth Capex*: Kitchen/bath upgrades that drive a specific ROI (e.g., higher rent premiums).
  • *Development Capex*: Funding for ground-up construction.
  • Major capex programmes underway: As of late 2024, MAA had seven communities under development (2,312 units) with $374.3 million in funding remaining.
  • Capitalised software / development costs: Immaterial compared to real estate development.
  • M&A pattern: Opportunistic acquirer and active portfolio recycler. MAA frequently sells older assets (e.g., disposing of two communities for $85 million in Q4 2024) and recycles capital into new developments or newer acquisitions (e.g., acquiring a 386-unit Dallas property).
  • Typical acquisition multiple paid: Usually evaluated on a nominal cap rate basis (historically 4.5% to 5.5% depending on the market).

Debt & Capital Structure

  • Total debt: Approximately $4.5 billion to $5.0 billion.
  • Debt/EBITDA ratio: Exceptionally strong at 4.0x Net Debt to EBITDAre as of Q4 2024.
  • Credit rating: A- or better from major rating agencies (one of the highest rated apartment REITs).
  • Key debt instruments: Unsecured senior notes (bonds) and an unsecured revolving credit facility.
  • Maturity profile: Average maturity of 7.3 years as of late 2024.
  • Interest rate profile: 95% fixed rate debt, with a highly attractive effective interest rate of 3.8%.
  • Covenants: Standard REIT covenants (Total Debt to Total Assets < 60%, Secured Debt to Total Assets < 40%, Fixed Charge Coverage > 1.5x). MAA operates well within all limits.
  • Share repurchase programme: Active opportunistically, but not the primary return of capital.
  • Dividend policy: Consistent dividend payer. Payout ratio is typically 60% to 70% of Core AFFO, providing a secure yield and room for dividend growth.

Cash Flow Characteristics

  • Operating cash flow conversion: Very high. OCF closely tracks FFO.
  • Free cash flow margin: AFFO (which deducts routine capital expenditures from FFO) is the best proxy for free cash flow in a REIT. AFFO margins are typically 35% to 40% of total revenue.
  • Major non-cash items: Depreciation of real estate assets is the largest non-cash expense. Fair value adjustments on embedded derivatives and straight-line rent adjustments also bridge Net Income to OCF.
  • Working capital cash flow impact: Minimal impact year-over-year due to the upfront nature of rent collection.
  • Capex intensity: High absolute dollar capex, but highly discretionary on the development side. Routine capex is predictable and stable.
  • Cash tax rate: Near 0%. As a REIT, MAA pays no federal income tax at the corporate level provided it distributes at least 90% of its taxable income to shareholders.

Sheet Structure

  1. Assumptions: Hardcoded inputs for macroeconomic drivers, Same Store metrics (occupancy, rent growth, expense growth), development pipeline yields, and capital structure rates.
  2. Portfolio & Operating Metrics: Roll-forward of total units, Same Store vs. Non-Same Store unit counts, average effective rent per unit, and physical occupancy percentages.
  3. Income Statement: Consolidated statement of operations mirroring the 10-K. Includes Rental and Other Property Revenues, Property Operating Expenses, Depreciation, G&A, and Interest Expense.
  4. Segment NOI Build: Detailed breakout of Revenue and Property Operating Expenses for the "Same Store" and "Non-Same Store and Other" segments, calculating segment-level NOI.
  5. FFO & AFFO Reconciliation: The critical REIT schedule. Bridges Net Income to NAREIT FFO, Core FFO, and Core AFFO by adding back real estate depreciation and deducting routine capital expenditures.
  6. Balance Sheet: Assets (Real Estate at Cost, Accumulated Depreciation, Cash) and Liabilities (Unsecured Notes, Credit Facility, Equity).
  7. Cash Flow Statement: Standard three-section cash flow. OCF driven by Net Income plus depreciation. ICF driven by development and acquisitions. DCF driven by dividends and debt issuance.
  8. Debt Schedule: Tranches of unsecured notes, revolving credit facility balance, interest rate calculations, and Net Debt to EBITDAre covenant tracking.
  9. NAV Valuation: Net Asset Value calculation applying a market cap rate to forward 12-month NOI, adding cash, and subtracting debt to find an implied share price.
  10. DCF Valuation: 10-year unlevered free cash flow (AFFO-based) model with terminal value based on a terminal cap rate.

Key Financial Relationships

  1. Same Store Rental Revenue = Prior Year Same Store Rental Revenue x (1 + Same Store Effective Rent Growth) x (Current Occupancy / Prior Occupancy)
  2. Same Store NOI = Same Store Rental Revenue + Same Store Other Property Revenue - Same Store Property Operating Expenses
  3. Non-Same Store Revenue = Non-Same Store Units x Average Effective Rent x Average Occupancy
  4. Total Property Revenues = Same Store Revenue + Non-Same Store and Other Revenue
  5. NAREIT FFO = Net Income Available to Common Shareholders + Real Estate Depreciation and Amortisation - Gains on Sale of Depreciable Real Estate
  6. Core FFO = NAREIT FFO + Casualty Losses - Casualty Gains + Non-Routine Legal Costs
  7. Core AFFO = Core FFO - Routine Capital Expenditures
  8. Net Debt = Total Unsecured Notes + Revolving Credit Facility - Cash and Cash Equivalents
  9. EBITDAre = Net Income + Interest Expense + Income Taxes + Depreciation and Amortisation - Gains on Sale of Real Estate
  10. Net Debt to EBITDAre = Net Debt / Annualised EBITDAre
  11. Implied Real Estate Value = Forward 12-Month Total NOI / Market Capitalisation Rate
  12. Net Asset Value (NAV) per Share = (Implied Real Estate Value + Cash + Construction in Progress - Total Debt) / Diluted Shares Outstanding

Cross-Sheet Dependencies

  • The Assumptions sheet dictates the growth rates used in the Portfolio & Operating Metrics sheet.
  • The Portfolio & Operating Metrics sheet feeds unit counts and rent levels directly into the Segment NOI Build.
  • The Segment NOI Build aggregates to form the top half of the Income Statement (Revenues and Property Operating Expenses).
  • The Income Statement generates Net Income, which is the starting point for the FFO & AFFO Reconciliation and the Cash Flow Statement.
  • The Debt Schedule calculates Interest Expense, which flows back to the Income Statement. This creates a potential circularity if debt is drawn to fund cash shortfalls; the builder should use a switch to break circularity or calculate interest on beginning balances.
  • The NAV Valuation relies on forward NOI from the Segment NOI Build and current balance sheet items from the Balance Sheet.

Sign Convention

  • Revenues and Income: Positive.
  • Expenses and Outflows: Negative in the Income Statement and Cash Flow Statement (e.g., Property Operating Expenses, Interest Expense, Capex).
  • Assets: Positive.
  • Liabilities and Equity: Positive.
  • Contra-Assets: Negative (e.g., Accumulated Depreciation).
  • Formulas: When calculating margins or subtotals, use addition if expenses are negative (e.g., Gross Profit = Revenue + COGS).

Things Most Likely to Go Wrong

  1. Depreciation Add-Backs: REITs must add back real estate depreciation to calculate FFO, but non-real estate depreciation (e.g., corporate office equipment) is NOT added back. The model must separate these.
  2. Gains on Sale: MAA frequently sells properties. Gains on the sale of depreciable real estate inflate Net Income but must be strictly excluded from FFO and EBITDAre.
  3. Development Yields: Assuming new developments generate full NOI immediately is a mistake. The model must account for a 12 to 18 month lease-up period where occupancy scales from 0% to 95%.
  4. Capitalised Interest: During construction, interest expense is capitalised into the asset value rather than expensed. Failing to model this overstates current interest expense and understates the final asset basis.
  5. Straight-Line Rent: GAAP requires straight-lining of rent over the lease term. The model must adjust for the non-cash difference between straight-line rent and cash rent when calculating AFFO.
  6. Share Count Dilution: MAA uses forward equity sales agreements and an ATM (At-The-Market) programme. The diluted share count must reflect the settlement of these forward contracts.
  7. Casualty Gains/Losses: Storm damage (e.g., from hurricanes) creates volatile one-time expenses and subsequent insurance recovery gains. These must be stripped out to calculate Core FFO.
  8. Property Tax Reassessments: Assuming linear expense growth is dangerous. Property taxes often jump in step-functions after a property is acquired or when local municipalities reassess values.

Validation Checks

  1. Occupancy Check: Average Physical Occupancy should remain between 94.0% and 96.5%. Flag if it drops below 94% or exceeds 97% (which is operationally near impossible due to natural turnover).
  2. Leverage Check: Net Debt to EBITDAre should remain between 3.5x and 4.5x. Flag if it exceeds 5.0x, as this breaches management's conservative balance sheet targets.
  3. Dividend Coverage Check: Dividend Payout Ratio (Dividends / Core AFFO) should be between 60% and 75%. Flag if it exceeds 85%, indicating an unsustainable dividend.
  4. NOI Margin Check: Same Store NOI margin should be stable between 62% and 65%. Flag if it moves outside this band.
  5. Balance Sheet Check: Total Assets must equal Total Liabilities plus Shareholders' Equity in every period.
  6. Fixed Rate Debt Check: The percentage of fixed-rate debt should remain above 85% based on MAA's historical risk management profile.
  7. FFO vs Net Income Check: NAREIT FFO should always be significantly higher than Net Income due to the massive real estate depreciation add-back.

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
Same Store Average Physical Occupancy95.6%Actual Q4 2024 reported occupancy
Same Store Revenue Growth (2025E)0.40%Midpoint of management's 2025 guidance
Same Store Expense Growth (2025E)3.20%Midpoint of management's 2025 guidance
Same Store NOI Growth (2025E)-1.15%Midpoint of management's 2025 guidance
Average Effective Rent per Unit1,693$ / monthActual Q4 2024 reported figure
Core FFO per Share (2025E)8.77$Midpoint of management's 2025 guidance
Core AFFO per Share (2025E)7.79$Midpoint of management's 2025 guidance
Net Debt to EBITDAre Target4.0xActual Q4 2024 reported leverage
Weighted Average Interest Rate3.8%Actual effective rate as of late 2024
Development Yield on Cost6.3%Reported NOI yield on new developments in lease-up
Routine Capital Expenditures1,200$ / unit / yearStandard industry benchmark for Sunbelt garden/mid-rise apartments
Effective Tax Rate0.0%REIT structure eliminates corporate income tax
NAV Capitalisation Rate5.25%Estimated market cap rate for Sunbelt multi-family assets
Discount Rate (WACC)7.5%Reflects low beta, high fixed-rate debt, and stable cash flows
Terminal FCF Growth Rate2.5%Long-term inflation and rent growth proxy

Data Sources & Benchmarks

  • Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and the MAA Investor Relations website (specifically the quarterly Supplemental Operating and Financial Data package, which is critical for REITs).
  • Key Peers: Camden Property Trust (CPT), AvalonBay Communities (AVB), Equity Residential (EQR), and UDR, Inc. (UDR).
  • Industry Data: National Association of Real Estate Investment Trusts (NAREIT) for industry-standard definitions of FFO and AFFO.
  • Consensus Estimates: FactSet or Bloomberg for consensus FFO per share and NAV estimates.
  • Proprietary Data: RealPage or Yardi Matrix for granular submarket rent growth and new supply delivery forecasts in the Sunbelt region.

Sources

Frequently asked

What kind of properties does Mid-America Apartment Communities (MAA) own?+

Mid-America Apartment Communities (MAA) is a real estate investment trust (REIT) focused on acquiring, owning, developing, and managing multi-family residential apartment communities. These properties are primarily located in the Sunbelt region of the United States, including high-growth markets like Dallas, Atlanta, and Orlando.

How does Mid-America Apartment Communities (MAA) generate its revenue?+

MAA primarily generates revenue through rental income from its real estate portfolio, with approximately 95% coming from "Same Store" established communities. The remaining revenue comes from recently acquired properties, those in development or lease-up, and non-multifamily activities.

What is the assumed capital expenditure percentage in the MAA financial model?+

The financial model for Mid-America Apartment Communities assumes a Capex_Pct_Revenue of 0.03 (3%). This represents the capital expenditures relative to the company's revenue, which is a key input for forecasting.

What key metrics are forecasted in the MAA equity valuation model?+

The MAA equity valuation model forecasts key metrics such as Funds From Operations (FFO), Adjusted Funds From Operations (AFFO), and Net Asset Value (NAV). These projections are based on factors like Sunbelt apartment supply dynamics, lease pricing trends, and development pipeline yields.

Can I download an Excel financial model for Mid-America Apartment Communities (MAA)?+

Yes, a downloadable Excel financial model is available for Mid-America Apartment Communities (MAA). This model provides a comprehensive equity valuation and operational forecast for the company, covering a forecast horizon from FY2026 to FY2030.

What is Mid-America Apartment Communities' (MAA) working capital profile?+

MAA typically has a negative net working capital profile because it collects rent upfront and pays expenses in arrears. Days Sales Outstanding (DSO) is near zero, and Days Payable Outstanding (DPO) is generally 15 to 30 days.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Other Real Estate Company Financial Models

Browse another company in the same sector.

Explore more Real Estate financial model templates.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview