In: Accounting
1. Consider the data for each of the following four independent companies. Calculate the missing values in the table below. For margin and ROI, enter your answers as percentages, rounded to two decimal places. For example, the decimal value .03827 would be entered as "3.83" percent. For turnover, enter your answer as a decimal value rounded to two decimal places.
A | B | C | D | |||||
Revenue | $12,500 | $48,000 | $96,000 | $ | ||||
Expenses | $10,000 | $ | $90,240 | $ | ||||
Operating income | $2,500 | $12,000 | $ | $ | ||||
Assets | $50,000 | $ | $48,000 | $9,800 | ||||
Margin | % | 25 | % | % | 6.00 | % | ||
Turnover | 0.50 | 2.00 | ||||||
ROI | % | % | % | % |
2. Assume that the cost of capital is 9 percent for each of the four firms. Compute the residual income for each of the four firms. If the residual income is negative, enter a negative amount.
A's residual income | $ |
B's residual income | $ |
C's residual income | $ |
D's residual income | $ |
For turnover, enter your answer as a decimal value rounded to two decimal places.
A | B | C | D | |||||
Revenue | $12,500 | $48,000 | $96,000 | 1176/.06 = 19600 | ||||
Expenses | $10,000 | $36000 | $90,240 | 18424 | ||||
Operating income | $2,500 | $12,000 | $5760 | 9800*12% = 1176 | ||||
Assets | $50,000 | 12000/.125 = 96000 | $48,000 | $9,800 | ||||
Margin | 2500/12500 = 20 | % | 25 | % | 5760/96000 = 6 | % | 6.00 | % |
Turnover | 12500/50000 = 0.25 | 0.50 | 2 | 2.00 | ||||
ROI | 2500/50000 = 5% | % | 25*.50 = 12.50 | % | 12 | % | 12 | % |
2. Assume that the cost of capital is 9 percent for each of the four firms. Compute the residual income for each of the four firms. If the residual income is negative, enter a negative amount.
A's residual income | $2500-(50000*9%) = -2000 |
B's residual income | $12000-8640 = 3360 |
C's residual income | $5760-4320 = 1440 |
D's residual income | $1176-882 = 294 |