Advanced Excel

Hi Wayne, Thanks for the post, welcome to the forum, in answer to your question;
The PMT function, one of Excel's Financial functions, can be used to calculate the payments for a loan or the future value of an investment. The syntax for the PMT function is: = PMT ( rate , nper , pv , fv , type )
rate - the annual interest rate for the loan.
nper - the total number of payments for the loan.
pv - the present value or the amount borrowed or the "principal of the loan.
fv - future value - for a loan this will be