Bishop Department stores would like to expand by purchasing a new warehouse in Bristol. The store would cost $750,000 and have a life of 25 years. The salvage value would be $100,000. Annual costs for maintenance, insurance, and other cash expenses would total $70,000. Annual cash receipts resulting from this expansion are expected to be $135,000. The company's required rate of return is 10 percent. Construct an Excel spreadsheet to calculate the net present value and internal rate of return in a format like that in your textbook. Should Bishop purchase the warehouse? Explain