In: Accounting
The financial statements for Castile Products, Inc., are given below:
Castile Products, Inc. Balance Sheet December 31 |
||||||
Assets | ||||||
Current assets: | ||||||
Cash | $ | 20,000 | ||||
Accounts receivable, net | 230,000 | |||||
Merchandise inventory | 340,000 | |||||
Prepaid expenses | 7,000 | |||||
Total current assets | 597,000 | |||||
Property and equipment, net | 820,000 | |||||
Total assets | $ | 1,417,000 | ||||
Liabilities and Stockholders' Equity | ||||||
Liabilities: | ||||||
Current liabilities | $ | 240,000 | ||||
Bonds payable, 10% | 380,000 | |||||
Total liabilities | 620,000 | |||||
Stockholders’ equity: | ||||||
Common stock, $5 per value | $ | 200,000 | ||||
Retained earnings | 597,000 | |||||
Total stockholders’ equity | 797,000 | |||||
Total liabilities and stockholders’ equity | $ | 1,417,000 | ||||
Castile Products, Inc. Income Statement For the Year Ended December 31 |
|||
Sales | $ | 2,280,000 | |
Cost of goods sold | 1,170,000 | ||
Gross margin | 1,110,000 | ||
Selling and administrative expenses | 660,000 | ||
Net operating income | 450,000 | ||
Interest expense | 38,000 | ||
Net income before taxes | 412,000 | ||
Income taxes (30%) | 123,600 | ||
Net income | $ | 288,400 | |
Account balances at the beginning of the year were: accounts receivable, $160,000; and inventory, $340,000. All sales were on account.
Assume that Castile Products, Inc., paid dividends of $3.65 per share during the year. Also assume that the company’s common stock had a market price of $68 at the end of the year and there was no change in the number of outstanding shares of common stock during the year.
Required:
Compute financial ratios as follows:
1. Earnings per share. (Round your answer to 2 decimal places.)
2. Dividend payout ratio. (Round your intermediate calculations to 2 decimal places. Round your percentage final answer to 2 decimal places. (i.e., 0.1234 should be entered as 12.34).)
3. Dividend yield ratio. (Round your percentage answer to 2 decimal places. (i.e., 0.1234 should be entered as 12.34).)
4. Price-earnings ratio. (Round your intermediate calculations and final answer to 2 decimal places.)
5. Book value per share. (Round your answer to 2 decimal places.)
|
Financial ratios are the ratios calculated from the variables in the financial statement. Financial ratios help to analyse the overall performance the business. Financial ratios are calculated from financial statements like, income statement, Balance Sheet, Cash flow statement, etc.
1.
Earnings per share = Net income/ Average shares outstanding
Net income = $288,400
Average shares outstanding = $200,000 / $5 = 40,000 shares
Earnings per share = $288,400/40,000 = $7.21 per share
2.
Dividend payout ratio = Dividend/ Net income
Dividend = $3.65 × ($200,000/$5) = $146,000
Net income = $288,400
Dividend payout ratio = $146,000/$288,400 = 50.62%
3.
Dividend yield ratio = Dividend per share / Market price per
share
Dividend per share = $3.65
Market price per share = $68
Dividend yield ratio = $3.65/$68 = 5.37%
4.
Price earnings ratio = Current share price / Earnings per share
Current share price = $68
Earnings per share = $7.21
Price earnings ratio = $68/$7.21 = 9.43
5.
Book value per share = Stockholders equity/ Average shares
outstanding
Stockholders equity = $797,000
Average shares outstanding = 40,000
Book value per share = $797,000/40,000 = $19.93