ItemPriceFree Download
 
Please feel at home to download tadXL for FREE, currently valued at US$119
 
Whether you require analyzing a single investment to find investor's ROI or are eager to evaluate a whole portfolio of investments, tadXL will deliver the results. And how about analyzing a "portfolio of portfolios" or even a portfolio of "portfolios of portfolios"
 
tadXL v2.5 allows one dimensional financial analysis, the next many iterations of tadXL will allow for N-dimensional financial analysis starting with 2 dimensional TVM equation in v3.0 followed by 3 dimensional time value of money equation in v4.0 and moving upwards
 
Free 32-bit tadXL v2.5 full versionFREEDownload Now
Free 64-bit tadXL v2.5 full versionFREEDownload Now
 
In near future you will be get to download newer versions of tadXL v3.0, v4.0, v5.0, v6.0, v7.0, v8.0, v9.0 and v10.0
 
Don't be surprised if you find out that Microsoft has copied ideas from tadXL to offer similar financial functions in its upcoming Excel 2015. And you thought Microsoft would respect others copy protected work, yet that is not the case this time with that software Giant pirate
 
Find PVIFA in Excel 2007|2010|2013

PVIFA - is an acronym for present value interest factor of an ordinary annuity in amount of $1 that makes n payments and pays i% interest. The PVIFA calculation using paper and pencil are time consuming and error prone thus one would desire to find this amount using Excel. But Excel has no PVIFA function not unless we make use of 3rd party tadXL add-in for Excel 2007, 2010, and 2013. There are a large number of financial functions in tadXL including tadPVIFA that find this interest amount. It has some additional features such as use of different compounding frequencies of interest and the use of periods with varying lengths. Additionally you can specify the discounting convention of your choice such as mid-year discounting.

Finding PVIFA in Excel

Up until Excel 2013, there weren't any financial functions in Excel to find the PVIFA - present value annuity factor or any other interest rate factor functions. In spring of 2012, tadXL was released to the software market that offered a large collection of financial functions for Excel 2007, 2010 and 2013. Amongst these financial functions, there was tadPVIFA function to find the present value annuity factor of $1 periodic payments that earn i% interest rate for n number of periods. tadPVIFA function offered features for additional options to include compounding frequencies of interest, to define the length of the payment periods and to use various discounting conventions such as mid-year discounting. As stated earlier Excel had no such financial function up till Excel 2013 so it be surprising the least if Microsoft were to introduce new set of financial functions in the upcoming Excel 2015 or 2016. If they were to do so then more than likely such new financial functions in upcoming Excel would be copies of the financial functions that are found in tadXL add-in and have been available since 2012. But the buck stops here and the author reserves the right to challenge any derivative work based on tadXL financial functions.

Excel PVIFA function in tadXL v2.5

Using tadXL functions such as tadPVIFA finding present value annuity factor in Excel 2007, 2010 and 2013 becomes really easy. Let us now briefly look at this financial functions in tadXL to find PVIFA using Excel:

Using tadXL functions such as tadPVIFA finding present value annuity factor in Excel 2007, 2010 and 2013 becomes really easy. Let us now briefly look at this financial functions in tadXL to find PVIFA using Excel:

  1. tadPVIFA ( rate, nper, type, compounding, period, concentration )
nper1010101010
rate5%5%5%5%5%
compounding110.08330.08330
period110.08330.08331
distribution10.510.51
PVIFA7.72177.91249.77469.79497.6743
tadPVIFA ( rate, nper, type, compounding, period, concentration )

%
% or $





Data output

PVIFA =