DCF Tool

IBP

Installed Building Products Inc – Plumbing, Heating, and Air-Conditioning Contractors
headquartered in columbus, ohio, installed building products has over 125+ locations throughout the united states. we are the second largest insulation installer in the u.s. residential new construction market. we offer a diverse portfolio of products for new and existing residential, multifamily, and commercial building projects. we specialize in insulation, and install a number of additional products including garage doors, siding, gutters, shower doors, mirrors, bath hardware, closets and shelving, door locksets and fireplaces. ibp prides itself on our longstanding relationships with leading builders in markets nationwide. integrity is the cornerstone of those relationships and our business. our comprehensive training, knowledge of local building codes, and strong manufacturer relationships deliver smooth, hassle free results. and service at the local level is the quality that keeps our customers coming back time after time. we believe in fostering leadership at the local level thro
Analysis Results
Intrinsic Value $721.08
Latest Price $123.97
Relative Value 83% undervalued
Thoughts on this result? Let us know.
Ad
Cash Flow (Billions)
Analysis Parameters
%
%
%
New Ticker
Ad
Analysis Details
Growth Rate Projection

An exponential growth model was fit to the past cash flow data, giving more weight to more recent years. This model determined a growth rate estimate of 39.3%.

Weighted Average Cost of Capital (WACC)

The calculated WACC is 9.8%. This value is used as the default discount rate.

Value of Future Flows

Assuming a growth rate of 39.3%, the cash flows for the next 5 years are projected.

The present value of each year's flow is adjusted to present value using the discount rate.

Year Future flow (billion) Present value (billion)
2023 0.568 0.518
2024 0.792 0.657
2025 1.1 0.834
2026 1.54 1.06
2027 2.14 1.34
Terminal Value

Assuming a growth rate after the projection years of 2.0%, the terminal value of the company would be 28.1 billion. This corresponds to a present value of 16.1 billion.

Intrinsic Value Per Share

The total present value of the projected cash flows is 4.41 billion. Adding in the terminal value gives a total present value of 20.5 billion.

There are presently 28.4 million outstanding shares, so the intrinsic value per share is 721.08.

Financial Statements

The following data was to determine the past cash flows.

Current Assets 884,411,000
Current Cash 229,627,000
Current Liabilities 328,061,000
Current Debt 33,491,000
Non-Cash Working Capital (NCWC) 360,214,000
Change in NCWC 109,366,000
EBIT 329,302,000
Tax Provision 79,879,000
Depreciation and Amortization 117,677,000
Capital Expenditure -45,646,000
Unlevered Free Cash Flow 423,973,950
Current Assets 859,316,000
Current Cash 333,485,000
Current Liabilities 307,569,000
Current Debt 32,586,000
Non-Cash Working Capital (NCWC) 250,848,000
Change in NCWC 69,472,000
EBIT 187,880,000
Tax Provision 36,712,000
Depreciation and Amortization 102,899,000
Capital Expenditure -36,979,000
Unlevered Free Cash Flow 278,908,272
Current Assets 623,943,000
Current Cash 231,520,000
Current Liabilities 236,475,000
Current Debt 25,428,000
Non-Cash Working Capital (NCWC) 181,376,000
Change in NCWC 2,515,000
EBIT 161,867,000
Tax Provision 33,938,000
Depreciation and Amortization 87,996,000
Capital Expenditure -33,587,000
Unlevered Free Cash Flow 176,912,909
Current Assets 581,949,000
Current Cash 215,850,000
Current Liabilities 214,149,000
Current Debt 26,911,000
Non-Cash Working Capital (NCWC) 178,861,000
Change in NCWC 22,056,000
EBIT 121,160,000
Tax Provision 24,446,000
Depreciation and Amortization 79,063,000
Capital Expenditure -50,167,000
Unlevered Free Cash Flow 140,128,010
Current Assets 411,545,000
Current Cash 100,502,000
Current Liabilities 181,686,000
Current Debt 27,448,000
Non-Cash Working Capital (NCWC) 156,805,000
Change in NCWC 31,916,000
EBIT 93,217,000
Tax Provision 17,438,000
Depreciation and Amortization 58,725,000
Capital Expenditure -35,232,000
Unlevered Free Cash Flow 126,107,533
Current Assets 354,942,000
Current Cash 92,563,000
Current Liabilities 159,806,000
Current Debt 22,316,000
Non-Cash Working Capital (NCWC) 124,889,000
Change in NCWC 52,964,000
EBIT 74,266,000
Tax Provision 14,680,000
Depreciation and Amortization 55,142,000
Capital Expenditure -31,668,000
Unlevered Free Cash Flow 131,172,920
Current Assets 192,391,000
Current Cash 14,482,000
Current Liabilities 130,105,000
Current Debt 24,121,000
Non-Cash Working Capital (NCWC) 71,925,000
Change in NCWC 7,501,000
EBIT 66,050,000
Tax Provision 21,174,000
Depreciation and Amortization 34,830,000
Capital Expenditure -27,013,000
Unlevered Free Cash Flow 57,906,454
Current Assets 150,232,000
Current Cash 6,818,000
Current Liabilities 97,422,000
Current Debt 18,432,000
Non-Cash Working Capital (NCWC) 64,424,000
Change in NCWC 21,293,000
EBIT 44,952,000
Tax Provision 15,413,000
Depreciation and Amortization 23,239,000
Capital Expenditure -27,305,000
Unlevered Free Cash Flow 45,655,146
Current Assets 119,288,000
Current Cash 10,761,000
Current Liabilities 76,556,000
Current Debt 11,160,000
Non-Cash Working Capital (NCWC) 43,131,000
Change in NCWC 8,209,000
EBIT 25,586,000
Tax Provision 8,607,000
Depreciation and Amortization 15,011,000
Capital Expenditure -6,176,000
Unlevered Free Cash Flow 32,880,201

This analysis is provided for informational purposes only and does not constitute financial or investing advice. For more information on the advantages and limitations of DCF analysis see background. This information is provided on an "as is" basis. No warranty, expressed or implied, is made regarding accuracy, adequacy, completeness, legality, reliability or usefulness of any information. By using this site you agree that under no circumstances shall Valuation Tools LLC be held liable for any loss or damage caused by information obtained from this website including any articles, data, videos, its social media accounts, or any other materials.