Creating a monte carlo on excel.

You are purchasing insurance for your house. You have three options:

Zero deductible policy that will pay 100% of all expenses for the year costs you $325 per month.

Low deductible policy that pays out 100% of expenses after the first $7500 for the year costs you $150 per month.

High deductible policy that pays out 100% of expenses after the first $15000 for the year costs you $85 per month.

You expect house damages to this year to follow a discrete distribution as follows:

43% chance of no damages

20% chance of minor damages between $100 and $2,500 (uniformly distributed)

20% chance of moderate damages between $4,000 and $10,000 (uniformly distributed)

15% chance of high damages between $25,000 and $50,000 (uniformly distributed)

2% chance of catastrophic damages equal to $250,000.

What policy minimizes your expected expenses pertaining to damages and insurance coverage for the year?