Sheet1RATIO_ANALYSIS_SPREADSHEET_PosNeuNegCompanyP_

Sheet1

RATIO ANALYSIS SPREADSHEET					= Pos,Neu,Neg
Company	P & G
			2018		2017		2016		Industry
									Average
BALANCE SHEET RATIOS: Stability (Staying Power)									Access csimarket.com and query by stock symbol
1	Current									Ability to meet current obligations
		Current Assets	23,320	0.83	26,494	0.88	33,782	1.10
		Current Liabilities	28,237		30,210		30,770		1.19
2	Debt-to-Equity									Margin of Safety to Creditors
		Total Liabilities	65,427	1.27	64,628	1.19	69,153	1.23
		Equity	51,326		54,178		56,303		0.12
INCOME STATEMENT RATIOS: Profitability (Earning Power)
3	Gross Margin									Gross Profit expressed as a % of Sales
		Gross Profit	33,383	50.0%	33,116	50.9%	32,390	49.6%
		Sales	66,832		65,058		65,299		54.7%
4	Operating Profit Margin									Operating Profit expressed as a % of Sales
		Operating Profit	14,781		14,685		13,454
		Sales	66,832	22.1%	65,058	22.6%	65,299	20.6%	17.5%
5	Net Margin									Net Profit expressed as a % of Sales
		Net Income	9,750	14.6%	15,326	23.6%	10,508	16.1%
		Sales	66,832		65,058		65,299		16.1%
ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios
6	Earnings Quality									Measures cash generated from sales; higher % the better
		Cash flow from Operations	14,867	152%	12,753	83%	15,435	147%
		Net Income	9,750		15,326		10,508		n/a
7	Return on Assets									Measures the profitability of using the assets
		Net Income	9,750	8.2%	15,326	12.7%	10,508	8.3%
		Total Assets	118,310		120,406		127,136		10.5%
8	Return on Equity									Measures the profitability of the stockholders investment
		Net Income	9,750	19.0%	15,326	28.3%	10,508	18.7%
		Equity	51,326		54,178		56,303		27.1%
ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios
9	Inventory Turnover									Measures the efficiency of moving the inventory
		Cost of Revenue/Goods Sold	33,449	7	31,942	7	32,909	7
		Inventory	4,738		4,624		4,716		5
10	Inventory Turn-Days									Average # of days it takes to move inventory
		360	360	50.99	360	52.11	360	51.59
		Inventory Turnover	7		7		7		73.02
11	Accounts Receivable Turnover									Measures the efficiency of collecting Accounts Receivable
		Sales	66,832	14.26	65,058	14.16	65,299	14.93	9.73
		Accounts Receivable	4,686		4,594		4,373
12	Accounts Receivable Turn-Days									Average # of days it takes to collect Accounts Receivable
		360	360	25	360	25	360	24
		Accts. Rec. Turnover	14		14		15		37
13	Accounts Payable Turnover									Measures the efficiency of paying Accounts Payable
		Cost of Revenue/Goods Sold	33,449	3.23	31,942	3.32	32,909	3.53
		Accounts Payable	10,344		9,632		9,325		n/a
14	Average Payment Period									Average # of days it takes to pay Accounts Payable
		360	360	111	360	109	360	102
		Accts. Pay. Turnover	3		3		4

Sheet2

Sheet3

· Visit two e-commerce websites of your choice, and apply the social marketing process model (outlined on pp. 431–432) to both. Critically compare and contrast the effectiveness of these sites in terms of the dimensions of the social marketing process. Address the questions below in your paper.

1. How well do these sites acquire fans, generate engagement, amplify responses, create a community, and strengthen their brands?

1. What recommendations can you make for these sites to improve their effectiveness at a global and local level?

Your paper must be at least three pages in length; the title and reference pages do not count toward meeting the minimum length requirement. Make sure your essay follows APA format. You must use a minimum of two external sources, which can include the two websites that you choose to review. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations.

blog2

Sheet1

Sheet2

Sheet3

Get help from top-rated tutors in any subject.