Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he retires, until he is 85. He wants a fixed retirement income that has the same purchasing power at the time he retires as $40,000 has today. (The real value of his retirement income will decline annually after he retires.) His retirement income will begin the day he retires, 10 years from today, at which time he will receive 24 additional annual payments. Annual inflation is expected to be 6%. He currently has $125,000 saved, and he expects to earn 9% annually on his savings. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.Open spreadsheetHow much must he save during each of the next 10 years (end-of-year deposits) to meet his retirement goal? Do not round your intermediate calculations. Round your answer to the nearest cent.

Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he retires, until he is 85. He wants a fixed retirement income that has the same purchasing power at the time he retires as $40,000 has today. (The real value of his retirement income will decline annually after he retires.) His retirement income will begin the day he retires, 10 years from today, at which time he will receive 24 additional annual payments. Annual inflation is expected to be 6%. He currently has $125,000 saved, and he expects to earn 9% annually on his savings. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.Open spreadsheetHow much must he save during each of the next 10 years (end-of-year deposits) to meet his retirement goal? Do not round your intermediate calculations. Round your answer to the nearest cent.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

A woman is planning for retirement in 30 years and decides she can deposit $6,000 each year on December 31 into a retirement savings plan that she expects will pay 6% interest. In 20 years she also expects to receive a small inheritance of $12,000 that she can also put into her retirement fund. The woman anticipates that her retirement fund will need to last 20 years; she estimates that she will need $60,000 at the end of each year in retirement to cover her living expenses. Her plan is flawed. How much extra does she need to save every year (rounded to dollars and cents) to achieve her goals? (Do not round interim calculations)
Adele is planning for retirement. She would like to have $75,000 in her hand at the beginning of her first year of retirement at age 65 to live on for the year. She estimates that the amount will have to grow by 6% every year to keep up with inflation. What APR (nominal rate per year) should her retirement account earn if it is compounded continuously? She plans to deposit $21,000 on her 40th birthday and plans to keep increasing the deposits by 6% every year and till her 64th birthday. She estimates her life expectancy to be 85, meaning she would like to have the last retirement payment on her 85th birthday.
Monica has decided that she wants to build enough retirement wealth, if invested at 8 percent per year, to provide her with $3,500 of monthly income for 20 years. To date, she has saved nothing, but she still has 30 years until she retires. How much money does she need to contribute per month to reach her goal? First compute how much money she will need at retirement, then compute the monthly contribution to reach that goal.
You are making plans for your retirement. You have just turned 30 and want to retire on your 65th birthday. Once retired, you plan to move to a tax-free Caribbean state, where you believe you can live comfortably on your retirement savings. You plan to make your first withdrawal from your retirement savings when you retire at age 65 and your last withdrawal one month before your 85th birthday. Based on family history, you expect to live until exactly age 85. Your plan is to have a total of $1 million when you retire. Your current salary is $36,000 per year, or $3,000 per month. Your personal tax rate is approximately 30%. You estimate that you can earn an average return of 12% APR compounded annually on any money you invest over the next 60 years. You want to start putting aside a fixed amount of money at the end of every month until your retirement at age 65. You will make your first deposit one month from now and your last deposit on your 65th birthday. Given that you have $1…
Mr. Mangano is considering taking early retirement, having saved $400,000. Mr. Mangano wishes to determine how many years the saving will last if he withdraws $60,000 per year at the end of each year. Mr.Mangano's savings can earn 10 percent per year. 11.67 years. 11.35 years 10.90 years 11.53 years. 12.01 years
Una Day is planning to retire in 14 years, at which time she hopes to have accumulated enough money to receive an annuity of $17,000 a year for 19 years of retirement. During her pre-retirement period she expects to earn 8 percent annually, while during retirement she expects to earn 10 percent annually on her money. What annual contributions to this retirement fund are required for Una to achieve her objective and sleep well at night? (Use a Financial calculator to arrive at the answer. Do not round intermediate calculations. Round the final answer to the nearest whole dollar.) Annual contribution $ 7,422 x
Oscar is looking forward to retirement in a few years when he will have completed 20 years of pensionable service. Oscar's pension plan provides an annual pension benefit of 1.5% of average career earnings for each year of pensionable service. Using information from Oscar's pension statements, he estimates his career average annual earnings will be $50,000 when he retires with 20 years of service. Given these assumptions, calculate Oscar's annual pension benefit that he can expect to receive when he retires. $7,500 $10,000 $15,000 $20,000
Ann is 55 years old and will retire in 10 years. She is depositing $250,000 into a retirement fund now. The fund will earn 8% per year compounded annually. She wants the retirement payments to start one year after retiring (11 years from now). She plans on having 25 annual payments. How much will be the annual retirement payments she will receive?

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

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 Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

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 Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS