Please show excel formulas! Will upvote!

\begin{tabular}{|c|c|c|c|c|c|c|} \hline \begin{tabular}{l} XYz company BaLANCF SHEt \\ Fiscal year ends in December. USD in millions. \end{tabular} & 202212 & 202112 & 202012 & 201912 & 201812 & 201712 \\ \hline \multirow{2}{*}{\multicolumn{7}{|c|}{\begin{tabular}{l} Fiscal year ends in December. USD in millions. \\ Ausets \end{tabular}}} \\ \hline \multirow{2}{*}{\multicolumn{6}{|c|}{\begin{tabular}{l} Assets \\ Current assets \end{tabular}}} & \\ \hline & 9,739 & 6,568 & 5,3,37 & 4,233 & 4,469 & 3,490 \\ \hline \begin{tabular}{l} Cach and cach equivaleits \\ Receivables \end{tabular} & 1,701 & 1,414 & 1,074 & 1,207 & 1,278 & 1,267 \\ \hline \begin{tabular}{l} Receivables \\ Inventories \end{tabular} & 1,910 & 1,955 & 2,001 & 2,217 & 1,557 & 1,790 \\ \hline \begin{tabular}{l} Inventories \\ ofter current zosest \end{tabular} & 335 & 302 & 299 & 440 & 1,030 & 910 \\ \hline \begin{tabular}{l} Other current atsets \\ Total current asents \end{tabular} & 13,585 & 10,239 & 8,761 & 8,097 & 8,734 & 7,457 \\ \hline \multirow{2}{*}{\multicolumn{7}{|c|}{\begin{tabular}{l} Total current assets \\ Non-current ansets \end{tabular}}} \\ \hline & 7,858 & 5,781 & 5,240 & 5,425 & 4,789 & 4,923 \\ \hline \begin{tabular}{l} Gross property, plant and equipenent \\ Necumulated Depreciation \end{tabular} & (2717) & (2512) & (2,437) & (2.242) & (2,225) & (2.411) \\ \hline \begin{tabular}{l} Necumulated Depreciation \\ Goodwill \end{tabular} & 4,362 & 4,362 & 4,352 & 4.362 & 4,362 & 4,362 \\ \hline \begin{tabular}{l} Goodwill \\ Ceher intancible xuts \end{tabular} & 348 & 61 & cos & 717 & 1,056 & 1,316 \\ \hline \begin{tabular}{l} Other intarpible xuts \\ Other lone term assets \end{tabular} & 1,140 & & 926 & m & 826 & 784 \\ \hline \begin{tabular}{l} Other lone term assets \\ Total non-current assets \end{tabular} & 10,991 & 9,112 & 9.257 & 9,040 & 8,908 & 8,974 \\ \hline \begin{tabular}{l} Total non-current assets \\ Total assets \end{tabular} & 24,676 & 19,351 & 18,018 & 17,137 & 17,642 & 16,431 \\ \hline Total ascets & & & & & & \\ \hline \multicolumn{7}{|l|}{ Uabilities } \\ \hline \multicolumn{7}{|l|}{ Corrent liabilities } \\ \hline Short term debt & 500 & sso & 500 & 249 & 500 & 631 \\ \hline Nceounts pingble and other accruals & 1,428 & 2,182 & 2,102 & 1,001 & 1,036 & 923 \\ \hline Other current liabilities & 641 & 658 & $21 & 724 & 722 & 710 \\ \hline Total current liabilities & 2,569 & 2,390 & 2,123 & 2,474 & 2,258 & 2,264 \\ \hline \multicolumn{7}{|l|}{ Noncurrent liabilities } \\ \hline Loreterm debt & 7,242 & 6,248 & 5,903 & 4,319 & 3,57 & 2,978 \\ \hline Deferred taxes liabilities & s) & 90 & 7t & 42 & 78 & 33. \\ \hline Other loneterm liabilities & 2,446 & 1,436 & 1,507 & 1,308 & 1,392 & 683 \\ \hline Totail non-current liabilities & 8,774 & 7,774 & 6,943 & 5,669 & 5,047 & 3,694 \\ \hline \multirow[t]{2}{*}{ Total liabilities } & 11,343 & 10,164 & 9,111 & 8,143 & 7,305 & 5,95t \\ \hline & & & & & & \\ \hline \multicolumn{7}{|l|}{ Stockholders' +quity } \\ \hline Commen stock & 1,741 & 1,741 & 1,741 & 1,741 & 1.741 & 1,741 \\ \hline Additional Paid in Capital & 2,630 & 2,333 & 2,110 & 1,950 & 1,776 & 1,674 \\ \hline Retained earning: & 45,919 & 42,051 & 39,898 & 32,906 & 34,662 & 33,107 \\ \hline Treasury stock: & (36,860) & (36,578) & (34,495) & (32,130) & (27,453) & (25,523) \\ \hline Aceumulated other comprahenzive income & (15) & (960) & (347) & (473) & (384) & (526) \\ \hline Total stockholder's equity & 13,333 & 5,187 & 8,907 & 8,994 & 10,397 & 10,473 \\ \hline Total liabilities and stockholders equity & 24,676 & 19,351 & 18,018 & 17,137 & 17,642 & 16,431 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline & & & F & & & \\ \hline \multirow{2}{*}{\begin{tabular}{l} XYZ company INCOME STATENENT \\ Fiscal pear ends in December. USO in millions. \end{tabular}} & & & & & & \\ \hline & 202212 & 2021-12 & 202012 & 201912 & 201812 & 2017.12 \\ \hline & & & & & 14,961 & 13,370 \\ \hline \begin{tabular}{l} Revenue (Sailes) \\ Cost of revenue (Cost of poods sold) \end{tabular} & \begin{tabular}{r} 18,344 \\ 5,968 \end{tabular} & \begin{tabular}{r} 14,461 \\ 5,192 \end{tabular} & \begin{tabular}{r} 14,383 \\ 5,219 \end{tabular} & \begin{tabular}{r} 15,184 \\ 5,507 \end{tabular} & 5,347 & 5,130 \\ \hline & \begin{tabular}{r} 5,968 \\ 12,376 \end{tabular} & 9,269 & 9,164 & 10,277 & 9,614 & 8,240 \\ \hline Operating oxpenses & 2,319 & 2,070K & 2,216 & 2,876 & 3,217 & 2,636 \\ \hline EBITA & 10,057 & 7,199 & 6,948 & 7,401 & .6,397 & 5,604 \\ \hline Deprec and amort & 954r & 592 & 1,050 & 790 & 939 & 605 \\ \hline Operating income (EBM) & 9,103 & 6,207 & 5,898 & 6,611 & 5,458 & 4,999 \\ \hline interest Expense & 184 & 190 & 170 & 125 & 78 & 69 \\ \hline Taxable income & 8,919 & 6,017 & 5,728 & 6,436 & 5,380 & 4,930 \\ \hline income tax expense & 1,150 & 422 & 711 & 906 & 1.698 & 1,335 \\ \hline Net income & 7,769 & 5,595 & 5,017 & 5,580 & 3,682 & 1,595 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline A & B & c & o & E & s. & G & H & & \\ \hline \begin{tabular}{l} Xrz Compary \\ rohoo Inince data \\ 12/31/22 (vear end) \end{tabular} & & & & & Date & \begin{tabular}{l} Quarterly \\ Dividends \end{tabular} & \begin{tabular}{l} Annual \\ Dividends \end{tabular} & \begin{tabular}{l} Annual Growth \\ Bartes \end{tabular} & \begin{tabular}{l} Averse \\ Growh Rate \end{tabular} \\ \hline & & & & & 10/28/22 & 1.15 & & & \\ \hline \begin{tabular}{l} Current stock price \\ Mtrket Cap (Value) \end{tabular} & & & & & 07/22/22 & 1.02 & & & \\ \hline \begin{tabular}{l} Current stock price \\ Murket Cap (Value) \\ Beta \end{tabular} & & \begin{tabular}{ll} 5 & 188.47 \end{tabular} & & & 04/29/22 & 1.02 & & & \\ \hline \begin{tabular}{l} Mtrket Cap (Value) \\ Beta \\ PEraxio \end{tabular} & & \$ 176.41 & billion & & 01/28/22 & 1.02 & & & \\ \hline \begin{tabular}{l} Beta \\ PERaxio \\ EPS \end{tabular} & & 1.35 & & & 10/29/21 & 1.02 & & & \\ \hline ESS & & \begin{tabular}{r} 22.82 \\ 8.26 \end{tabular} & & & 07/23/21 & 0.90 & & & \\ \hline Mnnua dividend & & \begin{tabular}{l} 8.26 \\ 4.21 \end{tabular} & & & 04/30/21 & 0.90 & & & \\ \hline flof shares outstanding & & /5 \begin{tabular}{r} 4.21 \\ 976.000 \end{tabular} & & & 01/29/21 & 0.90 & & & \\ \hline & & 976.000 & miltion & & 10/29/20 & 0.90 & & & \\ \hline & & & & & 07/30/20 & 0,77 & & & \\ \hline currentprice & 188.47 & & & & 05/01/20 & 0.77 & & & \\ \hline outstanding shares & 936,000,000 & & & & 01/30/20 & 0.77 & & & \\ \hline market value & S 176,407,920,000 & & & & 10/30/19 & 0.7 & & & \\ \hline & or & & & & 07/30/19 & 0.62 & & & \\ \hline 7 & 176.41 & billion & & & 05/01/19 & 0.62 & & & \\ \hline 8 & & & & & 10/30/1901/30/19 & 0.62 & & & \\ \hline 3 & & & & & \begin{tabular}{l} 10/30/13 \\ 07/30/18 \end{tabular} & 0.62 & & & \\ \hline 0 & & & & & \begin{tabular}{l} 07/30/18 \\ 05/04/18 \end{tabular} & 0.50 & & & \\ \hline 1 & & 2 & & & \begin{tabular}{l} 05/04/18 \\ 01/30/18 \end{tabular} & 0.50 & & & \\ \hline 2 & & & & & 10/30/2701/30/18 & 0.50 & & & \\ \hline & & & & & \begin{tabular}{l} 10/30/17 \\ 07/27/17 \end{tabular} & =050 & & & \\ \hline 4 & & & & & \begin{tabular}{l} 07/27/17 \\ 04/27/17 \end{tabular} & 0.33 & & & \\ \hline 8 & & . & & & \begin{tabular}{l} 04/27/17 \\ 01/27/17 \end{tabular} & 0.38 & & & \\ \hline & & & & & 11/03/1601/27/17 & 0.311 & & & \\ \hliney & & & & & \begin{tabular}{l} 11/03/16 \\ 07/21/16 \end{tabular} & 0.38 & & & \\ \hline as & & & & & \begin{tabular}{l} 07/21/16 \\ 04/28/16 \end{tabular} & 0.34 & & & \\ \hline 10 & & & & & \begin{tabular}{l} 04/28/16 \\ 01/2B/16 \end{tabular} & 0.34 & & & \\ \hline & & & & & 01/2m/a & 0.14 & & & \\ \hline \end{tabular} Instructions Anower Schedule Financials Data Bond Sched Readv Sifccessibllity Gogd to go XYZ outstanding bonds as of 12/31/22 Face amounts are in millions. \begin{tabular}{|c|c|c|c|c|c|} \hline Name & Maturity & \begin{tabular}{r} Face \\ Amount \\ $( Mii) \end{tabular} & \begin{tabular}{r} Current \\ Price \end{tabular} & Coupon \% & \begin{tabular}{l} Yield to \\ Maturity % \end{tabular} \\ \hline Senior Notes & 05/15/23 & 500.00 & 100.05 & 1.850N & 10921% \\ \hline Senior Noses & 05/01/24 & 500.00 & 10050 & 2.250% & \\ \hline Seplor Notes & 05/15/25 & 300.00 & 101.00 & 2.625s & 21055% \\ \hline Secior Notes & 03/12/26 & 25000 & 9730 & 13734 & 22547% \\ \hline Seribor Notes & 05/31/27 & 500.00 & 2500 & 1125x & 23226% \\ \hline Eeniar Nolis & 11/03/28 & 500.00 & 10055 & 2900x & 27960% \\ \hline Senior Nobles & 08/04/70 & 75000 & 0560 & 2.2505 & 2.0931s \\ \hline Seniber Notet & 05/04/31 & 750.00 & 8140 & 1.750% & 2 rieas \\ \hline Seckor Noties & 06/30/32 & 500,00 & 50.5 & 1 sook & 3.00205 \\ \hline Seniar Notes & 03/15/40 & 750.00 & 105:0 & 3.875% & 3 Areas \\ \hline Senior Notes & 05/15/49 & 1,50000 & 10475 & 4.15006 & 3a6118 \\ \hline Senior Nolts & 07/31/52 & 50000 & & 2.700s & 30705x \\ \hline \multirow[t]{4}{*}{ Totals } & & 7,800.00 & & & \\ \hline & & or & & & \\ \hline & & 7.800 & & & \\ \hline & & billion & & & 4 \\ \hline \end{tabular} \begin{tabular}{|l|} \hline or \\ billion \\ Mer-tax Cost of Debt \\ Mdiustment for tax rate \\ After tax Cont of Debt \\ \hline \end{tabular} instructions Antwer Schodilo Financials Datil Bondsched