• 100% Satisfaction Guarantee
Lev, Tax Preparer
Category: Finance
Satisfied Customers: 27726
Experience:  Personal Investment, Tax Preparation
870116
Lev is online now

# My father is 50 years old, and he plans to retire in 10 ...

### Customer Question

My father is 50 years old, and he plans to retire in 10 years. He expects to live for 25 years after he retires (until he's 85). He wants a fixed retirement income that has the same purchasing power at the time he retires as \$40,000 has today. His retirement income will begin the day he retires, 10 years from today, and he will then get 24 additional annual payments. Inflation is expected to be 5 percent per year from today forward; he currently has 100,000 saved up. He expects to earn a return on his savings of 8 percent per year, annual compounding. To the nearest dollar, how much must he save during each of the next ten years (with deposits made at the end of each year) to meet his retirement goal?
Submitted: 8 years ago.
Category: Finance
Expert:  Lev replied 8 years ago.

Dear XXXXX,

Thank you for very interesting question!

here are some results

The first part is accumulated phase - you only add to saving and spend from other sources. The second phase - there will nt be any additional to saving - only interest and spending.

Spending is inflation adjusted (based on 5% inflation).

Additional also inflation adjusted - you would need to save \$49,925 annualy in this year and it will be \$77,450 in ten years from now.

You will have ~\$1,100,000 at the time of retirement. The maximum saving will be \$1,222,519 in 19 years and will start to go down because of spending increase (inflation adjusted). So far by the time your father plan to die his estate will be \$54.

Lev, Tax Preparer
Category: Finance
Satisfied Customers: 27726
Experience: Personal Investment, Tax Preparation
Customer: replied 8 years ago.

When I put the figures in Excel, I got results similar to yours.

However, I am a little confused because the book I'm using lists the answer as: PMT= \$36,949.61.

Any suggestions?
Expert:  Lev replied 8 years ago.

Please find HERE the excel file I created - so you may compare with yours.

PMT(rate,nper,pv,fv,type) - is the financial function that used also in Excel - it calculates the payment for a loan based on constant payments and a constant interest rate.

• Rate is the interest rate for the loan.
• Nper is the total number of payments for the loan.
• Pv is the present value, or the total amount that a series of future payments is worth now; also known as the principal.
• Fv is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
• Type is the number 0 (zero) or 1 and indicates when payments are due.

However, in your situation - payments are not constant - but inflation adjusted. Is it possible that spending will not be inflation adjusted after he retired?

Customer: replied 8 years ago.
I suppose that it's possible spending will not be inflation-adjusted after retirement, but, in that case, would the payments be lowered this significantly (from 49,000 to 36,000)? Thank you again for your help.
Expert:  Lev replied 8 years ago.

providing that spending will not be inflation-adjusted after retirement - and payments will not be inflation-adjusted - that amount will be \$33,109.

Customer: replied 8 years ago.
Expert:  Lev replied 8 years ago.
Appreciate you nice words. I wish you the best.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

### What Customers are Saying:

• I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W Matteson, IL
< Previous | Next >
• I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W Matteson, IL
• I WON!!! I just wanted you to know that your original answer gave me the courage and confidence to go into yesterday's audit ready to fight. Bonnie Chesnee, SC
• Great service. Answered my complex tax question in detail and provided a lot of additional useful information for my specific situation. John Minneapolis, MN
• Excellent information, very quick reply. The experts really take the time to address your questions, it is well worth the fee, for the peace of mind they can provide you with. Orville Hesperia, California
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA

### Meet The Experts:

#### Satisfied Customers:

2489
Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years
< Last | Next >

#### Satisfied Customers:

2489
Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years

### Megan C

#### Satisfied Customers:

2210
Licensed CPA, CFE, CMA, CGMA who teaches accounting courses at Master's Level

### Manal Elkhoshkhany

#### Satisfied Customers:

1905
More than 5000 online tutoring sessions.

### JKCPA

#### Satisfied Customers:

843
Bachelors degree and CPA with Accounting experience.

### Eric

#### Satisfied Customers:

559
Loan servicing, counseling and real estate expert. Foreclosure Expert and Financial Planner.

### R. Klein, EA

#### Satisfied Customers:

480
TurboTax Expert. QuickBooks Certified Pro Advisor