Question 1174312
first you want to find the amount that you need to deposit in your account at the beginning of your retirement so that you can withdraw 20,000 at the beginning of each year for the next 30 years.


next you want to find the amount to deposit in your account at the end of each year for 25 years so that you will have that the amount that you need to deposit in your account.


use the financial calculator at <a href = "https://arachnoid.com/finance/index.html" target = "_blank">https://arachnoid.com/finance/index.html</a> to solve this.


your inputs for finding the amount you need to deposit at the beginning of the 30 year period are:


fv = 0
np = 30
pmt = 20,000
ir = 5
payment at beginning of time period.


click on pv and you get a present value of 322,821.47.  that's how much you need to have in the account at the beginning of the 30 year withdrawal period.


here's a display of the results.


<img src = "http://theo.x10hosting.com/2021/020401.jpg" >


your inputs for finding the amount you need to invest are:


pv = 0
fv = 322,821.47
np = 25
ir = 5
payment at end of time period.


click on pmt and you get a payment of 6763.9 to be deposited at the end of each year for 25 years.


here's a display of the results.


<img src = "http://theo.x10hosting.com/2021/020402.jpg" >


i used excel to show you the yearly cash flow results.


here's a display of the cash flows from excel.


<img src = "http://theo.x10hosting.com/2021/020403.jpg" >
<img src = "http://theo.x10hosting.com/2021/020404.jpg" >



i'll be available to answer any questions you might have regarding this.


theo