Integrated Excel: Calculating Return on Investment (ROI) and Residual Income Adams Corporation evaluates divisional managers based on Return on Investment (ROI) and has provided the operating results of the Northern Division from last year. The Controller has asked you to compute the ROI and Residual Income based on data from last year and if the division adds a new product line. Sales $ 27,000,000 Variable expenses 16,200,000 Contribution margin 10,800,000 Fixed expenses 8,805,000 Net operating income $ 1,995,000 Divisional operating assets $ 9,500,000 The Northern Division has an opportunity to add a new product line as follows: Required investment $ 2,500,000 Net operating income $ 400,000 Adams Corporation's minimum acceptable rate of return 15% Required: Compute the following: 1. Northern Division ROI for last year 2. Northern Division ROI if new product line is added 3. Determine whether the Northern Division manager will ACCEPT or REJECT the new product line based on ROI. 4. Northern Division residual income for last year 5. Northern Division residual income if the new product line is added 6. Determine whether the Northern Division manager will ACCEPT or REJECT the new product line based on residual income.
Added by Brian L.
Close
Step 1
Northern Division ROI for last year: ROI = Net Operating Income / Divisional Operating Assets ROI = $1,995,000 / $9,500,000 ROI = 0.2095 or 20.95% Show more…
Show all steps
Your feedback will help us improve your experience
Madhur L and 55 other Principles of Accounting educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
5. (Depreciation) You are considering the following investment: a. Assuming that the investment can be depreciated using 7-year straight-line depreciation with no salvage value, calculate the project NPV. b. What will be the company's gain in present value if it uses a 7-year modified accelerated depreciation (MACRS) schedule, given below:
Akash M.
For this assignment, read the case facts below and then create an Excel spreadsheet using the guidance at the end of the case. On January 1, 2020, James Company purchased 100 percent of the outstanding voting stock of Nolan, Inc. for $1,000,000 in cash and other consideration. At the purchase date, Nolan had common stock of $500,000 and retained earnings of $185,000. James attributed the excess of acquisition-date fair value over Nolan's book value to a trade name with an estimated 25-year remaining useful life. James uses the equity method to account for its investment in Nolan. During the next two years, Nolan reported the following: Worksheet Adjustment for case assignment. 2020 - Income: $78,000; Dividends Declared: $25,000; Inventory Transfers to James at Transfer Price: $190,000 2021 - Income: $85,000; Dividends Declared: $27,000; Inventory Transfers to James at Transfer Price: $210,000 Nolan sells inventory to James after a markup based on a gross profit rate. At the end of 2020 and 2021, 30 percent of the current year purchases remain in James's inventory. Create an Excel spreadsheet that computes the following: Equity method balance in James' Investment in Nolan, Inc. account as of December 31, 2021. Worksheet adjustments for the December 31, 2021, consolidation of James and Nolan. Formulate your solution so that Nolan's gross profit rate on sales to James is treated as a variable.
John Limited has created a new division with four investment opportunities. The firm's cost of capital is 20%. The following additional information is available: Opportunity Income Investment ÂŁ'000 ÂŁ'000 A 131 750 B 162 600 C 151 500 D 148 700 Required: a) Calculate the Return on investment for each project. b) Assume you are the Project Manager and you are being evaluated based on Return On Investment (ROI), select the investment opportunities you would accept where the projects are mutually exclusive. Calculate the associated ROI for the division. c) If, on the other hand, you were evaluated on Residual income (RI) basis, identify the investments you would accept. Calculate the Residual income for the division. d) Assuming you are the CEO of John Limited, identify which project you would want the division to accept. State the performance measure you would use to encourage this action.
Madhur L.
Recommended Textbooks
Horngren’s Cost Accounting
Cost Accounting A Managerial Emphasis
Principles of Accounting Volume 1: Financial Accounting
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD