Answered step by step
Verified Expert Solution
Question
1 Approved Answer
using the photos, calculate the current ratio, quick ratio, debt to total asset ratio, and debt to equity ratio using excel formulas. Mckesson Corp. Historicle
using the photos, calculate the current ratio, quick ratio, debt to total asset ratio, and debt to equity ratio using excel formulas.
Mckesson Corp. Historicle Balance Sheets As of March 31, 2022, March 31, 2021, March 31, 2020 Ss in Millions Mar. 31, 2022 Mar. 31,2021 Mar. 31, 2020 Current Assets Cash and cash equivalents Receivables, net $3,53218,583$6,27819,181$4,01519,950 Inventories, net Assets held for sale Prepaid expenses and other Total current assets Property, plant, and equipment, net Operating lease right-of-use assets Goodwill Intangible assets, net Other non-current assets Total assets \begin{tabular}{rrr} 18,702 & 19,246 & 16,734 \\ 4,516 & 12 & 906 \\ 898 & 665 & 617 \\ 46,231 & 45,382 & 42,222 \\ \hline 2,092 & 2,581 & 2,365 \\ 1,548 & 2,100 & 1,886 \\ 9,451 & 9,493 & 9,360 \\ 2,059 & 2,878 & 3,156 \\ 1,917 & 2,581 & 2,259 \\ 63,298 & 65,015 & 19,025 \\ \hline \end{tabular} Current liabilities Drafts and accounts payable Current portion of long-term debt Current portion of operating lease liabilities Liabilities held for sale Other accrued liabilities Total current liabilities Long-term debt Long-term deferred tax liabilities Long-term operating lease liabilities Long-term litigation liabilities Other non-current liabilities Total Non-Current Liabilities Redeemable noncontrolling interests \begin{tabular}{rrr} 38,086 & 38,975 & 37,195 \\ 799 & 742 & 1,052 \\ 297 & 390 & 354 \\ 4,741 & 9 & 683 \\ 4,543 & 3,987 & 3,340 \\ 48,466 & 44,103 & 42,624 \\ \hline 5,080 & 6,406 & 6,335 \\ 1,418 & 1,411 & 2,255 \\ 1,366 & 1,867 & 1,660 \\ 7,220 & 8,067 & 0 \\ 1,540 & 1,715 & 1,662 \\ 16,624 & 19,466 & 11,912 \\ 0 & 1,271 & 1,402 \end{tabular} McKesson Corporation stockholders' deficit Preferred stock, $0.01 par value, 100 shares authorized, no shares issued or outstanding Common stock, $0.01 par value, 800 shares authorized, 275 and 273 shares issued at March 31, 2022 and 2021, respectively Additional paid-in capital Retained earnings Accumulated other comprehensive loss Treasury shares, at cost, 130 and 115 shares at March 31, 2022 and 2021, respectively Total McKesson Corporation stockholders' deficit Noncontrolling interests Total equity (deficit) Total liabilities, redeemable noncontrolling interests, and equity \begin{tabular}{rrr} (2,272) & (21) & 5,092 \\ \hline 480 & 196 & 217 \\ (1,792) & 175 & 5,309 \\ \hline$63,298 & $65,015 & $61,247 \\ \hline \end{tabular} Fields Using Formulas Mckesson Corp. Historicle Balance Sheets As of March 31, 2022, March 31, 2021, March 31, 2020 Ss in Millions Mar. 31, 2022 Mar. 31,2021 Mar. 31, 2020 Current Assets Cash and cash equivalents Receivables, net $3,53218,583$6,27819,181$4,01519,950 Inventories, net Assets held for sale Prepaid expenses and other Total current assets Property, plant, and equipment, net Operating lease right-of-use assets Goodwill Intangible assets, net Other non-current assets Total assets \begin{tabular}{rrr} 18,702 & 19,246 & 16,734 \\ 4,516 & 12 & 906 \\ 898 & 665 & 617 \\ 46,231 & 45,382 & 42,222 \\ \hline 2,092 & 2,581 & 2,365 \\ 1,548 & 2,100 & 1,886 \\ 9,451 & 9,493 & 9,360 \\ 2,059 & 2,878 & 3,156 \\ 1,917 & 2,581 & 2,259 \\ 63,298 & 65,015 & 19,025 \\ \hline \end{tabular} Current liabilities Drafts and accounts payable Current portion of long-term debt Current portion of operating lease liabilities Liabilities held for sale Other accrued liabilities Total current liabilities Long-term debt Long-term deferred tax liabilities Long-term operating lease liabilities Long-term litigation liabilities Other non-current liabilities Total Non-Current Liabilities Redeemable noncontrolling interests \begin{tabular}{rrr} 38,086 & 38,975 & 37,195 \\ 799 & 742 & 1,052 \\ 297 & 390 & 354 \\ 4,741 & 9 & 683 \\ 4,543 & 3,987 & 3,340 \\ 48,466 & 44,103 & 42,624 \\ \hline 5,080 & 6,406 & 6,335 \\ 1,418 & 1,411 & 2,255 \\ 1,366 & 1,867 & 1,660 \\ 7,220 & 8,067 & 0 \\ 1,540 & 1,715 & 1,662 \\ 16,624 & 19,466 & 11,912 \\ 0 & 1,271 & 1,402 \end{tabular} McKesson Corporation stockholders' deficit Preferred stock, $0.01 par value, 100 shares authorized, no shares issued or outstanding Common stock, $0.01 par value, 800 shares authorized, 275 and 273 shares issued at March 31, 2022 and 2021, respectively Additional paid-in capital Retained earnings Accumulated other comprehensive loss Treasury shares, at cost, 130 and 115 shares at March 31, 2022 and 2021, respectively Total McKesson Corporation stockholders' deficit Noncontrolling interests Total equity (deficit) Total liabilities, redeemable noncontrolling interests, and equity \begin{tabular}{rrr} (2,272) & (21) & 5,092 \\ \hline 480 & 196 & 217 \\ (1,792) & 175 & 5,309 \\ \hline$63,298 & $65,015 & $61,247 \\ \hline \end{tabular} Fields Using FormulasStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started