Utilize your financial knowledge, give your answer or opinion to the input question or subject . Answer format is not limited.

Given a certain yearly savings, how much can I spend on a capital improvement? NPV of future cash flow
This investment does not have a payback period as the net present value of your investment is negative. Your investment requires an initial cash outlay of $40,000 followed by annual savings of $2060 for the next 20 years. Your discount rate is 5% at which the NPV is $-14327.85 as calculated below by using this JavaScript financial functions library tadJS that is based on a popular tadXL add-in for Excel 2007, 2010 and 2013.