lior03
03-03-2007, 08:21 AM
hello
i want tire you with financial analysis.the aim of the following function is to let the user know at a given interest rate ,and intial investment how much will he make per dollar invested.how can i use indifinate number of years.my limited vba knowhow enabled me to use only eight years.
Function investec(rate, inflow1, inflow2, inflow3, inflow4, inflow5, inflow6, inflow7, intialcost)
investec = Abs(1 + Abs(Application.WorksheetFunction.NPV(rate, inflow1, inflow2, inflow3, inflow4, inflow5, inflow6, inflow7) - intialcost) / intialcost)
End Function
thanks
i want tire you with financial analysis.the aim of the following function is to let the user know at a given interest rate ,and intial investment how much will he make per dollar invested.how can i use indifinate number of years.my limited vba knowhow enabled me to use only eight years.
Function investec(rate, inflow1, inflow2, inflow3, inflow4, inflow5, inflow6, inflow7, intialcost)
investec = Abs(1 + Abs(Application.WorksheetFunction.NPV(rate, inflow1, inflow2, inflow3, inflow4, inflow5, inflow6, inflow7) - intialcost) / intialcost)
End Function
thanks