Study guides for the MBA student

MBA study guide

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.

FVIF in Excel

Download FREE FVIF calculator

Please go ahead and download IntRates calculator that offers 10 financial functions to analyze investments including one to find future value of $1. To find the future value interest factor of $1 you would have to enter the interest rate and the number of periods. This calculator allows you to define the length of the period and to make use of various compounding frequencies of interest. It also allows you to apply almost any type of discounting convention such as mid-year discounting or full-year discounting. Have a look at the screen shot of this robust, feature rich and easy to use calculator that is shown below. You may click on the FVIF calculator screenshot to download and use this calculator on Windows 7 and 8 operating systems. No installation is required, just copy the file on your Windows desktop and run the program file by double clicking the program icon.

FVIF calculator
Qty.DescriptionPriceDownloadAction
1IntRates Calculator$39Download Buy Now

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.

tadXL download free

There are 14 financial functions in tadXL v0.8 including a number of functions to find future value interest factor of a $1. A list of these functions may be found here

Qty.DescriptionPriceFunctionsDownloadAction
132-bit tadXL v0.8$1914 functionsDownload tadXL
164-bit tadXL v0.8$1914 functionsDownload tadXL

Excel FVIF function

The future value interest factor Excel function requires the following values as input:
=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

Finance tutorials

Finance tutorials on a variety of topics ranging from finding ROI using IRR, NPV, Payback period, etc. TVM calculations i.e. present value & future value of loans and bank deposits. Valuation & yield on stocks and bonds i.e. cost of equity, & debt. Rates of return on investments i.e. ARR, GRR, holding period return & yield.

Excel 4 finance

Excel 4 finance to perform DCF analysis NPV, xNPV, IRR, xIRR, MIRR, xMIRR etc. Time value of money calculations i.e GRADIENT, INTEREST RATE, NPER, PMT, etc, yields and prices of bonds and stocks. Rates of return i.e. HPR, HPY, AHPR, and AHPY, etc.

TI BA II plus guide

TI BA II plus guide to analyze investments using capital budgeting methods i.e IRR, NPV, MIRR etc. TVM calculations i.e. RATE, NPER, PMT, PV, FV. Interest rate factors i.e. PVIFA, PVIF, FVIFA, FVIF, etc .

Finance tables

Finance tables to find interest factors for present value and future value of $1 and of annuities with start of period and end of period payments in amount of $1. Interest rates for growing and shrinking annuities are available as well.