Blair Bookstores is thinking about expanding its facilities. In considering the expansion, Blair's finance staff has obtained the following information:
The expansion will require the company to purchase today (t = 0) $5 million of equipment. The equipment will be depreciated over the following four years at the following rate:
The expansion will require the company to increase its net operating working capital by $500,000 today (t = 0). This net operating working capital will be recovered at the end of four years (t = 4).
The equipment is not expected to have any salvage value at the end of four years.
The expansion will increase the company's dollar sales. The projected increases, all relative to current sales are:
Year 1:$3.0 million
Year 2:3.5 million
Year 3:4.5 million
Year 4:4.0 million
(For example, in Year 4 sales will be $4 million more than they would have been had the project not been undertaken.) After the fourth year, the equipment will be obsolete, and will no longer provide any additional incremental sales.
· The company's tax rate is 40 percent and the company's other divisions are expected to have positive tax liabilities throughout the project's life.
· If the company proceeds with the expansion, it will need to use a building that the company already owns. The building is fully depreciated; however, the building is currently leased out. The company receives $300,000 before-tax rental income each year (payable at year end). If the company proceeds with the expansion, the company will no longer receive this rental income.
· The project's WACC is 10 percent.
What is the proposed project's NPV?
e. -$ 748,378
In Excel, the response calculates the NPV.