| FINC 6366 – Project 1 – Risk Assement | | Name |
|
| A) |
|
| Loss Outcome |
| Probability of Loss Outcome |
| Expected Value of Loss |
|
| B) |
| Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
| Loss outcomes | Probabilities | Loss Outcome – Expected Loss | Squared Difference | Squared Difference x Probability |
|
|
| Sum |
| Variance |
| Standard Deviation |
|
| C) |
| Column 1 | Column 2 | Column 3 |
| Number of Claims Filed | Number of Houses | Total Number of Claims |
|
|
|
| Sum |
| Average Frequency |
|
| D) |
| Number of Claims |
| Probability |
|
| E) |
| Column 1 | | Column 2 | Column 3 | Column 4 |
| Lower Range of Loss | Upper Range of Loss | Midpoint of Claims Range | Number of Losses | Total Dollar Amount of Losses |
|
|
| N/A |
| Sum |
| Average Loss Severity |
|
| F) |
| Midpoint of Claims Range |
| Probability |
|
| G) |
| Row | Loss 1 | Loss 2 | Total Loss | Probability | Total Loss x Probability |
| A |
| B |
| C |
| D |
| E |
| F |
| G |
| H |
| I |
| J |
| K |
| L |
| M |
| Sum |
|
| H) |
| Probability |
| Loss |
| Expected Value of Loss |
| Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
| Loss outcomes | Probabilities | Loss Outcome – Expected Loss | Squared Difference | Squared Difference x Probability |
|
|
|
| Sum |
| Variance |
| Standard Deviation |
|
| I) |
| Alderan Loss | Dagobah Loss | Total Loss | Mean Loss | Probability |
|
|
|
|
|
|
|
|
|
|
| J) |
| Expected Value of Loss |
| Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
| Loss outcomes | Probabilities | Loss Outcome – Expected Loss | Squared Difference | Squared Difference x Probability |
|
|
|
|
|
|
|
|
|
| Sum |
| Variance |
| Standard Deviation |
|
