I know you cant attatch an excel but please post a screenshot of yours so I can see, also please answer all questions

You have been hired as an equity analyst and asked to estimate the stock price of Target Corporation (TGT). See the questions on page 2. After examining its financials and growth expectations, you decide to use the dividend discount models (DDM) and price-multiples approaches to estimate the intrinsic value of Target. Target's stock price, earnings per share (EPS), and dividends per share (DPS) for the past 5 years are given below. Analysts have estimated Target's perpetual constant dividend growth rate at 8%. Dividends are projected to increase at an annual rate of 10% in the next five years (2023-27). Beyond 2027, the annual dividend growth is expected to slow down to a constant growth rate of 8%. Target's beta is estimated at 1.0. The current U.S. 10-year Treasury bond yield is 5%. Historically, the market risk premium in the U.S. stock market has been estimated as 6%. The required return of a stock or the discount rate is estimated using the Capital Asset Pricing Model (CAPM) equation. You have compiled the projected earnings per share for 2023 for Target and Walmart in the retail store industry. Assume the last year (2022) as year zero. Your assignment is to value Target as of October 2023. Answer the following questions. 1. What is the value of Target using the constant dividend growth model? (20 pts) 2. What is the value of Target using the two-stage dividend growth model? (40 pts) 3. What is the value of Target using the past 5-year average price-earnings multiple of Target? (20 pts) 4. What is the value of Target using the forward Price-earnings multiple of Walmart? (15 pts) 5. Would you recommend buying Target stock? How would the current and expected U.S. and global economic environment impact your decision? Explain clearly and completely. (5 points) Prepare solutions to the above questions in Excel. Submit the Excel spreadsheet as well as a PDF of the spreadsheet (in portrait) via Canvas. Please make sure to show all your calculations and describe any assumptions