Please complete these part 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.

F). For a week, Zabine borrows a neighbor's car, with permission, while the neighbor is away on vacation. The neighbor has a PAP similar to the one Zabine has. On the sixth day, Zabine hits a tree while driving. The neighbor's automobile sustained $4,500 in damage. Consider which insurance is primary.

G). Zabine is driving on County Highway. All of a sudden, Zabine collides head-on with a deer. Zabine's vehicle is destroyed.