can someone help me make a vertical analysis of Lowes on excel using the 2019 annual report balance statement?

Lenel Companies. Inc Consolidated Blue (le millions de pare Juary 31, 2020 February 2009 Carral Cash and cah equivalents 7165 ILI SHI 318 12.561 95 10 1412 1 Total current Property less commune depreciation 3.81 236 Latomie Deferred income Geodwill 10 30 995 4.30 1.941 1110 Sot 1.219 . ISINI 14497 3.983 SH 72 Liabilities and shareholders' equity Current liabilit Sherem borrowing Current maturities of longtem debet Current penting Accounts payable Accrual competice and employee benefits Deferral Other current Total current les Long tom deltexcluding current maurities Nesent operating low liter Deferred velended protection plans Cheries Total abilities Come and concis Shareholdery Preferred stick 55 per valued Coneck sa 50 per value January 31, 2020 February 1, 2019 Capital in de Retained coming Accumulate other companies Total sharbadensity Total abilities and shareholders' equilla Ear areap dilatat financial statraman 30.54 763 NO! 351 (15) 1H 34.50 3.45 Lunel Companies, Inc. Consolidated States of Shadesquity (In million copper dare data) Acante Cempre har Manex February 2017 14 Other companiei Cadded 1.38 334) Lowe's Companies, Inc. Consolidated Balance Sheets (In millions, except par value) January 31, 2020 February 1, 2019 S 511 716 S 160 13,179 1,263 15,318 18,669 3,891 372 216 218 12.561 938 14.228 18.432 303 256 294 303 995 34,508 702 39,471 S 722 1.110 Assets Current assets: Cash and cash equivalents Short-term investments Merchandise inventory - net Other current assets Total current assets Property, less accumulated depreciation Operating lease right-of-use assets Long-term investments Deferred income taxes.net Goodwill Other assets Total assets Liabilities and shareholders' equity Current liabilities: Short-term borrowings Current maturities of long-term debt Current operating lease liabilities Accounts payable Accrued compensation and employee benefits Deferred revenue Other current liabilities Total current liabilities Long-term debt, excluding current maturities Noncurrent operating Icase liabilities Deferred revenue - Extended protection plans Other liabilities Total liabilities Commitments and contingencies Shareholders' equity: Preferred stock - 55 par value, none issued Common stock - So.50 par value; Shares issued and outstanding January 31, 2020 February 1, 2019 Capital in excess of par value Retained camings Accumulated other comprehensive loss Total shareholders' equity Total liabilities and shareholders' equity See accompanying notes to consolidated financial statements. 1.941 S 597 501 7.659 684 1,219 2,581 15,182 16,768 3,943 8.279 662 1.299 2.425 14,497 14.391 894 712 37,499 827 1.149 30.864 763 801 381 401 1,727 (136) 1,972 39,471 S 3.452 (209) 3,644 34.508