Kč - Kč ( ) - £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč € - € - € / / / / € - € Kč - Kč Kč - Kč Kč - Kč Kč - Kč - - - - - - Kč - Kč - Kč - - Kč - Kč - Kč : : : : Yes Yes No True True False On On Off ¥€ ( € ) € - € % / / ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 ISPMT Function Result TRUE Sheet Result Description 1 TRUE Simple ISPMT formulas with local references and values Function Expected Correct FunctionString Comment Data Description Data Description -214.29 Kč -214.285714285714 TRUE =ISPMT(0.05,5,7,15000) 10.00% 0.1 Annual interest rate -20.83 Kč -20.8333333333333 TRUE =ISPMT(0.075/12, 8, 2*12, 5000) 1 1 Period Err:504 error TRUE =ISPMT(0.06/52, 30, 4*52, 8000, 0 ,1) 3 3 Number of years in the investment -204.75 Kč -204.75 TRUE =ISPMT(0.0525/1, 4, 10*1, 6500) 8000 8000000 Amount of loan -64.81 Kč -64.8148148148148 TRUE =ISPMT(I2/12, I3, I4*12,I5) 0.00 Kč 0 TRUE =ISPMT(I2, 3,I4, I5) 0.00 Kč 0 TRUE =ISPMT(0,5,7,15000) -750.00 Kč -750 TRUE =ISPMT(0.05,0,7,15000) #NUM! error TRUE =ISPMT(0.05,5,0,15000) 0.00 Kč 0 TRUE =ISPMT(0.05,5,7,0) 0.00 Kč 0 TRUE =ISPMT(0.05,5,7,) -20.8333333333333 -20.8333333333333 TRUE =ISPMT(0.075/12, 8,2*12, 5000) -7.89940828402367 -7.89940828402367 TRUE =ISPMT(0.06/52,30, 4*52,8000) -7.89940828402367 -7.89940828402367 TRUE =ISPMT(0.06/52, 30, 4*52, 8000) Err:511 error TRUE =ISPMT(0.05,5,7) #NUM! error TRUE =ISPMT(0.05,5,,15000) Err:504 error TRUE =ISPMT(0.06/52, 30, 4*52, 8000, ,1) Err:504 error TRUE =ISPMT(0.06/52, 30, 4*52, 8000, 0 ) Err:504 error TRUE =ISPMT(0.06/52, 30, 4*52, 8000, 0 ,2) Err:504 error TRUE =ISPMT(0.06/52, 30, 4*52, 8000, 0 ,-2) -64814.8148148148 -64814.8148148148 TRUE =ISPMT(L2/12,L3,L4*12,L5) -533333.333333333 -533333.333333333 TRUE =ISPMT(L2,1,L4,L5) 0 0 TRUE =ISPMT(L2,1,L4,) #NUM! error TRUE =ISPMT(L2,1,,L5) -800000 -800000 TRUE =ISPMT(L2,,L4,L5) -800000 -800000 TRUE =ISPMT(L2,0,L4,L5) 0 0 TRUE =ISPMT(0,1,L4,L5) 0 0 TRUE =ISPMT(,1,L4,L5) ISPMTSummary: Compute the interest payment of an amortized loan for a given period.Syntax: ISPMT( Number Rate ; Number Period ; Number Nper ; Number Pv )Returns: CurrencyConstraints: None.Semantics: Computes the interest payment of an amortized loan for a given period. The parameters are:Rate: the interest rate per period.Period: the period for which the interest is computedNper: the total number of payment periods.Pv: the amount of the investment 4