Discounted Cash Flow (DCF) Analysis Unlevered

Public Storage (PSA)

$295.8

+0.32 (+0.11%)
All numbers are in Millions, Currency in USD
Stock DCF: 512.23 | 295.8 | undervalue

Operating Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 2,668.532,754.282,846.822,915.073,415.823,639.123,877.024,130.474,400.494,688.16
Revenue (%)
EBITDA 1,909.442,227.182,079.091,966.752,757.472,719.472,897.253,086.653,288.433,503.40
EBITDA (%)
EBIT 1,454.921,743.531,566.181,413.502,044.042,046.412,180.192,322.712,474.562,636.32
EBIT (%)
Depreciation 454.53483.65512.92553.26713.43673.06717.06763.93813.87867.07
Depreciation (%)

Balance Sheet Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash 433.38361.22409.74257.56734.60539.24574.49612.05652.06694.68
Total Cash (%)
Account Receivables ----------
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable ----------
Accounts Payable (%)
Capital Expenditure -460.68-478.87-187.31-170-270.24-400.10-426.26-454.12-483.81-515.44
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 295.8
Beta 0.392
Diluted Shares Outstanding 174.64
Cost of Debt
Tax Rate 0.33
After-tax Cost of Debt 1.21%
Risk-Free Rate
Market Risk Premium
Cost of Equity 5.357
Total Debt 7,475.28
Total Equity 51,659.10
Total Capital 59,134.38
Debt Weighting 12.64
Equity Weighting 87.36
Wacc

Build Up Free Cash

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 2,668.532,754.282,846.822,915.073,415.823,639.123,877.024,130.474,400.494,688.16
EBITDA 1,909.442,227.182,079.091,966.752,757.472,719.472,897.253,086.653,288.433,503.40
EBIT 1,454.921,743.531,566.181,413.502,044.042,046.412,180.192,322.712,474.562,636.32
Tax Rate 0.43%0.36%0.34%0.29%0.33%0.35%0.35%0.35%0.35%0.35%
EBIAT 1,448.651,737.201,560.921,409.332,037.392,039.252,172.562,314.592,465.902,627.10
Depreciation 454.53483.65512.92553.26713.43673.06717.06763.93813.87867.07
Accounts Receivable ----------
Inventories ----------
Accounts Payable ----------
Capital Expenditure -460.68-478.87-187.31-170-270.24-400.10-426.26-454.12-483.81-515.44
UFCF 1,442.501,741.981,886.531,792.592,480.582,312.212,463.362,624.392,795.962,978.73
WACC
PV UFCF 2,205.672,241.592,278.102,315.202,352.90
SUM PV UFCF 11,393.46

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 4.83
Free cash flow (t + 1) 3,038.31
Terminal Value 107,360.75
Present Value of Terminal Value 84,804.25

Intrinsic Value

Enterprise Value 96,197.71
Net Debt 6,740.68
Equity Value 89,457.03
Shares Outstanding 174.64
Equity Value Per Share 512.23