Provide the answers on excel. Zabine$$s 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 Zabine$$s car is $$21,000.$ The goal is to calculate the amount Zabine$$s 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.$

Medical expenses and wages : $?$

Zabine$$s car damage: $?$

Zabine$$s car deductible: $?$

Zabine$$s car ACV: $?$

Zabine$$s insurer will pay $?$

E$)$ Zabine lends a car to Karmel. Karmel has a PAP, with coverage identical to Zabine$$s$.$ 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.$

Liability amount: $?$

Liability limit: $?$

Zabine$$s insurer will pay $?$

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.

Damage to neighbor$$s car $?$

Zabine$$s car deductible: $?$

Zabine$$s insurer will pay $?$

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

Zabine$$s car ACV?

Zabine$$s car deductible: $?$

Zabine$$s insurer will pay $?$