Question: Please include all the details and how to solve A N 35 DE F G H I J K L M Retirement Worksheet Annual Retirement
Please include all the details and how to solve

A N 35 DE F G H I J K L M Retirement Worksheet Annual Retirement Income Need 125,000 Years until Retirement 30 Years in Retirement Rate of Return before Retirement 8.00% Rate of Return during Retirement Worth 3 points Savings Required at Retirement Use PV function Worth 3 points Investment Required Today Use PV function and assume that you invest a lump sum today and no other payment before the retirement Worth 4 points Annual Investment Required Use PMT function and assume that you do NOT make a lump sum investment today. Instead you invest a fixed amount at the end of each year before retirement. 6.00% (1) (3) Key: (1) annual retirement incomen 125,000 is a cash outflow (2): Use (1) as FV and set it as a negative number. Moreover PMT=0. (3): Use (1) as FV and set it as a negative number. Moreover PV=0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
