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:
- tadFVIF ( rate, nper, compounding, period, distribution )