Reaching a financial goal

[Shindigbeme]

I have 42,180.53$ in a brokerage account, I will contribute and additional 5000$ to the account at the end of every year, My expected annual return is 12%. my goal is to reach 250,000$. How many years will it take me to accomplish this goal?

[factor-fiction]

Exactly 11 years.

[factor-fiction]

In this table:
Y is the year
A= balance at start of year
B= interest over full year
C= amount paid in on 31 Dec
D= year end balance at 31 Dec

Y <A> <C> < D>
1, 42181, 5062, 5000, 52242
2, 52242, 6269, 5000, 63511
3, 63511, 7621, 5000, 76133
4, 76133, 9136, 5000, 90269
5, 90269, 10832, 5000, 106101
6, 106101, 12732, 5000, 123833
7, 123833, 14860, 5000, 143693
8, 143693, 17243, 5000, 165936
9, 165936, 19912, 5000, 190848
10, 190848, 22902, 5000, 218750
11, 218750, 26250, 5000, 250000

[buildersmate]

Its clearly a trick question from an exam paper. Its been reverse-engineered so that the starting figure produces a nice round number at the end.

[factor39]

I'm sure Shindigbeme is too shy to see his name in print again but would really like to thank factor30 for the work he put in to doing shindigbeme's homework.