1. perform Vertical Analysis on each line item of the Income Statement in Google Sheets or Excel. 1. Please use the Google Sheet document that contains the financial statements of all 5 companies. 2. You are required to show your calculations. Recommended to use formulas in the cells. Consolidated Statements Of Earnings - USD ($) shares in Thousands, $ in Thousands SALES AND OPERATING REVENUES: NET SALES AND OPERATING REVENUES TOTAL COST OF SALES GROSS PROFIT CARMAX AUTO FINANCE INCOME S Less: Selling, General and Administrative Expense 5 Depreciation, Depletion and Amortization, Nonproduction 5 Interest expense 7 Nonoperating Income (Expense) Income (Loss) from Continuing Operations before Equity Method Investments, Income Taxes, 8 Noncontrolling Interest 9 Income tax provision 0 Net earnings 1 2 23 12 Months Ended Feb. 28, 2023 Feb. 28, 2022 $ 29,684,873 26,884,670 2,800,203 663,404 2,487,357 $31,900,412 28,612,870 3,287,542 801,507 2,325,220 228,449 120,398 (9,401) 636,804 152,042 $ 484,762 211,956 94,095 (34,568) 1,492,346 341,049 $ 1,151,297