JJ Enterprises is considering the purchase of a new machine that will produce thumb drives. The new machine will require an initial investment of $100,000 and has an economic life of five years and will be fully depreciated by the straight line method. The machine will produce 15,000 thumb drives per year with each costing $2.00 to make. Each will be sold at $4.50. Assume JJ Enterprises uses a discount rate of 14 percent and has a tax rate of 34 percent. What is the NPV of the project and should JJ Enterprises make the purchase.

ZXC has 20 annual lease payments remaining in its contract. The next one for $2.5m is due in 4 months. The payments decrease with the equipment value by 4% per year. Using a 12% discount rate, what is todays present value of the remaining lease payments?

Please show work in excel please