# Kimco Realty (KIM) Financial Model Free Excel 3-statement financial model and company analysis for Kimco Realty. - Canonical: https://finamodel.com/companies/kimco-realty - Industry: Real Estate - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/KIM.xlsx ## Model Purpose This model forecasts Funds From Operations (FFO), Adjusted Funds From Operations (AFFO), and Net Asset Value (NAV) to determine the equity valuation and dividend sustainability for Kimco Realty, aiding equity research analysts in setting a target price. ## Company Overview Kimco Realty Corporation (NYSE: KIM) is North America's largest publicly traded owner and operator of open-air, grocery-anchored shopping centres and mixed-use assets. The company generates revenue by leasing retail space to necessity-based tenants, ensuring consistent foot traffic and resilient rental income. - **Business segments**: Revenues from rental properties (approximately 98% of total revenue) and Management and other fee income (approximately 2%). - **Key geographies**: Strictly United States, with a strategic concentration in the first-ring suburbs of top major metropolitan markets, including high-barrier-to-entry coastal markets and rapidly expanding Sun Belt cities. - **Business model type**: Asset-heavy Real Estate Investment Trust (REIT) generating recurring rental income from long-term leases. - **Competitive position**: An S&P 500 member and an industry leader in the retail REIT space, competing with peers like Regency Centers, Brixmor Property Group, and Federal Realty Investment Trust. - **Recent major events**: The company closed the $2.3 billion acquisition of RPT Realty in January 2024, adding 56 open-air shopping centres to its portfolio. In 2025, Kimco achieved record portfolio occupancy of 96.4% and received credit rating upgrades to A- from multiple agencies. ## Revenue Deep Dive ### Revenues from Rental Properties - **Segment name**: Revenues from rental properties (includes Minimum rent, Tenant recoveries, and Percentage rent). - **Revenue driver formula**: Gross Leasable Area (GLA) x Occupancy Percentage x Annualised Base Rent (ABR) per square foot. - **Historical growth rate**: 3.0% to 5.0% Same-Property Net Operating Income (NOI) growth over the last 3 years. - **Key growth levers and headwinds**: Growth is driven by positive rent spreads on new leases (achieving 29% pro-rata rent spreads in Q4 2025) and contractual annual rent bumps (typically 3%+ for small shops). Headwinds include tenant bankruptcies and macroeconomic disruptions affecting retail spending. - **Pricing dynamics**: Contractual base rents with built-in escalators, plus tenant recoveries where tenants reimburse the landlord for their pro-rata share of property operating expenses (triple-net leases). - **Revenue recognition notes**: Base rent is recognised on a straight-line basis over the lease term. This creates a non-cash straight-line rent receivable that must be deducted when calculating AFFO. - **Seasonality**: Generally stable, though percentage rents (based on tenant sales volumes) can be slightly higher in the fourth quarter due to holiday shopping. ### Management and Other Fee Income - **Segment name**: Management and other fee income. - **Revenue driver formula**: Joint Venture Assets Under Management (AUM) x Management Fee Rate. - **Historical growth rate**: Relatively flat, growing 1% to 2% annually. - **Key growth levers and headwinds**: Driven by the formation of new joint ventures or structured investments. - **Pricing dynamics**: Contractual fee percentages based on property revenues or asset values managed on behalf of joint venture partners. - **Revenue recognition notes**: Recognised as services are performed. - **Seasonality**: None. ## Cost Structure ### Property Operating Expenses (COGS equivalent) - **Line-by-line breakdown**: Real estate taxes, operating and maintenance (Common Area Maintenance or CAM), insurance, and provision for credit losses. - **Gross margin range**: NOI margin typically ranges from 68% to 72%. - **Key input costs and commodity exposures**: Property taxes and insurance premiums are the largest uncontrollable expenses, though the majority are recovered from tenants via triple-net leases. - **How COGS scales with revenue**: Highly linear due to the tenant recovery structure. Operating leverage is achieved when occupancy increases, as fixed property costs are spread over a larger revenue base. ### Operating Expenses - **R&D**: Not applicable for a REIT. - **SG&A**: General and administrative expenses cover corporate headcount, legal, and IT. It typically runs at 4% to 5% of total revenues. - **Depreciation & Amortisation**: Extremely high (typically 25% to 30% of revenue) due to the asset-heavy nature of real estate. This is a non-cash charge added back to calculate FFO. - **Stock-Based Compensation**: Minimal, typically less than 1% of revenue. - **Restructuring / one-time charges**: Infrequent, usually tied to major M&A integration (such as the RPT Realty acquisition in 2024). ### Margin Profile - **NOI Margin**: 68% to 72%. - **EBITDA Margin**: 55% to 60%. - **Net Margin**: Highly variable due to gains/losses on property sales and non-cash depreciation, typically ranging from 15% to 25%. - **Margin trend**: Stable to slightly expanding as occupancy reaches record highs (96.4% in 2025) and small shop occupancy peaks, improving cost recovery efficiency. ## Balance Sheet Structure - **Total assets**: Approximately $18 billion to $20 billion. - **Key asset categories**: Real estate (land, buildings, and improvements) net of accumulated depreciation makes up over 85% of total assets. Investments in and advances to real estate joint ventures is the second largest category. - **Goodwill & intangibles as % of total assets**: Minimal (under 2%), primarily consisting of in-place lease intangibles from acquisitions. - **Working capital profile**: - **Days Sales Outstanding (DSO)**: Not a primary metric; tenant receivables are closely monitored via the provision for credit losses. - **Days Inventory Outstanding (DIO)**: Not applicable. - **Days Payable Outstanding (DPO)**: 30 to 45 days for standard trade payables. - **Net working capital as % of revenue**: Typically negative. REITs do not require traditional working capital; they distribute cash and fund operations via debt and equity issuance. - **PP&E**: Represents the core shopping centre portfolio. Useful life assumptions are typically 30 to 50 years for buildings and 15 years for improvements. - **Right-of-use assets / operating leases**: Material only in the context of ground leases where Kimco is the lessee, representing approximately 1% to 2% of total assets. ## Capital Expenditure & Investment - **Capex as % of revenue**: 15% to 20%, heavily skewed towards redevelopment and tenant improvements. - **Maintenance capex vs. growth capex**: Maintenance capex (including tenant improvements and leasing commissions) runs at $150 million to $200 million annually. Growth capex (redevelopment and expansions) is guided at $175 million to $225 million for 2026. - **Major capex programmes underway**: Densification of existing assets, adding mixed-use elements (such as multifamily residential units) to grocery-anchored centres. - **Capitalised software / development costs**: Negligible. - **M&A pattern**: A mix of bolt-on single-asset acquisitions and occasional transformational corporate M&A (Weingarten Realty in 2021, RPT Realty in 2024). - **Typical acquisition multiple paid**: Shopping centre acquisitions are typically executed at a 6.0% to 7.0% capitalisation rate. ## Debt & Capital Structure - **Total debt**: Approximately $7.5 billion to $8.5 billion, with net debt to EBITDA standing at 5.4x as of year-end 2025. - **Debt/EBITDA ratio**: Current is 5.4x; target range is 5.0x to 5.5x. - **Credit rating**: A- (S&P, Fitch), A3 (Moody's). - **Key debt instruments**: A $2.0 billion unsecured revolving credit facility, unsecured term loans, and senior unsecured notes. - **Maturity profile**: Well-laddered, though 2026 features approximately $800 million of consolidated maturities at historically low coupon rates, presenting an interest expense headwind upon refinancing. - **Interest rate profile**: Over 90% fixed rate, with a weighted average interest rate typically between 3.5% and 4.5%. - **Covenants**: Standard unsecured debt covenants (Total Debt to Total Assets must be under 60%; currently operates well below this threshold). - **Share repurchase programme**: Active but opportunistic. The company repurchased 6.1 million shares in 2025 at an average price of $19.79. - **Dividend policy**: The company pays a regular quarterly cash dividend. The 2025 annualised dividend was $1.00 per share, representing an AFFO payout ratio of approximately 65% to 70%. ## Cash Flow Characteristics - **Operating cash flow conversion**: OCF consistently exceeds Net Income due to the massive non-cash add-back of real estate depreciation. - **Free cash flow margin**: The company generated over $165 million in free cash flow after dividends and leasing costs in 2025. - **Major non-cash items**: Real estate depreciation and amortisation, straight-line rent adjustments, and non-cash stock compensation. - **Working capital cash flow impact**: Minimal impact on overall cash generation. - **Capex intensity**: High. Real estate requires constant reinvestment (tenant improvements, roof replacements, parking lot paving) to maintain asset quality and occupancy. - **Cash tax rate vs. GAAP effective tax rate**: As a REIT, Kimco pays zero corporate income tax on earnings distributed to shareholders. The effective tax rate is near 0%. ## Sheet Structure 1. **Assumptions**: Hardcoded inputs for portfolio metrics, macroeconomic drivers, cap rates, and debt terms. 2. **Portfolio Metrics**: Tracks Gross Leasable Area (GLA), Anchor Occupancy, Small Shop Occupancy, Total Occupancy, and Annualised Base Rent (ABR) per square foot. 3. **Income Statement**: Projects Revenues from rental properties, Management fee income, Property operating expenses, G&A, Depreciation, and Interest expense down to Net Income. 4. **FFO & AFFO Reconciliation**: Bridges Net Income to NAREIT FFO (adding back real estate depreciation and subtracting gains on sales) and then to AFFO (adjusting for straight-line rent and maintenance capex). 5. **Balance Sheet**: Forecasts Real Estate assets, Accumulated Depreciation, Cash, Debt, and Equity. 6. **Cash Flow Statement**: Standard three-section cash flow, heavily reliant on the FFO/AFFO sheet for operating cash flow logic. 7. **Debt Schedule**: Tracks the $2.0 billion revolver, term loans, and senior notes, calculating interest expense and tracking the 2026 maturity refinancing. 8. **NAV Valuation**: Applies a market capitalisation rate to forward 12-month Net Operating Income (NOI) to determine gross asset value, subtracts net debt, and divides by shares outstanding to calculate Net Asset Value per share. ## Key Financial Relationships 1. **Rental Revenue** = Total GLA x Total Occupancy % x Implied Annualised Base Rent per sq ft. 2. **Same-Property NOI Growth** = (Current Year NOI for Same-Store Pool / Prior Year NOI for Same-Store Pool) - 1. 3. **Total Property Operating Expenses** = Real Estate Taxes + Operating and Maintenance + Provision for Credit Losses (modelled as a % of Rental Revenue). 4. **Net Operating Income (NOI)** = Revenues from rental properties - Total Property Operating Expenses. 5. **NAREIT FFO** = Net Income Available to Common Shareholders + Depreciation and Amortisation related to real estate - Gains on sales of properties. 6. **AFFO** = NAREIT FFO - Straight-line rent adjustments - Recurring capital expenditures (Tenant Improvements and Leasing Commissions). 7. **Net Debt** = Total Notes and Bonds Payable + Mortgages Payable + Revolving Credit Facility - Cash and Cash Equivalents. 8. **Net Debt to EBITDA** = Net Debt / Annualised Consolidated EBITDA. 9. **Implied Capitalisation Rate** = Forward 12-Month NOI / Implied Gross Real Estate Value. 10. **Dividend Payout Ratio** = Total Common Dividends Paid / AFFO. ## Cross-Sheet Dependencies - The **Portfolio Metrics** sheet is the engine of the model; GLA and Occupancy assumptions directly drive Rental Revenue on the **Income Statement**. - The **Income Statement** calculates Net Income, which is the starting point for the **FFO & AFFO Reconciliation** sheet. - The **FFO & AFFO Reconciliation** sheet calculates the true cash generation capacity, which feeds the Operating Cash Flow section of the **Cash Flow Statement**. - The **Debt Schedule** calculates Interest Expense, which flows back to the **Income Statement**. This creates a potential circularity if the revolver is used to fund cash shortfalls, as interest expense lowers net income, reducing cash flow, and requiring more revolver draw. - The **NAV Valuation** sheet pulls forward NOI from the **Income Statement** and current Net Debt from the **Balance Sheet** to calculate the target share price. ## Sign Convention - **Revenues and Assets**: Entered and displayed as positive numbers. - **Expenses and Liabilities**: Entered as positive numbers but subtracted in formulas (e.g., NOI = Revenue - Expenses). - **Cash Flow Statement**: Cash inflows are positive; cash outflows (capex, dividends, debt repayment) are negative. - **Contra-assets**: Accumulated depreciation is entered as a positive number but subtracted from Gross Real Estate to calculate Net Real Estate. ## Things Most Likely to Go Wrong - **Confusing GAAP Net Income with FFO**: REITs are valued on FFO and AFFO. Using Net Income or standard EPS to calculate valuation multiples will result in massive errors due to the distortion of real estate depreciation. - **Ignoring Straight-Line Rent**: GAAP requires rent to be averaged over the lease term. The model must deduct non-cash straight-line rent revenue from FFO to arrive at AFFO. - **Mismodelling the 2026 Debt Maturities**: Kimco has $800 million of debt maturing in 2026 at historically low rates. The model must reflect a step-up in interest expense as this debt is refinanced at current market rates. - **Overestimating Occupancy**: Portfolio occupancy hit an all-time high of 96.4% in 2025. Modelling occupancy to expand significantly beyond 97% is unrealistic for a retail REIT; growth must come from rent spreads, not just filling vacant space. - **Forgetting Pro-Rata Joint Ventures**: Kimco holds significant assets in unconsolidated joint ventures. The model must account for the pro-rata share of JV NOI and debt when calculating consolidated metrics like Net Debt to EBITDA. - **Capitalising vs. Expensing Tenant Improvements**: Tenant improvements and leasing commissions are capitalised on the balance sheet and amortised, but they represent real cash outflows that must be deducted in the AFFO calculation. - **Provision for Credit Losses**: This must be modelled as a contra-revenue or expense line (typically 75 to 100 bps of rental revenue). Ignoring it will overstate NOI. ## Validation Checks - **Occupancy Check**: Total portfolio occupancy must not exceed 100% (flag if >97.5% as it breaks historical maximums). - **FFO per Share Check**: 2026 FFO per share should land between $1.80 and $1.84 based on management guidance. - **Net Debt to EBITDA Check**: Leverage should remain between 5.0x and 6.0x. Flag if it breaches 6.0x, as this threatens the company's A- credit rating. - **Same-Property NOI Growth Check**: Should normalise between 2.0% and 3.5%. Flag if the model implies >5.0% sustained growth. - **Dividend Coverage Check**: AFFO payout ratio should remain below 85% to ensure the dividend is safely covered by cash flow. - **Balance Sheet Check**: Total Assets must exactly equal Total Liabilities plus Shareholders' Equity in all forecast periods. - **Credit Loss Check**: Provision for credit losses should be at least 0.75% of total rental revenues. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Total Gross Leasable Area (GLA) | 100.0 | Millions sq ft | Based on year-end 2025 actuals. | | Total Portfolio Occupancy | 96.4 | % | Matches the all-time high reported in Q4 2025. | | Same-Property NOI Growth | 3.0 | % | Midpoint of management's 2026 guidance (2.5% to 3.5%). | | Provision for Credit Losses | 0.85 | % of Rental Rev | Midpoint of 2026 guidance (75 to 100 bps). | | Property Operating Expense Margin | 29.0 | % of Rental Rev | Historical average required to maintain ~71% NOI margin. | | General & Administrative Expense | 4.5 | % of Total Rev | Consistent with historical run-rate. | | Redevelopment Capex | 200.0 | $ Millions | Midpoint of 2026 guidance ($175M to $225M). | | Acquisitions | 200.0 | $ Millions | Midpoint of 2026 guidance ($100M to $300M). | | Dispositions | 500.0 | $ Millions | Midpoint of 2026 guidance ($400M to $600M). | | Refinancing Interest Rate (2026) | 5.5 | % | Estimated market rate for unsecured notes replacing low-coupon 2026 maturities. | | Target Net Debt to EBITDA | 5.4 | x | Matches year-end 2025 actuals. | | Annual Dividend per Share | 1.00 | $ | Based on the declared quarterly dividend of $0.25. | | NAV Capitalisation Rate | 6.5 | % | Standard market cap rate for high-quality grocery-anchored retail assets. | | Effective Tax Rate | 0.0 | % | As a REIT, Kimco pays no corporate tax on distributed earnings. | ## Data Sources & Benchmarks - **SEC EDGAR**: Source for Kimco's 10-K, 10-Q, and 8-K filings. - **Kimco Investor Relations**: Source for quarterly supplemental financial packages, which are critical for finding pro-rata JV data, same-property NOI, and lease expiration schedules. - **Key Peers for Benchmarking**: Regency Centers (REG), Brixmor Property Group (BRX), Federal Realty Investment Trust (FRT), and Kite Realty Group (KRG). - **Industry Data Sources**: Green Street Advisors for retail real estate cap rates and NAV estimates; ICSC (International Council of Shopping Centers) for broader retail foot traffic and sales trends. - **Consensus Estimates**: FactSet or Bloomberg for consensus FFO and AFFO estimates. ## Sources - Kimco Realty Corporation Q4 2025 Earnings Release and Supplemental Information (February 12, 2026). - Kimco Realty Corporation 2024 Annual Report on Form 10-K. - Kimco Realty Q4 2025 Earnings Call Transcript. - Kimco Realty Investor Relations Website (investors.kimcorealty.com). --- ## Frequently asked questions ### What kind of properties does Kimco Realty own and operate? Kimco Realty is North America's largest publicly traded owner and operator of open-air, grocery-anchored shopping centres and mixed-use assets. The company generates revenue by leasing retail space primarily to necessity-based tenants across the United States. ### How does Kimco Realty generate its revenue? Kimco Realty primarily generates revenue from rental properties, which accounts for approximately 98% of its total revenue. This recurring income comes from long-term leases with tenants in its grocery-anchored shopping centers located in strategic metropolitan markets. ### What is Kimco Realty's capital expenditure strategy? Kimco Realty's capital expenditure, typically 15% to 20% of revenue, is heavily focused on redevelopment and tenant improvements. The company also invests in growth capex for densification of existing assets and adding mixed-use elements to its grocery-anchored centres. ### What is the assumed revenue growth rate in the Kimco Realty financial model? The financial model for Kimco Realty assumes a Revenue_Growth rate of 0.2. This assumption helps forecast future rental income and overall top-line expansion for the company. ### What is the primary purpose of the Kimco Realty financial model? The Kimco Realty financial model forecasts Funds From Operations (FFO), Adjusted Funds From Operations (AFFO), and Net Asset Value (NAV). Its main purpose is to determine equity valuation and dividend sustainability, assisting equity research analysts in setting a target price. ### Can I download an Excel financial model for Kimco Realty? Yes, an Excel financial model for Kimco Realty is available for download. This model forecasts financials from FY2026 to FY2030 and includes key assumptions for revenue, costs, and capital expenditures. [Interactive forecast calculator](https://finamodel.com/companies/kimco-realty/forecast)