Purchase Solution

Prepare Financial Statements from Adjusted Trial Balance

Not what you're looking for?

Ask Custom Question

Prepare Financial Statements from Adjusted Trial Balance Worksheet

The adjusted balances taken from the general ledger of Coopertown Suppliers, Inc. are listed below in general ledger order. Transfer these accounts and balances to a spreadsheet worksheet and prepare an Income statement, Balance Sheet, and Statement of Retained Earnings all in good form using proper headings for each statement.

Coopertown Suppliers, Inc.
DR CR
cash $12,950
accounts receivable $28,150
supplies $4,400
prepaid insurance $9,500
land $100,000
buildings $360,000
equipment $260,000
accumulated depreciation - equipment $269,900
accounts payable $33,300
salaries payable $3,300
common stock $1,500
retained earnings $427,600
dividends $25,000
service fees $475,000
rent revenue $5,000
salaries expense $340,600
depreciation expense $25,100
supplies expense $10,950
insurance expense $3,000
miscellaneous selling and admin expense $30,850
utilities expense $5,100
Total $1,215,600 $1,215,600

Purchase this Solution

Solution Summary

Prepare Financial Statements from Adjusted Trial Balance Worksheet

The adjusted balances taken from the general ledger of Coopertown Suppliers, Inc. are listed below in general ledger order. Transfer these accounts and balances to a spreadsheet worksheet and prepare an Income statement, Balance Sheet, and Statement of Retained Earnings all in good form using proper headings for each statement.

Detailed solution contained in attached MS Excel spreadsheet.

Purchase this Solution


Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Introduction to Finance

This quiz test introductory finance topics.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.