Please show computations in Excel formula.

Question 1:

Part 1: What three conditions must exist in order to use the constant growth (Gordon Growth) or Dividend Discount models for valuing stocks?

Part 2: Holtzman Clothiers stock currently sells for $35.00 a share. It just paid a dividend of $1.95 per share (i.e. D0 = $1.95). The dividend is expected to grow at a constant rate of 6% a year. What stock price is expected 1 year from now? What is the required rate of return?

Part 3: Scampini Technologies is expected to generate $42 million in free cash flow next year, and FCF is expected to grow at a constant rate of 3.5% per year indefinitely. Scampini has no debt or preferred stock, and its WACC is 8.5%. If Scampini has 50 million shares of stock outstanding, what is the stocks value per share?

Please show computations in Excel formula.