On Monday, December 23, 2013 5:48:55 PM UTC+5, Robert Miller wrote:
On Thursday, December 19, 2013 8:53:21 AM UTC+5, Abraham A wrote:


Abe, I noticed that in the last few days you have extended the functionality of your Excel NPV function http://tadxl.com/excel_npv_function.html and Excel IRR function http://tadxl.com/excel_irr_function.html to include the effect of inflation on forward looking cash flow amounts. Not only your tadNPV function allows for a growth rate but it also permits you to use annuity payments that are worth their face value or those that are adjusted for inflation.



There are a lot more variables in your tadNPV function now as compared to what you had just a week ago. The following shows the syntax for this Excel NPV function that now accepts up to 12 different set of values. These values may be entered as single numbers or an array of numbers thus making the input array a 12 x N matrix (recall that Matrix is the code name for tadXL v3.0)



=tadNPV( rate, growth, tax_rate, cash flows, adjust_for_inflation, frequency, type, compounding, period, concentration, hair_cut, rate_rigged_by )

The tadNPV function in it's current form will become part of tadXL add-in v3.0 that will be released in January 2014

I have uploaded a video demonstration of this Excel NPV function here at https://plus.google.com/109666872827...ts/ES5HMAGNnf6

Let me know if you have any comments on the way it is being demonstrated in this video