Create a horizontal financial statement analysis of the data for the past 5 years.

Horizontal Financial Statement Analysis Horizontal analysis compares a component of the company's financial statement against the same component over time. Typically, company performance is compared on a year-over-year basis using either percentage change or dollar change (or both). For example, if a company's sales in 2020 were $100M and in 2021 were $110M horizontal analysis would indicate that the company's sales grew by $10M or 10%. A B E F G 1 Revenue Total revenue $226,954$195,929$166,761$152,703$141,576 OPERATING EXPENSES Merchandise costs 7 Selling, general and administrative 8 Operating income 9 OTHER INCOME (EXPENSE) 10 interest expense 11 Interest income and other, net 12 INCOME BEFORE INCOME TAXES 13 Provision for income taxes 14 Net income induding noncontrolling interests 15 Net income attributable to noncontrolling interests 16 NET INCOME ATIRIBUTABLE TO COSTCO 17 TET INCOME PER COMMON SHARE ATTRIBUTABLE TO COSTCO: 199,38219,7797,793(158)2057,8401,9255,915(71)$5,844170,68418,5376,708(171)1436,6801,6015,079(72)$5,007144,93916,3875,435(160)925,3671,3084,059(57)$4,002132,88614,994864,737(150)1784,7651,0613,704(45)$3,659123,15213,876684,480(159)1214,4421,2633,179(45)$3,134 18 Basic (in dollars per share) 19 Diluted (in dollars per share) 20 Shares used in calculation (000/s) 21 Basic (shares) 22 Diluted (shares) 23 Net sales 24 REVENUE 25 Total revenue 26 Membership tees $222,730$192,052$163,220$149,351$138,434 27 REVENUE 28 Total revenue 3029 $4,224$3,877$3,541$3,352$3,142