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