Question

In: Accounting

Using the data from this module’s Connect Excel Simulation - "Calculation of Return of Investment and...

Using the data from this module’s Connect Excel Simulation - "Calculation of Return of Investment and Residual Income for Adam Corporation’s Northern Division", compare and contrast how the calculations may have impacted the division manager’s decision regarding accepting or rejecting a new product line. Include discussion of the limits of using ROI vs Residual Income for evaluating performance of the division. Do you think the division manager’s decision to invest would change if his/her bonus was based on company ROI versus Residual Income? What is best for the company as a whole?

Adams Corporation evaluates divisional managers based on ROI. Operating results for the company's Northern Division for last year are given below:

SALES $27,000,000
Variable expense 16,200,000
Contribution margin 10,800,000
Fixed expenses 8,805,000
Net Operating 1,995,000
Average divisional operating assets 9,500,000

The Northern Division has an opportunity to add a new product line at the beginning of the year as Follows:

Required investment $2,500,000
Net Operating income 400,000

Adams Corporation's minimum acceptable rate of return 15%

Compute the following:

Northern Division ROI for last year 21%

Northern Division ROI if new product line is added 19.96%

Manager will ACCEPT

Northern Division residual income for last $570,000

Northern Division residual income if the new product line is added $595,000

Manager will ACCEPT

Solutions

Expert Solution

ROI:
Before After
Investment Investment
Net Operating Income 1995000 2395000
(1995000+400000)
Divide: Average Operating assets 9500000 12000000
(9500000+2500000)
ROI 21% 19.96%
(Net Income/ Average Assets)
Residual Income:
Before After
Investment Investment
Net Operating Income 1995000 2395000
(1995000+400000)
Divide: Average Operating assets 9500000 12000000
(9500000+2500000)
Acceptable Rate of return 15% 15%
Target return 1425000 1800000
Residual Return 570000 595000
(Actual income-Target Income)
Req 1.
Northern Division ROI: 21%
Northern Division after investment: 19.96%
Accepted
Req 2.
Northern residual income: 570000
Northern division residual income after investment: 595000
Accepted

Related Solutions

Show all calculation details by not using a calculator or Excel answers. Consider the data set:...
Show all calculation details by not using a calculator or Excel answers. Consider the data set: (7,11), (10,0), (13,-2). A. Compute and interpret the coefficient of correlation. B. Compute the least squares line for this data (no need to repeat computations from above).
Risk and Return using EXCEL Use the following data to explore the return-risk relation and the...
Risk and Return using EXCEL Use the following data to explore the return-risk relation and the concept of beta for Apple stock, JPMorgan Chase & Co stock, and the S&P 500 market index: Year | Apple Stock Price | JPMorgan Chase & Co Stock Price | S&P 500 Market Index Value 2017 | $149.04 | $93.85 | 2,425.17 2016 | $95.89 | $59.60 | 2,102.94 2015 | $124.50 | $68.25 | 2,076.79 2014 | $94.03 | $57.05 | 1,960.96 2013...
Please show the calculation process in Excel, thank you With the gasoline time series data from...
Please show the calculation process in Excel, thank you With the gasoline time series data from Table 8.1, show the exponential smoothing forecasts using α=0.1. Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of α=0.1 or α=0.2 for the gasoline sales time series? Are the results the same if you apply MAE as the measure of accuracy? What are the results if MAPE is used? Week Sales (1000s of gallons) 1 17 2 21 3...
Using the following data: (Pleae prove answers in excel spreadship & show calculations) • Initial Investment...
Using the following data: (Pleae prove answers in excel spreadship & show calculations) • Initial Investment = $10,000,000 • Cash Inflow – Year 1 = $3,000,000 • Cash Inflow – Year 2 = $3,500,000 • Cash Inflow – Year 3 = $4,000,000 • Cash Inflow – Year 4 = $4,900,000 • Cash Inflow – Year 5 = $5,000,000 a. Calculate Internal Rate of Return b. Calculate Net Present Value (assuming a required return of 8%) 2). Using the following data:...
Solve the following questions in excel using the skills from class. Lindner is considering an investment...
Solve the following questions in excel using the skills from class. Lindner is considering an investment with an initial cost of $122,400 and salvage value of 63,600 with the following cash flows over the next 6 years: Year Cash flow 1 $28,750 2 $19,500 3 $44,100 4 $27,900 5 $15,850 6 $13,050 The discount rate is 14.8%. Find the NPV and IRR, what is the decision and what was the criteria for each rule? You want to analyze the impact...
Using the data in the table below, calculate the return for investing in the share from...
Using the data in the table below, calculate the return for investing in the share from 1 January to 31 December. Prices are after the dividend has been paid Date Price Dividend     Jan 1 $31.53 − Feb 5 $31.11 $0.22 May 14 $30.67 $0.18 Aug 13 $31.78 $0.21 Nov 12 $37.95 $0.22 Dec 31 $40.11 Return for the entire period is ................. ​%. ​(Enter your response as a percent rounded to two decimal​ places.)
Using the data in the​ table, calculate the return for investing in the stock from January...
Using the data in the​ table, calculate the return for investing in the stock from January 1 to December 31. Prices are after the dividend has been paid. Date Price Dividend   Jan 1 $ 34.96 minus Feb 5 $ 30.19 $ 0.21 May 14 $ 28.61 $ 0.19 Aug 13 $ 32.06 $ 0.21 Nov 12 $ 37.48 $ 0.18 Dec 31 $ 42.57 minus Return for the entire period is nothing​%. ​(Round to two decimal​ places.
using excel functions Complete the following without a table (round each calculation to the nearest cent...
using excel functions Complete the following without a table (round each calculation to the nearest cent as needed): 1. principal time rate of compounding interest   compounded NUMBER of periods compounded total amount Total interest $ 500   1 year 8% quarterly A. ? B. ? C.? Solve the previous problem by using compound value (FV). See Table 12.1. Lionel Rodgers deposits $7,000 in Victory Bank, which pays 4% interest compounded semiannually. How much will Lionel have in his account at the...
How do I complete this in Excel . Calculation  ANOVA Using one-way analysis of variance on the...
How do I complete this in Excel . Calculation  ANOVA Using one-way analysis of variance on the data assuming the populations have equal variances and the populations are normally distributed. Use alpha = 0.05. three samples obtained independently from 3 population Item Group A Group B Group C 1 14 17 17 2 13 16 14 3 12 16 15 4 15 18 16 5 16 14 6 16
Question ( mortgage problem) (Try to work this question WITHOUT using Excel, get calculation in detail)...
Question ( mortgage problem) (Try to work this question WITHOUT using Excel, get calculation in detail) You are considering the purchase of a $500,000 home. You plan to take a 30-year fixed mortgage after making a 20% downpayment to avoid PMI. Payments are to be made monthly (at the end of the month) and the APR is 8%. What is the monthly payment? During what month does the principal portion first exceed the interest portion? Are you surprised by your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT