Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete three years of projected income statements, starting with the most recent year after last published(starting with 2022). All numbers must be calculated by formulas

Complete three years of projected income statements, starting with the most recent year after last published(starting with 2022). All numbers must be calculated by formulas and assumptions must be justified with research. Numbers will need to match for projected balance sheet and statement of cash flows. Please provide formulas and assumptions. The company is Cardinal Health.

image text in transcribedimage text in transcribed

Jun 30, 2021 12 Months Ended Jun 30, 2020 Jun 30, 2019 $ 162,467 155,689 6,778 $ 152,922 146,054 6,868 $ 145,534 138,700 6,834 Income Statement Revenue Cost of products sold Gross margin Operating expenses: Distribution, selling, general and administrative expenses Restructuring and employee severance Amortization and other acquisition-related costs Impairments and (gain)/loss on disposal of assets, net Litigation (recoveries/charges, net Operating earnings/(loss) Other (income)/expense, net Interest expense, net Loss on early extinguishment of debt Gain (Loss) on Sale of Investments Earnings/(loss) before income taxes Provision for/benefit from) income taxes Net earnings Less: Net earnings attributable to noncontrolling interests Net earnings/(loss) attributable to Cardinal Health, Inc. Earnings/(los) per common share attributable to Cardinal Health, Inc. Earnings Per Share, Basic Earnings Per Share, Diluted Weighted-average number of common shares outstanding: Basic (in shares) Diluted in shares) 4,533 114 451 79 1,129 472 (47) 180 14 (2) 323 (289) 612 (1) $ 611 4,572 122 524 7 5,741 (4,098) (1) 238 16 579 (3,772) (79) (3,693) (3) $ (3,696) 4,480 125 621 (488) 36 2,060 15 294 0 0 1,751 386 1,365 (2) $ 1,363 $ 2.09 $2.08 $(12.61) $ (12.61) $4.55 $ 4.53 293 292 294 300 301 293 12 Months Ended % Change Jun 30, 2020 Jun 30, 2021 $ Change $ Change % Change Jun 30, 2019 $ 162,467 155,689 6,778 $ 152,922 146,054 6,868 $ 145,534 138,700 6,834 Income Statement Revenue Cost of products sold Gross margin Operating expenses: Distribution, selling, general and administrative expenses Restructuring and employee severance Amortization and other acquisition-related costs Impairments and (gain)/loss on disposal of assets, net Litigation (recoveries/charges, net Operating earnings/(loss) Other (income)/expense, net Interest expense, net Loss on early extinguishment of debt Gain (Loss) on Sale of Investments Earnings/(loss) before income taxes Provision for/(benefit from) income taxes Net earnings Less: Net earnings attributable to noncontrolling interests Net earnings/(loss) attributable to Cardinal Health, Inc. Earnings/(loss) per common share attributable to Cardinal Health, Inc. Earnings Per Share, Basic Earnings Per Share, Diluted Weighted average number of common shares outstanding: Basic (in shares) Diluted in shares) 4,533 114 451 79 1,129 472 (47) 180 14 (2) 323 (289) 612 (1) $ 611 $ $9,545 9,635 (90) 0 (39) (8) (73) 72 (4,612) 4,570 (46) (58) (2) (581) 4,095 (210) 4,305 2 4,307 4,480 125 621 (488) 36 2,060 15 294 6% 7% -1% 0% -1% -7% -14% 1029% -80% -112% 4600% -24% -13% -100% -109% 266% -117% -67% -117% 0% -117% -116% 0% 0% 0% 4,572 122 524 7 5,741 (4,098) (1) 238 16 579 (3,772) (79) (3,693) (3) $ (3,696) $ 7,388 7,354 34 0 92 (3) (97) 495 5,705 (6,158) (16) (56) 16 579 (5,523) (465) (5,058) (1) $ (5,059) 0 $(17.16) $(17.14) 0 (7) (8) 5% 5% 0% 0% 2% -2% -16% -101% 15847% -299% -107% -19% 0% 0% -315% -120% -371% 50% -371% 0% -377% -378% 0% -2% -3% 0 0 1,751 386 1,365 (2) $ 1,363 $2.09 $2.08 0 $ 14.70 $ 14.69 $(12.61) $(12.61) $ 4.55 $ 4.53 0 (1) 1 292 294 300 293 293 301 Jun 30, 2021 12 Months Ended Jun 30, 2020 Jun 30, 2019 $ 162,467 155,689 6,778 $ 152,922 146,054 6,868 $ 145,534 138,700 6,834 Income Statement Revenue Cost of products sold Gross margin Operating expenses: Distribution, selling, general and administrative expenses Restructuring and employee severance Amortization and other acquisition-related costs Impairments and (gain)/loss on disposal of assets, net Litigation (recoveries/charges, net Operating earnings/(loss) Other (income)/expense, net Interest expense, net Loss on early extinguishment of debt Gain (Loss) on Sale of Investments Earnings/(loss) before income taxes Provision for/benefit from) income taxes Net earnings Less: Net earnings attributable to noncontrolling interests Net earnings/(loss) attributable to Cardinal Health, Inc. Earnings/(los) per common share attributable to Cardinal Health, Inc. Earnings Per Share, Basic Earnings Per Share, Diluted Weighted-average number of common shares outstanding: Basic (in shares) Diluted in shares) 4,533 114 451 79 1,129 472 (47) 180 14 (2) 323 (289) 612 (1) $ 611 4,572 122 524 7 5,741 (4,098) (1) 238 16 579 (3,772) (79) (3,693) (3) $ (3,696) 4,480 125 621 (488) 36 2,060 15 294 0 0 1,751 386 1,365 (2) $ 1,363 $ 2.09 $2.08 $(12.61) $ (12.61) $4.55 $ 4.53 293 292 294 300 301 293 12 Months Ended % Change Jun 30, 2020 Jun 30, 2021 $ Change $ Change % Change Jun 30, 2019 $ 162,467 155,689 6,778 $ 152,922 146,054 6,868 $ 145,534 138,700 6,834 Income Statement Revenue Cost of products sold Gross margin Operating expenses: Distribution, selling, general and administrative expenses Restructuring and employee severance Amortization and other acquisition-related costs Impairments and (gain)/loss on disposal of assets, net Litigation (recoveries/charges, net Operating earnings/(loss) Other (income)/expense, net Interest expense, net Loss on early extinguishment of debt Gain (Loss) on Sale of Investments Earnings/(loss) before income taxes Provision for/(benefit from) income taxes Net earnings Less: Net earnings attributable to noncontrolling interests Net earnings/(loss) attributable to Cardinal Health, Inc. Earnings/(loss) per common share attributable to Cardinal Health, Inc. Earnings Per Share, Basic Earnings Per Share, Diluted Weighted average number of common shares outstanding: Basic (in shares) Diluted in shares) 4,533 114 451 79 1,129 472 (47) 180 14 (2) 323 (289) 612 (1) $ 611 $ $9,545 9,635 (90) 0 (39) (8) (73) 72 (4,612) 4,570 (46) (58) (2) (581) 4,095 (210) 4,305 2 4,307 4,480 125 621 (488) 36 2,060 15 294 6% 7% -1% 0% -1% -7% -14% 1029% -80% -112% 4600% -24% -13% -100% -109% 266% -117% -67% -117% 0% -117% -116% 0% 0% 0% 4,572 122 524 7 5,741 (4,098) (1) 238 16 579 (3,772) (79) (3,693) (3) $ (3,696) $ 7,388 7,354 34 0 92 (3) (97) 495 5,705 (6,158) (16) (56) 16 579 (5,523) (465) (5,058) (1) $ (5,059) 0 $(17.16) $(17.14) 0 (7) (8) 5% 5% 0% 0% 2% -2% -16% -101% 15847% -299% -107% -19% 0% 0% -315% -120% -371% 50% -371% 0% -377% -378% 0% -2% -3% 0 0 1,751 386 1,365 (2) $ 1,363 $2.09 $2.08 0 $ 14.70 $ 14.69 $(12.61) $(12.61) $ 4.55 $ 4.53 0 (1) 1 292 294 300 293 293 301

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

Step: 3

blur-text-image

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

Lawyers And The Proceeds Of CrimeThe Facilitation Of Money Laundering And Its Control

Authors: Katie Benson

1st Edition

1138744867, 9781138744868

More Books

Students also viewed these Accounting questions

Question

Summarize the reactive strategy of your organization.

Answered: 1 week ago