Using the Balance sheet, complete the formulas for the sheet below.

\begin{tabular}{|c|c|c|c|c|c|c|} \hline A & B & c & D & E & F & G \\ \hline Line Items & Year (t=0) & Year (t=1) & Year (t=2) & Year (t=3) & Year (t=4) & Year (t=5) \\ \hline Recommended: S\&P Capital IQ - Standard & 2022FY & 2021FY & 2020FY & 2019FY & 2018FY & 2017FY \\ \hline Period Ended & 12/31/2022 & 12/31/2021 & 12/31/2020 & 12/31/2019 & 12/31/2018 & 12/31/2017 \\ \hline Currency & USD & USD & USD & USD & USD & USD \\ \hline Units & Millions & Millions & Millions & Millions & Millions & Millions \\ \hline \multicolumn{7}{|l|}{ Current Assets } \\ \hline Cash and Cash Equivalents & 2,547.00 & 3,604.00 & 3,160.00 & 1,514.00 & 772 & 2,861.00 \\ \hline Receivables & 2,505.00 & 1,963.00 & 1,978.00 & 2,337.00 & 2,444.00 & 2,265.00 \\ \hline Contract Asset & 12,318.00 & 10,579.00 & 9,545.00 & 9,094.00 & 9,472.00 & 7,992.00 \\ \hline Inventories & 3,088.00 & 2,981.00 & 3,545.00 & 3,619.00 & 2,997.00 & 2,878.00 \\ \hline Other Current Assets & & 688 & 1,150.00 & 531 & 418 & 1,509.00 \\ \hline Total Current Assets & 20,991.00 & 19,815.00 & 19,378.00 & 17,095.00 & 16,103.00 & 17,505.00 \\ \hline \multicolumn{7}{|l|}{ Noncurrent Assets } \\ \hline Property, Plant and Equipment, Net & 7,975.00 & 7,597.00 & 7,213.00 & 6,591.00 & 6,124.00 & 5,775.00 \\ \hline Deferred Income Taxes & 3,744.00 & 2,290.00 & 3,475.00 & 3,319.00 & 3,208.00 & 3,156.00 \\ \hline Goodwill & 10,780.00 & 10,813.00 & 10,806.00 & 10,604.00 & 10,769.00 & 10,807.00 \\ \hline Intangible Assets & 2,459.00 & 2,706.00 & 3,012.00 & 3,213.00 & 3,494.00 & 3,797.00 \\ \hline Other Assets & 6,931.00 & 7,652.00 & 6,826.00 & 6,706.00 & 5,178.00 & 5,580.00 \\ \hline Total Assets & 52,880.00 & 50,873.00 & 50,710.00 & 47,528.00 & 44,876.00 & 46,620.00 \\ \hline \multicolumn{7}{|l|}{ Current Liabilities } \\ \hline Accounts Payable & 2,117.00 & 780 & 880 & 1,281.00 & 2,402.00 & 1,467.00 \\ \hline Salaries, Benefits, Payroll Taxes & 3,075.00 & 3,108.00 & 3,163.00 & 2,466.00 & 2,122.00 & 1,785.00 \\ \hline Current Portion of Long-term Debt & NA & NA & 500 & 1,250.00 & NA & NA \\ \hline Current Maturities of Long-term Debt and Commercial Paper & NA & NA & NA & NA & 1,500.00 & 750 \\ \hline Contract Liabilities & 8,488.00 & 8,107.00 & 7,545.00 & 7,054.00 & 6,491.00 & 7,028.00 \\ \hline Other Current Liabilities & & 2,002.00 & 1,845.00 & 1,921.00 & 1,883.00 & 1,883.00 \\ \hline Total Current Liabilities & 15,887.00 & 13,997.00 & 13,933.00 & 13,972.00 & 14,398.00 & 12,913.00 \\ \hline \multicolumn{7}{|l|}{ Noncurrent Liabilities } \\ \hline Long-term Debt & 15,429.00 & 11,670.00 & 11,669.00 & 11,404.00 & 12,604.00 & 13,513.00 \\ \hline Accrued Pension Liabilities & 5,472.00 & 8,319.00 & 12,874.00 & 13,234.00 & 11,410.00 & 15,703.00 \\ \hline Other Postretirement Benefit Liabilities & NA & NA & NA & NA & 704 & 719 \\ \hline Minority Interest & 0 & 0 & 23 & 44 & 55 & 74 \\ \hline Other Liabilities & 6,826.00 & 5,928.00 & 6,196.00 & 5,747.00 & 4,311.00 & 4,548.00 \\ \hline \multicolumn{7}{|l|}{ Shareholders' Equity } \\ \hline Common Stock - Par Value & 254 & 271 & 279 & 280 & 281 & 284 \\ \hline Additional Paid in Capital & 92 & 94 & 221 & NA & NA & NA \\ \hline Retained Earnings & 16,943.00 & 21,600.00 & 21,636.00 & 18,401.00 & 15,434.00 & 11,405.00 \\ \hline Accumulated Other Comprehensive Income (Loss) & 8,023.00 & 11,006.00 & 16,121.00 & 15,554.00 & 14,321.00 & 12,539.00 \\ \hline Total Shareholders Equity & 9,266.00 & 10,959.00 & 6,015.00 & 3,127.00 & 1,394.00 & -850 \\ \hline Total Liabilities \& Shareholders Equity & 52,880.00 & 50,873.00 & 50,710.00 & 47,528.00 & 44,876.00 & 46,620.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 27 & & Year (t=0) & Year (t=1) & Year (t=2) & Year (t=3) & Year (t=4) & Year (t=5) \\ \hline 28 & Accounts Receivable: & 2022 & 2021 & 2020 & 2019 & 2018 & 2017 \\ \hline 29 & \multicolumn{7}{|c|}{ Review Footnotes related to AR. Were there any changes? } \\ \hline \multicolumn{8}{|l|}{30} \\ \hline 31 & \begin{tabular}{l} AR Amounts Reported on Bal Sheet (Net of \\ Allowances) \end{tabular} & & & & & & \\ \hline 32 & Allowance Amounts & & & & & & \\ \hline 33 & Gross AR (AR + Allowances) & & & & & & \\ \hline 34 & \begin{tabular}{l} Allowance to Gross AR Ratio (i.e. what \\ percentage the firm thinks is uncollectible) = \\ Allowance Amt/Gross AR \end{tabular} & & & & & & \\ \hline \multicolumn{8}{|l|}{35} \\ \hline 36 & Bad Debt Expense & & & & & & \\ \hline 37 & Bad Debt to Sales Ratio & & & & & & \\ \hline 38 & \begin{tabular}{l} AR to Sales Ratio (note that it's the inverse of AR \\ turnover) \end{tabular} & & & & & & \\ \hline \multicolumn{8}{|l|}{39} \\ \hline 40 & Accounts Receivable Turnover & Y & & & & & \\ \hline 41 & DSO & & & & & & \\ \hline \multicolumn{8}{|l|}{42} \\ \hline 43 & Potential for Income Shifting? & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline A & B & c & D & E & F & G \\ \hline Line Items & Year (t=0) & Year (t=1) & Year (t=2) & Year (t=3) & Year (t=4) & Year (t=5) \\ \hline Recommended: S\&P Capital IQ - Standard & 2022FY & 2021FY & 2020FY & 2019FY & 2018FY & 2017FY \\ \hline Period Ended & 12/31/2022 & 12/31/2021 & 12/31/2020 & 12/31/2019 & 12/31/2018 & 12/31/2017 \\ \hline Currency & USD & USD & USD & USD & USD & USD \\ \hline Units & Millions & Millions & Millions & Millions & Millions & Millions \\ \hline \multicolumn{7}{|l|}{ Current Assets } \\ \hline Cash and Cash Equivalents & 2,547.00 & 3,604.00 & 3,160.00 & 1,514.00 & 772 & 2,861.00 \\ \hline Receivables & 2,505.00 & 1,963.00 & 1,978.00 & 2,337.00 & 2,444.00 & 2,265.00 \\ \hline Contract Asset & 12,318.00 & 10,579.00 & 9,545.00 & 9,094.00 & 9,472.00 & 7,992.00 \\ \hline Inventories & 3,088.00 & 2,981.00 & 3,545.00 & 3,619.00 & 2,997.00 & 2,878.00 \\ \hline Other Current Assets & & 688 & 1,150.00 & 531 & 418 & 1,509.00 \\ \hline Total Current Assets & 20,991.00 & 19,815.00 & 19,378.00 & 17,095.00 & 16,103.00 & 17,505.00 \\ \hline \multicolumn{7}{|l|}{ Noncurrent Assets } \\ \hline Property, Plant and Equipment, Net & 7,975.00 & 7,597.00 & 7,213.00 & 6,591.00 & 6,124.00 & 5,775.00 \\ \hline Deferred Income Taxes & 3,744.00 & 2,290.00 & 3,475.00 & 3,319.00 & 3,208.00 & 3,156.00 \\ \hline Goodwill & 10,780.00 & 10,813.00 & 10,806.00 & 10,604.00 & 10,769.00 & 10,807.00 \\ \hline Intangible Assets & 2,459.00 & 2,706.00 & 3,012.00 & 3,213.00 & 3,494.00 & 3,797.00 \\ \hline Other Assets & 6,931.00 & 7,652.00 & 6,826.00 & 6,706.00 & 5,178.00 & 5,580.00 \\ \hline Total Assets & 52,880.00 & 50,873.00 & 50,710.00 & 47,528.00 & 44,876.00 & 46,620.00 \\ \hline \multicolumn{7}{|l|}{ Current Liabilities } \\ \hline Accounts Payable & 2,117.00 & 780 & 880 & 1,281.00 & 2,402.00 & 1,467.00 \\ \hline Salaries, Benefits, Payroll Taxes & 3,075.00 & 3,108.00 & 3,163.00 & 2,466.00 & 2,122.00 & 1,785.00 \\ \hline Current Portion of Long-term Debt & NA & NA & 500 & 1,250.00 & NA & NA \\ \hline Current Maturities of Long-term Debt and Commercial Paper & NA & NA & NA & NA & 1,500.00 & 750 \\ \hline Contract Liabilities & 8,488.00 & 8,107.00 & 7,545.00 & 7,054.00 & 6,491.00 & 7,028.00 \\ \hline Other Current Liabilities & & 2,002.00 & 1,845.00 & 1,921.00 & 1,883.00 & 1,883.00 \\ \hline Total Current Liabilities & 15,887.00 & 13,997.00 & 13,933.00 & 13,972.00 & 14,398.00 & 12,913.00 \\ \hline \multicolumn{7}{|l|}{ Noncurrent Liabilities } \\ \hline Long-term Debt & 15,429.00 & 11,670.00 & 11,669.00 & 11,404.00 & 12,604.00 & 13,513.00 \\ \hline Accrued Pension Liabilities & 5,472.00 & 8,319.00 & 12,874.00 & 13,234.00 & 11,410.00 & 15,703.00 \\ \hline Other Postretirement Benefit Liabilities & NA & NA & NA & NA & 704 & 719 \\ \hline Minority Interest & 0 & 0 & 23 & 44 & 55 & 74 \\ \hline Other Liabilities & 6,826.00 & 5,928.00 & 6,196.00 & 5,747.00 & 4,311.00 & 4,548.00 \\ \hline \multicolumn{7}{|l|}{ Shareholders' Equity } \\ \hline Common Stock - Par Value & 254 & 271 & 279 & 280 & 281 & 284 \\ \hline Additional Paid in Capital & 92 & 94 & 221 & NA & NA & NA \\ \hline Retained Earnings & 16,943.00 & 21,600.00 & 21,636.00 & 18,401.00 & 15,434.00 & 11,405.00 \\ \hline Accumulated Other Comprehensive Income (Loss) & 8,023.00 & 11,006.00 & 16,121.00 & 15,554.00 & 14,321.00 & 12,539.00 \\ \hline Total Shareholders Equity & 9,266.00 & 10,959.00 & 6,015.00 & 3,127.00 & 1,394.00 & -850 \\ \hline Total Liabilities \& Shareholders Equity & 52,880.00 & 50,873.00 & 50,710.00 & 47,528.00 & 44,876.00 & 46,620.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 27 & & Year (t=0) & Year (t=1) & Year (t=2) & Year (t=3) & Year (t=4) & Year (t=5) \\ \hline 28 & Accounts Receivable: & 2022 & 2021 & 2020 & 2019 & 2018 & 2017 \\ \hline 29 & \multicolumn{7}{|c|}{ Review Footnotes related to AR. Were there any changes? } \\ \hline \multicolumn{8}{|l|}{30} \\ \hline 31 & \begin{tabular}{l} AR Amounts Reported on Bal Sheet (Net of \\ Allowances) \end{tabular} & & & & & & \\ \hline 32 & Allowance Amounts & & & & & & \\ \hline 33 & Gross AR (AR + Allowances) & & & & & & \\ \hline 34 & \begin{tabular}{l} Allowance to Gross AR Ratio (i.e. what \\ percentage the firm thinks is uncollectible) = \\ Allowance Amt/Gross AR \end{tabular} & & & & & & \\ \hline \multicolumn{8}{|l|}{35} \\ \hline 36 & Bad Debt Expense & & & & & & \\ \hline 37 & Bad Debt to Sales Ratio & & & & & & \\ \hline 38 & \begin{tabular}{l} AR to Sales Ratio (note that it's the inverse of AR \\ turnover) \end{tabular} & & & & & & \\ \hline \multicolumn{8}{|l|}{39} \\ \hline 40 & Accounts Receivable Turnover & Y & & & & & \\ \hline 41 & DSO & & & & & & \\ \hline \multicolumn{8}{|l|}{42} \\ \hline 43 & Potential for Income Shifting? & & & & & & \\ \hline \end{tabular}