Answered step by step
Verified Expert Solution
Question
1 Approved Answer
what does that mean ? 2015 450 Number of Rooms Available ADR OCC RevPAR 215 85% 183 2016 450 220 86% 189 2017 450 225
what does that mean ?
2015 450 Number of Rooms Available ADR OCC RevPAR 215 85% 183 2016 450 220 86% 189 2017 450 225 86 193 2018 450 227 86% 195 2019 450 231 87% 201 Istanbul Hotel Income Statement REVENUE Rooms Food & Beverage Other Operated Depts Misc Income Total Revenue 30,016,687.5 7,585,300 1,412,800 2,278,000 41,292,787.5 31,076,100 7,615,900 1,455,700 2,210,000 42,357,700 31,700,250 7,566,000 1,459,400 2,280,900 43,006,550 32,064,885 7,436,820 1.667.570 2,437,760 43,607,035 33,009,322.5 7,659,924.6 1,734,272.8 2,559,648 44,963,167.9 DEPARTMENTAL EXPENSES Rooms Food & Beverage Other Operated Depts Total Departmental Expenses 11,492,600 7,831,900 504,600 19,829,100 11,558,800 7,897,800 512,000 19,968,600 11,633,700 7,898,500 519,400 20,051,600 13,523.900 8,086,560 588,130 22,198,590 13,794,378 8,329,156.8 611,655.2 22,735,190 Total Departmental Profit 21,463,687.5 22,389,100 22,954,950 21,408,445 22,227,977.9 UNDISTRIBUTED OPERATING EXPENSES Administrative & General Marketing Utility Costs Property Operations & Maintenance Total Undistributed Operating Expenses GROSS OPERATING PROFIT 3,659,800 3,565,100 3,305,800 2,325,400 12,856,100 3,700,800 3,571,200 3,316,400 2,342,500 12,930,900 3,741,800 3,577,300 3,327,000 2,359,600 13,005,700 4,061,210 3,372,120 1,843,700 2,192,320 11,469,350 4,142,434.2 3,473,283.6 1,917,448 2,301,936 11,835, 101.8 8,607,587.5 9,458,200 9,949,250 9,939,095 10,392,876.1 1,500,834.375 258,227.625 1,553,805 283,746 1,585,012.5 298,477.5 1,603,244.25 298,172.85 1,650,466.125 311,786,283 6,848,525.5 7,620,649 8,065,760 8,037,677.9 8,430,623.692 Franchise Fees (Royalty) Management Fees INCOME BEFORE FIXED CHARGES Selected Fixed Charges Property Taxes Insurance Reserve For Capital Replacement 1,312,900 447,900 430,379.375 1,353,400 455,600 472,910 1,394,000 455,500 497,462.5 1,444,300 483,480 1,127,850 1,473,186 497.984.4 1,172,964 EBITDA Depreciation Interest Expense Income Before Income Tax Income Tax Net Income 4,657,346.125 680,000 60,000 3,917,346,125 1,096,856.915 2,820,489.21 5,338,739 680,000 60,000 4,598,739 1,287,646.92 3,311,092.08 5,718,797.5 680,000 60,000 4,978,797.5 1,394,063.3 3,584,734.2 4,982,047.9 621.000 60,000 4,301,047.9 1,204,293.412 3,096,754.488 5,286,489.292 609,000 60,000 4,617,489.292 1,292,897.002 3,324,592.29 2015-2016 Dollar Change % Change Horizontal Financial Statement Analysis 2016-2017 2017-2018 Dollar Change % Change Dollar Change % Change 2018-2019 Dollar Change % Change Vertical Financial Statement Analysis 2015 2016 2017 2018 2019 Complete the vertical and horizontal analysis (these pictures are side-by-side on the Excel) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started