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