AFC - Abacus Formula Compiler for Java

Financial Functions In AFC

Financial Functions

The supported numeric functions are shown by example below:

NPV
ABCDEFGHI
21.1884434123352206=NPV(C2,D2:G2)0.1 (#0.00)-10.03.04.26.8
31.9220615549323696=NPV(C3,E3:I3)+D30.08 (#0.00)-40.08.09.210.012.014.57.0

MIRR
ABCDEFGHI
50.0625220116777323=MIRR(C5:G5,H5,I5)-120.039.030.021.037.00.1 (#0.00)0.12 (#0.00)7.0

IRR
ABCDEFGH
70.08663094803634251=IRR(C7:H7)-70.012.015.018.021.026.0
8-0.44350694133465396=IRR(C8:E8,F8)-70.012.015.0-0.1 (#0.00)
90.05188165495421505=IRR(C9:G9)100.0-50.0-30.0-20.0-10.0
10!FE...34.012.015.018.021.0Excel says: #NUM!

DB
ABCDEFG
122752.96176=DB(C12,D12,E12,F12)12345.12987.6510.01.0
131003.4234680309769...12345.12987.6510.05.0
14284.17727671733377...12345.12987.6510.010.0
151605.8943600000002=DB(C15,D15,E15,F15,G15)12345.12987.6510.01.07.0
161123.4167291693875...12345.12987.6510.05.07.0
17103.0043955434808...12345.12987.6510.011.07.0

DDB
ABCDEFG
192469.0240000000003=DDB(C19,D19,E19,F19)12345.12987.6510.01.0
20904.5451574605321...12345.12987.6510.05.5
21331.3867916574723...12345.12987.6510.010.0
221851.768=DDB(C22,D22,E22,F22,G22)12345.12987.6510.01.01.5
23891.1929465967952...12345.12987.6510.05.51.5
24428.9008493849543...12345.12987.6510.010.01.5
2511357.47...12345.12987.6510.01.010.1
260.0...12345.12987.6510.01.00110.1

SLN
ABCDE
282250.0=SLN(C28,D28,E28)30000.07500.010.0
292247.772227772228...29999.957499.7510.01

SYD
ABCDEF
314090.909090909091=SYD(C31,D31,E31,F31)30000.07500.010.01.0
32409.09090909090907...30000.07500.010.010.0
333270.600462208092...29999.957499.7510.013.0

FV
ABCDEFG
352581.4033740601185=FV(C35,D35,E35,F35,G35)0.0050 (#0.0000)10.0-200.0-500.01.0
3612682.503013196976=FV(C36,D36,E36)0.01 (#0.0000)12.0-1000.0
3782898.06514315684=FV(C37,D37,E37,,F37)0.0092 (#0.0000)35.0-2000.01.0
382301.4018303408993=FV(C38,D38,E38,F38,G38)0.0050 (#0.0000)12.0-100.0-1000.01.0
392295.23404915445=FV(C39,D39,E39,F39)0.0050 (#0.0000)12.0-100.0-1000.0
402200.0...0.0 (#0.0000)12.0-100.0-1000.0

NPER
ABCDEFG
4259.67386567429457=NPER(C42,D42,E42,F42,G42)0.01 (#0.00)-100.0-1000.010000.01.0
4360.08212285376166=NPER(C43,D43,E43,F43)0.01 (#0.00)-100.0-1000.010000.0
4490.0...0.0 (#0.00)-100.0-1000.010000.0
45-9.578594039813161=NPER(C45,D45,E45)0.01 (#0.00)-100.0-1000.0
46-9.488095005505821=NPER(C46,D46,E46,,F46)0.01 (#0.00)-100.0-1000.01.0

PMT
ABCDEFG
48-1512.0079920253022=PMT(C48,D48,E48,F48,G48)0.0066 (#0.0000)10.010000.05000.01.0
49-1500.0=PMT(C49,D49,E49,F49)0.0 (#0.0000)10.010000.05000.0
50-1029.8610800534268=PMT(C50,D50,E50,,F50)0.0066 (#0.0000)10.010000.01.0
51-1036.6581631817796=PMT(C51,D51,E51)0.0066 (#0.0000)10.010000.0
52-129.08116086799728=PMT(C52,D52,E52,F52)0.0050 (#0.0000)216.00.050000.0
53-231.4814814814815...0.0 (#0.0000)216.00.050000.0

PV
ABCDEFG
55-70842.65167097464=PV(C55,D55,E55,F55,G55)0.0066 (#0.0000)240.0500.050000.01.0
56-70445.76332409514=PV(C56,D56,E56,F56)0.0066 (#0.0000)240.0500.050000.0
57-170000.0...0.0 (#0.0000)240.0500.050000.0
58-60134.59801204454=PV(C58,D58,E58)0.0066 (#0.0000)240.0500.0
59-60531.486358924034=PV(C59,D59,E59,,F59)0.0066 (#0.0000)240.0500.01.0
60-120000.0=PV(C60,D60,E60)0.0 (#0.0000)240.0500.0

RATE
ABCDEFGH
620.007252054197075087=RATE(C62,D62,E62,F62,G62,H62)48.0-200.08000.0200.01.00.0
630.007252054197077615=RATE(C63,D63,E63,F63,G63)48.0-200.08000.0200.01.0
640.0069258280078605215=RATE(C64,D64,E64,F64)48.0-200.08000.0200.0
650.007701472488201368=RATE(C65,D65,E65)48.0-200.08000.0
660.007701472488195906=RATE(C66,D66,E66,,,F66)48.0-200.08000.00.0
670.0...240.0500.0-120000.00.0
68!FE...240.0500.03.00.0Excel says: #NUM!

VDB
ABCDEFGHI
70384.0=VDB(C70,D70,E70,F70,G70)2400.0300.010.01.02.0
71307.2...2400.0300.010.02.03.0
72329.1456000000001...2400.0300.010.06.010.0
73313.34400000000005=VDB(C73,D73,E73,F73,G73,H73,I73)2400.0300.010.02.33.42.0true7.0
743890.7484052950003=VDB(C74,D74,E74,F74,G74,H74)12345.12987.6510.02.05.51.5
75428.9008493849543=VDB(C75,D75,E75,F75,G75,H75,I75)12345.12987.6510.09.010.01.5true7.0
7611357.47=VDB(C76,D76,E76,F76,G76,H76)12345.12987.6510.00.01.010.1
772488.7761920000003...12345.12987.6510.00.01.012.0
78!FE=VDB(C78,D78,E78,F78,G78)2400.0300.010.0-1.02.0Excel says: #NUM!
79!FE...2400.0300.010.02.01.0Excel says: #NUM!
80!FE...-1.02401.010.01.02.0Excel says: #NUM!
810.0...2400.02410.010.01.02.0
821147.10447=VDB(C82,D82,E82,F82,G82,H82)12345.12987.6510.00.01.010.0
83!FE...12345.12987.6510.00.01.01-0.0010Excel says: #NUM!