EXCEL FORMULAS PLEASE Average return Variance Sigma Covariance of returns Correlation of returns Portfolio Proportion of A

EXCEL FORMULAS PLEASE

 

Transcribed Image Text:

Average return Variance Sigma Covariance of returns Correlation of returns Portfolio Proportion of A Proportion of B Portfolio average return Portfolio standard deviation Section a.. Proportion of A Proportion of B Portfolio average return Portfolio standard Section b. Min-variance portfolio Proportion of A Proportion of B Portfolio average return Portfolio standard Company A Company B stock stock 10% 0.0800 28.28% 15% 0.1600 40.00% 0.00350 0.03094 B6/(B4*C4) 0.9 0.11-B10 10.50% Average return Variance Sigma Covariance of returns Correlation of returns Portfolio Proportion of A Proportion of B Portfolio average return Portfolio standard deviation Section a.. Proportion of A Proportion of B Portfolio average return Portfolio standard Section b. Min-variance portfolio Proportion of A Proportion of B Portfolio average return Portfolio standard Company A Company B stock stock 10% 0.0800 28.28% 15% 0.1600 40.00% 0.00350 0.03094 B6/(B4*C4) 0.9 0.11-B10 10.50%

Answer rating: 100% (QA)

Certainly Lets break this down step by step Section a 1 Portfolio Proportions Proportion of A 09 90 ... View the full answer