2 PLEASE COMPLETE TWO PARTS OF ONE QUESTION - SHOW ALL YOUR WORK IN EXCEL. SHOW FORMULAS. I WILL RATE POSITIVELY IF DONE IN EXCEL.

Homeowners Insurance

Assume that Sandra Rice owns a HO-3 policy for his home. The limits set in his policy are provided below:

Type	Coverage A	Coverage B	Coverage C	Coverage D	Coverage E	Coverage F
Limit	$120,000	$12,000	$60,000	$24,000	$100,000	$5,000

A $350 deductible applies to Section 1, Coverages A, B, and/or C. The replacement cost of Sandras home is $130,000, the contents are valued at $70,000, and the home is 30 percent depreciated. Compute the amount that Sandra will collect in each of the following circumstances and assume that each event occurs independently. Note: a deductible will only apply if losses are less than the coverage limit.

e). Sandra accidentally burns down her neighbor's house while cooking, causing $130,000 in damage.

f). By accident, Sandra strikes another golfer, Timothy, on the head while they are playing golf at Sandra's house. Sandra warned Timothy before he was struck. Timothy claims he didn't hear the warning and has filed a lawsuit against Sandra for $7,000 in medical expenses, $18,000 in lost wages, and $50,000 for pain and suffering. To defend Sandra, it will cost an additional $10,000 to hire a lawyer. Assume Timothy wins the lawsuit.

g). Sandra's son, Jack, has his PlayStation stolen from his dorm room when he is away at college. This results in $600 of damage.

\begin{tabular}{l|l|l|l|} \hline 65 & & & \\ \hline 66 & E) & Personal liability limit & \\ \hline 68 & Personal liability loss & \\ \hline 69 & Total collected & \\ \hline 70 & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Personal liability limit & \\ \hline Timothy's lost wages & \\ \hline Timothy's pain and suffering & \\ \hline Medical payments to others limit & \\ \hline Timothy's medical bill & \\ \hline Cost of Sandra's legal defense & \\ \hline Total collected & \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Personal property limit & \\ \hline Personal property loss & \\ \hline Deductible & \\ \hline Does deductible apply (yeso) & \\ \hline Total collected & \\ \hline \end{tabular}