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