Please attach an excel sheet with the formulas. I want the formulas most importantly.

CLOSING CASE E A JOB AT EAST COAST YACHTS, PART 2 You are discussing your 401(k) with Dan Ervin when he mentions that Sarah Brown, a representative from Bledsoe Financial Services, is visiting East Coast Yachts today. You decide that you should meet with Sarah, so Dan sets up an appointment for you later in the day. When you sit down with Sarah, she discusses the various investment options available in the company's 401(k) m account. You mention to Sarah that you researched East Coast Yachts before you accepted your newjob. You are confident in management's ability to lead the company. Analysis of the company has led to your belief that the company is growing and will achieve a greater market share in the future. You also feel you should support your employer. Given these considerations, along with the fact that you are a conservative investor, you are leaning toward investing 100 percent of your 401(k) account in East Coast Yachts. Assume the risk-free rate is the historical average risk-free rate (in Chapter 10). The correlation between the bond fund and the large-cap stock fund is .16. (Note'The spreadsheet graphing and \"Solver\" functions may assist you in answering the following questions.) Chapter 11 A Job at East Coast Yachts, Part 2 Input area: 10-year annual return Standard deviation Bledsoe Large Company Stock Fund 10.73% 26.73% Bledsoe Bond Fund 8.04% 10.34% Risk-free rate (historic) 3.60% Correlation 0.16Portfolio standard Weight of stock fund Portfolio E(R) deviation 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Dominant portfolio: Weight of stock fund 17.27% Weight of bond fund Standard deviation Expected return Minumum variance portfolio: Weight of Bledsoe large cap stock fund Weight of Bledsoe bond fund Expected return Variance Standard deviation