Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The deductible on your home insurance policy is $ 10,000, which means that you will pay the first $ 10,000 of any damages and then

The deductible on your home insurance policy is $ 10,000, which means that you will pay the first $ 10,000 of any damages and then the insurance company will cover the rest. If the house damages are less than $10,000, you need not file a claim with the insurance company and you will pay on your own.

The damage amounts to the home is going to be normally distributed with a mean of $12,000 and a standard deviation of $ 3,000. The value of the house is insured for only 50,000, which is the upper bound on the damage amount. Any accident resulting in damages above 50,000 requires a new home.

The lower bound on damages is $0. The probability of a home accident occurring this year is 5.5%.

Build a Monte Carlo simulation model to show your expenses in this situation. If there is no home damage then there are no expenses that you have to pay.

Analyze the results of the 1000 iterations to find the following as a percentage of the 1000 iterations. Answer the following in Excel:

How often a claim was filed (damage met deductible) ?

How often you ended up buying a new house ?

Calculate your expected expenses that you paid ?

Provide solution in excel.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

E-Commerce 2013 Business Technology Society

Authors: Ken Laudon, Kenneth C Laudon

9th Edition

0132730359, 978-0132730358

More Books

Students also viewed these Economics questions

Question

What do you mean by quenching of G.M tube.

Answered: 1 week ago