Can you please show we step wise how to do it using excel solver? Thankyouu 2-42. HiRise Construction can bid on two 1-year projects. The following table provides the quarterly cash flow (in millions of dollars) for the two projects. January 1 Cash flow (in millions of S) at April October 1 -3.1 -1.5 1.8 -25 1.5 1.8 Project 1 II July 1 -1.0 December 31 5.0 2.8 HiRise has cash funds of $1 million at the beginning of each quarter and may borrow at most $1 million at a 10% nominal annual interest rate. Any borrowed money must be returned at the end of the quarter. Surplus cash can earn quarterly interest at an 8% nominal annual rate. Net accumulation at the end of one quarter is invested in the next quarter. (a) Assume that HiRise is allowed partial or full participation in the two projects. Determine the level of participation that will maximize the net cash accumulated on December 31. Solve the model using Solver or AMPL. (b) Is it possible in any quarter to borrow money and simultaneously end up with surplus funds? Explain Can you please show we step wise how to do it using excel solver? Thankyouu 2-42. HiRise Construction can bid on two 1-year projects. The following table provides the quarterly cash flow (in millions of dollars) for the two projects. January 1 Cash flow (in millions of S) at April October 1 -3.1 -1.5 1.8 -25 1.5 1.8 Project 1 II July 1 -1.0 December 31 5.0 2.8 HiRise has cash funds of $1 million at the beginning of each quarter and may borrow at most $1 million at a 10% nominal annual interest rate. Any borrowed money must be returned at the end of the quarter. Surplus cash can earn quarterly interest at an 8% nominal annual rate. Net accumulation at the end of one quarter is invested in the next quarter. (a) Assume that HiRise is allowed partial or full participation in the two projects. Determine the level of participation that will maximize the net cash accumulated on December 31. Solve the model using Solver or AMPL. (b) Is it possible in any quarter to borrow money and simultaneously end up with surplus funds? Explain