We assume an age at retirement of 67. Assuming that you start with zero dollars, at...

We assume an age at retirement of 67. Assuming that you start with zero dollars, at your age**, today, and you begin setting aside $500 per month, each month, from the present until age 67. How much money will you have set aside?

Now, assume that your savings are invested at a annual return rate of 7%. How much money will you have at age 67? Would it make a difference if you invested an additional $100 each month, for a total of $600?

What can we learn from your results?

** Starting age is 20 **

Expert Solution

1. Value of Deposits of $ 500 at the age of 67: $2357958.56

2. Value of Deposits of $ 600 at the age of 67: $2829550.27

3. Conclusion: the lesson we can learn from the results is that the value of deposits will increase at an compounded rate just because the deposit amount increased by $100 i.e., from $2357958.56 with $500 deposit to $2829550.27 with $600 deposit

*NPER=(67 years - 20 years + 1) * 12

Please comment if you face any difficulty and please dont forget to upvote

jeff jeffy answered 1 year ago

For the initial scenario, assume your current age, zero current savings, a retirement age of 60,...

For the initial scenario, assume your current age, zero current savings, a retirement age of 60, a life expectancy of 95 years, an inflation rate of 3.5%, an investment portfolio return of 9% and current purchasing power of income of $75,000. Set up your worksheet to compute and show the user: (a) How much they will need to have the day they retire in order to fund their retirement with no additional contributions, (b) How much they will need to...

You plan to graduate at age 23 and start saving for retirement at age 24. You...

You plan to graduate at age 23 and start saving for retirement at age 24. You save as follows: Age 24-35 $6,000 per year Age 36-50 $5,000 per year Age 51-60 $2,000 per year Age 61-65 $8,000 per year How much money will you be able to withdrawal from ages 66-90 as regular amounts assuming all money earns 6.5% interest? Please use excel and show equations

You decide that you want to save 767,393 dollars for retirement. Assuming that you are 25...

You decide that you want to save 767,393 dollars for retirement. Assuming that you are 25 years old today, will retire at the age of 65, and can earn a 8 percent annual interest rate on your deposits, how much must you deposit each year to meet your retirement goal? (your first deposit will be one year from now and your last deposit will be 40 years from today, i.e. 40 deposits) Hint : The number of years for FVIFA...

1. Assume you will retire at 67. You decide to open a retirement account that earns...

1. Assume you will retire at 67. You decide to open a retirement account that earns 8% interest. You will put $125 per month into this account starting now (age of 38 years old). How much money will you have in this account when you retire? 2. Assume you will retire at 67. You decide to open a retirement account that earns 8% interest. You put $125 per month into this account starting now (38 years old), for a 10-year...

If you start contributing to your retirement account at the age of 18 with $25 a...

If you start contributing to your retirement account at the age of 18 with $25 a month and you increase your contributions by $5 each year, how much will you be contributing a month at the age of 40?

Disability Before Retirement: Jack, age 60, was planning on retirement at 67. He currently has $400,000...

Disability Before Retirement: Jack, age 60, was planning on retirement at 67. He currently has $400,000 in his retirement accounts and would likely have doubled that by the time he retired. However, he has become permanently disabled after getting into a vehicle accident a few months ago. If his average earnings were $65,000, what would his Social Security disability benefit be? Social Security Disability benefits end at age 65, and he will switch over to Social Security Retirement benefits. What...

Assume you are 32 years old and plan to retire in 35 years at age 67....

Assume you are 32 years old and plan to retire in 35 years at age 67. You are currently earning $75,000/year and expect average annual salary increases of 4.0%/year over the next 35 years. You have $0 saved for retirement. You are trying to determine how much money to save (invest) each year in your 401(k) Plan to fund your retirement in order to pay yourself 70% of your final salary each year (that increases with inflation). [Remember this is...

You want to start saving for retirement. Your goal is to retire in 25 years. Assume...

You want to start saving for retirement. Your goal is to retire in 25 years. Assume that you have $25,000 to invest now and that you will contribute $4,800 per year. What will your account be worth when you retire if you can earn 6% a year? What will your account be worth if the 6% annual return is compounded monthly and instead of contributing $4,800 per year, you contribute $400 monthly (you still start with $25,000) Assume all payments...

Assume you have a half million dollars to invest to start a business. Perform a Porter’s...

Assume you have a half million dollars to invest to start a business. Perform a Porter’s Five Forces analysis for the grocery retail industry in the US. List each of the five forces as low threat, medium threat or high threat. You should write a paragraph for EACH force explaining your analysis and give supporting arguments for why you came to that conclusion for each of the forces. At the end, use this Porter’s Five Forces analysis to determine if...

4. At age 35 you start saving for retirement. Your investment plan pays 6% APR compounded...

4. At age 35 you start saving for retirement. Your investment plan pays 6% APR compounded monthly and you want to have $2,000,000 when you retire at age 65. a) How much do you need to save each month? b) Suppose you had started saving when you were 30 years old. How much would you need to save each month? c) Suppose you had started saving when you were 25 years old. How much would you need...

Question