For this question there are 2 steps
Do both vertical and horizontal analysis for the Income statement necessary years
2nd (2018 2019only) find the financial ratios based off of the Income statement and the balance sheet
$ 300 2015 230 $ 85% 195.50 $ 2016 234 S 86% 201.24 $ 2017 240 $ 87% 208.80 $ 2018 247 $ 88% 217.36 $ 2019 256 88% 225.28 $ 1 2 3 Number of rooms 4 5 ADR 7 RevPAR 8 9 REVENUE 10 Rooms 11 Food & Beverage 12 Other Operated Departments 13 Miscellaneous Income 14 TOTAL REVENUE 15 16 DEPARTMENTAL EXPENSES 17 Rooms 18 Food & Beverage 19 Other Operated Departments 20 TOTAL DEPARTMENTAL EXPENSES 21 22 TOTAL DEPARTMENTAL PROFITS 23 4 UNDISTRIBUTED OPERATING EXPENSES $ 21,407,250 $ 22,035,780 $ 22,863,600 $ 23,800,920 $ 24,668,160 $ 2,598,100 $ 2,812,783 $ 2,924,641 $ 3,116,191 $ 3,152,037 $ 333,673 S 378,245 $ 351,244 S 320,721 $ 353,944 $ S 81,376 $ 101,028 $ 111,131 $ 90,816 $ 24,339,023 $ 25,308,184 $ 26, 240,513 $ 27,348,963 $ 28,264,957 $ 2,649,024 S 2,918,832 $ 3,114,476 $ 2,966,355 $ 3,051,108 779,430 $ 900,090 $ 965,131 $ 934,857 $ 945,611 S 135,053 $ 135,039 $ 188,243 151,601 S 143, 110 $ 3,563,506,5 $3,953,961.7 $4,267.849.7 $4,052,813.0 $4,139,828.8 $ 20,775,517 $ 21,354,222 $ 21,972,663 $ 23,296,150 $ 24,125,129 B D $ 712,667 $ 763,952 $ 788,277 $ 793,210 $ 786,030 $ 610,327 $ 622,703 664,596 $ 738,631 $ 736,311 $ 330,306 $ 344,937 $ 371,599 $ 377,833 $ 356,926 $ 351,476 $ 373,369 $ 383,536 $ 387,269 $ 382,653 $ 2,004,777 $ 2,104,960 $ 2,208,007 $ 2,296,943 $ 2,261,919 $ 18,770,740 $ 19,249,262 $19,764,656 $20,999,207 $21,863,209 $ 1,070,363 $ 1,101,789 $ 1,143,180 $ 1,190,046 $ 1,233,408 $ 1,313,952 $ 1,347,448 $ 1,383,526 $ 1,469,944 $ 1,530,425 24 UNDISTRIBUTED OPERATING EXPENSES 25 Administrative & General 26 Marketing 27 Utility Costs 28 Property Operation & Maintenance 29 TOTAL UNDISTRIBUTED OPERATING EXPENSES 30 31 GROSS OPERATING PROFIT 32 33 Franchise Fees (Royalty) (5% of Rooms Revenue) 34 Management Fees (7% of GOP) 35 36 INCOME BEFORE FIXED CHARGES 37 38 SELECTED FIXED CHARGES 39 Property Taxes 40 Insurance 41 Reserve For Capital Replacement 42 43 EBITDA 44 Depreciation 45 Interest Expense 46 Income Before Income Tax 47 Income Tax 2096 48 Net Income $ 16,386,425 $ 16,800,025 $17,237,950 $ 18,339,216 $19,099,377 $ $ S 328,545 S 59,700 S 150,467 $ 328,545 $ 59,700$ 169,400 $ 328,545 $ 59,700$ 171,091 S 328,545 $ 59,700 $ 150,467 $ 328,545 59,700 169,400 S 15,847,714 $16,242,379 $ 16,678,614 $17,800,505 $18,541,732 S 280,000 $ 280,000 $ 280,000 $ 280,000 $ 280,000 $ 120,000 $ 120,000 $ 120,000 $ 120,000 $ 120,000 $ 15,447,714 $15.842,379 $ 16,278,614 $17,400,505 $ 18,141,732 $ 3,089,543 $ 3,168,476 $ 3.255.723 S 3,480,101 $ 3,628,346 $ 12,358,171 $12,673,904 $13,022,891 $13,920,404 $14.513,385 w a P R H M Vertical Financial Statement Analysis Horizontal Financial Statement is 2016-2017 2017 2018 Dolar Change Change Dollar Change Change 2015 2016 Dollar Change Change 2018 2010 2018-2019 Dolar Charge Charge 2017 2015 2016 Part 1 and income Statement Talance sheet Partos 2017 2018 2019 Assets Current Assets Cash Marketable Securities Net Receivables Inventories Total Current Assets Property & Equipment Land Building Furnishings & Equpment Less Accumulated Dep Net Property & Equipment Total Assets $ $ $ $ $ 5,989,560 $ 6,304,800 $ 5,731,700 9,415,350 $ 10,461,500 $ 13,076,900 4,800,000 $ 6,400,000 $ 8,000,000 5,319,930 $ 4,836,300 $ 3,454,500 25,524,840 $ 28,002,600 $ 30,263,100 $ 70,450,480 $ 81,496,200 $ 45,489,000 $ 13,345,707 $ 14,589,600 $ 43,447,900 $ 21,377,840 $ 26,722,300 $ 20,555,600 $ 12,843,900 $ 14,271,000 $ 13,542,900 $ 92,330,127 $ 108,537,100 $ 95,949,600 $ 117,854,967 $ 136,539,700 $ 126,212,700 Liabilities & Owners' Equity Current Liabilities Accounts Payable Notes payable $ $ 24,068,630 $ 25,335,400 $ 14,243,900 3,445,740 $ 3,828,600 $ 3,190,500 Liabilities & Owners' Equity Current Liabilities Accounts Payable $ 24,068,630 $ 25,335,400 $ 14,243,900 Notes payable $ 3,445,740 $ 3,828,600 $ 3,190,500 other current liabilities $ 14,420,925 $ 19,227,900 $ 14,790,700 Total current Liabilities $ 41,935,295 $ 48,391,900 $ 32,225,100 Long-Term Liabilities Long term debt $ 5,000,000 $ 5,000,000 $ 10,000,000 Mortgage $ 5,973,920 $ 5,256,000 $ 11,827,200 Total Long-Term Liabilities $ 10,973,920 $ 10,256,000 $ 21,827,200 Total Liabilities $ 52,909,215 $ 58,647,900 $ 54,052,300 Owners' Equity Common Stock $ 9,749,945 $ 10,263,100 $ 7,894,700 Paid in Capital $ 43,848,584 $ 42,162,100 $ 32,432,400 Retained Earnings $ 11,347,223 S 25,466,600 S 31,833,300 Total Owners' Equity $ 64,945,752 $ 77.891,800 $ 72,160,400 Total Liabilities & Owners' Equity $ 117,854,967 $ 136,539,700 $ 126,212,700 Shares Outstanding Market Price per Share 430,000 300 430,000 340 430,000 400 $ E 2018 2019 Liquidity Ratios Current Ratio Quick Ratio/Acid-test Ratio Solvency Ratios Debt Ratio Debt to Equity Ratio Number of times interest earned Profitability Ratios Profit Margin Operating Efficiency Ratio (GOP Margin) Return on Assets Return on Owners' Eq (ROE)/Return on Investment (ROI) Earnings Per Share (EPS) Price/Earnings Ratio (P/E Ratio) Activity Ratios Account Receivables Tumover Average Collection Period Inventory Turnover Ratio Purchasing Cycle Fixed Asset Turnover