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-201

The instructions are at the top. Thats all the information that wAs given to me to complete this question. If dont know how to solve this question. please allow me to go to someone else without wasting my question.Thanks

Hotel Tally Number of rooms 285 2015 225 829 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 1.506,855 415.695.984 151,013.25 3.462.390 1.590,050 556.026.838 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,6042 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 94,500 155,918.927 421,580 94.500 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