part 1 can you conduct horizontal and vertical analysis of the given income statement for the years given

part 2 find the financial ratios for the years 2018 and 2019 baded on the given inckme statement and balance sheet

Number of rooms ADR OCC RevPAR REVENUE Rooms Food \& Beverage Other Operated Departments Miscellaneous income TOTAL REVENUE DEPARTMENTAL EXPENSES Rooms Food \& Beverage Other Operated Departments TOTAL DEPARTMENTAL EXPENSES TOTAL DEPARTMENTAL PROFITS UNDISTRIBUTED OPERATING EXPENSES Administrative \& General Marketing Utility Costs Property Operation \& Maintenance TOTAL UNDISTRIBUTED OPERATING EXPENSES GROSS OPERATING PROFIT Franchise Fees (Royalty) ( 5% of Rooms Revenue) Management Fees (7\% of GOP) INCOME BEFORE FIXED CHARGES SELECTED FIXED CHARGES Property Taxes Insurance Reserve For Capital Replacement BBITDA Depreciation Interest Expense Income Before Income Tax IncomeTax@20\% Net Income \begin{tabular}{|r|r|r|r|r|} \hline 300 & & & & \\ \hline 2015 & 2016 & 2017 & 2018 & 2019 \\ \hline 230 & 234 & 240 & 247 & 256 \\ \hline 85% & 86% & 87% & 88% & 88% \\ \hline 195.5 & 201.24 & 208.8 & 217.36 & 225.28 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|r|} \hline 21,407,250 & 22,035,780 & 22,863,600 & 23,800,920 & 24,668,160 \\ \hline 2,598,099.9 & 2,812,782.56 & 2,924,640.9 & 3,116,190.83 & 3,152,037.3 \\ \hline 333,673.2 & 378,245.14 & 351,243.75 & 320,721.27 & 353,944,08 \\ \hline 0 & 81,376 & 101,028 & 111,130.8 & 90,816 \\ \hline 24,339,023.1 & 25,308,183.7 & 26,240,512.65 & 27,348,962.9 & 28,264,957.38 \\ \hline \end{tabular} 20,775,516.6321,354,221.98121,972,662.90323,296,149.85124,125,128.59 \begin{tabular}{|r|r|r|r|r|} \hline 712,667.16 & 763,951.57 & 788,276.5 & 793,210.44 & 786,029.85 \\ \hline 610,327.44 & 622,702.83 & 664,595.8 & 738,630.63 & 736,310.73 \\ \hline 330,306.12 & 344,937.04 & 371,598.7 & 377,832.9 & 356,926.05 \\ \hline 351,476.28 & 373,368.6 & 383,535.9 & 387,269.01 & 382,652.52 \\ \hline 2,004,777 & 2,104,960.04 & 2,208,006.9 & 2,296,942.98 & 2,261.919.15 \\ \hline \end{tabular} 18,770,739.6319,249,261.94119,764,656.00320,999,206.87121,863,209.44 \begin{tabular}{|r|r|rrr|r} 1,070,362.5 & 1,101,789 & 1,143,180 & 1,190,046 & 1,233,408 \\ \hline 1,313,951.774 & 1,347,448.336 & 1,383,525.92 & 1,469,944,481 & 1,530,424.661 \\ \hline \end{tabular} 16,386,425.35616,800,024.60517,237,950.08318,339,216.3919,099,376.775 \begin{tabular}{|r|r|r|r|r|} \hline 328,545 & 328,545 & 328,545 & 328,545 & 328,545 \\ \hline 59,700 & 59,700 & 59,700 & 59,700 & 59,700 \\ \hline 150,466.56 & 169,400.12 & 171,090,92 & 150,466.56 & 169,400.12 \\ \hline \end{tabular} 15,847,713.79616,242,379.48516,678,614,16317,800,504.8318,541,731.655 \begin{tabular}{|c|c|c|c|} \hline 80,000 & 280,000 & 280,000 & 280,000 \\ \hline 120,000 & 120,000 & 120.000 & 120.000 \\ \hline \end{tabular} 15,447,713.79615,842,379,48516,278,614,16317,400,504.8318,141,731,655 3,089,542.7593,168,475.8973,255,722.8333,480,100.9663.628,346.332 12,358,171.03712,673,903.58813,022,891.3313,920,403.86414,513,385.327 Vertical Financial Statement Analsysis 2015 2016 2017 2018 2019 Horizontal Financial Statement Analsysis 2015-2016 2016-2017 2017-2018 2018-2019 Dollar Change \% Change Dollar Change \% Change Dollar Change \% Change Dollar Change \% Change 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 Turnover Average Collection Period Inventory Turnover Ratio Purchasing Cycle Fixed Asset Turnover 2017 2018 2019 Assets Current Assets CashMarketableSecuritiesNetReceivablesInventoriesTotalCurrentAssetsProperty&EquipmentLandBuildingFurnishings&EqupmentLessAccumulatedDepNetProperty&EquipmentTotalAssets$$$$$$$$$$$5,989,5609,415,3504,800,0005,319,93025,524,84070,450,48013,345,70721,377,84012,843,90092,330,127117,854,967$$$$$$$$$$108,537,100$136,539,7006,304,80010,461,5006,400,0004,836,30028,002,60081,496,20014,589,60026,722,30014,271,000$$$$$$$$$$$95,949,600126,212,7005,731,70013,076,9008,000,0003,454,50030,263,10045,489,00043,447,90020,555,60013,542,900 Liabilities \& Owners' Equity Current Liabilities Accounts Payable Notes payable other current liabilities Total current Liabilities Long-Term Liabilities Long term debt Mortgage Total Long-Term Liabilities Total Liabilities Owners' Equity Common Stock Paid in Capital Retained Earnings Total Owners' Equity Total Liabilities \& Owners' Equity \begin{tabular}{|c|c|c|c|c|c|} \hline & 24,068,630 & $ & 25,335,400 & $ & 14, \\ \hline & 3,445,740 & $ & 3,828,600 & $ & 3,190,500 \\ \hline & 14,420,925 & $ & 19,227,900 & $ & 14,790,700 \\ \hline & 41,935,295 & $ & 48,391,900 & $ & 32,225,100 \\ \hline & 5,00 & $ & 5,00 & $ & 10, \\ \hline & 5,973,920 & $ & 5,256,000 & $ & 11,8 \\ \hline & 10,973,920 & $ & 10,256,000 & $ & 21,827,200 \\ \hline & 52,909,215 & $ & 58,647,900 & $ & 54,052,300 \\ \hline & 9,7 & $ & 10,2 & $ & \\ \hline & 43,848,584 & $ & 42,162 & $ & 32,4 \\ \hline & 11,347,223 & $ & 25,466,600 & $ & 31,833,300 \\ \hline & 64,945,752 & $ & 77,891,800 & $ & 72,160,400 \\ \hline & 17,854,967 & $ & 136,539,700 & $ & 126,212,700 \\ \hline \end{tabular} Shares Outstanding Market Price per Share 430,000 430,000 430,000 $ 300 340 400