Kindly answer this as soon as possible. UrgentNOTE:It was answered before but was in excel kindly this time do not use excel. ThanksAssume that when you are 25 years old you plan to aggressively save for your retirementby contributing $5,000 a year to a tax-sheltered account. A relative of yours tells you toforget about earning 10 percent or more a year, because that is very unlikely to happen(which is true). He also tells you that you should not worry too much about whether youearn, for example, 6 or 7 percent, because it won't make a lot of difference in your finalwealth. You decide to see for yourself the various results that could occur by doing somecalculations.a. Fill in the spreadsheet below with the combinations indicated. Determine the difference inoutcomes between 9 percent for 40 years and 10 percent for 40 years.b. Calculate the difference between earning 6 percent and earning 7 percent for 20, 30 and 40years. How would you respond to your relative?5% 6% 7% 8% 9% 10%20 yrs25 угs30 yrs35 yrs40 yrs

The question is based on the concept of calculating the future value of a periodic deposit, which…

Answered: Assume that when you are 25 years old…

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter14: Planning For Retirement

Section: Chapter Questions

Problem 2FPE

See similar textbooks

Similar questions

“Suppose that your parents are willing to lend you $20,000 for part of the cost of your college education and living expenses. They want you to repay them the $20,000 without any interest, in a lump sum 15 years after you graduate, when they plan to retire and move. Meanwhile, you will be busy repaying federally guaranteed loans for the first 10 years after graduation. But you realize that you won’t be able to repay the lump sum without saving up. So you decide that you will put aside money in an interest-bearing account every month for the first five years before the payment is due. You feel comfortable with setting aside $275 a month (the amount of the payment on your college loans, which will be paid off after 10 years). How high an annual nominal rate on savings do you need to accumulate the $20,000, in 60 months, if interest is compounded monthly? Enter into a spreadsheet the values of d = 275, r = 0.05 (annual rate), and n = 60, and the savings formula with r replaced…
Suppose that your parents are willing to lend you $20,000 for part of the cost of your college education and living expenses. They want you to repay them the $20,000, without any interest, in a lump sum 15 years after you graduate, when they plan to retire and move. Meanwhile, you will be busy repaying federally guaranteed loans for the first 10 years after graduation. But you realize that you won’t be able to repay the lump sum without saving up. So you decide that you will put aside money in an interest-bearing account every month for the five years before the payment is due. You feel comfortable with putting aside $275 a month (the amount of the payment on your college loans, which will be paid off after 10 years). How high an annual nominal interest rate on savings do you need to accumulate the $20,000 in 60 months, if interest is compounded monthly? Enter into a spreadsheet the values d 5 275, r 5 0.05 (annual rate), and n 5 60, and the savings formula with r replaced by r/12 (the…
(spread sheet) supposed that your parents are willing to lend you $20,000 for part of the cost of your college education and living expenses. They want you to repay them the $20,000, without any interest, in a lump sum 15 years after you graduate, when they plan to retire and move. Meanwhile, you will be busy repaying federally guaranteed loans for the first 10 years after graduation. But you realize that you won't be able to repay the lump sum without saving up. So you decide that you will put aside money in an interest-bearing account every month for the five years before the payment is due. You feel comfortable with putting aside $275 a month ( the amount of the payment of your college loans, which will be paid off after 10 years.) how high an annual nominal interest rate in savings do you need to accumulate the $20,000 in 60 months, if interest is compounded monthly? Enter into a spreadsheet the values d =275, r=0.05 (annual rate), and n=60, and the savings formula with r…
Hi, on the topic of time value of money, I am having trouble with the steps to answer the following questions: 1. Mia plans to save $9,700 a year for the next 27 years to help her in retirement starting at the end of this year. If her super fund earns 8.6% p.a, how much money would she be able to spend per year over the following 35 years?" 2. Jane intends to retire in 30 years' time. What annual contribution should she make to her superannuation fund, starting at the end of the current year, if she expects to draw a pension of $120,000 per year for 20 years following her retirement? Her fund earns a return of 5% p.a. with annual compounding. Thank you! :)
Experts say that the baby boom generation (born 1946-1960) cannot count on a company pension or Social Security benefits to provide a comfortable retirement. It is recommended that they start to save regularly and early. Michael, a baby boomer, has decided to deposit $3000 every year in an account that pays 12% compounded semiannually for 15 years. a) How much money will be in the account at the end of the 15 years? b) Suppose Michael has determined he needs to accumulate $250,000 from this annuity. What rate would achieve this goal? c) If he cannot get the higher rate, what amount would his payments need to be in order to achieve the goal?
Problem “Suppose that your parents are willing to lend you $20,000 for part of the cost of your college education and living expenses. They want you to repay them the $20,000 without any interest, in a lump sum 15 years after you graduate, when they plan to retire and move. Meanwhile, you will be busy repaying federally guaranteed loans for the first 10 years after graduation. But you realize that you won’t be able to repay the lump sum without saving up. So you decide that you will put aside money in an interest-bearing account every month for the first five years before the payment is due. You feel comfortable with setting aside $275 a month (the amount of the payment on your college loans, which will be paid off after 10 years). How high an annual nominal rate on savings do you need to accumulate the $20,000, in 60 months, if interest is compounded monthly? Enter into a spreadsheet the values of d = 275, r = 0.05 (annual rate), and n = 60, and the savings formula…
An individual is currently 30 years old, wants to work until the age of 65 and plans on dying at the age of 85. How much will the individual need to have saved by the time he or she is 65 if he or she plans on spending $40,000 per year while retired? You can assume the individual can earn an interest rate of 5.0% and the $40,000 is in addition to any Social Security that may be received
You took an amazing class at the U that changed your life, so now you are going to invest for your retirement. Your tax bracket is 25% federal and 5% state. Your investment is in a federally and state tax free account that earns 11% each year, what interest rate are you effectively earning on your investment? How much will you have effectively earned if you invest $4,000 each year for the next 35 years (please use the rate you got in question 1)?
You invest $2000 today at 7% per year. If you leave thisfor your grandchildren by not touching the account for80 years, what is the amount of interest on interestearned for this investment? Please explain how to do this problem in the financial calculator. The most important thing is that I understand how to solve the problem on my own
Nicola Martin also just started working with the NCB as a sales representative and is just trying to catch up on having money for retirement. NCB offers her a pension plan with an annuity that is guaranteed to earn 11% interest compounded Semi-annually. She plans to work for the same 12 years before retiring and would then like to be able to draw an income of $110,000 per annum for 16 years. How much must be deposited per annum into her retirement fund to accomplish this? DO NOT USE EXCEL SHOW ALL WORKING
You just accepted an offer from XYZ Petrochemical Company in Louisiana. As a sign up bonus, the XYZ will deposit $10,000 in a retirement account for you which generates 12% return annually. In addition, the company deposits $5,000 every year in the same account, if you stays with XYZ. How much money will be accumulated in this account if you decide to retire 40 years from now?
1. Shanice Johnson, of Philadelphia, Pennsylvania, wants to invest $4,000 annually for her retirement 30 years from now. She has a conservative investment philosophy, and expect to earn a return of 3% in a tax-sheltered account. If she took a more aggressive investment approach and earned a return of 5%, how much more would Shanice accumulate? (Hint: use the ordinary annuity formula, as in find the future value of periodic payments made to an interest-bearing account.) 2. List two or three mistakes that people make when planning for retirement. In your opinion, which one might be the most serious one and why?

SEE MORE QUESTIONS

Recommended textbooks for you

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

SWFT Essntl Tax Individ/Bus Entities 2020

Accounting

ISBN:

9780357391266

Author:

Nellen

Publisher:

Cengage

SWFT Comprehensive Vol 2020

Accounting

ISBN:

9780357391723

Author:

Maloney

Publisher:

Cengage

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

SWFT Essntl Tax Individ/Bus Entities 2020

Accounting

ISBN:

9780357391266

Author:

Nellen

Publisher:

Cengage

SWFT Comprehensive Vol 2020

Accounting

ISBN:

9780357391723

Author:

Maloney

Publisher:

Cengage

SWFT Comprehensive Volume 2019

Accounting

ISBN:

9780357233306

Author:

Maloney

Publisher:

Cengage

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS