PMT

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

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

rateThe fixed interest rate per period.
nperThe total number of payments.
pvThe 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 FV function to return the future value for a series of equal cash flows at regular intervals.
* You can use the IPMT function to return the interest amount paid on a given period on a loan with fixed interest.
* You can use the NPER function to return the number of periods for an investment.
* You can use the PV function to return the present value of a series of equal cash flows at regular intervals.
* 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 RATE function to return the interest rate for a series of equal cash flows at regular intervals
* 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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top