FINANCE HOMEWORK HELP

copy_of_portfolio_1.xlsx

Sheet1

							Portfolio # 1
							Fidelity® Mega Cap Stock Fund
current fund price				$16.39
10 yrs total return
History (03/31/2015)	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014
FGRTX	7.48	12.84	11.05	-39.41	28.61	14.41	2.34	19.42	33.23	11.66
S&P 500 TR USD	4.91	15.79	5.49	-37	26.46	15.06	2.11	16	32.39	13.69
				10 yrs Annual report Net Expense Ratio
History (03/31/2015)	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014
	0.81	0.82	0.81	0.74	0.78	0.79	0.78	0.75	0.7	0.68
					mpt statistic 10 yrs measure
	R-Squared	Beta	Alpha	Treynor Ratio	Currency
3/31/15
vs. Standard Index
FGRTX	S&P 500 TR USD	97.33	1.04	0.07	6.58
					Volatility Measure (10yrs measure)
Standard	Return	Sharpe Ratio	Sortino Ratio	Bear Market
Deviation				Percentile Rank
3/31/15
FGRTX	15.63	8.3	0.5	0.72	—
S&P 500 TR USD	14.76	8.01	0.5	0.71

name						GuideStone Funds ExtendedDuration Bond Fund Investor Class"
current fund price			$18.56
						10 yrs total return
History (03/31/2015)	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	YTD
GEDZX	5.54	4.49	8.36	-8.29	24.97	12.06	13.14	15.06	-5.29	17.39	2.62
Barclays US Agg Bond TR USD	2.43	4.33	6.97	5.24	5.93	6.54	7.84	4.21	-2.02	5.97
						10 yrs Annual report Net Expense Ratio
History (03/31/2015)	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	YTD
GEDZX	5.54	4.49	8.36	-8.29	24.97	12.06	13.14	15.06	-5.29	17.39	2.62
Barclays US Agg Bond TR USD	2.43	4.33	6.97	5.24	5.93	6.54	7.84	4.21	-2.02	5.97
					mpt statistic 10 yrs measure
	Index	R-Squared	Beta	Alpha	Treynor Ratio
GEDZX	Barclays US Agg Bond TR USD	68.49	2.46	-1.14	2.91
					Volatility Measure (10yrs measure)
Standard	Return	Sharpe Ratio	Sortino Ratio	Bear Market
Deviation				Percentile Rank
9.8	8.61	0.74	1.15

name						Dodge & Cox International Stock
current fund price			$44.00
						10 yrs total return
History (03/31/2015)	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014
DODFX	16.75	28.01	11.71	-46.69	47.46	13.69	-15.97	21.03	26.31	0.08
MSCI ACWI Ex USA NR USD	16.62	26.65	16.65	-45.53	41.45	11.15	-13.71	16.83	15.29	-3.87
							10 yrs annual report Net Expense Ratio
History (03/31/2015)	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014
	0.7	0.66	0.65	0.64	0.65	0.65	0.64	0.64	0.64	0.64
					MPT statistic 10 yrs measure
10-Year Trailing	Index	R-Squared	Beta	Alpha	Treynor Ratio
DODFX	MSCI ACWI Ex USA NR USD	95.75	1.07	1.39	5.2
					Volatility Measure
10-Year Trailing	Standard	Sharpe Ratio	Sortino Ratio
	Deviation
DODFX	20.5	0.36	0.52
MSCI ACWI Ex USA NR USD	18.81	0.3	0.42

name						Fidelity® Government MMkt
current fund price			$1.00
						10 yrs total return
History (03/31/2015)	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014	YTD
SPAXX	2.87	4.73	4.88	2.31	0.32	0.01	0.01	0.01	0.01	0.01	0
USTREAS T-Bill Auction Ave 3 Mon	3.34	5.06	4.77	1.51	0.16	0.14	0.06	0.09	0.06	0.03
						10 yrs Annual Report Net Expense Ratio
History (03/31/2015)	2005	2006	2007	2008	2009	2010	2011	2012	2013	2014
	0.42	0.42	0.42	0.41	0.44	0.35	0.26	0.16	0.19	0.11
		MPT Statistics 10 yrs measure
10-Year Trailing	Index	R-Squared	Beta	Alpha	Treynor Ratio
SPAXX	USTREAS T-Bill Auction Ave 3 Mon
		Volatility Measures (10 yrs)
10-Year Trailing	Standard	Sharpe Ratio	Sortino Ratio
	Deviation
SPAXX	0.56	0.1	0.19
USTREAS T-Bill Auction Ave 3 Mon	0.57