You are currently 40 years old and intend to retire at age 60. To make your...

You are currently 40 years old and intend to retire at age 60. To make your retirement easier, you intend to start a retirement account. At the END of each of years, you will deposit some money to your retirement account till your retire. You expect the account will earn 7% per year. After retirement at age 60, you want to withdraw $10,000 from your retirement account at the END of each year for 10 years. How much money should you plan to deposit in your retirement each year? Requirement: Use all the three methods (1) Solver, (2) Goal Seek, and (3) PV and PMT function to solve for annual deposit. Use snipping tool to screenshot the dialog windows of Solver and Goal Seek with the appropriate parameters.

Solutions

Expert Solution

Answer)

Inputting the values from the table below , we need to find the PV of the money required at age 60.

Using PV function in excel and using the following values:

PMT = 10,000 , N = 10 , FV = 0, I/Y = 7%

PV = 70,236

Now finding the annula deposits (PMT) from PV of 70,236 at age 40 , We use the PMT function in excel and input the following values:

PV = 0 , FV = 70,236, I/Y = 7%, N = 20

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

Hypothetically, you are currently 55 years old and intend to retire at age 60. To make...

Hypothetically, you are currently 55 years old and intend to retire at age 60. To make your retirement easier, you intend to start a retirement account. At the beginning of each years 1, 2, 3, 4 (that is, starting today and at the beginning of each of the next four years), you intend to make a deposit into the retirement account. You assume that the account will earn 8% per year. After retirement at age 60, you anticipate living 8...

Julia, your aunt, currently is 55 years old; she will retire at the age of 60....

Julia, your aunt, currently is 55 years old; she will retire at the age of 60. Last month, Julia just formed a portfolio with stock A, B, and C. Julia invest her retirement money equally in all 3 assets. Beta of each assets are as follows; bA = 2.21; bB = 1.85; and bC = 1.75 Aunt Julia is a very conservative investor, she can accept minimal risk and she can bear the maximum loss only 5% of her investment,...

You are 40 years old and want to retire at age 60. Each year, starting one...

You are 40 years old and want to retire at age 60. Each year, starting one year from now, you will deposit an equal amount into an investment account that pays 4.6% interest. The last deposit will be on your 60th birthday. On your 60th birthday, you will switch the accumulated savings into a safer bank account that pays only 4.2% interest. You will withdraw your annual income of $130,000 at the end of that year (on your 61st birthday)...

25 years old and $70,000 yearly salary.1.) you intend to retire at the age of...

25 years old and $70,000 yearly salary.1.) you intend to retire at the age of 65, (40yrs). if the inflation rate over the next 40 years is expected to average 2.5% per year, how much money will you have to be earning at the start of your retirement to have the same purchasing power your 70,000 salary today? Ignore taxes, show work2.) you need to have $250,000 per year to live comfortable in retirement to allow for your passion for...

You now realize you would like to retire in 30 years (age 60). You are currently...

You now realize you would like to retire in 30 years (age 60). You are currently making $90K a year. After your life expenditure and taxes, you are able to save 10% of your salary. You come from a family with really good genes so you expect to live another 25 years after retirement (to an age of 85 years old). You do not want to be a burden on your family and it’s not likely there will be any...

1. You are now 50 years old and plan to retire at age 65. You currently...

1. You are now 50 years old and plan to retire at age 65. You currently have a stock portfolio worth $150,000, a 401(k) retirement plan worth $250,000, and a money market account worth $50,000. Your stock portfolio is expected to provide annual returns of 12 percent, your 401(k) investment will earn 9.5 percent annually, and the money market account earns 5.25 percent, compounded monthly. (12 points) a. If you do not save another penny, what will be the total...

Your dad is now 55 years old and plans to retire at age 70. He currently...

Your dad is now 55 years old and plans to retire at age 70. He currently has a stock portfolio worth $450,000. The portfolio is expected to earn a return of 8 percent per year. b. Assume he plans to invest an additional $12,000 every year in his portfolio for the next 15 years (starting one year from now). How much will his investments be worth when he retires at 70? c. Assume that your dad expects to live 20...

You are 40 years old and want to retire at age 65. Each year, starting one...

You are 40 years old and want to retire at age 65. Each year, starting one year from now, you will deposit an equal amount into an investment account that pays 4% interest. The last deposit will be on your 65th birthday. On your 65th birthday, you will switch the accumulated savings into a safer bank account that pays only 4.2% interest. You will withdraw your annual income of $110,000 at the end of that year (on your 66th birthday)...

you will work for 40 years then you will retire. when yiu retire, you will make...

you will work for 40 years then you will retire. when yiu retire, you will make the first of 40 annual investments of $7549 in a fund. the fund is expected to return 9.9% per year, how much will you have on the day that you make your last deposit?

You are 30 years old and want to retire at the age of age 65 and...

You are 30 years old and want to retire at the age of age 65 and expect to live another 25 years. On the day you retire, you want to have $900,000 in your retirement savings account. a) If you invest monthly starting one month from today and your investment earns 6.0 percent per year, How much money do you need to invest every month until you retire? b) You're retired with $900,000 and you have 25 more years. You...

Subjects