Question 5
		ABT	COST	EA	FB	Total
	Total Ret	89.31%	39.65%	46.86%	37.51%
	$ Investment	1	1	1	1
	Beta	0.714	1.393	1.904	0.934
	No short-sales is allowed
	If you manage $10,000,000, find the highest return you can obtain if you want to maintain the
	systematic risk of your portfolio equal to 1.11
	(Hint, using the initial value 1 and 1 investment in each stock, calculate Return, beta (if needed) and the use solver)
Question 6
		ABT	COST	EA	FB	Total
	Total Ret	89.31%	39.65%	46.86%	37.51%
	$ Investment	1	1	1	1
	Beta	0.714	1.393	1.904	0.934
	No short-sales is allowed
	If you manage $10,000,000, find the Lowest systematic risk you can obtain if you want to maintain the
	return of your portfolio equal to 40.00%
	(Hint, using the initial value 1 and 1 investment in each stock, calculate Return, beta (if needed) and the use solver)
Question 7
		HES	MTB	TROW	WYNN	Total
	Total Ret	37.51%	18.41%	48.95%	33.92%
	$ Investment	1	1	1	1
	Beta	0.934	1.488	1.050	0.740
	No short-sales is allowed
	If you manage $10,000,000, find the highest return you can obtain if you want to maintain the
	systematic risk of your portfolio equal to 1.15
	(Hint, using the initial value 1 and 1 investment in each stock, calculate Return, beta (if needed) and the use solver)
Question 8
		HES	MTB	TROW	WYNN	Total
	Total Ret	37.51%	18.41%	48.95%	33.92%
	$ Investment	1	1	1	1
	Beta	0.934	1.488	1.050	0.740
	No short-sales is allowed
	If you manage $10,000,000, find the Lowest systematic risk you can obtain if you want to maintain the
	return of your portfolio equal to 20.00%
	(Hint, using the initial value 1 and 1 investment in each stock, calculate Return, beta (if needed) and the use solver)

Question 5
		YHOO	WMT	NFXL	MGM	Total
	Total Ret	28.576%	77.830%	150.000%	80.000%
	$ Investment	1	1	1	1
	Beta	0.911	0.488	1.350	1.600
	No short-sales is allowed
	If you manage $10,000,000, find the highest return you can obtain if you want to maintain the
	systematic risk of your portfolio equal to 1.00
	(Hint, using the initial value 1 and 1 investment in each stock, calculate Return, beta (if needed) and the use solver)
Question 6
		YHOO	WMT	NFXL	MGM	Total
	Total Ret	28.576%	77.830%	150.000%	80.000%
	$ Investment	1	1	1	1
	Beta	0.911	0.488	1.350	1.600
	No short-sales is allowed
	If you manage $10,000,000, find the Lowest systematic risk you can obtain if you want to maintain the
	return of your portfolio equal to 85.00%
	(Hint, using the initial value 1 and 1 investment in each stock, calculate Return, beta (if needed) and the use solver)
Question 7
		MSFT	GOOG	BOA	WMT	Total
	Total Ret	42.797%	100.017%	49.643%	77.830%
	$ Investment	1	1	1	1
	Beta	0.921	0.904	0.934	0.488
	No short-sales is allowed
	If you manage $10,000,000, find the highest return you can obtain if you want to maintain the
	systematic risk of your portfolio equal to 0.6
	(Hint, using the initial value 1 and 1 investment in each stock, calculate Return, beta (if needed) and the use solver)
Question 8
		MSFT	GOOG	BOA	WMT	Total
	Total Ret	42.797%	100.017%	49.643%	77.830%
	$ Investment	1	1	1	1
	Beta	0.921	0.904	0.934	0.488
	No short-sales is allowed
	If you manage $10,000,000, find the Lowest systematic risk you can obtain if you want to maintain the
	return of your portfolio equal to 85.00%
	(Hint, using the initial value 1 and 1 investment in each stock, calculate Return, beta (if needed) and the use solver)