Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are considering the purchase of a 1,824SF industrial building in Bellflower. Below, you are given the information you need to analyze the investment and

image text in transcribed
You are considering the purchase of a 1,824SF industrial building in Bellflower. Below, you are given the information you need to analyze the investment and decide how to proceed. In the first year, you plan to charge $12/SF, but the building is currently vacant.You expect that it will take you six months to find a tenant and fill the unit. Then, you will get them to sign a contract for three years, after which you expect another six-month vacancy before you fill it again.Variable operating expenses will cost you 20% of EGI, and fixed operating expenses will cost5%of PGI. But you can require your tenants to pay all of the variable expenses.You plan to set aside$100,000 per year for future renovations. 1.What is the estimated net operating income (NOI) and property-before-tax cash flow (PBTCF) for the first year of operations? Please show these calculations in the form of a pro forma. 2.If you pay $155/SF for the building, what is the going- in cap rate? You assume that PGI will grow by 5% per year for the next six years. You plan to sell the property after year 5, and you expect your selling expenses to be 6% of the resale price. Assume that the going-out cap rate is 100 basis points higher than the going-in cap rate. 3.What is the resale price? 4.What is the reversion cash flow? 5.Please fill out the pro forma to calculate the PBTCFS for the remaining years of the investment. You assume this property will be quite safe, closer to bonds than stocks. To make it worthwhile, you'd have to earn a 4.5% return. 6.What is the value of this property? 7. Based on the value and the price, is it a good deal for you to buy the property? Please use Excel and Show formulas used to do it

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

Corporate Risk Management

Authors: Faisal F. Al-Thani, Tony Merna

2nd Edition

0470518332, 978-0470518335

More Books

Students also viewed these Accounting questions

Question

=+vii. Bullet points to emphasize important ideas.

Answered: 1 week ago