FINC6366Project1-RiskAssessment1.xlsx

Published by at March 29, 2022

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