In: Accounting
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  |