Hi, (first time posting), I could not find any related post to this problem.
Basically, I am looking for something like the "Rate" function but considering that a fraction of each period's return would be taken out and not reinvested for the the next period (also known as Tax). The only unknown here is the interest rate,
I know the present value, future value, number of period, tax rate, and payments per period.
At this point I know how to do it, but it is very inefficient as I have to guess the interest rate until I get the correct future value.
I have a feeling VBA will be needed to complete this task. Any help will be greatly appreciated!!!
Basically, I am looking for something like the "Rate" function but considering that a fraction of each period's return would be taken out and not reinvested for the the next period (also known as Tax). The only unknown here is the interest rate,
I know the present value, future value, number of period, tax rate, and payments per period.
At this point I know how to do it, but it is very inefficient as I have to guess the interest rate until I get the correct future value.
I have a feeling VBA will be needed to complete this task. Any help will be greatly appreciated!!!
