Finance Assignment

profileboomer sooner

Classified Balance Sheets (60 points) 

The following (given in scrambled order) are accounts and balances from the accounting records of Alleg, Inc., 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 equipment120,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: 

  1. 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.
  2. Compute the total asset turnover rate assuming that total revenues in 2012 were $682,500. Round to the nearest hundredth, e.g. 3.33.
  3. Assume that Alleg’s primary competitor has an asset turnover of 2.12. What does this tell you about Alleg’s asset management?
    • 9 years ago
    • 10
    Answer(6)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      alleg_inc_bs_tutorial.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      classified_balance_sheets.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      boomer_sooner.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      fin_400_module_4_assignment_-_classified_balance_sheets.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      solutions_0.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      fin_400_module_4_assignment_-_classified_balance_sheets.xlsx