CCM is currently comparing 4 DDC machines (DDC1, DDC2, DDC3, and DDC4) and they plan to procure one of them. CCM's MARR is 15% and the expected useful life of the DCC machine is six years.   Use incremental cash flow analysis to determine the economically optimal option. Solve this problem in Excel (IRR), copy/paste a screenshot of your Excel model below and provide an e

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
icon
Concept explainers
Topic Video
Question

CCM is currently comparing 4 DDC machines (DDC1, DDC2, DDC3, and DDC4) and they plan to procure one of them. CCM's MARR is 15% and the expected useful life of the DCC machine is six years.

 

Use incremental cash flow analysis to determine the economically optimal option. Solve this problem in Excel (IRR), copy/paste a screenshot of your Excel model below and provide an explanation.

### Comparative Analysis of Data Centers (DDCs)

The table below provides a comparative analysis of four data centers (DDC1, DDC2, DDC3, and DDC4) based on their Purchase Price, Annual Revenues, Annual Expenses, Residual Value, and Study Period.

| Aspect                | DDC1       | DDC2       | DDC3       | DDC4       |
|-----------------------|------------|------------|------------|------------|
| **Purchase Price**    | $500,000   | $620,000   | $550,000   | $600,000   |
| **Annual Revenues**   | $100,000   | $155,000   | $110,000   | $120,000   |
| **Annual Expenses**   | $25,000    | $30,000    | $30,000    | $30,000    |
| **Residual Value**    | $60,000    | $125,000   | $90,000    | $100,000   |
| **Study Period**      | 6 Years    | 6 Years    | 6 Years    | 6 Years    |

#### Detailed Insights:

1. **Purchase Price**:
   - The cost to acquire each data center varies, with DDC1 being the cheapest at $500,000 and DDC2 being the highest at $620,000.

2. **Annual Revenues**:
   - This represents the income each data center is projected to generate annually. DDC2 has the highest annual revenue at $155,000, while DDC1 has the lowest at $100,000.

3. **Annual Expenses**:
   - These are the yearly operating costs for each data center. 
   - DDC1 has the lowest annual expenses at $25,000, while DDC2, DDC3, and DDC4 have higher expenses, each being $30,000.

4. **Residual Value**:
   - This indicates the remaining value of the data center after the study period.
   - DDC2 has the highest residual value at $125,000, whereas DDC1 has the lowest at $60,000.

5. **Study Period**:
   - This denotes the time frame over which the economic analysis is conducted. 
   - All data centers have a study period of 6 years.

This detailed comparison helps in
Transcribed Image Text:### Comparative Analysis of Data Centers (DDCs) The table below provides a comparative analysis of four data centers (DDC1, DDC2, DDC3, and DDC4) based on their Purchase Price, Annual Revenues, Annual Expenses, Residual Value, and Study Period. | Aspect | DDC1 | DDC2 | DDC3 | DDC4 | |-----------------------|------------|------------|------------|------------| | **Purchase Price** | $500,000 | $620,000 | $550,000 | $600,000 | | **Annual Revenues** | $100,000 | $155,000 | $110,000 | $120,000 | | **Annual Expenses** | $25,000 | $30,000 | $30,000 | $30,000 | | **Residual Value** | $60,000 | $125,000 | $90,000 | $100,000 | | **Study Period** | 6 Years | 6 Years | 6 Years | 6 Years | #### Detailed Insights: 1. **Purchase Price**: - The cost to acquire each data center varies, with DDC1 being the cheapest at $500,000 and DDC2 being the highest at $620,000. 2. **Annual Revenues**: - This represents the income each data center is projected to generate annually. DDC2 has the highest annual revenue at $155,000, while DDC1 has the lowest at $100,000. 3. **Annual Expenses**: - These are the yearly operating costs for each data center. - DDC1 has the lowest annual expenses at $25,000, while DDC2, DDC3, and DDC4 have higher expenses, each being $30,000. 4. **Residual Value**: - This indicates the remaining value of the data center after the study period. - DDC2 has the highest residual value at $125,000, whereas DDC1 has the lowest at $60,000. 5. **Study Period**: - This denotes the time frame over which the economic analysis is conducted. - All data centers have a study period of 6 years. This detailed comparison helps in
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education