How to set in the pro-form a balance sheet for the company income statement
COMBINED STATEMENT OF INCOME 12.131121 \".4. 12131720 % 12731719 % SALES ROOMS 8.865.539 73.32% 8.033.063 72.29% 0.055.990 74.32% FOOD 2.247312 18.58% 2.113.508 19.02% 1.880.245 17.35% BEVERAGE 715,834 5.92% 707.396 6.37% 649.040 5.99% TELEPHONE 93,391 0.77% 98.949 0.89% 97.742 0.90% OTHER 170.135 1.41% 158.889 1.43% 156.901 1.45% TOTAL SALES 12.002.211 100.00% 11.111.755 100.00% 10.039310 100.00% COST OF GOODS SOLD FOOD 732,824 32.61% 684.829 32.40% 616.494 32.79% BEVERAGE 199.517 27.87% 198.071 28.00% 195.241 30.08% TELEPHONE 33.107 35.45% 29.685 30.00% 29.323 30.00% TOTAL COST OF GOODS SOLD 955.448 29.92% 912.505 29.54% 841.050 30.21% PAYROLL AND RELATED ROOMS 929,503 10.48% 815.521 10.15% 779.685 9.68% FOOD 383.714 17.07% 348.055 15.47% 337.309 17.97% BEVERAGE 86.3 50 12.00% 05.947 12.15% 84.399 13.03% TELEPHONE 22.275 23.35% 23.496 23.75% 23.210 23.75% TOTAL SALARIES AND WAGES 1.421.842 11.76% 1.273.120 11.46% 1.225.602 11.31% OPERATING EXPENSES ROOMS 866,429 9.77% 709.057 8.83% 666.083 8.27% FOOD 50.034 2.67% 57.101 2.70% 55.422 2.95% BEVERAGE 30,614 5.11% 30.579 4.32% 30.711 4.73% TELEPHONE 6,933 7.48% 6.376 6.44% 6.302 6.45% OTHER 80,567 47.35% 79.420 50.00% 78.450 50.00% TOTAL OPERATING EXPENSES 1.050.627 3.69% 832.533 7.94% 835.968 7.72% TOTAL DEPARTMENTAL PROFIT 8.654.294 71.57% 0.043.517 72.39% 7,936.290 73.21% UNDISTRIBUTED EXPENSES ADMINISTRATIVE 550.430 4.60% 521.349 4.69% 472.349 4.36% SALES & MARKETING 778.501 0.44% 733.012 0.60% 006.912 0.15% MAINTENANCE 430.058 3.56% 396.471 3.57% 375.582 3.46% UTILITIES 484,997 4.01% 438.850 3.95% 384.108 3.54% TOTAL UNDISTRIBUTED EXPENSES 2.250.047 10.81% 2.089.503 18.81% 1.898.945 17.52% GROSS OPERATING PROFIT 6.404248 52.96% 5.953.834 53.58% 0.037.345 55.70% FIXED EXPENSES FRANCHISE FEES 177.311 1.47% 150.061 1.45% 161.120 1.49% INSURANCE EXPENSES 183.032 1.52% 190.085 1.71% 187.767 1.73% MANAGEMENT FEES 265.965 2.20% 240.992 2.17% 241.580 2.23% MORTGAGE INTEREST 736,110 6.09% 761.210 8 85% 751.927 6.94% PROPERTY TAXES 395.000 3.27% 300.000 2.70% 295.000 2.72% DEPRECIAT ION EXPENSE 200.000 1.05% 200.000 1.00% 200.000 1.85% TOTAL FIXED EXPENSES 1.958.319 16.19% 1.852.948 16.68% 1.837.494 16.95% NET INCOME BEFORE INCOME TAXES 4.445.929 30.77% 4.100.806 36.91% 4.199.852 38.74% INCOME TAXES 689.186 7.35% 820.177 7.38% 839.970 7.75% NET INCOME 3.556.743 29.41% 3.280.709 29.52% 3.359.881 31.00% STATISTICS: 12.131121 12131720 12731119 ROOMS OCCUPIEDTRANSIENT 29,581 30.379 22.292 ROOMS OCCUPIED-GROUP 21.498 21.599 20.577 ROOMS OCCUPIED-WHOLESALE 37.246 34.719 42.869 TOTAL ROOMS OCCUPIED 88.325 86.797 85.738 TOTAL ROOMS AVAILABLE 105.050 105.850 105.850 ROOMS IN HOTEL 290 290 290 OCCUPANCY % 83.4% 82.0% 81.0% AVERAGE DAILY RATE 100.374 92.55 93.961 REVPAR 83.756 75.801 76.108