excel answer is needed

just common style of income statement is needed.

Problem 4.14 The Warwick Motel has two major operating departments- The following information is supplied to you as of December 31, 20x6: rooms and food. Account Title Account Balance Insurance (Fire) - General Manager's Salary (Adm. & Gen. Salaries and Wages-Rooms- Salaries and Wages-Food Supplies-Food $ 5,000 30,000 80,000 60,000 20,000 Food Purchases Room Salesv Interest Income Interest Expense v Cost of Food Sold 55,000 380,000 1,000 21,000 Food Sales Wages (Adm. & Gen.N Advertising Property Operation and Maintenance v Depreciation 180,000 25,000 10,000 30,000 30,000 Heat/ Power and Lights Supplies and Other-Rooms / Property Taxes v Other Expenses Adm. & Gen 15,000 12,000 30,000 12,000 10,000 Other information is as follows: 1. The beginning and ending inventories of food were $2,000 and $3,000, 2. Fringe benefits and payroll taxes for all employees are 15% of salaries 3. The Warwick Motel pays an average of 25% of its pre-tax income to the respectively and wages. various governmental units in the form of income taxes Required Prepare an income statement for 20X6 for the Warwick Motel based on the USALI. (If you do not have a copy of the USALI use Exhibit 4-2 as a guide.) PROBLEMS 89