Your assignment is to prepare and submit a paper on ratio analysis situation. 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.