Business
College
FINC 6366: Portfolio Covariance and Correlation and Insurance Risk Assessment
FINC 6366 quantitative risk pack. Project 2 is a worked Excel model of expected returns, standard deviations, covariance and correlation for six stocks across growth/status-quo/recession states, plus three 50/50 portfolios. Project 1 is a risk-assessment problem set: loss distributions and expected loss for a car-rental fleet, claim frequency and severity for an insurer, convolution to average loss, and pooling of independent fire losses.
Summaries
Read the workbook structure and scenario dataFrom: Copy of FINC_6366_Project_2_Covariance_and_Correlation
Reading the Portfolio Pair Outputs in the Covariance WorkbookFrom: Copy of FINC_6366_Project_2_Covariance_and_Correlation
Portfolio Covariance and Correlation: Core Workbook ConceptsFrom: Copy of FINC_6366_Project_2_Covariance_and_Correlation