If you intend to make $175,000 per year in the latter part of your career and you wish to maintain that in retirement, how much must you have saved at retirement? You expect to earn an average of 6% in retirement. You plan to retire at the age of 65 and you feel you need to conservatively maintain this income until the age of 100 years old. Total amount saved
Answer:,
Let us assume on retirement, annual withdrawal will be made at the beginning of year.
Annual withdrawal =$175,000
Number of years (Retirement duration) = 100 - 65 = 35 years
Rate of earnings during retirement = 6%
To get total retirement corpus (total amount saved) at the start of retirement, we will use PV function of excel:
= PV (rate,nper, pmt, fv, type)
= PV (6%, 35, -175000, 0, 1)
= $2,689,424.70
Total amount Saved (on retirement date) = $2,689,424.70
If you intend to make $175,000 per year in the latter part of your career and...
You are 22 years old, college grad with a full-time job in your career, thinking about saving for retirement. You go to a financial planning site to get some ideas. The site asks you the following questions: At what age do you think you would like to retire? How much money do you feel you would need per year to live on during the first year of retirement? (consider housing, medical expenses, travel, etc. – many financial experts suggest 80%...
You just turned 30 years old, and decided that it is time to start saving for retirement. Based on your anticipated income and expenses, you expect to be able to invest $4,000 each year until you are 50 years old, and then $5,000 each year until you retire at age 65. You expect to earn 6.1% on your investments. What is the expected value of your retirement account at age 65? During retirement, you expect to spend about $160000 per...
You are 25 years old and decide to start saving for your retirement - so smart! You plan to save $5,000 each year (so the first deposit will be one year from now), and you will make your last deposit when you retire at age 65. Suppose you earn 8% compounded annually on your retirement savings. a. How much will you have saved for retirement? b. How much will you have saved if you wait until age 35 to start...
A young couple, both 25 years old, are planning to retire in 40 years at the age of 65. After they retire, they expect to live for an additional 20 years, until age 85. They plan to begin saving for retirement today and based on information from their financial planner, they think they will earn 8% on their investment compounded annually. They think they will earn 5% on their retirement savings after they retire. If they begin at age 25...
expect to retire You are 35 years old today and are considering your retirement needs. You at age 65 and your actuarial tables suggest that you will live to be 100. You want to move to the Bahamas when you retire. You estimate that it will cost you $ 300,000 to make the move (on your 65th birthday) and that your living expenses will be $30,000 a year (starting at the end of year 66 and continuing through the end...
EQuestion Help You have just turned 22 per year You cannot make withdrawals until comfortably in retirement you will need $105,000 per year, starting at the end of bachelor's degree, and accepted your first job. Now you must decide how much money to put into your you retire on your 65th birthday After that, you can make retirement plan. The plan works as follows Every dollar in the plan earns 74% rawals as you see fit You decide that you...
You want to withdraw $11,200 per month for 30 years when you retire, then you expect to pass on. You plan to retire in 40 years, and expect to earn a return of 11.2 percent until then. You will make monthly deposits to fund your retirement account. Immediately after you make your last deposit, you plan to withdraw $80,000 to take an around the world trip. You also wish to leave your grandchildren $1,200,000 when you pass on. You will...
You have just turned 30 years? old, have just received your? MBA, and have accepted your first job. Now you must decide how much money to put into your retirement plan. The plan works as? follows: Every dollar in the plan earns 7% per year. You cannot make withdrawals until you retire on your 65th birthday. After that? point, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until...
You have just turned 30 years old, have just received your MBA, and have accepted your first job. Now you must decide how much money to put into your retirement plan. You are required to specify a fixed percentage of your salary that you want to contribute. Assume that your starting salary is $78,000 per year and it will grow 1.9% per year until you retire. Every dollar in the plan earns 7.1% per year. You cannot make withdrawals until...
Can you please solve these on Excel and show me how you solved
it. Thank you so much.
6) You would like to have $5 million dollars when you retire at age 65. You are 25 years old and you want to make your first savings payment immediately. You have not saved any money for your retirement as of yet. Assume interest rate is 7%, how much money must you set aside per year until and including your 65th birthday?...