Host Hotels and Resorts Analysis.xlsx

	A	B	C	D	E	F	G
1
2
3
4
5	Host Hotels & Resorts, Inc. (NasdaqGS:HST) > Financials > Key Stats
6
7	In Millions of the trading currency, except per share items.	Currency:	Trading Currency		Conversion:	Historical
8		Order:	Latest on Right		Units:	S&P Capital IQ (Default)
9		Decimals:	Capital IQ (Default)		Dilution:	Basic
10
11
12	Key Financials¹
13	For the Fiscal Period Ending	12 months Dec-31-2017A	12 months Dec-31-2018A	12 months Dec-31-2019A	12 months Dec-31-2020A	12 months Dec-31-2021A	LTM² 12 months Jun-30-2022A
14	Currency	USD	USD	USD	USD	USD	USD
15
16	Total Revenue	5,417.0	5,554.0	5,483.0	1,590.0	2,921.0	4,298.0
17	Growth Over Prior Year	(0.6%)	2.5%	(1.3%)	(71.0%)	83.7%	179.5%
18
19	Gross Profit	1,541.0	1,601.0	1,591.0	(164.0)	644.0	1,294.0
20	Margin %	28.4%	28.8%	29.0%	(10.3%)	22.0%	30.1%
21
22	EBITDA	1,443.0	1,497.0	1,484.0	(253.0)	545.0	1,196.0
23	Margin %	26.6%	27.0%	27.1%	(15.9%)	18.7%	27.8%
24
25	EBIT	735.0	813.0	822.0	(918.0)	(125.0)	526.0
26	Margin %	13.6%	14.6%	15.0%	(57.7%)	(4.3%)	12.2%
27
28	Earnings from Cont. Ops.	571.0	1,151.0	932.0	(741.0)	(11.0)	581.0
29	Margin %	10.5%	20.7%	17.0%	(46.6%)	(0.4%)	13.5%
30
31	Net Income	564.0	1,087.0	920.0	(732.0)	(11.0)	573.0
32	Margin %	10.4%	19.6%	16.8%	(46.0%)	(0.4%)	13.3%
33
34	Diluted EPS Excl. Extra Items³	0.76	1.47	1.26	(1.04)	(0.02)	0.8
35	Growth Over Prior Year	(25.5%)	93.3%	(14.3%)	NM	NM	NM
36
37
38	Currency	USD	USD	USD	USD	USD	USD
39	Exchange Rate	1.0	1.0	1.0	1.0	1.0	1.0
40	Conversion Method	H	H	H	H	H	H
41
42	¹All results are taken from the most recently filed statement for each period. When there has been more than one, earlier filings can be viewed on the individual statement pages.
43	²Growth rates for the LTM period are calculated against the LTM period ending 12 months before.
44
45	Growth Rates are calculated in originally reported currency only and will not reflect any currency conversion selected above.
46
47	Latest Capitalization (Millions of USD)
48	Currency	USD
49	Share Price	$16.34
50	Shares Out.	714.9
51
52	Market Capitalization	11,681.3
53	- Cash & Short Term Investments	699.0
54	+ Total Debt	4,784.0
55	+ Pref. Equity	-
56	+ Total Minority Interest	168.0
57	- Long Term Marketable Securities	-
58	= Total Enterprise Value (TEV)	15,934.3
59
60	Implied Shares Outstanding	-
61	Implied Market Capitalization	-
62	Book Value of Common Equity	6,777.0
63	+ Pref. Equity	-
64	+ Total Minority Interest	168.0
65	+ Total Debt	4,784.0
66	= Total Capital	11,729.0
67
68	**For companies that have multiple share classes that publicly trade, we are incorporating the different prices to calculate our company level market capitalization. Please click on the value to see the detailed calculation. Prices shown on this page are the close price of the company’s primary stock class. Shares shown on this page are total company as-reported share values.
69	*Includes number of shares outstanding + shares held by non-controlling interest holders without accounting for dilutive securities
70
71
72	Total Liability includes Total Debt, Minority Interest and Pref. Equity.
73	Net Liability includes Total Liability, net of Cash and Short Term Investments.
74	TEV includes Market Cap and Net Liability.
75	Total Capital includes Common Equity and Total Liability.
76
77	Valuation Multiples based on Current Capitalization
78	For the Fiscal Period Ending	12 months Dec-31-2018A	12 months Dec-31-2019A	12 months Dec-31-2020A	12 months Dec-31-2021A	LTM 12 months Jun-30-2022A
79	TEV/Total Revenue	2.9x	2.9x	10.0x	5.6x	3.7x
80
81	TEV/EBITDA	10.6x	10.2x	NM	27.7x	12.8x
82
83	TEV/EBIT	19.6x	19.4x	NM	NM	30.3x
84
85	P/Diluted EPS Before Extra	11.1x	13.0x	NM	NM	20.5x
86
87	P/BV	1.6x	1.6x	1.8x	1.8x	1.7x
88
89	Price/Tang BV	1.6x	1.6x	1.8x	1.8x	1.7x
90
91
92
93
94
95
96
97
98
99
100