Formula's to calculate Future Value, Lumpsum Required & SIP Amt

[dvm49]

Hello Team,

I would like to know how the value is calculated in the Column G, H & I. Can someone help me with the formula pls?

Attached the Excel File, where I would like to calculate the value in G, H & I.

 

[AlanSidman]

Future Value in G2 is =FV(D2,2*1,0,-E2,1). Not sure what you are looking for in H and I

Look here---->https://www.techonthenet.com/excel/formulas/fv.php