Question

In: Finance

Blue Buffalo has a new 4-year project to evaluate. The Installed Cost of the project’s long-term...

Blue Buffalo has a new 4-year project to evaluate. The Installed Cost of the project’s long-term assets is $200 million. The project also requires an initial Net Working Capital increase of $30 million (no further changes in NWC are required) when implemented at t=0. This initial Net Working Capital of $30 million is also assumed to be fully recovered when the project is terminated at t=4 years. The project’s assets fit into a 3 year IRS MACRS depreciation schedule as follows: Year 1 -- 33%; Year 2 -- 45%; Year 3 -- 15%; Year 4 -- 7%. The project will be terminated exactly four years from today (t=4) and this project’s assets will then be sold at an estimated $40 million salvage value. If the project is accepted it will increase the firm’s revenue and operating costs by $110 million and $40 million, respectively, for each of the following four years (t=1 through t=4). The corporate tax rate is 40%. The cost of capital for this project is r=12% per year. This is a stand alone project. Calculate the NPV and IRR. Should this project be accepted or rejected?

Solutions

Expert Solution

Formula Year (n) 0 1 2 3 4
Initial investment (II)                     200
Revenue increase ('R)                       110                      110                               110                        110
Op.cost increase (OC)                          40                         40                                 40                          40
3-year MACRS dep. Schedule Depreciation rate ('r) 33% 45% 15% 7%
II*r Depreciation (D)                          66                         90                                 30                          14
R-OC-D EBIT                            4                      (20)                                 40                          56
EBIT*(1-Tax rate) After-tax EBIT                            2                      (12)                                 24                          34
Add: depreciation (D)                          66                         90                                 30                          14
After-tax EBIT + D Operating Cash Flow (OCF)                          68                         78                                 54                          48
NWC change                     (30)                          30
salvage value*(1-Tax rate) After-tax salvage value (SV)                          18
SV + NWC + FCF - II Free Cash Flow (FCF)                   (230)                          68                         78                                 54                          96
1/(1+d)^n Discount factor @ 12%                 1.000                    0.893                   0.797                           0.712                    0.636
FCF*Discount factor PV of FCF             (230.00)                    61.07                   62.18                           38.44                    60.76
Sum of all PVs NPV                 (7.56)
Using IRR() function and FCFs IRR 10.49%

The project should not be accepted as it has a negative NPV and its IRR is less than the cost of capital of 12%. It is a loss-making project.


Related Solutions

What are the concerns (considerations) of a project’s long–term lenders and equity investors?
What are the concerns (considerations) of a project’s long–term lenders and equity investors?
A company is evaluating a new 4-year project. The equipment necessary for the project will cost...
A company is evaluating a new 4-year project. The equipment necessary for the project will cost $3,600,000 and can be sold for $725,000 at the end of the project. The asset is in the 5-year MACRS class. The depreciation percentage each year is 20.00 percent, 32.00 percent, 19.20 percent, 11.52 percent, and 11.52 percent, respectively. The company's tax rate is 40 percent. What is the aftertax salvage value of the equipment?
TI Inc. is considering a 4-year investment project. The project’s cash flows are summarized in the...
TI Inc. is considering a 4-year investment project. The project’s cash flows are summarized in the table below. Management is expecting at least a 8% annual return from this investment. What are the IRR and MIRR of the following cash flows? Which metric you would recommend to Truman’s CEO and why? (Explain briefly) Year 0 1 2 3 4 Cash Flow - $450,000 $9,000 $10,000 $15,000 $790,000
Nippon Inc is considering a project that has an up-front cost of $500,000. The project’s subsequent...
Nippon Inc is considering a project that has an up-front cost of $500,000. The project’s subsequent cash flows depend on whether its products become the industry standard. There is a 60% chance that products will become the industry standard, in which case the project’s expected cash flows will be $120,000 per year for the next 7 years. There is a 40% chance that products will not become the industry standard, in which case the project’s expected cash flows will be...
Project EvaluationDog Up! Franks is looking at a new sausage system with an installed cost of...
Project EvaluationDog Up! Franks is looking at a new sausage system with an installed cost of $375,000. This cost will be depreciated straight-line to zero over the project’s 5-year life, at the end of which the sausage system can be scrapped for $25,000. The sausage system will save the firm $95,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $15,000. If the tax rate is 24 percent and the discount...
Suppose a company has proposed a new 4-year project. The project has an initial outlay of...
Suppose a company has proposed a new 4-year project. The project has an initial outlay of $25,000 and has expected cash flows of $7,000 in year 1, $9,000 in year 2, $12,000 in year 3, and $13,000 in year 4. The required rate of return is 11% for projects at this company. What is the net present value for this project? (Answer to the nearest dollar.)
Suppose a company has proposed a new 4-year project. The project has an initial outlay of...
Suppose a company has proposed a new 4-year project. The project has an initial outlay of $17,000 and has expected cash flows of $8,000 in year 1, $9,000 in year 2, $10,000 in year 3, and $14,000 in year 4. The required rate of return is 15% for projects at this company. What is the profitability index for this project? (Answer to the nearest hundredth, e.g. 1.23)
Suppose a company has proposed a new 4-year project. The project has an initial outlay of...
Suppose a company has proposed a new 4-year project. The project has an initial outlay of $29,000 and has expected cash flows of $7,000 in year 1, $8,000 in year 2, $11,000 in year 3, and $13,000 in year 4. The required rate of return is 14% for projects at this company. What is the profitability index for this project? (Answer to the nearest hundredth, e.g. 1.23)
ABC Corporation has hired you to evaluate a new FOUR year project for the firm. The...
ABC Corporation has hired you to evaluate a new FOUR year project for the firm. The project will require the purchase of a $772,200.00 work cell. Further, it will cost the firm $57,200.00 to get the work cell delivered and installed. The work cell will be straight-line depreciated to zero with a 20-year useful life. The project will require new employees to be trained at a cost of $58,400.00. The project will also use a piece of equipment the firm...
ABC Corporation has hired you to evaluate a new FOUR year project for the firm. The...
ABC Corporation has hired you to evaluate a new FOUR year project for the firm. The project will require the purchase of a $796,900.00 work cell. Further, it will cost the firm $57,100.00 to get the work cell delivered and installed. The work cell will be straight-line depreciated to zero with a 20-year useful life. The project will require new employees to be trained at a cost of $58,400.00. The project will also use a piece of equipment the firm...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT