Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

REAL 470 Wal-Mart Distribution Center Wal-Mart has approached you with the opportunity to develop a one million square foot warehouse for them. In typical Wal-Mart

REAL 470 Wal-Mart Distribution Center Wal-Mart has approached you with the opportunity to develop a one million square foot warehouse for them. In typical Wal-Mart fashion, they have given you a “take it, or leave it” final offer. The key terms are: Facility Size 1,000,000 ft2 with 26,000,000 usable cubic feet Lease Term 6 years Rent $7 per ft2 Operating Expenses Wal-Mart pays all operating expenses, utilities, and property taxes Renewal Options 7 year extension at $8 per ft2; a second 7 year extension at $9.50 per ft 2; a third 7 year extension at $11.50 per ft.2. All at Wal-Mart’s choice (i.e. it’s Wal-Mart’s option). Wal-Mart pays all operating expenses, utilities, property taxes, and capital expenditures undertaken during all lease renewal periods. Penalties If the property has not received its Certificate of Occupancy within 9 months, rent falls to $5 per ft.2 during the first 4 years of the lease. If it is not received within 12 months, Wal-Mart is released from all obligations and receives a $3 million penalty payment from the developer. Property Specifications Must meet all design and quality standards associated with a top quality bulk distribution facility. You know the market and feel that the selected location is good, and that the warehouse market is in good supply/demand balance. Vacancy rates are 4% - 5% in quality facilities, while net rents in the market are running about $7.50 - $8 per ft.2. You estimate that your development costs to complete (and hence receive your Certificate of Occupancy) this project within 8 months are: 

Hard Costs $40 millio

Your Development Fee $ 2 millio

Interest Costs $ 3 millio

Land $16 millio

Other Soft Costs $ 9 millio

Total $70 million.

You have a $54 million construction loan lined up with a one-year term for a 7% interest rate. 

You believe that upon completion you can sell the property for a 9% cap rate with Wal-Mart credit as the tenant. Alternatively, you believe you could get a 10-year, 30-year amortization, 6% interest loan for $58 million upon completion (with Wal-Mart as the tenant). Lesser credit tenant quality distribution facilities sell at roughly 10% cap rates. You have a construction bid for the $40 million hard costs from a mid-sized local contractor that contains a guarantee of hard costs. You also have a contract to purchase the land for $16 million, which you can close with your $16 million of available equity (90% of your firm’s net equity). 

Your experience indicates that it should take 30-33 weeks to complete the project and receive your Certificate of Occupancy. It’s decision time. Do you accept their bid or walk away? More importantly, why or why not? Your written analysis should be at least 1 page, double spaced. You should include any calculations that support your answer.


Step by Step Solution

3.51 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

Implied Cap rate is 1007165 424 We are told to take a 3 premium for discount factor 1 DCF Analys... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business in Action

Authors: Courtland Bovee, John Thill

7th edition

9780133773897, 133773892, 978-0133773996

More Books

Students also viewed these Finance questions

Question

How could you apply zero-based budgeting to your personal finances?

Answered: 1 week ago