KU Real Estate Club_Case_Study

docx

School

University of Kansas *

*We aren’t endorsed by this school

Course

MISC

Subject

Finance

Date

Feb 20, 2024

Type

docx

Pages

2

Uploaded by DeaconPelicanMaster615

Report
KU Real Estate Club – Case Study 10/30/2023 Morriss Real Estate, LLP (MRE, LLP) is considering purchasing the Downtown Building, which is a 140,000 square foot office building in Philadelphia, Pennsylvania. The asking price of the office building is $20,000,000 with the following tenants and lease terms. Line Downtown Building Tenants Leased Sq. Feet Current Rent per Sq. Foot Annual rent adjustment Annual tenant reimbursement per sq. foot Remaining lease term (years) 1 Medical Clinic 15,000.00 22.00 $ 2.25% 5.00 $ 7 2 Accounting Firm 44,280.00 25.00 $ 2.25% 6.00 $ 2 3 Law Firm 30,000.00 23.00 $ 2.25% 6.00 $ 6 4 Insurance Agency 25,000.00 20.00 $ 2.25% 6.00 $ 7 5 Bank 6,741.00 24.00 $ 2.25% 6.00 $ 4 6 Optometrist 3,612.00 24.00 $ 2.25% 6.00 $ 8 7 Vacancies at market rates: 8 Suite 102 (Vacant) 3,000.00 9 Suite 107 (Vacant) 3,000.00 10 Suite 205 (Vacant) 3,000.00 11 12 Total available space 133,633.00 13 Total building space 140,000.00 14 Common area space 6,367.00 Lease Terms MRE, LLP expects it would borrow 80% of the $20,000,000 purchase price ($16,000,000), which means MRE, LLP’s equity cash investment would be the remaining 20% ($4,000,000). MRE, LLP anticipates the $16,000,000 debt would be a full amortization of 25 years with fixed annual interest rate 5.5%, payable monthly. MRE, LLP’s standard practice is to own and operate the building for 5 years and sell the building at the end of the 5 th year. Additionally, MRE, LLP won’t invest in any project unless the internal rate of return (IRR) on the investment is at least 35%. MRE, LLP anticipates that all the vacant suites would be leased at $24 per square foot without any base annual rent increases and $5 per square foot annual operating expenses reimbursements as follows: 1. Suite 102 could be leased in future year 2. 2. Suite 107 could be leased in future year 3. 3. Suite 205 could be leased in future year 4. Moreover, MRE, LLP anticipates paying the usual 3% commission on the first-year rent to the leasing agent that finds the tenants for the vacant suites. MRE, LLP assumes any tenant coming off lease during the 5-year investment period will automatically renew at the current market rent and avoiding a lease commission. MRE, LLP also anticipates the following additional assumptions about the Downtown Building. Page 1 of 2
KU Real Estate Club – Case Study 10/30/2023 Credit loss % of lease rental revenue [Gross rents - Vacancy] 4.00% Initial operating expense % of lease rental revenue [Gross rents - vacancy] Real Estate Taxes 15.00% Office Expenses 5.00% Insurance 7.00% Repairs & Maintenance 10.50% Advertising 5.00% Management 2.00% Utilities 3.50% Miscellaneous Expenses 2.00% Subsequent years' operating expense increase 2.25% To determine if MRE, LLP should purchase the building you need to compute: 1. The equity value of MRE, LLP’s investment and 2. The equity IRR Page 2 of 2
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