Analyze the data

Muriel111111
assignment12.xls
Home>Business & Finance homework help>Accounting homework help>Analyze the data

Sheet1

RATIO ANALYSIS SPREADSHEET = Pos,Neu,Neg
Company PEP
2017__ 2016__ 2015__ 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 31,027 1.51 26,150 1.24 23,031 1.31
Current Liabilities 20,502 21,135 17,578
2 Debt-to-Equity Margin of Safety to Creditors
Total Liabilities 68,823 6.23 62,291 5.54 57,637 4.78
Equity 11,045 11,246 12,068
INCOME STATEMENT RATIOS: Profitability (Earning Power)
3 Gross Margin Gross Profit expressed as a % of Sales
Gross Profit 34,740 54.7% 34,590 55.1% 34,325 54.4%
Sales 63,525 62,799 63,056 54.3%
4 Operating Profit Margin Operating Profit expressed as a % of Sales
Operating Profit 10,578 10,483 10,009
Sales 63,525 16.7% 62,799 16.7% 63,056 15.9% 15.9%
5 Net Margin Net Profit expressed as a % of Sales
Net Income 4,857 7.6% 6,329 10.1% 5,452 8.6%
Sales 63,525 62,799 63,056 7.7%
ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios
6 Earnings Quality Measures cash generated from sales; higher % the better
Cash flow from Operations 9,994 206% 10,673 169% 10,864 199%
Net Income 4,857 6,329 5,452 n/a
7 Return on Assets Measures the profitability of using the assets
Net Income 4,857 6.1% 6,329 8.6% 5,452 7.8%
Total Assets 79,804 73,490 69,667
8 Return on Equity Measures the profitability of the stockholders investment
Net Income 4,857 44.0% 6,329 56.3% 5,452 45.2%
Equity 11,045 11,246 12,068
ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios
9 Inventory Turnover Measures the efficiency of moving the inventory
Cost of Revenue/Goods Sold 28,785 10 28,209 10 28,731 11
Inventory 2,947 2,723 2,720
10 Inventory Turn-Days Average # of days it takes to move inventory
360 360 36.86 360 34.75 360 34.08
Inventory Turnover 10 10 11 -
11 Accounts Receivable Turnover Measures the efficiency of collecting Accounts Receivable
Sales 63,525 9.04 62,799 9.38 63,056 9.80
Accounts Receivable 7,024 6,694 6,437
12 Accounts Receivable Turn-Days Average # of days it takes to collect Accounts Receivable
360 360 40 360 38 360 37
Accts. Rec. Turnover 9 9 10 -
13 Accounts Payable Turnover Measures the efficiency of paying Accounts Payable
Cost of Revenue/Goods Sold 28,785 4.28 28,209 4.58 28,731 5.18
Accounts Payable 6,727 6,158 5,546 n/a
14 Average Payment Period Average # of days it takes to pay Accounts Payable
360 360 84 360 79 360 69
Accts. Pay. Turnover 4 5 5

Sheet2

Sheet3