Calculate irr for each option

Reference no: EM132060438

Question: Proust Manufacturing Co. produces personal fitness machines. The once successful line is no longer selling well, so the company is considering production of a new improved cardio-vascular machine. This can be done by buying needed production equipment. There is a six-month manufacturing, delivery, setup, and training delay before the equipment will be ready for production. The company wants to start producing the new cardio machine in January next year. Two options are available - lease or buy. Buy Option - The entire purchase price of the production equipment is $650K and is due at the time of the order. The cost of capital for this purchase is 6%. Assume: (1) the equipment has no residual value at the end of the fifth year and (2) there are no taxes. Lease Option - The total lease cost is $550K. A $25K deposit is due at the time of the order. The remaining portion of the first year's lease payment ($85K) is due in January next year. The other four annual lease payments ($110K each) are due in January of production years 2, 3, 4, and 5. The cost of capital for leasing is 12%. Assume no taxes. Revenue from sales of the new cardiovascular machines is expected to be:

• Year 1 - $400,000

• Year 2 - $350,000

• Year 3 - $200,000

• Year 4 - $150,000

• Year 5 - 80,000

1. Calculate the net present value of both the new purchase option and the lease option. Show all work. Determine the best option for Proust and justify your answer.

2. You used the Excel NPV function to calculate NPV and you got the following values: Buy - $363,562; Lease - $464,317. What did you do wrong?

3. Calculate IRR for each option.

Reference no: EM132060438

Questions Cloud

What is the amount of the premium on these bonds at issuance : Quatro Co. issues bonds dated January 1, 2015, with a par value of $740,000. What is the amount of the premium on these bonds at issuance

Discuss the importance of internal financial reports : Provide your thoughts on the importance of internal financial reports particularly the importance of budgets in managing the resources and obligations.

How much of each type of bond should be purchased : Providence Health Care is obligated to make a payment of $300,000 in exactly three years. In order to provide for this obligation, their financial officer.

Pros and cons of investing directly in individual stocks : What are the pros and cons of investing directly in individual stocks or bonds versus investing indirectly through a mutual fund?

Calculate irr for each option : Proust Manufacturing Co. produces personal fitness machines. The once successful line is no longer selling well, so the company is considering production.

What reforms should be considered for the future : What reforms should be considered for the future? Who is advocating for those reforms and which segment of the voting population supports those reforms?

What happens to the minimum detectable effect : What happens to the MDE (the Minimum detectable effect) if we increase the variance of the error term? What does that say about the value of including control.

What are the reasons for the difference in union success : During the first six months of 1862, Union forces enjoyed much more success in the western theater than they did in the East.

Identify three forecast content items : You are the chief executive officer at Memorial Hospital. Memorial is a nonprofit hospital with 300 beds and is located in a busy metropolitan area directly.

User Account

All Pages