Question

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 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

Answer 1

Income Statement
All numbers in thousands
			Absoulute change			Absoulute change
Revenue	8/31/2015	8/31/2016	Increase/(decrease)	% (compare to 2015)	8/31/2017	Increase/(decrease)	% (compare to 2015)
Total Revenue	103,444,000	117,351,000	13,907,000	13.4	118,214,000	14,770,000	14.3
Cost of Revenue	76,691,000	87,477,000	10,786,000	14.1	89,052,000	12,361,000	16.1
Gross Profit	26,753,000	29,874,000	3,121,000	11.7	29,162,000	2,409,000	9.0
Operating Expenses
Research Development	-	-			-
Selling General and Administrative	22,085,000	23,873,000	1,788,000	8.1	23,605,000	1,520,000	6.9
Non Recurring	-	-			-
Others	-	-			-
Total Operating Expenses	-	-			-
Operating Income or Loss	4,668,000	6,001,000	1,333,000	28.6	5,557,000	889,000	19.0
Income from Continuing Operations
Total Other Income/Expenses Net	1,248,000	-261,000			-11,000
Earnings Before Interest and Taxes	5,916,000	5,740,000	-176,000	-3.0	5,546,000	-370,000	-6.3
Interest Expense	605,000	596,000	-9,000	-1.5	693,000	88,000	14.5
Income Before Tax	5,311,000	5,144,000	-167,000	-3.1	4,853,000	-458,000	-8.6
Income Tax Expense	1,032,000	953,000	-79,000	-7.7	752,000	-280,000	-27.1
Minority Interest	439,000	401,000	-38,000	-8.7	808,000	369,000	84.1
Net Income From Continuing Ops	4,220,000	4,173,000	-47,000	-1.1	4,078,000	-142,000	-3.4
Non-recurring Events
Discontinued Operations	-	-			-
Extraordinary Items	-	-			-
Effect Of Accounting Changes	-	-			-
Other Items	-	-			-
Net Income
Net Income	4,220,000	4,173,000	-47,000	-1.1	4,078,000	-142,000	-3.4
Preferred Stock And Other Adjustments	-	-			-
Net Income Applicable To Common Shares	4,220,000	4,173,000	-47,000	-1.1	4,078,000	-142,000	-3.4
Balance Sheet
All numbers in thousands
Period Ending	8/31/2015	8/31/2016			8/31/2017
Current Assets
Cash And Cash Equivalents	3,000,000	9,807,000	6,807,000	226.9	3,301,000	301,000	10.0
Short Term Investments	-	-			-
Net Receivables	6,849,000	6,260,000	-589,000	-8.6	6,528,000	-321,000	-4.7
Inventory	8,678,000	8,956,000	278,000	3.2	8,899,000	221,000	2.5
Other Current Assets	1,130,000	860,000	-270,000	-23.9	1,025,000	-105,000	-9.3
Total Current Assets	19,657,000	25,883,000	6,226,000	31.7	19,753,000	96,000	0.5
Long Term Investments	1,242,000	6,174,000	4,932,000	397.1	6,320,000	5,078,000	408.9
Property Plant and Equipment	15,068,000	14,335,000	-733,000	-4.9	13,642,000	-1,426,000	-9.5
Goodwill	16,372,000	15,527,000	-845,000	-5.2	15,632,000	-740,000	-4.5
Intangible Assets	12,351,000	10,302,000	-2,049,000	-16.6	10,156,000	-2,195,000	-17.8
Accumulated Amortization	-	-			-
Other Assets	4,092,000	467,000	-3,625,000	-88.6	506,000	-3,586,000	-87.6
Deferred Long Term Asset Charges	-	-			-
Total Assets	68,782,000	72,688,000	3,906,000	5.7	66,009,000	-2,773,000	-4.0
Current Liabilities
Accounts Payable	15,489,000	16,690,000	1,201,000	7.8	18,296,000	2,807,000	18.1
Short/Current Long Term Debt	1,068,000	323,000	-745,000	-69.8	251,000	-817,000	-76.5
Other Current Liabilities	-	-			-
Total Current Liabilities	16,557,000	17,013,000	456,000	2.8	18,547,000	1,990,000	12.0
Long Term Debt	13,315,000	18,705,000	5,390,000	40.5	12,684,000	-631,000	-4.7
Other Liabilities	4,072,000	4,045,000	-27,000	-0.7	4,223,000	151,000	3.7
Deferred Long Term Liability Charges	3,538,000	2,644,000	-894,000	-25.3	2,281,000	-1,257,000	-35.5
Minority Interest	439,000	401,000	-38,000	-8.7	808,000	369,000	84.1
Negative Goodwill	-	-			-
Total Liabilities	37,482,000	42,407,000	4,925,000	13.1	37,735,000	253,000	0.7
Stockholders' Equity
Misc. Stocks Options Warrants	-	-			-
Redeemable Preferred Stock	-	-			-
Preferred Stock	-	-			-
Common Stock	12,000	12,000	0	0.0	12,000	0	0.0
Retained Earnings	25,089,000	27,684,000	2,595,000	10.3	30,137,000	5,048,000	20.1
Treasury Stock	-3,977,000	-4,934,000	-957,000	24.1	-9,971,000	-5,994,000	150.7
Capital Surplus	9,953,000	10,111,000	158,000	1.6	10,339,000	386,000	3.9
Other Stockholder Equity	-216,000	-2,993,000	-2,777,000	1,285.6	-3,051,000	-2,835,000	1,312.5
Total Stockholder Equity	30,861,000	29,880,000	-981,000	-3.2	27,466,000	-3,395,000	-11.0
Net Tangible Assets	2,138,000	4,051,000	1,913,000	89.5	1,678,000	-460,000	-21.5
We will take 2015 as a base to calcualte % we will take
Current year-base Year/base year *100