PMT Function

PMT Function Formula: =PMT (rate, nper, pv, [fv], [type]) Rate: The annual percentage rate of interest. NPER: The total amount paid. PV: The amount of the loan or the sum of all future payments. This argument, which is optional and by default set to zero, allows you to specify the desired target cash amount after…