I need help with creating the excel portion of this assigment. I don't know how to do
Question:
I need help with creating the excel portion of this assigment. I don't know how to do excel at all. The numbers will be based off of Amazon's financial statement.
where is the information below found in the 10-k form and how do I add it into excel to calculate 1-5 in excel?
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 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 to your instructor.
While APA is not required for the body of this assignment, solid academic writing isexpected, and documentation of sources should be presented using APA guidelines, which can be found in the APA Guide, located in the Student Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit the Word document for this assignment to LopesWrite.