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.

Get help from top-rated tutors in any subject.

Efficiently complete your homework and academic assignments by getting help from the experts at homeworkarchive.com