# PMT

## Basic Overview

AVAILABLE SINCE 5.3.1

 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 Rate -> The interest rateNper -> Number of periods: the number of payments to be madePv -> Present value:  the current value of the annuityFv ->  [Optional] - Future value: the future value remaining after the final payment has been made. If not entered, 'Fv' is set to 0.Type -> [Optional] type (1=pmt at beginning of period (Annuity Due), 0=pmt at end of period (Ordinary Annuity)). By default 'Type' is set to 0. Notes Argument 'Pv' is the leading input node.A leading input node is a function argument, for which we assume the levels to be correct. All other input nodes need to have the same dimensionality.Each input node can be a single numberProviding all inputs with the same dimensionality results in a noticeable performance improvement Limitations All other inputs must not contain levels that are not in the leading input node 'Pv'. All level values that are in the leading input node  'Pv' , must be in all the other input nodes.

## Example

 Rate(Interest Rate) 0,03 Nper(Number of Periods) 24 Pv(Present Value) 6000 Fv(Future Value) 0 TypePayment at Beginning of Period (Annuity Due) = 1Payment 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

## Contact

You may contact the Valsight Customer Support via:

+49 30 46799042

support@valsight.com

Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .

*Except Public holidays in Berlin, Germany.

JavaScript errors detected