Ratio Analysis Situation - Assignment Example

Ratio Analysis Case Section One Return on Total Asset (ROTA) can be calculated as; ROTA = Earnings before interest and tax/total net assets (Siddiqui, 623) Net Assets = total assets – liabilities Net assets = 3,000, 000 + 2,400, 000 – 1,600, 000 = 3,800, 000 Earnings before interest and tax = 340, 000 ROTA = 340, 000/ 3,800,000 = 0.0895 Return on common stockholders’ equity = Net income divided by average common stockholders’ equity. Net income = 182, 000 Average common stockholders’ equity = (1,400, 000 + 1,272, 000) / 2 = 1,336, 000 Return on common stockholders’ equity = 182, 000 / 1,336, 000 = 0.

136 The company’s financial leverage is negative because the return on common stockholders’ equity is greater than return on total assets. Section Two Earning per share is calculated as Net income divided by number of common shares outstanding. Net income = 182, 000 Number of common shares outstanding = 800, 000/40 = 20, 000 Earning per share = 182, 000 / 20, 000 = 9.1. Dividend payout ratio for common stock = cash dividends / net income =30,000 / 182,000 = 0.165 Dividend yield ratio for common stock is calculated as the annual dividends per share of common stock divided by the market price of common stock per share (Siddiqui, 623).

Annual dividends per share = 30,000 / 800,000 = 0.0375 Market price of common stock = $ 60. Hence, dividend yield ratio for common stock would be 0.0375 / 60 = 0.000625. Price earning ratio = market price of common stock per share dividend by earnings per share (Siddiqui, 623). Therefore, price earning ratio would be equal to 60 / 9.1 = 6.59. Investors regard Stephens Company as a good investment company in the industry since the investors can earn well from their investment in shares. Although the price earning ratio of the company is below that of the industry, investors in the company will still earn, but below the industry’s earning.

Book value per share of common stock = book value of equity for common shares divided by number of common shares. Book value for common shares = (3,000,000 – 1,600,000 – 300,000) = 1,100, 000 Book value of equity per common share = 1100, 000 / 20, 000 = $55. The market value of the common shares is $60 while the book value is $55. The company’s stock is not undervalued since the stock is selling at a higher value than the book value. Gross margin percentage = gross profit / net sales (Siddiqui, 623) Gross profit = 770,000 Net sales = 2,850,000 Gross profit margin = 770,000 / 2,850,000 = 0.

27 * 100 = 27% Section Three Current ratio = current assets / current liabilities (Siddiqui, 623). =1,120,000 / 600,000 = 1.87 Acid-test ratio = quick assets / current liabilities Quick assets = (1,120,000 – 610,000) = 510,000 Therefore, acid-test ratio = 510,000 / 600,000 = 0.85 Average collection period = 365/ receivables turnover Receivable turnover = 2,850,000 / 550,000 = 5.18. Therefore, average collection period would be 365 / 5.18 = 70.4, which is equivalent to 71 days. Average sale period = (inventory * 365) / cost of sales = (590,000 + 610,000) * 365 / 2,080,000 = 1210,000 * 365 / 2080,000 = 212.

3, which is approximately 213 days. Debt to equity ratio = total liabilities divided by total stockholders’ equity. Therefore, debt to equity ratio would be equal to 1,600,000 / 1,400,000 = 1.143. Times interest earned = EBIT divided by interest charges (Siddiqui, 623). Hence, times interest earned would be equal to 340,000 / 80,000 = 4.25. Section Four From the ratio analysis, the company’s loan application for $ 500,000 should be approved since the company would be capable of meeting its liability.

This is from the analysis of the acid-test ratio and the current ratio. The company is capable of repaying the loan within the duration of five years. Work Cited Siddiqui, A. Managerial Economics and Financial Analysis. New Delhi: New Age International Publishers, 2006. Print.