Investment Plan for Ilkay's Child Education lkay Yaam at age of 32 has been working for a worldwide company as an engineer with current net salary 10,000 TL. She decided to make an investment for her child's education for a 10-year time frame. In the last 8 years, she has saved a small fortune as an amount of 50,000 TL. She is little confused about type of the investment that she will make. There are two ways to invest her savings for her child's education. First way is to deposit money for Individual Pension System (IPS). IPS is a system that enables people to carn an income that can maintain their living standards in retirement periods by directing the savings they make during their active working lives to long-term investment. However, although IPS is designed for retirement (more than 10 years), lkay is planning to use the system as 10-year time frame as a saving tool. Second way to save money for her child's education is to create deposit account in a bank for 10-year time frame. Hence, she asked a friend (who took Engineering Economy) for a help that her financial plans by developing the monthly financial plan (cash lows) with taking into account the time value of the money. Bank Deposit: Saving amount of 50,000TL will be deposited in a bank for 10-year period. Estimated MARR values for each year compounded monthly, are given in below table. Note that, the income tax in this type of deposit accounts is 15% for the returns (see below *). |1 2 345 6 7 8 9 10 Estimated MARR (%) 10 11 9 9 85 10 9.5 115 9 8.5 Year IPS System: Her current salary is 10,000 TL. She will save 1,000TL for each month for the first year. For the following years, she will get salary inereases. Her net savings will also be increased as salary increases in same percentages. The 10 year estimated salary increase percentages are given as in below table. 2 3 4 5 6|1 89 10 Increase (%) 3.5 4 3.8 4.1 2.9 34 4.3 2.8 3.7 Year In IPS, she is able to deposit any additional amount at any time. This amount will be withdrawn from bank deposit. Remaining amount will still be kept in the bank deposit. However, she is planning to deposit these extra amount payments anytime between 6" and 10" years. She wants to see from her friend to present at least four different alternative plans that show in which month additional deposit should be made to get maximum accumulated amount at the end of year 10. If she chooses IPS, the govemment provides %25 support in entire accumulated amount at the end. Note that, the annual total government support could not be more than 7,500 TL. But, lkay will be able to get %60 percent of the govermment support if she quits the system at the end of year 10. Estimated annual returns on the pension deposits compounded monthly are given below to calculate the accumulated total amount in IPS. 2 3 45 6 7 89 10 Year Rate of Return (%) 11 10 8.5 9 10 9.8 10.2 12.3 12 11.8 Also, there will be an income tax of 10% for IPS returns to be caleulated at the end of year 10 (see below **). In the lights of information supplied above, she wonders that: How reasonable are her goals? What will be the accumulated amount for the investment plan at the end of 10-year period? Note that you are supposed to perform analyzing your alternatives with at least using present worth and rate of return methods on Mierosoft Excel. Notes: Income tax for bank deposits is to be deductible at the end of each compounding period: After Tax Effective Effective Tax Rate ( 1 Interest Rate (%15) Interest Rate Income tax in IPS is to be deductible at the end of 10 years period: Total Amount of Total Amount Net Total Amount of Tax Rate - ( Money Accumulated - of Deposits for ) Income Money Accumulated in IPS (%10) in IPS After Tax IPS