Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 Formulas

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Tools for business decision making

Authors: kimmel, weygandt, kieso

4th Edition

978-0470117262, 9780470534786, 470117265, 470534788, 978-0470095461

More Books

Students also viewed these Accounting questions