In: Accounting
Problem 11-15 Return on Investment (ROI) and Residual Income [LO11-1, LO11-2]
Financial data for Joel de Paris, Inc., for last year follow:
Joel de Paris, Inc. Balance Sheet |
||||||
Beginning Balance |
Ending Balance |
|||||
Assets | ||||||
Cash | $ | 134,000 | $ | 135,000 | ||
Accounts receivable | 340,000 | 490,000 | ||||
Inventory | 572,000 | 481,000 | ||||
Plant and equipment, net | 874,000 | 854,000 | ||||
Investment in Buisson, S.A. | 394,000 | 428,000 | ||||
Land (undeveloped) | 252,000 | 245,000 | ||||
Total assets | $ | 2,566,000 | $ | 2,633,000 | ||
Liabilities and Stockholders' Equity | ||||||
Accounts payable | $ | 371,000 | $ | 349,000 | ||
Long-term debt | 1,032,000 | 1,032,000 | ||||
Stockholders' equity | 1,163,000 | 1,252,000 | ||||
Total liabilities and stockholders' equity | $ | 2,566,000 | $ | 2,633,000 | ||
Joel de Paris, Inc. Income Statement |
|||||||||
Sales | $ | 5,238,000 | |||||||
Operating expenses | 4,557,060 | ||||||||
Net operating income | 680,940 | ||||||||
Interest and taxes: | |||||||||
Interest expense | $ | 117,000 | |||||||
Tax expense | 208,000 | 325,000 | |||||||
Net income | $ | 355,940 | |||||||
The company paid dividends of $266,940 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. (Round "Margin", "Turnover" and "ROI" to 2 decimal places.)
3. What was the company’s residual income last year?
1. | Average operating assets | ||
2. | Margin | % | |
Turnover | |||
ROI | % | ||
3. | Residual income |
1) | |||||||||
Average operating assets = ( ending balances + beginning balances )/2 | |||||||||
(1,960,000+1,920,000)/2 | |||||||||
1940000 | |||||||||
2) | Margin = net operating income/sales | ||||||||
Turnover = sales/average operating assets | |||||||||
ROI = margin * turnover | |||||||||
Margin | 13.0% | ||||||||
turnover | 2.70 | ||||||||
ROI | 35.1% | ||||||||
total operating assets don't include investments in other companies or in undeveloped | |||||||||
land | |||||||||
ending | Beginning | ||||||||
balances | balances | ||||||||
Cash | 135,000 | 134,000 | |||||||
account receivable | 490,000 | 340,000 | |||||||
inventory | 481,000 | 572,000 | |||||||
plant and equipment,net | 854,000 | 874,000 | |||||||
total Assets | 1,960,000 | 1,920,000 | |||||||
Average operating assets = ( ending balances + beginning balances )/2 | |||||||||
(1,960,000+1,920,000)/2 | |||||||||
1940000 | |||||||||
3) | Net operating income | 680,940 | |||||||
minimum required return | 15% | ||||||||
residual income | 389940 | ||||||||
Residual income =net operating income - (average operating assets *min required return) | |||||||||