this is the entire thing together

C $ 200 2015 170 $ 75% 128 $ 2016 175 $ 77% 135 $ 2017 177 $ 78% 138 S 2018 179 $ 78% 140 $ 2019 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 S 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 S 1,218,317 $ 1,218,317 $ 1,218,317 $ 82,817 S 82,817 $ 82 817 S 82,817 s 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 1 2 Average Number of rooms 3 4 ADR 5 6 RevPAR 7 8 REVENUE Rooms 10 Food & Beverage 11 Other Operated Departments 12 Miscellaneous Income 13 TOTAL REVENUE 14 15 DEPARTMENTAL EXPENSES 16 Rooms 17 Food & Beverage 18 Other Operated Departments 19 TOTAL DEPARTMENTAL EXPENSES 20 21 TOTAL DEPARTMENTAL PROFITS 22 23 UNDISTRIBUTED OPERATING EXPENSES 24 Administrative & General 25 Marketing 26 Utility Costs 27 Property Operation & Maintenance 28 TOTAL UNDISTRIBUTED OPERATING EXPENSES 29 30 GROSS OPERATING PROFIT 31 32 Franchise Fees (Royalty) (4% of Rooms Revenue) 33 Management Fees (5% of GOP) 34 35 INCOME BEFORE FIXED CHARGES 36 37 SELECTED FIXED CHARGES 38 Property Taxes 39 Insurance 40 Reserve For Capital Replacement (4% of GOP) 41 42 EBITDA 43 Depreciation 44 Amortization 45 Interest Expense 46 Income Before Income Tax 47 Income Tax @ 22% 48 Net Income 49 50 51 $ 1.163,537 $ 1,216,462 $ 1,240,625 $ 1,252,013 $ 1,274,789 $ 930,830 $ 973,170 $ 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 $ 267,740 $ 393,470 $ 282,559 $ 403,135 $ 289,325 $ 407,690 $ 292,513 $ 416,801 298,891 $ 4,714,767 $ 4,975,157 $ 5,094,038 $ 5,150,066 $ 5,262,123 210,000 43,000 214,192 223,000 44,700 226,047 236,000 46,400 231,460 249,000 48,100 234,011 262,000 49,800 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,027409 $ 4,126,178 $ 4,164,955 $ 4,257,210 834,586 $ 886,030 $ 907,759 $ 916,290 $ 936,586 $ 2,958,988 S 3,141,379 S 3,218,419 $ 3,248,665 $ 3,320,624 Insert Draw Formulas View Data Page Layout Tell me Review fx 0 Q $ T U w 1 1 M N Horizontal Analysis 2016-2017 2017-2018 Difference Change Difference XChange Vertical Analysis 2016 2017 2015 2018 2019 2015 2016 Difference Change 2018-2019 Difference Change 2019 183 78% 143 20.020 30528 0704 90,300 747891 084,001 218,317 82,817 1,385,138 3,362,753 1274789 101931 76073 325 AUS 3,384939 5977814 - 416,801 5,752,123 252.000 49.000 272,113 54711110 23000 5 100,000 5 124.000 $ 457,310 5 935,585 0 52 Tally Hotel Home Insert Draw Page Layout Formulas Data Review View Telme Comments *T E G MIR the New New INS SA 13 00 w 3 SL ME 5 VI SSSSSSS 30 og 11 ore 5 000 MSDS 14 18 DAMENTALES 27 Foods 30 LOS OJO 11 SUBUHI 1 TS 25 5 MINUS 1 L TOTAL DEPARTMINAL POSTS 23 OTTIMOS 14 M $ US US USU US WIN IN TH 5 E DISTRIBUTIES SS SS S SAU $ 11 $ 2 TOHO DIECARE . re M 17 DY 14 5 UNS 44100 5 4 11 1 05 15 1340 0 wer WEES Tay Hotel