Comapny name Gas distributors

Make sure you're in the Equity tab then go to the bottom right of the page and click $"+$ New Equity Screen" $1$Within the SELECT CRITERIA section at the top, make sure the $3$ Criteria Options are clicked then click on the folder icon: Add the S&P Composite $1500$ index stocks only $($note it's $1500$ not $500)$Index $>$ S&P US $>$ S&P Composite $1500$ Index $2$Within the "Add Columns" section of the Format Results area, include one column for each of the following parameters using the Screening formulas below: Factset Screeing Formula Factset IndustryFG$\_$FACTSET$\_$IND Stock PriceP$\_$PRICE$($NOW$)$ Market Value of the stockP$\_$MARKET$\_$VAL$\_$SEC$(0)$ Company Net SalesFF$\_$SALES$($LTM$\_$R$,0)1$ yr $\%$ Change in stock priceFG$\_$PRICE$\_$CHANGE$($NOW$,0/0/-1)$ P$/$E Ratio $($TTM$)$P$\_$PRICE$($NOW$)/$FF$\_$EPS$($LTM$,0,$RP$,$USD$)$ Dividend Yields $>\mathrm{.}5\%$FF$\_$DIV$\_$YLD$($CURR$)>=\mathrm{.}53$Yr Beta of the stockP$\_$BETA$\_$PR$(3$Y$)3$Download the results into excel and remove all industries except the one assigned to you. If your industry has more than $12$ companies, remove any that have a negative P$/$E ratio. If you still have more than $12$ companies, select only the first $12($sorted alphabetically$)$ for your portfolio. $4$Put the resulting data into the appropriate columns within the "Portfolio Template" tab and then using that data: $5$Calculate the data highlighted in green, based on $3$ portfolios containing your companies using $3$ different weightings. Equal weighting $($assumes the investor invests an equal $\%$ of her assets in each stock$)$ Market value weighting $($assumes the investor's allocation to each stock is that stock's market capitalization as a $\%$ of the entire portfolio's market capitalization$)$ Company Net Sales weighting $($assumes the investor's allocation to each stock is that stock's Net Sales as a $\%$ of the Net Sales of all stocks in the portfolio combined There are $5$ items to calculate for each of the $3$ portfolios. You'll get $1/3$ mark for each correct answer. Maximum marks $=5$ NOTE: For each portfolio's Treynor Ratio calculation use the $1$ yr $\%$ Price Change as the portfolio return. $6$In the Q$6$ tab, write a paragraph on which of the three portfolios you'd prefer to invest in and why. Refer to the data to justify your answer. $4$ Marks $7$Choose any one of the stocks in your portfolio. Go to the "Charting" tab in Factset and create a chart with the past $10$ years of data showing these $3$ things:The price of the stock.The stock's last $12$ month's earnings per share $($EPS $-$ LTM$)$The stock's price to earnings ratio based on the last $12$ months of eps $($P$/$E $-$ LTM$)$ Take a screenshot of the chart and paste it in tab $"$Q$7"2$ marks $8$A stock's price will change due to either a change in the company's EPS and$/$or a change in the multiple of EPS $($the P$/$E ratio$)$ that investors are willing to pay.Point out a time period in the above graph when the stock price changed due to an increase or decrease in the P$/$E ratio $($while the eps was fairly stable$)$ rather than to a change in the earnings per share $($while the P$/$E ratioremained fairly stable$).2$ marks$9$Which company in your portfolio is most likely to appeal to a "Value" investor and why? $2$ marksWhich company in your portfolio is most likely to appeal to a "Momentum" investor and why?