Question: I just need help calculating the last 3 blanks on the Excel sheet. pls show all calculations Copeland Company is an investment center and an

I just need help calculating the last 3 blanks on the Excel sheet. pls show all calculations

Copeland Company is an investment center and an operating segment of Bobcat International Corporation. Copeland Company is currently earning an ROI of 16% on average operating assets of $15,000,000 as of January 1, 2015. On January 1, 2015 the company has the opportunity to make an investmentwhichwillcostsa000.000and which they believe will yield a 12.5% return (ROI). Bobcat International Corporation expects its investment centers to earn at least 10% on all new investments REQUIRED: Calculate the operating income Copeland Company is currently earning. Calculate the operating income the investment is expected to earn. Calculate the average operating assets Copeland Company will have at yeacend if they make the investment Calculate the operating income Copeland Company will have if they make the investment. What will Copeland Company's ROI be if they make the investment? If the CEO of Copeland Company is evaluated based on ROI will Copeland Company make the investment? Calculate the Residual Income for Copeland Company before making the investment. Calculate the Residual Income for Copeland Company assuming that they make the investment. If the CEO of Copeland Company is evaluated based on Residual Income will Copeland Company make the investment? 1. 2. 3. 4. 5. 6. 7. 8. 9. ETURN ON INVESTMEN Operating Income Average Operating Assets Before Investment Investment After Investment $2,400,000 $500,000 $2,900,000 $15,000,000 $4,000,000 $19,000,000 Return on Investment 16.00%, 12.50% 15.26% Assuming that Copeland Company is evaluated based on ROI only, will Copeland Company make the Investment? RESIDUAL INCOME Corporate Desired ROl Operating Income Desired Operating Income 10.00% Before Investment After Investment $2,400,000 $1,500,000 $900,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

1.1 Consider the regression results given in Table 1.2. (a) Suppose you want to test the hypothesis that the true or population regression coeffi cient of the education variable is 1. How would you...

I need help with my Final Project. Please see attachments below. MBA 503 Final Project Guidelines and Rubric Overview There are two summative assessments for this course. For your first assessment,...

Financial Statement Analysis Part 1 As described in the project overview, Appendix A of your textbook describes several ratios, as well as vertical analysis and horizontal analysis of financial...

I need my powerpoint draft edited to ensure all the requirement of the assignment are answered and clearly noted in this powerpoint. I have attached the current Powerepoint draft, the...

Need help Please with the following.. Calculate the following ratios using Microsoft Excel : Current Ratio Quick Ratio Debt Equity Ratio Inventory Turnover Ratio Receivables Turnover Ratio Total...

CAN YOU PLEASE HELP ME SOLVE THE QUESTION REFERENCING THE ANNUAL REPORT OF BILLABOG 2015 AND 2016. THANKS FEDERATION BUSINESS SCHOOL BUACC1508 ACCOUNTING AND FINANCE ASSESSMENT TASK 2: GROUP...

Common Size Balance Sheet Prepare a spreadsheet with common size balance sheets for the years ended November 30, 2014 and 2015. For 2014, each line item should be shown as a percentage of total...

Please help, this is actually due today and the person who said they would answer this question that was initially due last night. Thank you for the help if possible. I need help with putting the...

1. What is the WACC and why is it important to estimate a firms cost of capital? Is the WACC set by investors or by managers? Explain. Did Cohen make any mistakes in her analysis? Explain. 2....

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

Attached is a problem set in the work document. The excel contain a self grading template so you know if you are doing it correctly. You MUST not change any of the macros on the excel spreadsheet....

sampling design includes the cluster of people, events, things, or other phenomenon that you are most interested in. It is also who or what that you want to say something about at the end of your...

What organizations in your state will furnish maps and reference data to surveyors and engineers?

Create a brief description using the following paragraph on how this experience equips me to be a physician, "At the start of a new project, I was tasked with creating a comprehensive training...

Velocity and temperature profiles for laminar flow in a tube of radius ro = 10 mm have the form u (r) = 0.1 [1 (r/r o ) 2 ] T(r) = 344.8 + 75.0(r/r o )2 18.8(r/r o ) 4 with units of m/s and K....

A finned-tube, cross-flow heat exchanger is to use the exhaust of a gas turbine to heat pressurized water. Laboratory measurements are performed on a prototype version of the exchanger, which has a...

Bond Price Movements Bond X is a premium bond making annual payments. The bond pays a 9 percent coupon, has a YTM of 7 percent, and has 13 years to maturity. Bond Y is a discount bond making annual...

Here are two useful rules of thumb. The Rule of 72 says that with discrete compounding the time it takes for an investment to double in value is roughly 72/interest rate (in percent). The Rule of 69...

Calculating Total Cash Flows Bedrock Gravel Corp. shows the following information on its 2007 income statement: sales $162,000; costs = $93,000; other expenses = $5,100: depreciation expense =...

what is Social Expectations for Professionals.

5.103 Charles Thorson has asked you to determine the mean and variance for a portfolio that consists of 100 shares of stock from each of the following firms: 3M Company, Alcoa, Inc., Intel...

5.102 Zafer Toprak is a developing a new mutual fund portfolio and in the process has asked you to develop the mean and variance for the stock price that consists of 10 shares of stocks from Alcoa...

5.81 A hamburger stand sells hamburgers for $1.45 each. Daily sales have a distribution with a mean of 530 and a standard deviation of 69. a. Find the mean daily total revenues from the sale of...