In: Finance
Sally Prescott plans on retiring in 15 years, that is, she will work for another 15 full years. When she retires she plans on spending 3 years in Bulgaria volunteering for the Peace Corps. After which she will spend her time in Boca Raton, Florida at a townhouse she purchased 5 years ago for $250,000. She currently has $100,000 in savings. She estimates that she will need $20,000 a year for living expenses in Bulgaria and then $35,000 a year for approximately 20 years when she retires to Florida. If she earns 4% compounded monthly in her savings account, how much must she deposit each year to meet her financial goals? She will withdraw her annual cash flows at the beginning of each year, that is, her first $20,000 withdrawal will occur at the beginning of year 16, before she travels to Bulgaria. Her annual deposits will begin at the end of this year and continue until she leaves for Bulgaria.
No excel sheets
The first step is to find the size of the retirement fund.
The savings account earns 4% compounded monthly, The effective annual rate is found as follows
Size of retirement fund = $ 57684.1 + $ 436474.5674 = $ 494158.66
------------------------------------------------------------------------
To reach the financial goal, the deposit to be made each year is found as follows
Solving for A in the above equation
$ 494,158.66 = $ 181,921.2 + A 20.13
A 20.13 = $ 494,158.66 - $ 181,921.2
A 20.13 = $ 312,237.46
Annual deposit to be made = $ 15,511.1 $ 15,511