1. Using the stocks in your initial portfolio, prepare a valuation of each stock and the initial portfolio using zero, constant or variable growth models with a market return at 8% and at 12%. [Note that the growth rate must be less than the required rate of return.]

2. Is the stock of each of these companies over or undervalued?

3. What is the expected return using the CAPM model?

4. Prepare a time series ratio analysis (liquidity, activity, debt, and profitability). Identify any events during the period that may have caused the stocks prices to increase or decrease, explaining how these events affect the stocks prices.

(Information below)

	# of Shares Purchased for Each Stock	Closing Prices as of 09/07/2017	Last Dividend Paid Date and Amount	Expected Next Ex-dividend and Paid Dates	Total Investment	Beta	Closing Prices as of 11/03/2017	Value of Investment
A Company	2750	161.26	05/18/17 $0.63	08/10/17 $0.63	2750 * 161.26 = 443465	1.155	172.5	2750 * 172.5 = 474375
H Company	1550	28.22	03/07/17 $0.187	03/28/17 $0.189	1550 * 28.22 = 43741	0.9975	32.87	1550 * 32.87 = 50948.5
N Company	2550	52.39	07/05/17 $0.18	08/31/17 $0.18	2550 * 52.39 = 133594.5	1.0325	55.71	2550 * 55.71 = 142060.5
V Company	1675	46.2	08/01/17 $0.577	10/06/16 $0.59	1675 * 46.2 = 77385	0.94	47.42	1675 * 47.42 = 79428.5
W Company	2550	80.12	09/05/17 0.51	12/07/17 $0.51	2550 * 80.12 = 204306	0.85	89.68	2550 * 89.68 = 228684
Total Investment:					(2750*161.26)+(1550*28.22)+(2550*52.39)+(1675*46.2)+(2550*80.12)= 902491.5
Amount Held in Cash:	1000000-(2750*161.26)-(1550*28.22)-(2550*52.39)-(1675*46.2)-(2550*80.12)= 97508.5

	Total Investment	Beta	Investment * Beta
A Company	443465	1.155	512202.075
H Company	43741	0.9975	43631.6475
N Company	133594.5	1.0325	137936.3212
V Company	77385	0.94	72741.9
W Company	204306	0.85	173660.1
Total	902491.5		940172.0437
	940172.0437 / 902491.5 = Portfolio Beta 1.04175