Home | Quick Start | Documentation | Download | Support | Contribute

# Financial Functions In AFC

### Financial Functions

The supported numeric functions are shown by example below:

##### NPV
 A B C D E F G H I 2 1.1884434123352206 =NPV( C2, D2:G2 ) 0.1 -10.0 3.0 4.2 6.8 3 1.9220615549323696 =(NPV( C3, E3:I3 ) + D3) 0.08 -40.0 8.0 9.2 10.0 12.0 14.5 7.0

##### MIRR
 A B C D E F G H I 5 0.0625220116777323 =MIRR( C5:G5, H5, I5 ) -120.0 39.0 30.0 21.0 37.0 0.1 0.12 7.0

##### IRR
 A B C D E F G H 7 0.08663094803634251 =IRR( C7:H7, 0.1 ) -70.0 12.0 15.0 18.0 21.0 26.0 8 -0.44350694133465396 =IRR( C8:E8, F8 ) -70.0 12.0 15.0 -0.1 9 0.05188165495421505 =IRR( C9:G9, 0.1 ) 100.0 -50.0 -30.0 -20.0 -10.0 10 !FE ... 34.0 12.0 15.0 18.0 21.0 Excel says: #NUM!

##### DB
 A B C D E F G 12 2752.96176 =DB( C12, D12, E12, F12 ) 12345.12 987.65 10.0 1.0 13 1003.4234680309769 ... 12345.12 987.65 10.0 5.0 14 284.17727671733377 ... 12345.12 987.65 10.0 10.0 15 1605.8943600000002 =DB( C15, D15, E15, F15, G15 ) 12345.12 987.65 10.0 1.0 7.0 16 1123.4167291693875 ... 12345.12 987.65 10.0 5.0 7.0 17 103.0043955434808 ... 12345.12 987.65 10.0 11.0 7.0

##### DDB
 A B C D E F G 19 2469.0240000000003 =DDB( C19, D19, E19, F19 ) 12345.12 987.65 10.0 1.0 20 904.5451574605321 ... 12345.12 987.65 10.0 5.5 21 331.3867916574723 ... 12345.12 987.65 10.0 10.0 22 1851.768 =DDB( C22, D22, E22, F22, G22 ) 12345.12 987.65 10.0 1.0 1.5 23 891.1929465967952 ... 12345.12 987.65 10.0 5.5 1.5 24 428.9008493849543 ... 12345.12 987.65 10.0 10.0 1.5 25 11357.47 ... 12345.12 987.65 10.0 1.0 10.1 26 0.0 ... 12345.12 987.65 10.0 1.001 10.1

##### SLN
 A B C D E 28 2250.0 =SLN( C28, D28, E28 ) 30000.0 7500.0 10.0 29 2247.772227772228 ... 29999.95 7499.75 10.01

##### SYD
 A B C D E F 31 4090.909090909091 =SYD( C31, D31, E31, F31 ) 30000.0 7500.0 10.0 1.0 32 409.09090909090907 ... 30000.0 7500.0 10.0 10.0 33 3270.600462208092 ... 29999.95 7499.75 10.01 3.0

##### FV
 A B C D E F G 35 2581.4033740601185 =FV( C35, D35, E35, F35, G35 ) 0.0050 10.0 -200.0 -500.0 1.0 36 12682.503013196976 =FV( C36, D36, E36 ) 0.01 12.0 -1000.0 37 82898.06514315684 =FV( C37, D37, E37, , F37 ) 0.0092 35.0 -2000.0 1.0 38 2301.4018303408993 =FV( C38, D38, E38, F38, G38 ) 0.0050 12.0 -100.0 -1000.0 1.0 39 2295.23404915445 =FV( C39, D39, E39, F39 ) 0.0050 12.0 -100.0 -1000.0 40 2200.0 ... 0.0 12.0 -100.0 -1000.0

##### NPER
 A B C D E F G 42 59.67386567429457 =NPER( C42, D42, E42, F42, G42 ) 0.01 -100.0 -1000.0 10000.0 1.0 43 60.08212285376166 =NPER( C43, D43, E43, F43 ) 0.01 -100.0 -1000.0 10000.0 44 90.0 ... 0.0 -100.0 -1000.0 10000.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.0 1.0

