Welltower Financial Model
Real Estate Company Financials Example (Free Excel Download)
Welltower Inc. is a real estate investment trust (REIT) that invests in healthcare infrastructure, primarily seniors housing, post-acute care facilities, and outpatient medical properties.
professionals from Deloitte
Used by professionals from
About this model
This model projects Welltower's Net Operating Income (NOI), Funds From Operations (FFO), and Adjusted Funds From Operations (AFFO) to determine the company's dividend sustainability and net asset value (NAV) for equity valuation purposes.
Welltower Inc. is a real estate investment trust (REIT) that invests in healthcare infrastructure, primarily seniors housing, post-acute care facilities, and outpatient medical properties. The company partners with leading seniors housing operators, health systems, and post-acute care providers to fund real estate development and acquisitions.
Business segments include:
- Seniors Housing Operating (SHO): Approximately 76% of total revenues.
- Triple-net (Seniors Housing and Post-Acute): Approximately 10% of total revenues.
- Outpatient Medical (OM): Approximately 10% of total revenues.
- Health System / Other: Remaining balance.
Key geographies include the United States, Canada, and the United Kingdom. The business model is asset-heavy, relying on acquiring and developing properties. In the SHO segment, Welltower uses RIDEA (REIT Investment Diversification and Empowerment Act) structures to participate directly in the underlying cash flows of the communities, making it more operationally sensitive than traditional triple-net leases. Welltower is the largest healthcare REIT by market capitalisation. Recent major events include aggressive capital deployment, with over $6 billion in acquisitions in 2024 and further expansion in 2025, alongside a strategic shift to convert many triple-net properties into SHO structures to capture operational upside.
The downloadable Welltower 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 & AssumptionsWelltower financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $3.20B | $4.17B | $4.75B | $6.03B | $8.45B |
| Gross profit | $422.7M | $614.9M | $806.0M | $1.20B | $1.96B |
| General and administrative expenses | $126.7M | $150.4M | $179.1M | $235.5M | $1.75B |
| Net income | $336.1M | $141.2M | $340.1M | $951.7M | $936.8M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Welltower
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Seniors Housing Operating (SHO)
- Segment name: Seniors Housing Operating
- Revenue driver formula: Available Rooms x Average Occupancy Rate x Revenue Per Occupied Room (RevPOR)
- Historical growth rate: 15% to 25% Same-Store NOI (SSNOI) growth recently, driven by post-pandemic recovery and demographic tailwinds.
- Key growth levers and headwinds: Aging population (80+ demographic growth), constrained new supply, and operator efficiency. Headwinds include labour shortages and wage inflation for care staff.
- Pricing dynamics: Spot pricing with annual or semi-annual rate increases. Highly competitive but currently benefiting from a supply-demand imbalance.
- Revenue recognition notes: Recognised as resident fees and services over time as services are rendered.
- Seasonality: Winter months typically see higher mortality rates and lower move-ins, slightly depressing Q1 occupancy and revenue.
Triple-net
- Segment name: Triple-net
- Revenue driver formula: Number of Properties x Average Contractual Rent x Rent Escalator
- Historical growth rate: 3% to 5% SSNOI growth.
- Key growth levers and headwinds: Contractual rent bumps (often tied to CPI) and operator EBITDARM coverage ratios. Headwinds include operator financial distress.
- Pricing dynamics: Long-term contractual leases (typically 10 to 15 years) with built-in escalators.
- Revenue recognition notes: Straight-line rental income over the lease term.
- Seasonality: None material.
Outpatient Medical
- Segment name: Outpatient Medical
- Revenue driver formula: Rentable Square Feet x Occupancy Rate x Rent Per Square Foot
- Historical growth rate: 2% to 3% SSNOI growth.
- Key growth levers and headwinds: Health system affiliations and outpatient care trends. Headwinds include tenant retention upon lease expiry.
- Pricing dynamics: Contractual leases, often triple-net or modified gross, with steady escalators.
- Revenue recognition notes: Straight-line rental income.
- Seasonality: None material.
Cost Structure
Property Operating Expenses
- Line-by-line breakdown: Labour (nursing and care staff), food, utilities, insurance, property taxes, and maintenance.
- Gross margin range: SHO operating margins typically range from 25% to 30%, while Triple-net and OM margins are much higher (often 90%+) because tenants bear most property-level costs.
- Key input costs and commodity exposures: Caregiver wages, agency labour costs, and utility rates.
- How COGS scales with revenue: SHO expenses scale with occupancy but have a high fixed component. Expense Per Occupied Room (ExpPOR) is the key metric tracked against RevPOR.
Operating Expenses
- R&D: Not applicable for a REIT.
- SG&A: General and administrative expenses typically run at 4% to 6% of total revenues, primarily driven by corporate headcount and technology investments.
- Depreciation & Amortisation: Extremely high (often 15% to 20% of revenue) due to the massive real estate asset base. Split primarily into building depreciation and lease intangible amortisation.
- Stock-Based Compensation: Modest, typically 1% to 2% of revenue.
- Restructuring / one-time charges: Occasional impairment charges on real estate assets or operator transitions.
Margin Profile
- EBITDA margin: 45% to 55% consolidated.
- Margin trend: Expanding. RevPOR growth has been outpacing ExpPOR growth in the SHO segment, driving operating margin expansion.
- Segment-level margins: SHO (25% to 30%), Triple-net (95%+), Outpatient Medical (90%+).
Balance Sheet Structure
- Total assets: Approximately $40 billion to $45 billion.
- Key asset categories: Real estate investments (land, buildings, improvements), investments in unconsolidated entities, and right-of-use assets.
- Goodwill & intangibles as % of total assets: Low (under 5%), primarily lease intangibles.
- Working capital profile:
- Days Sales Outstanding (DSO): 10 to 15 days (rent and resident fees are typically paid in advance or promptly).
- Days Inventory Outstanding (DIO): Not applicable.
- Days Payable Outstanding (DPO): 20 to 30 days.
- Net working capital as % of revenue: Slightly negative to neutral.
- Is working capital positive or negative? Often negative, providing a slight funding advantage.
- PP&E: Real estate is the core asset. Buildings are typically depreciated over 40 years, and improvements over 5 to 15 years.
- Right-of-use assets / operating leases: Material due to ground leases, but small relative to owned fee-simple real estate.
Capital Expenditure & Investment
- Capex as % of revenue: Maintenance capex typically runs at 2% to 4% of revenue.
- Maintenance capex vs. growth capex: Maintenance is a small fraction of total spend. Growth capex (development and acquisitions) dominates capital allocation.
- Major capex programmes underway or planned: Significant ongoing development funding and property conversions.
- Capitalised software / development costs if material: Immaterial compared to real estate development.
- M&A pattern: Transformational and serial acquirer. Welltower deployed over $6 billion in 2024 and continues aggressive acquisitions at discounts to replacement cost.
- Typical acquisition multiple paid: Typically evaluated on a going-in cap rate (yield) basis, often targeting 6% to 8% initial yields depending on the asset class.
Debt & Capital Structure
- Total debt: Approximately $14 billion to $16 billion.
- Debt/EBITDA ratio: Target and current levels are around 3.0x to 3.5x (Net Debt to Adjusted EBITDA).
- Credit rating: A- (S&P) and A3 (Moody's).
- Key debt instruments: Unsecured senior notes, $5 billion unsecured revolving credit facility, commercial paper programme, and exchangeable senior notes.
- Maturity profile: Well-laddered, with average maturity typically exceeding 5 years.
- Interest rate profile: Predominantly fixed rate (often 85%+ fixed) with a weighted average cost of debt around 3.5% to 4.5%.
- Covenants: Standard REIT covenants (e.g., Total Indebtedness to Total Assets < 60%).
- Share repurchase programme: Rarely active; the company frequently issues equity via an ATM (At-The-Market) programme to fund acquisitions.
- Dividend policy: Consistent quarterly dividend. Payout ratio is typically 60% to 70% of AFFO. Current annualised dividend is around $2.68 per share.
Cash Flow Characteristics
- Operating cash flow conversion: High. OCF is typically much higher than GAAP Net Income due to massive depreciation add-backs.
- Free cash flow margin: AFFO margin (a proxy for REIT FCF) is typically 25% to 35% of revenue.
- Major non-cash items that bridge net income to OCF: Depreciation and amortisation, stock-based compensation, straight-line rent adjustments, and gains/losses on real estate dispositions.
- Working capital cash flow impact: Minimal impact year-over-year.
- Capex intensity: High growth capex, low maintenance capex.
- Cash tax rate vs. GAAP effective tax rate: Near zero. As a REIT, Welltower pays minimal corporate income tax provided it distributes at least 90% of its taxable income to shareholders.
Sheet Structure
- Assumptions: Hardcoded inputs for macroeconomic drivers, segment growth rates, occupancy, RevPOR, ExpPOR, cap rates, and capital structure targets.
- Portfolio & Operating Metrics: Tracks unit counts, available rooms, occupancy percentages, RevPOR, and ExpPOR for the SHO segment. Tracks property counts and square footage for Triple-net and OM.
- Revenue Schedule: Calculates revenue by segment (Seniors Housing Operating, Triple-net, Outpatient Medical) based on the drivers in Sheet 2.
- Property Expenses & NOI: Calculates property-level operating expenses and Net Operating Income (NOI) for each segment.
- Consolidated Income Statement: Rolls up NOI, deducts corporate SG&A, depreciation, interest expense, and calculates GAAP Net Income.
- FFO & AFFO Reconciliation: Bridges GAAP Net Income to NAREIT FFO, Normalized FFO, and AFFO (deducting maintenance capex and straight-line rent).
- Balance Sheet: Projects real estate assets, accumulated depreciation, debt balances, and equity.
- Debt Schedule: Details tranches of debt, interest rates, maturities, and calculates interest expense.
- Cash Flow Statement: Standard 3-statement cash flow, heavily driven by the FFO/AFFO dynamics and acquisition spend.
- NAV Valuation: Calculates Net Asset Value by applying segment-specific cap rates to forward 12-month NOI, adding cash, and deducting debt.
Key Financial Relationships
- SHO Revenue = SHO Available Rooms x SHO Occupancy Rate x RevPOR x 12
- SHO Property Expenses = SHO Occupied Rooms x ExpPOR x 12
- SHO NOI = SHO Revenue - SHO Property Expenses
- Triple-net Revenue = Prior Year Triple-net Revenue x (1 + Contractual Rent Escalator) + Acquired Rent
- Outpatient Medical Revenue = OM Rentable Square Feet x OM Occupancy Rate x Rent Per Square Foot
- Consolidated NOI = SHO NOI + Triple-net NOI + Outpatient Medical NOI
- NAREIT FFO = GAAP Net Income + Real Estate Depreciation and Amortisation - Gains on Sales of Real Estate
- Normalized FFO = NAREIT FFO + Transaction Costs + Impairments + Non-Recurring Items
- AFFO = Normalized FFO - Maintenance Capital Expenditures - Straight-Line Rent Adjustments
- Interest Expense = Average Debt Balance x Weighted Average Interest Rate
- Ending Real Estate Assets = Beginning Real Estate Assets + Acquisitions + Development Capex - Dispositions
- Implied Cap Rate = Consolidated Forward NOI / (Market Capitalisation + Net Debt)
Cross-Sheet Dependencies
- Portfolio & Operating Metrics feeds directly into the Revenue Schedule and Property Expenses & NOI sheets.
- Property Expenses & NOI feeds the top half of the Consolidated Income Statement and the NAV Valuation sheet.
- Consolidated Income Statement feeds the FFO & AFFO Reconciliation (starting with Net Income) and the Cash Flow Statement.
- Debt Schedule calculates interest expense which flows to the Consolidated Income Statement and ending debt balances which flow to the Balance Sheet and NAV Valuation.
- Cash Flow Statement determines the funding gap, which dictates equity issuance (ATM programme) or debt drawdowns, creating a potential circularity with the Debt Schedule and interest expense.
Sign Convention
- Revenues and operating metrics (Occupancy, RevPOR) are positive.
- Expenses (Property expenses, SG&A, Interest Expense) are positive in their specific schedules but subtracted in the Income Statement and NOI calculations.
- Capital expenditures and acquisitions are positive in the asset schedules but negative in the Cash Flow Statement (representing a use of cash).
- Debt paydowns are negative in the Cash Flow Statement; debt issuances are positive.
Things Most Likely to Go Wrong
- Failing to separate maintenance capex from growth capex. Only maintenance capex should be deducted when calculating AFFO.
- Applying operating expenses to the Triple-net segment. Triple-net tenants pay property taxes, insurance, and maintenance; Welltower's margin here should be near 100%.
- Ignoring the impact of the ATM (At-The-Market) equity programme. Welltower funds acquisitions heavily with equity; keeping share count flat will artificially inflate FFO per share.
- Miscalculating RevPOR and ExpPOR. These are monthly or annualised figures per *occupied* room, not per available room.
- Straight-line rent adjustments. GAAP revenue includes straight-line rent, but this non-cash revenue must be deducted to reach AFFO.
- Confusing GAAP Net Income with FFO. REIT valuations and dividend payout ratios are based on FFO/AFFO, not Net Income.
- Overestimating corporate tax. Welltower is a REIT; apply a near-zero tax rate.
- Failing to account for property conversions. Welltower frequently converts Triple-net properties to SHO structures, which shifts revenue from pure rent to gross resident fees and adds property operating expenses.
Validation Checks
- Consolidated NOI margin should be between 45% and 55%.
- SHO operating margin should be in the 25% to 30% range.
- Net Debt to Adjusted EBITDA should remain between 3.0x and 4.0x per rating agency and management targets.
- Dividend payout ratio should not exceed 80% of AFFO to ensure dividend safety.
- Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period.
- Total Indebtedness to Total Assets covenant check should remain well below 60%.
- Occupancy rates in the SHO segment should not exceed 95% (practical maximum due to turnover).
- AFFO must be lower than Normalized FFO due to the deduction of maintenance capex.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| SHO Occupancy Rate | 83.0 | % | Recent actual occupancy levels, recovering steadily. |
| SHO RevPOR Growth | 5.0 | % | Recent year-over-year growth driven by strong pricing power. |
| SHO ExpPOR Growth | 3.0 | % | Expense growth is moderating, driving margin expansion. |
| Triple-net SSNOI Growth | 3.5 | % | Midpoint of recent management guidance. |
| Outpatient Medical SSNOI Growth | 2.5 | % | Midpoint of recent management guidance. |
| SG&A as % of Revenue | 5.0 | % | Historical average for the company. |
| Maintenance Capex as % of Revenue | 2.5 | % | Standard run-rate for healthcare REIT portfolios. |
| Weighted Average Interest Rate | 4.0 | % | Blended cost of debt based on recent filings. |
| Effective Tax Rate | 0.5 | % | REIT structure eliminates most corporate income tax. |
| Dividend per Share (Annual) | 2.68 | $ | Based on recent quarterly dividend of $0.67. |
| Target Net Debt / EBITDA | 3.5 | x | Management's stated leverage target. |
| SHO Cap Rate (Valuation) | 6.0 | % | Standard market cap rate for high-quality seniors housing. |
| Triple-net Cap Rate (Valuation) | 7.0 | % | Standard market cap rate for healthcare triple-net assets. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Welltower Inc. 10-K, 10-Q, 8-K) and the Welltower Investor Relations page (quarterly supplemental information packages are critical for REITs).
- Peers for Benchmarking: Ventas (VTR), Healthpeak Properties (DOC), Omega Healthcare Investors (OHI).
- Industry Data Sources: National Investment Center for Seniors Housing & Care (NIC) for occupancy and rent growth data.
- Consensus Estimates: Bloomberg or FactSet for FFO per share and NAV estimates.
Sources
Do more with the Welltower model
Frequently asked
What type of company is Welltower and what does it invest in?+
Welltower Inc. is the largest healthcare real estate investment trust (REIT) by market capitalization. The company primarily invests in healthcare infrastructure, including seniors housing, post-acute care facilities, and outpatient medical properties across the United States, Canada, and the United Kingdom.
What are Welltower's primary revenue sources and business segments?+
Welltower's revenues are primarily driven by its Seniors Housing Operating (SHO) segment, which accounts for approximately 76% of total revenues. Other significant segments include Triple-net leases for seniors housing and post-acute care, and Outpatient Medical properties, each contributing around 10% of total revenues.
How does capital expenditure impact Welltower's financial model?+
Capital expenditure is a significant factor in Welltower's financial model, with growth capex from development and acquisitions dominating capital allocation. While maintenance capex is a smaller fraction (2-4% of revenue), the model assumes a Capex_Pct_Revenue of 40%, reflecting the company's asset-heavy and acquisitive business model.
What is the purpose of the Welltower financial model and what metrics does it project?+
The Welltower financial model is designed to project key metrics such as Net Operating Income (NOI), Funds From Operations (FFO), and Adjusted Funds From Operations (AFFO). These projections are crucial for determining the company's dividend sustainability and its net asset value (NAV) for equity valuation purposes.
Can I download an Excel financial model for Welltower, and what is its forecast horizon?+
Yes, an Excel financial model for Welltower is available for download, providing detailed financial projections. This model offers a forecast horizon extending from fiscal year 2026 through fiscal year 2030, allowing for long-term analysis.
What is Welltower's strategy for growth and capital deployment?+
Welltower employs an aggressive strategy of capital deployment and acquisitions, having deployed over $6 billion in 2024 alone. The company is a serial acquirer, targeting properties at going-in cap rates typically between 6% and 8% to fuel its growth and expand its real estate portfolio.
Have more financial modelling questions? Contact us
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.
Alexandria Real Estate Equities
Alexandria Real Estate Equities (ARE) is a pioneering, internally managed Real Estate Investment Trust (REIT) focused exclusively on collaborative life science, agtech, and technology campuses.
AvalonBay Communities
AvalonBay Communities, Inc.
BXP
BXP is the largest publicly traded developer, owner, and manager of premier Class A office space in the United States, operating as a fully integrated real estate investment trust.
CBRE Group
CBRE Group is the world's largest commercial real estate services and investment firm, providing a broad suite of services to occupiers, owners, lenders, and investors.
Camden Property Trust
Camden Property Trust is an S&P 500 real estate investment trust (REIT) primarily engaged in the ownership, management, development, redevelopment, acquisition, and construction of multifamily apartment communities.
Digital Realty
Digital Realty Trust, Inc.
Healthpeak Properties
Healthpeak Properties, Inc.
Equinix
Equinix is the world's largest digital infrastructure company, operating as a real estate investment trust (REIT) that provides global colocation, interconnection, and managed IT services.
Explore more Healthcare financial model templates.
