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.
PMT('Rate', 'Nper', 'Pv' [, 'Fv' , ["Type"]])
(Number of Periods)
Payment at Beginning of Period (Annuity Due) = 1
Payment at End of Period (Ordinary Annuity) = 0
PMT(Rate, Nper, Pv, Fv, Type)
*the result is negative as it is marked as a payment