help with formulas Fed Ex; Ups; Coo Balance sheets and ratios! thank you!

A B c D E FedEx Corporation Balance Sheets \begin{tabular}{|c|c|c|c|c|} \hline A & B & c & D & E \\ \hline TOTAL ASSETS & & 87,143.00 & 85,994.00 & 82,777.00 \\ \hline \multicolumn{5}{|l|}{ CURRENT LIABILITIES } \\ \hline Current portion of long-term debt & & 126.00 & 82.00 & 146.00 \\ \hline Accrued salaries and employee benefits & & 2,475.00 & 2,531.00 & 2,903.00 \\ \hline Accounts payable & & 3,848.00 & 4,030.00 & 3,841.00 \\ \hline Operating lease liabilities & & 2,390.00 & 2,443.00 & 2,208.00 \\ \hline Accrued expenses & & 4,747.00 & 5,188.00 & 4,562.00 \\ \hline Total current liabilities & & 13,586.00 & 14,274.00 & 13,660.00 \\ \hline LONG-TERM DEBT, LESS CURRENT PORTION & & 20,453.00 & 20,182.00 & 20,733.00 \\ \hline \multicolumn{5}{|l|}{ OTHER LONG-TERM LIABILITIES } \\ \hline Deferred income taxes & & 4,489.00 & 4,093.00 & 3,927.00 \\ \hline Pension, postretirement healthcare and other benefit obligations & & 3,130.00 & 4,448.00 & 3,501.00 \\ \hline Self-insurance accruals & & 3,339.00 & 2,889.00 & 2,430.00 \\ \hline Operating lease liabilities & & 15,363.00 & 14,487.00 & 13,375.00 \\ \hline Other liabilities & & 695.00 & 682.00 & 983.00 \\ \hline Total other long-term liabilities & & 27,016.00 & 26,599.00 & 24,216.00 \\ \hline \multicolumn{5}{|l|}{ COMMITMENTS AND CONTINGENCIES } \\ \hline \multicolumn{5}{|l|}{ COMMON STOCKHOLDERS' INVESTMENT } \\ \hline \begin{tabular}{l} Common stock, $0.10 par value; 800 million shares authorized; 318 \\ million shares issued as of May 31,2023 and 2022 \end{tabular} & & 32.00 & 32.00 & 32.00 \\ \hline Additional paid-in capital & & 3,769.00 & 3,712.00 & 3,481.00 \\ \hline Retained earnings & & 35,259.00 & 32,782.00 & 29,817.00 \\ \hline Accumulated other comprehensive loss & & (1,327.00) & (1,103.00) & (732.00) \\ \hline Treasury stock, at cost & & (11,645.00) & (10,484.00) & (8,430.00) \\ \hline Total common stockholders' investment & & 26,088.00 & 24,939.00 & 24,168.00 \\ \hline TOTAL LIABILITIES AND COMMON STOCKHOLDERS' INVESTMENT & & $87,143.00 & $85,994.00 & $82,777.00 \\ \hline \multirow{2}{*}{\multicolumn{5}{|c|}{ [1] Segment assets include intercompany receivables. }} \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular} United Parcel Service Balance Sheets \begin{tabular}{|c|c|c|c|c|} \hline Dec. & \begin{tabular}{l} 2022; Dec. 31, 2021;Dec \\ USD (\$) \$ in Millions \end{tabular} & \begin{tabular}{c} 302031 \\ 2022 \end{tabular} & \begin{tabular}{l} Dec. 31 \\ 2021 \end{tabular} & \begin{tabular}{l} Dec. 31, \\ 2020 \end{tabular} \\ \hline \multicolumn{5}{|l|}{ Current Assets: } \\ \hline Cash and cash equivalents & & $5,602 & $10,255 & $5,910 \\ \hline Marketable securities & & 1,993 & 338 & 406 \\ \hline Accounts receivable & & 12,729 & 12,669 & 10,888 \\ \hline Less: Allowance for credit losses & & (146) & (128) & (138) \\ \hline Accounts receivable, net & & 12,583 & 12,541 & 10,750 \\ \hline Assets held for sale & & & 0 & 1,197 \\ \hline Other current assets & & 2,039 & 1,800 & 1,953 \\ \hline Total Current Assets & & 22,217 & 24,934 & 20,216 \\ \hline Property, Plant and Equipment, Net & & 34,719 & 33,475 & 32,254 \\ \hline Operating Lease Right-Of-Use Assets & & 3,755 & 3,562 & 3,073 \\ \hline Goodwill & & 4,223 & 3,692 & 3,367 \\ \hline Intangible Assets, Net & & 2,796 & 2,486 & 2,274 \\ \hline Investments and Restricted Cash & & & 26 & 25 \\ \hline Deferred Income Tax Assets & & 139 & 176 & 527 \\ \hline Other Non-Current Assets & & 3,275 & 1,080 & 672 \\ \hline Total Assets & & 71,124 & 69,405 & 62,408 \\ \hline \multicolumn{5}{|l|}{ Current Liabilities: } \\ \hline \multicolumn{2}{|c|}{\begin{tabular}{l} Current maturities of long-term debt, commercial paper and \\ finance leases \end{tabular}} & 2,341 & 2,131 & 2,623 \\ \hline \multicolumn{2}{|l|}{ Current-maturities of operating leases } & 621 & 580 & 560 \\ \hline \multicolumn{2}{|l|}{ Accounts payable } & 7,512 & 7,523 & 6,455 \\ \hline \multicolumn{2}{|l|}{ Accrued wages and withholdings } & 4,049 & 3,819 & 3,569 \\ \hline \multicolumn{2}{|l|}{ Self-insurance reserves } & 1,069 & 1,048 & 1,085 \\ \hline \multicolumn{2}{|c|}{ Accrued group welfare and retirement plan contributions } & 1,076 & 1,038 & 927 \\ \hline Liabilities to be disposed of & & & 0 & 347 \\ \hline Other current liabilities & & 1,472 & 1,430 & 1,450 \\ \hline Total current fiabilities & & 18,140 & 17,569 & 17,016 \\ \hline \end{tabular} A B C D XPO, Inc Balance Sheets 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 \begin{tabular}{|c|c|c|c|} \hline Total assets & 6,269 & 8,717 & 16,177 \\ \hline \multicolumn{4}{|l|}{ Current liabilities } \\ \hline Accounts payable & 521 & 519 & 854 \\ \hline Accrued expenses & 774 & 822 & 1,044 \\ \hline Short-term borrowings and current maturities of & 59 & 58 & 1,281 \\ \hline Short-term operating lease liabilities & 107 & 107 & 152 \\ \hline Other current liabilities & 30 & 58 & 102 \\ \hline Current liabilities of discontinued operations & 16 & 984 & 1,728 \\ \hline Total current liabilities & 1,507 & 2,548 & 5,161 \\ \hline \multicolumn{4}{|l|}{ Long-term liabilities } \\ \hline Long-term debt & 2,473 & 3,513 & 5,240 \\ \hline Deferred tax liability & 319 & 247 & 286 \\ \hline Employee benefit obligations & 93 & 122 & 131 \\ \hline Long-term operating lease liabilities & 606 & 596 & 696 \\ \hline Other long-term liabilities & 259 & 272 & 384 \\ \hline Long-term liabilities of discontinued operations & 0 & 281 & 1,430 \\ \hline Total long-term liabilities & 3,750 & 5,031 & 8,167 \\ \hline \multicolumn{4}{|l|}{ Stockholders' equity } \\ \hline Convertible perpetual preferred stock, value & & & 1 \\ \hline \begin{tabular}{l} Common stock, $0.001 par value; 300 shares \\ authorized; 115 shares issued and outstanding as \\ of December 31,2022 and 2021 \end{tabular} & 0 & 0 & 0 \\ \hline Additional paid-in capital & 1,238 & 1,179 & 1,998 \\ \hline Retained earnings (accumulated deficit) & (4) & 43 & 868 \\ \hline Accumulated other comprehensive loss & (222) & (84) & (158) \\ \hline \begin{tabular}{l} Total stockholders' equity before noncontrolling \\ interests \end{tabular} & & & 2,709 \\ \hline Noncontrolling interests & & & 140 \\ \hline Total equity & 1,012 & 1,138 & 2,849 \\ \hline Total liabilities and equity & $6,269 & $8,717 & $16,177 \\ \hline \end{tabular} Add footer 1 Format Painter Merge \& Center $%,0 00 Conditional Format Formatting 2 Table Font y y Number y Alignment y fx= SUM('Historical Balance Sheets'!C4+'Historical Balance Sheets'!C5/'Historical Balance Sheets'!C30) Format Painter Formatting Table 2 Clipboard y Font y Alignment Number y fx= SUM('UPS Balance Sheets'!B3+'UPS Balance Sheets'!B4+'UPS Balance Sheets'!B5/'UPS Balance Sheets'!B28) Formatting 2 Table Clipboard ry Font y Alignment y Number y B9 fx =SUM('Historical Balance Sheets'!C25+'Historical Balance Sheets'!C31/'Historical Balance Sheets'!C23) 8 A B C D E F G H I J FedEx Corporation Competitor Ratio Analysis Historical Ratios For Years Ending May 31, 2023, 2022, 2021 31-Dec-22 United Parcel Service XPO, Inc. Industry Average Liquidity Current Ratio Quick Ratio 2023 2022 2021 Leverage Ratios Debt to Total Assets Ratio Debt Equity Ratio Long-Term Debt to Equity Times Interest Earned Ratio Activity Ratios Inventory Turnover Fixed Assets Turnover Accounts Receivable Turnover Average Collection Period Profitability Ratios Gross Profit Margin Net Profit Margin Return on Total Assets (ROA) Return on Stockholders' Equity (ROE) Earnings Per Share (EPS) Price Earnings Ratio =SUM('UPS Balance Sheets'!B20+'UPS Balance Sheets'!B29+'UPS Balance Sheets'!B33/'UPS Balance Sheets'!B18) A B c D E FedEx Corporation Balance Sheets \begin{tabular}{|c|c|c|c|c|} \hline A & B & c & D & E \\ \hline TOTAL ASSETS & & 87,143.00 & 85,994.00 & 82,777.00 \\ \hline \multicolumn{5}{|l|}{ CURRENT LIABILITIES } \\ \hline Current portion of long-term debt & & 126.00 & 82.00 & 146.00 \\ \hline Accrued salaries and employee benefits & & 2,475.00 & 2,531.00 & 2,903.00 \\ \hline Accounts payable & & 3,848.00 & 4,030.00 & 3,841.00 \\ \hline Operating lease liabilities & & 2,390.00 & 2,443.00 & 2,208.00 \\ \hline Accrued expenses & & 4,747.00 & 5,188.00 & 4,562.00 \\ \hline Total current liabilities & & 13,586.00 & 14,274.00 & 13,660.00 \\ \hline LONG-TERM DEBT, LESS CURRENT PORTION & & 20,453.00 & 20,182.00 & 20,733.00 \\ \hline \multicolumn{5}{|l|}{ OTHER LONG-TERM LIABILITIES } \\ \hline Deferred income taxes & & 4,489.00 & 4,093.00 & 3,927.00 \\ \hline Pension, postretirement healthcare and other benefit obligations & & 3,130.00 & 4,448.00 & 3,501.00 \\ \hline Self-insurance accruals & & 3,339.00 & 2,889.00 & 2,430.00 \\ \hline Operating lease liabilities & & 15,363.00 & 14,487.00 & 13,375.00 \\ \hline Other liabilities & & 695.00 & 682.00 & 983.00 \\ \hline Total other long-term liabilities & & 27,016.00 & 26,599.00 & 24,216.00 \\ \hline \multicolumn{5}{|l|}{ COMMITMENTS AND CONTINGENCIES } \\ \hline \multicolumn{5}{|l|}{ COMMON STOCKHOLDERS' INVESTMENT } \\ \hline \begin{tabular}{l} Common stock, $0.10 par value; 800 million shares authorized; 318 \\ million shares issued as of May 31,2023 and 2022 \end{tabular} & & 32.00 & 32.00 & 32.00 \\ \hline Additional paid-in capital & & 3,769.00 & 3,712.00 & 3,481.00 \\ \hline Retained earnings & & 35,259.00 & 32,782.00 & 29,817.00 \\ \hline Accumulated other comprehensive loss & & (1,327.00) & (1,103.00) & (732.00) \\ \hline Treasury stock, at cost & & (11,645.00) & (10,484.00) & (8,430.00) \\ \hline Total common stockholders' investment & & 26,088.00 & 24,939.00 & 24,168.00 \\ \hline TOTAL LIABILITIES AND COMMON STOCKHOLDERS' INVESTMENT & & $87,143.00 & $85,994.00 & $82,777.00 \\ \hline \multirow{2}{*}{\multicolumn{5}{|c|}{ [1] Segment assets include intercompany receivables. }} \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular} United Parcel Service Balance Sheets \begin{tabular}{|c|c|c|c|c|} \hline Dec. & \begin{tabular}{l} 2022; Dec. 31, 2021;Dec \\ USD (\$) \$ in Millions \end{tabular} & \begin{tabular}{c} 302031 \\ 2022 \end{tabular} & \begin{tabular}{l} Dec. 31 \\ 2021 \end{tabular} & \begin{tabular}{l} Dec. 31, \\ 2020 \end{tabular} \\ \hline \multicolumn{5}{|l|}{ Current Assets: } \\ \hline Cash and cash equivalents & & $5,602 & $10,255 & $5,910 \\ \hline Marketable securities & & 1,993 & 338 & 406 \\ \hline Accounts receivable & & 12,729 & 12,669 & 10,888 \\ \hline Less: Allowance for credit losses & & (146) & (128) & (138) \\ \hline Accounts receivable, net & & 12,583 & 12,541 & 10,750 \\ \hline Assets held for sale & & & 0 & 1,197 \\ \hline Other current assets & & 2,039 & 1,800 & 1,953 \\ \hline Total Current Assets & & 22,217 & 24,934 & 20,216 \\ \hline Property, Plant and Equipment, Net & & 34,719 & 33,475 & 32,254 \\ \hline Operating Lease Right-Of-Use Assets & & 3,755 & 3,562 & 3,073 \\ \hline Goodwill & & 4,223 & 3,692 & 3,367 \\ \hline Intangible Assets, Net & & 2,796 & 2,486 & 2,274 \\ \hline Investments and Restricted Cash & & & 26 & 25 \\ \hline Deferred Income Tax Assets & & 139 & 176 & 527 \\ \hline Other Non-Current Assets & & 3,275 & 1,080 & 672 \\ \hline Total Assets & & 71,124 & 69,405 & 62,408 \\ \hline \multicolumn{5}{|l|}{ Current Liabilities: } \\ \hline \multicolumn{2}{|c|}{\begin{tabular}{l} Current maturities of long-term debt, commercial paper and \\ finance leases \end{tabular}} & 2,341 & 2,131 & 2,623 \\ \hline \multicolumn{2}{|l|}{ Current-maturities of operating leases } & 621 & 580 & 560 \\ \hline \multicolumn{2}{|l|}{ Accounts payable } & 7,512 & 7,523 & 6,455 \\ \hline \multicolumn{2}{|l|}{ Accrued wages and withholdings } & 4,049 & 3,819 & 3,569 \\ \hline \multicolumn{2}{|l|}{ Self-insurance reserves } & 1,069 & 1,048 & 1,085 \\ \hline \multicolumn{2}{|c|}{ Accrued group welfare and retirement plan contributions } & 1,076 & 1,038 & 927 \\ \hline Liabilities to be disposed of & & & 0 & 347 \\ \hline Other current liabilities & & 1,472 & 1,430 & 1,450 \\ \hline Total current fiabilities & & 18,140 & 17,569 & 17,016 \\ \hline \end{tabular} A B C D XPO, Inc Balance Sheets 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 \begin{tabular}{|c|c|c|c|} \hline Total assets & 6,269 & 8,717 & 16,177 \\ \hline \multicolumn{4}{|l|}{ Current liabilities } \\ \hline Accounts payable & 521 & 519 & 854 \\ \hline Accrued expenses & 774 & 822 & 1,044 \\ \hline Short-term borrowings and current maturities of & 59 & 58 & 1,281 \\ \hline Short-term operating lease liabilities & 107 & 107 & 152 \\ \hline Other current liabilities & 30 & 58 & 102 \\ \hline Current liabilities of discontinued operations & 16 & 984 & 1,728 \\ \hline Total current liabilities & 1,507 & 2,548 & 5,161 \\ \hline \multicolumn{4}{|l|}{ Long-term liabilities } \\ \hline Long-term debt & 2,473 & 3,513 & 5,240 \\ \hline Deferred tax liability & 319 & 247 & 286 \\ \hline Employee benefit obligations & 93 & 122 & 131 \\ \hline Long-term operating lease liabilities & 606 & 596 & 696 \\ \hline Other long-term liabilities & 259 & 272 & 384 \\ \hline Long-term liabilities of discontinued operations & 0 & 281 & 1,430 \\ \hline Total long-term liabilities & 3,750 & 5,031 & 8,167 \\ \hline \multicolumn{4}{|l|}{ Stockholders' equity } \\ \hline Convertible perpetual preferred stock, value & & & 1 \\ \hline \begin{tabular}{l} Common stock, $0.001 par value; 300 shares \\ authorized; 115 shares issued and outstanding as \\ of December 31,2022 and 2021 \end{tabular} & 0 & 0 & 0 \\ \hline Additional paid-in capital & 1,238 & 1,179 & 1,998 \\ \hline Retained earnings (accumulated deficit) & (4) & 43 & 868 \\ \hline Accumulated other comprehensive loss & (222) & (84) & (158) \\ \hline \begin{tabular}{l} Total stockholders' equity before noncontrolling \\ interests \end{tabular} & & & 2,709 \\ \hline Noncontrolling interests & & & 140 \\ \hline Total equity & 1,012 & 1,138 & 2,849 \\ \hline Total liabilities and equity & $6,269 & $8,717 & $16,177 \\ \hline \end{tabular} Add footer 1 Format Painter Merge \& Center $%,0 00 Conditional Format Formatting 2 Table Font y y Number y Alignment y fx= SUM('Historical Balance Sheets'!C4+'Historical Balance Sheets'!C5/'Historical Balance Sheets'!C30) Format Painter Formatting Table 2 Clipboard y Font y Alignment Number y fx= SUM('UPS Balance Sheets'!B3+'UPS Balance Sheets'!B4+'UPS Balance Sheets'!B5/'UPS Balance Sheets'!B28) Formatting 2 Table Clipboard ry Font y Alignment y Number y B9 fx =SUM('Historical Balance Sheets'!C25+'Historical Balance Sheets'!C31/'Historical Balance Sheets'!C23) 8 A B C D E F G H I J FedEx Corporation Competitor Ratio Analysis Historical Ratios For Years Ending May 31, 2023, 2022, 2021 31-Dec-22 United Parcel Service XPO, Inc. Industry Average Liquidity Current Ratio Quick Ratio 2023 2022 2021 Leverage Ratios Debt to Total Assets Ratio Debt Equity Ratio Long-Term Debt to Equity Times Interest Earned Ratio Activity Ratios Inventory Turnover Fixed Assets Turnover Accounts Receivable Turnover Average Collection Period Profitability Ratios Gross Profit Margin Net Profit Margin Return on Total Assets (ROA) Return on Stockholders' Equity (ROE) Earnings Per Share (EPS) Price Earnings Ratio =SUM('UPS Balance Sheets'!B20+'UPS Balance Sheets'!B29+'UPS Balance Sheets'!B33/'UPS Balance Sheets'!B18)