Your clients, both just turned 40, will retire when they turn 62. They have a current salary at an annual rate of ($10,000*salary scalar + $100,000), being paid equally at the end of each month. They expect a 3% raise in their salary every year until they retire. They deposit 12% of their monthly salary in their 401(k) account that generates an annual rate of return of 10%, compounded daily. In addition, their employer matches their contribution with 5% of their monthly salary to the same 401(k) account.
1. Determine the cash flows pattern of the monthly contributions to the 401(k) account within each year; and calculate and explain precisely your choice of interest rate, i.e., EAR/EPR/PER, used in your analysis. Also, calculate the yearend value of the 401(k) contributions for each year. Verify your work for Years 1 and 2 only with either the formula or the financial calculator approach!
2. Determine the pattern of the year-end values of the 401(k) contributions across years; and calculate and explain precisely your choice of interest rate, i.e., EAR/EPR/PER, used in your analysis. Also, calculate their 401(k) account balance upon their retirement. Verify your work with the formula approach!
At the end of each year, your clients will receive a bonus of 15% of their annual salary. Your clients commit to deposit part of their annual bonus, $14,000, in a 529 Plan account each year for financing their daughter’s, who just turned 12, college education. They will keep contributing to the 529 account until their daughter finishes college. Any remaining amount from the annual bonus check will be deposited in an IRA account. The 529 Plan account and the IRA account are expected to generate annual rates of return of 8% and 10%, respectively. And both accounts are compounded daily.
3. Determine the cash flows pattern of their contributions to the IRA account; and calculate and explain precisely your choice of interest rate, i.e., EAR/EPR/PER, used in your analysis. Also, calculate their IRA account balance upon their retirement.
4. Determine the cash flows pattern of their contributions to the 529 Plan account; and calculate and explain precisely your choice of interest rate, i.e., EAR/EPR/PER, used in your analysis. Also, calculate the 529 Plan account balances at the time their child starts college. Verify your work with either the formula or the financial calculator approach!
Currently, annual college expenses are running at $30,000, and are expected to grow at an annual rate of 5%. Their daughter will enter college when she turns 18, and complete the degree program in five years. Your clients expect their daughter to be responsible for 30% of her college expenses via the work-study program. All annual college expenses will be due at the beginning of each year. Your clients will tap into the 529 Plan account for paying their daughter’s college expenses.
5. Will there be sufficient funding in the 529 account for financing their daughter’s college expenses? If not, when will the funding run out of money? Support your answer numerically by showing the annual balances of the 529 Plan account through their daughter’s college years.
With a positive balance in the 529 account at their daughter’s college graduation, your clients will partially support her graduate study with money left in the 529 account. Their daughter plans to work for three years before returning to graduate school for an MBA. Currently, annual expenses for a highly competitive full-time 2-year MBA program are running at $55,000, and are expected to grow at an annual rate of 4%. Your clients will offer assistance to their daughter’s pursuit of graduate education through the 529 account at one-third of the annual expenses during her MBA study.
6. Will there be sufficient funding in the 529 account for subsidizing their daughter’s MBA program’s expenses? If not, when will the funding run out of money? Support your answer numerically numerically by showing the annual balances of the 529 Plan account through her MBA study.
If there is money left (i.e., positive balance) in the 529 account after their daughter’s MBA study, your client will transfer the balance to their IRA account.
7. How large will be the nest egg upon the retirement of your clients? In other words, calculate the combined balance of the 401(k) account and their IRA account when they retire.