Select from the list of online financial calculators:   Benefit to cost ratio calculator Capital budgeting calculator Discounted payback period calculator Equivalent annual annuity calculator Equivalent annual cost calculator Incremental IRR calculator IRR calculator Kapitalwert calculator Modified IRR calculator Net future value calculator Net intermediate value calculator Net present value calculator Payback period calculator
 Select from the list of Windows 7 financial calculators:   Benefit to cost ratio calculator for Win 7 Discounted payback period calculator for Win 7 Equivalent annual annuity calculator for Win 7 Equivalent annual cost calculator for Win 7 IRR calculator for Win 7 Modified IRR calculator for Win 7 Net future value calculator for Win 7 Net present value calculator for Win 7 Payback period calculator for Win 7 True discounted payback period calculator for Win 7 True payback period calculator for Win 7
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 )
 nper 10 10 10 10 10 rate 5% 5% 5% 5% 5% compounding 1 1 0.0833 0.0833 0 period 1 1 0.0833 0.0833 1 distribution 1 0.5 1 0.5 1 FVIF 1.6289 1.5896 1.0425 1.0403 1.6487
tadFVIF ( rate, nper, compounding, period, distribution )

%

\$

FV =