Ginny and Larry Stewart are 38 years old and have one son, age 9. Ginny is the primary earner, making $140,000 per year. Larry does not currently work. The Stewarts have decided to use the needs analysis method to calculate the value of a life insurance policy that would provide for Larry and their son in the event of Ginny's death Ginny and Larry estimate that while their son is still living at home, monthly living expenses for Larry and their child will be about $4,000 (in current dollars). After their son leaves for college in 9 years, Larry will need a monthly income of $3,300 until he retires at age 65. The Stewarts estimate Larry's living expenses after 65 will only be $2,900 a month. The life expectancy of a man Larry's age is 82 years, so the Stewart family calculates that Larry will spend about 17 years in retirement. Using this information, complete the first portion of the needs analysis worksheet to estimate their total living expenses: Life Insurance Needs Analysis Worksheet Larry and Ginny Stewart July 31, 2015 Name of Insured Date Step 1: Financial Resources Needed after Death 1. Annual Living Expenses and Other Needs Period 1 Period 2 Period 3 Monthly living expenses $ $4,000 $ $ a. b. Net yearly income needed (la x 12) $ $ Number of years in time period 9 18 17 . d. $ Total living needs per time period (1b x $ $ 1c) Total Living Expenses (add Line 1d for each period to check your total): $1,736,400 In addition to these monthly expenses, other future outlays must be accounted for. Before they had a child, Larry worked as a financial consultant, but his knowledge and skills are now somewhat outdated. Therefore, they include $40,000 for Larry to go back to school. Additionally, Ginny and Larry want to create a college fund of $60,000 to fund their child's college education. They estimate that final expenses (funeral costs and estate taxes) will amount to $18,000. Finally, they have taken out a loan for home improvements of $150,000 and a credit card balance of $1,800. They own their home but still have an outstanding mortgage of $400,000. Using this information, complete the next portion of Step 1 to determine the total financial resources needed: 2. Special Needs Spouse's education fund $ a. b. Child's college fund $ Other needs $0 C. 3. Final Expenses (funeral costs and estate taxes) $ 4. Debt Liquidation House mortgage $ . Other loans Total debt (4a + 4b) $ C. 5. Other Financial Needs $0 Total Financial Resources Needed (add right-hand column plus the Total Living Expenses you $2,406,200 calculated previously to check your math): The second half of the needs analysis worksheet is not shown on this page. To complete the worksheet and determine the value of the life insurance policy the Stewarts should purchase, they need to factor in additional information True or False: Ginny's future salary (if she does not die) should be accounted for in the remaining portion of the form O False O True Ginny and Larry Stewart are 38 years old and have one son, age 9. Ginny is the primary earner, making $140,000 per year. Larry does not currently work. The Stewarts have decided to use the needs analysis method to calculate the value of a life insurance policy that would provide for Larry and their son in the event of Ginny's death Ginny and Larry estimate that while their son is still living at home, monthly living expenses for Larry and their child will be about $4,000 (in current dollars). After their son leaves for college in 9 years, Larry will need a monthly income of $3,300 until he retires at age 65. The Stewarts estimate Larry's living expenses after 65 will only be $2,900 a month. The life expectancy of a man Larry's age is 82 years, so the Stewart family calculates that Larry will spend about 17 years in retirement. Using this information, complete the first portion of the needs analysis worksheet to estimate their total living expenses: Life Insurance Needs Analysis Worksheet Larry and Ginny Stewart July 31, 2015 Name of Insured Date Step 1: Financial Resources Needed after Death 1. Annual Living Expenses and Other Needs Period 1 Period 2 Period 3 Monthly living expenses $ $4,000 $ $ a. b. Net yearly income needed (la x 12) $ $ Number of years in time period 9 18 17 . d. $ Total living needs per time period (1b x $ $ 1c) Total Living Expenses (add Line 1d for each period to check your total): $1,736,400 In addition to these monthly expenses, other future outlays must be accounted for. Before they had a child, Larry worked as a financial consultant, but his knowledge and skills are now somewhat outdated. Therefore, they include $40,000 for Larry to go back to school. Additionally, Ginny and Larry want to create a college fund of $60,000 to fund their child's college education. They estimate that final expenses (funeral costs and estate taxes) will amount to $18,000. Finally, they have taken out a loan for home improvements of $150,000 and a credit card balance of $1,800. They own their home but still have an outstanding mortgage of $400,000. Using this information, complete the next portion of Step 1 to determine the total financial resources needed: 2. Special Needs Spouse's education fund $ a. b. Child's college fund $ Other needs $0 C. 3. Final Expenses (funeral costs and estate taxes) $ 4. Debt Liquidation House mortgage $ . Other loans Total debt (4a + 4b) $ C. 5. Other Financial Needs $0 Total Financial Resources Needed (add right-hand column plus the Total Living Expenses you $2,406,200 calculated previously to check your math): The second half of the needs analysis worksheet is not shown on this page. To complete the worksheet and determine the value of the life insurance policy the Stewarts should purchase, they need to factor in additional information True or False: Ginny's future salary (if she does not die) should be accounted for in the remaining portion of the form O False O True