Excel: Prepare Balance Sheet with total asset turnover rate and Asset Management analysis

/in /by

In today’s fast-paced academic environment, students often find themselves juggling multiple responsibilities, from attending classes and working part-time jobs to participating in extracurricular activities. The demands of modern education can be overwhelming, leaving students in search of effective solutions to manage their academic workload efficiently. One such solution is the use of Nursingpapertutors.com academic writing website. Nursingpapertutors.com academic writing website employ a cadre of experienced and knowledgeable writers who are well-versed in various academic subjects and writing styles. Nursingpapertutors.com professionals bring a wealth of expertise to the table, enabling them to produce well-researched and well-structured papers that meet the academic standards and expectations of students. Their familiarity with diverse subjects ensures that students can receive assistance across a wide spectrum of disciplines, from mathematics to literature, and from nursing to engineering.

 

The 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: 

  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 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.

 

One of the significant challenges students face is time management. The demands of coursework, assignments, and exams can create immense pressure, leading to stress and a potential drop in academic performance. Nursingpapertutors.com academic writing website can be a valuable resource for students seeking to balance their responsibilities effectively. By outsourcing some of their academic tasks, students can free up time to focus on studying, participating in meaningful extracurricular activities, or even addressing personal obligations. This improved time management can alleviate the stress associated with academic overload. The ultimate goal of education is to enhance one’s knowledge and skills. Nursingpapertutors.com academic writing websites can play a vital role in achieving this goal by providing students with well-crafted papers that serve as models for their own work. These papers can offer valuable insights into effective research, organization, and writing, thereby empowering students to improve their academic performance over time.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.