You are concerned about your retirement portfolio and want to start planning. Yo

Question

You are concerned about your retirement portfolio and want to start planning. You figure you will retire in exactly 42 years and then live another 30 years. During retirement, you want to be able to take out $7,000 per month for the first 15 years and then $5,000 per month for the last fifteen years of your life. Today, you make a monthly salary of $6,200. You are just getting started on paying off those student loans, so you plan to only invest 5% of your salary in the retirement account. You plan to do this for the next 20 years. How much will you have to invest in your retirement account for those remaining 22 years to have enough proceeds to reach your retirement goals? You may assume the applicable rate is 7% APR, compounded monthly.

Explanation / Answer

we solve this using pmt,pv and fv formuale in excel.

first find present value of 7000 per month for 15 years

PV(7%/12,15*4,-7000,,0)=$353,513.95

first find present value of 15000 per month for 15 years

PV(7%/12,15*4,-15000,,0)=$757,529.5

this has to be brought to present

PV(7%/12,15*12,,757529.5,0)=$265,898.23

total amoutn=353,513.95+265,898.23=619,412,2

now find the future value of 5% of salary for 20 years

FV(7%/12,20*12,-310,,0)=$161,487.26

let amount be "x" for next 22 years

FV(7%/12,22*12,-x,,0) +161,487.26=619,412,2

use solver to solve "x' and it is 245.5

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.