Solve using excel (show work) Assume you are now 25 years old. You plan to retire...

Solve using excel (show work)

Assume you are now 25 years old. You plan to retire when you are 65 years old. You think you will live until you are 80 years.

a.) If the rate of return during your working years (a.k.a. the "savings period") is 8% and you plan to save $2,000 per year, how much will you have saved up by retirement age?

b.) If the rate of return during your retirement is 6% on the amount of savings you have accumulated, how much will you receive as an annual income during the 15 years you are retired?

c.) Assume borrow $75,000 for college and have to pay back the loan monthly for 10 years after graduation. If the annual rate is 6%, what is the amount of your monthly loan payment?

d.) Would you rather receive: $5000 in three years, $1,000 per year for 7 years or $8000 per year for 15 years if the discount rate is 20%?

Solutions

Expert Solution

a	Amount saved till age 65	$518,113.04

b	Annual income in15 years	$53,346.35

c	Monthly loanpayment	$832.65

d	PV of option 1	$2,893.52
	PV of option 2	$3,604.59
	PV of option 3	$37,403.78
	Select option 3 with highest PV

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Assume you are now 25 years old. You plan to retire when you are 65 years...

Assume you are now 25 years old. You plan to retire when you are 65 years old. You think you will live until you are 80 years. a.) If the rate of return during your working years (a.k.a. the "savings period") is 8% and you plan to save $2,000 per year, how much will you have saved up by retirement age? b.) If the rate of return during your retirement is 6% on the amount of savings you have accumulated,...

please show your work and formula on excel You are now 25 years old. You would...

please show your work and formula on excel You are now 25 years old. You would like to retire when you are 65 years old. You want to receive starting at 65 an annual income of $150,000 per year until you are 95. How much money must you have in your retirement account when you are 65? Assume you can earn 4% per annum.

You plan to work for 40 years and then retire using a 25-year annuity. You want...

You plan to work for 40 years and then retire using a 25-year annuity. You want to arrange a retirement income of $4700 per month. You have access to an account that pays an APR of 8.4% compounded monthly. What size nest egg do you need to achieve the desired monthly yield? (Round your answer to the nearest cent.)

You are now 25 years old. You would like to retire when you are 65 years old.

You are now 25 years old. You would like to retire when you are 65 years old. You want to receive starting at 65 an annual income of $150,000 per year until you are 95. How much money must you have in your retirement account when you are 65? Assume you can earn 4% per annum.

You plan to retire 35 years from now. You expect that you will live 25 years...

You plan to retire 35 years from now. You expect that you will live 25 years after retiring. You want to have enough money upon reaching retirement age to withdraw $180,000 from the account at the beginning of each year you expect to live, and yet still have $2,500,000 left in the account at the time of your expected death (60 years from now). You plan to accumulate the retirement fund by making equal annual deposits at the end of...

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

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

You are 25 years old and plan to retire 35 year from today. You expect that...

You are 25 years old and plan to retire 35 year from today. You expect that you will live 30 years after retiring. You want to have enough money upon reaching retirement age to withdraw $150,000 from the account at the beginning of each year you expect to live, and yet still have $1,000,000 left in the account at the time of your expected death (65 years from now). You plan to accumulate the retirement fund by making equal annual...

You are 25 years old and plan to retire 35 year from today. You expect that...

Assume that your father is now 50 years old, plans to retire in 10 years, and...

Assume that your father is now 50 years old, plans to retire in 10 years, and expects to live for 25 years after he retires - that is, until age 85. He wants his first retirement payment to have the same purchasing power at the time he retires as $35,000 has today. He wants all his subsequent retirement payments to be equal to his first retirement payment. (Do not let the retirement payments grow with inflation: Your father realizes that...

Subjects