Life Insurance Financial Needs Analysis Worksheet Step 1: Calculate the Family's Income (Cash Flow) Needs for Each Period. Empty Nest/ Blackout Period of Surviving Spouse (Age XX. 60) Retirement Period for Surviving Spouse (X Years) Readjustment (1 or 2 Years) Children's Area) (X-16) Children's Agas) (17-18) Surviving Spouse's Age Deceased Spouse's (Would Be Age Annual Income Needed Less Assumed OASD Social Security) Net Annual Income Needed (PMT) [{1+ Nominal Returnil +Inflation)-1] x 100 N-Years Needed PV of Net Annual Income Needed (Use Begin Mode) Discount Period Present Value Today Sum of Present Value of Total Income Needed 0 0 0 Step 2: Calculate the Family's Lump-Sum Funding Needs. Final Expenses Debts Other Than Mortage Mortage Education Funding Needed (in Today's Dollars Emegency Fund 0 Estate Settlement Costs 0 Total Lump-Sum Funding Needs 0 0 Step 3: Calculate Total Life Insurance Needs. Present Value of Total Income Needed Total Lam Sum Funding Needs Total Needs 0 0 Step 4: Calculate the Life Insurance Death Benefit Needed. Total Life Insurance Needs 0 Less Current Life Insurance Less Current Liquid Assets Net Death Benefit of Life Insurance Needed 0