I need the Formuals needed to find the vertical analysis as well as the Horizontal Analysis. Not just the number, i need the formulas for each cell to find the number thanks.

FY 2019 Vertical Analysis FY 2020 Vertical Analysis Horizontal Analysis 12/28/2019 FY2020 12/26/2020 FY2020 Dollar Change Percentage change 13,123.00 4,194.00 8,929.00 7,659.00 7,659.00 0 8,744.00 840 6,225.00 1,679.00 0 1, 713.00 280 C 22 4 In Millions of USD except Per Share 5 12 Months Ending 6 Total Assets 7 + Cash, Cash Equivalents & STI 8 + Cash & Cash Equivalents 9 +ST Investments 10 + Accounts & Notes Receiv 11 + Accounts Receivable, Net 12 +Notes Receivable, Net 13 + Inventories 14! + Raw Materials 15 + Work In Process 16 + Finished Goods 17 + Other Inventory 18 +Other ST Assets 19 + Derivative & Hedging Assets 20 + Assets Held-for-Sale 21 + Deferred Tax Assets + Misc ST Assets 23 Total Current Assets 24 + Property, Plant & Equip, Net 25 + Property, Plant & Equip 26 - Accumulated Depreciation 27 +LT Investments & Receivables 28 +LT Investments 29 +LT Marketable Securities 30 +LT Receivables 31 + Other LT Assets 32 + Total Intangible Assets 33 + Goodwill 34 + Other Intangible Assets 35 + Prepaid Expense 36 + Deferred Tax Assets 37 + Derivative & Hedging Assets 38 + Prepaid Pension Costs 39 + Investments in Affiliates 401 + Misc LT Assets 41 Total Noncurrent Assets 23,895.00 5,865.00 18,030.00 6,782.00 6,782.00 0 8,427.00 908 6,007.00 1,512.00 0 8,145.00 692 5,400.00 1,232.00 821 47,249.00 57,188.00 134,833.00 77,645.00 7,483.00 2,174.00 5,152.00 157 41,171.00 35,997.00 26,971.00 9,026.00 1,502.00 1,232.00 1,550.00 1,209.00 224 31, 239.00 56,014.00 129,335.00 73,321.00 7,760.00 3,239.00 3,967.00 554 41,511.00 37,103.00 26,276.00 10,827.00 1,641.00 1,209.00 706 - 37 18 815 872 105,842.00 105, 285.00 A B C D E F G 105,285.00 136,524.00 105,842.00 153,091.00 + 18,152.00 4,128.00 0 21, 267.00 5,581.00 8 OO 0 14,024.00 3,868.00 0 15,686.00 2,677.00 0 175 173 0 175 173 3,693.00 290 2,504.00 810 + 0 0 290 810 59 O 0 41 Total Noncurrent Assets 42 Total Assets 43 44 Liabilities & Shareholders' Equity 45 + Payables & Accruals 46 + Accounts Payable 47 + Accrued Taxes 48 +Interest & Dividends Payable 49 + Other Payables & Accruals 50 + ST Debt 51 +ST Borrowings 52 +ST Lease Liabilities 53 +ST Finance Leases 54 +ST Operating Leases 55 + Current Portion of LT Debt 56 +Other ST Liabilities 57 + Deferred Revenue 58 + Derivatives & Hedging + Misc ST Liabilities 60 Total Current Liabilities 61 +LT Debt 62 +LT Borrowings 63 +LT Lease Liabilities 64 +LT Finance Leases 65 +LT Operating Leases 66 +Other LT Liabilities 67 + Accrued Liabilities 68 + Pension Liabilities 69 + Deferred Revenue 70 + Deferred Tax Liabilities 71 + Derivatives & Hedging 72 + Misc LT Liabilities 73 Total Noncurrent Liabilities 74 Total Liabilities 75 + Preferred Equity and Hybrid Capital 76 + Share Capital & APIC 77 + Common Stock 78 + Additional Paid in Capital 22,310.00 25,683.00 25,308.00 375 24,754.00 34,251.00 33,897.00 354 0 375 10,872.00 0 4,284.00 1,368.00 2,044.00 13 3,163.00 36,555.00 58,865.00 0 25, 261.00 4.3 25, 256.70 354 13,048.00 0 4,929.00 1,367.00 3,843.00 5 2,904.00 47,299.00 72,053.00 0 25,556.00 4.1 25,551.90 0 0 + 4,284.00 1,368.00 2,044.00 13 3,163.00 36,555.00 58,865.00 0 67 + Accrued Liabilities 68 + Pension Liabilities 69 + Deferred Revenue 70 + Deferred Tax Liabilities 71 + Derivatives & Hedging 72 + Misc LT Liabilities 73 Total Noncurrent Liabilities 74 Total Liabilities 75 + Preferred Equity and Hybrid Capital 76 + Share Capital & APIC 77 + Common Stock 78 + Additional Paid in Capital 79 - Treasury Stock 80 + Retained Earnings 81 + Other Equity 82 Equity Before Minority Interest 83 + Minority/Non Controlling Interest 84 Total Equity 85 Total Liabilities & Equity 25,261.00 4.3 4,929.00 1,367.00 3,843.00 5 2,904.00 47,299.00 72,053.00 0 25,556.00 4.1 25,551.90 0 56,233.00 -751 81,038.00 0 81,038.00 153,091.00 25,256.70 0 53,523.00 -1,125.00 77,659.00 0 77,659.00 136,524.00