Columbia Property Trust
Financial ratios & Valuation

Historical Multiples (2013 – 2020)

2013 2014 2015 2016 2017 2018 2019 2020 TTM Median
Valuation Ratios
Price/Earnings ratio
213.2334.1665.6531.5515.74241.20264.7714.5126.3815.74
Price/Sales ratio
6.365.855.175.619.597.688.435.588.665.61
Price/Book Value ratio
1.201.151.121.061.090.830.920.640.861.09
Price/Cash Flow ratio
15.3513.3613.1313.7744.7623.4517.7116.0821.9413.77
Price/Free Cash Flow ratio
19.3217.3020.9617.31-111.4286.0934.5647.25135.7717.31
Price/Earnings Growth ratio
-3.200.06-1.270.350.13-2.55-176.950.010.020.13
Dividend Yield
5.71%4.73%3.84%5.58%3.95%4.15%3.83%5.74%N/A3.95%
Profitability Indicator Ratios
Gross Profit Margin
65.95%65.83%62.98%63.02%68.57%69.90%67.48%60.42%53.97%68.57%
Operating Profit Margin
18.73%23.69%19.12%20.96%16.94%19.41%18.13%12.82%5.84%16.94%
Pretax Profit Margin
4.99%17.62%7.94%17.89%60.84%3.19%3.14%38.45%35.86%17.89%
Net Profit Margin
2.98%17.12%7.88%17.79%60.91%3.18%3.18%38.49%32.85%17.79%
Effective Tax Rate
1.89%0.69%0.84%0.52%-0.12%0.38%0.23%-2.42%-0.71%-0.12%
Return on Assets
0.34%1.95%0.95%1.96%3.90%0.22%0.21%2.83%2.05%1.96%
Return On Equity
0.56%3.38%1.70%3.36%6.95%0.34%0.35%4.43%3.23%6.95%
Return on Capital Employed
2.19%2.76%2.38%2.40%1.12%1.41%1.26%1.00%0.39%1.12%
Liquidity Ratios
Current Ratio
2.543.061.392.130.881.801.440.740.540.88
Quick Ratio
2.213.061.392.130.881.801.440.740.390.88
Cash ratio
1.001.400.231.280.060.230.120.250.100.06
Days of Sales Outstanding
83.8783.3077.8455.47119.17110.76100.8393.01116.0455.47
Days of Inventory outstanding
N/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Operating Cycle
83.8783.3077.8455.47119.17110.76100.8393.0128.61119.17
Days of Payables Outstanding
202.95209.93172.05273.17502.41199.93275.37280.71303.19273.17
Cash Conversion Cycle
-119.07-126.62-94.20-217.70-383.24-89.16-174.53-187.70-187.15-217.70
Debt Ratios
Debt Ratio
0.390.350.360.320.360.310.420.300.350.32
Debt Equity Ratio
0.640.610.660.560.650.480.690.480.560.56
Long-term Debt to Capitalization
0.340.380.390.360.390.320.360.300.310.39
Total Debt to Capitalization
0.340.380.390.360.390.320.400.320.340.39
Interest Coverage Ratio
0.961.691.261.460.801.021.211.020.470.80
Cash Flow to Debt Ratio
0.140.140.120.130.030.070.070.080.070.07
Company Equity Multiplier
1.641.731.781.711.781.521.611.561.591.78
Cash Flow Ratios
Operating Cash Flow / Sales Ratio
0.410.430.390.400.210.320.470.340.390.39
Free Cash Flow / Operating Cash Flow Ratio
0.790.770.620.79-0.400.270.510.340.16-0.40
Cash Flow Coverage Ratio
0.140.140.120.130.030.070.070.080.070.07
Short Term Coverage Ratio
N/AN/AN/AN/AN/AN/A0.410.940.61N/A
Dividend Payout Ratio
1218.02%161.88%252.29%176.16%62.23%1001.53%1016.41%83.36%N/A62.23%