Please show work and if it can be done in excel I would greatly appreciate you showing or telling me how to do that as well!

2. Suppose you have the following historical information: Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 Bond A Return 2.350 1.670 3.33% 5.4196 6.10% 5.340% 4.11 2.00% 1.01% .68% Stock Z Return -2.11% 8.43% 4.56% 11.44% 9.41% 8.32% 6.34% 2.50% 1.08% -2.36% Market Return 7.12% 6.19% 5.25% 9.50 11.32% 10.42% 8.42% 3.21% -1.99% -2.54% GDP Growth Rate 23% 1.34% 2.96% 4.50% 3.01% 2.1990 1.90% 90% 44% 06% The covariance between Bond A and the market is 8.40% and the covariance between Stock 7 and the market is 17.25%. Historically, GDP growth rates less than 1% represent recessionary years, while GDP growth rates over 2.5% represent booming years. There is an equal 30% chance of a boom and a recession next period, with the remaining being the possibility of a normal cconomy. Anything in the middle is a nomal year a. If you have 25% of your portfolio in Bond A and the rest in Stock Z. what is your expected retum on your portfolio? (10 pts) b. If you have 25% of your portfolio in Bond A and the rest in Stock Z. what is your beta of your portfolio? (10 pts) 2. Suppose you have the following historical information: Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 Bond A Return 2.350 1.670 3.33% 5.4196 6.10% 5.340% 4.11 2.00% 1.01% .68% Stock Z Return -2.11% 8.43% 4.56% 11.44% 9.41% 8.32% 6.34% 2.50% 1.08% -2.36% Market Return 7.12% 6.19% 5.25% 9.50 11.32% 10.42% 8.42% 3.21% -1.99% -2.54% GDP Growth Rate 23% 1.34% 2.96% 4.50% 3.01% 2.1990 1.90% 90% 44% 06% The covariance between Bond A and the market is 8.40% and the covariance between Stock 7 and the market is 17.25%. Historically, GDP growth rates less than 1% represent recessionary years, while GDP growth rates over 2.5% represent booming years. There is an equal 30% chance of a boom and a recession next period, with the remaining being the possibility of a normal cconomy. Anything in the middle is a nomal year a. If you have 25% of your portfolio in Bond A and the rest in Stock Z. what is your expected retum on your portfolio? (10 pts) b. If you have 25% of your portfolio in Bond A and the rest in Stock Z. what is your beta of your portfolio? (10 pts)