Discounted Cash Flow (DCF) Analysis Unlevered

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

$26.11

+1.06 (+4.23%)
All numbers are in Millions, Currency in USD
Stock DCF: -176.52 | 26.11 | 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,994-2,556.52-2,879.56-3,243.42-3,653.25-4,114.86
EBIT (%)
Depreciation 7481,8042,1652,2833,2602,919.713,288.643,704.184,172.244,699.43
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,748-1,834.28-2,066.06-2,327.12-2,621.17-2,952.38
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 26.11
Beta 1.354
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 10.083
Total Debt 46,693
Total Equity 3,864.28
Total Capital 50,557.28
Debt Weighting 92.36
Equity Weighting 7.64
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,994-2,556.52-2,879.56-3,243.42-3,653.25-4,114.86
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-6,383.22-602.23-678.33-764.04-860.58-969.32
Depreciation 7481,8042,1652,2833,2602,919.713,288.643,704.184,172.244,699.43
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,748-1,834.28-2,066.06-2,327.12-2,621.17-2,952.38
UFCF 184.46-844.371,171.93-50.31-9,432.841,877.56-674.88-760.16-856.21-964.40
WACC
PV UFCF 1,960.89-736.12-865.94-1,018.65-1,198.29
SUM PV UFCF -1,858.10

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) -4.25
Free cash flow (t + 1) -983.68
Terminal Value 15,738.95
Present Value of Terminal Value 19,556.09

Intrinsic Value

Enterprise Value 17,697.98
Net Debt 43,823
Equity Value -26,125.02
Shares Outstanding 148
Equity Value Per Share -176.52