Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Average Number of rooms 200 2015 170 $ 75% 128 $ 2016 175 $ 77% 135 $ 2017 177 $ 78% 138 $ 2018 179

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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 Vertical Analysis 2016 2017 2015 2018 2019 2015-2016 Difference Change Horizontal Analysis 2016-2017 2017-2018 Difference % Change Difference % Change 2018-2019 Difference % Change B 3 19 23 45 39 14 191 123 000 113 210 .000 000 ,000 210 5,586 3.624 9:44

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services

Authors: Alvin Arens, Randal J. Elder

14th Global Edition

0273755013, 978-0273755012

More Books

Students also viewed these Accounting questions

Question

16.2 Explain three trends in the labour movement in Canada.

Answered: 1 week ago