Financial Functions In AFC
The supported numeric functions are shown by example below:
| 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.00) | 0.12 (#0.00) | 7.0 |
| A | B | C | D | E | F | G | H |
7 | 0.08663094803634251 | =IRR(C7:H7) | -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 (#0.00) | |
9 | 0.05188165495421505 | =IRR(C9:G9) | 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! |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| A | B | C | D | E | F | G |
35 | 2581.4033740601185 | =FV(C35,D35,E35,F35,G35) | 0.0050 (#0.0000) | 10.0 | -200.0 | -500.0 | 1.0 | |
36 | 12682.503013196976 | =FV(C36,D36,E36) | 0.01 (#0.0000) | 12.0 | -1000.0 | |
37 | 82898.06514315684 | =FV(C37,D37,E37,,F37) | 0.0092 (#0.0000) | 35.0 | -2000.0 | 1.0 | |
38 | 2301.4018303408993 | =FV(C38,D38,E38,F38,G38) | 0.0050 (#0.0000) | 12.0 | -100.0 | -1000.0 | 1.0 | |
39 | 2295.23404915445 | =FV(C39,D39,E39,F39) | 0.0050 (#0.0000) | 12.0 | -100.0 | -1000.0 | |
40 | 2200.0 | ... | 0.0 (#0.0000) | 12.0 | -100.0 | -1000.0 | |
| A | B | C | D | E | F | G |
42 | 59.67386567429457 | =NPER(C42,D42,E42,F42,G42) | 0.01 (#0.00) | -100.0 | -1000.0 | 10000.0 | 1.0 | |
43 | 60.08212285376166 | =NPER(C43,D43,E43,F43) | 0.01 (#0.00) | -100.0 | -1000.0 | 10000.0 | |
44 | 90.0 | ... | 0.0 (#0.00) | -100.0 | -1000.0 | 10000.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.0 | 1.0 | |
| A | B | C | D | E | F | G |
48 | -1512.0079920253022 | =PMT(C48,D48,E48,F48,G48) | 0.0066 (#0.0000) | 10.0 | 10000.0 | 5000.0 | 1.0 | |
49 | -1500.0 | =PMT(C49,D49,E49,F49) | 0.0 (#0.0000) | 10.0 | 10000.0 | 5000.0 | |
50 | -1029.8610800534268 | =PMT(C50,D50,E50,,F50) | 0.0066 (#0.0000) | 10.0 | 10000.0 | 1.0 | |
51 | -1036.6581631817796 | =PMT(C51,D51,E51) | 0.0066 (#0.0000) | 10.0 | 10000.0 | |
52 | -129.08116086799728 | =PMT(C52,D52,E52,F52) | 0.0050 (#0.0000) | 216.0 | 0.0 | 50000.0 | |
53 | -231.4814814814815 | ... | 0.0 (#0.0000) | 216.0 | 0.0 | 50000.0 | |
| A | B | C | D | E | F | G |
55 | -70842.65167097464 | =PV(C55,D55,E55,F55,G55) | 0.0066 (#0.0000) | 240.0 | 500.0 | 50000.0 | 1.0 | |
56 | -70445.76332409514 | =PV(C56,D56,E56,F56) | 0.0066 (#0.0000) | 240.0 | 500.0 | 50000.0 | |
57 | -170000.0 | ... | 0.0 (#0.0000) | 240.0 | 500.0 | 50000.0 | |
58 | -60134.59801204454 | =PV(C58,D58,E58) | 0.0066 (#0.0000) | 240.0 | 500.0 | |
59 | -60531.486358924034 | =PV(C59,D59,E59,,F59) | 0.0066 (#0.0000) | 240.0 | 500.0 | 1.0 | |
60 | -120000.0 | =PV(C60,D60,E60) | 0.0 (#0.0000) | 240.0 | 500.0 | |
| 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! |
| 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! |