BIC 2023 Updated

docx

School

University Of Georgia *

*We aren’t endorsed by this school

Course

MISC

Subject

Finance

Date

Feb 20, 2024

Type

docx

Pages

9

Uploaded by DukeEmu1537

Report
Module 4 Assignment Class Time: 9:35T/TR Group Number: ____12___ Semester Group Members (eLC Last Name, First Name): 1. ___Campbell Pitzer________ 2. ____Hunter Benson______________ 3. ____Lily Mahoney______________ 4. ___Emily Miller___________ Bulldog Investment Company (BIC) recently sold a property from their portfolio and is now considering new investment options. Your group’s task is to determine which one of the following properties BIC should purchase. The cost of any of the options is not a concern. This assignment meets the Module 4 Learning Objective of being able to compute present values and make investment decisions using DCF and NPV for CRE. An additional important takeaway is how each investment option can be compared directly because individual risk has already been factored into the analysis. Each question has one correct answer; therefore, no partial credit is available. Please make your answers clear by highlighting them in some way. The deliverable is one team copy of this document. The assignment is due by 9/22 by 5 pm to the eLC dropbox. Any late assignments will reduce the grade by 10% per day. Since the deliverable is a team project and the grade reduction applies to all, a strong recommendation is to submit the assignment well before 5pm so that all team members can verify the submission by the chosen member.
Final recommendation: Which property does your team recommend and why? (5 points for each answer) We recommend the Tiger Town Investment as we have calculated this investment to have the highest NPV without appearing to be “too good to be true”. BIC’s extensive market analysis gave the company confidence that they can complete capital improvements to increase rents. This need for capital improvements may contribute to the Bulldog Investment Company having leverage and as a result, being able to purchase this property at the discount resulting in the large positive NPV. Additionally, the extensive market analysis points to this being a good investment. DCF and NPV analysis is only as good as the input numbers (GIGO). Subsequently, our investment decisions are only as good as the quality of the cash flow and discount rate assumptions that go into the right-hand side of the DCF valuation formula. While based on the given market data, does one of these investment opportunities appear to be too good to be true and why? (5 points for each answer) The investment opportunity of purchasing raw land for an office and retail complex seems as though it may be too good to be true. Bulldog Investment Company would likely need to seek additional demographic information to determine whether or not an NPV of over $2 Million for the retail property is realistic depending on if the local economy could support the retailers present. It is important that the company considers which types of retailers could fill the space. Office and Retail space are currently riskier product types so it is necessary for the company to proceed with caution. However, it is important to note that because development is generally a higher risk venture, higher rewards can be expected. Consequently, it is more likely that a development venture would have a higher NPV that is not necessarily indicative of being “too good to be true” as opposed to a more black and white “buyer and seller” transaction for an already stabilized property where such massive discounts are unlikely to occur. Regardless, it would be important to conduct market research to ensure that the community could sustain such a large retail facility. The first property is the Empty Arms hotel. Next year’s NOI and cash flow is expected to be $900,000 and BIC’s forecast of market supply and demand and vacancy levels indicates that these factors will continue to be in balance. As a result, NOI should
increase by 2 percent each year and BIC believes they should earn 10% total return on the investment. A) If Empty Arms is like other recently sold properties, what is the cap rate in the local market? (5 points) Cap rate= NOI/ property value R=y+g Cap Rate = 8% B) What is the estimated value of the property? (5 points) Value= NOI/Cap rate Value = $11,250,000.00 C) Thinking only of this property and not the other options yet, should BIC purchase this investment if the negotiated asking price is $11.25M and why? Answer this question and all others that ask for a recommendation in the form of: Yes/No, the NPV = +/- $xxxxxx (5 points for each answer) Yes, the NPV=0. An NPV of zero is not only profitable but expected during transactions as both the buyer and seller must benefit for the transaction to occur (Transaction Price = Market Value, or there would be no transaction). The second property is Tiger Town. BIC has done an extensive market analysis and has estimated that, based on the current rents and operating expenses, the annual NOI will be $1,200,000 next year. The NOI will be flat for a few years until capital improvements allow BIC to increase rents. After which, NOI is expected to increase by 1.5% per year
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
indefinitely. Bulldog believes that investors should earn 9.5% total return on this type of investment, which is therefore the discount rate. End of Year NOI 1 1,200,000.00 2 1,200,000.00 3 1,200,000.00 4 1,218,000.00 5 1,236,270.00 6 1,254,814.05 7 1,273,636.26 8 1,292,740.80 A) While this specific property does not exhibit constant growth, we can determine the market cap using the returns relationship. Recalling Equation (2) in Chapter 9, what current cap rate should be found in the market for similar properties? (5 points) (Y= CF/V). R= y+g à 9.5% = y + 1.5% à Cap Rate =8% B) Assuming the investment will be owned for 7 years and then sold, what is the present value of the property? Assume the cap rate in year 7 is the one computed in part A. (10 points) The present value of the property is $14,606,868.05 C) What is the NPV if the final negotiated purchase price is $14,500,000? Be clear if it is positive or negative. (5 points) If the final negotiated purchase price is $14,500,000 the NPV = $106,868.05
BIC also likes the idea of a development project and is considering the purchase of some raw land. A lot that is currently undergoing a change in zoning can support either an office building or a retail complex. Based upon market data, BIC has made the following estimates. The income and expense values are at the end of the current year (i.e., standard direct capitalization to determine the present value of the benefits) and the costs are in present value terms. Use the categories of EGI, OE, and NOI to compute the PV benefits. Office Retail Effective rentable annual square feet (net of vacancy) 86,00 0 89,000 Effective rent per annual square foot (net of vacancy) $22.0 $28.00
0 Operating expense ratio 45% 40% Average growth in NOI per annum 1.5% 2.0% Required total return 10.0% 11.0% Total building construction cost per effective rentable square foot $95 $113 Land cost $4M $4M A) What is the NPV of office venture? (10 points) NPV= MV - TP $72,352 .94 B) What is the NPV of retail venture? (10 points) $2,556,333.22 The last investment option for BIC is a run-down building on 1 acre of land called Crystal Estates. They expect to rent the building as a storage facility, which will yield an NOI of $105,000 next year. Because of the wear on the building, BIC expects cash flows to decline at the rate of 1% per year indefinitely. BIC estimates it will earn a total return of 6.5%. A) What is the NPV of this property in its current condition if the purchase price is $1.2M? (5 points) NPV = MV – TP MV= 105,000/7.50% cap rate, cap rate= 6.5% - (-1%) = 7%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
NPV= $1,400,000 – $1,200,000 NPV = $200,000 Now assume that after 4 years the building will be demolished, and the land will be redeveloped into a strip retail property during year 5. There thus is income from the storage facility for 4 years as stated above, and then zero income in year 5. At the end of year 5, the new property will cost $700,000 to development, yield $240,000 per year beginning in year 6 (still end mode), and grow at 2% per year indefinitely. Investors currently earn a total return of 13% on recently built strip retail investments, which is applicable starting in year 6 after the building is finished and rented. The PV at the EOY 5 should be discounted back to today using the 13% discount rate. B) What is the new present value assuming the storage facility for 4 years and then the retail mall in year 6 and after? (5 points) Present Value = $1,158,900.70 C) What is the NPV assuming the redevelopment if the final negotiated price for the land is the same $1.2M? (5 points) NPV= MV-TP NPV= -$41,099.3
Acknowledgement of Work Including this assignment, many of the assessments for the rest of the semester are team projects. Working with other students is an important component of your education as many employers’ assignments are completed as teams. To confirm adequate contribution by all, each team member must sign or type their name and describe their contribution to this project. Dr. Hayunga will not initially assess the specific level of effort by each student; nevertheless, students’ signatures are an acknowledgement of their contribution that is agreed upon by the team members. If there are any contribution issues, students should understand that adding their name to an assignment without contributing sufficiently is a violation of the UGA Honor Code and Dr. Hayunga is required to submit the violation to the University. Team member #1 ___Campbell Pitzer______________ Contribution including percentage: 25% We all worked on the problems together through a FaceTime call and word document. I created the shared word document and took notes in class on the assignment to refer back to. Team member #2 ____Hunter Benson______________ Contribution including percentage: 25% We all worked on the problems together through a FaceTime call and word document. Team member #3 ______Lily Mahoney_____________ Contribution including percentage: 25% I created our shared excel file and completed cash flow tables and proformas necessary to complete the assignment.
Team member #4 _______Emily Miller__________________ Contribution including percentage: 25% We all worked on the project together over facetime and created a shared excel file to calculate the answers on.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help