| FINC 6366 - Project 4 - Homeowners Insurance |
| Name |
| Coverage A | $120,000 |
| Coverage B | $12,000 |
| Coverage C | $60,000 |
| Coverage D | $24,000 |
| Coverage E | $100,000 |
| Coverage F | $5,000 |
| A) | Home replacement value |
| | Insurance to value ratio |
| | Dwelling limit |
| | Dwelling loss |
| | Personal property limit |
| | Personal property loss |
| | Loss of use limit |
| | Loss of use expense |
| | Deductible |
| | Does deductible apply (yes/no) |
| | Total collected |
| B) | Dwelling limit |
| | Dwelling loss |
| | Is the dwelling covered (yen/no) |
| | Truck loss amount |
| | Is the truck covered (yes/no) |
| | Combined medical expenses |
| | Is medical covered (yes/no) |
| | Deductible |
| | Does deductible apply (yes/no) |
| | Total collected |
| C) | Other structures limit |
| | Other structures loss |
| | Personal property limit |
| | Personal property loss |
| | Deductible |
| | Does deductible apply (yes/no) |
| | Total collected |
| D) | Dwelling limit |
| | Dwelling loss |
| | Other structures limit |
| | Other structures loss |
| | Personal property limit |
| | Personal property loss |
| | Loss of use limit |
| | Loss of use expense |
| | Deductible |
| | Does deductible apply (yes/no) |
| | Total collected |
| E) | Personal liability limit |
| | Personal liability loss |
| | Total collected |
| F) | Personal libaility limit |
| | Timothy's lost wages |
| | Timothy's pain and suffering |
| | Medical payments to others limit |
| | Timothy's medical bill |
| | Cost of Sandra's legal defense |
| | Total collected |
| G) | Personal property limit |
| | Personal property loss |
| | Deductible |
| | Does deductible apply (yes/no) |
| | Total collected |
| H) | Personal property limit |
| | Personal property loss |
| | Deductible |
| | Is loss a covered peril (yes/no) |
| | Total collected |
| I) | Personal liability limit |
| | Personal liability loss |
| | Is loss excluded (yes/no) |
| | Total collected |
Juicetea
FINC6366Project4-HomeownersInsurance1.xlsx
