Ishan and Hazel plan to retire at age 60 with a retirement income of $48,000 a year from their savings. Rather than pay themselves the whole amount at the beginning of each year, they have decided that payment at the beginning of each quarter of $12,000 gives them the right balance of flexibility and maximized interest earnings. They feel they can safely earn an interest rate of 8%, compounded quarterly, on their money and they are budgeting based on the prediction that they will live until they are 90 years old.
Now that Ishan and Hazel have their saving goal calculated, and rounded up to the nearest dollar, they want to start budgeting to reach that goal. They are 40 years old currently, so they have just 20 years to save up the total they calculated they would require so that they can still reach their goal of retirement by age 60.
If they assume the same interest rate, and make deposits into their savings at the beginning of every month, how much would their deposit have to be each month?
How much interest will be earned?
Step by stepSolved in 4 steps with 2 images
Is it possible to get a solution with formulas instead of excel?
Is it possible to get a solution with formulas instead of excel?
- Tariq Ahmed is 25 years old and is saving for her retirement. He is planning on making 40 contributions to her retirement account at the beginning of each of the next 40 years. The first contribution will be made today and the final contribution will be made 40 years from today. The retirement account will earn a return of 12 percent a year. If each contribution he makes is $5,000, how much will be in the retirement account 40 years from now?arrow_forwardMelissa wants to retire with $45,000 per month.she needs $4,500,000 in principal at the time she retires in order to generate this amount of monthly income if the interest rate is 12%.If Melissa has 28 years before retirement and has $90,000 to invest today.What simple interest rate does she need to achieve the necessary amount of principal?arrow_forwardPeter and Blair recently reviewed their future retirement income and expense projections. They hope to retire in 29 years and anticipate they will need funding for an additional 20 years. They determined that they would have a retirement income of $62,000.00 in today's dollars but that they would actually need $86,142.00 in retirement income (in today's dollars) to meet all of their objectives. a. What is their annual shortfall at retirement assuming inflation of 3 percent per year? Click on the table icon to view the FVIF table: b. At the time that they retire, how much additional amount must they have accumulated to fund their retirement needs, assuming 3 percent inflation and a rate of return of 9 percent? Click on the table icon to view the PVIFA table: c. Calculate the additional amount that Peter and Blair must save each year for the next 29 years if they wish to completely fund their income shortfall. Click on the table icon to view the FVIFA table:arrow_forward
- Ishan and Hazel plan to retire at age 60 with a retirement income of $48,000 a year from their savings. Rather than pay themselves the whole amount at the beginning of each year, they have decided that payment at the beginning of each quarter of $12,000 gives them the right balance of flexibility and maximized interest earnings. They feel they can safely earn an interest rate of 6.5%, compounded quarterly, on their money and they are budgeting based on the prediction that they will live until they are 90 years old. How much money will they have to have saved by the time they are 60 in order to reach their retirement goal? If the same total calculated above was to be saved, but no interest earned whatsoever, how much would be available to live on each quarter? If the full 30 years are lived and quarterly budget spent, how much money in total will have been utilized in retirement? How much will have been earned in interest?arrow_forwardJamie Lee and Ross agree that by accomplishing their short goals, they can budget $5,000 a year towards their long-term investment goals. They are estimating that with the allocations recommended by their financial advisor, they will see an average of 7 percent on their investments. The triplets will begin college in 15 years and will need $100,000 for tuition. Using the Time Value of Money calculations, decide if Jamie Lee and Ross will be on track to reaching their long-term financial goals of having enough money from their investments to pay the triplets’ tuition.arrow_forwardRajesh and Priya plan to retire at age 60 with a retirement income of $48,000 a year from their savings. Rather than pay themselves the whole amount at the beginning of each year, they have decided that withdrawing payments of $12,000 at the beginning of each quarter of gives them the right balance of liquidity and maximized interest earnings. They feel they can safely earn an interest rate of 5.75%, compounded quarterly, on their money and they are budgeting based on the prediction that they will live until they are 90 years old. How much money will they have to have saved by the time they are 60 and ready to begin their retirement, in order fulfill this plan? [Blank-1]If the same total calculated above was to be saved, but no interest earned whatsoever, how much would be available to live on each quarter? [Blank-2]If the full 30 years are lived and quarterly budget spent, how much money in total will have been utilized in retirement? [Blank-3]How much will have been earned in…arrow_forward
- A 30 year - old person plans to retire at 64 and live until 92. During retirement, the person will take a growing annuity from the retirement account. The amount in the first year will be $90,000 with a 2% growth rate. The return on savings before retirement is 9%, an after retirement is 6%. Initial savings are zero, and the person does not want to leave a legacy at the time of death. How much must the person save per year before retirement to achieve this goal?arrow_forwardJoe's starting salary as a mechanical engineer is around $100,000. Joe is planning to place a total of 8% of his salary each year in the mutual fund. Joe expects a 5% salary increase each year for the next 30 years of employment. If the mutual fund will average 9% annual return over the course of his career, what can Joe expect at retirement?arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education