Finc 498 Mini Case #2: Insurance Spring 2022 Attached is a cash flow statement and balance sheet for the Johnsons to reflect their lives 7 years since we first met them. Please use the information on this document along with the information that you have received in class to develop an insurance portfolio for the Johnsons. The report should let the Johnson's know what kind of coverage they currently have, Where the gaps are, ard how they can address these gaps with insurance coverage that you recommend. They currently have their primary residence insured for $138,000 and their rental property insured for $100,000. The replacement cost for those dwellings are $225,000 and $160,000 respectively. Mr. Johnson does have some short-term disability coverage through his employer, but Mrs. Johnson does not. The Johnson's have a son (Brandon 6) and a Rottweiler dog (Frankie) since we last met with them. Mrs. Johnson has really gotten into fitness and currently competes in Biathlons (running and biking) while Mr. Johnson loves to deer hunt when in season. They are a happy family, and while they have 1x their salary of life insurance through their employer, that is their only life insurance coverage. Mr. Johnson carries the family's health insurance through his job. They are a little unclear about the coverage they have (70/30, $4000ded/per $8000/family). The Johnson's currently live in Tulsa Oklahoma, they are not in a flood plain and currently have no sewer backup or earthquake coverage on their property. They have state minimum limits on the auto policy and they have no comprehensive or collision coverage on their personal autos Iohnsons: (this is a more formal FINPLN 2183 HONORS MINI CASE 2 Balance Sheet Cash Flow Statement Cash Inflows: Monthly Husband paycheck Wife paycheck Rental Income: Total inflows 7.200.00 $ 4,800.00 $ 1,500.00 $ 13,500.00 Assets: Primary Residence FMV Rental Property FMV Auto 1" State min limitsins Auto 2 "State min limitsins Jewlery Antique Furniture Gun Collection Triathlon Bikes Other Furnishings 401/k) Accounts Roth IRA'S Investments Total Assets Inbox Cash Outflows: Monthly Mortgage (Primary Home) Mortgage (Rental Property Auto 1 Auto 2 Student Loan Credit Cards Grade School Tuition Daycare Groceries Utilities Entertainment Roth IRA'S Investments Total Outflows Monthly Net Income $ 2.750.00 $ 1,150.00 S 450.00 S $ 700.00 $ 300.00 $ 600.00 S 800.00 s 800.00 $ 1,200.00 $ 600.00 $ 900.00 $ 1.000.00 $ 11,250,00 1 II Llabilities Primary Mortgage Rental Property Mortgage Auto 1 Student Loan Credit Cards Grade School Tuition Totallibilis Net Worth Total libes & Net Worth ili s 2.250.00 FINPLN 2183 HONORS MINI CASE #2 Balance Sheet Assets: Primary Residence FM Rental Property FMV Auto 1. State min limitsins Auto 2 State min limits ins Jewlery Antique Furniture Gun Collection Triathalon Bikes Other Furnishings 401(k) Accounts Roth IRA'S Investments Total Assets $ 175,000.00 $ 95,000.00 $ 16,000.00 $ 1,600.00 $ 18,000.00 $ 7,800.00 $ 1,500.00 $ 5,500.00 $ 45,000.00 $ 130,000.00 $ 40,000.00 $ 25,000.00 $ 560,400.00 Liabilities Primary Mortgage Rental Property Mortgage Auto 1 Student Loan Credit Cards Grade School Tuition Total Liabilities Net Worth Total Liabilities & Net Worth $ 140,000.00 $ 65,000.00 $ 22,000.00 $ 45,000.00 $ 6,000.00 $ 43,200.00 $ 321,200.00 $ 239,200.00 $ 560,400.00 Question 1 Risk Tolerance Life insurance Health insurance Auto DI Home Home- EG, flood, sew & H20 Finc 498 Mini Case #2: Insurance Spring 2022 Attached is a cash flow statement and balance sheet for the Johnsons to reflect their lives 7 years since we first met them. Please use the information on this document along with the information that you have received in class to develop an insurance portfolio for the Johnsons. The report should let the Johnson's know what kind of coverage they currently have, Where the gaps are, ard how they can address these gaps with insurance coverage that you recommend. They currently have their primary residence insured for $138,000 and their rental property insured for $100,000. The replacement cost for those dwellings are $225,000 and $160,000 respectively. Mr. Johnson does have some short-term disability coverage through his employer, but Mrs. Johnson does not. The Johnson's have a son (Brandon 6) and a Rottweiler dog (Frankie) since we last met with them. Mrs. Johnson has really gotten into fitness and currently competes in Biathlons (running and biking) while Mr. Johnson loves to deer hunt when in season. They are a happy family, and while they have 1x their salary of life insurance through their employer, that is their only life insurance coverage. Mr. Johnson carries the family's health insurance through his job. They are a little unclear about the coverage they have (70/30, $4000ded/per $8000/family). The Johnson's currently live in Tulsa Oklahoma, they are not in a flood plain and currently have no sewer backup or earthquake coverage on their property. They have state minimum limits on the auto policy and they have no comprehensive or collision coverage on their personal autos Iohnsons: (this is a more formal FINPLN 2183 HONORS MINI CASE 2 Balance Sheet Cash Flow Statement Cash Inflows: Monthly Husband paycheck Wife paycheck Rental Income: Total inflows 7.200.00 $ 4,800.00 $ 1,500.00 $ 13,500.00 Assets: Primary Residence FMV Rental Property FMV Auto 1" State min limitsins Auto 2 "State min limitsins Jewlery Antique Furniture Gun Collection Triathlon Bikes Other Furnishings 401/k) Accounts Roth IRA'S Investments Total Assets Inbox Cash Outflows: Monthly Mortgage (Primary Home) Mortgage (Rental Property Auto 1 Auto 2 Student Loan Credit Cards Grade School Tuition Daycare Groceries Utilities Entertainment Roth IRA'S Investments Total Outflows Monthly Net Income $ 2.750.00 $ 1,150.00 S 450.00 S $ 700.00 $ 300.00 $ 600.00 S 800.00 s 800.00 $ 1,200.00 $ 600.00 $ 900.00 $ 1.000.00 $ 11,250,00 1 II Llabilities Primary Mortgage Rental Property Mortgage Auto 1 Student Loan Credit Cards Grade School Tuition Totallibilis Net Worth Total libes & Net Worth ili s 2.250.00 FINPLN 2183 HONORS MINI CASE #2 Balance Sheet Assets: Primary Residence FM Rental Property FMV Auto 1. State min limitsins Auto 2 State min limits ins Jewlery Antique Furniture Gun Collection Triathalon Bikes Other Furnishings 401(k) Accounts Roth IRA'S Investments Total Assets $ 175,000.00 $ 95,000.00 $ 16,000.00 $ 1,600.00 $ 18,000.00 $ 7,800.00 $ 1,500.00 $ 5,500.00 $ 45,000.00 $ 130,000.00 $ 40,000.00 $ 25,000.00 $ 560,400.00 Liabilities Primary Mortgage Rental Property Mortgage Auto 1 Student Loan Credit Cards Grade School Tuition Total Liabilities Net Worth Total Liabilities & Net Worth $ 140,000.00 $ 65,000.00 $ 22,000.00 $ 45,000.00 $ 6,000.00 $ 43,200.00 $ 321,200.00 $ 239,200.00 $ 560,400.00 Question 1 Risk Tolerance Life insurance Health insurance Auto DI Home Home- EG, flood, sew & H20