please help me. pleas do this in excel and show me the formulas please.

You are analyzing the U.S. equity market based upon the Sap Industrials Index and using the present value of free cash flow to equity technique. Your inputs are as follows: Beginning FCFE: $80 k=0.11 a. Assuming that the current value for the SeP industrials Index is 4,600, would you underweight, overweight, or market weight the U.S. equity market? Do not round intermediate calculations. Round your answer to the nearest cent. You should the U.S. equity market as the estimated value of the stock of s is the sus Incustrials Index. b. Assume that there is a 2 percent increase in the rate of inflation - what would be the market's value, and how would you weight the u,S. market? Assume that the required return would increase from 11% to 13%, decreasing the value, Also assume that the nomiral cash flow growth rates would increase for al time periods by two percentage points. bo not round intermediate calculations. Round vour answer to the nearest cent You should Industrials Index: the 1,5 , equity market as the estimated value of the stock of $ is than the sep