Jack and Jill Smith live in the Midwestern suburb of Pleasantville. They have two children, ages 5 and 7. Jill is 39 years old and Jack is 40 . Jack works as a marketing manager for a toy manufacturing company. Jack has been with this company for 10 years and his career is progressing well. He makes $72,000 per year (before taxes). Jill worked part-time at a department store for many years but quit her job after their second child was born. Assume that their total income taxes (including Federal, State and FICA / Medicare) are \$12,000 per year. Jack's company offers a 401(K) plan (they do not however match any of his contributions). Jack contributes $12,000 per year to the 401(K) and he plans to continue contributing this amc)int every year until he retires. He has built up a balance of $40,000 in the 401k account so far. After ex Ading his 401(k) contribution Jack's take home pay is $4000 per month. They have a mortgage of $200,000 (monthly payment is $1000 ) on their home. Their home is worth $220,000. They own two cars - an SUV (worth about $12000 ) and a sedan (worth about $5000 ). They have a $10,000 car loan on the SUN, on which the monthly payment is $500. Their Property taxes on the home are $400 per month. Home insurance costs $400 per year and Auto insurance is $1200 per year. The health insurance provided by Jack's employer costs $100 per month. They spend $1100 per month on food and household items, $400 on Gas (plus maintenance for the cars), $200 per month on personal care (e \& haircuts), clothing (and other personal needs) and $200 on entertainment (e.g. movies, eating out). They also spend $500 per month on utilities (including gas heating, electric/AC, phone, water etc). Two years ago, Jack got interested in investing, opened an internet brokerage account, and bought $10,000 of a mutual fund. Jack carries a Term Ufe insurance policy with a Death benefit of $100,000 that is provided by his employer. 1il does not carry Ufe insurance. Jack and Jill have often talked about preparing a will but have not gotten around to doing so. They have a Savings and Checking account at the bank with a balance of $6,000. In answering the questions, assume that the description above covers their ENTIRE financialfituation. If something that you think should be induded is missing, It is because the Smiths have not set it up or considered it. You should include this in your recommendations. Question 3 - Chlidren's education ( 6 pts) Assume that their children will go to a public school, but likely in another state. At such fout of state) public schools today, tuition, fees and living expenses add up to about $20,000 per year. Tultion is expected to grow at 6% year. Given these facts, what will be the total A year tuition expense . Tultion upon entering college x 4) for each child?. Show your calculations (please use the Time value of Money tables in the text] and summarize in the table below: Show your calculations dearty TPlease uie the tables in the Time value of Moner Appendix from the textbook for your calculations: Show your calculations dearly. Do not use fritel or websites suth as Maneychimp.oom. if you are nat: sure about the approach to use, make a posting to the Course topics board or send me an email and I can steer you in the right directionj a. Assume that the rate of inflation in the future will be 4. lack would like to retire at age 65 iin 25 years]. For this calculation, assume that their total monthly expenses in today's dollars are $5000 lienare the detailed expenses isted at the beginning of the casel, how much will their expenses grow to in 25 years? Show your calculations dearty b. Jack's total retirement smings today are $40,000 fassume he is saving only in his 401k for retirement. Based on the $12,000 he plans to add to his 401k each year, how moch will it srow to in 25 years? Assume that he will obtain a rate of retum of 7 per year, show your calculations dearhy c. A Financial Flanner advised lack that he would need $2 Million in his 401k to be assured of a comfortable retirement. Hew much would iack need to invest fin total, includin the $12,000 per year that he plans upon putting in) in his 401k each year, for the next 25 years, to grow the account from its current valve of $40,000 to $2M at age 657 Assume that he will obtain a rate of return if 7% per year. Show your calculations clearfy Jack and Jill Smith live in the Midwestern suburb of Pleasantville. They have two children, ages 5 and 7. Jill is 39 years old and Jack is 40 . Jack works as a marketing manager for a toy manufacturing company. Jack has been with this company for 10 years and his career is progressing well. He makes $72,000 per year (before taxes). Jill worked part-time at a department store for many years but quit her job after their second child was born. Assume that their total income taxes (including Federal, State and FiCA / Medicare) are $12,000 per year. Jack's company offers a 401(K) plan (they do not however match any of his contributions). Jack contributes $12,000 per year to the 401(K) and he plans to continue contributing this amount every year until he retires. He has built up a balance of $40,000 in the 401k account so far. After excluding his 401(k) contribution Jack's take home pay is $4000 per month. They have a mortgage of $200,000 (monthly payment is $1000 ) on their home. Their home is worth $220,000. They own two cars - an SUV (worth about $12000 ) and a sedan (worth about $5000 ). They have a $10,000 car loan on the SUV, on which the monthly payment is $500. Their Property taxes on the home are $400 per month. Home insurance costs $400 per year and Auto insurance is $1200 per year. The health insurance provided by Jack's employer costs $100 per month. They spend $1100 per month on food and household items, $400 on Gas (plus maintenance for the cars), $200 per month on personal care (e.g. haircuts), clothing (and other personal needs) and $200 on entertainment (e.g. movies, eating out). They also spend $500 per month on utilities (including gas heating, electric/AC, phone, water etc). Two years ago, Jack got interested in investing, opened an internet brokerage account, and bought $10,000 of a mutual fund. Jack carries a Term Life insurance policy with a Death benefit of $100,000 that is provided by his employer. Jill does not carry life insurance. Jack and Jill have often talked about preparing a will but have not gotten around to doing so. They have a Savings and Checking account at the bank with a balance of $6,000. In answering the questions, assume that the description above covers their ENTIRE financial/situation. If something that you think should be included is missing, it is because the Smiths have not set it up or considered it. You should include this in your recommendations. Assume that their children will go to a public school, but likely in another state. At such (out of state) public schools today, tuition, fees and living expenses add up to about $20,000 per year. Tuition is expected to grow at 6% a year. Given these facts, what will be the total 4 year tuition expense (= Tuition upon entering college 4 ) for each child?. Show your calculations (please use the Time value of Money tables in the text) and summarize in the table below: a. Assume that the rate of inflation in the future will be 4%. Jack would like to retire at age 65 (in 25 years). For this calculation, assume that their total monthly expenses in today's dollars are $5000 (ignore the detailed expenses listed at the beginning of the case), how much will their expenses grow to in 25 years? Show your calculations clearly b. Jack's total retirement savings today are $40,000 (assume he is saving only in his 401k for retirement). Based on the $12,000 he plans to add to his 401k each year, how much will it grow to in 25 years? Assume that he will obtain a rate of return of 7% per year. Show your calculations clearly c. A Financial Planner advised Jack that he would need $2 Million in his 401k to be assured of a comfortable retirement. How much would Jack need to invest (in total, including the $12,000 per year that he plans upon putting in) in his 401k each year, for the next 25 years, to grow the account from its current value of $40,000 to $2M at age 65 ? Assume that he will obtain a rate of return of 7% per year. Show your calculations clearly Jack and Jill Smith live in the Midwestern suburb of Pleasantville. They have two children, ages 5 and 7. Jill is 39 years old and Jack is 40 . Jack works as a marketing manager for a toy manufacturing company. Jack has been with this company for 10 years and his career is progressing well. He makes $72,000 per year (before taxes). Jill worked part-time at a department store for many years but quit her job after their second child was born. Assume that their total income taxes (including Federal, State and FICA / Medicare) are \$12,000 per year. Jack's company offers a 401(K) plan (they do not however match any of his contributions). Jack contributes $12,000 per year to the 401(K) and he plans to continue contributing this amc)int every year until he retires. He has built up a balance of $40,000 in the 401k account so far. After ex Ading his 401(k) contribution Jack's take home pay is $4000 per month. They have a mortgage of $200,000 (monthly payment is $1000 ) on their home. Their home is worth $220,000. They own two cars - an SUV (worth about $12000 ) and a sedan (worth about $5000 ). They have a $10,000 car loan on the SUN, on which the monthly payment is $500. Their Property taxes on the home are $400 per month. Home insurance costs $400 per year and Auto insurance is $1200 per year. The health insurance provided by Jack's employer costs $100 per month. They spend $1100 per month on food and household items, $400 on Gas (plus maintenance for the cars), $200 per month on personal care (e \& haircuts), clothing (and other personal needs) and $200 on entertainment (e.g. movies, eating out). They also spend $500 per month on utilities (including gas heating, electric/AC, phone, water etc). Two years ago, Jack got interested in investing, opened an internet brokerage account, and bought $10,000 of a mutual fund. Jack carries a Term Ufe insurance policy with a Death benefit of $100,000 that is provided by his employer. 1il does not carry Ufe insurance. Jack and Jill have often talked about preparing a will but have not gotten around to doing so. They have a Savings and Checking account at the bank with a balance of $6,000. In answering the questions, assume that the description above covers their ENTIRE financialfituation. If something that you think should be induded is missing, It is because the Smiths have not set it up or considered it. You should include this in your recommendations. Question 3 - Chlidren's education ( 6 pts) Assume that their children will go to a public school, but likely in another state. At such fout of state) public schools today, tuition, fees and living expenses add up to about $20,000 per year. Tultion is expected to grow at 6% year. Given these facts, what will be the total A year tuition expense . Tultion upon entering college x 4) for each child?. Show your calculations (please use the Time value of Money tables in the text] and summarize in the table below: Show your calculations dearty TPlease uie the tables in the Time value of Moner Appendix from the textbook for your calculations: Show your calculations dearly. Do not use fritel or websites suth as Maneychimp.oom. if you are nat: sure about the approach to use, make a posting to the Course topics board or send me an email and I can steer you in the right directionj a. Assume that the rate of inflation in the future will be 4. lack would like to retire at age 65 iin 25 years]. For this calculation, assume that their total monthly expenses in today's dollars are $5000 lienare the detailed expenses isted at the beginning of the casel, how much will their expenses grow to in 25 years? Show your calculations dearty b. Jack's total retirement smings today are $40,000 fassume he is saving only in his 401k for retirement. Based on the $12,000 he plans to add to his 401k each year, how moch will it srow to in 25 years? Assume that he will obtain a rate of retum of 7 per year, show your calculations dearhy c. A Financial Flanner advised lack that he would need $2 Million in his 401k to be assured of a comfortable retirement. Hew much would iack need to invest fin total, includin the $12,000 per year that he plans upon putting in) in his 401k each year, for the next 25 years, to grow the account from its current valve of $40,000 to $2M at age 657 Assume that he will obtain a rate of return if 7% per year. Show your calculations clearfy Jack and Jill Smith live in the Midwestern suburb of Pleasantville. They have two children, ages 5 and 7. Jill is 39 years old and Jack is 40 . Jack works as a marketing manager for a toy manufacturing company. Jack has been with this company for 10 years and his career is progressing well. He makes $72,000 per year (before taxes). Jill worked part-time at a department store for many years but quit her job after their second child was born. Assume that their total income taxes (including Federal, State and FiCA / Medicare) are $12,000 per year. Jack's company offers a 401(K) plan (they do not however match any of his contributions). Jack contributes $12,000 per year to the 401(K) and he plans to continue contributing this amount every year until he retires. He has built up a balance of $40,000 in the 401k account so far. After excluding his 401(k) contribution Jack's take home pay is $4000 per month. They have a mortgage of $200,000 (monthly payment is $1000 ) on their home. Their home is worth $220,000. They own two cars - an SUV (worth about $12000 ) and a sedan (worth about $5000 ). They have a $10,000 car loan on the SUV, on which the monthly payment is $500. Their Property taxes on the home are $400 per month. Home insurance costs $400 per year and Auto insurance is $1200 per year. The health insurance provided by Jack's employer costs $100 per month. They spend $1100 per month on food and household items, $400 on Gas (plus maintenance for the cars), $200 per month on personal care (e.g. haircuts), clothing (and other personal needs) and $200 on entertainment (e.g. movies, eating out). They also spend $500 per month on utilities (including gas heating, electric/AC, phone, water etc). Two years ago, Jack got interested in investing, opened an internet brokerage account, and bought $10,000 of a mutual fund. Jack carries a Term Life insurance policy with a Death benefit of $100,000 that is provided by his employer. Jill does not carry life insurance. Jack and Jill have often talked about preparing a will but have not gotten around to doing so. They have a Savings and Checking account at the bank with a balance of $6,000. In answering the questions, assume that the description above covers their ENTIRE financial/situation. If something that you think should be included is missing, it is because the Smiths have not set it up or considered it. You should include this in your recommendations. Assume that their children will go to a public school, but likely in another state. At such (out of state) public schools today, tuition, fees and living expenses add up to about $20,000 per year. Tuition is expected to grow at 6% a year. Given these facts, what will be the total 4 year tuition expense (= Tuition upon entering college 4 ) for each child?. Show your calculations (please use the Time value of Money tables in the text) and summarize in the table below: a. Assume that the rate of inflation in the future will be 4%. Jack would like to retire at age 65 (in 25 years). For this calculation, assume that their total monthly expenses in today's dollars are $5000 (ignore the detailed expenses listed at the beginning of the case), how much will their expenses grow to in 25 years? Show your calculations clearly b. Jack's total retirement savings today are $40,000 (assume he is saving only in his 401k for retirement). Based on the $12,000 he plans to add to his 401k each year, how much will it grow to in 25 years? Assume that he will obtain a rate of return of 7% per year. Show your calculations clearly c. A Financial Planner advised Jack that he would need $2 Million in his 401k to be assured of a comfortable retirement. How much would Jack need to invest (in total, including the $12,000 per year that he plans upon putting in) in his 401k each year, for the next 25 years, to grow the account from its current value of $40,000 to $2M at age 65 ? Assume that he will obtain a rate of return of 7% per year. Show your calculations clearly