##### PMT
 A B C D E F G 48 -1512.0079920253022 =PMT( C48, D48, E48, F48, G48 ) 0.0066 10.0 10000.0 5000.0 1.0 49 -1500.0 =PMT( C49, D49, E49, F49 ) 0.0 10.0 10000.0 5000.0 50 -1029.8610800534268 =PMT( C50, D50, E50, , F50 ) 0.0066 10.0 10000.0 1.0 51 -1036.6581631817796 =PMT( C51, D51, E51 ) 0.0066 10.0 10000.0 52 -129.08116086799728 =PMT( C52, D52, E52, F52 ) 0.0050 216.0 0.0 50000.0 53 -231.4814814814815 ... 0.0 216.0 0.0 50000.0

##### PV
 A B C D E F G 55 -70842.65167097464 =PV( C55, D55, E55, F55, G55 ) 0.0066 240.0 500.0 50000.0 1.0 56 -70445.76332409514 =PV( C56, D56, E56, F56 ) 0.0066 240.0 500.0 50000.0 57 -170000.0 ... 0.0 240.0 500.0 50000.0 58 -60134.59801204454 =PV( C58, D58, E58 ) 0.0066 240.0 500.0 59 -60531.486358924034 =PV( C59, D59, E59, , F59 ) 0.0066 240.0 500.0 1.0 60 -120000.0 =PV( C60, D60, E60 ) 0.0 240.0 500.0

##### RATE
 A B C D E F G H 62 0.007252054197075087 =RATE( C62, D62, E62, F62, G62, H62 ) 48.0 -200.0 8000.0 200.0 1.0 0.0 63 0.007252054197077615 =RATE( C63, D63, E63, F63, G63 ) 48.0 -200.0 8000.0 200.0 1.0 64 0.0069258280078605215 =RATE( C64, D64, E64, F64 ) 48.0 -200.0 8000.0 200.0 65 0.007701472488201368 =RATE( C65, D65, E65 ) 48.0 -200.0 8000.0 66 0.007701472488195906 =RATE( C66, D66, E66, , , F66 ) 48.0 -200.0 8000.0 0.0 67 0.0 ... 240.0 500.0 -120000.0 0.0 68 !FE ... 240.0 500.0 3.0 0.0 Excel says: #NUM!

##### VDB
 A B C D E F G H I 70 384.0 =VDB( C70, D70, E70, F70, G70 ) 2400.0 300.0 10.0 1.0 2.0 71 307.2 ... 2400.0 300.0 10.0 2.0 3.0 72 329.1456000000001 ... 2400.0 300.0 10.0 6.0 10.0 73 313.34400000000005 =VDB( C73, D73, E73, F73, G73, H73, I73 ) 2400.0 300.0 10.0 2.3 3.4 2.0 true 7.0 74 3890.7484052950003 =VDB( C74, D74, E74, F74, G74, H74 ) 12345.12 987.65 10.0 2.0 5.5 1.5 75 428.9008493849543 =VDB( C75, D75, E75, F75, G75, H75, I75 ) 12345.12 987.65 10.0 9.0 10.0 1.5 true 7.0 76 11357.47 =VDB( C76, D76, E76, F76, G76, H76 ) 12345.12 987.65 10.0 0.0 1.0 10.1 77 2488.7761920000003 ... 12345.12 987.65 10.0 0.0 1.01 2.0 78 !FE =VDB( C78, D78, E78, F78, G78 ) 2400.0 300.0 10.0 -1.0 2.0 Excel says: #NUM! 79 !FE ... 2400.0 300.0 10.0 2.0 1.0 Excel says: #NUM! 80 !FE ... -1.0 2401.0 10.0 1.0 2.0 Excel says: #NUM! 81 0.0 ... 2400.0 2410.0 10.0 1.0 2.0 82 1147.10447 =VDB( C82, D82, E82, F82, G82, H82 ) 12345.12 987.65 10.0 0.0 1.01 0.0 83 !FE ... 12345.12 987.65 10.0 0.0 1.01 -0.0010 Excel says: #NUM!