CEIE370 Mount Hope Shopping Project Economic Analysis Assignment 3

User Generated

6ezon

Writing

CEIE370

Description

please find attached file

Assume you are Claire and are trying to determine if the Mount Hope shopping mall is a good investment of your $6.5 million inheritance, using a 20-year period. Assume operation of the facility begins in year 2 and the equity is utilized in year 1.

Determine the:

  • Gross annual revenue
  • Annual Maintenance Costs
  • Net Annual Revenue
  • Estimated Annual Debt Service
  • Estimated Annual Profit
  • Net Present Value of Claire’s investment, if the discount rate = 9%

Internal Rate of Return for the project investment

Unformatted Attachment Preview

THE MOUNT HOPE PROJECT DEVELOPING AN ECONOMIC ANALYSIS CEIE-370 CONSTRUCTION SYSTEMS Assignment 3 – The Mount Hope Project DEVELOPING AN ECONOMIC ANALYSIS Setting: After some time the owner, the architect, and the engineer met again. Claire was very pleased because Tony’s design exceeded her expectations. During this meeting Angie told Claire that it was time for Claire get in contact with a contractor in order to get a good estimate of project costs before talking with the banks. Claire appreciated the design engineer’s advice, because without additional funding there would be no mall. Angie recommended that Claire talk to Cornelius "Corny" Cornell, the owner of Corny Construction & Co., with whom she had good experiences. Claire gave Corny a call and they set an appointment for the next day at Corny's office, where their conversation went like this: Corny: Nice to see you. I hear you have a property you want to develop. What can I do for you? Claire: I hope you can help me with some cost estimates, because soon I have to go to the bank to get funding for the project. I brought you the preliminary drawings from my architect and engineer. What do you think the project will cost? Corny: Let's have a look. That is a well-designed mall. Well, Corny Construction has done some malls before; we will be able to provide you with an estimate. However, first I need to check out the property and what is needed from the site work, utilities, and landscaping points of view. I see you have some estimates on the site development. Whom did you get those from? Claire: The numbers are from "Big Builders.” Corny: Oh, good. I know Bob. I'll give him a call. In addition, I will talk to your architect and your engineer. I'll be done with the estimate in two days, okay? Claire: Great. Which bank do you do business with? Corny: I work with Betsy Benefit from "Best Banking.” She is very reasonable when it comes to lending money. Two days later Claire was back in the office of Corny Construction. While she was waiting for Corny in his office-room, she took a look at his bookshelf. There were some interesting book titles, such as Construction Scheduling, Estimating, Means and Methods, Contract Administration, and Financing Construction Projects. "This is an interesting subject,” she thought. Her thoughts were disturbed when Corny walked in and gave her the list of estimates (see Table 3.1). Based on the information Corny had provided, Claire realized that she would need a loan of $25,330,000 to complete construction of the project, after the use of the $6.5 million inheritance. She estimated the interest on the loan would be 7.5 percent, compounded annually over a 20-year period. Claire also estimated that she could expect $30 per square foot of rental space (150,000 SF) and that her maintenance and operating costs would be approximately 2 percent of total cost of the project. She began to wonder exactly how much profit (if any) she could expect to make from the project while she was paying off such a substantial loan over the next twenty years. It would be necessary to convey this to the bank to receive funding. After she returned to her office, Claire set about developing a profit picture for the Mount Hope shopping facility to determine if the project was economically feasible. Table 3.1: Parameter Estimate of Costs for the Mount Hope Market Item Description Estimated Cost $ 1 Land 2 Bob Builder consulting fee 50,000 3 Corny Cornell consulting fee 34,000 4 Architect fee 5 Permitting cost 6 Design & consulting engineer fee 7 Grading and site work sub 8 Construction of shopping facility 9 Construction of parking lot 2,027,000 10 Installation of utilities by sub 1,435,000 11 Installation of electrical reticulation by sub 248,000 12 Landscaping sub 304,000 13 Allowance for fees of loans and interests Total 2,945,000 105,000 25,000 165,000 2,487,000 17,573,000 4,436,000 31,834,000 Assignment 3 Assume you are Claire and are trying to determine if the Mount Hope shopping mall is a good investment of your $6.5 million inheritance, using a 20-year period. Assume operation of the facility begins in year 2 and the equity is utilized in year 1. Determine the: • • • • • • • Gross annual revenue Annual Maintenance Costs Net Annual Revenue Estimated Annual Debt Service Estimated Annual Profit Net Present Value of Claire’s investment, if the discount rate = 9% Internal Rate of Return for the project investment Prepare a memo summarizing your findings from above and make a firm recommendation as to whether the project is a sound investment.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached is the full answer. Please check it over and make sure it’s good to go before signing-off on the work. Should you have any queries don't hesitate to reach out

Inheritance
Loan
Loan interest (p.a)
Period
Rental space (SF)
Rental revenue ($/SF)
Maintenance cost (p.a)

$
6,500,000.00
$ 25,330,000.00
7.50%
20years
150,000.00
$
30.00
$
636,680.00

1
2
Bal b/f
$ 25,330,000.00 $ 27,229,750.00 $
Interest (7.5%)
$
1,899,750.00 $
2,042,231.25 $
Est. Annual Debt Service (Bal
$ c/d)
27,229,750.00 $ 29,271,981.25 $

Gross Revenue
Finance cost
1,899,750.00
Net Annual Revenue
(1,899,750.00)
Maintenance & Operating Cost
Est. Annual Profit/(loss)
(1,899,750.00)

Period
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

Cash flows ($)
(31,834,000.00)
(1,899,750.00)
1,821,088.75
1,667,921.41
1,503,266.51
1,326,262.50
1,135,983.19
931,432.93
711,541.40
475,158.0...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags