Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Average Number of rooms $ ADR OCC RevPAR 200 2015 170 $ 75% 128 $ 2016 175 $ 77% 135 $ 2017 177 $ 78%

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Average Number of rooms $ ADR OCC RevPAR 200 2015 170 $ 75% 128 $ 2016 175 $ 77% 135 $ 2017 177 $ 78% 138 $ 2018 179 $ 78% 140 $ 2019 183 78% 143 $ REVENUE Rooms Food & Beverage Other Operated Departments Miscellaneous Income TOTAL REVENUE $ 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 DEPARTMENTAL EXPENSES Rooms Food & Beverage Other Operated Departments TOTAL DEPARTMENTAL EXPENSES $ 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 TOTAL DEPARTMENTAL PROFITS $ 8,472,737 $ 8,896,137 $ 9,089,441 $ 9,180,545 + 9,362,753 UNDISTRIBUTED OPERATING EXPENSES Administrative & General Marketing Utility Costs Property Operation & Maintenance TOTAL UNDISTRIBUTED OPERATING EXPENSES $ 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 2 GROSS OPERATING PROFIT $ 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 2 Franchise Fees (Royalty) (4% of Rooms Revenue) 3 Management Fees (5% of GOP) 4 5 INCOME BEFORE FIXED CHARGES 6 7 SELECTED FIXED CHARGES 8 Property Taxes 9 Insurance -0 Reserve For Capital Replacement (4% of GOP) 1 12 EBITDA 13 Depreciation 14 Amortization 25 Interest Expense 6 Income Before Income Tax 47 Income Tax @ 22% 18 Net Income 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,027,409 $ 4,126,178 $ 4,164,955 $ 4,257,210 $ 834,586 $ 886,030 5 907,759 $ 916,290 $ 936,586 $ 2,958,988 $ 3,141,379 $ 3,218,419 $ 3,248,665 $ 3,320,624 0 P 2015-2016 Difference % Change Horizontal Analysis 2016-2017 2017-2018 Difference Change Difference % Change 2018-2019 Difference Change U V W X R S T Vertical Analysis 2016 2017 2015 2018 2019 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

Step: 3

blur-text-image

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

More Books

Students also viewed these Accounting questions

Question

=+8.4. Show that B 8 [W] k-0 n=1m=1 A-1

Answered: 1 week ago

Question

8. Demonstrate aspects of assessing group performance

Answered: 1 week ago