# CoStar Group (CSGP) Financial Model Free Excel 3-statement financial model and company analysis for CoStar Group. - Canonical: https://finamodel.com/companies/costar-group - Industry: Marketplaces - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/CSGP.xlsx ## Model Purpose To forecast CoStar Group's (CSGP) revenue growth, margin expansion, and cash flow generation to determine its equity valuation, focusing specifically on the profitability inflection of its Residential segment (Homes.com) and the resilience of its Commercial data products. ## Company Overview - CoStar Group is a leading global provider of online real estate marketplaces, information, analytics, and 3D digital twin technology for the commercial and residential property markets. - **Business Segments:** Commercial Real Estate (~55% of revenue, including CoStar Suite, LoopNet, Information Services) and Residential Real Estate (~45% of revenue, including Apartments.com and Homes.com). - **Key Geographies:** Primarily North America (over 90% of revenue), with a growing presence in the UK, Europe, and Australia. - **Business Model:** Subscription-based SaaS (data and analytics) and duration-based marketplace advertising. It is an asset-light, high-gross-margin business, though it requires heavy initial sales and marketing investments to build marketplace liquidity. - **Competitive Position:** CoStar holds a near-monopoly in US commercial real estate data. Apartments.com is the #1 multifamily listing network, and Homes.com has rapidly grown to become the #2 residential portal in the US, challenging Zillow and Realtor.com. - **Recent Major Events:** In 2024/2025, CoStar completed the acquisitions of Matterport (3D spatial data) and Domain. The company also executed a massive marketing blitz for Homes.com, which depressed 2024/2025 GAAP earnings but drove record traffic, and initiated a $1.5 billion share repurchase programme ($500 million completed in Q4 2025, $700 million planned for 2026). ## Revenue Deep Dive ### Commercial Segment: CoStar Suite - **Segment Name:** CoStar Suite (rolls up into Commercial) - **Revenue Driver Formula:** Number of Subscriber Firms x Average Revenue Per User (ARPU) - **Historical Growth Rate:** 8-10% CAGR - **Key Growth Levers & Headwinds:** High renewal rates (typically ~90%+) provide a strong floor. Headwinds include commercial real estate market downturns and broker headcount reductions. - **Pricing Dynamics:** Contractual, subscription-based with built-in annual price escalators. - **Revenue Recognition:** Recognised rateably over the contract term; creates significant deferred revenue. - **Seasonality:** Relatively smooth due to the subscription model, though Q4 often sees higher net new bookings. ### Commercial Segment: LoopNet & Information Services - **Segment Name:** LoopNet / Information Services (rolls up into Commercial) - **Revenue Driver Formula:** Number of Premium Listings x Duration/Tier Price (LoopNet); Subscriptions x Fee (Information Services/STR) - **Historical Growth Rate:** 10-15% CAGR - **Key Growth Levers & Headwinds:** LoopNet benefits from high commercial vacancies as landlords pay for premium exposure to lease empty space. - **Pricing Dynamics:** Tiered advertising packages (Diamond, Platinum, Gold). ### Residential Segment: Multifamily (Apartments.com) - **Segment Name:** Multifamily (rolls up into Residential) - **Revenue Driver Formula:** Number of Advertised Properties x Average Ad Package Price - **Historical Growth Rate:** 15-20% CAGR - **Key Growth Levers & Headwinds:** Counter-cyclical to the housing market. When apartment vacancies rise, property managers buy more advertising to fill units. - **Pricing Dynamics:** Subscription-based advertising packages. ### Residential Segment: Homes.com - **Segment Name:** Residential / Homes.com - **Revenue Driver Formula:** Number of Agent Memberships x Monthly Membership Fee - **Historical Growth Rate:** 30%+ CAGR (hyper-growth phase) - **Key Growth Levers & Headwinds:** Transitioning from a free traffic-building phase to aggressive monetisation. The "Your Listing, Your Lead" model is the primary growth lever against competitors. - **Pricing Dynamics:** Tiered membership subscriptions for residential real estate agents. ## Cost Structure ### Variable Costs / COGS - **Line-by-line breakdown:** Cost of revenues primarily includes the costs of the research fleet (vehicles, fuel), salaries for data researchers, website hosting, data acquisition costs, and software licensing. - **Gross margin range:** 80-82% (highly stable and best-in-class). - **Key input costs:** Cloud computing (AWS) and human capital for data verification. - **How COGS scales:** Step-function. The database has massive operating leverage; adding a new subscriber costs almost nothing marginally. ### Operating Expenses - **Selling & Marketing (S&M):** The largest expense line. Includes massive national advertising campaigns (e.g., Super Bowl ads for Homes.com) and a large direct sales force. Historically 30-40% of revenue, but spiked higher during the Homes.com launch. - **Software Development (R&D):** Typically 8-10% of revenue. Covers platform maintenance, AI integration (Homes AI), and app development. - **General & Administrative (G&A):** Typically 10-12% of revenue. Corporate overhead, legal, and executive compensation. - **Depreciation & Amortisation:** Elevated due to serial acquisitions (Matterport, STR, Ten-X). Split heavily towards amortisation of acquired intangible assets. - **Stock-Based Compensation:** Significant (typical for tech). Runs at roughly 4-6% of revenue. ### Margin Profile - **Gross Margin:** 80-82% - **Adjusted EBITDA Margin:** ~13-14% in 2024/2025 (depressed by Homes.com investment), guiding to 20-21% in 2026. Mature segments (CoStar Suite) run at 40%+ margins. - **Net Margin:** Highly volatile recently (near 0% in 2025) due to M&A integration costs and heavy marketing, expected to expand as marketing normalises. ## Balance Sheet Structure - **Total assets:** ~$10.5 billion - **Key asset categories:** Cash and cash equivalents (~$3.6 billion), Goodwill and Intangible Assets (~$4.5 billion+ from acquisitions), and PP&E. - **Goodwill & intangibles:** Represents >40% of total assets due to the roll-up strategy (LoopNet, STR, Ten-X, Matterport). - **Working capital profile:** - **DSO:** 30-40 days. - **DIO:** N/A (software/services). - **DPO:** 25-35 days. - **Net working capital:** Structurally negative. Customers pay for annual subscriptions upfront, creating large deferred revenue balances. - **Funding growth:** The company funds growth efficiently through this negative working capital dynamic. - **PP&E:** Historically light, but recently elevated due to the $400M+ buildout of the Richmond, Virginia corporate campus. ## Capital Expenditure & Investment - **Capex as % of revenue:** Historically 2-4%, but spiked to ~12-14% in 2024/2025 due to the Richmond campus project. - **Maintenance vs. growth:** 90% of recent capex is growth/expansion (Richmond campus, data centre upgrades). - **Capitalised software:** Material, as the company capitalises certain internal-use software development costs. - **M&A pattern:** Transformational and bolt-on acquirer. CoStar uses its premium stock and cash pile to acquire adjacencies (e.g., Matterport for 3D spatial data, Domain for international expansion). ## Debt & Capital Structure - **Total debt:** Effectively zero traditional long-term debt. The company operates with a pristine, cash-rich balance sheet. - **Net debt:** Deeply negative (net cash position of ~$3.6 billion). - **Credit facility:** Maintains an undrawn revolving credit facility for liquidity and M&A flexibility. - **Share repurchase programme:** Highly active. Completed a $500 million Accelerated Share Repurchase (ASR) in Q4 2025. Authorised a new $1.5 billion programme, with $700 million planned for deployment in 2026. - **Dividend policy:** No dividend. Capital is returned via buybacks or reinvested in M&A. ## Cash Flow Characteristics - **Operating cash flow conversion:** Very strong. OCF significantly exceeds GAAP Net Income due to high D&A, stock-based compensation, and positive working capital dynamics (deferred revenue growth). - **Free cash flow margin:** Historically 20-25%, temporarily depressed in 2024/2025 due to the Richmond campus capex and Homes.com marketing spend, but poised to rebound. - **Working capital cash flow impact:** Source of cash. As bookings grow, deferred revenue increases, providing upfront cash before revenue is recognised. - **Cash tax rate:** Generally tracks close to the statutory rate (21-24%), though timing differences arise from amortisation of intangibles. ## Sheet Structure 1. **Assumptions**: Hardcoded inputs for macroeconomic drivers, segment growth rates, margin targets, and capital allocation (buybacks). 2. **Revenue Build**: Detailed build separating the Commercial Segment (CoStar Suite, LoopNet, Info Services) and Residential Segment (Apartments.com, Homes.com) using volume and pricing drivers. 3. **Income Statement**: GAAP view mirroring the 10-K, with a clear bridge at the bottom to Adjusted EBITDA and Adjusted Net Income. 4. **Balance Sheet**: Assets, Liabilities, and Equity. Must explicitly break out Deferred Revenue, Goodwill, and Intangible Assets. 5. **Cash Flow Statement**: Indirect method starting from GAAP Net Income, adding back D&A, SBC, and tracking the deferred revenue working capital benefit. 6. **Working Capital & Depreciation**: Schedules for accounts receivable, deferred commissions, deferred revenue, and PP&E/Intangibles roll-forward. 7. **Debt & Equity Schedule**: Tracks the massive cash balance, interest income, and the execution of the $700 million 2026 share repurchase programme. 8. **DCF Valuation**: Unlevered free cash flow build, WACC calculation, and terminal value based on mature margin assumptions. ## Key Financial Relationships 1. `Commercial Segment Revenue = CoStar Suite Revenue + LoopNet Revenue + Information Services Revenue + Other Commercial Marketplaces` 2. `Residential Segment Revenue = Multifamily (Apartments.com) Revenue + Homes.com Revenue` 3. `Total Revenue = Commercial Segment Revenue + Residential Segment Revenue` 4. `Cost of Revenues = Total Revenue x (1 - Gross Margin %)` 5. `Selling & Marketing Expense = Base S&M + Homes.com Discretionary Marketing Spend` 6. `Adjusted EBITDA = GAAP Net Income + Provision for Income Taxes + Interest Expense - Interest Income + Depreciation & Amortisation + Stock-Based Compensation + Acquisition/Integration Costs` 7. `Deferred Revenue (End of Period) = Deferred Revenue (Beginning of Period) + Total Net New Bookings - Recognised Revenue` 8. `Interest Income = Average Cash Balance x Yield on Cash Equivalents` 9. `Shares Outstanding (End of Period) = Shares Outstanding (Beginning of Period) - (Share Repurchase Spend / Average Share Price) + Shares Issued via SBC` 10. `Unlevered Free Cash Flow = Adjusted EBITDA - Capex - Change in Net Working Capital - Cash Taxes` ## Cross-Sheet Dependencies - The **Revenue Build** is the engine of the model; it feeds the top line of the **Income Statement** and drives the Deferred Revenue additions in the **Working Capital** sheet. - The **Working Capital** sheet calculates the change in Deferred Revenue, which flows directly into the **Cash Flow Statement** as a major operating cash flow adjustment. - The **Cash Flow Statement** determines the ending cash balance, which flows to the **Balance Sheet** and feeds the **Debt & Equity Schedule** to calculate Interest Income for the next period's **Income Statement** (creating a minor circularity that requires an iterative calculation or average balance toggle). - The **Debt & Equity Schedule** calculates the reduced share count from buybacks, which feeds the EPS calculation on the **Income Statement**. ## Sign Convention - **Income Statement:** Revenues are positive. All expenses (COGS, S&M, R&D, G&A, D&A) are negative. Net Income is the sum of revenues and negative expenses. - **Balance Sheet:** All assets are positive. All liabilities and equity are positive. Total Assets must equal Total Liabilities + Equity. - **Cash Flow Statement:** Net Income is positive. Non-cash add-backs (D&A, SBC) are positive. Increases in assets (use of cash) are negative. Increases in liabilities (source of cash, like deferred revenue) are positive. Capex and share repurchases are negative. ## Things Most Likely to Go Wrong - **GAAP vs. Non-GAAP Disconnect:** CoStar's GAAP Net Income in 2025 was only $7 million due to M&A costs and heavy amortisation, while Adjusted EBITDA was $442 million. The model must explicitly forecast the bridge items (SBC, M&A costs) or it will drastically undervalue the core cash generation. - **Segment Reclassification:** CoStar recently shifted its reporting narrative to "Commercial" vs "Residential" segments. Ensure historical data (which broke out CoStar, LoopNet, Multifamily separately) is correctly mapped to this new two-pillar structure. - **Extrapolating Peak Capex:** Capex spiked to $400M+ in 2024/2025 due to the Richmond campus buildout. Do not hold this capex % constant in the terminal year; it must step down to historical maintenance levels (2-4% of revenue). - **Ignoring Deferred Revenue:** Because CoStar collects cash upfront for annual subscriptions, deferred revenue is a massive source of operating cash flow during high-growth periods. Failing to model the deferred revenue roll-forward will understate OCF. - **Homes.com Margin Drag:** The Residential segment currently operates at a loss due to massive marketing spend. The model must reflect a distinct margin profile for Residential (improving over time) vs Commercial (highly profitable, 40%+ margins). - **Interest Income Impact:** With ~$3.6 billion in cash, interest income is a material contributor to the bottom line. If interest rates fall, this non-operating income stream will compress. - **Stock-Based Compensation:** SBC is a real dilution cost. Excluding it entirely from valuation flatters the margins. Ensure share count increases from SBC are netted against the share repurchase programme. - **Unique Visitor Metrics:** Do not tie revenue directly to Unique Visitors in the model. Traffic is a leading indicator, but revenue is driven by agent/broker subscriptions and ad packages. ## Validation Checks - "Gross margin should be highly stable in the 80-82% range; flag if it drops below 80%." - "Adjusted EBITDA margin must show expansion from ~14% in 2025 towards the 20-21% guidance for 2026." - "Capex should normalise to <5% of revenue post-2026 after the Richmond campus is completed." - "Operating Cash Flow must consistently exceed GAAP Net Income (OCF/Net Income > 2.0x) due to D&A, SBC, and deferred revenue." - "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period." - "Net Debt should remain negative (net cash position) unless a massive transformational acquisition is modelled." - "Share count should decrease YoY in 2026, validating that the $700M buyback outpaces SBC dilution." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | 2026 Total Revenue Growth | 17.0 | % | Midpoint of 2026 guidance ($3.78B - $3.82B on $3.25B 2025 base) | | Commercial Segment Growth | 12.0 | % | Historical trend and recovery in commercial real estate volumes | | Residential Segment Growth | 25.0 | % | Continued hyper-growth and monetisation of Homes.com | | Gross Margin | 81.5 | % | Consistent historical average for the data/marketplace business | | 2026 Adjusted EBITDA Margin | 20.5 | % | Midpoint of 2026 guidance ($740M - $800M) | | S&M as % of Revenue | 35.0 | % | Elevated but stepping down from 2024/2025 peak as Homes.com marketing normalises | | R&D as % of Revenue | 9.0 | % | Historical average, supporting Homes AI and platform integration | | G&A as % of Revenue | 11.0 | % | Historical average for corporate overhead | | 2026 Capex | 250 | $ Millions | Tapering down from 2025 peak as Richmond campus nears completion | | Long-term Capex / Revenue | 3.5 | % | Normalised maintenance and standard growth capex | | Effective Tax Rate | 24.0 | % | Historical average cash tax rate | | Share Repurchase (2026) | 700 | $ Millions | Management stated plan for 2026 | | Yield on Cash Equivalents | 4.0 | % | Assumed interest rate on $3.6B cash pile | | WACC | 9.5 | % | Standard discount rate for high-growth, debt-free tech/data platform | | Terminal Growth Rate | 3.5 | % | Reflects strong pricing power and GDP+ long-term growth in real estate data | ## Data Sources & Benchmarks - **Filings:** SEC EDGAR (CoStar Group 10-K, 10-Q, 8-K), CoStar Investor Relations website (investors.costargroup.com) for earnings presentations and supplemental data. - **Key Peers for Benchmarking:** Zillow Group (Z), Redfin (RDFN), Realtor.com (News Corp - NWSA), Thomson Reuters (TRI), MSCI (MSCI). - **Industry Data:** National Association of Realtors (NAR) for existing home sales and agent counts; CBRE/JLL market reports for commercial real estate transaction volumes and vacancy rates. - **Consensus Estimates:** FactSet or Bloomberg for forward revenue and Adjusted EBITDA consensus. - **Proprietary Data:** SimilarWeb or Google Analytics for tracking average monthly unique visitors to Homes.com vs Realtor.com/Zillow. ## Sources - CoStar Group Q4 2025 Earnings Press Release (February 24, 2026) - CoStar Group 2025 Annual Report (Form 10-K) - CoStar Group Q4 2025 Earnings Call Transcript - CoStar Group Investor Relations Presentations (Q4 2025) - Speedwell Research: CoStar Group Business Update - Simply Wall St: CoStar Group Margin Analysis --- ## Frequently asked questions ### What does CoStar Group do? CoStar Group is a leading global provider of online real estate marketplaces, information, analytics, and 3D digital twin technology. It serves both commercial and residential property markets through segments like CoStar Suite, LoopNet, Apartments.com, and Homes.com. ### How does CoStar Group generate revenue? CoStar Group generates revenue through a subscription-based SaaS model for its data and analytics products, as well as duration-based marketplace advertising. Its business model is asset-light and high-gross-margin, relying on significant initial sales and marketing investments. ### What are CoStar Group's typical capital expenditure patterns? Historically, CoStar Group's capital expenditure as a percentage of revenue has been 2-4%, but it spiked to 12-14% in 2024/2025 due to the buildout of its Richmond corporate campus. The majority of recent capex is for growth and expansion, including data center upgrades. ### What is the assumed revenue growth rate for CoStar Group in the financial model? The financial model assumes a revenue growth rate of approximately 15.08% for CoStar Group. This forecast considers the profitability inflection of its Residential segment (Homes.com) and the resilience of its Commercial data products. ### How does CoStar Group's working capital profile impact its financial model? CoStar Group has a structurally negative net working capital profile, primarily because customers often pay for annual subscriptions upfront, creating large deferred revenue balances. This dynamic allows the company to efficiently fund its growth. ### Can I download an Excel financial model for CoStar Group (CSGP)? Yes, an Excel financial model for CoStar Group (CSGP) is available for download. This model forecasts revenue growth, margin expansion, and cash flow generation from FY2026 to FY2030 to determine its equity valuation. [Interactive forecast calculator](https://finamodel.com/companies/costar-group/forecast)