David has been working in a local company as a finance manager for 2 years. He is currently earning $4,000 per month. Over the last 2 years, he has successfully saved $20,000 in his bank account. However, David is considering investing his savings to fund for his childrens education expenses. He feels that based on the increasing cost of education in Singapore, he will need $200,000 in 6 years to pay off his children overall education fees throughout their elementary school period. Assuming Davids salary stays constant throughout 6 years from now.

a. Based on the past performance of S&P 500 index, David expects an average return of 12% p.a. on his investment. If he decides to invest all his savings only, how much will he get in 6 years? Will David have $200,000 he needs in 6 years? If not, how much more money will he need?

b. Currently David contributes 20% of his salary to his CPF, spends $1,000 on the necessities per month, and saves $500 for emergency cash monthly. To fill up the gap for his children education fund needed in part (a), how much more he should invest his disposal income (after expenses and emergency fund) every month to accumulate the additional fund he needs over the next 6 years? Assumes he can earn an average return of 12% p.a. on his investment?

c. If David decides to invest (i) his savings $20,000 as a single investment and (ii) invest his $2,000 every month from his monthly disposal income. However, he wants to take a lower risk, which gives him an average rate of return of 4% p.a., will he have $200,000 he needs to establish his children education fund in 6 years? What expected return David should seek to grow all his investments (both lump sum savings and monthly savings) to $200,000 in 6 years? If he invests all his monies in an investment with 12% return p.a., how long will it take David to achieve his children education fund?

thank you