You have just made your first $5,000 contribution to your retirement account. Assume you earn a return of 10 percent per year and make no additional contributions. What will your account be worth when you retire in 45 years? What if you wait 35 years before contributing? (show answer using function feature in excel)

You have just made your first $5,000 contribution to your retirement account. Assume you earn a return of 10 percent per year and make no additional contributions. What will your account be worth when you retire in 45 years? What if you wait 35 years before contributing? (show answer using function feature in excel)

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

How much can be accumulated for retirement if $2,000 is put aside at the end of each of the next 40 years? Assume that you can earn 9% a year on your savings.
You decide to make monthly payments into a retirement fund earning 4.75% compounded monthly. Note: Payments are made at the end of each period.
Assume that you are 30 years old today, and that you are planning on retirement at age 65. Your current salary is $45,000 and you expect your salary to increase at a rate of 5% per year as long as you work. To save for your retirement, you plan on making annual contributions to a retirement account. Your first contribution will be made on your 31st birthday and will be 8% of this year's salary. Likewise, you expect to deposit 8% of your salary each year until you reach age 65. Assume that the rate of interest is 7%, what is the present value of your retirement savings? please answer fast i give upvote
You wish to retire after 22 years; at which time you want to have accumulated enough money to receive an annuity of $68,000 a year for 25 years of retirement. During the period before retirement, you can earn 6 percent annually, while after retirement you can earn 4 percent on your money. What annual contribution to the retirement fund will allow you to receive the $68,000 annually?
Your parents will retire in 26 years. They currently have $360,000 saved, and they think they will need $1,050,000 at retirement. What annual interest rate must they earn to reach their goal, assuming they don't save any additional funds? Round your answer to two decimal places.
You have just made your first $10,000 contribution to your individual retirement account. Assume you earn an annual rate of return of 12 percent compounded quarterly and make no additional contributions. What will your account be worth when you retire in 50 years?Note: Do not round intermediate calculations and round your answer to 2 decimal Blaces, e.g., 32.16. You need $20,000 to go on your dream vacation to South Africa. If you save $5,000 today in an account at 10% interest compounded annually, how long will you have to wait to go on your dream vacation?Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.
Your employer automatically puts 5 percent of your salary into a 401(k) retirement account each year. The account earns 7% interest. Suppose you just got the job, your starting salary is $50000, and you expect to receive a 3.5% raise each year. For simplicity, assume that interest earned and your raises are given as nominal rates and compound continuously. Find the value of your retirement account after 20 years Value = $
As part of your financial planning and to supplement your retirement, you decided to save $3000 at the end of each year for 30 years, how much money you will have in your account if you can earn 10%?
You are 46 years from retirement. Starting now, if you save $8,141 at the end of every year until you retire, how much will you have at retirement if the interest rate is 5.8 percent? (Do not round any intermediate calculations. Round your final answer to 2 decimal places and enter it in the box below.)
I am 25 years of age.
You annually invest $2,000 in an individual retirement account (IRA) starting at the age of 30 and make the contributions for 15 years. Your twin sister does the same starting at age 35 and makes the contributions for 25 years. Both of you earn 7 percent annually on your investment. What amounts will you and your sister have at age 60? Use Appendix A and Appendix C to answer the question. Round your answers to the nearest dollar.Amount on your account: $ Amount on your sister's account: $ Who has the larger amount at age 60?-Select-You haveYour sister hasItem 3 the larger amount.
I am not understanding how to use excel to get the answer to this. Please show excel work. Answer should be: $2,704,814

SEE MORE QUESTIONS

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