Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 4%return from its investments.Initial investmentNet cash flows in:Year 1Year 2Year 3Project X1Project X2IRR21.00 %12.00 %Project X1$ (90,000)YesYes30,00040,50065,500Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whethereach project is acceptable.Note: Round your answers to 2 decimal places.Acceptable?Project X2$ (140,000)67,50057,50047,500

The internal rate of return (IRR) is a financial tool that helps predict an investment's future…

Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 4% return from its investments. Initial investment Net cash flows in: Year 1 Year 2 Year 3 Project X1 $ (90,000) IRR 30,000 40,500 65,500 Project X2 $ (140,000) Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. Note: Round your answers to 2 decimal places. Acceptable? 67,500 57,500 47,500

Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 4% return from its investments. Initial investment Net cash flows in: Year 1 Year 2 Year 3 Project X1 $ (90,000) IRR 30,000 40,500 65,500 Project X2 $ (140,000) Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. Note: Round your answers to 2 decimal places. Acceptable? 67,500 57,500 47,500

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter19: Capital Investment

Section: Chapter Questions

Problem 22E

See similar textbooks

Similar questions

There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $35,000 and is expected to generate the following cash flows: Use the information from the previous exercise to calculate the internal rate of return on both projects and make a recommendation on which one to accept. For further instructions on internal rate of return in Excel, see Appendix C.
Buena Vision Clinic is considering an investment that requires an outlay of 600,000 and promises a net cash inflow one year from now of 810,000. Assume the cost of capital is 10 percent. Required: 1. Break the 810,000 future cash inflow into three components: a. The return of the original investment b. The cost of capital c. The profit earned on the investment 2. Now, compute the present value of the profit earned on the investment. 3. Compute the NPV of the investment. Compare this with the present value of the profit computed in Requirement 2. What does this tell you about the meaning of NPV?
Assume a company is going to make an investment of $450,000 in a machine and the following are the cash flows that two different products would bring in years one through four. Which of the two options would you choose based on the payback method?
Garnette Corp is considering the purchase of a new machine that will cost $342,000 and provide the following cash flows over the next five years: $99,000, $88,000, $92,000. $87,000, and $72,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel. see Appendix C.
There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment or $28.000 and is expected to generate the following cash flows: If the discount rate is 5% compute the NPV of each project and make a recommendation of the project to be chosen.
Your company is planning to purchase a new log splitter for is lawn and garden business. The new splitter has an initial investment of $180,000. It is expected to generate $25,000 of annual cash flows, provide incremental cash revenues of $150,000, and incur incremental cash expenses of $100,000 annually. What is the payback period and accounting rate of return (ARR)?
Assume a company is going to make an investment in a machine of $825,000 and the following are the cash flows that two different products would bring. Which of the two options would you choose based on the payback method?
Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects’ NPVs, IRRs, MIRRs, and PIs, assuming a cost of capital of 12%. Which project would be selected, assuming they are mutually exclusive, using each ranking method? Which should actually be selected?
Project B cost $5,000 and will generate after-tax net cash inflows of $500 in year one, $1,200 in year two, $2,000 in year three. $2,500 in year four, and $2,000 in year five. What is the NPV using 8% as the discount rate? For further instructions on net present value in Excel, see Appendix C.
Consolidated Aluminum is considering the purchase of a new machine that will cost $308,000 and provide the following cash flows over the next five years: $88,000, 92,000, $91,000, $72,000, and $71,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel, see Appendix C.
Manzer Enterprises is considering two independent investments: A new automated materials handling system that costs 900,000 and will produce net cash inflows of 300,000 at the end of each year for the next four years. A computer-aided manufacturing system that costs 775,000 and will produce labor savings of 400,000 and 500,000 at the end of the first year and second year, respectively. Manzer has a cost of capital of 8 percent. Required: 1. Calculate the IRR for the first investment and determine if it is acceptable or not. 2. Calculate the IRR of the second investment and comment on its acceptability. Use 12 percent as the first guess. 3. What if the cash flows for the first investment are 250,000 instead of 300,000?