Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Give a Horizontal Analysis for CVS and Walgreens CVS Balance Sheet All numbers in thousands Period Ending 12/31/2017 12/31/2016 12/31/2015 Current Assets Cash And

Please Give a Horizontal Analysis for CVS and Walgreens

CVS

Balance Sheet

All numbers in thousands

Period Ending

12/31/2017

12/31/2016

12/31/2015

Current Assets

Cash And Cash Equivalents

1,696,000

3,371,000

2,459,000

Short Term Investments

111,000

87,000

88,000

Net Receivables

13,181,000

12,164,000

11,888,000

Inventory

15,296,000

14,760,000

14,001,000

Other Current Assets

945,000

660,000

722,000

Total Current Assets

31,229,000

31,042,000

29,158,000

Long Term Investments

-

-

-

Property Plant and Equipment

10,292,000

10,175,000

9,855,000

Goodwill

38,451,000

38,249,000

38,106,000

Intangible Assets

13,630,000

13,511,000

13,878,000

Accumulated Amortization

-

-

-

Other Assets

1,529,000

1,485,000

1,440,000

Deferred Long Term Asset Charges

-

-

-

Total Assets

95,131,000

94,462,000

92,437,000

Current Liabilities

Accounts Payable

15,472,000

14,883,000

14,319,000

Short/Current Long Term Debt

15,176,000

11,367,000

8,850,000

Other Current Liabilities

-

-

-

Total Current Liabilities

30,648,000

26,250,000

23,169,000

Long Term Debt

22,181,000

25,615,000

26,267,000

Other Liabilities

1,611,000

1,549,000

1,542,000

Deferred Long Term Liability Charges

2,996,000

4,214,000

4,217,000

Minority Interest

4,000

4,000

7,000

Negative Goodwill

-

-

-

Total Liabilities

57,440,000

57,632,000

55,202,000

Stockholders' Equity

Misc. Stocks Options Warrants

-

-

39,000

Redeemable Preferred Stock

-

-

-

Preferred Stock

-

-

-

Common Stock

17,000

17,000

17,000

Retained Earnings

43,556,000

38,983,000

35,506,000

Treasury Stock

-37,765,000

-33,452,000

-28,886,000

Capital Surplus

32,079,000

31,618,000

30,948,000

Other Stockholder Equity

-196,000

-336,000

-389,000

Total Stockholder Equity

37,691,000

36,830,000

37,196,000

Net Tangible Assets

-14,390,000

-14,930,000

-14,788,000

Income Statement

All numbers in thousands

Revenue

12/31/2017

12/31/2016

12/31/2015

Total Revenue

184,765,000

177,526,000

153,290,000

Cost of Revenue

156,220,000

148,669,000

126,762,000

Gross Profit

28,545,000

28,857,000

26,528,000

Operating Expenses

Research Development

-

-

-

Selling General and Administrative

-

-

-

Non Recurring

-

-

-

Others

-

-

-

Total Operating Expenses

-

-

-

Operating Income or Loss

9,517,000

10,366,000

9,475,000

Income from Continuing Operations

Total Other Income/Expenses Net

-208,000

-671,000

-21,000

Earnings Before Interest and Taxes

9,309,000

9,695,000

9,454,000

Interest Expense

1,041,000

1,058,000

838,000

Income Before Tax

8,268,000

8,637,000

8,616,000

Income Tax Expense

1,637,000

3,317,000

3,386,000

Minority Interest

4,000

4,000

7,000

Net Income From Continuing Ops

6,631,000

5,320,000

5,230,000

Non-recurring Events

Discontinued Operations

-8,000

-1,000

9,000

Extraordinary Items

-

-

-

Effect Of Accounting Changes

-

-

-

Other Items

-

-

-

Net Income

Net Income

6,622,000

5,317,000

5,237,000

Preferred Stock And Other Adjustments

-

-

-

Net Income Applicable To Common Shares

6,622,000

5,317,000

5,237,000

Walgreens

Income Statement

All numbers in thousands

Revenue

8/31/2017

