ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN: 9780190931919
Author: NEWNAN
Publisher: Oxford University Press
Bartleby Related Questions Icon

Related questions

Question
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 Analysis
The 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
expand button
Transcribed Image Text:**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 Analysis The 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
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Economics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:9780190931919
Author:NEWNAN
Publisher:Oxford University Press
Text book image
Principles of Economics (12th Edition)
Economics
ISBN:9780134078779
Author:Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:PEARSON
Text book image
Engineering Economy (17th Edition)
Economics
ISBN:9780134870069
Author:William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:PEARSON
Text book image
Principles of Economics (MindTap Course List)
Economics
ISBN:9781305585126
Author:N. Gregory Mankiw
Publisher:Cengage Learning
Text book image
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Text book image
Managerial Economics & Business Strategy (Mcgraw-...
Economics
ISBN:9781259290619
Author:Michael Baye, Jeff Prince
Publisher:McGraw-Hill Education