Question

In: Finance

Puffy Clouds, a maker of data storage products, is considering adding a new manufacturing facility. The...

Puffy Clouds, a maker of data storage products, is considering adding a new manufacturing facility. The new facility would be housed in an unused building that the firm bought 8 years ago for $5 million; the building is being depreciated over a 20 life to a salvage value of zero. The building can be sold today for $2 million, and the market value of the building is expected to increase at 5% per year going forward. The new facility would require the purchase of $50 million of equipment that would be depreciated straight line to zero over a useful life of 5 years. However, the firm expects this equipment would have a scrap value of $250,000 at the end of its 5-year life. The firm would finance the equipment purchase with a five-year debt issue that would carry an interest rate of 5% p.a. The new facility would add $20 million to annual revenues, which are currently $100 million per year. The higher manufacturing efficiency of the new facility would reduce annual operating costs from 40% of revenues to 35% for both existing and new sales revenues. The new facility would require a $500,000 increase in net working capital, which would be recovered at the end of the project. The firm’s tax rate is 20% and the required rate of return is 8%. Calculate the NPV and IRR for the new facility (25 points)


five year life

Solutions

Expert Solution

The $5 million cost of the land 8 years ago is a sunk cost and irrelevant. The $2 million sale price of the land today is an opportunity cost and is relevant. The sale price of the land in 5 years is a relevant cash flow as well. The fact that the company is keeping the land rather than selling it is unimportant. The land is an opportunity cost in 5 years and is a relevant cash flow for this project.

The debt payments (finance expenses) should not be considered separately because the required rate of return incorporates the cost of debt already.

Operating cash flow (OCF) each year = income after tax + depreciation

profit on sale of equipment at end of year 5 = sale price - book value

book value is zero as the equipment is fully depreciated.

after-tax salvage value = salvage value - tax on profit on sale of equipment

NPV and IRR are calculated using NPV and IRR functions in Excel

NPV is $15,194,084

IRR is 18.17%


Related Solutions

Birnham Motors is considering adding a new location to their existing car lots. The new facility...
Birnham Motors is considering adding a new location to their existing car lots. The new facility will cost $12.7 million to construct. Management uses a discount rate of 10.9%. They anticipate the following cash flows for next seven years: Year Cash Flow 1 2.2m 2 2.5m 3 2.9m 4 3.1m 5 3.4m 6 3.6m 7 3.9m The proposed project's net present value is closest to:
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $570,000. The...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $570,000. The facility is to be fully depreciated on a straight-line basis over seven years. It is expected to have no resale value at that time. Operating revenues from the facility are expected to be $425,000, in nominal terms, at the end of the first year. The revenues are expected to increase at the inflation rate of 4 percent. Production costs at the end of the...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $450,000.
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $450,000. The facility is to be fully depreciated on a straight-line basis over seven years. It is expected to have no resale value at that time. Operating revenues from the facility are expected to be $365,000, in nominal terms, at the end of the first year. The revenues are expected to increase at the inflation rate of 4 percent. Production costs at the end of the...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $540,000. The...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $540,000. The facility is to be fully depreciated on a straight-line basis over seven years. It is expected to have no resale value at that time. Operating revenues from the facility are expected to be $410,000, in nominal terms, at the end of the first year. The revenues are expected to increase at the inflation rate of 2 percent. Production costs at the end of the...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $560,000. The...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $560,000. The facility is to be fully depreciated on a straight-line basis over seven years. It is expected to have no resale value at that time. Operating revenues from the facility are expected to be $420,000, in nominal terms, at the end of the first year. The revenues are expected to increase at the inflation rate of 5 percent. Production costs at the end of the...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $550,000. The...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $550,000. The facility is to be fully depreciated on a straight-line basis over seven years. It is expected to have no resale value at that time. Operating revenues from the facility are expected to be $415,000, in nominal terms, at the end of the first year. The revenues are expected to increase at the inflation rate of 3 percent. Production costs at the end of the...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $600,000. The...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $600,000. The facility is to be fully depreciated on a straight-line basis over seven years. It is expected to have no resale value at that time. Operating revenues from the facility are expected to be $440,000, in nominal terms, at the end of the first year. The revenues are expected to increase at the inflation rate of 3 percent. Production costs at the end of the...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $490,000. The...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $490,000. The facility is to be fully depreciated on a straight-line basis over seven years. It is expected to have no resale value at that time. Operating revenues from the facility are expected to be $385,000, in nominal terms, at the end of the first year. The revenues are expected to increase at the inflation rate of 5 percent. Production costs at the end of the...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $620,000. The...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $620,000. The facility is to be fully depreciated on a straight-line basis over seven years. It is expected to have no resale value at that time. Operating revenues from the facility are expected to be $450,000, in nominal terms, at the end of the first year. The revenues are expected to increase at the inflation rate of 4 percent. Production costs at the end of the...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $500,000. The...
Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $500,000. The facility is to be fully depreciated on a straight-line basis over seven years. It is expected to have no resale value at that time. Operating revenues from the facility are expected to be $390,000, in nominal terms, at the end of the first year. The revenues are expected to increase at the inflation rate of 4 percent. Production costs at the end of the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT