PREPARE common-sized financial statements for the same company from Part 1A for the most recent year and prior two (2) years [There will be three (3) years in total]. Common-sized financial statements include both VERTICAL and HORIZONTAL analysis. In addition COMPLETE the ratio analysis (see template provided) for the same company for the same three (3) year period. The EXAMPLE provided is a sample of what a finished product should look like. It is up to you to create an EXCEL document that is CLEAR, WELL FORMATTED, EASY to read, and includes the VERTICAL, HORIZONTAL, AND RATIO analysis (3 TABS MAX) for your company for the current year and two prior years.

This is for Amazon (NASDAQ)

Annual Data Millions of US $ except per share data 2021-12-31 2020-12-31 2019-12-31 . irl $469,822 $272,344 $197,478 $56,052 $116,485 S-62 . Revenue Cost Of Goods Sold Gross Profit Research And Development Expenses SG&A Expenses Other Operating Income Or Expenses Operating Expenses Operating Income Total Non-Operating Income/Expense Pre-Tax Income Income Taxes Income After Taxes Other Income Income From Continuous Operations Income From Discontinued Operations Net Income EBITDA EBIT Basic Shares Outstanding Shares Outstanding Basic EPS EPS- Earnings Per Share $386,064 $233,307 $152,757 $42,740 $87,193 $75 $363,165 $22,899 $1,279 $24,178 $2,863 $21,315 $280,522 $165,536 $114,986 $35,931 564,313 S-201 $265,981 $14,541 S-565 $13,976 $2,374 $11,602 $444,943 EEEEE $24,879 $13,272 $38,151 $4,791 $33,360 lil $33,364 $21,331 $11,588 $33,364 $59,175 $24,879 506 515 $21,331 $48,150 $22,899 500 510 $42.64 $11,588 $36,330 $14,541 494 504 $65.96 $23.46 11 $64.81 $41.83 $23.01 Balance Sheet HORIZONTAL ANALYSIS VERTICAL ANALYSIS Prior Year 1 (CY-PY1)/PY1 (PY!-PY2)/PY2 Period Ending Current Year Prior Year 2 Current Year Prior Year 2 Prior Year 1 Dollars (000's Omitted) Income Statement HORIZONTAL ANALYSIS VERTICAL ANALYSIS Prior Year 1 (CY-PY1)/PY1 (PY!-PY2)/PY2 Current Year Prior Year 2