Question: Using the following partial Excel work sheet for Cozy Motel, prepare the Income Statement, the Statement of Changes in Equity, and an unclassified Balance
Using the following partial Excel work sheet for Cozy Motel, prepare the Income Statement, the Statement of Changes in Equity, and an unclassified Balance Sheet for the company. Assume the owner did not make any investments in the business during the year. Account Cash Accounts receivable Office supplies Prepaid insurance Building Accumulated depreciation Building Notes payable Salaries payable S. Ramone, capital S. Ramone, withdrawals Motel rental revenue Depreciation expense, Building Salaries expense Insurance expense Rent expense Office supplies expense Repairs expense Telephone expense Totals Net Income Totals Cozy Motel Work Sheet For Year Ended June 30, 2015 Income Statement Dr. Cr. 2,825 1,560 700 1,300 200 550 750 7,885 132,665 140,550 140,550 140,550 140,550 Statement of Changes in Dr. Cr. 11.475 1,550 1,800 7.400 130,000 41.425 193,650 193,650 5,825 2,000 3,160 50,000 60,985 132,665 193,650
Step by Step Solution
3.39 Rating (140 Votes )
There are 3 Steps involved in it
Based on the provided partial Excel worksheet for Cozy Motel I will prepare the Income Statement the Statement of Changes in Equity and an unclassifie... View full answer
Get step-by-step solutions from verified subject matter experts
