FVIF Excel Function
Written by:Abraham A.What is FVIF
Assume you have made a deposit of $1 into a savings account that pays an interest of 10% per annum. Let us say that you kept the money in your savings account for 10 years. Your account will earn interest not only on the $1 you invested but also on the interest earned in prior years. FVIF will be the amount of money shown as the closing balance of your account at the end of 10 years.
Compound Interest
As stated earlier compound interest is the interest earned on deposit plus interest on interest. Compounding of interest may be either discrete or it may be continuous compouding. When interest is calculated per period such as per year, per quarter, per month or per day then it is referred to as periodic or discrete compounding of interest. Yet modern banking permits calculation of interest on continuous scale, this is referred to as continuous compounding of interest. Excel functions only provide results when interest is compounded discretely.
FVIF MS Excel Example
This article http://support.microsoft.com/kb/141695 from Official Microsoft Excel Support states that "Microsoft Excel does not include a function for determining compound interest".
The Solution
tadFVIF Excel function calculates compound amount earned on a $1 using either discrete or continuous compounding of interest. No VBA programming required. tadFVIF Excel function is part of the TADXL Excel add-in for finance, that provides numerous financial functions that are not currently available in Excel. tadFVIF accepts the following three values
- RATE
refers to the periodic interest rate - NPER
refers to the number of periods - Compounding
refers to either 0 for discrete compounding of interest or to 1 for continuous compounding of interest
| A | B | C | |
| 1 | RATE | 10% | 10% |
| 2 | NPER | 10 | 10 |
| 3 | Compounding | 0 | 1 |
| 4 | TADXL | =tadFVIF(B1, B2, B3) | =tadFVIF(C1, C2, C3) |
| 1 | FVIF | 2.59374 | 2.71828 |
You can try out the sample FVIF calculation in Excel as shown in the previous example. If Excel reports the #NAME error when you enter the =tadFVIF(B1, B2, B3) function in cell B4, then you must install TADXL Add-in for finance to see the results of compound interest calculation using tadFVIF function. TADXL is an Excel Add-in for finance, that contains many financial functions which are not provided by Excel. Go ahead and download TADXL now.
Related Interest factors Excel functions
Following is a list of related Excel functions that cover other interest factors used in financial management:FVIF Calculator
You can opt to use this FVIF Calculator that calculates not only FVIF but also the interest rate and number of periods from future value interest factor. The FVIF calculator permits you to select from discrete and continuous compounding of interest.
FVIF Table
Get yourself a FVIF PDF download file that tabulates future value interest factor of a $1 at interest rates ranging from 1% to 50% for number of periods ranging from 1 to 50. The FVIF table comes in an easy to read format where alternating rows are highlighted in contrasting colors. A must have for any financial analyst, business student, and other accounting professionals.
FVIF on ba ii plus
TI BA II plus is a popular financial calculator manufactured by Texas Instruments. FVIF on BA II plus may be found using the time value of money function keys. This tutorial guides you on how to find FVIF on BA II plus.