Excel spreadsheet
 

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%.

Excel spreadsheet
 

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.

Excel spreadsheet
 

Matt wrote:
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.

--
Message posted via http://www.officekb.com

Excel spreadsheet
 

Matt wrote:
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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1