In: Accounting
Financial data for Joel de Paris, Inc., for last year follow:
Joel de Paris, Inc. Balance Sheet |
||||||
Beginning Balance |
Ending Balance |
|||||
Assets | ||||||
Cash | $ | 130,000 | $ | 138,000 | ||
Accounts receivable | 334,000 | 479,000 | ||||
Inventory | 564,000 | 482,000 | ||||
Plant and equipment, net | 862,000 | 831,000 | ||||
Investment in Buisson, S.A. | 392,000 | 425,000 | ||||
Land (undeveloped) | 252,000 | 249,000 | ||||
Total assets | $ | 2,534,000 | $ | 2,604,000 | ||
Liabilities and Stockholders' Equity | ||||||
Accounts payable | $ | 371,000 | $ | 340,000 | ||
Long-term debt | 985,000 | 985,000 | ||||
Stockholders' equity | 1,178,000 | 1,279,000 | ||||
Total liabilities and stockholders' equity | $ | 2,534,000 | $ | 2,604,000 | ||
Joel de Paris, Inc. Income Statement |
|||||||||
Sales | $ | 4,202,000 | |||||||
Operating expenses | 3,613,720 | ||||||||
Net operating income | 588,280 | ||||||||
Interest and taxes: | |||||||||
Interest expense | $ | 124,000 | |||||||
Tax expense | 192,000 | 316,000 | |||||||
Net income | $ | 272,280 | |||||||
The company paid dividends of $171,280 last year. The “Investment
in Buisson, S.A.,” on the balance sheet represents an investment in
the stock of another company. The company's minimum required rate
of return of 15%.
Required:
1. Compute the company's average operating assets for last year.
2. Compute the company’s margin, turnover, and return on investment (ROI) for last year. (Do not round intermediate calculations and round your final answers to 2 decimal places.)
3. What was the company’s residual income last year?
Ans. | Assets | Beginning balance | Ending balance | |
Cash | $130,000 | $138,000 | ||
Accounts receivables | $334,000 | $479,000 | ||
Inventory | $564,000 | $482,000 | ||
Plant and equipment | $862,000 | $831,000 | ||
Total operating assets | $1,890,000 | $1,930,000 | ||
*Undeveloped land and investment in other company are not included in operating assets. | ||||
Ans.1 | Average operating assets = (Beginning operating assets + Ending operating assets) / 2 | |||
($1,890,000 + $1,930,000) / 2 | ||||
$3,820,000 / 2 | ||||
$1,910,000 | ||||
Ans.2 a | Margin = Net operating income / Sales * 100 | |||
$588,280 / $4,202,000 * 100 | ||||
14.00% | ||||
Ans.2 b | Turnover = Sales / Average operating assets | |||
$4,202,000 / $1,910,000 | ||||
2.20 | times | |||
Ans. 2 c | Return on investment (ROI) = Turnover * Margin | |||
2.20 * 14% | ||||
30.80% | ||||
Ans. 3 | Residual income = Operating income - Minimum required income | |||
$588,280 - $286,500 | ||||
$301,780 | ||||
*Minimum required income = Average operating assets * Desired rate of return | ||||
$1,910,000 * 15% | ||||
$286,500 | ||||
*Residual income is the difference between Net operating income and minimum required income, and the | ||||
minimum required income is the product of average operating assets and desired rate of return. |