Monthly Payment Formula Worksheet - CIESE

Monthly payments are thus based on 12 months and the standard interest rate provided. Use a PMT function to calculate the first client’s monthly payment in cell . J5. (Note that the value in . B3 . is an annual rate and must be converted to a monthly rate for use in the PMT function), using appropriate relative and absolute cell references. ................
................