In cell g8 in the summary worksheet, insert a date function to calculate the number of years between 1/1/2018 in cell h2 and the last remodel date in the last remodel column (cell f8). use relative and mixed references correctly. copy the function to the range g9: g57. unit 101 was last remodeled 13.75 years ago. ensure that the function you use displays that result.

An external consultant recommends that a plant installs a bank of capacitors for power factor correction. this will reduce the peak electrical demand charges by an average of 93 kw every month. the plant current pays $13 per kw in peak demand charges. the capacitor bank will include 223 kw of fixed capacitors, and 183 of variable capacitors. the fixed capacitors cost $59 per kw, and the variable capacitors will cost $65 per kw. the consultant charges 21% of the equipment costs to install the capacitors. because this project will reduce the demand for the electric utility, they are prepared to provide a one-time rebate of $42 per kw of reduced demand. what is the simple payback period for this project (in years)?