You want to form a portfolio between two stocks: Canadian Tire and the Apple Inc. Download the monthly price data from Yahoo! Finance pages for Canadian Tire (ticker symbol: CTC-A.TO) and Apple (ticker symbol: AAPL) from November 1, 2018 to November 1, 2023. Calculate the monthly holding period returns for each stock in Excel using the split-adjusted prices that Yahoo provides . Use these data and Excel to answer the following questions:

What are the average monthly return and standard deviation of returns for Canadian Tire? What are the average monthly return and standard deviation of returns for the Apple? Does risk-return relationship (trade-off) hold between these two stocks?

Using these values, calculate the portfolio return and standard deviation for various weights in Canadian Tire and Apple:

Calculate the portfolio return and standard deviation for a portfolio with alternately 0%, 5%, 10%, 15% .., 95%, 100% weight in Apple and the rest in Canadian Tire.

Graph this portfolio return and standard deviation for all possible portfolios on a graph with Return on the vertical axis and Standard deviation on the horizontal axis. (hint: Use Scatter Plot type of graph)

Calculate the Canadian Tires weight in the portfolio that gives the minimum standard deviation (hint: try using solver or manual trial and error); show this portfolio on a graph built above.