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 |