Question

You currently have $20,000 in a bank account that pays you 5 percent interest annually. You plan to withdraw $800 (starting 1 year from now) every year for the next 10 years in the same account. How much are you going to have in that account at the end of 10 years?

Answer 1

Answer: $22,515.58

Explanation:

Based on the information given, the amount that'll be in the account at the end of the 10 years will be:

Present Value, PV = $20,000

Interest rate = 5% = 0.05

PMT = 800

nper = 10 years

Therefore, the future value will be solved in Excel by using the formula:

= FV(rate,nper,pmt,pv,type)

= FV(0.05,10,800,20000,0)

= $22,515.58

Therefore, the value in the account at the end of 10 years is $22,515.58