Question

In: Finance

Income Needed During Retirement $90,000 Number of Years in Retirement 30 Number of Year Before Retirement...

Income Needed During Retirement $90,000 Number of Years in Retirement 30 Number of Year Before Retirement 20 Rate of Return During Retirement 4.50% Rate of Return Before Retirement 7.50% Inflation Before and During Retirement 3% A. How much should your client save per year in order to meet their required funds for retirement? Calculate for both an annuity and annuity due.

Solutions

Expert Solution

CALCULATION FOR ANNUITY:
PAYMENT AT END   OF YEAR
Inflation Rate =3%
Return rate during retirement =4.5%
Rate Inflation adjusted return during retirement 1.46% (1.045/1.03)-1 1.014563
Nper Number of years in retirement 30
Pmt Annual retirement income $90,000
PV Amount required at the time of retirement $2,174,871 (Using Excel PV function with Rate =1.46%,Nper=30,Pmt=-90000)
Rate Return rate before retirement 7.50%
Nper Number of years of savings 20
FV Amount required at retirement $2,174,871
PMT Annual Saving required before retirement $50,222.54 (Using Excel PMT function with Rate =7.5%,Nper=20,FV=-2174871)
CALCULATION FOR ANNUITY DUE
PAYMENT AT BEGINNING OF YEAR
Inflation Rate =3%
Return rate during retirement =4.5%
Rate Inflation adjusted return during retirement 1.46% (1.045/1.03)-1 1.014563
Nper Number of years in retirement 30
Pmt Annual retirement income $90,000
Type Beginning of year payments                           1
PV Amount required at the time of retirement $2,206,544 (Using Excel PV function with Rate =1.46%,Nper=30,Pmt=-90000, Type=1)
Rate Return rate before retirement 7.50%
Nper Number of years of savings 20
FV Amount required at retirement $2,206,544
PMT Annual Saving required before retirement $50,953.94 (Using Excel PMT function with Rate =7.5%,Nper=20,FV=-2206544)

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

You decide to replace your income of $70,000 a year in retirement for 30 years. How...
You decide to replace your income of $70,000 a year in retirement for 30 years. How much do you need in your retirement account the day you retire to make that happen, assuming a real interest rate of 3%?
12. You plan to save for your retirement during the next 30 years. To do this,...
12. You plan to save for your retirement during the next 30 years. To do this, he will invest 700 dollars a month in a stock account and 300 dollars in a bond account. The performance of the stock account is expected to be 11% and the bond account pays 6%. When you retire, you will combine your money in an account with a 9% return. How much can you withdraw each month from your account if you have a...
Daniel's adjusted gross income is $90,000. During the year he incurred $14,000 of medical expenses and...
Daniel's adjusted gross income is $90,000. During the year he incurred $14,000 of medical expenses and was reimbursed for $3,000 of these expenses. What is his allowable medical expense deduction if he is age 45, single, and itemizes? If this Daniel's only itemized deduction, should he itemize or claim the standard deduction? (2018)
Small Company reported 2017 net income of $300,000 and paid dividends of $90,000 during the year....
Small Company reported 2017 net income of $300,000 and paid dividends of $90,000 during the year. Parker Inc. acquired 20% of Small's outstanding voting stock on January 1, 2017 for $630,000. At December 31, 2017, Parker determined the fair value of the shares in small to be $615,000. Parker reported operating income of $540,000. instructions: Compute Parker's net income for 2017 assuming it uses the following methods to account for its investment. a. equity method in accounting for its investment...
Comprehensive Given: current income $50,000 income needed in retirement $45,000 current age 35 age at retirement...
Comprehensive Given: current income $50,000 income needed in retirement $45,000 current age 35 age at retirement 70 age at death 90 investment return prior to retirement 7% investment return during retirement 4% a) Calculate the nest-egg needed at retirement. Assume the annual income amount will be taken at the beginning of each year during retirement. b) How much must this individual save each year in order to meet the retirement-savings goal? Assume the individual will save an equal amount annually.
You are planning to save for retirement over the next 30 years. To save for retirement,...
You are planning to save for retirement over the next 30 years. To save for retirement, you will invest $1,850 per month in a stock account in real dollars and $610 per month in a bond account in real dollars. The effective annual return of the stock account is expected to be 10 percent, and the bond account will earn 6 percent. When you retire, you will combine your money into an account with an effective return of 8 percent....
You are planning to save for retirement over the next 30 years. To save for retirement,...
You are planning to save for retirement over the next 30 years. To save for retirement, you will invest $1,450 a month in a stock account in real dollars and $570 a month in a bond account in real dollars. The effective annual return of the stock account is expected to be 10 percent and the bond account will earn 6 percent. When you retire, you will combine your money into an account with an effective annual return of 7...
You are planning to save for retirement over the next 30 years. To save for retirement,...
You are planning to save for retirement over the next 30 years. To save for retirement, you will invest $1,450 per month in a stock account in real dollars and $570 per month in a bond account in real dollars. The effective annual return of the stock account is expected to be 10 percent, and the bond account will earn 6 percent. When you retire, you will combine your money into an account with an effective return of 7 percent....
You are planning to save for retirement over the next 30 years. To save for retirement,...
You are planning to save for retirement over the next 30 years. To save for retirement, you will invest $1,300 per month in a stock account in real dollars and $555 per month in a bond account in real dollars. The effective annual return of the stock account is expected to be 12 percent, and the bond account will earn 8 percent. When you retire, you will combine your money into an account with an effective return of 9 percent....
you are planning to save for retirement over the next 30 years. To save for retirement,...
you are planning to save for retirement over the next 30 years. To save for retirement, you will invest $700 per month in a stock account in real dollars and $325 per month in a bond account in real dollars. The effective annual return of the stock account is expected to be 12 percent, and the bond account will have an annual return of 7 percent. When you retire, you will combine your money into an account with an effective...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT