I need help asap please!!! Will pay for it.

this is the first part contact me on what's app or iMessage for the details

484-619-8532

Use the attached Excel sheet as a guide. Note: The attached Excel sheet shows the calculations for 12 stocks. Your portfolios have 10 stocks, so you will have to make a similar sheet for your portfolios using your 10 stock investments.

1. Use the 10 stocks from your investments and treat it as your portfolio. These 10 investments will be your "Universe" of investable assets.
   1. Replace the "Name" row in the "Price Data" worksheet with the names of your investments
   2. Replace the "Ticker" row in the "Price Data" worksheet with the ticker of your investments
   3. Find the Market Capitalization data for each of your 12 stocks and update the "Equity Value" row in the "Price Data" worksheet (see the note below for how to get the Marketcap numbers from Yahoo finance.). If you cannot find the Market Cap for a particular firm, estimate it using a comparable firm for which data is available. You can make by using the Yahoo stock screener (https://finance.yahoo.com/screener/) and finding similar firms to the one you are searching for.
   4. The "Benchmark Proportions" row in the "Price Data" worksheet will update automatically
   5. Replace the "Your Initial $ Investment" row in the "Price Data" worksheet with the approximate $ amounts you invested in each of the 10 assets.
   6. Replace the "Price on date of purchase" row in the "Portfolio Returns" worksheet with the purchase price of 1 stock of each of the 10 assets.
   7. Download price data from Yahoo finance for your 10 investments and update the columns C through N, rows 9 - 69.
      1. I am attaching a second Excel sheet: "Get Yahoo Monthly or Daily Data, calculate beta, and Calculate Portfolio Values-5.xlsm" which will pull daily and/or monthly data for you. Please follow the instructions provided in the Excel sheet. The sheet will also calculate the betas of the stock for you.
      2. This sheet assumes that ALL of your money is invested in your portfolio. If you have any cash that you did not invest, please adjust the portfolio with this amount. You can assume that the cash earns the risk-free rate of interest.
      3. This sheet uses SPY instead of ^GSPC as the market proxy. You can use this as your market proxy as well.

Replace the "Risk Free Rate" in cell B17 in the "Var-Covar" worksheet with the risk-free rate (see: https://www.treasury.gov/resource-center/data-chart-center/interest-rates/pages/textview.aspx?data=yield ). Justify which rate you pick. Note that the rates shown here are already in %, i.e. the number 0.02 means 0.02% ANNUALLY. Be sure to convert to the monthly rate by dividing it by 12.

1. Calculate the Unconstrained Markowitz Optimal Risky Portfolio in the "Var-Covar" worksheet. (Copy paste these into your writeups)
   1. Discuss how realistic the Unconstrained Markowitz Optimal Risky Portfolio is with the recommendations obtained.
   2. Replace cells in row 7 in the "Portfolio Returns" worksheet to obtain the performance of the Unconstrained Markowitz Optimal Risky Portfolio.
2. Calculate the Constrained Optimal portfolio (no shorting) on the worksheet "Var-Covar - Constrained" using Excel's Solver function. Please play around with different constraints to obtain the best possible Sharpe ratio. Use the weights obtained using this optimization (also try different algorithms - GRG NonLinear, Simplex LP, Evolutionary from "Choose a Solving Method" option). I show below and example of the solver function with the following constraints:
   1. No-Shorting (P20:P31 >=0)
   2. Maximum 20% invested in 1 stock (P20:P31 <=0.2)
   3. Minimum 5% invested in each stock (P20:P31 >=0.05)
   4. Fully invested (P33 = 1)

please help needed asap contact me