Discounted Cash Flow (DCF) Analysis Unlevered

CT Real Estate Investment Trust (CRT-UN.TO)

$15.85

+0.16 (+1.02%)
All numbers are in Millions, Currency in USD
Stock DCF: 19.18 | 15.85 | 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 443.30472.48489.01502.35514.54534.13554.48575.59597.52620.27
Revenue (%)
EBITDA 413.82405.51416.33291.35562.58461.11478.67496.91515.83535.48
EBITDA (%)
EBIT -----461.11478.67496.91515.83535.48
EBIT (%)
Depreciation ----------
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 10.904.999.734.533.557.587.878.178.488.81
Total Cash (%)
Account Receivables 1.972.152.884.912.883.233.353.483.613.75
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable ----------
Accounts Payable (%)
Capital Expenditure -16.50-19.11-22.45-17.56-35.86-24.38-25.31-26.27-27.27-28.31
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 15.85
Beta 0.960
Diluted Shares Outstanding 322.57
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt 8.12%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.222
Total Debt 1,302.09
Total Equity 5,112.81
Total Capital 6,414.89
Debt Weighting 20.30
Equity Weighting 79.70
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 443.30472.48489.01502.35514.54534.13554.48575.59597.52620.27
EBITDA 413.82405.51416.33291.35562.58461.11478.67496.91515.83535.48
EBIT -----461.11478.67496.91515.83535.48
Tax Rate 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
EBIAT -----461.11478.67496.91515.83535.48
Depreciation ----------
Accounts Receivable --0.18-0.74-2.032.03-0.35-0.12-0.13-0.13-0.14
Inventories ----------
Accounts Payable ----------
Capital Expenditure -16.50-19.11-22.45-17.56-35.86-24.38-25.31-26.27-27.27-28.31
UFCF -----436.39453.24470.51488.43507.03
WACC
PV UFCF 403.31387.15371.44356.36341.90
SUM PV UFCF 1,860.15

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 8.20
Free cash flow (t + 1) 517.17
Terminal Value 8,341.42
Present Value of Terminal Value 5,624.75

Intrinsic Value

Enterprise Value 7,484.91
Net Debt 1,298.53
Equity Value 6,186.38
Shares Outstanding 322.57
Equity Value Per Share 19.18