please help with ratios I was able to a quite all other info.

U Calibri $ % 75% 0 .00 123 fx Data Sheet/Analysis F D E B Prior Year Balances ann. Repo Current Year Balances page # Balance Sheet Data (most Recent) (S in Millions) 5 Cash 6 Marketable Securities Accounts Receivable 18 Inventory Other Current Assets 20 Total Current Assets Property, Plant, and Equipment Other Long-term Assets Total Assets Accounts Payable Other Current Liabilities Total Current Liabilities Long-term Liabilities Total Liabilities Common Stock and Paid-in Capital Preferred Stock and Paid-In Capital Total Retained Earnings 62 Total Stockholders' Equity 33 Total Liabilities and Equity # of Common Shares Outstanding $42,122 $42,274 $24,542 $23,795 $22,778 $132,733 $113,114 $75,348 $321,195 $72,549 S53,846 $126,395 $101,406 $227,801 $42,865 $36,092 $18,929 $20,816 $20,497 $16,314 $96,334 $72,705 $56,209 $225,248 $47,183 $40,629 $87,812 $75,376 $163,188 $33,658 $52,551 593,404 $321, 205 $503 531,220 $62,060 $225, 248 $498 35 36 37 38 39 DI LOLOL! Income Statement Data (most recent) (S in Millions) Net Sales Cost of Goods Sold Gross Profit Income from Operations Interest Expense Income Tax Expense Net Income Earnings per Share 40 $386,064 $363,165 $942,400 $22,899 -$1,647 $2,863 $21,331 $280,522 $265,981 $747,540 $14,541 -$1,600 $2,374 $11,588 523 41 42 43 4 $43 45 47 48 Cash Flow Statement (most recent) Cash flows from: Operating Activities Investing Activities Financing Activities $21,331 $66,064 -S59,611 -$1,104 $11,588 538,514 -524 281 -S10,066 50 51 52 $504 Common Dividend's Preferred Dividends Year-end Market Price per Share $510 SO $3,257 UT 54 55 51,848 56 Current year beginning balances are the same as previous year ending balances Horizontal Analysis -- Balance Sheet Cash Percentage Change 60 son A B C D E 56 Current year beginning balances are the same as previous year ending balances 58 59 60 Horizontal Analysis - Balance Sheet Cash Marketable Securities Accounts Receivable Percentage Change 16.70% 123% 17.9% % 61 16.1% 39.66 37.86 55.60 3496 42.696 53.896 Inventory Other Current Assets Current Assets Property, Plant, and Equipment Other Long-term Assets Total Assets Accounts Payable Other Current Liabilities Current liabilities Long-term Liabilities Total Liabilities Common Stock and Paid-in Capital Preferred Stock and Paid-In Capital Total Retained Earnings Total Stockholders' Equity Total Liabilities and Equity 32.596 48.99% 34.596 39.596 096 68.394 50 50 42.696 A A B c D E 80 B2 37.6% 36.5% Horizontal Analysis -- Income Statement Net Sales Cost of Goods Sold Gross Profit Income from Operations Interest Expense Income Tax Expense Net Income Earnings per Share 57.5% B5 2.9% 20.6% 84.1% 86.96% Bal Sheet Vertical Analysis current year Percentage Marketable Securities Accounts Receivable 13.196 13.296 35.29: Inventory Other Current Assets Current Assets Property, Plant, and Equipment Other Long-term Assets Total Assets Accounts Payable Other Current Liabilities Current Liabilities Long-term Liabilities Total Liabilities Common Stock and Paid-in Capital Preferred Stock and Paid-in Capital 31.8% 23.596 55.598 44.5% 1005 Edit View Insert Format Data Tools 75% $ % . .09 123- A1 fx Data Sheet/Analysis B D 41.36 29.5% 100% 31.896 Other Current Assets Current Assets Property, Plant, and Equipment Other Long-term Assets Total Assets Accounts Payable Other Current Liabilities Current Liabilities Long-term Liabilities Total Liabilities Common Stock and Paid-in Capital Preferred Stock and Paid-In Capital Total Retained Earnings Total Stockholders' Equity Total Liabilities and Equity 23.66 55.5% 44.5% 13.3% 10096 Inc. Stmt Vertical Analysis current year Net Sales Cost of Goods Sold Gross Profit Income from Operations Interest Expense Income Tax Expense Net Income 5.996 0496 Ratios: Liquidity Analysis Working Capita 75% Calibri 16 % 0 .00 123- A Data Sheet/Analysis A1 A B C D F 121 Net Income 5.5% 123 Ratios: 124 Liquidity Analysis 125 Working Capital 126 Current Assets Current Liabilities 129 Current Ratio Numerator Denominator Acid-test (Quick) Ratio Numerator Denominator 136 138 Asset Management Accounts Receivable Turnover Numerator Denominator Days! Sales Uncollected Numerator Denominator Inventory Turnover Numerator Denominator Data Sheet A1 Data Sheet/Analysis E F G A B 149 Denominator 149 150 Day's Sales in Inventory 151 Numerator Denominator 152 153 1154 1155 Long-Term Solvency Debt Ratio 156 157 Numerator Denominator Equity Ratio Numerator Denominator Debt to Equity Ratio 165 Numerator 166 Denominator 167 168 Times Interest Earned 169 Numerator Denominator Profitability Profit Margin Ratio Numerator Denominator B D F Denominator 6 Gross Margin Ratio 18 Numerator Denominator 20 31 Return on Total Assets Numerator Denominator 35 Retum on Common Equity Numerator Denominator 37 Book Value per Common Share Numerator Denominator Basic Earnings per Common Share Numerator Denominator Market Strength Price Earnings Ratio Numerator Denominator 2. 75% $ % 0 .00 123- Calibri 16 fx Data Sheet/Analysis A B E F 192 193 1194 Basic Earnings per Common Share Numerator Denominator 195 195 198 Market Strength Price-Earnings Ratio Numerator Denominator Dividend Yield Numerator Denominator 20