Question
In: Accounting
Margin, Turnover, ROI Required: 1. Consider the data for each of the following four independent companies....
Margin, Turnover, ROI
Required:
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 | $49,000 | $96,000 | $fill in the blank 1 | ||||
| Expenses | $10,000 | $fill in the blank 2 | $90,240 | $fill in the blank 3 | ||||
| Operating income | $2,500 | $14,700 | $fill in the blank 4 | $fill in the blank 5 | ||||
| Assets | $50,000 | $fill in the blank 6 | $48,000 | $9,500 | ||||
| Margin | fill in the blank 7 | % | 30 | % | fill in the blank 8 | % | 6.00 | % |
| Turnover | fill in the blank 9 | 0.50 | fill in the blank 10 | 2.00 | ||||
| ROI | fill in the blank 11 | % | fill in the blank 12 | % | fill in the blank 13 | % | fill in the blank 14 | % |
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 | $fill in the blank 15 |
| B's residual income | $fill in the blank 16 |
| C's residual income | $fill in the blank 17 |
| D's residual income | $fill in the blank 18 |
Solutions
Expert Solution
- Requirements asked
|
A |
B |
C |
D |
|
|
Revenue |
$12,500 |
$49,000 |
$96,000 |
$19,000 |
|
Expenses |
$10,000 |
$34,300 |
$90,240 |
$17,860 |
|
Operating income |
$2,500 |
$14,700 |
$5,760 |
$1,140 |
|
Assets |
$50,000 |
$98,000 |
$48,000 |
$9,500 |
|
Margin |
20.00% |
30.00% |
6.00% |
6.00% |
|
Turnover |
0.25 |
0.50 |
2.00 |
2.00 |
|
ROI |
5.00% |
15.00% |
12.00% |
12.00% |
--Working
|
A |
B |
C |
D |
|
|
Revenue |
12500 |
49000 |
96000 |
=9500*2 |
|
Expenses |
10000 |
=49000-14700 |
90240 |
=19000-1140 |
|
Operating income |
2500 |
14700 |
=96000-90240 |
=19000*6% |
|
Assets |
50000 |
=49000/0.5 |
48000 |
9500 |
|
Margin |
=2500/12500 |
0.3 |
=5760/96000 |
0.06 |
|
Turnover |
=12500/50000 |
0.5 |
=96000/48000 |
2 |
|
ROI |
=2500/50000 |
=14700/98000 |
=5760/48000 |
0.12 |
- [2]
|
Assets |
Expected Operating Income |
Actual Operating Income |
Residual Income [ANSWERS] |
|
|
[A] |
[B = A x 9%] |
[C] |
[D = C - B] |
|
|
A |
$50,000 |
$4,500 |
$2,500 |
($2,000) |
|
B |
$98,000 |
$8,820 |
$14,700 |
$5,880 |
|
C |
$48,000 |
$4,320 |
$5,760 |
$1,440 |
|
D |
$9,500 |
$855 |
$1,140 |
$285 |
ekkarill92 answered 10 months agoRelated Solutions
1. Consider the data for each of the following four independent companies. Calculate the missing values...
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
$10,000
$49,000
$96,000
$
Expenses
$8,000
$
$90,240
$
Operating income
$2,000
$12,250
$
$...
1. Consider the data for each of the following four independent companies. Calculate the missing values...
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
$
$...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an...
Mastery
Problem: Return on Investment, margin, and turnover
Return on
Investment (ROI)
The manager of an
investment center should be evaluated based on revenues, costs, and
investments. An evaluation based on net income ignores the amount
of investment the investment center required. One way to measure
operating profit in relation to investment is a calculation called
the return on investment.
One formula for calculating return on investment is:
Operating income
Invested Assets
ROI is effective
because it takes into consideration...
Mastery Problem: Return on Investment, margin, and turnover Return on Investment (ROI) The manager of an...
Mastery
Problem: Return on Investment, margin, and turnover
Return on
Investment (ROI)
The manager of an
investment center should be evaluated based on revenues, costs, and
investments. An evaluation based on net income ignores the amount
of investment the investment center required. One way to measure
operating profit in relation to investment is a calculation called
the return on investment.
One formula for calculating return on investment is:
Operating income
Invested Assets
ROI is effective
because it takes into consideration...
I have the formulas for how to calculate ROI, Margin and Turnover. But I don't know...
I have the formulas for how to calculate ROI, Margin and
Turnover. But I don't know if I am using the right numbers and it
gets frustrating. A worked out calculation for each would really be
helpful so I know what numbers from what years you plugged in. Your
time is valuable and would really appreciate the help. If the
response is correct, I would not mind giving a like!
Return on Investment, Margin, Turnover
Ready Electronics is facing stiff...
Calculating Average Operating Assets, Margin, Turnover, Return on Investment (ROI) Forchen, Inc., provided the following information...
Calculating Average Operating Assets, Margin, Turnover, Return
on Investment (ROI)
Forchen, Inc., provided the following information for two of its
divisions for last year:
Small Appliances
Division
Cleaning Products
Division
Sales
$34,670,000
$34,800,000
Operating income
2,773,600
1,392,000
Operating assets, January 1
6,394,000
5,600,000
Operating assets, December 31
7,474,000
6,000,000
Required:
1. For the Small Appliances Division,
calculate:
a. Average operating assets
$
b. Margin
%
c. Turnover
d. Return on investment (ROI)
%
2. For the Cleaning Products Division,
calculate:...
Calculating Average Operating Assets, Margin, Turnover, Return on Investment (ROI) Forchen, Inc., provided the following information...
Calculating Average Operating Assets, Margin, Turnover, Return
on Investment (ROI)
Forchen, Inc., provided the following information for two of its
divisions for last year:
Small Appliances
Division
Cleaning Products
Division
Sales
$34,670,000
$29,000,000
Operating income
2,773,600
1,160,000
Operating assets, January 1
6,394,000
5,600,000
Operating assets, December 31
7,474,000
6,000,000
Required:
1. For the Small Appliances Division,
calculate:
a. Average operating assets
$ fill in the blank 1
b. Margin
fill in the blank 2
%
c. Turnover
fill in the...
Identifying Fixed, Variable, Mixed, and Step Costs Consider each of the following independent situations: Required: 1....
Identifying Fixed, Variable, Mixed, and Step Costs
Consider each of the following independent situations:
Required:
1. For each situation, describe the cost as one
of the following: fixed cost, variable cost, mixed cost, or step
cost. (Hint: First, consider what the driver or output measure is.
If additional assumptions are necessary to support your cost type
decision, be sure to write them down.)
Example: Raw materials used in production - Variable cost
a. A computer service agreement in which a...
Required: Firm A has a margin of 11%, sales of $520,000, and ROI of 19%. Calculate...
Required:
Firm A has a margin of 11%, sales of $520,000, and ROI of 19%.
Calculate the firm's average total assets.
Firm B has net income of $72,000, turnover of 1.40, and average
total assets of $900,000. Calculate the firm's sales, margin, and
ROI.
Firm C has net income of $132,000, turnover of 1.91, and ROI of
24.00%. Calculate the firm's margin, sales, and average total
assets.
Firm A has a margin of 11%, sales of $520,000, and ROI of...
Consider the following data collected from four independent populations: Sample 1 Sample 2 Sample 3 Sample...
Consider the following data collected from four independent
populations:
Sample 1 Sample 2 Sample 3 Sample 4
3 14 21 8
8 9 15 3
6 13 16 13
5 14
a. Calculate the total sum of squares
(SST).
b. Partition the total sum of squares (SST) into its two
components.
c. Using a= 0.001, what conclusions can be made about the
population means?
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- this week we are learning about language and cognitive development. Psychologists have been debating for quite...
- Using the firm Coles Supermarkets, create a SWOT analysis
- How do you define the following common rating errors: Leniency, central tendency, strictness, halo, proximity, contrast,...
- he final exam grade of a statistics class has a skewed distribution with mean of 78...
- A sheet of glass is coated with a 501-nm-thick layer of oil (n = 1.42). 1.For...
- Enlist 2 differences between matplotlib vs Seaborn and for what type of visualization would you use...
- A company that makes shopping carts for supermarkets and other stores recently purchased some new equipment...
ADVERTISEMENT