Transfer accounts and balances to a spreadsheet worksheet

Reference no: EM131311543

The 2012 year-end adjusted balances taken from the general ledger of Cooperstown Services, Inc. are listed below in general ledger order.

Coopertown Suppliers, Inc.
	DR	CR
Cash	$12,950
Accounts receivable	28,150
Supplies	8,400
Prepaid insurance	9,500
Land	115,000
Buildings	360,000
Equipment	260,000
Accumulated depreciation		$239,900
Accounts payable		35,300
Salaries payable		7,300
Taxes payable Common stock		5,200 31,500
Additional paid-in capital - Common Retained earnings		15,400 427,600
Dividends	25,400
Service revenue		475,000
Salaries expense	335,600
Depreciation expense	25,100
Supplies expense	12,950
Insurance expense	8,200
Miscellaneous expense	30,850
Utilities expense	5,100
Total	$1,237,200	$1,237,200

Transfer these accounts and balances to a spreadsheet worksheet and prepare an income statement, a classified balance sheet, and a statement of retained earnings, all in good form using proper headings for each statement. Note that Cooperstown is a service company so there is no cost of goods sold in its chart of accounts. Also, assume that all the liabilities are current liabilities. Keep in mind that you should not report any accounts without balances in your statements.

Reference no: EM131311543

Questions Cloud

Discuss the core aspects that comprise virtue ethics : Discuss the core aspects that comprise virtue ethics. Also, analyze one primary strength and one principal weakness of this ethical theory

Effective interest rate per compounding period corresponds : What effective interest rate per compounding period corresponds to the following interest rate?

Should organizations be left to police : Should organizations be left to police themselves with respect to providing access to information or should the government impose privacy legislation?

Multimedia systems development : Q.1 Identify and explain the three major interrelated tasks for creating 3-D animation. Q.2 Identify and explain the advantages of sampled sound and synthesized sound.

Transfer accounts and balances to a spreadsheet worksheet : Note that Cooperstown is a service company so there is no cost of goods sold in its chart of accounts. Also, assume that all the liabilities are current liabilities. Keep in mind that you should not report any accounts without balances in your sta..

Complete the ethical theory chart : Directions: Complete the Ethical Theory Chart. You will be comparing and contrasting the key ethical ideas of philosophers. Fill out each column with a detailed response. Include a summary at the bottom of this page

What business intelligence would need to predict enrollments : What business intelligence would it need to determine what curriculums to offer? Do you think your school gathers and uses this kind of business intelligence? Why or why not?

The operating and maintenance expenses : The operating and maintenance expenses on a machine are expected to increase 0.5% per month. This month’s expenses are $2,000. Find the equal monthly series that is equivalent to the monthly expenses over 5 years for an interest rate of 21% per year ..

Capital investment and concept check : To illustrate and further support our strategic financial planning systems we need to show the CFO and management team an example of the application of the previously constructed WACC. Capital investment: Acme is planning construction of a new loadin..

User Account

All Pages