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-10.03.04.26.8
31.9220615549323696=(NPV( C3, E3:I3 ) + D3)0.08-40.08.09.210.012.014.57.0

MIRR
ABCDEFGHI
50.0625220116777323=MIRR( C5:G5, H5, I5 )-120.039.030.021.037.00.10.127.0

IRR
ABCDEFGH
70.08663094803634251=IRR( C7:H7, 0.1 )-70.012.015.018.021.026.0
8-0.44350694133465396=IRR( C8:E8, F8 )-70.012.015.0-0.1
90.05188165495421505=IRR( C9:G9, 0.1 )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.005010.0-200.0-500.01.0
3612682.503013196976=FV( C36, D36, E36 )0.0112.0-1000.0
3782898.06514315684=FV( C37, D37, E37, , F37 )0.009235.0-2000.01.0
382301.4018303408993=FV( C38, D38, E38, F38, G38 )0.005012.0-100.0-1000.01.0
392295.23404915445=FV( C39, D39, E39, F39 )0.005012.0-100.0-1000.0
402200.0...0.012.0-100.0-1000.0

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

PMT
ABCDEFG
48-1512.0079920253022=PMT( C48, D48, E48, F48, G48 )0.006610.010000.05000.01.0
49-1500.0=PMT( C49, D49, E49, F49 )0.010.010000.05000.0
50-1029.8610800534268=PMT( C50, D50, E50, , F50 )0.006610.010000.01.0
51-1036.6581631817796=PMT( C51, D51, E51 )0.006610.010000.0
52-129.08116086799728=PMT( C52, D52, E52, F52 )0.0050216.00.050000.0
53-231.4814814814815...0.0216.00.050000.0

PV
ABCDEFG
55-70842.65167097464=PV( C55, D55, E55, F55, G55 )0.0066240.0500.050000.01.0
56-70445.76332409514=PV( C56, D56, E56, F56 )0.0066240.0500.050000.0
57-170000.0...0.0240.0500.050000.0
58-60134.59801204454=PV( C58, D58, E58 )0.0066240.0500.0
59-60531.486358924034=PV( C59, D59, E59, , F59 )0.0066240.0500.01.0
60-120000.0=PV( C60, D60, E60 )0.0240.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!