8/31/2016

8/31/2015

Total Revenue

118,214,000

117,351,000

103,444,000

Cost of Revenue

89,052,000

87,477,000

76,691,000

Gross Profit

29,162,000

29,874,000

26,753,000

Operating Expenses

Research Development

-

-

-

Selling General and Administrative

23,605,000

23,873,000

22,085,000

Non Recurring

-

-

-

Others

-

-

-

Total Operating Expenses

-

-

-

Operating Income or Loss

5,557,000

6,001,000

4,668,000

Income from Continuing Operations

Total Other Income/Expenses Net

-11,000

-261,000

1,248,000

Earnings Before Interest and Taxes

5,546,000

5,740,000

5,916,000

Interest Expense

693,000

596,000

605,000

Income Before Tax

4,853,000

5,144,000

5,311,000

Income Tax Expense

752,000

953,000

1,032,000

Minority Interest

808,000

401,000

439,000

Net Income From Continuing Ops

4,078,000

4,173,000

4,220,000

Non-recurring Events

Discontinued Operations

-

-

-

Extraordinary Items

-

-

-

Effect Of Accounting Changes

-

-

-

Other Items

-

-

-

Net Income

Net Income

4,078,000

4,173,000

4,220,000

Preferred Stock And Other Adjustments

-

-

-

Net Income Applicable To Common Shares

4,078,000

4,173,000

4,220,000

Balance Sheet

All numbers in thousands

Period Ending

8/31/2017

8/31/2016

8/31/2015

Current Assets

Cash And Cash Equivalents

3,301,000

9,807,000

3,000,000

Short Term Investments

-

-

-

Net Receivables

6,528,000

6,260,000

6,849,000

Inventory

8,899,000

8,956,000

8,678,000

Other Current Assets

1,025,000

860,000

1,130,000

Total Current Assets

19,753,000

25,883,000

19,657,000

Long Term Investments

6,320,000

6,174,000

1,242,000

Property Plant and Equipment

13,642,000

14,335,000

15,068,000

Goodwill

15,632,000

15,527,000

16,372,000

Intangible Assets

10,156,000

10,302,000

12,351,000

Accumulated Amortization

-

-

-

Other Assets

506,000

467,000

4,092,000

Deferred Long Term Asset Charges

-

-

-

Total Assets

66,009,000

72,688,000

68,782,000

Current Liabilities

Accounts Payable

18,296,000

16,690,000

15,489,000

Short/Current Long Term Debt

251,000

323,000

1,068,000

Other Current Liabilities

-

-

-

Total Current Liabilities

18,547,000

17,013,000

16,557,000

Long Term Debt

12,684,000

18,705,000

13,315,000

Other Liabilities

4,223,000

4,045,000

4,072,000

Deferred Long Term Liability Charges

2,281,000

2,644,000

3,538,000

Minority Interest

808,000

401,000

439,000

Negative Goodwill

-

-

-

Total Liabilities

37,735,000

42,407,000

37,482,000

Stockholders' Equity

Misc. Stocks Options Warrants

-

-

-

Redeemable Preferred Stock

-

-

-

Preferred Stock

-

-

-

Common Stock

12,000

12,000

12,000

Retained Earnings

30,137,000

27,684,000

25,089,000

Treasury Stock

-9,971,000

-4,934,000

-3,977,000

Capital Surplus

10,339,000

10,111,000

9,953,000

Other Stockholder Equity

-3,051,000

-2,993,000

-216,000

Total Stockholder Equity

27,466,000

29,880,000

30,861,000

Net Tangible Assets

1,678,000

4,051,000

2,138,000

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

Portfolio Of Marketing Audits Company Self Assessment Audits

Authors: David Crosby

1st Edition

1902433157, 978-1902433158

More Books

Students also viewed these Accounting questions

Question

=+b. What proportion of these patients had at most two impairments?

Answered: 1 week ago

Question

6. Identify characteristics of whiteness.

Answered: 1 week ago

Question

9. Explain the relationship between identity and communication.

Answered: 1 week ago