The purpose of this is to analyze asset ratios to make recommendations for generating revenue and increasing company profitability through asset utilization.

Assume that the chief financial officer (CFO) has asked you to analyze the use of company assets and make recommendations for revenue generation and increasing profitability. The CFO has requested you summarize your findings in a 250-500 word memo addressed to the CFO, but one that could be shared with other stakeholders.

In the Form 10-K for the company you selected in the Topic 1 assignment, review and study the assets as reported for the past 3 years. Using the correct formulas and a separate tab for each analysis, calculate the following ratios using Excel.

Receivables turnover

Average collection period

Inventory turnover

Average days in inventory

Asset turnover

Using the results of your ratio calculations, provide recommendations about how to improve one of these assets: receivables, inventory, or property, plant, and equipment for the company, as a means of generating revenue and increasing profitability. Include discussion and explanation of the following within the memo.

Summarize how well the company is collecting on its receivables based upon the type(s) of products the company sells and the industry in which it competes. Justify your speculation by using supporting facts from the income statement, balance sheet, or other resources.

Summarize how effective the company is in managing inventory based upon the type(s) of products the company sells and the industry in which it competes. Include a discussion about whether the inventory turnover ratio is increasing or decreasing, what is causing the ratio increase/decrease, and whether the total value of inventory is increasing or decreasing on the balance sheet.

Summarize how well the company is utilizing its assets to generate net income. Justify your assessment with examples of other ratios and values on the income statement and balance sheet.

Make a recommendation to improve one of these assets: receivables, inventory, or property, plant, and equipment. Use information from the ratio calculations, income statement, balance sheet, or other resources to justify your recommendation and explain how accepting the recommendation will generate revenue and increase company profitability.

Submit the Excel file that contains your ratios and the Word file memo.

Financial Accounting