Analyzing Financial Statements
Prepare Financial Statements from Adjusted Trial Balance Worksheet (110 pts)
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.
Please submit your spreadsheet to the Week 6 Assignments page. Ensure your work is accurate and reflects CSU-Global writing expectations.
12 years ago
25
Purchase the answer to view it

- coopertown_suppliers__completesolutions.xlsx
Purchase the answer to view it

- solution_to_assignment.xlsx
Purchase the answer to view it

- financial_statements_sheet.xls
Purchase the answer to view it

- cooperstown_solution.xls
Purchase the answer to view it

- prepare_financial_statements_from_adjusted_trial_balance_worksheet_-_cooperstown_services_inc.xlsx
Purchase the answer to view it

- solutions_25.xlsx
Purchase the answer to view it

- financial_statements_from_adjusted_trial_balance_worksheet.xls
Purchase the answer to view it

- financial_statements_from_adjusted_trial_balancecooperstown_services_inc..xls
- Acct Homework help
- Pharma Biotech is interested in developing an initial “big picture” of the size of financing that might be needed to...
- Solve the system of equations x+y+x=5.8 2x+4y+2z=13.8 -x+8y-3z=-1.7
- a circle has the equation x^2+y^2^4x-4y-1=0 graph the circle using center (h,k) and raduis r. find the intercepts, if any...
- 28 Marks Total ASSIGNMENT 14 Compton, de Broglie, and Wave-Particle Duality (1) There are similarities and differences between the Photoelectric Effect and Compton Scattering. ...
- Is an online course I have two quizzes of 20 questions each and a final exam of 45 questions can...
- solve for the variable indicated: 1/5xy-10y=5 for y
- [2.02]In what way was the Treaty of Paris unfair to Native Americans?
- I am in middle of building a GUI(Java) for a stack. I would like to know if how do I...
- Finance

