cell $114,$ insert the PMT unction. Divide the APR $($cell $17)$ by the number of months in a year $($cell $18).$ The term is one year $(12$ months$).$ Use a cell reference. The Total Cost for the city is the present value. Use relative and mixed $($or absolute$)$ references correctly. Make sure the result is a positive value.Copy the function in cell $114$ and use the Paste Formulas option to copy the function to the range $115$:$119$ without removing the border in cell $119.$