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

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter15: Ratio Analysis (ratioa)
Section: Chapter Questions
Problem 2R: The comparative financial statements of Global Technology are as follows: Open the file RATIOA from...
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
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning