| A | B | C | D | E | F | G | H | I | J |
1 | Name | Father's Name | Address | Mob NO | Email ID | year | rate | Fix Deposit (Present Value) | PMT | Future Value |
2 | Sandeep |
|
| +91 87265 12118 |
| 3 | 12% | 200000 | Rs 1,000.00 | Rs 329,230.64 |
j2 =FV(G2/12,F2*12,-I2,-H2)
Note-
=FV(rate, nper, -pmt, -pv)
fv = Future value
nper = total instalment
pmt = per instalment value
pv = Fix amount
yaha pe Sandeep nam ka ek vakti kisi Bank me Rs 200000 ka fix deposit karata hai,
aur har Month Rs1000 12% /Yearly rate par jama karta hai
to 3 Year bad use kya future value(fv) milega