Under a special arrangement, Swineyard Company has an opportunity to market a new product for a five-year period. The product will be purchased from the manufacturer, with Swineyard Company responsible for all costs of promotion and distribution. The licensing arrangement could be renewed at the end of the five-year period. After careful study, Swineyard Company has estimated the following costs and revenues for the new product Cost of equipment needed $60,000 Working capital needed 100,000 Overhaul of equipment in 4 years 5,000 Salvage value of the equipment in 5 years 10,000 Annual Revenue and costs: Sales Revenue 200,000 Cost of Goods Sold 125,000 35,000 Operating costs At the end of the five year period, the working capital would be released for investment elsewhere if Swineyard decides not to renew the licensing arrangement. Swineyard uses a 14% discount rate to compare projects against. What is the excel formula used to get NPV and PV in this problem?|