CLICK ON IMAGES TO MAKE IT BIGGER

Prepare a summary income statement for the Wilson Motel (showing math and formulas)

The Wilson Motel has two major operated departments: rooms and food. The following information is supplied to you as of December 31, 20x6. 96,000.0 72,000.0 Account Insurance (fire) Rooms department - salaries and wages Food department - salaries and wages Supplies - food department Food purchases Room sales Interest income Interest expense Cost of food sold Food sales A & G - wages G Advertising Maintenance - contract Depreciation Heat Information & telecom. Systems - contract Power and lights Franchise fee Supplies and other - rooms department Property taxes A & G - other expense Account balance $ 5,000 80,000 60,000 20,000 55,000 380,000 1,000 44,000 53,200 180,000 50,000 10,000 20,000 50,000 15,000 10,000 12,000 30,000 30,000 12,000 10,000 FOOD MATH: 57,000 54,000 53,200 Other information 1. The Wilson Motel borrowed $50,000 two year ago from the Wilmore Savings and Loan. On June 30, 20X6, the first non-interest payment is made to Wilmore of $10,000. The funds were borrowed at an interest rate of 10%. 2. The beginning and ending inventories of food were $2,000 and $3,000 respectively. Food consumed by the food and rooms department employees during the year (free of charge) totaled $500 and $300, respectively. 3. Benefits and payroll taxes for all employees, including free food, are 20 percent of gross salaries and wages. 4. The Wilson Motel pays an average of 25 percent of its pretax income to the various gouvernmental units in the form of income taxes. 5. The management fee to be paid to the management company is 3 percent of room sales and 10 percent of total income after undistributed operating expenses. Required Prepare a summary income statement for the Wilson Motel. Wilson Motel Other expenses Profit (loss) Cost of sales costs and related exp -12000 (73,000) Wilson Motel Summary income statement For the year ended December 31, 20X6 Operated departments Net revenues Rooms 380,000 Food 180,000 Miscellaneous Income Total operated departments Undistributed operating expenses Administrative and general Information and telecommunication system Sales and marketing Property opertion and maintenance Utilities Total undistributed expenses Totals Gross operating profit Management fees Income before non-operating expenses Property taxes and insurance EBITDA Depreciation and amortization Interest expense Income before taxes Income taxes Net income