Stock Analysis on Net

CoStar Group Inc. (NASDAQ:CSGP)

This company has been moved to the archive! The financial data has not been updated since July 26, 2023.

Enterprise Value to FCFF (EV/FCFF) 

Microsoft Excel

Free Cash Flow to The Firm (FCFF)

CoStar Group Inc., FCFF calculation

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Net income 369,453 292,564 227,128 314,963 238,334
Net noncash charges 314,695 331,909 272,864 229,768 178,427
Changes in operating assets and liabilities, net of acquisitions (205,528) (154,742) (13,886) (86,951) (81,303)
Net cash provided by operating activities 478,620 469,731 486,106 457,780 335,458
Interest paid, net of tax1 22,745 22,820 4,986 1,610 1,193
Proceeds from sale of property and equipment and other assets 30,097 612
Purchases of property and equipment and other assets (58,574) (65,220) (48,347) (46,197) (29,632)
Free cash flow to the firm (FCFF) 472,888 427,943 442,745 413,193 307,019

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).


Operating Cash Flow
The net cash provided by operating activities demonstrated an upward trend from 2018 through 2020, increasing from $335,458 thousand to $486,106 thousand. However, in 2021, a slight decline to $469,731 thousand was observed, followed by a modest recovery in 2022 to $478,620 thousand. Overall, the operating cash flow displayed robust growth over the five-year period, with minor fluctuations in the last two years.
Free Cash Flow to the Firm (FCFF)
Free cash flow to the firm increased substantially from $307,019 thousand in 2018 to $442,745 thousand in 2020, indicating strong cash generation ability beyond operating needs. Similar to operating cash flow, a dip was noted in 2021, with FCFF decreasing to $427,943 thousand. In 2022, the FCFF saw a significant rebound, rising to $472,888 thousand, surpassing previous years except for 2020. This pattern suggests effective management of capital expenditures and working capital adjustments over the period.
General Observations
Both net cash provided by operating activities and free cash flow to the firm exhibited consistent growth over the analyzed years, reflecting stable operational performance and healthy liquidity positions. The decline observed in 2021 may point to temporary operational challenges or increased investments but was not sustained, as evidenced by the recovery in 2022. The alignment between operating cash flow and FCFF trends indicates controlled capital spending relative to cash generated from operations.

Interest Paid, Net of Tax

CoStar Group Inc., interest paid, net of tax calculation

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Effective Income Tax Rate (EITR)
EITR1 24.05% 27.58% 16.18% 19.44% 16.08%
Interest Paid, Net of Tax
Interest paid, before tax 29,947 31,510 5,948 1,998 1,421
Less: Interest paid, tax2 7,202 8,690 962 388 228
Interest paid, net of tax 22,745 22,820 4,986 1,610 1,193

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 See details »

2 2022 Calculation
Interest paid, tax = Interest paid × EITR
= 29,947 × 24.05% = 7,202


Effective Income Tax Rate (EITR)
The effective income tax rate exhibited variability over the examined period. Starting at 16.08% in 2018, the rate increased to 19.44% in 2019, followed by a decline to 16.18% in 2020. Subsequently, there was a notable rise to 27.58% in 2021, with a slight decrease to 24.05% in 2022. This pattern indicates fluctuations in tax obligations relative to earnings before taxes, with the most significant increase occurring between 2020 and 2021.
Interest Paid, Net of Tax (in thousands of US$)
Interest expenses, net of tax, demonstrated an upward trend throughout the period. The amount increased from $1,193 thousand in 2018 to $1,610 thousand in 2019. A sharper rise was observed in 2020, reaching $4,986 thousand. The escalation continued more dramatically in 2021, climbing to $22,820 thousand, and remaining relatively stable at $22,745 thousand in 2022. The substantial increase starting from 2020 suggests growing debt levels or higher interest rates impacting the company's financing costs.

Enterprise Value to FCFF Ratio, Current

CoStar Group Inc., current EV/FCFF calculation, comparison to benchmarks

Microsoft Excel
Selected Financial Data (US$ in thousands)
Enterprise value (EV) 30,476,681
Free cash flow to the firm (FCFF) 472,888
Valuation Ratio
EV/FCFF 64.45
Benchmarks
EV/FCFF, Industry
Industrials 33.40

Based on: 10-K (reporting date: 2022-12-31).

If the company EV/FCFF is lower then the EV/FCFF of benchmark then company is relatively undervalued.
Otherwise, if the company EV/FCFF is higher then the EV/FCFF of benchmark then company is relatively overvalued.


Enterprise Value to FCFF Ratio, Historical

CoStar Group Inc., historical EV/FCFF calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in thousands)
Enterprise value (EV)1 25,361,735 18,292,660 30,185,814 23,931,971 15,576,296
Free cash flow to the firm (FCFF)2 472,888 427,943 442,745 413,193 307,019
Valuation Ratio
EV/FCFF3 53.63 42.75 68.18 57.92 50.73
Benchmarks
EV/FCFF, Industry
Industrials 24.30 28.80 189.49

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 See details »

2 See details »

3 2022 Calculation
EV/FCFF = EV ÷ FCFF
= 25,361,735 ÷ 472,888 = 53.63


Enterprise Value (EV)
The enterprise value showed an overall increasing trend from 2018 to 2022, with notable fluctuations. Starting at approximately 15.58 billion USD in 2018, EV rose significantly to around 23.93 billion USD in 2019 and further increased to approximately 30.19 billion USD in 2020. However, in 2021, EV experienced a marked decline to about 18.29 billion USD before rebounding to roughly 25.36 billion USD in 2022.
Free Cash Flow to the Firm (FCFF)
Free cash flow to the firm exhibited steady growth over the period. Beginning at approximately 307 million USD in 2018, FCFF increased in each subsequent year, reaching around 472.9 million USD in 2022. This indicates an improving cash-generating capability by the firm over time.
EV/FCFF Ratio
The EV to FCFF ratio demonstrated variability with no consistent directional trend. It started at 50.73 in 2018 and increased to 57.92 in 2019, followed by a further rise to 68.18 in 2020, indicating a growing valuation multiple relative to cash flow. In 2021, the ratio dropped sharply to 42.75, coinciding with the substantial decrease in EV. In 2022, the ratio increased again to 53.63, reflecting the partial recovery in enterprise value alongside continued FCFF growth.
Insights
The data reveals a company experiencing fluctuating valuation levels over the five-year period, with enterprise value affected more dramatically than free cash flow. The improvement in FCFF suggests solid operational cash performance, whereas the volatility in EV and the EV/FCFF ratio may indicate external market perceptions, strategic changes, or other factors influencing valuation independent of cash flow trends.