Problem 7 (20). A company has a new product whose sales are expected to be 1.2, 3.5, 7, 5 and 3 million units per year over the next five years. Production, distribution and overhead costs are stable at $120 per unit. The price of the product will be $200 per unit for the first two years and then $180, $160 and $140 for the next three tears. The upfront R&D and capital costs are $300 million. If market interest rate is 15%, what is the present worth of the new product? Note: Solve this problem in Excel and attach printout of your calculations.