Payment P x r n x 1 r nn t 1 r nn t - 1. The PMT function below calculates the monthly payment. The PMT function can be used to figure out the future payments for a loan assuming constant payments and a constant interest rate.
Ignore the last two variables and input your variables as follows.
Pv required argument The present value or total amount that a series of future payments is worth now. R or Rate is the rate used per compounding period. 2 Note that the carat indicates that youre raising a number to the power indicated after the carat. PMT PV x PV FV 1 r n -1 x -r 1 b Where.