Your goal is to retire 30 years from now and have investments worth $2.5 million at thattime. Today, you have $211 in your investment account and plan on adding an additional $10,000 to that account each year. What annual rate of return must you earn on average toachieve your goal?

Calculate the annual rate of return using Excel as follows:Formula sheet:Notes:To understand the…

Answered: Your goal is to retire 30 years from…

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 10P

See similar textbooks

Similar questions

You want to invest $8,000 at an annual Interest rate of 8% that compounds annually for 12 years. Which table will help you determine the value of your account at the end of 12 years? A. future value of one dollar ($1) B. present value of one dollar ($1) C. future value of an ordinary annuity D. present value of an ordinary annuity
Suppose you wish to retire 30 years from today .You have determined that you would need $75,000 annually once you retire, which you will withdraw at the end of each year. You estimate that you will earn 6% on your retirement funds, compounded annually, and that you will live for 20 years after retirement. how much funds would you need on retirement to fullfill your goals above.?
Imagine that your goal is to retire 34 years from today with $1,000,000 in savings. Assuming that you currently (i.e., today) have $5,000 in savings, what rate of return must you earn on that savings to hit your goal?
You believe you will need to have saved $510,000 by the time you retire in 30 years in order to live comfortably. If the interest rate is 7% per year, how much must you save each year to meet your retirement goal?
You have decided that in order to have a comfortable retirement you will need to replace $65,000 in income each year in retirement. Assuming you will need 20 years of retirement income and an inflation rate of 3.5%, how much will you need to have saved up in order to meet your goal on the day you retire?
You are planning on retiring for retirement 34 years from now. You plan to invest $4,200 per year for the first 7 years, $6,900 per year for the next 11 years, and $14,500 per year for the following 16 years (assume all cashflows occur at the end of each year). If you believe you will earn an effective annual rate of return of 9%, what will your retirement investment be worth 34 years from now?
You believe you will need to have saved $593,000 by the time you retire in 30 years in order to live comfortably. You also believe that you will inherit $113,000 in 5 years. 1) If the interest rate is 7% per year, what is the future value of your inheritance at retirement? 2) How much additional money must you save to meet your retirement goal, assuming you save your entire inheritance?
You are planning for retirement 34 years from now. You plan to invest $4,200 per year for the first 7 years, $6.900 per year for the next 11 years, and $14,500 per year for the following 16 years (assume all cash flows occur at the end of each year). If you believe you will earn an effective annual rate of return of 9.7%, what will your retirement investment be worth 34 years from now ? Using financial calculator
You want to retire soon. When you finally retire, you want your investments to provide you with an income of $150,00 each year for the next 40 years. If the annual interest rate guaranteed to be 6 percent or higher, what is the present value of that stream of payments (or how much of a deposit do you need in order to get that payment amount per year)?
in planning for your retirement, you would like to withdraw $80,000 per year for 17 years, the first withdrawal will occur 20 years from today. A- what amount must you invest today if your return is 10% per year? B-What amount must you invest today if your return is 15% per year?
In planning for your retirement, you have decided that you would like to be able to withdraw $60,000 per year for a 10 year period. The first withdrawal will occur 20 years from today. a. What amount must you invest today if your return is 10% per year? b. What amount must you invest today if your return is 15% per year?
You plan to make annual deposits of $5,000 per year at the beginning of each year into your retirement account. Your goal is to have $800,000 If you expect to get an 8% rate of return, how many years will it take you to reach your goal?

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Financial Accounting Intro Concepts Meth/Uses

Finance

ISBN:

9781285595047

Author:

Weil

Publisher:

Cengage

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Financial Accounting Intro Concepts Meth/Uses

Finance

ISBN:

9781285595047

Author:

Weil

Publisher:

Cengage

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

Your goal is to retire 30 years from now and have investments worth $2.5 million at that time. Today, you have $211 in your investment account and plan on adding an additional $ 10,000 to that account each year. What annual rate of return must you earn on average to achieve your goal?