Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a projected 6-year annual income and expense pro forma financial statement for the Property, based on the information provided for each property and your

Create a projected 6-year annual income and expense pro forma financial statement for the Property, based on the information provided for each property and your own underwriting; start the projection on July 1, 2020.

image text in transcribed

Property #2 Property type = Industrial warehouse Location = Franklin/Mansfield, MA Year Built = 2005 Property Size: 350,000 SF Tenant Area (SF) Market Rent Lease Expiration Date (year) Current Annual Rent Lockheed Martin 180,000 June 2022 $5.00/sf triple net Your assumption Raytheon 75,000 June 2021 $5.50/sf triple net Your assumption 60,000 June 2023 $6.00/sf triple net Thermo Fisher Scientific Your assumption Vacant 35,000 n/a Your assumption Total 350,000 Assume all are triple net leases and leases go to your projected market rate after expiration Lease renewal probability: 50% Vacancy rate: 7% per year Annual Rent and Expense Growth Rate: 3% Terminal cap rate = 7.0% Discount rate = 8.0% Leasing Reserve= $5/SF at start of investment Property #2 Property type = Industrial warehouse Location = Franklin/Mansfield, MA Year Built = 2005 Property Size: 350,000 SF Tenant Area (SF) Market Rent Lease Expiration Date (year) Current Annual Rent Lockheed Martin 180,000 June 2022 $5.00/sf triple net Your assumption Raytheon 75,000 June 2021 $5.50/sf triple net Your assumption 60,000 June 2023 $6.00/sf triple net Thermo Fisher Scientific Your assumption Vacant 35,000 n/a Your assumption Total 350,000 Assume all are triple net leases and leases go to your projected market rate after expiration Lease renewal probability: 50% Vacancy rate: 7% per year Annual Rent and Expense Growth Rate: 3% Terminal cap rate = 7.0% Discount rate = 8.0% Leasing Reserve= $5/SF at start of investment

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions