Excel: Prepare Balance Sheet with total asset turnover rate and Asset Management analysis
broy77The following (given in scrambled order) are accounts and balances from the accounting records of the company as of December 31, 2012, after the books were closed for the year.
Common stock, authorized 21,000 share At $1 par value, issued 12,000 shares | $12,000 |
Additional paid-in capital | 38,000 |
Cash | 14,000 |
Marketable securities | 17,000 |
Accounts receivable | 26,000 |
Accounts Payable | 16,000 |
Current maturities of long-term debt | 11,000 |
Mortgages payable | 80,000 |
Bonds payable | 65,000 |
Inventory | 33,000 |
Land and buildings | 57,000 |
Machinery and equipment | 120,000 |
Goodwill | 13,000 |
Patents | 9,000 |
Other assets | 45,000 |
Deferred income taxes (long-term liability) | 18,000 |
Retained earnings | 33,000 |
Accumulated depreciation | 61,000 |
Bonds and mortgages generally have 10-30 years until maturity. Marketable securities are short-term investments that can be converted to cash in a matter of minutes.
Required:
- Prepare a classified balance sheet with a proper heading on a spreadsheet. For assets, use the classifications of current assets, plant and equipment, intangibles, and other assets. For liabilities, use the classifications of current liabilities and long-term liabilities.
- Compute the total asset turnover rate assuming that total revenues in 2012 were $682,500. Round to the nearest hundredth, e.g. 3.33.
- Assume that the company's primary competitor has an asset turnover of 2.12. What does this tell you about Alleg’s asset management?
The following links provide sample formatting for income statements and statements of retained earnings.
- 9 years ago
- 20
Answer(4)
Purchase the answer to view it
NOT RATED
- alleg_inc.xls
Purchase the answer to view it
NOT RATED
- perfect.xlsx
Purchase the answer to view it
NOT RATED
- solutions_0.xlsx
Purchase the answer to view it
NOT RATED
- fin_400_module_4_assignment_-_classified_balance_sheets.xlsx
Bids(0)
other Questions(10)
- COMM 105 Week 1-5 Entire GRADE A+ 100%
- business
- PSY 430 Week 3 DQs
- MGT 300 Week 4 Team Assignment Pro Forma
- LTC 328 Week 4 Team Assignment Comparison Brochure Refrences
- ISCOM 352 Weeks 1-5 Entire course Logistics Management .
- BSHS 471 Week 1 Learning Team Dq
- correct grammar, make sentences flow
- TinselWriter
- Week Two: Marketing Research_MKT_421