ISPMT(rate, per, nper, pv)

Returns the interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly).

rateThe fixed interest rate per period.
perThe period for which you want to find the interest.
nperThe total number of payments.
pvThe present value.

Remarks

* This function was originally provided to allow backwards compatibility with Lotus 1-2-3 and should never be used.
* Instead of using this function you should use the IPMT function which apart from giving the correct value has more flexibility.
* This function uses an incorrect formula to calculate the interest which is why the result is different to that returned by IPMT.
* This function assumes that principle payments are constant but interest varies which means that the total payment varies.
* IPMT assumes that total payments are constant meaning both the principle payment and the interest vary.
* The amount of principal paid back every period IS constant.
* The amount repaid every period is not constant.
* The "per" must be in the range 0 to ('nper' - 1).
* For the Microsoft documentation refer to support.office.com

 A
1=ISPMT(10%/12,0,5*12,10000) = -83.333
2=ISPMT(10%/12,1,5*12,10000) = -81.944
3=ISPMT(10%/12,2,5*12,10000) = -80.556
4=ISPMT(5%/12,0,12*15,50000) = -208.333
5=ISPMT(0.1/12,0,36,8000) = -66.667

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%. The result is incorrect.
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%. The result is incorrect.
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 - 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%.

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