Class Project Assignment is: Medtronic Inc. has an opportunity to supply medical devices to Memorial Hermann, a private hospital in the United States. Memorial Hermann will pay $4 million upfront i.c. when the contract is signed and $3 million for the first year. $1.5 million for the second year and $7.5 million for the third year Medtronic had obtained loan from Bank of America Merrill Lynch (an investment bank) prior to the initial payment from Hermann and invest s million from at the beginning of the project. Subsequently. Medtronic spend $3.5 million, $10 million $1.5 million. 4 million, and $3 million as running cost for the first second third, fourth and fifth year respectively, Memorial Hermann will take delivery of the medical devices during year 4, and agrees to pay $4.25 million at the end of that year and the S 4.5 million balance at the end of year 5. The outcome of the rate of return on this investment as compare with the minimum attractive rate of return (MARR) will determine if Medtronic will continue to sustain their current staff strength or they will cede to the option of downsizing after the completion of the 5 year deal. Medtronic management request her project management team to conduct an economic analysis on the proposed venture (project) so that they can be better informed on policy formulation in readiness for any exigency that may result from the project. These exigencies include but not limited to staff downsizing, staff retainment, salary freezing, and salary cut or closing down some of their plants since they are multinational company The project management team is planning to upproach the task as follows: 1. Generate a table depicting the cash flow estimates for the Project 2. Draw the cash flow diagram for the cash flow estimates 3. Determine the number of rates of return values this project is likely to have Class Project Assignment is: Medtronic Inc. has an opportunity to supply medical devices to Memorial Hermann, a private hospital in the United States. Memorial Hermann will pay $4 million upfront i.c. when the contract is signed and $3 million for the first year. $1.5 million for the second year and $7.5 million for the third year Medtronic had obtained loan from Bank of America Merrill Lynch (an investment bank) prior to the initial payment from Hermann and invest s million from at the beginning of the project. Subsequently. Medtronic spend $3.5 million, $10 million $1.5 million. 4 million, and $3 million as running cost for the first second third, fourth and fifth year respectively, Memorial Hermann will take delivery of the medical devices during year 4, and agrees to pay $4.25 million at the end of that year and the S 4.5 million balance at the end of year 5. The outcome of the rate of return on this investment as compare with the minimum attractive rate of return (MARR) will determine if Medtronic will continue to sustain their current staff strength or they will cede to the option of downsizing after the completion of the 5 year deal. Medtronic management request her project management team to conduct an economic analysis on the proposed venture (project) so that they can be better informed on policy formulation in readiness for any exigency that may result from the project. These exigencies include but not limited to staff downsizing, staff retainment, salary freezing, and salary cut or closing down some of their plants since they are multinational company The project management team is planning to upproach the task as follows: 1. Generate a table depicting the cash flow estimates for the Project 2. Draw the cash flow diagram for the cash flow estimates 3. Determine the number of rates of return values this project is likely to have