Can someone help me with all parts lf this problem please

I need the calculations

a) Choose 4 different publicly traded stocks. Assume that you had a total of $10,000 to invest (so invest your funds as close to $10,000 as possible) b) Allocate the funds as you see fit between the 4 stocks based on prices 25 months ago. c) Go to Yahoo Finance and download the prices on a montlhly basis for the last 25 months for each stock. Use the first price as your purchase price. Use the adjusted close prices. d) Calculate the Initial Value of your investment = No of Shares x Price e) Calculate each of the stocks weight based on initial investment value . So for stock A weight would be = Value in $ of A Total porfolio value in $ f) Calculate monthly returns for each stock, You should have 24 Returns. R=(P2P1/P1, Calculate expected monthly return of your stock = the average of your returns and then mutiply by 12 to anualize your returns. Add your results to colunm f g) Calculate the risk of the monthly returns by calculating the std deviation (one value) anualize by multiplying the result by the Square root of 12 . (excel function = SQRT(. ).) h) Using your annual expecected returns and portfolio weights, calclate the weighted expected return of your portfolio. i) Obain the Betas for each stock in Yahoo Finance - These are available in the first sheet that you see when you get the information for your stock. i) Assume that the risk free rate is 1.99% (You can actually look for the updated value in Yahoo Finance using the Ticker TNX which will give you the rate for the 10 year treasury bond.) and assume that the market return is 8%. Using that information plus the Betas of each stock, calculate the return of each stoch using the CAPM k) Calculate the weighted expected return of your portfolio using the Expected return calculations that you did Using the CAPM, 1) Calculate the portfolio Beta m) Add your sales price (The most recent price from your analysis) n) Calculate your value by multiplying your number of shares x sales price For this discussion you will need to do some calculations and share your results. The idea is for you to apply the concepts related to risk and return that you have learned so fat a) Choose 4 different publiely traded stocks. Assume that you had a total of $10,000 to invest (so invest your funds as close to $10,000 as possible) Aaron's, Inc Advance Auto Parts Inc Apple inc Allas Air Worldwde Holdings b) Allocate the funds as you seefit between the 4 stocks based on prices 25 months ago. c) Co to Yahoo Finance and downlood the prices on a montihly basis for the last 25 months for each stock. Use the first price as your purchase price. Use the adfusted dose prices d) Colculate the initial Value of your investment = No of shares x Price e) Calculate each of the stocks weight based on initial investment value. 50 for stock A weight would be is value in 5 of A fotal porfolio value in 5 1) Calculate monthly returns for each stock, You should have 24 Returns H=(P2 - P1)/P1 . Calculate expected monthly return of vour stock = the averaer of your returns and then mutiply by 12 to anualize your returns. Add yout results to colunmf u) Calculate the risk of the monthly ceturns by calculating the std deviation (one value) anualize by multiplyine the resulf by the Square root of 12 . (escel function same 1.) h) Wsing your annual expecected returns and portfolio weights, calclate the weighted expected refure of your portfolio. 1) Obain the betas for each stock in Yaheo Finance - These are available in the first sheet that you see when you eet the information for your stock. II Assume that the risk free rate is 1.99 ( You can actually look for the updated value in Yahoo finance using the Ticher TNX which will give vou the rate for the 10 year tieasury bo and assume that the market return is 8K, Usine that information plus the Betas of each stock, calculate the return of each stoch usine the CAPM k) Calculate the weighted expected return of your portfolio using the Expected return calculations that you did using the capM. 1) Calculate the portfolio Beta e) Calculate exch of the stocks weight bosed on initial investrient valut so for stock A weipent would be =value in $ of Mrotal porfolio value in $ 7) Calculate monthly returns for each stakk You should have 24 Returns k=(P2 - P1)/P1. Calculate exsected monthly return of vour stock e the averase of vour returns and then mutiply by 12 to anualize vour returns: Add your results to colunm f m) Calculate the risk of the monthly returns by calculating the std deviation (one value) anualize by multiplying the tesult by the Savare root of 12 . (eacel function isami. I ) h) Usine vour annual expecected returns and portfolio weights, calciate the weichtrd expected return of your portfolio 6i) Obain the Zletas for each stock in Yahoo finance. These are avoulable in the first sheet that you see when you get the information for your stock. j) Assume that the risk free rate is 199 ( You can actually look for the updated value in yahoo Finance using the Ticker Tinx which will give you the rate for the 10 year treatury bond and assume that the market return is 5%, Using that information plus the Betas of each stock, calculate the return of esch stoch using the CapM W) Colculate the weighted expected return of vour portfolio using the Expected return calculations that you did Using the CapM. 1) Calculate the portfolia ileta m) Add your sales price the most recent price from vour analysis) n) Calculate your value by multiplyine yeur number of shares x sales price a) Calculate vour final return a) Choose 4 different publicly traded stocks. Assume that you had a total of $10,000 to invest (so invest your funds as close to $10,000 as possible) b) Allocate the funds as you see fit between the 4 stocks based on prices 25 months ago. c) Go to Yahoo Finance and download the prices on a montlhly basis for the last 25 months for each stock. Use the first price as your purchase price. Use the adjusted close prices. d) Calculate the Initial Value of your investment = No of Shares x Price e) Calculate each of the stocks weight based on initial investment value . So for stock A weight would be = Value in $ of A Total porfolio value in $ f) Calculate monthly returns for each stock, You should have 24 Returns. R=(P2P1/P1, Calculate expected monthly return of your stock = the average of your returns and then mutiply by 12 to anualize your returns. Add your results to colunm f g) Calculate the risk of the monthly returns by calculating the std deviation (one value) anualize by multiplying the result by the Square root of 12 . (excel function = SQRT(. ).) h) Using your annual expecected returns and portfolio weights, calclate the weighted expected return of your portfolio. i) Obain the Betas for each stock in Yahoo Finance - These are available in the first sheet that you see when you get the information for your stock. i) Assume that the risk free rate is 1.99% (You can actually look for the updated value in Yahoo Finance using the Ticker TNX which will give you the rate for the 10 year treasury bond.) and assume that the market return is 8%. Using that information plus the Betas of each stock, calculate the return of each stoch using the CAPM k) Calculate the weighted expected return of your portfolio using the Expected return calculations that you did Using the CAPM, 1) Calculate the portfolio Beta m) Add your sales price (The most recent price from your analysis) n) Calculate your value by multiplying your number of shares x sales price For this discussion you will need to do some calculations and share your results. The idea is for you to apply the concepts related to risk and return that you have learned so fat a) Choose 4 different publiely traded stocks. Assume that you had a total of $10,000 to invest (so invest your funds as close to $10,000 as possible) Aaron's, Inc Advance Auto Parts Inc Apple inc Allas Air Worldwde Holdings b) Allocate the funds as you seefit between the 4 stocks based on prices 25 months ago. c) Co to Yahoo Finance and downlood the prices on a montihly basis for the last 25 months for each stock. Use the first price as your purchase price. Use the adfusted dose prices d) Colculate the initial Value of your investment = No of shares x Price e) Calculate each of the stocks weight based on initial investment value. 50 for stock A weight would be is value in 5 of A fotal porfolio value in 5 1) Calculate monthly returns for each stock, You should have 24 Returns H=(P2 - P1)/P1 . Calculate expected monthly return of vour stock = the averaer of your returns and then mutiply by 12 to anualize your returns. Add yout results to colunmf u) Calculate the risk of the monthly ceturns by calculating the std deviation (one value) anualize by multiplyine the resulf by the Square root of 12 . (escel function same 1.) h) Wsing your annual expecected returns and portfolio weights, calclate the weighted expected refure of your portfolio. 1) Obain the betas for each stock in Yaheo Finance - These are available in the first sheet that you see when you eet the information for your stock. II Assume that the risk free rate is 1.99 ( You can actually look for the updated value in Yahoo finance using the Ticher TNX which will give vou the rate for the 10 year tieasury bo and assume that the market return is 8K, Usine that information plus the Betas of each stock, calculate the return of each stoch usine the CAPM k) Calculate the weighted expected return of your portfolio using the Expected return calculations that you did using the capM. 1) Calculate the portfolio Beta e) Calculate exch of the stocks weight bosed on initial investrient valut so for stock A weipent would be =value in $ of Mrotal porfolio value in $ 7) Calculate monthly returns for each stakk You should have 24 Returns k=(P2 - P1)/P1. Calculate exsected monthly return of vour stock e the averase of vour returns and then mutiply by 12 to anualize vour returns: Add your results to colunm f m) Calculate the risk of the monthly returns by calculating the std deviation (one value) anualize by multiplying the tesult by the Savare root of 12 . (eacel function isami. I ) h) Usine vour annual expecected returns and portfolio weights, calciate the weichtrd expected return of your portfolio 6i) Obain the Zletas for each stock in Yahoo finance. These are avoulable in the first sheet that you see when you get the information for your stock. j) Assume that the risk free rate is 199 ( You can actually look for the updated value in yahoo Finance using the Ticker Tinx which will give you the rate for the 10 year treatury bond and assume that the market return is 5%, Using that information plus the Betas of each stock, calculate the return of esch stoch using the CapM W) Colculate the weighted expected return of vour portfolio using the Expected return calculations that you did Using the CapM. 1) Calculate the portfolia ileta m) Add your sales price the most recent price from vour analysis) n) Calculate your value by multiplyine yeur number of shares x sales price a) Calculate vour final return