FINANCIAL
ACCRINT
ACCRINT('01/01/2011', '02/01/2011', '07/01/2014', 0.1, 1000, 1, 0)
350
CUMIPMT
CUMIPMT(0.1/12, 30*12, 100000, 13, 24, 0)
-9916.772514
CUMPRINC
CUMPRINC(0.1/12, 30*12, 100000, 13, 24, 0)
-614.0863271
DB
DB(1000000, 100000, 6, 1, 6)
159500
DDB
DDB(1000000, 100000, 6, 1, 1.5)
250000
DOLLARDE
DOLLARDE(1.1, 16)
1.625
DOLLARFR
DOLLARFR(1.625, 16)
1.1
EFFECT
EFFECT(0.1, 4)
0.103812891
FV
FV(0.1/12, 10, -100, -1000, 0)
2124.874409
FVSCHEDULE
FVSCHEDULE(100, [0.09,0.1,0.11])
133.089
IPMT
IPMT(0.1/12, 6, 2*12, 100000, 1000000, 0)
928.8235718
IRR
IRR([-75000,12000,15000,18000,21000,24000], 0.075)
0.057151429
ISPMT
ISPMT(0.1/12, 6, 2*12, 100000)
-625
MIRR
MIRR([-75000,12000,15000,18000,21000,24000], 0.1, 0.12)
0.079717104
NOMINAL
NOMINAL(0.1, 4)
0.096454756
NPER
NPER(0.1/12, -100, -1000, 10000, 0)
63.39385423
NPV
NPV(0.1, -10000, 2000, 4000, 8000)
1031.350318
PDURATION
PDURATION(0.1, 1000, 2000)
7.272540897
PMT
PMT(0.1/12, 2*12, 100000, 1000000, 0)
-42426.08564
PPMT
PPMT(0.1/12, 6, 2*12, 100000, 1000000, 0)
-43354.90921
PV
PV(0.1/12, 2*12, 1000, 10000, 0)
-29864.95026
RATE
RATE(2*12, -1000, -10000, 100000, 0, 0.1)
0.065178912