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 

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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Corporate Finance Questions!