Equinix REIT - the largest player in the data center real estate sector, is assessing the acquisition of a data center in Miami, FL. The total estimated cost is $110,000,000. The projected earnings from sales and other income over the next five years are as follows: 
Year 1: $18,000,000 
Year 2: $21,000,000 
Year 3: $33,000,000 
Year 4: $35,000,000 
Year 5: $39,000,000 
Year 6: $41,000,000 
Year 7: $43,000,000 

Equinix also anticipates selling the data center at the end of year 7 for $130,000,000. 

If Equinix's required rate of return is 8%, should this deal be accepted based on its NPV?

 
 
a.

Yes. The NPV is around $130,000,000

 
 
b.

Yes. The NPV is around $250,000,000

 
 
c.

Yes. The NPV is around $350,000,000

 
 
d.

No. The NPV is around $3,100,000

To determine whether Equinix should proceed with the acquisition based on its Net Present Value (NPV), we need to calculate the NPV using the projected cash flows, the sale value of the data center, and Equinix's required rate of return (8%).

Here's the general NPV formula:

\[
\text{NPV} = \sum \frac{C_t}{(1 + r)^t} - C_0
\]

Where:
- $ C_t $ = cash flows in each year (including the sale price in Year 7)
- $ r $ = discount rate (8% in this case, or 0.08)
- $ C_0 $ = initial cost (\$110,000,000)
- $ t $ = year of the cash flow

### Cash Flows:
- Year 1: \$18,000,000
- Year 2: \$21,000,000
- Year 3: \$33,000,000
- Year 4: \$35,000,000
- Year 5: \$39,000,000
- Year 6: \$41,000,000
- Year 7: \$43,000,000 + \$130,000,000 (sale price)

Let's calculate the NPV step by step.The Net Present Value (NPV) of the acquisition is approximately \$129,916,828.

Since the NPV is positive and around \$130,000,000, the acquisition should be accepted, and the correct answer is:

**a. Yes. The NPV is around \$130,000,000.**

Would you like more details or further clarification?

Here are 5 related questions to expand this topic:
1. How is the sale price of the data center factored into the NPV?
2. What would happen if the required rate of return were higher than 8%?
3. How does NPV differ from other investment appraisal techniques, like IRR?
4. What risks might Equinix face in assuming these projected cash flows?
5. How sensitive is the NPV calculation to changes in the sale price?

**Tip:** NPV helps in determining the profitability of an investment, but it's also important to consider risks and assumptions behind cash flow projections.

Equinix REIT - the largest player in the data center real estate sector, is assessing the acquisition of a data center in Miami, FL. The total estimated cost is $110,000,000. The projected earnings from sales and other income over the next five years are as follows:
Year 1: $18,000,000
Year 2: $21,000,000
Year 3: $33,000,000
Year 4: $35,000,000
Year 5: $39,000,000
Year 6: $41,000,000
Year 7: $43,000,000
Equinix also anticipates selling the data center at the end of year 7 for $130,000,000. If Equinix's required rate of return is 8%, should this deal be accepted based on its NPV?

Calculate the NPV for Equinix REIT's acquisition of a $110 million data center in Miami. Projected earnings and sale price are considered over seven years, and we apply an 8% discount rate to determine if the investment should be accepted. Step-by-step solution included.

Math Problem Statement

Solution

Ask a new question for Free

By Image

Math Problem Analysis

Mathematical Concepts

Formulas

Theorems

Suitable Grade Level

Related Recommendation