4) Gemini Products makes vitamin-enriched cereal products for large super market chains. They have forecasted the cash flows (in $1,000 units) for this and the next 4 years. a) Determine the Modified Internal Rate of Return (MIRR) by hand using i = 14% and in = 8% per year. b) Use Excel's MIRR function to verify your answer. Turn this in with Problem 2c via Canvas. Year Cash Flows ($1,000's) 0 3 (2) 2 3 (6) 4 3.8 1 1 5) A public-private initiative in Florida will significantly expand the wind-generated energy throughout the state. The cash flow for one phase of the project involving Central Point Energy, a transmission utility company, is shown. a) Determine the Modified Internal Rate of Return (MIRR) by hand using i = 14% and in = 7% per year. b) Use Excel's MIRR function to verify your answer. Turn this in with Problem 2c via Canvas. Year 0 1 Cash Flows ($1,000's) 5 (2) (1.5) (7) 4 2 3 4