1 | interest_rate | 3% | |
---|---|---|---|
2 | number_payments | 5 | |
3 | payment | -500 | |
4 | PV | -7000 | |
5 | type | 0 | |
6 | Result | 10769.48643 | |
7 | Formula | =FV(B1,B2,B3,B4, 0) | |
8 |
1 | interest_rate | 5.25% | |
---|---|---|---|
2 | number_payments | 36 | |
3 | payment | -100 | |
4 | PV | -8000 | |
5 | type | 0 | |
6 | Result | 13251.22839 | |
7 | Formula | =FV(B1/12,B2,B3,B4) | |
8 |
1 | interest_rate | 2.5% | |
---|---|---|---|
2 | number_payments | 104 | |
3 | payment | -50 | |
4 | PV | -2000 | |
5 | type | 1 | |
6 | Result | 7433.397293 | |
7 | Formula | =FV(B1/52,B2,B3,B4) | |
8 |