a. Current Ratio
b. Quick Ratio
c. Days Accounts Receivable
d. Day Inventory
e. Days Accounts Payable
f. Liabilities to Asset Ratio
g. Liabilities to Shareholdersâ Equity Ratio
h. Long Term Debt Ratio to Long-Term Capital Ratio
i. Operating Cash Flow to Total Liabilities Ratio
j. Interest Coverage Ratio
Apply those ratios to analyze Google financial position andprovide clear interpretation on each ratio.
a. Current Ratio
b. Quick Ratio
c. Days Accounts Receivable
d. Day Inventory
e. Days Accounts Payable
f. Liabilities to Asset Ratio
g. Liabilities to Shareholdersâ Equity Ratio
h. Long Term Debt Ratio to Long-Term Capital Ratio
i. Operating Cash Flow to Total Liabilities Ratio
j. Interest Coverage Ratio
Apply those ratios to analyze Google financial position andprovide clear interpretation on each ratio.
Related questions
Explain how the ratios help identify the strengths and weaknesses of the facility and the management team.
The students will use Financial Ratios to analyze a potential strategic acquisition.
The student will use the Financial Ratios to evaluate the current management teamâs ablity to make good long term and short term decisions. Should Acme continue to employ the current management team. If Beechtree is acquired, do we keep its management team or do build a new one
| Ratio | Formula | Standard | Beechtree |
| Current Ratio (Liquidity) | Current Assets/Current Liabilities | 1.3 | 1.15 |
| Quick Ratio (liquidity) | (Current Assets-Supplies on hand)/Current Liabilities | 1.2 | .9 |
| Days Cash on Hand (liquidity) | (Cash on Hand +Market Securities)/((Tot Operating Exp-Depreciation Exp)/365) | 50 | 35 |
| Days in Net Receivable (liquidity) | (Accounts Receivable +Notes Receivable + Other Receivable-allowance for uncollectable)/(Tot Operating Revenue/365) | 49 | 65 |
| Debt Service Coverage Ratio (solvency) | Net Operating Income/(Principal +interest + lease payment | >1 | .89 |
| Operating Margin (profitability) | Operating Income/Total Operating Revenue | >.05 | -.005 |
| Return on Total Assets (profitability) | Net Operating Income/Total Assets | 1.1 | .9 |
Net Operating Income for this financial statement=Decrease in unrestricted net assets + Interest Expense + Depreciation
Show ALL work
Ratio Analysis. The Williams Corporationâs forecasted 2010 financial statements follow, along with some industry average ratios.
| Forecasted Balance Sheet as of December 31, 2010 | ||||
| Cash | $ 72,000 | |||
| Accounts receivables | $ 439,000 | Accounts and notes payable | $ 432,000 | |
| Inventories | $ 894,000 | Accruals | $ 170,000 | |
| Total current assets | $1,405,000 | Total current liabilities | $ 602,000 | |
| Land and building | $ 238,000 | Long-term debt | $ 404,290 | |
| Machinery | $ 132,000 | Common stock | $ 575,000 | |
| Other fixed assets | $ 61,000 | Retained earnings | $ 254,710 | |
| Total assets | $1,836,000 | Total liabilities and equity | $1,836,000 | |
| Forecasted Income Statement for 2010 | ||||
| Sales | $4,290,000 | |||
| Cost of goods sold | $3,580,000 | Per-Share Data | ||
| Gross operating profit | $ 710,000 | EPS | $ 4.71 | |
| General admin & selling expenses | $ 236,320 | DPS | $ 0.95 | |
| Depreciation | $ 159,000 | P/E Ratio | 5.00 | |
| Misc. | $ 134,000 | Market price | $ 23.57 | |
| Earnings before Taxes | $ 180,680 | Number of shares outstanding | 23000 | |
| Taxes | $ 72,272 | |||
| Net Income | $ 108,408 | |||
| Industry Financial Ratios | Williamâs Financial Ratios | Ratio/Comment | ||
| Quick Ratio | 1x | Quick Ratio | ||
| Current Ratio | 2.7x | Current Ratio | ||
| Inventory Turnover | 7x | Inventory Turnover | ||
| Days Sales Outstanding | 40 days | Days Sales Outstanding | ||
| Fixed Asset Turnover | 13x | Fixed Asset Turnover | ||
| Total Asset Turnover | 2.6x | Total Asset Turnover | ||
| Return on Assets | 9.10% | Return on Assets | ||
| Return on Equity | 18.20% | Return on Equity | ||
| Debt Ratio | 55% | Debt Ratio | ||
| Profit Margin on Sales | 3.50% | Profit Margin on Sales | ||
| P/E Ratio | 6x | P/E Ratio |
Please show all work for the following questions.
a. Calculate the indicated ratios for Williamâs in the appropriate blanks.
b. Outline Williamâs strengths and weaknesses as compared to its industry. Be detailed in your ratio analysis.
c. Recommend at least three areas for correction. Be sure to support your recommendations.
d. Why is being trustworthy essential to success in the business world? Use at least two of the following scriptures to answer this question: Psalm 101:7, Proverbs 4:20-27, Proverbs 13:11, and Proverbs 28:12-13.
