Question

In: Statistics and Probability

Assume that three business owners each own an identical storage building valued at $120,000. Assume that...

Assume that three business owners each own an identical storage building valued at $120,000.

Assume that there is a 1% chance in any year each building will be destroyed by a peril (fire), and that a loss to any of the buildings is an independent event. Assuming that:

(first case ) Fire events are independent of each other

(second case) Each building faces the same types of risks and environmental conditions.

Given that, solve the below questions for each case:

1. Use the compound probability of independent events law to find the sample space of the probability of each possible event

2. Find the annual expected loss for each of the insureds.

3. Find the risk of incurrence of losses (Std dev)

I need it through excel plus need to see every function

Solutions

Expert Solution

solution: ............................................................... from the given data,

0.01 0.0099
Probability of No Loss 0.99 0.0099
Expected Loss to Insured $120000*0.01= $1,200
SAMPLE SPACE
p A B=A*p D=A-3600 E=D^2 F=p*D
OCCURANCE OF EVENT CALCULATION Probability Amount of Loss Expected Loss(Probability*Amount) Deviation from Expected Deviation Squared Probability*Deviation Squared
Loss to One Building Loss to A and No loss to B&C (0.01*0.99*0.99) 0.009801 $120,000 $1,176 $116,400 $13,548,960,000 $132,793,357
Loss to One Building Loss to B and No loss to A&C (0.01*0.99*0.99) 0.009801 $120,000 $1,176 $116,400 $13,548,960,000 $132,793,357
Loss to One Building Loss to C and No loss to A&B (0.01*0.99*0.99) 0.009801 $120,000 $1,176 $116,400 $13,548,960,000 $132,793,357
Loss to Two Buildings Loss to A&B and No loss to C (0.01*0.01*0.99) 0.000099 $240,000 $24 $236,400 $55,884,960,000 $5,532,611
Loss to Two Buildings Loss to A&C and No loss to B (0.01*0.01*0.99) 0.000099 $240,000 $24 $236,400 $55,884,960,000 $5,532,611
Loss to Two Buildings Loss to B&C and No loss to A (0.01*0.01*0.99) 0.000099 $240,000 $24 $236,400 $55,884,960,000 $5,532,611
Loss to Three Buildings Loss to A, B&C (0.01*0.01*0.01) 0.000001 $360,000 $0.36 $356,400 $127,020,960,000 $127,021
No Loss No Loss to A,B and C (0.99*0.99*0.99) 0.970299 $0 $0 ($3,600) $12,960,000 $12,575,075
SUM $3,600 SUM $427,680,000
EXPECTED LOSS TO INSURER $3,600
VARIANCE OF LOSS TO INSURER $427,680,000
Standard Deviation=Square Root (Variance)
RISK=Standard Deviation of Loss $20,680 (SQRT(427680000)

please vote for solution, thank you........


Related Solutions

Assume that three business owners each own an identical storage building valued at $120,000. Assume that...
Assume that three business owners each own an identical storage building valued at $120,000. Assume that there is a 1% chance in any year each building will be destroyed by a peril (fire), and that a loss to any of the buildings is an independent event. Assuming that: (first case ) Fire events are independent of each other (second case) Each building faces the same types of risks and environmental conditions. Given that, solve the below questions for each case:...
Solve the following question using EXCEL Assume that three business owners each own an identical storage...
Solve the following question using EXCEL Assume that three business owners each own an identical storage building valued at $120,000. Assume that there is a 1% chance in any year each building will be destroyed by a peril (fire), and that a loss to any of the buildings is an independent event. Assuming that: (first case ) Fire events are independent of each other (second case) Each building faces the same types of risks and environmental conditions. Given that, solve...
Due date is today after 3 hours Assume that three business owners each own an identical...
Due date is today after 3 hours Assume that three business owners each own an identical storage building valued at $120,000. Assume that there is a 1% chance in any year each building will be destroyed by a peril (fire), and that a loss to any of the buildings is an independent event. Assuming that: (first case ) Fire events are independent of each other (second case) Each building faces the same types of risks and environmental conditions. Given that,...
Due date is today after 2 hous Assume that three business owners each own an identical...
Due date is today after 2 hous Assume that three business owners each own an identical storage building valued at $120,000. Assume that there is a 1% chance in any year each building will be destroyed by a peril (fire), and that a loss to any of the buildings is an independent event. Assuming that: (first case ) Fire events are independent of each other (second case) Each building faces the same types of risks and environmental conditions. Given that,...
need to solve it on excel as soon as possible Assume that three business owners each...
need to solve it on excel as soon as possible Assume that three business owners each own an identical storage building valued at $120,000. Assume that there is a 1% chance in any year each building will be destroyed by a peril (fire), and that a loss to any of the buildings is an independent event. Assuming that: (first case ) Fire events are independent of each other (second case) Each building faces the same types of risks and environmental...
A new business client comes to your office. There are three owners of the business. The...
A new business client comes to your office. There are three owners of the business. The three individuals, Alan, Bob, and Carol, are thinking about forming a partnership. Alan is only investing $1 million in cash. He will not have anything to do with the daily activities of the business. Bob has had some experience in the business and will be responsible for the day-to-day operations of the business. Carol has a great deal of experience and many contacts within...
A new business client comes to your office. There are three owners of the business. The...
A new business client comes to your office. There are three owners of the business. The three individuals, Alan, Bob, and Carol, are thinking about forming a partnership. Alan is only investing $1 million in cash. He will not have anything to do with the daily activities of the business. Bob has had some experience in the business and will be responsible for the day-to-day operations of the business. Carol has a great deal of experience and many contacts within...
A new business client comes to your office. There are three owners of the business. The...
A new business client comes to your office. There are three owners of the business. The three individuals, Alan, Bob, and Carol, are thinking about forming a partnership. Alan is only investing $1 million in cash. He will not have anything to do with the daily activities of the business. Bob has had some experience in the business and will be responsible for the day-to-day operations of the business. Carol has a great deal of experience and many contacts within...
There are three owners of the business. The three individuals, Alan, Bob, and Carol, are thinking...
There are three owners of the business. The three individuals, Alan, Bob, and Carol, are thinking about forming a partnership. Alan is only investing $1 million in cash. He will not have anything to do with the daily activities of the business. Bob has had some experience in the business and will be responsible for the day-to-day operations of the business. Carol has a great deal of experience and many contacts within the business. She will be responsible for attracting...
A business valued at $2,000,000 has 4 partners. Each of the 4 partners buys a a...
A business valued at $2,000,000 has 4 partners. Each of the 4 partners buys a a $180,000 life insurance policy for purposes of a buy-sell agreement on each of the other partners. Which of the following is/are true? 1. This is an example of an entity purchase plan. 2. This is an example of a cross purchase plan. 3. The buy-sell agreement is over-funded. Group of answer choices 2 only 1 only 2 and 3 only 1 and 3 only
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT