assignment 11 Word analysis

profile1nj0h4783i9
302assignment112.xls
Home>Business & Finance homework help>Accounting homework help>assignment 11 Word analysis

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