PMT
Basic Overview
Description  Calculates the periodic payment required for a recurring investment based on a constant interest rate, a number of recurring payments and a present value and either ordinary annuity or annuity due (type) indicating whether payments are due at the beginning or the end of period. 

Signature  PMT('Rate', 'Nper', 'Pv' [, 'Fv' , ["Type"]]) 
Parameters 

Notes 

Limitations 

Example
Rate (Interest Rate)  0,03 

Nper (Number of Periods)  24 
Pv (Present Value)  6000 
Fv (Future Value)  0 
Type Payment at Beginning of Period (Annuity Due) = 1 Payment at End of Period (Ordinary Annuity) = 0  0 
Valsight Formula  PMT(Rate, Nper, Pv, Fv, Type) 
Result  354,28 *the result is negative as it is marked as a payment 