Suppose a firm has two business options to choose from and has asked you, a Business Mathematics student, to help it make a decision. Option "A" requires an immediate cost of $25,000 along with "upgradecosts" of $4,000 in year 3 and $7,500 in year 6. The returns from these investments begin in year 2 and are estimated to be $2,000 per year for 3 years, $4,000 per year for the next 3 years, and then $7,000 inyears 8 and 9, respectively. The only return in year 10 is a residual value of $6,000. Option "B" requires a cost today and in years 1 and 2 of $7,000 and has estimated returns beginning in year 4 and ending inyear 10 of $5,000 per year. There will also be a residual value of $2,000 in year 10. Using Excel's IRR function, find the Rate of Return for each of the two investment options available to the business based onthe information given. Assume the business's expected return on investment is 14 percent. Which option would you recommend?The rate of return on option A is %.(Round to the nearest whole number as needed.)(---)))

Answered: Image /qna-images/answer/9a313ef3-5424-4cd9-aa57-0db4b1f71b25.jpg

ppose a firm has two business options to choose from and has asked you, a Business Mathematics student, to help it m sts" of $4,000 in year 3 and $7,500 in year 6. The returns from these investments begin in year 2 and are estimated to be ars 8 and 9, respectively. The only return in year 10 is a residual value of $6,000. Option "B" requires a cost today and in ar 10 of $5,000 per year. There will also be a residual value of $2,000 in year 10. Using Excel's IRR function, find the Ra information given. Assume the business's expected return on investment is 14 percent. Which option would you recom

ppose a firm has two business options to choose from and has asked you, a Business Mathematics student, to help it m sts" of $4,000 in year 3 and $7,500 in year 6. The returns from these investments begin in year 2 and are estimated to be ars 8 and 9, respectively. The only return in year 10 is a residual value of $6,000. Option "B" requires a cost today and in ar 10 of $5,000 per year. There will also be a residual value of $2,000 in year 10. Using Excel's IRR function, find the Ra information given. Assume the business's expected return on investment is 14 percent. Which option would you recom

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 8TP: Fenton, Inc., has established a new strategic plan that calls for new capital investment. The...

See similar textbooks

Similar questions

