Question

1 Approved Answer

Posted on Jun 23, 2024

Create common size income balance sheets and common size income statements for Walgreen Boots Alliance and CVS Health. Give one reason for the difference in

Create common size income balance sheets and common size income statements for Walgreen Boots Alliance and CVS Health.

Give one reason for the difference in cost of goods sold percentage between the two companies.
Give one reason for the difference in selling, general, and administrative expense percentage between the two companies.
Give one reason for the difference in property, plant, and equipment percentage between the two companies.
Give one reason for the difference in goodwill percentage between the two companies.

CVS Health Corporation (NYSE:CVS) > Financials > Income Statement Walgreens Boots Alliance, Inc. (NasdaqGS:WBA) > Financials > Income Statement In Millions of the reported currency, except per share items. Income Statement Restated Reclassified Reclassified LTM Reclassified Reclassified Reclassified For the Fiscal Period Ending 12 months 12 months 12 months For the Fiscal Period Ending 12 months Dec-31-2015 Dec-31-2016 Dec-31-2017 Dec-31-2018 Dec-31-2019 Aug-31-2016 Aug-31-2017 Aug-31-2018 Aug-31-2019 May-31-2020 Currency USD USD USD USD USD USD Currency USD USD USD USD Revenue 153,290.0 177,526.0 184,765.0 255,765.0 262,980.0 Revenue 117,351.0 1 18,214. 131,537.0 138,745.0 Total Revenue 177,526.0 184,765.0 193,919.0 262,980.0 117,351.0 8,214.0 131,537.0 138,745.0 126,762.0 148,666.0 156,258.0 163,041.0 211,248.0 215,212.0 Cost Of Goods Sold 87,477.0 100,745.0 106,790.0 110,304.0 6,528.0 28,507.0 44,517.0 Gross Profit 28,441.0 Selling General & Admin Exp 16,833.0 18,284.0 18,737.0 20,827.0 32,699.0 33,888.0 Selling General & Admin Exp. 23,425.0 23,618.0 24,638.0 25,258.0 25, 125.0 Other Operating Exp., Total 18,284.0 18,737.0 20,827.0 32,699.0 Other Operating Exp., Total 23,618.0 24,638.0 25,258.0 Operating Income 10,051.0 3,316.0 (807.0) (2,619.0) 3,035.0) (2,979.0) (643.0) Interest and Invest. Income 21.0 21.0 660.0 1,011.0 815.0 Interest and Invest. Income 0.0 0.0 0.0 0.0 (786.0) (1,058.0) (1,041.0) (1,959.0) (2,024.0) (2,164.0) Net Interest Exp. (676.0) (629.0) Other Non-Operating Inc. (Exp.) (21.0) (1.0) 0.0 2.0) 7.0) 30.0 Income/(Loss) from Affiliates 81.0 187.0 361.0 Currency Exchange Gains (Loss) 0.0 0.0 0.0 0.0 0.0 0.0 Currency Exchange Gains (Loss) 39.0 121.0 68.0 Other Non-Operating Inc. (Exp.) 0.0 0.0 Other Non-Operating Inc. (Exp.) 88.0 81.0 EBT Excl Unusual Items 8,888.0 9,517.0 8,729.0 8,090.0 11,746.0 EBT Excl Unusual Items 5,095. 5,942.0 4,450.0 2,902.0 Restructuring Charges (215.0) (231.0) Restructuring Charges (424.0) Merger & Related Restruct. Charges (272.0) (291.0 Impairment of Goodwill 0.0 0.0 181.0) 0.0 0.0 Impairment of Goodwill 0.0 0.0 0.0 Gain (Loss) On Sale Of Invest. 0.0 0.0 0.0 Gain (Loss) On Sale Of Invest. (249.0) 0.0 0.0 Asset Writedown 0.0 0.0 0.0 0.0 0.0 Asset Writedown (57.0) (73.0) Legal Settlements 88.0 0.0 0.0 0.0 Other Unusual Items EBT Incl. Unusual Items 8,616.0 8,637.0 8,268.0 1,406.0 8,997. 11,206.0 EBT Incl. Unusual Items 6,029.0 931.0 Income Tax Expense 3,386.0 1,637.0 2,002.0 2,935.0 Income Tax Expense Earnings from Cont. Ops. 5,230.0 5,320.0 6,631.0 (596.0 6,631.0 8,271.0 Earnings from Cont. Ops. 4, 101.0 5,031.0 3,962.0 753.0 Earnings of Discontinued Ops. 9.0 (8.0) 0.0 Earnings of Discontinued Ops. Net Income to Company 5,239.0 5,319.0 6,623.0 6,631.0 8,271.0 Net Income to Company 4, 191.0 4,101.0 5,031.0 3,962.0 753.0 Minority Int. in Earnings (2.0) (2.0) 2.0 Minority Int. in Earnings 7.0 20.0 Net Income 5,237.0 5,317.0 6,622.0 (594.0 6,634.0 8,259.0 Net Income 4,173.0 4,078.0 5,024.0 3,982.0 760.0 Pref. Dividends and Other Adj. 26.0 27.0 24.0 3.0 5.0 2.0 Pref. Dividends and Other Adj. 0.0 0.0 NI to Common Incl Extra Items 5,211.0 5,290.0 (597.0) 6,629.0 8,257.0 NI to Common Incl Extra Items 3,982.0 NI to Common Excl Extra Items 5,202.0 5,291.0 6,606.0 (597.0) 6,629.0 NI to Common Excl Extra Items 4,173.0 4,078.0 5,024.0 3,982.0 760.0CVS Health Corporation (NYSE:CVS) > Financials > Balance Sheet Walgreens Boots Alliance, Inc. (NasdaqGS:WBA) > Financials > Balance Sheet In Millions of the reported currency, except per share items Balance Sheet Balance Sheet as of: Restated Balance Sheet as of: Dec-31-2018 Aug-31-2016 Aug-31-2017 May-31-2020 Currency JSD USD JSD USD JSD USD Currency USD JSD USD JSD USD 12, 164.0 13,035.0 19,719.0 5,800.0 Other Receivables 1,200.0 1,200. 1, 182.0 Total Receivables 12, 164.0 17,631.0 Total Receivables 6,260.0 6,528.0 6,573.0 6,982.0 14,001.0 16,450.0 16,519.0 8,956.0 9,333.0 9,563.0 Restricted Cash 0.0 14.0 6.0 0.0 Restricted Cash 185. 184.0 175. Other Current Assets 6,002.0 Other Current Assets 675.0 829.0 Total Current Assets 29,158.0 31,042.0 31,229.0 45,243.0 62,506.0 Total Current Assets 25,883.0 19,753.0 17,846.0 18,700.0 22,018.0 46,780.0 (15,520.0) 890.0) Accumulated Depreciation 7,713.0) Net Property, Plant & Equipment 9,855.0 10,175.0 11,349.0 32,904.0 32,792.0 Net Property, Plant & Equipment 13,435.0 12,747.0 12,411.0 11,978.0 112.0 15,732.0 6, 177.0 38, 106.0 38,451.0 78,678.0 79,749.0 80,057.0 15,527.0 16,560.0 14,948.0 Other Intangibles 13,511.0 36,524.0 33, 121.0 32,225.0 Other Intangibles 1 1,051.0 3,283.0 0, 183.0 1,440.0 1,485.0 1,417.0 8,930.0 9,059.0 9,321.0 Other Long-Term Assets 464. 506.0 1,060.0 1, 186.0 Total Assets 196,456.0 235,495.0 Total Assets 68,124.0 86,444.0 LIABILITIES LIABILITIES Accounts Payable 7,490.0 7,946.0 8,863.0 8,925.0 9,919.0 Accounts Payable 11,000.0 12,494.0 13,566.0 14,033.0 6,829.0 1,398.0 5,785.0 Short-term Borrowings 1,874.0 6,510.0 0.0 1,276.0 720.0 0.0 1,717.0 4,488.0 3,885.0 42.0 1,265.0 Curr. Port. of LT Debt 63.0 0.0 249.0 494.0 0.0 0.0 0.0 0.0 1.623.0 Curr. Port. of Leases 0.0 0.0 0.0 80.0 2,335.0 53.0 73.0 Curr. Income Taxes Payable 329.0 273.0 87.0 Other Current Liabilities 16,331.0 20,821.0 19.0 6.0 .8.0 Total Current Liabilities 23,169.0 26,250.0 63,694.0 Total Current Liabilities 17,013.0 26,647.0 26,267.0 25,615.0 21,511.0 62,479.0 Long-Term Debt 18,705.0 12,432.0 19,614.0 LongO.OTerm Leases 1,324.0 Pension & Other Post-Retire. Benefits 0.0 300.0 Pension & Other Post-Retire. Benefits 184.0 171.0 0.0 4,217.0 4,214.0 2,996.0 7,677.0 7,136.0 Def. Tax Liability, Non-Curr 2,644.0 2,281.0 1,785.0 1,538.0 Other Non-Current Liabilities 1,542.0 1,549.0 1,611.0 14,483.0 13,744.0 14,217.0 3,861.0 4,052.0 5,357.0 3,286.0 1,867.0 37,735.0 65,122.0 17.0 17.0 17.0 Common Stock 12.0 12.0 12.0 12.0 30,948.0 31,618.0 32,079.0 45,423.0 46,259.0 Additional Paid In Capital 10, 111.0 10,339.0 10,493.0 10,726.0 Retained Earn 35,506.0 40,911.0 45, 108.0 Retained Earnings 27,684.0 33,551.0 35,815.0 34,244.0 28,886.0) (37,765.0 (28, 199.0) (28,206.0) (4,934.0) (15,047.0) Comprehensive Inc. and Other (336.0 73.0 990.0 1, 184.0 Comprehensive Inc. and Other 2,993.0 (3,051.0) (3,002.0) 3,871.0 Total Common Equity 36,830.0 58,225.0 Total Common Equity 29,880.0 26,007.0 23,512.0 20,736.0 Total Equity 37.242.0 36,834.0 37,695.0 58,543.0 64,170.0 68,355.0 Total Equity 30,281.0 28,274.0 26,689.0 21,322.0 Total Liabilities And Equity 94,462.0 95,131.0 Total Liabilities And Equity 72,688.0 68,124.0 86,444.0