# PMT

PMT(rate, nper, pv [,fv] [,type])

Returns the full amount (principal + interest) paid every period on a loan with fixed interest.

 rate The fixed interest rate per period. nper The total number of payments. pv The present value of the loan. fv (Optional) The future value of the loan. type (Optional) The number indicating when the payments are due:0 = the end of the period (default)1 = the start of the period

 REMARKS
 * For an illustrated example refer to the [[Loan Repayments]] page.* A negative number represents any cash you pay out. * A positive number represents any cash you receive (start with or end with).* The "rate" and "nper" must have the same units.* The "rate" and "nper" MUST be expressed in the same units of time: years, months or days.* If "type" is left blank, then 0 is used.* If "type" = 0, then payments are made in arrears.* If you add the PPMT and the IPMT for the same period you will get the PMT.* You can use the PPMT function to return the principal amount paid on a given period on a loan with fixed interest.* You can use the IPMT function to return the interest amount paid on a given period on a loan with fixed interest.* The equivalent VBA function is VBA.PMT* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =PMT(0.1/12,5*12,-10000) = \$212.47 2 =PMT(0.1/12,5*12,-10000,,1) = \$210.71 3 =PMT(0.1/12,5*12,-10000,,0) = \$212.47 4 =PMT(0.1/52,5*52,-10000,,0) = \$48.91 5 =FV(0.1/52,5*52,-48.91) = \$16,478.93 6 =PMT(0.085,10,-25000) = \$3,810.19 7 =PMT(0.056/12,3*12,-5000,500) = \$138.42

 1 - How much would I have to pay back every month if I took out a loan for £10,000 over 5 years with an annual interest rate of 10%.2 - How much would I have to pay back every month if I took out a loan for £10,000 over 5 years with an annual interest rate of 10% and made the payments at the start of the month.3 - How much would I have to pay back every month if I took out a loan for £10,000 over 5 years with an annual interest rate of 10% and made the payments at the end of the month.4 - How much would I have to pay back every week if I took out a loan for £10,000 over 5 years with an annual interest rate of 10% and made the payments at the end of the week.5 - How much would I end up paying back if I took out a loan for £10,000 over 5 years with an annual interest rate of 10%.6 - How much would I have to pay back every year if I took out a loan for £25,000 over 10 years with an annual interest rate of 8.5%.7 - How much would I have to pay back every month if I took out a loan for £5,000 over 3 years with an annual interest rate of 5.6% and with a lump sum of £500 to pay at the end of the 3 years.