Discounted Cash Flow (DCF) Analysis Unlevered

UBS Group AG (UBS)

$19.07

+0.87 (+4.78%)
All numbers are in Millions, Currency in USD
Stock DCF: 165.78 | 19.07 | undervalue

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 30,00428,97632,28935,05934,45435,734.0137,061.5738,438.4639,866.4941,347.58
Revenue (%)
EBITDA 17,65218,29715,40014,83318,19618,924.2219,627.2820,356.4621,112.7321,897.09
EBITDA (%)
EBIT 16,35916,46713,27412,71516,193.3216,847.1417,473.0318,122.1718,795.4419,493.71
EBIT (%)
Depreciation 1,2931,8302,1262,1182,002.682,077.092,154.252,234.292,317.292,403.38
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 117,399115,293168,521203,642171,684170,825.58177,171.96183,754.12190,580.82197,661.13
Total Cash (%)
Account Receivables 20,60222,20729,14426,32517,57625,847.4126,807.6727,803.6128,836.5529,907.86
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 39,96438,79540,09745,13945,08546,516.4648,244.6150,036.9551,895.8953,823.89
Accounts Payable (%)
Capital Expenditure -1,688-1,584-1,854-1,841-1,902.34-1,973.01-2,046.31-2,122.34-2,201.18-2,282.96
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 19.07
Beta 1.116
Diluted Shares Outstanding 3,627.24
Cost of Debt
Tax Rate 20.56
After-tax Cost of Debt 2.77%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.762
Total Debt 188,259
Total Equity 69,171.49
Total Capital 257,430.49
Debt Weighting 73.13
Equity Weighting 26.87
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 30,00428,97632,28935,05934,45435,734.0137,061.5738,438.4639,866.4941,347.58
EBITDA 17,65218,29715,40014,83318,19618,924.2219,627.2820,356.4621,112.7321,897.09
EBIT 16,35916,46713,27412,71516,193.3216,847.1417,473.0318,122.1718,795.4419,493.71
Tax Rate 24.64%22.83%19.60%21.37%20.56%21.80%21.80%21.80%21.80%21.80%
EBIAT 12,328.6412,708.2610,672.919,997.4412,863.2713,174.6213,664.0714,171.7114,698.2115,244.26
Depreciation 1,2931,8302,1262,1182,002.682,077.092,154.252,234.292,317.292,403.38
Accounts Receivable --1,605-6,9372,8198,749-8,271.41-960.26-995.94-1,032.94-1,071.31
Inventories ----------
Accounts Payable --1,1691,3025,042-541,431.461,728.141,792.351,858.941,928
Capital Expenditure -1,688-1,584-1,854-1,841-1,902.34-1,973.01-2,046.31-2,122.34-2,201.18-2,282.96
UFCF 11,933.6410,180.265,309.9118,135.4421,658.616,438.7514,539.8915,080.0715,640.3116,221.37
WACC
PV UFCF 6,168.5613,345.2513,260.2413,175.7813,091.85
SUM PV UFCF 59,041.68

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 4.38
Free cash flow (t + 1) 16,545.79
Terminal Value 695,201.47
Present Value of Terminal Value 561,079.26

Intrinsic Value

Enterprise Value 620,120.94
Net Debt 18,814
Equity Value 601,306.94
Shares Outstanding 3,627.24
Equity Value Per Share 165.78