Complete a vertical and horizontal analysis for the balance sheet.

Below is the summary operating statement

	20x1			20x2			Variance (Horizontal)
							#/$	%
Rooms available:	300.00			300.00				0.00%
Rooms sold:	79,388.00			81,140.00				2.21%
Occupancy:	72.50%			74.10%				2.21%
ADR:	183.62			191.33			7.71	4.20%
Rooms RevPar:	133.12			141.78			8.66	6.51%
Total RevPar:	176.20			185.65			9.45	5.36%
Operating revenue
Rooms	14,577,225.00	75.55%		15,524,516.00	76.37%		947,291.00	6.50%
Food and beverage	4,444,791.00	23.04%		4,517,064.00	22.22%		72,273.00	1.63%
Misc. income	271,725.00	1.41%		287,236.00	1.41%		15,511.00	5.71%
Total operating revenue	19,293,741.00	100.00%		20,328,816.00	100.00%		1,035,075.00	5.36%
Departmental expenses
Rooms	3,848,590.00	19.95%		3,943,227.00	19.40%		94,637.00	2.46%
Food and beverage	3,272,482.00	16.96%		3,329,076.00	16.38%		56,594.00	1.73%
Total departmental expenses	7,121,072.00	36.91%		7,272,303.00	35.77%		151,231.00	2.12%
Total departmental profit	12,172,669.00	63.09%		13,056,513.00	64.23%		883,844.00	7.26%
Undistributed operating expense
Administrative and General	1,584,062.00	8.21%		1,646,634.00	8.10%		62,572.00	3.95%
Information & Telecommunications Systems	308,896.00	1.60%		304,932.00	1.50%		- 3,964.00	-1.28%
Sales and Marketing	1,816,014.00	9.41%		1,870,251.00	9.20%		54,237.00	2.99%
Property Operation and Maintenance	793,637.00	4.11%		813,153.00	4.00%		19,516.00	2.46%
Utilities	583,641.00	3.03%		589,536.00	2.90%		5,895.00	1.01%
Total undistributed expenses	5,086,250.00	26.36%		5,224,506.00	25.70%		138,256.00	2.72%
Gross operating profit	7,086,419.00	36.73%		7,832,007.00	38.53%		745,588.00	10.52%
Management fees	578,812.00	3.00%		609,864.00	3.00%		31,052.00	5.36%
Income before non-operating income and expenses	6,507,607.00	33.73%		7,222,143.00	35.53%		714,536.00	10.98%
Non-operating Income and expenses
(Income)/Loss	- 2,000.00	-0.01%		- 1,300.00	-0.01%		700.00	-35.00%
Property and other taxes	753,247.00	3.90%		783,001.00	3.85%		29,754.00	3.95%
Insurance	152,433.00	0.79%		149,298.00	0.73%		- 3,135.00	-2.06%
Total non-operating Income and Expenses	903,680.00	4.68%		930,999.00	4.58%		27,319.00	3.02%

Condensed Balance Sheet December 31, 20x7 and 20x8 20x1 20x2 Changes $ % $ % Assets Current Assets Cash Accounts Receivable Inventory Prepaids Total Current Assets 335,636 574,659 218,900 57,200 1,186,395 359,875 426,183 199,000 68,945 1,054,003 Investments 1,500,000 1,000,000 Property and Equipment Land Building Equipment Accumulated Depreciation Net Property and Equipment 1,779,800 20,160,800 6,485,624 (8,929,800) 19,496,424 1,779,800 20,160,800 6,508,560 (9,345,098) 19,104,062 Total Assets 22,182,819 21,158,065 Liabilities & Owners' Equity Current Liabilities Accounts Payable Accrued Expenses Advanced Deposits Total Current Liabilities 358,269 558,088 220,617 1,136,974 125,895 207,459 200,561 533,915 Mortgage Payable 6,308,170 5,734,700 Common Stock Retained Earnings 3,700,000 11,037,675 3,700,000 11,189,450 Total Liabilities and Owners' Equity 2 2,182,819 21,158,065 Summary Operating Statement Balance Sheet Statement of Cash Flow Op Sec