Question

10. Today, you are retiring. You have a total of $413,926 in your retirement savings and...

10.

Today, you are retiring. You have a total of $413,926 in your retirement savings and have the funds invested at 4.2 percent, compounded monthly. You want to withdraw $2,500 at the beginning of every month, starting today. You also want the withdrawals to stop when your account balance declines to $100,000. For how many years can you make withdrawals?

17.07 years

18.24 years

16.96 years

15.22 years

13.81 years

Homework Answers

Answer #1

the period till which withdrawals can be made is calculated using NPER function in Excel. with the following parameters,

rate = monthly rate = quoted rate /12

pmt = 2500 = monthly withdrawal

pv = -413926 = amount in retirement savings

fv = 100000 = account balance

type = 1 ( for beginning of the period withdrawals)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Today, you are retiring. You have a total of $289,416 in your retirement savings. You want...
Today, you are retiring. You have a total of $289,416 in your retirement savings. You want to withdraw $2,500 at the beginning of every month, starting today and expect to earn 4.6 percent, compounded monthly. How long will it be until you run out of money? I need to solve it with this calcualter , please, ( Texas Instruments - BA II Plus) step by step. Thank you so much for your time and your help
PLEASE SOLVE THIS QUESTION IN DETAILS AND WITHOUT USING FINANCIAL CALCULATOR, AGAIN DO NOT USE FINANCIAL...
PLEASE SOLVE THIS QUESTION IN DETAILS AND WITHOUT USING FINANCIAL CALCULATOR, AGAIN DO NOT USE FINANCIAL CALCULATOR: Today, you are retiring. You have a total of $411,016 in your retirement savings and have the funds invested such that you expect to earn an average of 7.10 percent, compounded monthly, on this money throughout your retirement years. You want to withdraw $2,500 at the beginning of every month, starting today. How long will it be until you run out of money?
You are retiring and you have $300000 save in your retirement account today. The account earns...
You are retiring and you have $300000 save in your retirement account today. The account earns interest at an annual rate of 12%. You are considering several alternatives for your payments. Determine the payment amount under each of the following circumstances: a) Your payments are received annually for the next 20 years and interest is compounded annually: b) Your payments are received semi- annually for the next 20 years and interest is compounded semi- annually: c) Your payments are received...
You have finished your time at Kelley and need to start thinking about retirement. You plan...
You have finished your time at Kelley and need to start thinking about retirement. You plan on working for 20 more years and then retire. Upon your retirement 20 years from today, you plan to have enough money to withdraw $10,000 per month, with the first payment coming exactly one month after your retirement day. You expect your retirement account to earn a return of 8% APR (stated rate), compounded monthly, on all funds in the retirement account. Assuming you...
You want to withdraw $100,000 every year for 35 years of retirement, and your first withdrawal...
You want to withdraw $100,000 every year for 35 years of retirement, and your first withdrawal will be one year after your last savings contribution. Assume you earn 4% APR compounded annually while you are retired. How much do you need to have saved to finance your retirement?
1. Today is your 25th birthday and you have a dream of retiring on your 65thbirthday....
1. Today is your 25th birthday and you have a dream of retiring on your 65thbirthday. You want to put aside however much is necessary on your 31st through 65th birthdays (35annual payments) to have enough to retire. You've estimated that you will live until you are 90 and you want the first withdrawal to occur on your 66thbirthday, with the last payment occurring on your 90thbirthday. You think that you will need $175,000 per year to spend during retirement....
1.Today is your 25thbirthday and you have a dream of retiring on your 65thbirthday. You want...
1.Today is your 25thbirthday and you have a dream of retiring on your 65thbirthday. You want to put aside however much is necessary on your 31stthrough 65thbirthdays (35annual payments) to have enough to retire. You've estimated that you will live until you are 90 and you want the first withdrawal to occur on your 66thbirthday, with the last payment occurring on your 90thbirthday. You think that you will need $175,000 per year to spend during retirement. You estimate constant interest...
You are 35 years old today and want to plan for retirement at age 65. You...
You are 35 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now to retirement. You expect to live to age 85 and want to withdraw a fixed amount each year during retirement that at age 65 will have the same purchasing power as $83,697 has today. You plan on withdrawing the money starting the day you retire. You have not saved any money for retirement....
You are 43 years old today and want to plan for retirement at age 65. You...
You are 43 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now to retirement. You expect to live to age 95 and want to withdraw a fixed amount each year during retirement that at age 65 will have the same purchasing power as $98,093 has today. You plan on withdrawing the money starting the day you retire. You have not saved any money for retirement....
You are 44 years old today and want to plan for retirement at age 65. You...
You are 44 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now to retirement. You expect to live to age 96 and want to withdraw a fixed amount each year during retirement that at age 65 will have the same purchasing power as $94,725 has today. You plan on withdrawing the money starting the day you retire. You have not saved any money for retirement....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT