Question

In: Accounting

company has the following operating data for the past 2 years: Year 1 Year 2 Residual...

company has the following operating data for the past 2 years:

Year 1 Year 2

Residual Income

$600

?

Return on Investment

10% 87.5%

Required Rate of return

8% 9%

Average operating assets

? $42,000

Sales in year 1 is $70,000 less than sales in year 2.

The Company had the same capital turnover in both years.

Q.) What is the sales margin in Year 2

Solutions

Expert Solution

Year 1:

Residual Income = Average Operating Assets * (Return on Investment - Required Rate of Return)

$600 = Average Operating Assets * (10% - 8%)

Average Operating Assets = $600 / 2%

Average Operating Assets = $30,000

Net Profit = Average Operating Assets * Return on Investment

= $30,000 * 10% i.e. $3,000

Year 2:

Residual Income = Average Operating Assets * (Return on Investment - Required Rate of Return)

Residual Income = $42,000 * (9% - 8.75%)

Residual Income = $105

Net Profit = Average Operating Assets * Return on Investment

= $42,000 * 8.75% i.e. $3,675

Combined Analysis:

Let Sales in Year 1 be X

It is provided that capital turnover is same in both years, i.e.

X / $30,000 = (X + $70,000) / $42,000

(X * $42,000) / $30,000 = X + $70,000

$1.4 * X = X + $70,000

X = $70,000 / 0.4

X = $175,000

Sales Margin in Year 2 = Net Profit / Sales

= $3,675 / ($175,000 + $70,000)

= 1.5%

(It is assumed that return on Investment in Year 2 is 8.75% instead of 87.5% as return on Invest @ 87.5% is very unreasonable. Moreover, it is assumed that all the assets of the firm are financed by Equity i.e. No debt firm.)

If you have any doubt, feel free to ask in comment section.


Related Solutions

Intra Corp. has the following operating data for the past 2 years: Year 1 Year 2...
Intra Corp. has the following operating data for the past 2 years: Year 1 Year 2 Return on Investment 10% 25% Residual Income $600 ? Required Rate of return 8% 10% Average operating assets ? $42,000 Sales in year 2 is $60,000 more than sales in year 1. The Company had the same capital turnover in both years. (Q.) What is the sales margin in Year 2? Use two decimal places in the answer (for example, if the answer is...
1. Meade Corp has the following operating data for the past 2 years: Year 1 Year...
1. Meade Corp has the following operating data for the past 2 years: Year 1 Year 2 Return on Investment 10% 20% Residual Income ? $25,000 Required Rate of return 8% 10% Sales $400,000 $500,000 Asset Turnover ? ? The sales margin in year 2 is twice the margin for the first year. The Company had the same asset turnover in both years. What is the residual income in year1? A. $4,000 B. $8,000 C. $10,000 D. $12,000 E. None...
The Dry Wall Division reports the following operating data for the past two years: Year 1...
The Dry Wall Division reports the following operating data for the past two years: Year 1 Year 2 Margin 15 % ? Turnover 2.6 3 Average operating assets ? $ 150,500 Net operating income $ 40,500 ? Stockholders’ equity $ 80,500 $ 125,500 Sales ? ? The return on investment at the Dry Wall Division was exactly the same in Year 1 and Year 2. The margin in Year 2 was:
The Millard Division's operating data for the past two years are provided below: Year 1 Year...
The Millard Division's operating data for the past two years are provided below: Year 1 Year 2 Return on investment 10 % 24 % Net operating income ? $ 380,000 Turnover ? 4 Margin ? ? Sales $ 3,210,000 ? Millard Division's margin in Year 2 was 120% of the margin in Year 1. The net operating income for Year 1 was: Garrison 16e Rechecks 2017-10-31 Multiple Choice $385,200 $160,500 $192,600 $190,000 Last year a company had sales of $370,000,...
Finn Company has the following operating data for the past year: Sales $616,000 Variable Cost $150,000...
Finn Company has the following operating data for the past year: Sales $616,000 Variable Cost $150,000 Fixed Cost $100,000 Minimum required rate of return 27% Balance Sheet Data for beginning and end of year: Assets Beginning Ending Cash $5,000 $5,000 Accounts Receivable $35,000 $40,000 Inventory $90,000 $95,000 Net PP&E $100,000 $115,000 Land (held for future use) $40,000 $40,000 Investments in affiliates $5,000 $0 Total Assets $275,000 $295,000 Liabilities & SH Equity Short Term Debt $22,000 $27,000 Long Term Debt $116,000...
Overhead Variances and Their Disposal Warner Company has the following data for the past year: Actual...
Overhead Variances and Their Disposal Warner Company has the following data for the past year: Actual overhead $240,500 Applied overhead:       Work-in-process inventory $56,000       Finished goods inventory 112,000       Cost of goods sold 112,000       Total $280,000 Warner uses the overhead control account to accumulate both actual and applied overhead. Required: 1. Calculate the overhead variance for the year. $ Provide the appropriate adjusting journal entry to close the overhead variance to Cost of Goods Sold. Assume the variance calculated is material. After...
Suppose that the following are the quarterly sales data for the past 7 years. 1.Construct a...
Suppose that the following are the quarterly sales data for the past 7 years. 1.Construct a time series plot and develop linear trend equation using the original data (with seasonal components). 2.Calculate 4-quarter moving average values for this time series (column E). 3.Calculate centered moving average values and seasonal indexes (column F and G). 4.Calculate seasonal indexes (column J) for the four quarters. 5.Copy seasonal indexes (column J) to column O, and calculate deseasonalized number sold (column P). 6.Construct a...
Computing Present Value of Terminal Residual Operating Income Use the following data to compute the present...
Computing Present Value of Terminal Residual Operating Income Use the following data to compute the present value of the terminal period ROPI for each of the four firms A through D. Assume a forecast horizon of four years. A B C D Terminal period ROPI $208,011 $46,767 $93,674 $124,622 Weighted average cost of capital (WACC) 8.1% 11.9% 9.7% 13.9% Terminal growth period rate 2.0% 1.0% 2.5% 2.0% Do not round until your final answers. Round your answers to the nearest...
The ABC Company has the following demand data (highlighted in green) for the last 2 years...
The ABC Company has the following demand data (highlighted in green) for the last 2 years of sales for all models of their popular ToyPop product (in units): - The company currently has five employees on the ToyPop line, each capable of producing approximately two ToyPops per day (assume 25 days per month). - Hiring and layoff are not considered for Year 2018. - The employees each earn $20 per hour for the standard 8-hour day, with $10 extra per...
Paint Inc. (PI) has been operating as a family owned private company for the past 30 years. It started as a company manufacturing...
Paint Inc. (PI) has been operating as a family owned private company for the past 30 years. It started as a company manufacturing paint for sale in its own retail stores in Ontario. PI is known as a manufacturer of high quality paint. Since then it has expanded with stores across Canada and recently started a decorating business. It has no desire to go public at this point in time and wants to keep accounting costs as low as possible.With...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT