Question

In: Finance

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 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)

Solutions

Expert Solution

Solution 1) Possible events:

Solution 2) Expected loss = 0.99*0 + 0.01*120000 = 0 + 1200 = $1,200

Solution 3) Risk of incurrence of losses (Standard deviation) = Sqrt(0.99*(0 - 1200)^2 +  0.01*(120000 - 1200)^2)

= Sqrt(0.99*(-1200)^2 + 0.01*(118800)^2)

= Sqrt(1425600 + 141134400)

= Sqrt(142560000)

= 11939.8492453

= $11,939.85

Please comment in case of any doubts or clarifications required. Please Thumbs Up!!


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:...
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:...
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...
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,...
***Using excel to solve the below*** A business manager wanted to know if there was a...
***Using excel to solve the below*** A business manager wanted to know if there was a relationship between daily temperature measured in degrees Fahrenheit and number of employees who called-in sick each day. He collected the following data over 10 days: Daily Temperature: 54 70 67 57 54 63 72 72 54 71 # Called-in Sick: 33 32 30 37 34 28 31 27 31 26 1. A. Obtain the mode, median, and mean for Daily Temperature only. B. Obtain...
For each of the topics, choose an 'application' for using the model to solve a business...
For each of the topics, choose an 'application' for using the model to solve a business problem. (In what area could you see applying some of the strategies presented in the chapter, and audio. Provide a short example and set up the problem solution. 1) Queuing: a) Where would you apply some of this knowledge? b) Provide a quick setup with all the variables of the application you chose 2) Inventory Management:  a) Where would you apply some of this knowledge?...
Please do it in MS Excel Required: Solve these question in Microsoft Excel Question 01: You...
Please do it in MS Excel Required: Solve these question in Microsoft Excel Question 01: You want to retire on the day you have $1,000,000 is your savings account. You expect to earn 4 percent compounded monthly, on your money during your retirement. Your plan is to withdraw $4500 a month as retirement income from this account. How many years can you be retired until you run out of money? . Question 02: you are able to pay mortgage payments...
(PLEASE READ ) :) Use the data below to solve the following problem using excel: (...
(PLEASE READ ) :) Use the data below to solve the following problem using excel: ( I would like to know how do you input the formula for each category, so please explain the process) I will RATE and comment your answer accordingly 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering the purchase of a new machine that will enable it to increase its expected sales. The machine will have a price of $100,000.  In addition, the machine must be installed and tested.  The costs of installation and testing will amount to $10,000.  The machine will be depreciated using 3-years MACRS. (Use MACRS table from class excel exercise by copying the table and pasting it)          The equipment will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT