Use MSFT.PDF file provided to you with historical returns from 5/1/2016 to 3/19/2021. As of November 11, 2022, price of MSFT is $247.11. Assume current price of MSFT is $247.11/share. Use the bootstrapping approach (that estimates a return on MSFT during each of the next 12 months by assuming that the return during each month is equally likely to be any of the returns for the 60 months listed in MSFT.pdf) to estimate MSFT ending Price in one year. Use Data Table to generate 1000 scenarios of MSFT price in one year (i.e., Run Monte Carlo simulations on stock price). A 1: One year target estimate for MSFT on Yahoo is $299.37. Estimate the probability that in one year the price of MSFT stock will be greater than or equal to $299.37.

A 2: Using current price of MSFT is $247.11/share and a similar bootstrapping approach, estimate MSFT ending Price in two years. Use Data Table to generate 1000 scenarios of MSFT price in two years (i.e., Run Monte Carlo simulations on stock price). Now, Estimate the probability that in two years the price of MSFT stock will be greater than or equal to $400.

Choose CO, and KKR. Use Adjusted Closing prices to calculate the return on each stock for each month. For example, Date Adj. Close of XYZ stock

2021-02-01 144.19 2021-01-01 143.84

Return = Adj close on (20210201) Adj close on (20210101)

Adj close on (20210101)

B (2) Then set up a spreadsheet to compute annual return AT THE END OF EACH MONTH for a portfolio (comprised of one share of each stock, CO AND KKR) for the period Start date 2015-05-01 to End date 2021-04-09. If you held the portfolio for 71 months, what annual rate of return would you get? If you held the portfolio for 39 months, what annual rate of return would you get? What are your inferences from this data analysis?

I Bulk Stock Quote Downloader Invest \begin{tabular}{l} Samir Khan \\ simulationconsultant@gmail.com \\ \hline 12th July 2017 \\ \hline \end{tabular} \begin{tabular}{l|l|l|} \hline 12 & Enter Tickers Below \\ 13 & WMT \\ 14 & CO \\ 15 & MSFT \\ 16 & ^GSPC \\ 17 & KKR \\ 18 & BP \\ 19 & O005.HK \\ 20 & NFTSE \\ 21 & XOM \\ 22 & NDJI \\ 23 & SHEL \\ 24 & \\ 25 & \\ \hline \end{tabular} Enter a list of stock tickers and click the button to automatically retrieve historical stock quotes from Yahoo Finance Data for each ticker is downloaded into separate sheets, each titled with the ticker symbol Collate Data stacks Close, Open, High, Low, Adjusted Close Failed for These Tickers \begin{tabular}{l} Success for These Tickers \\ WMT \\ CO \\ MSFT \\ GSPC \\ KKR \\ BP \\ OO05.HK \\ FTSE \\ XOM \\ DJI \\ SHEL \\ \hline \end{tabular} and Volume into the same sheets (with the date) for all tickers. The VBA for this spreadsheet is viewable and editable Please link to http://investexcel.net if you like the spreadsheet The latest version can be found at http://investexcel.net/multiple-stock-quote-downloader-for-excel/ Post questions or comments at http://investexcel.net/multiple-stock-quote-downloader-for-excel/ I Bulk Stock Quote Downloader Invest \begin{tabular}{l} Samir Khan \\ simulationconsultant@gmail.com \\ \hline 12th July 2017 \\ \hline \end{tabular} \begin{tabular}{l|l|l|} \hline 12 & Enter Tickers Below \\ 13 & WMT \\ 14 & CO \\ 15 & MSFT \\ 16 & ^GSPC \\ 17 & KKR \\ 18 & BP \\ 19 & O005.HK \\ 20 & NFTSE \\ 21 & XOM \\ 22 & NDJI \\ 23 & SHEL \\ 24 & \\ 25 & \\ \hline \end{tabular} Enter a list of stock tickers and click the button to automatically retrieve historical stock quotes from Yahoo Finance Data for each ticker is downloaded into separate sheets, each titled with the ticker symbol Collate Data stacks Close, Open, High, Low, Adjusted Close Failed for These Tickers \begin{tabular}{l} Success for These Tickers \\ WMT \\ CO \\ MSFT \\ GSPC \\ KKR \\ BP \\ OO05.HK \\ FTSE \\ XOM \\ DJI \\ SHEL \\ \hline \end{tabular} and Volume into the same sheets (with the date) for all tickers. The VBA for this spreadsheet is viewable and editable Please link to http://investexcel.net if you like the spreadsheet The latest version can be found at http://investexcel.net/multiple-stock-quote-downloader-for-excel/ Post questions or comments at http://investexcel.net/multiple-stock-quote-downloader-for-excel/