I am trying to set up a future value formula where I deposit $10,000 at
the beginning of each year for 10 years, and then want to know what
the future value is at the end of the 29th year using gross rate of 11..5%
annually (and a tax rate of 40%)?
Does the tax rate apply to the first 10 years as well as to the last
19 years?
If yes:
=FV(11.5%*(1-40%),19,0,-FV(11.5%*(1-40%),10,-10000,0,1))
If no:
=FV(11.5%*(1-40%),19,0,-FV(11.5%,10,-10000,0,1))
PS: Not good practice to post a substantially different question as a
response to another discussion, especially a discussion that is 2
years old.