Question

1 Approved Answer

Posted on Jul 24, 2024

Number of Rooms Available ADR OCC RevPAR 450 215 85% 183 450 220 86% 189 450 225 86 193 450 227 86% 195 450 231

Number of Rooms Available ADR OCC RevPAR 450 215 85% 183 450 220 86% 189 450 225 86 193 450 227 86% 195 450 231 87% 201 Istanbul Hotel Income Statement REVENUE Rooms Food & Beverage Other Operated Depts Misc Income Total Revenue DEPARTMENTAL EXPENSES Rooms Food & Beverage Other Operated Depts Total Departmental Expenses 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 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 21,463,687.5 22,389,100 22,954,950 21,408,445 22,227,977.9 Total Departmental Profit UNDISTRIBUTED OPERATING EXPENSES Administrative & General Marketing Utility Costs Property Operations & Maintenance Total Undistributed Operating Expenses 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 GROSS OPERATING PROFIT 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 Franchise Fees (Royalty) Management Fees INCOME BEFORE FIXED CHARGES 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 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 2018-2019 Dollar Change % Change Dollar Change % Change Dollar Change % Change Vertical Financial Statement Analsysis 2015 2016 2017 2018 2019 Complete the vertical and horizontal analysis (these pictures are side-by-side on the Excel) Number of Rooms Available ADR OCC RevPAR 2015 450 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 Mise 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 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 GROSS OPERATING PROFIT 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 Franchise Fees (Royalty) Management Fees INCOME BEFORE FIXED CHARGES 6,848,525.5 7,620,649 8,065,760 8,037,677.9 8,430,623.692 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,0479 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 Number of Rooms Available ADR OCC RevPAR 450 215 85% 183 450 220 86% 189 450 225 86 193 450 227 86% 195 450 231 87% 201 Istanbul Hotel Income Statement REVENUE Rooms Food & Beverage Other Operated Depts Misc Income Total Revenue DEPARTMENTAL EXPENSES Rooms Food & Beverage Other Operated Depts Total Departmental Expenses 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 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 21,463,687.5 22,389,100 22,954,950 21,408,445 22,227,977.9 Total Departmental Profit UNDISTRIBUTED OPERATING EXPENSES Administrative & General Marketing Utility Costs Property Operations & Maintenance Total Undistributed Operating Expenses 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 GROSS OPERATING PROFIT 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 Franchise Fees (Royalty) Management Fees INCOME BEFORE FIXED CHARGES 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 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 2018-2019 Dollar Change % Change Dollar Change % Change Dollar Change % Change Vertical Financial Statement Analsysis 2015 2016 2017 2018 2019 Complete the vertical and horizontal analysis (these pictures are side-by-side on the Excel) Number of Rooms Available ADR OCC RevPAR 2015 450 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 Mise 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 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 GROSS OPERATING PROFIT 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 Franchise Fees (Royalty) Management Fees INCOME BEFORE FIXED CHARGES 6,848,525.5 7,620,649 8,065,760 8,037,677.9 8,430,623.692 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,0479 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