C D Number of rooms $ ADR OCC RevPAR 300 2015 230 $ 85% 2016 234 $ 86% 2017 240 $ 87% 2018 247 $ 88% 2019 256 88% REVENUE Rooms Food & Beverage Other Operated Departments Miscellaneous Income TOTAL REVENUE $ 2,598,100 $ 2,812,783 $ 2,924,641 $ 3,116,191 $ 3,152,037 $ 333,673 $ 378,245 $ 351,244 $ 320,721 $ 353,944 $ $ 81,376 $ 101,028 $ 111,131 $ 90,816 DEPARTMENTAL EXPENSES Rooms Food & Beverage Other Operated Departments TOTAL DEPARTMENTAL EXPENSES $ 2,649,024 $ 2,918,832 $ 3,114,476 $ 2,966,355 $ 3,051,108 $ 779,430 $ 900,090 $ 965,131 $ 934,857 $ 945,611 $ 135,053 $ 135,039 $ 188,243 $ 151,601 $ 143,110 TOTAL DEPARTMENTAL PROFITS UNDISTRIBUTED OPERATING EXPENSES Administrative & General Marketing Utility Costs Property Operation & Maintenance TOTAL UNDISTRIBUTED OPERATING EXPENSES $ $ $ $ 712,667 $ 610,327 $ 330,306 $ 351,476 $ 763,952 $ 622,703 $ 344,937 $ 373,369 $ 788,277 $ 664,596 $ 371,599 $ 383,536 $ 793,210 $ 738,631 $ 377,833 $ 387,269 $ 786,030 736,311 356,926 382,653 GROSS OPERATING PROFIT Franchise Fees (Royalty) (5% of Rooms Revenue) Management Fees (7% of GOP) INCOME BEFORE FIXED CHARGES SELECTED FIXED CHARGES Property Taxes Insurance Reserve For Capital Replacement + $ $ $ 328,545 $ 59,700 $ 150,467 $ 328,545 $ 59,700 $ 169,400 $ 328,545 $ 59,700 $ 171,091 $ 328,545 $ 59,700 $ 150,467 $ 328,545 59,700 169,400 EBITDA Depreciation Interest Expense Income Before Income Tax Income Tax @ 20% Net Income $ $ 280,000 $ 120,000 $ 280,000 $ 120,000 $ 280,000 $ 120,000 $ 280,000 $ 120,000 $ 280,000 120,000 Find the missing value 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. Pars TWISSECTION Closed Tarik Dogru, PhD