Lundberg Corporation's most recent balance sheet and income statement appear below:
Statement of Financial Position December 31, Year 2 and Year1 (in thousands of dollars) |
| | Year 2 | Year 1 |
| Assets | | | | | | |
| Current assets: | | | | | | |
| Cash | $ | 200 | | $ | 250 | |
| Accounts receivable | | 360 | | | 320 | |
| Inventory | | 210 | | | 270 | |
| Prepaid expenses | | 60 | | | 60 | |
| |
|
|
|
|
|
|
| Total current assets | | 830 | | | 900 | |
| Plant and equipment, net | | 1,860 | | | 1,760 | |
| |
|
|
|
|
|
|
| Total assets | $ | 2,690 | | $ | 2,660 | |
| |
|
|
|
|
|
|
| Liabilities and Stockholders' Equity | | | | | | |
| Current liabilities: | | | | | | |
| Accounts payable | $ | 287 | | $ | 270 | |
| Accrued liabilities | | 75 | | | 100 | |
| Notes payable, short term | | 200 | | | 140 | |
| |
|
|
|
|
|
|
| Total current liabilities | | 562 | | | 510 | |
| Bonds payable | | 315 | | | 390 | |
| |
|
|
|
|
|
|
| Total liabilities | | 877 | | | 900 | |
| |
|
|
|
|
|
|
| Stockholders' equity: | | | | | | |
| Preferred stock, $100 par value, 10% | | 650 | | | 650 | |
| Common stock, $1 par value | | 320 | | | 320 | |
| Additional paid-in capital--common stock | | 350 | | | 350 | |
| Retained earnings | | 493 | | | 440 | |
| |
|
|
|
|
|
|
| Total stockholders' equity | | 1,813 | | | 1,760 | |
| |
|
|
|
|
|
|
| Total liabilities & stockholders' equity | $ | 2,690 | | $ | 2,660 | |
| |
|
|
|
|
|
|
|
Income Statement For the Year Ended December 31, Year 2 (in thousands of dollars) |
| Sales (all on account) | | $ | 3,150 | |
| Cost of goods sold | | | 2,040 | |
| | |
|
| |
| Gross margin | | | 1,110 | |
| Selling and administrative expense | | | 677 | |
| | |
|
| |
| Net operating income | | | 433 | |
| Interest expense | | | 36 | |
| | |
|
| |
| Net income before taxes | | | 397 | |
| Income taxes (30%) | | | 119 | |
| | |
|
| |
| Net income | | $ | 278 | |
| | |
|
| |
|
|
Dividends
on common stock during Year 2 totaled $160 thousand. Dividends on
preferred stock totaled $65 thousand. The market price of common stock
at the end of Year 2 was $9.46 per share.
|
| Required: |
| Compute the following for Year 2: |
| a. |
Gross margin percentage. (Round your answer to 1 decimal place.)
|
| b. |
Price-earnings ratio. (Round your intermediate calculations to 2 decimal places and final answer to 1 decimal place.)
|
| c. |
Dividend payout ratio. (Round your intermediate calculations to 2 decimal places and final answer to 1 decimal place.)
|
| d. |
Dividend yield ratio. (Round your answer to 2 decimal places.)
|
| e. |
Return on total assets. (Round your intermediate calculations and final answer to 2 decimal places.)
|
| f. |
Return on common stockholders' equity. (Round your answer to 2 decimal places.)
|
| g. |
Book value per share. (Round your answer to 2 decimal places.)
|
| i. |
Current ratio. (Round your answer to 2 decimal places.)
|
| j. |
Acid-test ratio. (Round your answer to 2 decimal places.)
|
| k. |
Average collection period. (Assume 365 days a year and round your answer to 1 decimal place.)
|
| l. |
Average sale period. (Assume 365 days a year and round your answer to 1 decimal place.)
|
| m. |
Times interest earned. (Round your answer to 2 decimal places.)
|
| n. |
Debt-to-equity ratio. (Round your answer to 2 decimal places.)
|
Explanation:(All values in thousands.)
a.
| Gross margin percentage = Gross margin ÷ Sales = $1,110 ÷ $3,150 = 35.2% |
b.
| Earnings per share = (Net Income - Preferred Dividends) ÷ Average number of common shares outstanding* |
| = ($278 - $65) ÷ (320 shares + 320 shares) / 2 = $0.67 per share |
| |
| *Number of common shares outstanding for year 2 = Common stock ÷ Par value |
| = $320 ÷ $1.0 per share = 320 shares |
| Number of common shares outstanding for year 1 = Common stock ÷ Par value |
| = $320 ÷ $1.0 per share = 320 shares |
c.
| Price-earnings ratio = Market price per share ÷ Earnings per share (see above) |
| = $9.46 ÷ $0.67 = 14.12 |
d.
Dividend payout ratio = Dividends per share* ÷ Earnings per share (see above) |
| = $0.50 ÷ $0.67 = 74.6% |
| |
| *Dividends per share = Common dividends ÷ Common shares (see above) |
| = $160 ÷ 320 shares = $0.50 per share |
e.
Dividend yield ratio = Dividends per share (see above) ÷ Market price per share |
| = $0.50 ÷ $9.46 = 5.30% |
f.
| Return on total assets = Adjusted net income* ÷ Average total assets** |
| = $303.20 ÷ $2,675 = 11.33% |
| |
| *Adjusted net income = Net income + [Interest expense × (1 − Tax rate)] |
| = $278 + [$36 × (1 − 0.30)] = $303.2 |
| |
| **Average total assets = ($2,690 + $2,660) ÷ 2 = $2,675 |
g.
| Return on common stockholders' equity |
| = (Net income − Preferred dividends) ÷ Average common stockholders' equity* |
| = ($278 − $65) ÷ $1,136 = 18.74% |
| |
| *Average common stockholders' equity = ($320 + $350 + $493 + $320 + $350 + $440) ÷ 2 = $1,136 |
h.
| Book value per share = Common stockholders' equity ÷ Number of common shares outstanding (see above) |
| = ($320 + $350 + $493) ÷ 320 shares = $3.63 per share |
i.
| Working capital = Current assets - Current liabilities = $830 − $562 = $268 thousand |
j.
| Current ratio = Current assets ÷ Current liabilities = $830 ÷ $562 = 1.48 |
k.
| Acid-test ratio = Quick assets* ÷ Current liabilities = $560 ÷ $562 = 1.00 |
| |
| *Quick assets = Cash + Marketable securities + Accounts receivable + Short-term notes receivable |
| = ($200 + $0 + $360 + $0) = $560 |
l.
| Accounts receivable turnover = Sales on account ÷ Average accounts receivable balance* |
| = $3,150 ÷ $340 = 9.26 |
| |
| *Average accounts receivable balance = ($360 + $320) ÷ 2 = $340 |
m.
| Average collection period = 365 days ÷ Accounts receivable turnover (see above) |
| = 365 days ÷ 9.26 = 39.4 days |
n.
| Inventory turnover = Cost of goods sold ÷ Average inventory balance* |
| = $2,040 ÷ $240 = 8.50 |
| |
| *Average inventory balance = ($210 + $270) ÷ 2 = $240 |
o.
| Average sale period = 365 days ÷ Inventory turnover (see above) = 365 days ÷ 8.50 = 42.9 days |
p.
| Times interest earned = Earnings before interest expense and income taxes ÷ Interest expense |
| = $433 ÷ $36 = 12.03 |
q.
| Debt-to-equity ratio = Total liabilities ÷ Stockholders' equity |
| = $877 ÷ $1,813 = 0.48 |