How To Use Microsoft Excel Pmt Function
Excel PMT Formula You can get the exact Syntax of the PMT Function in Microsoft Excel by typing =PMT in any cell of an Excel worksheet. Syntax of PMT Function = PMT(Rate, NPER, PV, [FV], [Type]) Rate: Interest Rate NPER: The number of periods required to pay the loan PV: The present value of the loan [FV]: [Optional] – The future value or cash balance that you want after the last payment is made....