Question

In: Finance

Ivanhoe Corp. management is planning to convert an existing warehouse into a new plant that will...

Ivanhoe Corp. management is planning to convert an existing warehouse into a new plant that will increase its production capacity by 45 percent. The cost of this project will be $7,676,401. It will result in additional cash flows of $2,225,200 for the next eight years. The discount rate is 11.80 percent.

What is the payback period? (Round answer to 2 decimal places, e.g. 15.25)

What is the NPV for this project?

What is the IRR?

Solutions

Expert Solution

Year Cash flow stream Cumulative cash flow
0 -7676401 -7676401
1 2225200 -5451201
2 2225200 -3226001
3 2225200 -1000801
4 2225200 1224399
5 2225200 3449599
6 2225200 5674799
7 2225200 7899999
8 2225200 10125199
Payback period is the time by which undiscounted cashflow cover the intial investment outlay
this is happening between year 3 and 4
therefore by interpolation payback period = 3 + (0-(-1000801))/(1224399-(-1000801))
3.45 Years
Discount rate 11.800%
Year 0 1 2 3 4 5 6 7 8
Cash flow stream -7676401 2225200 2225200 2225200 2225200 2225200 2225200 2225200 2225200
Discounting factor 1.000 1.118 1.250 1.397 1.562 1.747 1.953 2.183 2.441
Discounted cash flows project -7676401.000 1990339.893 1780268.240 1592368.730 1424301.190 1273972.442 1139510.234 1019239.923 911663.616
NPV = Sum of discounted cash flows
NPV Project = 3455263.27
Where
Discounting factor = (1 + discount rate)^(Corresponding period in years)
Discounted Cashflow= Cash flow stream/discounting factor
Project
IRR is the rate at which NPV =0
IRR 23.70%
Year 0 1 2 3 4 5 6 7 8
Cash flow stream -7676401.000 2225200.000 2225200.000 2225200.000 2225200.000 2225200.000 2225200.000 2225200.000 2225200.000
Discounting factor 1.000 1.237 1.530 1.893 2.341 2.896 3.583 4.432 5.482
Discounted cash flows project -7676401.000 1798868.211 1454218.426 1175600.979 950364.565 768281.775 621084.695 502089.481 405892.867
NPV = Sum of discounted cash flows
NPV Project = 0.000
Where
Discounting factor = (1 + discount rate)^(Corresponding period in years)
Discounted Cashflow= Cash flow stream/discounting factor
IRR= 23.70%

Related Solutions

Blossom Industries management is planning to replace some existing machinery in its plant. The cost of...
Blossom Industries management is planning to replace some existing machinery in its plant. The cost of the new equipment and the resulting cash flows are shown in the accompanying table. The firm uses an 18 percent discount rate for projects like this. Should management go ahead with the project? Year Cash Flow 0 -$3,029,000 1 836,610 2 874,500 3 1,100,000 4 1,373,260 5 1,589,400 What is the NPV of this project? (Enter negative amounts using negative sign e.g. -45.25. Do...
Sandhill Corp. management is planning to spend $650,000 on a new marketing campaign. They believe that...
Sandhill Corp. management is planning to spend $650,000 on a new marketing campaign. They believe that this action will result in additional cash flows of $343,000 each year for three years. If the discount rate is 17.5 percent, what is the NPV on this project?
Cullumber Corp. management is planning to spend $650,000 on a new marketing campaign. They believe that...
Cullumber Corp. management is planning to spend $650,000 on a new marketing campaign. They believe that this action will result in additional cash flows of $336,000 each year for three years. If the discount rate is 17.5 percent, what is the NPV on this project? (Enter negative amounts using negative sign e.g. -45.25. Do not round discount factors. Round other intermediate calculations and final answer to 0 decimal places, e.g. 1,525.)
Ivanhoe Corp. is a fast-growing company whose management expects it to grow at a rate of...
Ivanhoe Corp. is a fast-growing company whose management expects it to grow at a rate of 23 percent over the next two years and then to slow to a growth rate of 17 percent for the following three years. If the last dividend paid by the company was $2.15. What is the dividend for the 1st year? (Round answer to 3 decimal places, e.g. 15.250.) D1: $______ What is the dividend for the 2nd year? (Round answer to 3 decimal...
A new waste treatment plant has been planned to replace an existing small aging plant for...
A new waste treatment plant has been planned to replace an existing small aging plant for your home town. Discuss the MOEs for (i)the overall system, (ii)each phase of the overall system development,and (iii)the operations phase of any of the plant’s processes.
            The Fukushima Power plant is planning construction of a new plant to generate electricity four...
            The Fukushima Power plant is planning construction of a new plant to generate electricity four years hence and must decide now between a small, medium, or large-sized plant. The exact size needed is uncertain because future demands can only be estimated. Forecasters have estimated future demands and their likelihoods as follows: Level of Demand Probability High 0.30 Medium 0.55 Low 0.15 In the following, all the future costs and earnings have been adjusted to their present worth: If a...
A power plant is planning construction of a new plant to generate electricity four years hence...
A power plant is planning construction of a new plant to generate electricity four years hence and must decide now between a small, medium, or large-sized plant. The exact size needed is uncertain because future demands can only be estimated. Forecasters have estimated future demands and their likelihoods as follows: Level of Demand Probability High 0.30 Medium 0.55 Low 0.15             In the following, all the future costs and earnings have been adjusted to their present worth: The capacity of...
NEW NUMBERS: A chemical plant stores spare parts for maintenance in a large warehouse. Throughout the...
NEW NUMBERS: A chemical plant stores spare parts for maintenance in a large warehouse. Throughout the working day, maintenance personnel go to the warehouse to pick up supplies needed for their jobs. The warehouse receives a request for supplies, on average, every three minutes. The average request requires 2.75 minutes to fill. Maintenance employees are paid $21.50 per hour and warehouse employees are paid $16 per hour. The warehouse operates 8 hours per day. a) Based on the number of...
Celtic Inc is considering expanding their existing vegetable processing operations with a new plant in Ireland....
Celtic Inc is considering expanding their existing vegetable processing operations with a new plant in Ireland. The plant is expected to produce 8,472,000 pounds of processed vegetables each year for the next 15 years (1,000 pounds per hour, 24 hours per day, 353 days per year). The land for the plant will cost approximately $500,000. Construction of the physical plant building will cost approximately $18,500,000, and the required investment in equipment will be an additional $22,500,000. The initial investment in...
Trademark Inc. is planning to set up a new manufacturing plant in New York to produce...
Trademark Inc. is planning to set up a new manufacturing plant in New York to produce safety tools. The company bought some land six years ago for $4.3 million in anticipation of using it as a warehouse and distribution site, but the company has since decided to rent these facilities from a competitor instead. If the land were sold today, the company would sell for $4.6 million on an after-tax basis. In four years, the land could be sold for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT