Categories: Formula

Adjust Prepayment in PPMT Formula for Forex Trading


The Excel PMT function can be used to calculate the periodic payments on a loan. It can also be used to adjust the amount of the prepayment by providing the amount as the “additional payment” argument. To do this, simply enter the amount you want to prepay as the “additional payment” argument in the PMT formula. This will change the equation’s output so that it reflects the additional amount of money you entered when calculating the periodic payments. This is a useful tool for those who are looking to prepay their loans and would like to see how it would affect their payments.

Read More