Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

B C E G G H H 1 J D Turtle Tower Formula Bar 5.00 8,255,000.00 11.00% 11% Mixed use 30,500 0.5000 30,500.00 3 Lease

image text in transcribedimage text in transcribed

B C E G G H H 1 J D Turtle Tower Formula Bar 5.00 8,255,000.00 11.00% 11% Mixed use 30,500 0.5000 30,500.00 3 Lease renewal: Lease term Base rent - New/renew Rent escalation Reimbursements Renewal probability Months vacant Tenant improvements - New Tenant improvements - Renewal Leasing commisions - New Leasing commisions - Renewal 5 years Market .50/sf Base year stop 75% 6 months $10/st $5/sf 20% of base rent in initial year 10% of base rent in initial year 75.00% 6.00 10.00 Inflation 5.00 Inflation 20.00% 10.00% 22.00/SF 3% 3% 22.00 3.00% 3.00% Disposition: Market capitalization rate Sale commissions Legal 6.00% 2% of sale price 6.00% 2.00% 20,000.00 8,500 23.50/sf 4.00% 0/sf 8 years 8,500.00 23.50 4.00% 0.00 Mortgage financing: Principal amount borrowed Interest rate Amortization period Maturity Payment frequency Origination fee $4,4M 5.75% 25 years 4,375,000.00 5.75% 25 5 5 5 years 17,000 21.75/sf / 50/sf 9.75/st 3 years 17,000.00 21.75 0.50 9.75 Annual 2.0% of initial balance 3 General data: 4 Price 5 Required return (unlevered) 6 Property type 7 Rentable SF 8 Number of tenants 9 10 Market and economic data: 11 Market rent 12 Market inflation 13 Expense/general inflation 14 15 Income: 16 The Tasty Turtle 17 SF 18 Rent (as of 1/2020) 19 Rent escalation 20 Expense stop 21 Remaining lease term 22 Renewal 100% 23 Conor & Conor 24 SE 25 Rent (as of 1/2020) 26 Rent escalation 27 Expense stop 28 Remaining lease term 29 Ray's Realty 30 SF 31 Base rent 32 Rent escalation 33 Expense stop 34 Remaining lease term 35 36 Ancillary 37 % fixed 38 39 Reimbursements 40 41 Operating expenses: 42 Utilities 43 % fixed 44 Real estate taxes 45 Insurance 46 Repairs & Maintenance 47 Management (Non-reimbursable) 48 49 Capital expenses: 50 Reserves 51 52 2.00% 5,000 23.00 .50/sf TBD 5 years 5,000.00 23.00 0.50 Tax information: Marginal income tax rate Capital gains tax rate Depreciation recapture rate Other passive income Land value Structure and improvements Economic life-structure Economic life- capital expenditures Economic life - TI 35.00% 20.00% 25.00% None 3,000,000 5,255,000 39 10 15 5.00 moeten Parking, 175,000/Year 0% fixed 175,000.00 Inflation 0% Base stop 3.25/sf, 25% fixed 125,000 80,000 33,500 2% of EGI 3.25 Inflation 0.25 125,000.00 2% 80,000.00 Inflation 33,500.00 Inflation 2% 0.20/sf 0.20 Inflation A B C D E F G 1 H O 5 Market Rent 6 Turtle 7 C&C 8 Ray's 9 10 Potential rental income: 44 11 Turtle 12 C&C 4 13 Ray's 14 Potential gross income (PGI) 15 16 Vacancy allowance 17 Turtle 18 C&C 18 ce 19 Ray's 20 Total allowance 21 22 Vacancy 23 Occupancy 24 25 Effective gross income (EGI) 26 27 Reimbursements: 28 Turtle 29 Base stop 30 Reimbursement 31 C&C 32 Base stop 33 Reimbursement 34 Ray's 35 Base stop 36 Reimbursement 37 Total reimbursements 38 Parking 39 40 Total operating income 41 42 Expense information: 43 Utilities/st 44 Utilities 45 Real estate taxes 46 Insurance 47 Repairs & Maintenance 48 Total reimbursable expense 49 Total reimbursable expense/sf 50 51 Management expenses 52 53 Total operating expenses 54 Net operating income (NOI) 55 B C E G G H H 1 J D Turtle Tower Formula Bar 5.00 8,255,000.00 11.00% 11% Mixed use 30,500 0.5000 30,500.00 3 Lease renewal: Lease term Base rent - New/renew Rent escalation Reimbursements Renewal probability Months vacant Tenant improvements - New Tenant improvements - Renewal Leasing commisions - New Leasing commisions - Renewal 5 years Market .50/sf Base year stop 75% 6 months $10/st $5/sf 20% of base rent in initial year 10% of base rent in initial year 75.00% 6.00 10.00 Inflation 5.00 Inflation 20.00% 10.00% 22.00/SF 3% 3% 22.00 3.00% 3.00% Disposition: Market capitalization rate Sale commissions Legal 6.00% 2% of sale price 6.00% 2.00% 20,000.00 8,500 23.50/sf 4.00% 0/sf 8 years 8,500.00 23.50 4.00% 0.00 Mortgage financing: Principal amount borrowed Interest rate Amortization period Maturity Payment frequency Origination fee $4,4M 5.75% 25 years 4,375,000.00 5.75% 25 5 5 5 years 17,000 21.75/sf / 50/sf 9.75/st 3 years 17,000.00 21.75 0.50 9.75 Annual 2.0% of initial balance 3 General data: 4 Price 5 Required return (unlevered) 6 Property type 7 Rentable SF 8 Number of tenants 9 10 Market and economic data: 11 Market rent 12 Market inflation 13 Expense/general inflation 14 15 Income: 16 The Tasty Turtle 17 SF 18 Rent (as of 1/2020) 19 Rent escalation 20 Expense stop 21 Remaining lease term 22 Renewal 100% 23 Conor & Conor 24 SE 25 Rent (as of 1/2020) 26 Rent escalation 27 Expense stop 28 Remaining lease term 29 Ray's Realty 30 SF 31 Base rent 32 Rent escalation 33 Expense stop 34 Remaining lease term 35 36 Ancillary 37 % fixed 38 39 Reimbursements 40 41 Operating expenses: 42 Utilities 43 % fixed 44 Real estate taxes 45 Insurance 46 Repairs & Maintenance 47 Management (Non-reimbursable) 48 49 Capital expenses: 50 Reserves 51 52 2.00% 5,000 23.00 .50/sf TBD 5 years 5,000.00 23.00 0.50 Tax information: Marginal income tax rate Capital gains tax rate Depreciation recapture rate Other passive income Land value Structure and improvements Economic life-structure Economic life- capital expenditures Economic life - TI 35.00% 20.00% 25.00% None 3,000,000 5,255,000 39 10 15 5.00 moeten Parking, 175,000/Year 0% fixed 175,000.00 Inflation 0% Base stop 3.25/sf, 25% fixed 125,000 80,000 33,500 2% of EGI 3.25 Inflation 0.25 125,000.00 2% 80,000.00 Inflation 33,500.00 Inflation 2% 0.20/sf 0.20 Inflation A B C D E F G 1 H O 5 Market Rent 6 Turtle 7 C&C 8 Ray's 9 10 Potential rental income: 44 11 Turtle 12 C&C 4 13 Ray's 14 Potential gross income (PGI) 15 16 Vacancy allowance 17 Turtle 18 C&C 18 ce 19 Ray's 20 Total allowance 21 22 Vacancy 23 Occupancy 24 25 Effective gross income (EGI) 26 27 Reimbursements: 28 Turtle 29 Base stop 30 Reimbursement 31 C&C 32 Base stop 33 Reimbursement 34 Ray's 35 Base stop 36 Reimbursement 37 Total reimbursements 38 Parking 39 40 Total operating income 41 42 Expense information: 43 Utilities/st 44 Utilities 45 Real estate taxes 46 Insurance 47 Repairs & Maintenance 48 Total reimbursable expense 49 Total reimbursable expense/sf 50 51 Management expenses 52 53 Total operating expenses 54 Net operating income (NOI) 55

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Step: 3

blur-text-image

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

The Palgrave International Handbook Of Basic Income

Authors: Malcolm Torry

1st Edition

3030236137, 978-3030236137

More Books

Students also viewed these Finance questions

Question

Analyze the impact of labor unions on health care.

Answered: 1 week ago

Question

Assess three motivational theories as they apply to health care.

Answered: 1 week ago

Question

Discuss the history of U.S. labor unions.

Answered: 1 week ago