Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EXCEL FORMULAS PLEASE 1. If I start a job today and will immediately begin contributing to a 401k, how much will I have after 25

EXCEL FORMULAS PLEASE

1. If I start a job today and will immediately begin contributing to a 401k, how much will I have after 25 years,given the following assumptions? $125,000 Salary 6.00%% of salary put to 401k, contributed at year end every year 25years of contributions 5.50%Return on investments during working years $383,644.41 <- answer: balance after end of 25 years 2. If I were to assume a salary growth rate of 2.5% per year as well, what would my balance be after 25 years? <- answer: balance after end of 25 years 4. If, when I reached retirement, I actually had a balance in my retirement account of $3.4 million,how much can I withdraw at the end of each year if I assume 30 years of retirement and a returnon my investments of 4.0% during retirement? <- answer: amount of yearly withdrawal

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Valuing Agile The Financial Management Of Agile Projects

Authors: Alan Moran

1st Edition

0117082880, 9780117082885

More Books

Students also viewed these Finance questions