please solve in excel and show all formulas

2 Must be done in Excel. Show all work, I need to see what cells or Excel functions have been used to get the answers. There are 4 worksheets, each containing a problem. 3 Please use this file as a template and solve each problem on the appropriate worksheet. 4 5 Problem 1 6 Here are data on two companies. The 10-year Treasury Note rate is 4% and the market risk premium is 7% 7 8 Company Victoria Store Houston Store 9 Forecasted return 16% 15% 10 Standard Deviation of Returns 16% 15% 11 Beta 1.4 1 12 13 14 a. Estimate the expected return for each company according to CAPM 15 b. Characterize each company as underpriced, overpriced, or properly priced according to CAPM Another company, Sugar Land store, has a beta of 2.0. Estimate the expected rate of return for a portfolio consisting of 1/3 Victoria stock, 1/3 Houston stock, and 1/3 Sugar Land store. 17 16 c