excel w formulas pls

Investment Opportunities: 1. Solar Power Plant Investment. Energy Wells Inc is considering investment in a Solar Power Plant. The investment project requires an initial investment of $2,500,000. The projected cash flows over the next five years are as follows: 2. Wind Farm Investment. Energy Wells Inc is considering an investment opportunity to acquire a Wind Farm, which would require an initial investment of $3,000,000. The projected cash flows over the next five years are as follows: Your task is to assess both projects based on the provided data and recommend the most viable investment. Stock Valuation: Determine the value of Energy Wells' common stock using the Dividend Discount Model (DDM). Energy Wells expects to pay \$5 dividends next year and the company's dividends are expected to grow at a constant rate of 4%, and the required rate of return for the stock is 10%. (5points)