In cell J5, insert a function (PMT) to calculate the first client’s monthly payment.
Remember to convert the annual percentage rate into an appropriate periodic rate.
Think about how the nper (number of payments over the life of the loan) is calculated.
Change the sign of the result, inserting a minus sign before the function's name, in order to have the result display as a positive number instead of a negative number.
As this function will be copied to other cells, determine whether each cell reference should be absolute value of negative number.
Solved by X. B. in 15 mins