Find FVIF in Excel 2007|2010|2013

There are no financial functions in Excel to find FVIF - future value interest factor of $1 for n number of periods earning i% interest rate. But 3rd party functions such as tadFVIF help you easily find the future value factor with relative ease in Excel 2007, 2010, and 2013. tadFVIF is amongst a large number of financial functions that are found in tadXL add-in. Here me, Abraham A. will guide you through steps required for finding FVIF in Excel.

A FVIF is an acronym that stands for future value interest factor of $1 that earns i% interest for n number of periods. Finding it manually requires discounted cash flow calculations and without a calculator it gets time consuming to find it. Finding FVIF in Excel is possible when you use 3rd party financial functions such as tadFVIF that are part of tadXL add-in for Excel 2007, 2010 and 2013. This package contains a very large number of financial functions that are not found in Excel itself but are routinely used by financial analysts.

Excel FVIF function

The future value interest factor Excel function requires the following values as input:

  1. tadFVIF ( rate, nper, compounding, period, distribution )
nper1010101010
rate5%5%5%5%5%
compounding110.08330.08330
period110.08330.08331
distribution10.510.51
FVIF1.62891.58961.04251.04031.6487
tadFVIF ( rate, nper, compounding, period, distribution )

%

$



Data output

FV =