PMT FORMULA IN EXCEL

=PMT(interest rate, # of periods, present value)

If you work in industrial banking, real estate, FP&A or any monetary analyst setting that handles financial obligation routines, you’ll want to recognize these 2 detailed formulas.

The PMT formula offers you the value of equivalent repayments over the life of a financing.