Question 3 **Medtronic Inc. Project Overview**Medtronic Inc. has an opportunity to supply medical devices to Memorial Hermann, a private hospital in the U.S. The financial details and strategic approaches for this project are outlined below.### Financial Breakdown- **Initial Payment:** Memorial Hermann will pay $4 million upfront when the contract is signed.- **Yearly Payments:** - Year 1: $3 million - Year 2: $1.5 million - Year 3: $7.5 million- **Investment and Costs:** - Medtronic has secured a loan from Bank of America Merrill Lynch before the initial payment from Hermann, investing $2 million at the beginning. - Running costs: - Year 1: $3.5 million - Year 2: $10 million - Year 3: $1.5 million - Year 4: $4 million - Year 5: $3 million- **Payment by Memorial Hermann:** - Year 4: Takes delivery of devices and pays $4.25 million - Year 5: Balance payment of $4.5 million### Rate of Return AnalysisThe decision to continue or downsize staff after the 5-year deal hinges on the Minimum Attractive Rate of Return (MARR). Medtronic management has outlined the following steps for the project analysis:1. **Cash Flow Estimation:** - Create a table to illustrate projected cash flows for the project.2. **Visualization:** - Construct a cash flow diagram.3. **Rate of Return Calculation:** - Determine which rate of return values are applicable for the project.4. **Spreadsheet Analysis:** - Use Microsoft Excel to find rate of return, plotting Present Worth against a range of rate of return values (0% to 100%, with 5% increments).5. **Internal Rate of Return (IRR) Evaluation:** - Calculate for the zero net present worth using Excel.6. **Strategic Recommendation:** - With a set MARR of 15%, consider the impact of the cash flow reinvested at 14% from Memorial Hermann. The funding from Bank of America Merrill Lynch was secured at 7% for device production.This methodical approach will enable Medtronic management to provide informed strategies for future policy and staff considerations in alignment with the

Cash Flow The net amount of cash and cash equivalents being transferred in and out of a corporation…

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.e. 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 had obtained loan from Bank of America Merrill Lynch (an investment bank) prior to the initial payment from Hermann and invest $2 million from it 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 $ 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 year. Medtronic 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 approach 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. 4. Obtain the values for the rate of return using Microsoft Excel (Spreadsheet). These values should be obtain by plotting the Present worth against the range of rate of return values (0 % to 100 %, step increase of 5 %) 5. Evaluate the Internal Rate of Return (IRR) for the zero net present worth using Microsoft Excel Spreadsheet. 6. Medtronic management have set a MARR of 15% for any of their project; will you advise Medtronic to embark on this project knowing the net positive cash flow received from Memorial Hermann is reinvested at 14%. The loan Medtronic obtained from Bank of America Merrill Lynch for the production of the medical devices is borrowed at a rate of 7 %.