IPMT

IPMT(rate, per, nper, pv [,fv] [,type])

Returns the interest amount paid on a given period on a loan with fixed interest.

rate	The fixed interest rate per period.
per	The period for which you want to find the interest.
nper	The total number of payments.
pv	The present value.
fv	(Optional) The future value (or cash balance) after all the cash flows (0).
type	(Optional) The number identifying when the payments are due: 0 = the end of the period (default) 1 = the start of the period

REMARKS

* The amount of principal paid back every period is NOT constant.
* The amount repaid every period is constant.
* The present value is the total amount that the payments are worth now.
* 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 be expressed in the same units of time: years, months or days.
* The "per" must be in the range 1 to "nper".
* If "fv" is left blank, then 0 is used.
* If "type" is left blank, then 0 is used.
* If "type" = 0, then payments are made in arrears.
* If you make monthly payments on a four-year loan at 12% annual interest, use 12%/12 for rate and 4*12 for "nper".
* If you make annual payments on a four year loan at 12% annual interest, use 12% for "rate" and 4 for "nper".
* This function is often used alongside the PV function to create an amortisation table.
* If you add the PPMT and the IPMT for the same period you will get the PMT.
* You can use the PMT function to return the full amount (principal + interest) paid every period on a loan with fixed interest.
* You can use the PPMT function to return the principal amount paid on a given period on a loan with fixed interest.
* The equivalent VBA function is VBA.IPMT
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=IPMT(10%/12, 1, 5*12, 10000) = ($83.33)
2	=IPMT(10%/12, 2, 5*12, 10000) = ($82.26)
3	=IPMT(10%/12, 3, 5*12, 10000) = ($81.17)
4	=IPMT(5%/12, 1, 12*15, 50000) = ($208.33)
5	=IPMT(5%/12, 1215, 1215, 50000) = ($1.64)
6	=IPMT(0.1/12, 1, 36, 8000) = -$66.67
7	=IPMT(0.1, 3, 3, 8000) = -$292.45
8	=IPMT(1.2, 1, 3, 5000, 5000) = -$6,000.00
9	=IPMT(1.2, 1, 3, 2000, 5000) = -$2,400.00
10	=IPMT(1.2, 4, 3, 2000, 5000) = #NUM!
11	=IPMT(1.2, "some text", 3, 2000, 5000) = #VALUE!

1 - How much interest is paid back in the first month if I borrow £10,000 for 5 years at an annual interest rate of 10%.
2 - How much interest is paid back in the second month if I borrow £10,000 for 5 years at an annual interest rate of 10%.
3 - How much interest is paid back in the third month if I borrow £10,000 for 5 years at an annual interest rate of 10%.
4 - How much interest is paid back in the first month if I borrow £50,000 for 15 years at an annual interest rate of 5%.
5 - How much interest is paid back in the last month if I borrow £50,000 for 15 years at an annual interest rate of 5%.
6 - What is the amount of interest that is paid back in the first month if I borrow £8,000 for 3 years at an annual interest rate of 10%.