Discounted Cash Flow (DCF) Analysis Unlevered

Brookfield Business Partners L.P. (BBU-UN.TO)

$22.5

-0.27 (-1.19%)
All numbers are in Millions, Currency in USD
Stock DCF: -160.89 | 22.5 | overvalue

Operating Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 37,16843,03237,63546,58757,54564,816.2673,006.3082,231.2292,621.78104,325.27
Revenue (%)
EBITDA 4227657461,238-2,734363.19409.08460.77518.99584.57
EBITDA (%)
EBIT -326-1,039-1,419-1,045-5,159.21-2,368.47-2,667.74-3,004.83-3,384.52-3,812.18
EBIT (%)
Depreciation 7481,8042,1652,2832,425.212,731.663,076.823,465.603,903.514,396.75
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 2,2142,7204,1233,9882,8704,767.965,370.436,049.026,813.367,674.29
Total Cash (%)
Account Receivables 4,8355,3794,9895,6347,2788,232.419,272.6410,444.3211,764.0413,250.51
Account Receivables (%)
Inventories 1,5623,4903,6964,5127,7125,862.016,602.727,437.038,376.759,435.22
Inventories (%)
Accounts Payable 1,8192,9192,9713,6653,947.384,446.165,007.975,640.776,353.527,156.34
Accounts Payable (%)
Capital Expenditure -545-1,205-1,405-1,450-1,598.63-1,800.63-2,028.16-2,284.43-2,573.09-2,898.22
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 22.5
Beta 1.340
Diluted Shares Outstanding 148
Cost of Debt
Tax Rate -6.49
After-tax Cost of Debt -5.44%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.807
Total Debt 46,693
Total Equity 3,330
Total Capital 50,023
Debt Weighting 93.34
Equity Weighting 6.66
Wacc

Build Up Free Cash

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 37,16843,03237,63546,58757,54564,816.2673,006.3082,231.2292,621.78104,325.27
EBITDA 4227657461,238-2,734363.19409.08460.77518.99584.57
EBIT -326-1,039-1,419-1,045-5,159.21-2,368.47-2,667.74-3,004.83-3,384.52-3,812.18
Tax Rate 94.31%93.13%112.40%88.87%-6.49%76.44%76.44%76.44%76.44%76.44%
EBIAT -18.54-71.37175.93-116.31-5,494.23-557.93-628.43-707.84-797.28-898.02
Depreciation 7481,8042,1652,2832,425.212,731.663,076.823,465.603,903.514,396.75
Accounts Receivable --544390-645-1,644-954.41-1,040.23-1,171.67-1,319.72-1,486.48
Inventories --1,928-206-816-3,2001,849.99-740.71-834.31-939.73-1,058.47
Accounts Payable -1,10052694282.38498.78561.81632.80712.76802.82
Capital Expenditure -545-1,205-1,405-1,450-1,598.63-1,800.63-2,028.16-2,284.43-2,573.09-2,898.22
UFCF 184.46-844.371,171.93-50.31-9,229.271,767.45-798.90-899.85-1,013.55-1,141.62
WACC
PV UFCF 1,849.38-874.68-1,030.87-1,214.95-1,431.90
SUM PV UFCF -2,703.03

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) -4.43
Free cash flow (t + 1) -1,164.45
Terminal Value 18,109.67
Present Value of Terminal Value 22,714.47

Intrinsic Value

Enterprise Value 20,011.45
Net Debt 43,823
Equity Value -23,811.55
Shares Outstanding 148
Equity Value Per Share -160.89