Rate of return with taxes take out each yr.

[mspincus]

PLease help. Formula and graph and then powerpoint. I want to have a some dollars invested over a 10-15-20 ?? period, what would be the future value. mine is coming uo negative. I am trying to compare what 1 dollar invested over a certain period in which that period can change get the future value and then take a taxes out. exp 1 dollar earning 10% then take out 25% taxes and then the next year earn 10% on that money and so on. then i would like to bar graph info into a powerpoint and have it a working powerpoint.

 

[JackDanIce]

I'm assuming you mean 25% tax applied to the interest earned on the invested amount.

If
A1 contains your initial investment ($1)
A2 contains your interest earned (10%)
A3 contains the tax applied to the interest (25%)
A4 your investment time frame (for sake of example 10 years)

Then formula would be:

=A1*(1+A2*(1-A3))^A4

So with above values, answer is $2.06

I don't have time to provide solution for rest of your requirement