Excel spreadsheet

[Linnie4536]

My friend wants to start contributing to her employer's 401(k) plan to save
money for retirement. She wonders how much she would save on her income taxes
by contributing to the plan. She says she can invest up to 7% of her income
into the plan, her current income is $45,000.00 per year and she is in the 15%
tax bracket. How would she create an Excel spreadsheet that outlines how much
she would save in taxes by contributing to her 401(k) plan and she would
provide the following investment choices: 1%, 2%, 3%, 4%, 5%, 6%, and 7%.

 

[Matt]

Calculate how much the gross income is for each contribution rate and then
calculate the tax (0.15 x Gross) on the gross income and compare to what you
would pay with no contribution.

Tax = 45,000 * 1.0 * 0.15 (No 401K contributioN)
Tax = 45,000 * 0.99 * 0.15 (1% 401K contribution)
Tax = 45,000 * 0.98 * 0.15 (2% contribution)
etc.

 

[Linnie4536 via OfficeKB.com]

Calculate how much the gross income is for each contribution rate and then
calculate the tax (0.15 x Gross) on the gross income and compare to what you
would pay with no contribution.

Tax = 45,000 * 1.0 * 0.15 (No 401K contributioN)
Tax = 45,000 * 0.99 * 0.15 (1% 401K contribution)
Tax = 45,000 * 0.98 * 0.15 (2% contribution)
etc.

Hi Matt,
Thank-you for your answer and demonstration, I think I kind of understand it.

 

[Linnie4536 via OfficeKB.com]

Calculate how much the gross income is for each contribution rate and then
calculate the tax (0.15 x Gross) on the gross income and compare to what you
would pay with no contribution.

Tax = 45,000 * 1.0 * 0.15 (No 401K contributioN)
Tax = 45,000 * 0.99 * 0.15 (1% 401K contribution)
Tax = 45,000 * 0.98 * 0.15 (2% contribution)
etc.

Hi Matt,
Thanks for you answer, but what would the spreadsheet look like?