FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
CVS Health Corporation (NYSE:CVS) > Financials > Income Statement In Millions of the reported currency, except per share items. Income Statement Restated Reclassified Reclassified For the Fiscal Period Ending 12 months LTM 12 months 12 months 12 months 12 months Dec-31-2015 Dec-31-2016 12 months Dec-31-2017 Dec-31-2018 Dec-31-2019 Currency USD Jun-30-2020 USD USD USD USD USD Currency Exchange Gains (Loss) 0.0 0.0 0.0 0.0 Other Non-Operating Inc. (Exp.) 0.0 0.0 0.0 0.0 0.0 EBT Excl Unusual Items 0.0 0.0 0.0 8,888.0 9,517.0 8,729.0 8,090.0 9,787.0 11,746.0 Restructuring Charges 0.0 (34.0) (215.0) 0.0 Merger & Related Restruct. Charges (272.0) (231.0) (96.0) (291.0) (65.0 Impairment of Goodwill (492.0) (480.0) 0.0 (365.0) 0.0 (181.0) 0.0 Gain (Loss) On Sale Of Invest. (6, 149.0) 0.0 0.0 0.0 0.0 0.0 Asset Writedown 0.0 0.0 0.0 0.0 0.0 0.0 Legal Settlements (43.0) 0.0 0.0 88.0 0.0 0.0 0.0 Other Unusual Items 0.0 0.0 (643.0) 0.0 EBT Incl. Unusual Items 0.0 (79.0) 8,616.0 (79.0) 8,637.0 8,268.0 1,406.0 8,997.0 11,206.0 Income Tax Expense 3,386.0 3, 317.0 1,637.0 2,002.0 Earnings from Cont. Ops. 5,230.0 2,366.0 5,320.0 2,935.0 6,631.0 (596.0) 6,631.0 8,271.0 Earnings of Discontinued Ops. 9.0 (1.0) (8.0 0.0 0.0 Net Income to Company 5,239.0 5,319.0 0.0 6,623.0 (596.0) 6,631.0 8,271.0 Minority Int. in Earnings (2.0) (2.0) (1.0) 2.0 3.0 Net Income 5,237.0 5,317.0 (12.0) 6,622.0 (594.0) 6,634.0 8,259.0 Pref. Dividends and Other Adj. 26.0 27.0 24.0 3.0 5.0 2.0 NI to Common Incl Extra Items 5,211.0 5,290.0 6,598.0 NI to Common Excl Extra Items (597.0) 6,629.0 5,202.0 5,291.0 8,257.0 6,606.0 (597.0) 6,629.0 8,257.0Walgreens Boots Alliance, Inc. (NasdaqGS:WBA) > Financials > Income Statement Income Statement Reclassified Reclassified Reclassified For the Fiscal Period Ending LTM 12 months 12 months 12 months 12 months 12 months Aug-31-2016 Aug-31-2017 Aug-31-2018 Aug-31-2019 May-31-2020 Currency USD USD USD USD USD Currency Exchange Gains (Loss) 7.0 (37.0) 39.0 121.0 Other Non-Operating Inc. (Exp.) 68.0 (16.0) 88.0 81.0 .0 EBT Excl Unusual Items 5,941.0 5,095.0 (214.0) 5,942.0 4,450.0 2,902.0 Restructuring Charges (424.0) (234.0) 0.0 0.0 0.0 Impairment of Goodwill 0.0 0.0 0.0 0.0 Gain (Loss) On Sale Of Invest. (1,675.0) (249.0) 0.0 144.0 0.0 Asset Writedown (80.0) (70.0) 0.0 (57.0) (73.0) (399.0) Other Unusual Items 0.0 0.0 0.0 173.0 EBT Incl. Unusual Items 173.0 5,188.0 4,861.0 6,029.0 4,550.0 931.0 Income Tax Expense 997.0 760.0 998.0 588.0 Earnings from Cont. Ops. 178.0 4, 191.0 4, 101.0 5,031.0 3,962.0 753.0 Earnings of Discontinued Ops. 0.0 0.0 0.0 ).0 Net Income to Company 4, 191.0 0.0 4, 101.0 5,031.0 3,962.0 753.0 Minority Int. in Earnings (18.0) (23.0) (7.0) 20.0 7.0 Net Income 4,173.0 4,078.0 5,024.0 3,982.0 760.0 Pref. Dividends and Other Adj. 0.0 0.0 0.0 0.0 0.0 NI to Common Incl Extra Items 4, 173.0 4,078.0 5,024.0 3,982.0 760.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 In Millions of the reported currency, except per share items. Balance Sheet Balance Sheet as of: Restated Dec-31-2015 C-31-2016 Dec-31-2017 Dec-31-2018 Dec-31-2019 Jun-30-2020 Currency JSD JSD JSD JSD USD ISD ASSETS Cash And Equivalents 2,459.0 3, 371.0 1,696.0 4,059.0 5,683.0 14,869.0 Short Term Investments 38.0 87.0 111.0 2,522.0 2,373.0 2,596.0 Trading Asset Securities 0.0 0.0 0.0 0.0 Total Cash & ST Investments 547.0 458.0 5.0 1,812.0 6,581.0 8,056.0 0.0 17,465.0 Accounts Receivable 11,888.0 12, 164.0 13,035.0 16,071.0 17,236.0 19,719.0 Other Receivables 0.0 0.0 146.0 1,560. 2,381.0 2,801.0 Total Receivables 11,888.0 12, 164.0 13,181.0 17,631.0 19,617.0 22,520.0 nventory 14, 001.0 14,760.0 15,296.0 16,450.0 17,516.0 16,519.0 Restricted Cash 0.0 0.0 14.0 6.0 0.0 0.0 Other Current Assets 722.0 660.0 926.0 29, 158.0 042.0 4,575.0 5, 113.0 6,002.0 Total Current Assets 31,229.0 45,243.0 50,302.0 62,506.0 Gross Property, Plant & Equipment 21,036.0 22, 802.0 24,290.0 26,869.0 49,794.0 0.0 Accumulated Depreciation 11, 181.0) 12,627.0) 13,998.0) (15,520.0 16,890.0 0.0 Net Property, Plant & Equipment 9,855.0 10, 175.0 10,292.0 11,349.0 32,904.0 32,792.0 Long-term Investments 0.0 0.0 112.0 15,732.0 17,314.0 18,594.0 Goodwill 38, 106.0 38,249.0 38,451.0 78,678.0 79,749.0 80,057.0 Other Intangibles 13,878.0 13, 511.0 3,630.0 36,524.0 8.930.0 33, 121.0 32,225.0 Other Long-Term Assets 1,440.0 1,485.0 1,417.0 9 ,059.0 9 , 321.0 Total Assets 92,437.0 94,462.0 95,131.0 196,456.0 222,449.0 235,495.0 LIABILITIES Accounts Payable 7,490.0 7,946.0 8,863.0 8,925.0 10,492.0 9,919.0 Accrued Exp 6,829.0 6,937.0 6,510.0 16, 701.0 18,855.0 22,918.0 Short-term Borrowings 0.0 1,874.0 1,276.0 720.0 0.0 0.0 Curr. Port. of LT Deb 1, 197.0 42.0 3,568.0 Curr. Port. of Leases 0.0 1,265.0 3,754.0 3, 192.0 0.0 0.0 0.0 623.0 1,766.0 Unearned Revenue, Current 0.0 0.0 53.0 67.0 73.0 78.0 Other Current Liabilities 7,653.0 9,451.0 10,378.0 18,506.0 20,821.0 Total Current Liabilities 23,169.0 26,250.0 0.648.0 16,331.0 44,009.0 53,303.0 63,694.0 Long-Term Debt 26,267.0 25, 615.0 21,511.0 70,802.0 63,918.0 62,479.0 Long-Term Leases 0.0 0.0 670.0 342.0 19,707.0 19,614.0 Pension & Other Post-Retire. Benefits 0.0 0.0 0.0 300. 313.0 0.0 Def. Tax Liability, Non-Curr. 4,217.0 4,214.0 2,996.0 7,677.0 7,294.0 7,136.0 Other Non-Current Liabilities 1,542.0 1,549.0 1,611.0 14,483.0 13,744.0 14,217.0 Total Liabilities 55, 195.0 57,628.0 57,436.0 137,913.0 158,279.0 167,140.0 Common Stock 17.0 17.0 17.0 17.0 17.0 17.0 Additional Paid In Capital 30,948.0 31,618.0 32,079.0 45,423.0 45,955.0 46,259.0 Retained Earnings 35,506.0 38,983.0 40,911.0 Treasury Stock 28.886.0) 43,556.0 45, 108.0 48,768.0 (33,452.0) (37,765.0) (28, 199.0) (28,206.0) (28,206.0) Comprehensive Inc. and Other (389.0) (336.0) (196.0) 73.0 390.0 1,184.0 Total Common Equity 37, 196.0 36,830.0 37,691.0 58,225.0 63,864.0 68,022.0Walgreens Boots Alliance, Inc. (NasdaqGS:WBA) > Financials > Balance Sheet Balance Sheet Balance Sheet as of: Reclassified Aug-31-2016 Aug-31-2017 Aug-31-2018 Aug-31-2019 May-31-2020 Currency USD USD USD USD USD ASSETS Cash And Equivalents 9,807.0 3,301.0 785.0 1,023.0 768.0 Trading Asset Securities 0.0 0.0 0.0 0.0 9.0 Total Cash & ST Investments 9,807.0 3,301.0 785.0 1,023.0 777.0 Accounts Receivable 6,260.0 5,428.0 5,373.0 6,026.0 5,800.0 Other Receivables 0.0 1, 100.0 1,200.0 1,200.0 1, 182.0 Total Receivables 6,260.0 6,528. 6,573.0 7,226.0 6,982.0 nventory 8,956.0 8,899.0 9,565.0 9,333.0 9,563.0 Restricted Cash 185.0 202.0 190.0 184.0 175.0 Other Current Assets $75.0 323.0 733.0 934.0 829.0 Total Current Assets 25,883.0 19,753.0 17,846.0 18,700.0 18,326.0 Gross Property, Plant & Equipment 21, 148.0 20,855.0 21,960.0 22,018.0 46,780.0 Accumulated Depreciation 7,713.0) 8, 108.0) 9,549.0 (10,040.0 (12, 100.0 Net Property, Plant & Equipment 13,435.0 12,747.0 12,411.0 11,978.0 34,680.0 Long-term Investments 6, 177.0 6,320.0 6,610.0 6,924.0 7, 121.0 Goodwill 15,527.0 15,632.0 16,914.0 16,560.0 14,948.0 Other Intangibles 11,202.0 11,051.0 13,283.0 12,376.0 10, 183.0 Other Long-Term Assets 464.0 506.0 1,060.0 1,060.0 1, 186.0 Total Assets 72,688.0 66,009.0 68,124.0 67,598.0 86,444.0 LIABILITIES Accounts Payable 11,000.0 12,494.0 13,566.0 14,341.0 14,033.0 Accrued Exp. 1,398.0 5,454.0 5,858.0 5,388.0 5,785.0 Short-term Borrowings 260.0 251.0 1,717.0 4,488.0 3,885.0 Curr. Port. of LT Debt 63.0 0.0 249.0 1,250.0 494.0 Curr. Port. of Leases 0.0 0.0 0.0 80.0 2,335.0 Curr. Income Taxes Payable 206.0 329.0 273.0 216.0 87.0 Other Current Liabilities 4,086.0 19.0 4.0 6.0 28. Total Current Liabilities 17,013.0 18,547. 21,667.0 25,769.0 26,647.0 ong-Term Debt 18,705.0 12,684.0 12,432.0 11,098.0 12, 119.0 ong0.OTerm Leases 0.0 0.0 0.0 1,324.0 22,951.0 Pension & Other Post-Retire. Benefits 184.0 171.0 164.0 183.0 0.0 Def. Tax Liability, Non-Curr. 2,644.0 2,281.0 1,815.0 1,785.0 1,538.0 Other Non-Current Liabilities 3,861.0 4,052.0 5,357.0 3,286.0 1,867.0 Total Liabilities 42,407.0 37,735.0 41,435.0 43,445.0 65,122.0 Common Stock 12.0 12.0 12.0 12.0 12.0 Additional Paid In Capital 10, 111.0 10,339.0 10,493.0 10,639.0 10,726.0 Retained Earnings 27,684.0 30, 137.0 33,551.0 35, 815.0 34,244.0 Treasury Stock (4,934.0) 9,971.0 ) (15,047.0) (19,057.0) (20,375.0) Comprehensive Inc. and Other (2,993.0) (3,051.0) (3,002.0) (3,897.0 (3,871.0) Total Common Equity 29,880.0 27,466.0 26,007.0 23,512.0 20,736.0

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

Accounting

Accounting

Authors: Peter J Eisen

6th Edition

143800138X, 978-1438001388

More Books

Students also viewed these Accounting questions

Question

★★★★★
During your audit of the inventory account, you notice several adjustments made to the inventory account at the year-end. a. Identify several questions that you should ask of management regarding the...

Answered: 1 week ago

Question

★★★★★
Set out below are ratios relating to three different businesses. Each business operates within a different industrial sector. Ratio A plc B plc C plc Operating profit margin 3.6% 9.7% 6.8% Sales to...

Answered: 1 week ago

Question

★★★★★
Summarize the research on the roles of rules, procedures, consequences, and the design of the physical space in classroom management, with special attention to establishing your management system...

Answered: 1 week ago

Question

★★★★★
You are assessing internal control in the audit of the payroll and personnel cycle for Rogers Products Company, a manufacturing company specializing in assembling computer parts. Rogers employs...

Answered: 1 week ago

Question

★★★★★
how do you calculate total gross margin

Answered: 1 week ago

Question

★★★★★
At December 31, 2022, Palestine Commercial Bank reports the following balance sheet information: Current assets $800,000 Noncurrent assets 2,600,000 Goodwill 300,000 Current liabilities (700,000)...

Answered: 1 week ago

Question

★★★★★
Question 1: What is Ohms Law and how is it mathematically represented? Question 2: Explain Kirchhoffs Current Law (KCL) and Kirchhoffs Voltage Law (KVL). Question 3:What is Thevenins Theorem and how...

Answered: 1 week ago

Question

★★★★★
Q1: What is performance measurement in accounting? Q2: What are Key Performance Indicators (KPIs), and why are they important?

Answered: 1 week ago

Question

★★★★★
Q1: What are the main financial statements, and what information do they provide? Q2: Why is the cash flow statement important, and how does it differ from the income statement?

Answered: 1 week ago

Question

★★★★★
Q1: What are Generally Accepted Accounting Principles (GAAP)? Q2: What is the difference between GAAP and International Financial Reporting Standards (IFRS)?

Answered: 1 week ago

Question

★★★★★
Q1: What is cost accounting, and why is it important for businesses? Q2: Explain the difference between fixed costs and variable costs with examples.

Answered: 1 week ago

Question

★★★★★
3. Find examples from your everyday life of people or situations that fit the Ithaca Syndrome.

Answered: 1 week ago

Question

★★★★★
1. Discuss the following: a) If you want stability, you should focus on change. b) What happens when an effect becomes a cause? c) If you do the opposite of what is expected, the reaction is changed....

Answered: 1 week ago

Question

★★★★★
2. In this chapter, the reader should reflect on the following concepts: Systemic, positive feedback loop, negative feedback loop, negative feed-back loop dominance, positive feedback loop dominance,...

Answered: 1 week ago

Previous Question Next Question