Financial		Logical		Informational		Text
Mathematical		Statistical		Lookup		Reference		Formula Errors

FV is used to calculate the future value (FV) of an investment with periodic constant payments (pmt) and
a constant interest rate formula (rate) mentioning present value (pv) and the type

Syntax
FV( Rate, nper, [pmt], [pv], [type] )

Rate - Rate of interest - Expressed as Monthly Interest. If RoI is 12% p.a, we input Rate as 12%/12 or as 1%
nper - No.of.Period - Expressed in No.of.Months. If Nper is 2 years, input 24 (2 years x 12 Months)
pmt - Expressed as a negative value. Monthly Payment. For eg, -1000
[pv] - present value. Assume a deposit of 5000 initially .. Input as -5000
[type] - If start of the Month ,input as 1 ,If the payment is End of the Month - 0

Click Here to Download a copy of ExcelTechie Financial Formulas Workbook