# Camden Property Trust (CPT) Financial Model Free Excel 3-statement financial model and company analysis for Camden Property Trust. - Canonical: https://finamodel.com/companies/camden-property-trust - Industry: Real Estate - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/CPT.xlsx ## Model Purpose This model projects net operating income (NOI), funds from operations (FFO), and adjusted funds from operations (AFFO) to determine the net asset value (NAV) and dividend sustainability for an equity investor evaluating Camden Property Trust. ## Company Overview 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. The company owns and operates over 170 properties containing approximately 59,000 apartment homes across the United States, with a strong focus on high-growth Sun Belt markets. Business segments by revenue contribution: * Rental Revenue (approx. 89%) * Other Property Revenues / Non-Lease Components (approx. 11%) * Fee and Asset Management (less than 1%) Key geographies include major markets such as Houston, Washington D.C. Metro, Dallas, Atlanta, and Phoenix. The business model is asset-heavy, relying on acquiring, developing, and operating physical real estate to generate stable rental income. Camden holds a strong competitive position as one of the largest publicly traded multifamily REITs, competing with peers like AvalonBay Communities, Equity Residential, and Mid-America Apartment Communities. Recent major events include a strategic repositioning to reduce exposure to its largest markets (Houston and D.C.) to under 10% of NOI by 2027, alongside the issuance of $600 million in 4.90% senior unsecured notes due 2036 to extend its debt maturity profile. ## Revenue Deep Dive ### Rental Revenue * **Segment name:** Rental revenue * **Revenue driver formula:** Total Apartment Homes x Occupancy Rate x Average Monthly Rent per Occupied Home x 12 * **Historical growth rate:** 1% to 4% CAGR over the last 3 years, heavily dependent on market rent growth and supply dynamics. * **Key growth levers and headwinds:** Driven by job growth, household formation, and housing affordability in Sun Belt markets. Headwinds include elevated new multifamily supply in certain markets and broader macroeconomic pressures on consumer wallets. * **Pricing dynamics:** Spot pricing based on daily pricing optimization software; leases are typically 12 months. Blended lease rates (new and renewals) drive near-term revenue. * **Revenue recognition notes:** Recognised straight-line over the lease term. * **Seasonality:** Spring and summer months typically see higher leasing volume and stronger rent growth compared to the winter months. ### Other Property Revenues * **Segment name:** Non-lease components / Other property revenues * **Revenue driver formula:** Total Occupied Homes x Average Monthly Other Revenue per Home * **Historical growth rate:** 3% to 5% CAGR. * **Key growth levers and headwinds:** Driven by utility rebilling, trash collection fees, pet fees, parking, and technology packages (e.g., bulk internet). * **Pricing dynamics:** Contractual and usage-based. * **Revenue recognition notes:** Recognised as the services are provided to the residents. * **Seasonality:** Utility rebilling can fluctuate slightly with seasonal weather patterns (e.g., higher cooling costs in summer). ## Cost Structure ### Variable Costs / COGS As a REIT, Camden does not report traditional COGS. The equivalent is Property Operating and Maintenance expenses. * **Line-by-line breakdown:** Payroll for on-site staff, utilities, repairs and maintenance, turnover costs, and marketing. * **Gross margin range:** Net Operating Income (NOI) margin typically ranges from 62% to 65%. * **Key input costs and commodity exposures:** Utility rates, local wage inflation for property staff, and materials for property maintenance. * **How COGS scales with revenue:** Step-function. A property requires a baseline level of staffing and utilities regardless of whether occupancy is 90% or 95%. ### Operating Expenses * **Real Estate Taxes:** Highly dependent on local municipality assessments and tax rates. Typically grows at 2% to 5% annually. * **Property Management:** Corporate-level oversight and regional management costs, scaling with the number of properties. * **General and Administrative (G&A):** Executive compensation, corporate office expenses, and public company costs. Typically 2% to 3% of total revenue. * **Depreciation & Amortisation:** Significant non-cash expense due to the asset-heavy nature of real estate. Typically 30% to 35% of revenue. * **Stock-Based Compensation:** Included in G&A; relatively small but requires adjustment for Core AFFO calculation. * **Restructuring / one-time charges:** Infrequent, though the company occasionally records impairments on undeveloped land parcels (e.g., $0.12 per share in FY2025). ### Margin Profile * **NOI Margin:** 62% to 65%. * **EBITDAre Margin:** 55% to 60%. * **Margin trend:** Stable, though occasionally compressed by outsized increases in property insurance or real estate taxes. * **Segment-level margins:** Same-store NOI margin is the primary metric, typically mirroring the consolidated NOI margin. ## Balance Sheet Structure * **Total assets:** Approximately $8.5 billion to $9.5 billion (book value), though gross real estate assets before depreciation are significantly higher. * **Key asset categories:** Land, Buildings and Improvements, Construction in Progress, and Operating Lease Right-of-Use Assets. * **Goodwill & intangibles as % of total assets:** Negligible. * **Working capital profile:** * **Days Sales Outstanding (DSO):** Very low (under 5 days), as rent is due on the first of the month. * **Days Inventory Outstanding (DIO):** Not applicable. * **Days Payable Outstanding (DPO):** 15 to 30 days. * **Net working capital as % of revenue:** Negative. * **Is working capital positive or negative?** Negative. Rent is collected upfront, providing a working capital advantage. * **PP&E:** Represents the core real estate portfolio. Buildings are depreciated over 27.5 to 40 years. Maintenance capex is capitalised and depreciated over shorter useful lives (5 to 15 years). * **Right-of-use assets / operating leases:** Immaterial relative to the real estate portfolio. ## Capital Expenditure & Investment * **Capex as % of revenue:** 10% to 15% (including development), but maintenance capex is typically $1,000 to $1,500 per apartment home annually. * **Maintenance capex vs. growth capex:** Maintenance (recurring) capex is a small fraction of total spend. Growth capex (development and redevelopment) constitutes the majority. * **Major capex programmes underway:** Active development pipeline including projects in Charlotte, NC, and Nashville, TN. * **Capitalised software / development costs:** Capitalised interest and internal costs during the construction phase of development projects are material. * **M&A pattern:** Active capital recycler. The company targets $750 million in acquisitions and $750 million in dispositions annually to optimise the portfolio. * **Typical acquisition multiple paid:** Typically acquires at stabilised yields (cap rates) of 4.5% to 5.5% (e.g., Camden Leander acquired at a 5% yield). ## Debt & Capital Structure * **Total debt:** Approximately $3.5 billion to $4.0 billion. * **Debt/EBITDA ratio:** Target is around 4.0x to 4.5x (Net Debt/Adjusted EBITDAre was 4.10x recently). * **Credit rating:** Investment grade (Moody's: A3, Fitch: A-, S&P: A-). * **Key debt instruments:** 91.2% unsecured debt. Primarily senior unsecured notes and an unsecured revolving credit facility. * **Maturity profile:** Weighted average maturity of 5.7 years. The main revolver maturity was recently extended to 2030. * **Interest rate profile:** 73.2% fixed-rate debt. Weighted average interest rate of 4.2%. * **Covenants:** Standard REIT unsecured financial covenants (e.g., total debt to total assets under 60%). * **Share repurchase programme:** Active $600 million share repurchase authorisation approved in February 2026. * **Dividend policy:** Consistent dividend payer. Yield is approximately 3.86%, with a target payout ratio of 65% to 75% of AFFO. ## Cash Flow Characteristics * **Operating cash flow conversion:** High. OCF consistently exceeds Net Income due to heavy non-cash depreciation. * **Free cash flow margin:** FCF (AFFO) margin is typically 35% to 40% of total revenue. * **Major non-cash items:** Real estate depreciation and amortisation, stock-based compensation, and non-cash impairment charges. * **Working capital cash flow impact:** Minimal impact year-over-year due to the stable nature of rent collection. * **Capex intensity:** High absolute dollar spend, but highly discretionary beyond recurring maintenance capex. * **Cash tax rate vs. GAAP effective tax rate:** As a REIT, Camden pays near-zero corporate income tax provided it distributes at least 90% of taxable income to shareholders. ## Sheet Structure 1. **Assumptions:** Hardcoded inputs for macroeconomic drivers, market rent growth, occupancy, expense inflation, cap rates, and debt terms. 2. **Portfolio & Same-Store:** Tracks apartment home count, occupancy rates, average rent per home, and same-store vs. non-same-store performance. 3. **Income Statement:** Consolidated GAAP income statement projecting Rental Revenue, Other Property Revenue, Property Expenses, G&A, Depreciation, and Interest Expense. 4. **Balance Sheet:** Projects Real Estate Assets, Accumulated Depreciation, Cash, Unsecured Notes, and Equity. 5. **Cash Flow Statement:** Bridges Net Income to OCF, tracks development/acquisition spend (CFI), and debt/equity issuance and dividends (CFF). 6. **Debt Schedule:** Tranches of unsecured notes, revolver balance, interest rate calculations, and maturity schedule. 7. **FFO & AFFO Build:** Reconciles Net Income to NAREIT FFO, Core FFO, and Core AFFO (deducting recurring capital expenditures). 8. **NAV Valuation:** Applies a market cap rate to forward 12-month NOI, adds cash, deducts debt, to arrive at Net Asset Value per share. 9. **DCF Valuation:** 10-year unlevered free cash flow projection and terminal value calculation based on a terminal cap rate. ## Key Financial Relationships 1. Rental Revenue = Total Apartment Homes x Occupancy Rate x Average Monthly Rent x 12 2. Other Property Revenue = Total Apartment Homes x Occupancy Rate x Average Monthly Other Revenue x 12 3. Total Property Revenue = Rental Revenue + Other Property Revenue 4. Property Operating Expenses = Prior Year Property Operating Expenses x (1 + Expense Inflation Rate) 5. Net Operating Income (NOI) = Total Property Revenue - Property Operating Expenses - Real Estate Taxes 6. Same-Store NOI Growth = (Current Year Same-Store NOI / Prior Year Same-Store NOI) - 1 7. EBITDAre = Net Income + Interest Expense + Income Taxes + Depreciation and Amortisation + Impairments on Real Estate 8. NAREIT FFO = Net Income + Real Estate Depreciation and Amortisation + Impairments on Real Estate - Gains on Sale of Real Estate 9. Core FFO = NAREIT FFO + Expensed Transaction Pursuit Costs + Non-Core Legal/Settlement Costs 10. Core AFFO = Core FFO - Recurring Capital Expenditures (Maintenance Capex) 11. Net Debt = Total Debt - Cash and Cash Equivalents 12. Net Debt to EBITDAre = Net Debt / Annualised EBITDAre 13. Implied Capitalisation Rate = Forward 12-Month NOI / Implied Real Estate Value 14. Net Asset Value (NAV) = (Forward 12-Month NOI / Market Cap Rate) + Cash + Other Tangible Assets - Total Debt - Preferred Equity 15. Dividend Payout Ratio = Annual Dividend per Share / Core AFFO per Share ## Cross-Sheet Dependencies * The **Portfolio & Same-Store** sheet feeds total apartment homes and blended rent rates directly into the **Income Statement** revenue lines. * The **Income Statement** calculates NOI, which feeds both the **FFO & AFFO Build** and the **NAV Valuation** sheets. * The **Debt Schedule** calculates interest expense, which feeds the **Income Statement** and the **Cash Flow Statement**. * The **Cash Flow Statement** determines the ending cash balance and revolver draw requirements, which loop back into the **Balance Sheet** and **Debt Schedule**. * The **FFO & AFFO Build** determines the cash available for distribution, which feeds the dividend payout assumptions in the **Cash Flow Statement**. * Circularity risk exists between the Revolver balance (Debt Schedule), Interest Expense (Income Statement), and Cash Flow (Cash Flow Statement). A circuit breaker toggle must be included. ## Sign Convention * Revenues, asset balances, and equity balances are positive. * Expenses, capital expenditures, and liability balances are positive in their respective schedules but subtracted in aggregation formulas. * Cash Flow Statement: Cash inflows are positive; cash outflows (including capex, dividends, and debt paydown) are negative. * Contra-assets (e.g., Accumulated Depreciation) are entered as positive numbers but subtracted from Gross Assets to calculate Net Assets. ## Things Most Likely to Go Wrong 1. Failing to separate Same-Store from Non-Same-Store metrics. REIT growth is judged on Same-Store NOI; development lease-ups distort consolidated growth rates. 2. Incorrectly calculating NAREIT FFO. Depreciation of real estate is added back, but depreciation of non-real estate assets (like corporate software) is not. 3. Omitting recurring capital expenditures from the AFFO calculation. FFO overstates cash flow because it ignores the real cash cost of maintaining the properties. 4. Mismodelling the timing of development deliveries. A new property does not generate stabilised NOI on day one; it requires a 12 to 18-month lease-up period. 5. Double-counting property management fees. Camden internalises management, so these are operating expenses, not a below-the-line deduction as seen in externally managed REITs. 6. Ignoring capitalised interest. During development, interest is capitalised into the asset base rather than expensed, which flatters the income statement. 7. Applying the wrong cap rate in the NAV calculation. Cap rates vary wildly by market (e.g., Austin vs. D.C.); a blended cap rate must reflect the specific geographic mix. 8. Treating land impairments as an operating expense. These are non-cash charges that must be added back to calculate FFO and EBITDAre. ## Validation Checks 1. Consolidated NOI margin should remain between 62% and 65%; flag if it deviates outside this band. 2. Net Debt to Adjusted EBITDAre should remain between 4.0x and 4.5x based on management's target leverage profile. 3. Occupancy rate must not exceed 100% and should typically stabilise between 94.5% and 96.0%. 4. Dividend payout ratio should not exceed 100% of Core AFFO; flag if the dividend is uncovered. 5. Balance sheet must balance: Total Assets = Total Liabilities + Equity in every projected period. 6. The implied cap rate of the stock (Forward NOI / Implied Enterprise Value) should be compared against the hardcoded NAV cap rate to check for market premiums/discounts. 7. Fixed-rate debt percentage should remain above 70% to align with the company's conservative balance sheet strategy. 8. Total apartment homes should equal the prior period homes plus development deliveries plus acquisitions minus dispositions. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Total Apartment Homes (Starting) | 58,759 | Homes | Actual count as of January 2026. | | Occupancy Rate | 95.2 | % | Actual Q4 2025 occupancy rate. | | Average Monthly Rent per Home | 1,985 | $ | Estimated based on FY2025 rental revenue and home count. | | Same-Store Revenue Growth | 1.0 | % | Midpoint of 2025/2026 management guidance. | | Same-Store Expense Growth | 3.0 | % | Management guidance for expense inflation. | | NOI Margin | 63.5 | % | Historical average for the portfolio. | | Annual Acquisitions | 750 | $ Millions | Management target for capital recycling. | | Annual Dispositions | 750 | $ Millions | Management target for capital recycling. | | Acquisition Cap Rate | 5.0 | % | Recent stabilised yield on acquisitions (e.g., Camden Leander). | | Maintenance Capex per Home | 1,250 | $ | Industry standard for Class A/B Sun Belt multifamily. | | Weighted Average Interest Rate | 4.2 | % | Actual reported rate on total debt. | | Revolver Interest Rate | 4.9 | % | Management guidance for 2025 line of credit rate. | | Target Net Debt / EBITDAre | 4.1 | x | Actual reported leverage ratio. | | NAV Capitalisation Rate | 5.25 | % | Estimated blended market cap rate for Sun Belt multifamily assets. | | Dividend per Share (Annual) | 4.12 | $ | Based on recent quarterly dividend run-rate and historical growth. | ## Data Sources & Benchmarks * **Filings:** SEC EDGAR (Form 10-K, 10-Q, 8-K) and the Camden Property Trust Investor Relations website (Quarterly Supplemental Financial Information). * **Key Peers:** Mid-America Apartment Communities (MAA), AvalonBay Communities (AVB), Equity Residential (EQR), and UDR, Inc. (UDR). * **Industry Data:** RealPage, Yardi Matrix, and CoStar for market-level rent growth, supply deliveries, and occupancy benchmarks. * **Consensus Estimates:** Bloomberg or FactSet for consensus FFO, AFFO, and NAV estimates. ## Sources * Camden Property Trust Q4 2025 Earnings Release and Supplemental Information * Camden Property Trust Q3 2025 Earnings Release * Camden Property Trust March 2025 Investor Presentation * Camden Property Trust 2025 Proxy Statement * Camden Property Trust 2026 Proxy Statement * Camden Property Trust Q4 2024 Earnings Call Transcript * Bitget News: Camden Property Trust Debt Restructuring --- ## Frequently asked questions ### What kind of properties does Camden Property Trust own and operate? Camden Property Trust is an S&P 500 real estate investment trust (REIT) primarily engaged in the ownership, management, development, and acquisition of multifamily apartment communities. The company owns and operates over 170 properties containing approximately 59,000 apartment homes across the United States, with a strong focus on high-growth Sun Belt markets. ### How does Camden Property Trust generate its revenue? Camden Property Trust primarily generates its revenue through rental income, which accounts for approximately 89% of its total revenue. Additional income streams include other property revenues, non-lease components, and a small portion from fee and asset management. ### What are the key capital expenditure assumptions in the Camden Property Trust financial model? The financial model for Camden Property Trust assumes Capex_Pct_Revenue at 0.4, reflecting the asset-heavy nature of its business. While maintenance capex is a relatively small portion, growth capex from development and redevelopment constitutes the majority of the company's capital spending. ### What is the purpose of the Camden Property Trust financial model for investors? The financial model projects key metrics such as net operating income (NOI), funds from operations (FFO), and adjusted funds from operations (AFFO). This analysis helps determine the net asset value (NAV) and assess the dividend sustainability for equity investors evaluating Camden Property Trust. ### Can I download an Excel financial model for Camden Property Trust (CPT)? Yes, a downloadable Excel financial model is available for Camden Property Trust (CPT). This model provides projections for the forecast horizon of FY2026–FY2030, allowing users to analyze the company's financial performance. ### What is Camden Property Trust's strategy regarding its property portfolio? Camden Property Trust actively recycles capital, targeting $750 million in acquisitions and $750 million in dispositions annually to optimize its portfolio. The company is also strategically repositioning to reduce exposure to its largest markets, Houston and D.C., to under 10% of NOI by 2027. [Interactive forecast calculator](https://finamodel.com/companies/camden-property-trust/forecast)