The answer to the above question is B. However, what I need to know is if their is an excel function I can use that factors in both interest as well as tax, since most seem to only do interest, or, if there is a way to compound two or more excel functions to solve this in a simple mannor, I had to make a big chart with separate tax values as well as interest continualy calculating using manual addition and multiplication, so I would like to avoid that if possible. If this is not something excel can do, please let me know, but I would ideally like to avoid having to do this:

Question 32 You invest $125,000 now at 8.25% annual interest and your tax rate is 30%. How much will you have in 12 years? Assume you pay taxes annually out of interest that is earned. A) $215,821 B) $245,192 C) $208,763 D) $257,884 E) $296,417 0) 1 125000 10312.5 7218.75 2 132218.8 10908.05 7635.633 3 139854.4 11537.99 8076.591 4 147931 12204.31 8543.014 5 156474 12909.1 9036.373 6 165510.4 13654.6 9558.223 7 175068.6 14443.16 10110.21 8 185178.8 15277.25 10694.08 9 195872.9 16159.51 11311.66 10 207184.5 17092.72 11964.91 11 219149.4 18079.83 12655.88 12 231805.3 19123.94 13386.76 13 245192.1