Top Hyip List,Hyip Review

The easiest way I would do it is to put the initial investment in cell A1 and the annual rate (13%) in B1 and then multiply A1 by 1+B1 to get your ending balance in C1.

Then, I would link A2 to C1. I would copy the percentage rate down 20 cells in the same column and copy the formula in C1 down the column 20 cells as well.

The answer would be $3,456,926.33 with no additions and 13% compounded annually.

I hope this helps. If not, let me know and I can send you and example.

Update…muncie birder is right 13% is tough especially in today’s market. 8-10% is a bit more realistic if you are estimating for yourself. Even then to get that rate you have to be willing to take calculated risks in which you might actually lose money if the investment didn’t pan out.

R Worth gave you an excellent answer, but he should have mentioned that 13% is just a tad on the very aggressive side. You will with 95% probability not be able to maintain 13% over 20 years. A more probable rate would be between 8% and 10% depending on how good an investor you manage to become during the next 20 years.