Question

In: Accounting

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:

Solutions

Expert Solution

Year - 1 .

>> Year - 1 : Sales = Net profit / Margin

>> Year - 1 : Sales = $ 40,500 / 15 %

>> Year - 1 : Sales = $ 270,000.

>> Year -1 : Average Operating asset = Sales / Turnover

>> Year -1 : Average Operating asset = $ 270,000 / 2.6

>> Year -1 : Average Operating asset = $ 103,846.

>> Year - 1: Return on Investment = Net income / Average operating asset

>> Year - 1: Return on Investment = ( $ 40,500 * 100 ) / $ 103,846

>> Year - 1: Return on Investment = 39 %.

Year - 2

>> Year -2 return on investment and year - 1 return on investment is same

>> Year - 2 : Net profit = Average operating asset * Return on investment

>> Year - 2 : Net profit = $ 150,500 * 39 %

>> Year - 2 : Net profit = $ 58,695.

>> Year - 2 : Sales = Turnover * Average operating asset

>> Year - 2 : Sales = 3 * $ 150,500

>> Year - 2 : Sales = $ 451,500.

>> Year - 2 : Margin = Net profit / Sales

>> Year - 2 : Margin = ( $ 58,695 *100 ) / $ 451,500

>> Year - 2 : Margin = 13 %


Related Solutions

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,...
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...
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
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. Coolbrook Company has the following information available for the past year:    River Division Stream Division...
1. Coolbrook Company has the following information available for the past year:    River Division Stream Division Sales revenue $ 1,205,000 $ 1,812,000 Cost of goods sold and operating expenses 890,000 1,284,000 Net operating income $ 315,000 $ 528,000 Average invested assets $ 1,120,000 $ 1,520,000     The company’s hurdle rate is 6.76 percent. Required: 1. Calculate return on investment (ROI) and residual income for each division for last year. 2. Recalculate ROI and residual income for the division for each...
1. Neelon Corporation has two divisions: Southern Division and Northern Division. The following data are for...
1. Neelon Corporation has two divisions: Southern Division and Northern Division. The following data are for the most recent operating period: sales total company 341700 souther division 212300 northern division 129400 variable expense 118766 72182 46584 traceble fixed expenses 168400 70300 98100 common fixed expense 68340 42460 25880 The common fixed expenses have been allocated to the divisions on the basis of sales. The Northern Division’s break-even sales is closest to: 2. Data for January for Bondi Corporation and its...
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...
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...
Here are quarterly data for the past two years, from these data, prepare a forecast for...
Here are quarterly data for the past two years, from these data, prepare a forecast for the upcoming year using decompostion. foreccast years 9 to 12. FORECAST ERROR? Period Actual period Actual 1 300 5 416 2 540 6 760 3 885 7 1191 4 580 8 760
Coolbrook Company has the following information available for the past year:    River Division Stream Division Sales...
Coolbrook Company has the following information available for the past year:    River Division Stream Division Sales revenue $ 1,206,000 $ 1,804,000 Cost of goods sold and operating expenses 887,000 1,283,000 Net operating income $ 319,000 $ 521,000 Average invested assets $ 1,070,000 $ 1,560,000     The company’s hurdle rate is 7.26 percent. Required: 1. Calculate return on investment (ROI) and residual income for each division for last year. (Enter your ROI answers as a percentage rounded to two decimal places,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT