In: Finance
C.M. Burns Enterprises, Inc. is considering investing in a machine to produce computer keyboards. The price of the machine will be $400,000 and its economic life five years. The machine will be fully depreciated by the straight line method. The machine will produce 10,000 units of keyboards each year. The price of each keyboard will be $40 in the first year, and it will increase at 5% per year. The production cost per unit of the keyboard will be $20 in the first year, and it will increase at 10% per year. The corporate tax rate for the company is 34%. If the appropriate discount rate is 15%, what is the NPV of the investment?
**Could you show the work on how the answer was calculated. If solved by using excel could u also provide the formulas used in the calculations? Thank you.