Can I get the steps on how to do the horizontal and vertical analysis on this excel fill out.

Horizontal Analysis (Y3/Y2) Vertical Analysis Y3 Vertical Analysis Y2 Y3 Y2 24,837,000 15,152,000 9,685,000 8,131,000 544,000 25,778,000 15,621,000 10,157,000 8,265,000 Y1 27,079,000 16,496,000 10,583,000 8,256,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 479,000 288,000 0 186,000 105,000 98,000 0 0 0 0 0 0 0 0 0 Report Date Net sales Cost of sales Gross margin (loss) Selling, general & administrative expenses Gains on sale of real estate Impairments, store closing costs & division consolidation costs Restructuring, impairment, store closing and other costs Settlement charges Gain on sale of properties, impairments, store closing costs & & Operating income (loss) Interest on debt Amortization of debt premium Amortization of financing costs & debt discount Interest on capitalized leases Interest expense, gross Less interest capitalized on construction Interest expense Net premiums on early retirement of debt Interest income Income (loss) before income taxes Current income tax expense - federal Deferred income tax expense (benefit) - federal Total income tax expense (benefit) - federal Current income tax expense - state & local Deferred income tax expense (benefit) - state & local Total income tax expense (benefit) - state & local Federal, state & local income tax expense (benefit) Net income (loss) Net income attributable to non-controlling interest Net income attributable to Macy's, Inc. shareholders 1,315,000 392,000 (22,000) 5,000 2.000 377,000 10,000 367,000 2,039,000 393,000 (21,000) 6,000 2,000 380,000 17,000 363,000 0 0 0 0 1,807,000 332,000 (9,000) 7,000 2,000 332,000 11,000 321,000 10,000 11,000 1,507,000 367,000 (452,000) (85,000) 16,000 40,000 56,000 (29,000) 1,536,000 11,000 1,547,000 2,000 1,678,000 536,000 4,000 952,000 433,000 (125,000) 308,000 37,000 (4,000) 33,000 341,000 611,000 8,000 619,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 536,000 72,000 72,000 608,000 1,070,000 2,000 1,072,000 0 0