can you provide a walkthrough of #4 steps 1-4

Question #4 Download monthly price data for Apple, Microsoft, Exxon Mobil, and Johnson & Johnson for the period of Jan. 1995 through Jan. 2018 (use Finance.Yahoo.com). Use Excel for this question 1. Create a column in Ferland apply a range of weights between 1 and with step size of 0.1) to Apple to construct a portfolio consisting of the two shares (remember that the sum of weights should be one, so you can easily calculate the weight for Microsoft. Don't worry if it gets larger than 1!). Plot a scatter-plot graph showing average return and the standard deviation of the portfolio (10 points) 2. Now apply a constraint on weights eliminate negative values of weights and change the weight only between 0 and 1 (with step size of 0.05) and re-plot the scatter plot of average return and variance of portfolio (10 points) 3. Eliminating negative weights is called short sales constraints. Compare the results of parts (1) and (2) and discuss the effects of imposing short-sales constraints on a market. (5 points) 4. Repeat previous stages for the portfolio consisting Exxon Mobil and Johnson & Johnson. Do you observe any differences between this portfolio and the portfolio of (Apple, Microsoft)? (10 points) Question #5 Suppose you take out a 4-year variable interest amortized loan worth $500,000. The loan should be paid off in 48 monthly installment. The APRs in year 1, 2, ..., 5 are 3.5%, 4%, 4.5%, 5% and 4% respectively Calculate your monthly payment each year and attach the excel file containing the amortization table. Question #4 Download monthly price data for Apple, Microsoft, Exxon Mobil, and Johnson & Johnson for the period of Jan. 1995 through Jan. 2018 (use Finance.Yahoo.com). Use Excel for this question 1. Create a column in Ferland apply a range of weights between 1 and with step size of 0.1) to Apple to construct a portfolio consisting of the two shares (remember that the sum of weights should be one, so you can easily calculate the weight for Microsoft. Don't worry if it gets larger than 1!). Plot a scatter-plot graph showing average return and the standard deviation of the portfolio (10 points) 2. Now apply a constraint on weights eliminate negative values of weights and change the weight only between 0 and 1 (with step size of 0.05) and re-plot the scatter plot of average return and variance of portfolio (10 points) 3. Eliminating negative weights is called short sales constraints. Compare the results of parts (1) and (2) and discuss the effects of imposing short-sales constraints on a market. (5 points) 4. Repeat previous stages for the portfolio consisting Exxon Mobil and Johnson & Johnson. Do you observe any differences between this portfolio and the portfolio of (Apple, Microsoft)? (10 points) Question #5 Suppose you take out a 4-year variable interest amortized loan worth $500,000. The loan should be paid off in 48 monthly installment. The APRs in year 1, 2, ..., 5 are 3.5%, 4%, 4.5%, 5% and 4% respectively Calculate your monthly payment each year and attach the excel file containing the amortization table