Analyzing Asset Ratios

Analyzing Assets Radios

Company : Amazon

The purpose of this assignment 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.

1. Receivables turnover
2. Average collection period
3. Inventory turnover
4. Average days in inventory
5. 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.

1. 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.
2. 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 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.
3. 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.
4. 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 to your instructor.

APA style is required for the body of this assignment, solid academic writing is   expected, and documentation of sources should be presented using APA formatting guidelines

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful