Question

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

Answer 1

Common size analysis
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	1.78	3,371,000	3.57	2,459,000	2.66
Short Term Investments	111,000	0.12	87,000	0.09	88,000	0.10
Net Receivables	13,181,000	13.86	12,164,000	12.88	11,888,000	12.86
Inventory	15,296,000	16.08	14,760,000	15.63	14,001,000	15.15
Other Current Assets	945,000	0.99	660,000	0.70	722,000	0.78
Total Current Assets	31,229,000	32.83	31,042,000	32.86	29,158,000	31.54
Long Term Investments	-		-		-
Property Plant and Equipment	10,292,000	10.82	10,175,000	10.77	9,855,000	10.66
Goodwill	38,451,000	40.42	38,249,000	40.49	38,106,000	41.22
Intangible Assets	13,630,000	14.33	13,511,000	14.30	13,878,000	15.01
Accumulated Amortization	-		-		-
Other Assets	1,529,000	1.61	1,485,000	1.57	1,440,000	1.56
Deferred Long Term Asset Charges	-		-		-
Total Assets	95,131,000	100	94,462,000	100	92,437,000	100
Current Liabilities
Accounts Payable	15,472,000	16.26	14,883,000	15.76	14,319,000	15.49
Short/Current Long Term Debt	15,176,000	15.95	11,367,000	12.03	8,850,000	9.57
Other Current Liabilities	-		-		-
Total Current Liabilities	30,648,000	32.22	26,250,000	27.79	23,169,000	25.06
Long Term Debt	22,181,000	23.32	25,615,000	27.12	26,267,000	28.42
Other Liabilities	1,611,000	1.69	1,549,000	1.64	1,542,000	1.67
Deferred Long Term Liability Charges	2,996,000	3.15	4,214,000	4.46	4,217,000	4.56
Minority Interest	4,000	0.004	4,000	0.004	7,000	0.008
Negative Goodwill	-		-		-
Total Liabilities	57,440,000	60.38	57,632,000	61.01	55,202,000	59.72
Stockholders' Equity
Misc. Stocks Options Warrants	-		-		39,000
Redeemable Preferred Stock	-		-		-
Preferred Stock	-		-		-
Common Stock	17,000	0.02	17,000	0.02	17,000	0.02
Retained Earnings	43,556,000	45.79	38,983,000	41.27	35,506,000	38.41
Treasury Stock	-37,765,000	-39.70	-33,452,000	-35.41	-28,886,000	-31.25
Capital Surplus	32,079,000	33.72	31,618,000	33.47	30,948,000	33.48
Other Stockholder Equity	-196,000	-0.21	-336,000	-0.36	-389,000	-0.42
Total Stockholder Equity	37,691,000	39.62	36,830,000	38.99	37,196,000	40.24
Total liabilities & stockholder equity	95,131,000	100	94,462,000	100	92,398,000	100
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	100	177,526,000	100	153,290,000	100
Cost of Revenue	156,220,000	84.55	148,669,000	83.74	126,762,000	82.69
Gross Profit	28,545,000	15.45	28,857,000	16.26	26,528,000	17.31
Operating Expenses
Research Development	-		-		-
Selling General and Administrative	-		-		-
Non Recurring	-		-		-
Others	-		-		-
Total Operating Expenses	-		-		-
Operating Income or Loss	9,517,000	5.15	10,366,000	5.84	9,475,000	6.18
Income from Continuing Operations
Total Other Income/Expenses Net	-208,000	-0.11	-671,000	-0.38	-21,000	-0.01
Earnings Before Interest and Taxes	9,309,000	5.04	9,695,000	5.46	9,454,000	6.17
Interest Expense	1,041,000	0.56	1,058,000	0.60	838,000	0.55
Income Before Tax	8,268,000	4.47	8,637,000	4.87	8,616,000	5.62
Income Tax Expense	1,637,000	0.89	3,317,000	1.87	3,386,000	2.21
Minority Interest	4,000	0.24	4,000	0.12	7,000	0.21
Net Income From Continuing Ops	6,631,000	3.59	5,320,000	3.00	5,230,000	3.41
Non-recurring Events
Discontinued Operations	-8,000	-0.004	-1,000	-0.001	9,000	0.006
Extraordinary Items	-		-		-
Effect Of Accounting Changes	-		-		-
Other Items	-		-		-
Net Income
Net Income	6,622,000	3.58	5,317,000	3.00	5,237,000	3.42
Preferred Stock And Other Adjustments	-		-		-
Net Income Applicable To Common Shares	6,622,000	3.58	5,317,000	3.00		0.00
The total assets for Balance sheet and total revenue for Income statement is taken as base which is 100%. Than all the line items
% is calculated
For example COGS for 2017=156220000/184765000*100=84.55%
CAsh for 2017=1696000/95131000*100	1.78
Line item amt/base amt*100 is the formula used