KU Real Estate Club_Case_Study
docx
keyboard_arrow_up
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
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
Related Documents
Related Questions
whitout exel please Trident Office is considering
remodeling the office building it leases to Robert
Roberts, CPA. The remodeling costs are estimated at
$225,000. If the building is remodeled, Robert Roberts,
CPA has agreed to pay an additional $75,000 per year in
rent for the next five years. The discount rate is 10
percent. What is the benefit of the remodeling project to
Professional Properties?
a. $69,158.56
b. $59,309.01
c. -$69,158.56
d. $68,399.15
e. - $61,417.03
arrow_forward
i need the answer quickly
arrow_forward
eBook
Differential Analysis Report Involving Opportunity Costs
Five Star is considering leasing a building and buying the necessary equipment to operate a public warehouse. Alternatively, the company could use the funds to invest in $149,200 of 6% U.S. Treasury bonds that mature in 16 years. The bonds could be purchased at face value. The following data have been assembled:
Cost of equipment
$149,200
Life of equipment
16 years
Estimated residual value of equipment
$27,200
Yearly costs to operate the warehouse, excluding
depreciation of equipment
$55,600
Yearly expected revenues—years 1-8
84,700
Yearly expected revenues—years 9-16
74,000
Required:
1. Prepare a differential analysis report of the proposed operation of the warehouse for the 16 years as compared with present conditions.
Five StarProposal to Operate Warehouse
Differential revenue from alternatives:
$Revenue from operating warehouse
Revenue from investment in bonds…
arrow_forward
Differential Analysis Involving Opportunity Costs
On July 1, Campus Stores Inc. is considering leasing a building and purchasing the necessary equipment to operate a retail store. Alternatively, the company could use the funds to invest in $1,500,000 of 2% U.S. Treasury bonds that mature in 15 years. The bonds could be purchased at face value. The following data have been assembled:
Line Item Description
Amount
Cost of store equipment
$1,500,000
Life of store equipment
15 years
Estimated residual value of store equipment
$75,000
Yearly costs to operate the store, excludingdepreciation of store equipment
$320,000
Yearly expected revenues—years 1-6
$400,000
Yearly expected revenues—years 7-15
$600,000
Required:
Question Content Area
1. Prepare a differential analysis as of July 1 presenting the proposed operation of the store for the 15 years (Alternative 1) as compared with investing in U.S. Treasury bonds (Alternative 2). If an amount is zero, enter "0". If…
arrow_forward
Quantitative Problem 1: Findley Furniture Company must install $5.9 million of new equipment in one of its plants. It can obtain a bank loan for 100% of the required amount. Alternatively, management believes it can arrange a
lease. Assume that the following facts apply:
1. The equipment falls in the MACRS 5-year class. The applicable MACRS rates are 20%, 32%, 19%, 12%, 11%, and 6%.
2. The lease includes maintenance, whereas if the equipment is purchased, it would require maintenance provided by a service contract for $120,000 per year, payable at the end of the year.
3. Findley's federal-plus-state tax rate is 35%.
4. If the money is borrowed, the bank loan will be at a rate of 10%, amortized in 5 equal installments to be paid at the end of each year.
5. The tentative lease terms call for end-of-year payments of $1.25 million per year for 5 years.
6. At the end of the lease term, the equipment will have an estimated salvage value of $950,000. At that time, Findley plans to replace the…
arrow_forward
DONT GIVE ANSWER IN IMAGE FORMAT
arrow_forward
Apo
Don't upload any image please
arrow_forward
Differential Analysis Involving Opportunity Costs
On August 1, Rantoul Stores Inc. is considering leasing a building and purchasing the necessary equipment to operate a retail store. Alternative
company could use the funds to invest in $1,000,000 of 4% U.S. Treasury bonds that mature in 15 years. The bonds could be purchased at face
The following data have been assembled:
Cost of store equipment
$1,000,000
Life of store equipment
15 years
Estimated residual value of store equipment
$50,000
Yearly costs to operate the store, excluding
depreciation of store equipment
$200,000
Yearly expected revenues-years 1-6
$300,000
Yearly expected revenues-years 7-15
$400,000
Required:
1. Prepare a differential analysis as of August 1 presenting the proposed operation of the store for the 15 years (Alternative 1) as compared with
investing in U.S. Treasury bonds (Alternative 2). If an amount is zero, enter "0".
Differential Analysis
Operate Retail (Alt. 1) or Invest in Bonds (Alt. 2)
August 1
Invest…
arrow_forward
Hansaben
arrow_forward
can someone answer part a
arrow_forward
Homework help. Chapter 25, number 2. Need helping filling in the blanks. Thank you!
arrow_forward
Current Attempt in Progress
Cheyenne Inc. owns and operates a number of hardware stores in the New England region. Recently, the company has decided to
locate another store in a rapidly growing area of Maryland. The company is trying to decide whether to purchase or lease the building
and related facilities.
Purchase: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be $1,851,800.
An immediate down payment of $405,100 is required, and the remaining $1,446,700 would be paid off over 5 years at $369,600 per
year (including interest payments made at end of year). The property is expected to have a useful life of 12 years, and then it will be
sold for $503,100. As the owner of the property, the company will have the following out-of-pocket expenses each period.
Property taxes (to be paid at the end of each year)
Insurance (to be paid at the beginning of each year)
Other (primarily maintenance which occurs at the end of each year)…
arrow_forward
A1
arrow_forward
Current Attempt in Progress
Your answer is partially correct.
Vaughn Inc. owns and operates a number of hardware stores in the New England region. Recently, the company has decided to locate
another store in a rapidly growing area of Maryland. The company is trying to decide whether to purchase or lease the building and
related facilities.
Purchase: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be $1,865,700.
An immediate down payment of $415,500 is required, and the remaining $1,450,200 would be paid off over 5 years at $369,000 per
year (including interest payments made at end of year). The property is expected to have a useful life of 12 years, and then it will be
sold for $508,900. As the owner of the property, the company will have the following out-of-pocket expenses each period.
Property taxes (to be paid at the end of each year)
Insurance (to be paid at the beginning of each year)
Other (primarily maintenance which…
arrow_forward
Appendix One (Construct or lease)Objective: Should WLW lease or construct their own production facilityOption 1: ConstructCosts to incur:Buying land, construct building and getting ready for use$ 360,000Taxes, insurance, and repairs (per year) $ 34,000Intended years of use 20Projected market value in 20 years $ 1,600,000Maximum down payment WLW can make $ 500,000Remainder in four payments of; $ 160,000Revenue opportunityBuilding annex will be leased to a tenant and will generate a lease revenue (per year) for 10 years $60,000Option 2: Lease Intended years of use 20First lease payment due now $ 90,000Rest of the lease payments (years 2-20) $ 90,000Operating costs to be paid by WLWRepairs (annual) $ 9,000Maintenance (annual) $ 26,000Initial one-time deposit, will be returned in year 20$ 40,000Required rate of return 15%Methodology:The consulting team is proposing to perform a NPV analysis and determine the benefit to leasing or construction.Based on the analysis, they will recommend the…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Related Questions
- whitout exel please Trident Office is considering remodeling the office building it leases to Robert Roberts, CPA. The remodeling costs are estimated at $225,000. If the building is remodeled, Robert Roberts, CPA has agreed to pay an additional $75,000 per year in rent for the next five years. The discount rate is 10 percent. What is the benefit of the remodeling project to Professional Properties? a. $69,158.56 b. $59,309.01 c. -$69,158.56 d. $68,399.15 e. - $61,417.03arrow_forwardi need the answer quicklyarrow_forwardeBook Differential Analysis Report Involving Opportunity Costs Five Star is considering leasing a building and buying the necessary equipment to operate a public warehouse. Alternatively, the company could use the funds to invest in $149,200 of 6% U.S. Treasury bonds that mature in 16 years. The bonds could be purchased at face value. The following data have been assembled: Cost of equipment $149,200 Life of equipment 16 years Estimated residual value of equipment $27,200 Yearly costs to operate the warehouse, excluding depreciation of equipment $55,600 Yearly expected revenues—years 1-8 84,700 Yearly expected revenues—years 9-16 74,000 Required: 1. Prepare a differential analysis report of the proposed operation of the warehouse for the 16 years as compared with present conditions. Five StarProposal to Operate Warehouse Differential revenue from alternatives: $Revenue from operating warehouse Revenue from investment in bonds…arrow_forward
- Differential Analysis Involving Opportunity Costs On July 1, Campus Stores Inc. is considering leasing a building and purchasing the necessary equipment to operate a retail store. Alternatively, the company could use the funds to invest in $1,500,000 of 2% U.S. Treasury bonds that mature in 15 years. The bonds could be purchased at face value. The following data have been assembled: Line Item Description Amount Cost of store equipment $1,500,000 Life of store equipment 15 years Estimated residual value of store equipment $75,000 Yearly costs to operate the store, excludingdepreciation of store equipment $320,000 Yearly expected revenues—years 1-6 $400,000 Yearly expected revenues—years 7-15 $600,000 Required: Question Content Area 1. Prepare a differential analysis as of July 1 presenting the proposed operation of the store for the 15 years (Alternative 1) as compared with investing in U.S. Treasury bonds (Alternative 2). If an amount is zero, enter "0". If…arrow_forwardQuantitative Problem 1: Findley Furniture Company must install $5.9 million of new equipment in one of its plants. It can obtain a bank loan for 100% of the required amount. Alternatively, management believes it can arrange a lease. Assume that the following facts apply: 1. The equipment falls in the MACRS 5-year class. The applicable MACRS rates are 20%, 32%, 19%, 12%, 11%, and 6%. 2. The lease includes maintenance, whereas if the equipment is purchased, it would require maintenance provided by a service contract for $120,000 per year, payable at the end of the year. 3. Findley's federal-plus-state tax rate is 35%. 4. If the money is borrowed, the bank loan will be at a rate of 10%, amortized in 5 equal installments to be paid at the end of each year. 5. The tentative lease terms call for end-of-year payments of $1.25 million per year for 5 years. 6. At the end of the lease term, the equipment will have an estimated salvage value of $950,000. At that time, Findley plans to replace the…arrow_forwardDONT GIVE ANSWER IN IMAGE FORMATarrow_forward
- Apo Don't upload any image pleasearrow_forwardDifferential Analysis Involving Opportunity Costs On August 1, Rantoul Stores Inc. is considering leasing a building and purchasing the necessary equipment to operate a retail store. Alternative company could use the funds to invest in $1,000,000 of 4% U.S. Treasury bonds that mature in 15 years. The bonds could be purchased at face The following data have been assembled: Cost of store equipment $1,000,000 Life of store equipment 15 years Estimated residual value of store equipment $50,000 Yearly costs to operate the store, excluding depreciation of store equipment $200,000 Yearly expected revenues-years 1-6 $300,000 Yearly expected revenues-years 7-15 $400,000 Required: 1. Prepare a differential analysis as of August 1 presenting the proposed operation of the store for the 15 years (Alternative 1) as compared with investing in U.S. Treasury bonds (Alternative 2). If an amount is zero, enter "0". Differential Analysis Operate Retail (Alt. 1) or Invest in Bonds (Alt. 2) August 1 Invest…arrow_forwardHansabenarrow_forward
- can someone answer part aarrow_forwardHomework help. Chapter 25, number 2. Need helping filling in the blanks. Thank you!arrow_forwardCurrent Attempt in Progress Cheyenne Inc. owns and operates a number of hardware stores in the New England region. Recently, the company has decided to locate another store in a rapidly growing area of Maryland. The company is trying to decide whether to purchase or lease the building and related facilities. Purchase: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be $1,851,800. An immediate down payment of $405,100 is required, and the remaining $1,446,700 would be paid off over 5 years at $369,600 per year (including interest payments made at end of year). The property is expected to have a useful life of 12 years, and then it will be sold for $503,100. As the owner of the property, the company will have the following out-of-pocket expenses each period. Property taxes (to be paid at the end of each year) Insurance (to be paid at the beginning of each year) Other (primarily maintenance which occurs at the end of each year)…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub

Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub