Solved How do I caculate a 401k plan in excel?

December 12, 2015 at 05:51:24
Specs: Windows 7
I'm trying to calculate a 401k plan that shows 40 cents on the dollar up to 8%. How do I do that in MS Excel?

See More: How do I caculate a 401k plan in excel?

Report •

December 12, 2015 at 05:57:49
I don't understand what you are asking.

40 cents on a dollar is 40%. What does "up to 8% mean"?

What does "calculate a 401k plan" mean?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

December 12, 2015 at 06:06:28
I'm trying to calculate 40 cents for every dollar up to 8% in excel. For an example, my 401k plan matches up salary dollar for dollar up to 6%, but if it's only 40 cents of a dollar, how is that entered into excel? To calculate my example, I would enter 0.06*(Salary amount) How does one have excel calculate 40 cents on a dollar?

Report •

December 12, 2015 at 09:48:35
✔ Best Answer
Is this what your looking for:

         A              B
1) Salary          $100,000.00 
2) Percent Match            8%
3) Dollar Amt        $8,000.00 
5) 40 Cents                40%
6) Total Match       $3,200.00 

In Excel the formula would be:


Does that work for you?


Report •
Related Solutions

Ask Question