jamesbeau
03-27-2016, 04:36 PM
Hi guys,
I am trying to create a function which generates the required return on a savings account given its, current_value, annual_savings, target_value and n_years.
I have attempted to create a dynamic array cf() with current_value as cf(0), target as cf(n_year+1) and the value for annual_savings as all the other cashflows in the middle.
I haven't had much success and was wondering if someone could help me creating a structure like this.
The idea being once I have created the array I can just take the WorksheetFunction.IRR(cf()).
Any help would be greatly appreciated!
I am trying to create a function which generates the required return on a savings account given its, current_value, annual_savings, target_value and n_years.
I have attempted to create a dynamic array cf() with current_value as cf(0), target as cf(n_year+1) and the value for annual_savings as all the other cashflows in the middle.
I haven't had much success and was wondering if someone could help me creating a structure like this.
The idea being once I have created the array I can just take the WorksheetFunction.IRR(cf()).
Any help would be greatly appreciated!