Gemini Products makes vitamin-enriched cereal products for large supermarket chains. They have forecasted the cash flows (in $1000 units) for this and the next 4 years. Develop hand and spreadsheet solutions that determine the EROR for

(a) the ROIC method with ir  14% per year, and

(b) the MIRR method with ir  14% and ib  8% per year.

(c) Comment on these two EROR values compared to the IRR value(s) obtained using the IRRfunction

“guess” option to discover multiple roots.

Year Cash Flow, $
0 3000 1 2000 2 1000 3 6000 4 3800