FINC6366Project1-RiskAssessment1.xlsx

FINC 6366 – Project 1

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