Question

In: Accounting

Please Give a Verticle Analysis for CVS and Walgreens. CVS Balance Sheet All numbers in thousands...

Please Give a Verticle 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

Solutions

Expert Solution


Related Solutions

a. Please Give a Horizontal Analysis for CVS and Walgreens CVS Balance Sheet All numbers in...
a. 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...
a. Please give me a common-sized financial analysis for the CVS company CVS Balance Sheet All...
a. Please give me a common-sized financial analysis for the CVS company 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...
a. Please create a comparitive financial analysis for the Walgreen's company? Walgreens Income Statement All numbers...
a. Please create a comparitive financial analysis for the Walgreen's company? 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...
The Balance Sheet for CVS Health Review your company’s balance sheet and please respond to the...
The Balance Sheet for CVS Health Review your company’s balance sheet and please respond to the following 3 questions: 1) Examine your company’s current, long-term, and intangible assets. Discuss the more significant ones for your company. Discuss any observable trends over recent fiscal years. 2) What were the company's primary liabilities as displayed on the balance sheet for the most recent fiscal year? Comment on the trend in total liabilities, both current and long-term. 3) Notes to the financial statements:...
What is a Balance Sheet? What is the nature of the Balance Sheet? Please give an...
What is a Balance Sheet? What is the nature of the Balance Sheet? Please give an example by reviewing a Balance Sheet of any corporation and sharing it through the platform. Does the organization have more liability than owner's or stock equity? Does the company Assets show more current assets than long-term assets?
Partial Classified Balance Sheet for Walgreens The following items, listed alphabetically, appear on Walgreens Boots Alliance,...
Partial Classified Balance Sheet for Walgreens The following items, listed alphabetically, appear on Walgreens Boots Alliance, Inc consolidated balance sheet at August 31, 2015 (in millions): Accrued expenses and other liabilities $5,225 Deferred income taxes (long-term) 3,538 Long-term debt 13,315 Other non-current liabilities 4,072 Short-term borrowings 1,068 Trade accounts payable 10,088 Income taxes 176 Source: Walgreens, 2015 Form 10-K. Required: 1. Prepare the Current Liabilities and Long-Term Liabilities sections of Walgreens's classified balance sheet at August 31, 2015. Enter your...
Use the following balance sheet information to answer this question. Balance Sheet (dollars in thousands) and...
Use the following balance sheet information to answer this question. Balance Sheet (dollars in thousands) and Duration (in years) Duration Amount T-bills 0.5 90 T-notes 0.9 55 T-bonds 4.393 176 Loans 7 2,724 Deposits 1 2,092 Federal funds 0.01    238 Equity 715 A )What is the average duration of all the assets? B )What is the average duration of all the liabilities? C )What is the FI’s leverage-adjusted duration gap? What is the FI’s interest rate risk exposure? D...
Stealcase’s Balance Sheet, as of December 31(thousands of dollars)                                 
Stealcase’s Balance Sheet, as of December 31(thousands of dollars)                                              2017      2018                                                                            2017      2018 Cash                                 30            25                  Account Payable                                  35          50 Accts Receivable          5              20                  Bank Loan                                            25           25 Inventory                        100         100                Accrued Taxes                                   15          25 Current Assets              135          245                Long Term, Dept current portion    12         12                                                                                  Current Liabilities                                87         112 Net Plant & Equip           200          250                 Long-Term Dept                                100        95                                                                                  Common Stock (10,000 shares)    100      100                                                                                 Additional paid-in...
3.  Problem 3-11 (Balance Sheet Analysis) Balance Sheet Analysis Complete the balance sheet and sales information in...
3.  Problem 3-11 (Balance Sheet Analysis) Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.7 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 30% Total liabilities-to-assets ratio: 40% Quick ratio: 0.90 Days' sales outstanding (based on 365-day year): 36.5 days Inventory turnover ratio: 3.25 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial...
Below are numbers from a balance sheet and income statement. Based on these numbers calculate the...
Below are numbers from a balance sheet and income statement. Based on these numbers calculate the financial ratios requested below. All answers must be rounded to TWO decimal places including percentages Sales 421756 Operating Costs 313053 Depreciation Expense 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 52175 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 62175 Based on these values calculate: Current ratio Quick ratio NWC-to-total-Assets (Working capital to assets)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT