So, I have my base pay in cell B2
Column A runs down the % of the contribution made by me, 6% - 30%
Column B is contribution in dollars, this is base pay * contribution %
Column C is employer contribution, set at 3%, or .03 for calculation purposes
Column D is total contribution, mine + employers
Column E is Yearly contribution - column D * 12
So, I'm assuming my formula would be fv(1+.06)360,D4
That would be 6% interest, 360 months (30 years),D4 (total monthly contributions)
I'm getting a -6 trillion number :)
I'm usually very proficient in excel, so something isn't clicking in my head this morning.
I also have taxes/insurance, dependent care contribution, and HSA contribution, to help come to my actual net paycheck amount, but that isn't the issue at hand.