Porr / Cowwe www.statewwwy finding rever, room resume, or record departmental expenses, total departmental of wiscibule nating pass grows operating profit, fiance, managemcurfees, income before fixea charger, ERTDA, come high income war income ornet inexome for the period of 2015-2016 Hotel Tally Number of rooms 285 2015 225 82% ADR OCC 2016 230 83% 2017 235 84% 2018 240 85% 2019 242 86% RevPAR REVENUE Rooms Food Beverage Other Operated Departments TOTAL REVENUE 4,305,300 4,543,000 2,598,099.9 3,089,037.99 333,673.2 409,248.84 4,780,700 5,018,400 3,178,957.5 3,502,267.57 379,343.25 346,796.17 5,256,100 3,617,990.64 382.034.88 DEPARTMENTAL EXPENSES Rooms Food Beverage Other Operated Departments TOTAL DEPARTMENTAL EXPENSES 2,943,360 3,462,390 1,506,855 1,590,050 415,695.984 556,026.838 151,013.25 153,453.75 4,080.700 1,673,245 635,791.5 183.898.54 4,637,325 1,756,440 735,476.19 162.970.86 5,058,900 1,839,635 795,957.941 152.650.24 TOTAL DEPARTMENTAL PROFITS UNDISTRIBUTED OPERATING EXPENSES Administrative & General Information Systems Marketing Utility Costs Property Operation & Maintenance TOTAL UNDISTRIBUTED OPERATING EXPENSES 844,642.56 122.775 632,932.16 342,539.68 364,493.92 904,126.17 122.763 679,831.53 376,582.64 407,622.6 859,938 144.802 1,087,520.4 608.070.6 627,604.2 864,670.84 126,334 805,173.93 411,871.9 422.158.11 863,924.7 119,258 822,545.32 398,728.2 427,467.68 GROSS OPERATING PROFIT Franchise Fees (5% of Rooms Revenue) Management Fees (6% of GOP) INCOME BEFORE FIXED CHARGES SELECTED FIXED CHARGES Property Taxes Insurance Reserve For Capital Replacement 334,803 94,500 171,090.92 378,138 421,580 94,500 94,500 155,918.927 176,045.875 402.534 94,500 198,198.14 397,719 94,500 200,176,376 EBITDA Depreciation Amortization Interest Expense 400,000 200,000 280,000 400,000 200,000 280,000 400,000 200,000 280,000 400,000 200,000 280,000 400,000 200,000 280,000 Income Before Income Tax Income Tax @ 22% Net Income Hotel Tally Number of rooms 285 2015 2016 2017 2018 2019 ADR OCC $ 225 $ 230 $ 235 $ 240 $ 242 82% 83% 84% 85% 86% RevPAR REVENUE Rooms Food Beverage $ 4,305,300 $ 2,598,100 $ 333,673 $ 4,543,000 S 3,089,038 $ 409,249 $ 4,780,700 $ 3,178,958 $ 379,343 $ 5,018,400 $ 3,502,268 $ 346,796 $ 5,256,100 $ 3,617,991 $ 382,035 Other Operated Departments TOTAL REVENUE DEPARTMENTAL EXPENSES Rooms Food $ 2,943,360 $ 1.506,855 $ 415,696 $ 151,013 $ 3,462,390 $ 1.590,050 $ 556,027 $ 153.454 $ 4,000,700 $ 1,673,245 $ 635,792 $ 183,899 5 4,637,325 $ 1,756,440 $ 735,476 $ 162,971 $ 5,058.900 5 1,839,635 $ 795,958 $ 152,650 Beverage Other Operated Departments TOTAL DEPARTMENTAL EXPENSES TOTAL DEPARTMENTAL PROFITS UNDISTRIBUTED OPERATING EXPENSES Administrative & General Information Systems $ 844,643 $ 122,775 5 632,932 $ 342.540 $ 364,494 $ 859,938 s 144.802 $ 1,087,520 $ 608,071 $ 627,604 904,126 $ 122.763 $ 679,832 $ 376,583 $ 407,623 $ 864,671 $ 126,334 $ 805,174 $ 411,872 $ 422,158 $ 863,925 $ 119,258 $ 822,545 $ 398,728 $ 427,468 Marketing - Utility Costs Property Operation & Maintenance TOTAL UNDISTRIBUTED OPERATING EXPENSES - GROSS OPERATING PROFIT Franchise Fees (5% of Rooms Revenue) Management Fees (6% of GOP) - INCOME BEFORE FIXED CHARGES - SELECTED FIXED CHARGES Property Taxes S 334,803 S 94,500 S $ 378,138 5 94,500 $ 421,580 $ 94,500 $ $ 407,534 S 94,500 $ $ 397,719 $ 94,500 $ Insurance Insurance 94,500 $ 171,091 Reserve for Capital Replacement 94,500 $ 155,919 94,500 $ 176,046 94,500 $ 198,198 94,500 $ 200,176 EBITDA Depreciation $ 400,000 $ 200,000 $ 280,000 Amortization $ 400,000 $ 200,000 $ 280,000 $ 400,000 $ 200,000 $ 280,000 $ 400,000 $ 200,000 $ 280,000 $ 400,000 $ 200,000 $ 280,000 Interest Expense - Income Before Income Tax Income Tax @ 22% Net Income Part 1: Complete the income statement by finding revpar, room revenue, total revenue, total departmental expenses, total departmantal profit, total undistributed operating expenses, gross operating profit, franchise fees, management fees, income before fixed charges, EBITDA, income before income tax, income tax, and net income for the period of 2015-2019. Porr / Cowwe www.statewwwy finding rever, room resume, or record departmental expenses, total departmental of wiscibule nating pass grows operating profit, fiance, managemcurfees, income before fixea charger, ERTDA, come high income war income ornet inexome for the period of 2015-2016 Hotel Tally Number of rooms 285 2015 225 82% ADR OCC 2016 230 83% 2017 235 84% 2018 240 85% 2019 242 86% RevPAR REVENUE Rooms Food Beverage Other Operated Departments TOTAL REVENUE 4,305,300 4,543,000 2,598,099.9 3,089,037.99 333,673.2 409,248.84 4,780,700 5,018,400 3,178,957.5 3,502,267.57 379,343.25 346,796.17 5,256,100 3,617,990.64 382.034.88 DEPARTMENTAL EXPENSES Rooms Food Beverage Other Operated Departments TOTAL DEPARTMENTAL EXPENSES 2,943,360 3,462,390 1,506,855 1,590,050 415,695.984 556,026.838 151,013.25 153,453.75 4,080.700 1,673,245 635,791.5 183.898.54 4,637,325 1,756,440 735,476.19 162.970.86 5,058,900 1,839,635 795,957.941 152.650.24 TOTAL DEPARTMENTAL PROFITS UNDISTRIBUTED OPERATING EXPENSES Administrative & General Information Systems Marketing Utility Costs Property Operation & Maintenance TOTAL UNDISTRIBUTED OPERATING EXPENSES 844,642.56 122.775 632,932.16 342,539.68 364,493.92 904,126.17 122.763 679,831.53 376,582.64 407,622.6 859,938 144.802 1,087,520.4 608.070.6 627,604.2 864,670.84 126,334 805,173.93 411,871.9 422.158.11 863,924.7 119,258 822,545.32 398,728.2 427,467.68 GROSS OPERATING PROFIT Franchise Fees (5% of Rooms Revenue) Management Fees (6% of GOP) INCOME BEFORE FIXED CHARGES SELECTED FIXED CHARGES Property Taxes Insurance Reserve For Capital Replacement 334,803 94,500 171,090.92 378,138 421,580 94,500 94,500 155,918.927 176,045.875 402.534 94,500 198,198.14 397,719 94,500 200,176,376 EBITDA Depreciation Amortization Interest Expense 400,000 200,000 280,000 400,000 200,000 280,000 400,000 200,000 280,000 400,000 200,000 280,000 400,000 200,000 280,000 Income Before Income Tax Income Tax @ 22% Net Income Hotel Tally Number of rooms 285 2015 2016 2017 2018 2019 ADR OCC $ 225 $ 230 $ 235 $ 240 $ 242 82% 83% 84% 85% 86% RevPAR REVENUE Rooms Food Beverage $ 4,305,300 $ 2,598,100 $ 333,673 $ 4,543,000 S 3,089,038 $ 409,249 $ 4,780,700 $ 3,178,958 $ 379,343 $ 5,018,400 $ 3,502,268 $ 346,796 $ 5,256,100 $ 3,617,991 $ 382,035 Other Operated Departments TOTAL REVENUE DEPARTMENTAL EXPENSES Rooms Food $ 2,943,360 $ 1.506,855 $ 415,696 $ 151,013 $ 3,462,390 $ 1.590,050 $ 556,027 $ 153.454 $ 4,000,700 $ 1,673,245 $ 635,792 $ 183,899 5 4,637,325 $ 1,756,440 $ 735,476 $ 162,971 $ 5,058.900 5 1,839,635 $ 795,958 $ 152,650 Beverage Other Operated Departments TOTAL DEPARTMENTAL EXPENSES TOTAL DEPARTMENTAL PROFITS UNDISTRIBUTED OPERATING EXPENSES Administrative & General Information Systems $ 844,643 $ 122,775 5 632,932 $ 342.540 $ 364,494 $ 859,938 s 144.802 $ 1,087,520 $ 608,071 $ 627,604 904,126 $ 122.763 $ 679,832 $ 376,583 $ 407,623 $ 864,671 $ 126,334 $ 805,174 $ 411,872 $ 422,158 $ 863,925 $ 119,258 $ 822,545 $ 398,728 $ 427,468 Marketing - Utility Costs Property Operation & Maintenance TOTAL UNDISTRIBUTED OPERATING EXPENSES - GROSS OPERATING PROFIT Franchise Fees (5% of Rooms Revenue) Management Fees (6% of GOP) - INCOME BEFORE FIXED CHARGES - SELECTED FIXED CHARGES Property Taxes S 334,803 S 94,500 S $ 378,138 5 94,500 $ 421,580 $ 94,500 $ $ 407,534 S 94,500 $ $ 397,719 $ 94,500 $ Insurance Insurance 94,500 $ 171,091 Reserve for Capital Replacement 94,500 $ 155,919 94,500 $ 176,046 94,500 $ 198,198 94,500 $ 200,176 EBITDA Depreciation $ 400,000 $ 200,000 $ 280,000 Amortization $ 400,000 $ 200,000 $ 280,000 $ 400,000 $ 200,000 $ 280,000 $ 400,000 $ 200,000 $ 280,000 $ 400,000 $ 200,000 $ 280,000 Interest Expense - Income Before Income Tax Income Tax @ 22% Net Income Part 1: Complete the income statement by finding revpar, room revenue, total revenue, total departmental expenses, total departmantal profit, total undistributed operating expenses, gross operating profit, franchise fees, management fees, income before fixed charges, EBITDA, income before income tax, income tax, and net income for the period of 2015-2019