Question

Average Number of rooms 200 2015 170 $ 75% 128 $ 2016 175 $ 77% 135 $ 2017 177 $ 78% 138 $ 2018 179 $ 78% 140 $ 2019 D 183 78% 143 $ $ 9,307,500 $ 9,836,750 $ 10,078,380 $ 10,192,260 $ 10,420,020 $ 2,030,528 $ 2,030,528 $ 2,030,528 $ 2,030,528 $ 2,030,528 $ 207,043 $ 207,043 $ 207,043 $ 207,043 $ 207,043 $ 90,300 $ 90,300 $ 90,300 $ 90,300 $ 90,300 $ 11,635,371 $ 12,164,621 $ 12,406,251 $ 12,520,131 $ 12,747,891 $ 1,861,500 $ 1,967,350 $ 2,015,676 $ 2,038,452 $ 2,084,004 $ 1,218,317 $ 1,218,317 $ 1,218,317 $ 1,218,317 $ 1,218,317 $ 82,817 $ 82,817 $ 82,817 $ 82,817 $ 82,817 $ 3,162,634 $ 3,268,484 $ 3,316,810 $ 3,339,586 $ 3,385,138 $ 8,472,737 $ 8,896,137 $ 9,089,441 $ 9,180,545 $ 9,362,753 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) (4% of Rooms Revenue) Management Fees (5% of GOP) INCOME BEFORE FIXED CHARGES SELECTED FIXED CHARGES Property Taxes Insurance Reserve For Capital Replacement (4% of GOP) EBITDA Depreciation Amortization Interest Expense Income Before Income Tax Income Tax @ 22% Net Income $ 1,163,537 $ 1,216,462 $ 1,240,625 $ 1,252,013 $ 1,274,789 $ 930,830 $ 973,170 S 992,500 $ 1,001,610 $ 1,019,831 $ 698,122 $ 729,877 $ 744,375 $ 751,208 $ 764,873 $ 325,441 $ 325,442 $ 325,443 $ 325,444 $ 325,445 $ 3,117,930 $3,244,951 $ 3,302,943 $ 3,330,275 $ 3,384,939 $ 5,354,807 $ 5,651,186 $ 5,786,498 $ 5,850,270 $ 5,977,814 $ 372,300 $ 393,470 $ 403,135 $ 407,690 $ 416,801 $ 267,740 $ 282,559 $ 289,325 $ 292,513 S 298,891 $ 4,714,767 $ 4,975,157 $ 5,094,038 $ 5,150,066 $5,262,123 210,000 223,000 236,000 249,000 262,000 43,000 44,700 46,400 48,100 49,800 214,192 226,047 231,460 234,011 239,113 $ 4,247,574 $ 4,481,409 $ 4,580,178 $ 4,618,955 $ 4,711,210 $ 230,000 $ 230,000 $ 230,000 $ 230,000 $ 230,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 124,000 $ 124,000 $ 124,000 $ 124,000 $ 124,000 $ 3,793,574 $ 4,027,409 $ 4,126,178 $ 4,164,955 $ 4,257,210 $ 834,586 $ 886,030 S 907,759 $ 916,290 S 936,586 $ 2,958,988 $ 3,141,379 $3,218,419 $ 3,248,665 $3,320,624

Answer 1

Vertical Analyse Tucove 2016 2017 2018 2019 3,320,624 2.958,988 3,141,379/ 3.018119 3248,665 / 2015 Horůzoutal Analysis Change in Breme 2015-16 1 2016-17 2017-2018 2018-19 7. 1% 192,391 6.163 77040 2.454 30,246 70 271,999 2.2151 el