PMT function in Excel.

The PMT function in Excel is used to calculate the payment for a loan based on constant payments and a constant interest rate.
PMT(rate, nper, pv, [fv], [type])
Parameters:
rate: The interest rate for each period.

nper: The total number of payment periods.

pv: The present value, or the total amount that a series of future payments is worth now; also known as the principal.

fv: (Optional) The future value, or a cash balance you want to attain after the last payment is made. If omitted, it is assumed to be 0.

type: (Optional) The number 0 or 1 and indicates when payments are due. If omitted, it is assumed to be 0.
@aapkaapnabls

Видео PMT function in Excel. канала Aapka Apna BLS