2. A firm considers investing in a project. In Year 0 it needs to make an investment of $50,000. If it is expected to earn $50,000, $60,000, $70,000 in years 1,2,3 respectively, decide whether the firm should make the investment. Consider the required rate of return of 8%. You may use xis to make calculations. Make recommendations for both cases.
Below are four cases that you will have to solve using Excel spreadsheets. 2nd case The COMPETIDORA SA company has the possibility of investing in three different projects . The projections show us the following information on which a decision must be made: PROJECT X Y Initial Z$310,000 It is requested: investment $180,000 $250,000 Year 1 cash flows $50,000 $80,000 $150,000 1. Determine the internal rate of return. 2. Determine the present value. Year 2 cash flows 3. Determine the recovery period. 4. Define which is the most viable project. $70,000 $80,000 $120,000 The discount rate for the project will be 9% and the investors propose a MARR of 22%. Year 3 cash flows $80,000 $80,000 $100,000 Year 4 cash flows $100,000 $80,000
Calculate the Profitability Index for Project A A firm is considering the following mutually exclusive investment projects. Project A requires an initial outlay of $500 and will return $120 per year for the next seven years. Project B requires an initial outlay of $5,000 and will return $1,350 per year for the next five years. The required rate of return is 10%. Use th Select an answer and submit. For keyboard navigation, use the up/down arrow keys to select an answer. a b с 1.1684 1.2973 1.3476 d 1.4786
Below are four cases that you will have to solve using Excel spreadsheets. 1st case The company COMERCIAL SA has two investment alternatives that present the following information: PROJECT A B It is requested Initial investment. $25,000 $22,000 Cash flows year 1 1. Determine the internal rate of return. 2. Determine the present value. $7,000 $12,000 The discount rate for the project will be 10% and the MARR will be 20%. 3. Determine the recovery period. 4. Define which is the most viable project. Year 2 cash flows $15,000 $8,000 Year 3 cash flows $18,000 $12,000
You are considering investing in a start up company. The founder asked you for $290,000 today and you expect to get $980,000 in 8 years. Given the riskiness of the investment opportunity, your cost of capital is 25%. What is the NPV of the investment opportunity? Should you undertake the investment opportunity? Calculate the IRR and use it to determine the maximum deviation allowable in the cost of capital estimate to leave the decision unchanged.
A company is comparing two investments. Both require an initial investment of$2,500. Investment A returns $4,700 in eight years while investment B returns$5,650 in 12 years. Determine which investment is attractive.
A. Assume that you have completed your plans and proformas for the next year of operations. The upcoming year looks promising. What would you most likely do from the following list? a. From your proformas project your company’s weighted average cost of capital and return on assets, and compare the two b. Take a vacation because you have been working so hard c. Purchase a new house for your personal use because the future is looking so good d. Make sure that your company’s weighted average cost of capital exceeds your company’s return on assets, if not, rework your plans and proformas B. Assume that all sales are on account. If the average accounts receivable balance was $1,000,000 and accounts receivable turnover was 12 for the last year of operations, what was sales revenue? a. $10,000,000 b. $15,000,000 c. $12,000,000 d. $6,000,000
Use Microsoft Excel to assess the internal rate of return for an IT initiative. Suppose the initial investment is $60,000. The returns on investment in dollars for the following 5 years are (a) $10,000, (b) $12,000, (c) $15,000, (d) $21,000, and (e) $26,000. Use the IRR function to compute the internal rate of return after 2, 4, and 5 years. Next, assume that the loan for the initial $60,000 is at 8 percent and you are earning 16 percent on the annual returns. Use the MIRR function to calculate the internal rate of return. Required: 1. What is the Internal Rate of Return after 2 years? -46% -20% -1% -10% Required: 2. What is the Internal Rate of Return after 4 years? -46% -20% -1% 10% Required: 3. What is the Internal Rate of Return after 5 years? 10% 16% 8% 20%
You are a project manager for your company and you are faced with five potential projects that you can invest in. Free cash flow projections and additional relevant data are given for each project in the table below. Assume that there are no cash flows after year 3. Assume that you can only take each project once and that you can only choose one project. Which project would you invest in? Select the best answer. Project Project A Project B Project C Project D Project E O I. Project A II. Project B III. Project C IV. Project D O V. Project E FCF Forecasts by Year (in $1,000) 0 2 1 500 (400) (400) (300) (250) (300) 75 60 75 135 115 175 3 650 210 190 200 Interest Rate (EAR) 8.0% 10.0% 10.0% 12.0% 12.0% IRR 25.00% 17.57% 15.92% 17.81% 19.96%
You see an opportunity to invest $1 million in a business. The investment is expected to generate a cash flow of $250000 per year over the next five years. Assuming a discount rate is 5%, would it be a sound decision to invest in this business?
Perform a financial analysis for an IT Project which requires an initial investment of $32,000, but it is expected to generate revenues of $10,000, $20,000 and $15,000 for the first, second and third years respectively. The target rate of return is 12%. Write the formula and calculate the Net Present Value (NPV). In addition, Justify your result. (For this question Write the answer on the paper and take photo and upload OR Type in the MS Word document and upload the file)
Suppose you are a small business owner and are considering investing in a new project that has an expected cash flow of $100,000 in year 1, $150,000 in year 2, and $250,000 in year 3. The initial investment required for the project is $400,000. You have a required rate of return of 10% for this project. Is it a good investment? Justify your investment decision. b) After further careful evaluation, you ascertain that the required rate of return for a similar industry project is 7%. Re-evaluate the investment opportunity using the new required rate of return. Does your recommendation change?