Please complete D&E parts of a question in EXEL, SHOW THE FORMULAS. Thank you!

Personal Auto Policy

Assume that Zabine Telan owns a PAP. Zabines policy has the following limits:

Part A = $50,000 bodily injury each person; $100,000 bodily injury each accident; $50,000 property damage each accident

Part B = $5,000

Part C = $50,000 each person; $100,000 each accident

Part D = $1,000 deductible for collision; $500 deductible for other than collision

Assume that each of the events described in the following situations are distinct. The actual cash value of Zabines car is $21,000. The goal is to calculate the amount Zabines insurer will pay in total (i.e., net after any deductible that Zabine must pay).

D). Zabine is struck by an uninsured vehicle while driving to the store. Zabine's medical bills total $5,000 and lost wages total $15,000. Damage to Zabine's vehicle amounts to $23,000.

E). Zabine lends a car to Karmel. Karmel has a PAP, with coverage identical to Zabines. Karmel runs over and injures a famous soccer player who recently signed a 1-year contract for $1,000,000. Karmel is sued for $1,500,000.

A B c D \begin{tabular}{|l|l|} \hline Liability amount & \\ \hline Liability limit & \\ \hline Zabine's insurer will pay & \\ \hline \end{tabular} G)