In: Accounting
Question 1
Beaker Company |
|||||||
Statements of Financial Position |
|||||||
Beginning Balance |
Ending Balance |
||||||
Assets: |
|||||||
Cash |
$ |
256,000 |
$ |
231,240 |
|||
Accounts receivable |
144,000 |
192,000 |
|||||
Inventory |
310,000 |
240,000 |
|||||
Plant and equipment (net) |
492,000 |
445,000 |
|||||
Investment in Cedar Company |
301,000 |
286,000 |
|||||
Land (undeveloped) |
280,000 |
280,000 |
|||||
Total assets |
$ |
1,783,000 |
$ |
1,674,240 |
|||
Liabilities and owners' equity: |
|||||||
Accounts payable |
$ |
214,000 |
$ |
238,000 |
|||
Long-term debt |
810,000 |
810,000 |
|||||
Owners' equity |
759,000 |
626,240 |
|||||
Total liabilities and owners' equity |
$ |
1,783,000 |
$ |
1,674,240 |
|||
Beaker Company |
|||||||
Income Statement |
|||||||
Sales |
$ |
2,060,000 |
|||||
Less operating expenses |
1,854,000 |
||||||
Net operating income |
206,000 |
||||||
Less interest and taxes: |
|||||||
Interest expense |
$ |
96,900 |
|||||
Tax expense |
63,860 |
160,760 |
|||||
Net income |
$ |
45,240 |
|||||
The company paid dividends of $178,000 last year. The "Investment in Cedar Company" on the statement of financial position represents an investment in the stock of another company.
Additionally; The Board of Directors of Beaker Company has set a minimum required return of 15%.
Please calculate the following:
Average Operating Assets (rounded to the nearest whole dollar, with commas) |
$ |
Operating Income (rounded to the nearest whole dollar, with commas) |
$ |
Sales (rounded to the nearest whole dollar with commas) |
$ |
Margin (rounded to the 2 decimal places) |
% |
Turnover (rounded to 2 decimal places) |
|
Return On Investment (rounded to 2 decimal places) |
% |
Residual Income (rounded to the nearest whole dollar, with commas) |
$ |
Average operating assets = (beginning operating assets + ending operating assets)/2
Beginning operating assets
Cash |
256,000 |
Accounts receivable |
144,000 |
Inventory |
310,000 |
Plant and equipment (net) |
492,000 |
Total beginning operating assets |
1202000 |
Ending operating assets
Cash |
231,240 |
Accounts receivable |
192,000 |
Inventory |
240,000 |
Plant and equipment (net) |
445,000 |
Total beginning operating assets |
1108240 |
Average operating assets = (1202000+1108240)/2 = 1155120
Margin = net operating income / sales = 206000/2060000 = 10%
Turnover = sales/ average operating assets = 2060000/1155120 = 1.78
ROI = margin * turnover = 10%*1.78 = 17.8%
Residual income = net operating income – return on average operating assets = 206000-(1155120*15%) = $32732
Average Operating Assets (rounded to the nearest whole dollar, with commas) |
$1,155,120 |
Operating Income (rounded to the nearest whole dollar, with commas) |
$206,000 |
Sales (rounded to the nearest whole dollar with commas) |
$2,060,000 |
Margin (rounded to the 2 decimal places) |
10.00% |
Turnover (rounded to 2 decimal places) |
1.78 |
Return On Investment (rounded to 2 decimal places) |
17.80% |
Residual Income (rounded to the nearest whole dollar, with commas) |
$32,732 |