Question
How would you set up a mote carlo excel data table for the following question? You are purchasing insurance for your house.You have three options:
How would you set up a mote carlo excel data table for the following question?
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 $300 per month.
Low deductible policy that pays out 100% of expenses after the first $5000 for the year costs you $140 per month.
High deductible policy that pays out 100% of expenses after the first $10000 for the year costs you $75 per month.
You expect house damages to this year to follow a discrete distribution as follows:
65% chance of no damages
20% chance of damages light between $4,000 and $10,000 (uniformly distributed)
14% chance of high damages between $25,000 and $50,000 (uniformly distributed)
1% chance of catastrophic damages equal to $250,000.
What policy minimizes your expected expenses after insurance coverage for the year?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started