Instructions are below

Question Description

Using Excel, prepare a horizontal and a vertical analysis of the income statement for Amazon for the year ended December 31, 2018. You should actually use the same excel file that you created for the balance sheet tools last week. (I have attached the completed Horizontal and Vertical BS and added the information that need to be used for the Horizontal and Vertical IS) There is no need to download this data again. Identify three areas from the Vertical analysis and three areas from the Horizontal analysis that you think are worthy of additional analysis. You can indicate these directly in the Excel spreadsheet. You don’t have to complete an analysis of these items, just note why you think they need additional analysis. Also, make sure to format your Excel tools in a professional way that should help with your analysis and in presenting your tools to another person or group of people. Please see the videos that follow this assignment tab for help in preparing these tools.

Using the instruction that follow, prepare ratio calculations using the Google Sheets http://tinyurl.com/xbrlratios tool. Your ratios should include Amazon as the main company, and you should select two new companies (other than Walmart and Kroger from the videos) as your comparable companies. You will need to share the link to your Google Sheet (as noted in the video) to the assignment tab as your submission for the ratios. Indicate three items that you think are worthy of additional analysis as a result of these calculations. You can include these in the Google Spreadsheet.

I have also attached PowerPoint slides for instructions on the ratio part and an income statement powerpoint.

Please follow directions on the IS and ratio calculations!



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.