Question F14 – Use Excel File F14 for your answer. Suppose D…

Question F14 – Use Excel File F14 for your answer. Suppose Dr. N invests 25% of his hard-earned cash in four stocks, Apple, Microsoft, Tesla, and Costco. The following table shows the mean and standard deviation of each stock’s annual return.   Distributions of Returns   Mean Standard Deviation Apple 16% 21% Microsoft 12% 13% Tesla 25% 38% Costco 18% 20%   The correlations between the annual returns on the four stocks are as follows.   Correlation Matrix   Apple Microsoft Tesla Costco Apple 1 0.75 – 0.7 0.2 Microsoft 0.75 1 -0.2 0.5 Tesla -0.7 -0.2 1 0.65 Costco 0.2 0.5 0.65 1   ​You can assume that he has invested equal amounts in each of these stocks. Also it is safe to assume lognormal distribution for each of the stock returns. Use the above simulation model to estimate the probability that Dr. N’s portfolio’s annual return will exceed 22%. Please complete and upload this partial template:  F_2023_Excel F14.xlsx