test suite

financial-timevalue

76 tests · 48 with documented divergences

Test	Subject	Formula	Category	DVs
`d83227`	CUMIPMT	`=CUMIPMT(0.05/12, 360, 100000, 1, 12, 0)`	value
`cfc663`	CUMIPMT	`=CUMIPMT(0.05/12, 360, 100000, 349, 360, 0)`	value
`9c7348`	CUMIPMT	`=CUMIPMT(0.05/12, 360, 100000, 0, 12, 0)`	value	2
`6f35ff`	CUMPRINC	`=CUMPRINC(0.05/12, 360, 100000, 1, 12, 0)`	value
`7aa751`	CUMPRINC	`=CUMPRINC(0.05/12, 360, 100000, 1, 360, 0)`	value
`eadb99`	CUMPRINC	`=CUMPRINC(0.05/12, 360, 100000, 1, 12, 2)`	value	3
`906051`	DB	`=DB(1000000, 100000, 6, 1, 12)`	value	1
`2bdd96`	DB	`=DB(1000000, 100000, 6, 2, 12)`	value	1
`e434f5`	DB	`=DB(1000000, 100000, 6, 1, 7)`	value
`cd4b89`	DDB	`=DDB(1000, 100, 10, 1)`	value	2
`3d42b6`	DDB	`=DDB(1000, 100, 10, 2)`	value	3
`ae34e8`	DDB	`=DDB(2400, 300, 10, 1, 1.5)`	value	2
`731255`	DDB	`=DDB(1000, 100, 10, 10)`	value
`027d0b`	EFFECT	`=EFFECT(0.12, 12)`	value	5
`3e7cc5`	EFFECT	`=EFFECT(0.05, 1)`	value	2
`086aa8`	EFFECT	`=EFFECT(0.05, 0)`	value	2
`a51ac7`	FV	`=FV(0.06, 10, -1000)`	value	4
`6ed53c`	FV	`=FV(0.05, 20, 0, -10000)`	value	5
`0ab4dd`	FV	`=FV(0, 10, -100)`	value	1
`1742ab`	FVSCHEDULE	`=FVSCHEDULE(1000, {0.05, 0.06, 0.07})`	value	3
`b9bff1`	FVSCHEDULE	`=FVSCHEDULE(1000, {0.1, 0, 0.1})`	value	2
`61c9f9`	FVSCHEDULE	`=FVSCHEDULE(500, {0.1})`	value	1
`cacd3d`	IPMT	`=IPMT(0.05/12, 1, 360, -200000)`	value	6
`1d121d`	IPMT	`=IPMT(0.05/12, 360, 360, -200000)`	value
`982b40`	IPMT	`=IPMT(0.05/12, 0, 360, -200000)`	value	3
`18f67f`	IRR	`=IRR(A1:A6)`	value
`a62960`	IRR	`=IRR(A1:A4)`	value
`7f4f55`	IRR	`=IRR(A1:A3)`	value	2
`94acd6`	ISPMT	`=ISPMT(0.1/12, 1, 36, 8000000)`	value
`99ed2c`	ISPMT	`=ISPMT(0.05, 0, 5, -1000)`	value	1
`6467bf`	ISPMT	`=ISPMT(0.05, 5, 5, -1000)`	value	1
`5863cb`	MIRR	`=MIRR(A1:A6, 0.1, 0.12)`	value
`c555e8`	MIRR	`=MIRR(A1:A4, 0.1, 0.1)`	value
`312e2b`	MIRR	`=MIRR(A1:A3, 0.1, 0.12)`	value	2
`85b26a`	NOMINAL	`=NOMINAL(0.126825030131969, 12)`	value	2
`880ccd`	NOMINAL	`=NOMINAL(0.05, 1)`	value	2
`a62e7e`	NOMINAL	`=NOMINAL(-0.05, 4)`	value	2
`824009`	NPER	`=NPER(0.05/12, -1073.64, 200000)`	value
`9bf6a5`	NPER	`=NPER(0, -100, 1000)`	value	1
`0f3284`	NPER	`=NPER(0.1, -1, 10000)`	value	1
`9e7133`	NPV	`=NPV(0.1, -1000, 300, 300, 300, 300, 300)`	value
`d8f61d`	NPV	`=NPV(0.1, 100)`	value	3
`007ef7`	NPV	`=NPV(0, 100, 200, 300)`	value
`983081`	PDURATION	`=PDURATION(0.1, 1000, 2000)`	value	5
`c9beca`	PDURATION	`=PDURATION(0.05, 1000, 1000)`	value	1
`696cf4`	PDURATION	`=PDURATION(0, 1000, 2000)`	value	1
`136a75`	PMT	`=PMT(0.05/12, 360, -200000)`	value	5
`2cfde2`	PMT	`=PMT(0, 12, 12000)`	value	1
`0167d4`	PMT	`=PMT(0.06/12, 360, 0, 1000000)`	value
`573c61`	PPMT	`=PPMT(0.05/12, 1, 360, -200000)`	value
`2fe8d6`	PPMT	`=PPMT(0.05/12, 5, 360, -200000) + IPMT(0.05/12, 5, 360, -200000)`	value	8
`6f263c`	PPMT	`=PPMT(0.05/12, 361, 360, -200000)`	value	3
`0cd8e0`	PV	`=PV(0.06, 10, -1000)`	value	4
`464aee`	PV	`=PV(0.1, 5, 0, -1000)`	value	4
`d9f62d`	PV	`=PV(0, 10, -100)`	value
`cb69bc`	RATE	`=RATE(360, -1073.64, 200000)`	value
`b081e4`	RATE	`=RATE(10, 0, -500, 1000)`	value
`6b3948`	RATE	`=RATE(10, 100, 100)`	value
`f1c545`	RRI	`=RRI(8, 1, 2)`	value	4
`9d7de9`	RRI	`=RRI(5, 1000, 1000)`	value	1
`7f7154`	RRI	`=RRI(0, 1000, 2000)`	value
`c8649b`	SLN	`=SLN(1000, 100, 10)`	value	1
`c2acdf`	SLN	`=SLN(5000, 0, 5)`	value	1
`c946ad`	SLN	`=SLN(1000, 100, 0)`	value	1
`ebe9fb`	SYD	`=SYD(1000, 100, 10, 1)`	value	5
`e95202`	SYD	`=SYD(1000, 100, 10, 10)`	value	5
`9b2a4c`	SYD	`=SYD(1000, 100, 10, 11)`	value	2
`e12a5d`	VDB	`=VDB(2400, 300, 10*365, 0, 1)`	value
`851e1c`	VDB	`=VDB(2400, 300, 10, 0, 1)`	value	1
`42b58d`	VDB	`=VDB(2400, 300, 10, 0, 10, 2, TRUE)`	value
`0aba83`	XIRR	`=XIRR(A1:A5, B1:B5)`	value
`2bf9f0`	XIRR	`=XIRR(A1:A3, B1:B3, 0.1)`	value
`9862ea`	XIRR	`=XIRR(A1:A2, B1:B2)`	value	2
`055a38`	XNPV	`=XNPV(0.09, A1:A5, B1:B5)`	value
`9cb04b`	XNPV	`=XNPV(0.1, A1:A2, B1:B2)`	value
`ab2df7`	XNPV	`=XNPV(0.1, A1:A3, B1:B2)`	value	3