Just want an explanation how to do this. If you can do it with fake data that would be good.

Conduct ratio analysis including liquidity, solvency, profitability and turnover ratios in 2014 and 2015 for Marriott & Starwood, compare with each other and industry benchmark

Key Performance Indicators (KPIs) Comparison (7 points)
	2015			2014
	Marriott	Starwood	Industry	Marriott	Starwood	Industry
Occupancy			74.80%			74.30%
ADR			$171.82			$158.62
RevPAR			$128.55			$117.85
Financial Ratios Comparison (28 points)
	Y2015			Y2014
	Marriott	Starwood	Industry	Marriott	Starwood	Industry
Liquidity Ratios
current raio			1-1.5			1-1.5	CA / CL
AR turnover			20-30 times			20-30 times	TR / ave. AR
Solvency Ratios
TA to TL ratio			2			2	TA / TL
OCF to TL ratio			0.2			0.2	OCF / ave. TL
Profitability Ratios
operating efficiency			30-40%			30-40%	GOP / TR
net ROA ratio			n/a			n/a	NI / ave. TA
Turnover Ratios
WC turnover			12-50 times			12-50 times	TR / ave. WC
fixed asset turnover			1.5-2 times			1.5-2 times	TR / ave. FA