Jannsen Limited is contemplating investing in solar panels to reduce its need to purchase electricity from its local hydro company. The panels are estimated to cost $2,000,000 and will have a 15-year useful life with no salvage value. The electricity cost savings are expected to be about $200,000 per year. Management expects there will be some intangible benefits arising from purchasing the solar panels such as increased goodwill among its younger customers who are, on average, environmentally conscious. This could lead to increased repeat business with these customers in the future. Jannsen uses a discount rate of 10% when evaluating capital expenditures.

Required:

1.Calculate the net present value of the investment in solar panels.(Hint: Use Microsoft Excel to calculate the discount factor(s).