Please show you calculation

Question 1: (Needs Approach) The correct answers are based on the set of facts and tables provided below. All the data you need to perform the necessary calculations are contained in the tables following the three paragraphs below. Show all your calculations so you can receive partial credit even if you make mistake. The appearance of your homework is a factor in your grade; therefore, it is suggested it be presented in a professional manner.e. pretend it is like something you would prepare for your boss). Pat and Mandy are married and have a son, Steve, . 8. Mandy, age 29, earns $40,000 annually from her job. Pat, age 31, carns $50,000 annually from his job. Assume that Pat will die before Mandy. The family wants to ensure that they have adequate life insurance on Patto cover their cash and income needs if Pat dies. Hence, they want to determine if they should purchase additional life insurance on Patto cover these needs using Needs Approach. (you may find some hints from your textbook, page 207"209) The tables below provide figures on their: 1) cash needs; 2) present insurance and financial assets; 3) income needs; and 4) income that the family will receive if no additional life insurance is purchased. Use the values in these tables to determine how much, if any, additional life Insurance the family should purchase on Pat to cover their needs. In your answer, calculate and show the components of any additional life insurance needed in terms of cash needs and income needs and the total amount of additional life insurance needed. This exercise assumes that 1) Pat dies immediately: 2) Mandy continues to work if Pat dies. However, her earnings are not enough to meet their needs. So, the numbers provided in the table are net off her earnings, which means all the items provided below need to be included in your calculation, 3) Mandy plans to retire at age 65; and 4) the life insurance proceeds are invested at an interest rate equal to the rate of inflation Iso, you do not have to worry about time-value of money issues). Cash Needs: Estate Clearance $15,000 Mortgage Redemption Emergency fund Educational Fund $150,000 $20,000 $100,000 Present Insurance and Financial Assets: Whole Life Insurance $150,000 Investments/Savings $10,000 Income Needs: Readjustment Period Dependency Period Blackout Period $5,000 monthly for 2 years $5,000 monthly for 8 years $3,500 monthly for 28 years Mandy's Retirement Period $3,500 monthly for 25 years Expected Income from Sources Other Readjustment Period Dependency Period Blackout Period $3,500 monthly for 2 years $3,500 monthly for 8 years $3,000 monthly for 28 years $2.000 monthly for 25 years Mandy's Retirement Period Question 1: (Needs Approach) The correct answers are based on the set of facts and tables provided below. All the date you need to perform the e ar calculations are contained in the tables following the three paragraphs below. Show all your calculations so you can receive partial credit even if you make mistake. Pat and Mandy are married and have a son, Stev, 8. Mandy, are 29. earns $40,000 annually from her job. Pat pe 31. earns $50,000 annually from his job. Assume that Pat will die before Mandy. The family wants to ensure that they have adequate life insurance on Patto cover their cash and income needs wat die Here, they want to determine if they should purchase additional life insurance on Pat to cover these needs using Needs Approach, you may find some hints from your textbook, page 207-209) The tables below provide figures on the cash reeds 2) present insurance and financial assets; 3 income needs, and 4) income that the family will receive if no additional life insurance is purchased. Use the values in these tables to determine how much any additional life insurance the family should purchase on Patto cover their needs. In your answer, calculate and show the components of any additional life Insurance needed in terms of cash needs and income needs and the total amount of additional life insurance needed This exercise assumes that Pat dies immediately: 2) Mandy continues to work if Pat dies. However, her earnings are not enough to meet their needs. So, the numbers provided in the table are net off her earnings, which means all the items provided below need to be included in your calculation 3) Mandy plans to retire at age 65, anh 4 the life insurance proceeds are invested at an interest rate equal to the rate of inflation so, you do not have to worry about time-value of money issues). Cash Needs: Estate Clearance $15.000 $150,000 Mortgage Redemption Emergency fund Educational Fund $20.000 Present Insurance and Financial Assets: Whole Ufe Insurance $150,000 $10,000 Investments/Savings Income Needs: Readjustment Period Dependency Period Blackout Period $5,000 monthly for 2 years $5,000 monthly for 8 years $2,500 monthly for 28 years $3,500 monthly for 25 years Mandy's Retirement Period Expected Income from Sources Other than Life Insurance: $3,500 monthly for 2 years $3,500 monthly for years $3,000 monthly for 2 years $2,000 monthly for 25 years Question 1: (Needs Approach) The correct answers are based on the set of facts and tables provided below. All the data you need to perform the necessary calculations are contained in the tables following the three paragraphs below. Show all your calculations so you can receive partial credit even if you make mistake. The appearance of your homework is a factor in your grade; therefore, it is suggested it be presented in a professional manner.e. pretend it is like something you would prepare for your boss). Pat and Mandy are married and have a son, Steve, . 8. Mandy, age 29, earns $40,000 annually from her job. Pat, age 31, carns $50,000 annually from his job. Assume that Pat will die before Mandy. The family wants to ensure that they have adequate life insurance on Patto cover their cash and income needs if Pat dies. Hence, they want to determine if they should purchase additional life insurance on Patto cover these needs using Needs Approach. (you may find some hints from your textbook, page 207"209) The tables below provide figures on their: 1) cash needs; 2) present insurance and financial assets; 3) income needs; and 4) income that the family will receive if no additional life insurance is purchased. Use the values in these tables to determine how much, if any, additional life Insurance the family should purchase on Pat to cover their needs. In your answer, calculate and show the components of any additional life insurance needed in terms of cash needs and income needs and the total amount of additional life insurance needed. This exercise assumes that 1) Pat dies immediately: 2) Mandy continues to work if Pat dies. However, her earnings are not enough to meet their needs. So, the numbers provided in the table are net off her earnings, which means all the items provided below need to be included in your calculation, 3) Mandy plans to retire at age 65; and 4) the life insurance proceeds are invested at an interest rate equal to the rate of inflation Iso, you do not have to worry about time-value of money issues). Cash Needs: Estate Clearance $15,000 Mortgage Redemption Emergency fund Educational Fund $150,000 $20,000 $100,000 Present Insurance and Financial Assets: Whole Life Insurance $150,000 Investments/Savings $10,000 Income Needs: Readjustment Period Dependency Period Blackout Period $5,000 monthly for 2 years $5,000 monthly for 8 years $3,500 monthly for 28 years Mandy's Retirement Period $3,500 monthly for 25 years Expected Income from Sources Other Readjustment Period Dependency Period Blackout Period $3,500 monthly for 2 years $3,500 monthly for 8 years $3,000 monthly for 28 years $2.000 monthly for 25 years Mandy's Retirement Period Question 1: (Needs Approach) The correct answers are based on the set of facts and tables provided below. All the date you need to perform the e ar calculations are contained in the tables following the three paragraphs below. Show all your calculations so you can receive partial credit even if you make mistake. Pat and Mandy are married and have a son, Stev, 8. Mandy, are 29. earns $40,000 annually from her job. Pat pe 31. earns $50,000 annually from his job. Assume that Pat will die before Mandy. The family wants to ensure that they have adequate life insurance on Patto cover their cash and income needs wat die Here, they want to determine if they should purchase additional life insurance on Pat to cover these needs using Needs Approach, you may find some hints from your textbook, page 207-209) The tables below provide figures on the cash reeds 2) present insurance and financial assets; 3 income needs, and 4) income that the family will receive if no additional life insurance is purchased. Use the values in these tables to determine how much any additional life insurance the family should purchase on Patto cover their needs. In your answer, calculate and show the components of any additional life Insurance needed in terms of cash needs and income needs and the total amount of additional life insurance needed This exercise assumes that Pat dies immediately: 2) Mandy continues to work if Pat dies. However, her earnings are not enough to meet their needs. So, the numbers provided in the table are net off her earnings, which means all the items provided below need to be included in your calculation 3) Mandy plans to retire at age 65, anh 4 the life insurance proceeds are invested at an interest rate equal to the rate of inflation so, you do not have to worry about time-value of money issues). Cash Needs: Estate Clearance $15.000 $150,000 Mortgage Redemption Emergency fund Educational Fund $20.000 Present Insurance and Financial Assets: Whole Ufe Insurance $150,000 $10,000 Investments/Savings Income Needs: Readjustment Period Dependency Period Blackout Period $5,000 monthly for 2 years $5,000 monthly for 8 years $2,500 monthly for 28 years $3,500 monthly for 25 years Mandy's Retirement Period Expected Income from Sources Other than Life Insurance: $3,500 monthly for 2 years $3,500 monthly for years $3,000 monthly for 2 years $2,000 monthly for 25 years