Hotel Shu La La by Michael Scott Number of rooms ADR OCC RevPAR 240 2019 320 80% 256 New Revenues Sales Mis 22.425,600 6,240,000 480,500 40,000 29,186,100 Fixed Cost Variable Cost New VC 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 5,157,888 3,868.800 120,125 9.146,813 20,039,287 4,669,776 2,918,610 291,861 350.233.2 8.230,480.2 11,808,806.8 897,024 708,528.408 Franchise Fees Management Fees INCOME BEFORE FIXED CHARGES 10,203.254.392 SELECTED FIXED CHARGES Property Taxes Insurance Reserve For Capital Replacement 420.000 62,000 180,000 EBITDA Depreciation Interest Expense Income Before Income Tax Income Tax @ 25% Net Income 9.541.254.392 236,000 20,000 9.285.254.392 2,321,313.598 6.963.940.794 Total CMR New CMR 8. What would the required revenue be if a net income of $9,000,000 is desired? 9. What would the occupancy rate be if a net income of $9,000,000 is achieved at $320 ADR? 10. If the depreciation expense decreases by 100,000, what would the breakeven point be? 11. If the hotel reduces all departmental expenses by 10%, what would the new breakeven be? 12. What would the required revenue be if a net income of $10,000,000 is desired and at the same time the fixed expenses incease by $1,200,000? Final Answers Plare final anciare hara VAI AR A hana malumne a further anlain war alle 8 9 10 11 12 Requied Revenue Req Rev OCC BEP with decrease in depreciation BEP I DE decrease by 10% Requied Revenue Hotel Shu La La by Michael Scott Number of rooms ADR OCC RevPAR 240 2019 320 80% 256 New Revenues Sales Mis 22.425,600 6,240,000 480,500 40,000 29,186,100 Fixed Cost Variable Cost New VC 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 5,157,888 3,868.800 120,125 9.146,813 20,039,287 4,669,776 2,918,610 291,861 350.233.2 8.230,480.2 11,808,806.8 897,024 708,528.408 Franchise Fees Management Fees INCOME BEFORE FIXED CHARGES 10,203.254.392 SELECTED FIXED CHARGES Property Taxes Insurance Reserve For Capital Replacement 420.000 62,000 180,000 EBITDA Depreciation Interest Expense Income Before Income Tax Income Tax @ 25% Net Income 9.541.254.392 236,000 20,000 9.285.254.392 2,321,313.598 6.963.940.794 Total CMR New CMR 8. What would the required revenue be if a net income of $9,000,000 is desired? 9. What would the occupancy rate be if a net income of $9,000,000 is achieved at $320 ADR? 10. If the depreciation expense decreases by 100,000, what would the breakeven point be? 11. If the hotel reduces all departmental expenses by 10%, what would the new breakeven be? 12. What would the required revenue be if a net income of $10,000,000 is desired and at the same time the fixed expenses incease by $1,200,000? Final Answers Plare final anciare hara VAI AR A hana malumne a further anlain war alle 8 9 10 11 12 Requied Revenue Req Rev OCC BEP with decrease in depreciation BEP I DE decrease by 10% Requied Revenue