Plese give a conclusion and recommendation for investment for CVS & Walgreens. Please reposnd in a paragraph or four or more senetences.
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 |
Solution:
The investment decision in a company is depending upon the performance ratios of the company. In the given case the various performance ratios of CVS company are as follows:
Net Profit Margin = (Net Profit/Total Revenue) *100 = (6622000/184765000)*100 = 3.58% in 2017
Gross Profit Ratio = = (Gross Profit/Total Revenue) *100 = (28545000/184765000)*100 = 15.45% in 2017
Return on Equity = (Net Profit/Total Equity)*100 = (6622000/37691000)*100 = 17.57% in 2017.
Debt-Equity = (Total Debt/Total Equity) = 57440000/37691000 = 1.53
In other hand the various performance ratio of Walgreens are as follows:
Net Profit Margin = (Net Profit/Total Revenue) *100 = (4078000/118214000)*100 = 3.45% in 2017
Gross Profit Ratio = = (Gross Profit/Total Revenue) *100 = (29162000/118214000)*100 = 24.67% in 2017
Return on Equity = (Net Profit/Total Equity)*100 = (4078000/27466000)*100 = 14.84% in 2017.
Debt-Equity = (Total Debt/Total Equity) = 37735000/27466000 = 1.37
The best investment option is CVS company as the net profit margin. Gross profit margin and return on equity is more than Walgreens. But the higher debt equity ratio of CVS represents the high risk involve in the investment in the CVS company.
Get Answers For Free
Most questions answered within 1 hours.