50.1K

Verified Solution

Link Copied!

Please describe two possible circulated calculation in pro forma modeling in the pictures below. How to tackle in Excel? (15) Ans: Q7 Find the inverse matrix of the Matrix A in worksheet " 26. (15 ) Ans: In template Q7, please write down the variance-corariance matrix of the six stocks (with 3 digita) (15) Ans: Q9 a. Given the data in worksheet Q8, please find out the envelope (efficient) portfolios given the constants =0% and 6%, with shoit selling allowed. What are the weights of each stock in the portfolios x and y ? (6) Ans: Annualized Return -stock 1: stock 2: stock3 : Stock4: Variance-Covariance Matrix b. What are the annualized return, variance for each portfolio, and covariance and correlation -coefficient between x and y?(6) Please describe two possible circulated calculation in pro forma modeling in the pictures below. How to tackle in Excel? (15) Ans: Q7 Find the inverse matrix of the Matrix A in worksheet " 26. (15 ) Ans: In template Q7, please write down the variance-corariance matrix of the six stocks (with 3 digita) (15) Ans: Q9 a. Given the data in worksheet Q8, please find out the envelope (efficient) portfolios given the constants =0% and 6%, with shoit selling allowed. What are the weights of each stock in the portfolios x and y ? (6) Ans: Annualized Return -stock 1: stock 2: stock3 : Stock4: Variance-Covariance Matrix b. What are the annualized return, variance for each portfolio, and covariance and correlation -coefficient between x and y?(6)

Answer & Explanation Solved by verified expert

See Answer