You want to purchase an office building in Brooklyn. The property contains 32,100 square feet of...

Transcribed Image Text:

You want to purchase an office building in Brooklyn. The property contains 32,100 square feet of rentable space and is currently occupied by multiple tenants each with differing maturities on their respective leases. No lease is currently shorter than 1 year. The annual rent in the 1st year of ownership is $45.50/sq ft. The vacancy rate is 15.5%. You expect to incur collection losses (from tenant default) on 5.5% of the square feet during your first year. 1. What is the Potential Gross Income (PGI) for the first year? 2. What is the Effective Gross Income (EGI) for the first year? 3. If operating expenses are expected to be 50% of EGI, what is the Net Operating Income (NOI) generated by the property in the 1st year of ownership? 4. You decide you want to take out a loan to finance the purchase of this property. It will be an IO loan at a rate of 7.25%, compounded annually, with annual payments. The lender will provide financing up to a minimum Debt Service Coverage Ratio (DSCR) of 1.2 based off of the 1st year NOI. What is the largest annual loan payment the lender will allow you to make based on the DSCR? 5. If you get a loan that corresponds to the largest annual loan payment the lender will allow you to make based on the DSCR (computed in part 4), what will be your net income in the first year? 6. What is the largest loan a lender is willing to provide you with based on question 4? (Use the fact that this is an IO loan at 7.25%. Also use the loan payment from question 4.) You want to purchase an office building in Brooklyn. The property contains 32,100 square feet of rentable space and is currently occupied by multiple tenants each with differing maturities on their respective leases. No lease is currently shorter than 1 year. The annual rent in the 1st year of ownership is $45.50/sq ft. The vacancy rate is 15.5%. You expect to incur collection losses (from tenant default) on 5.5% of the square feet during your first year. 1. What is the Potential Gross Income (PGI) for the first year? 2. What is the Effective Gross Income (EGI) for the first year? 3. If operating expenses are expected to be 50% of EGI, what is the Net Operating Income (NOI) generated by the property in the 1st year of ownership? 4. You decide you want to take out a loan to finance the purchase of this property. It will be an IO loan at a rate of 7.25%, compounded annually, with annual payments. The lender will provide financing up to a minimum Debt Service Coverage Ratio (DSCR) of 1.2 based off of the 1st year NOI. What is the largest annual loan payment the lender will allow you to make based on the DSCR? 5. If you get a loan that corresponds to the largest annual loan payment the lender will allow you to make based on the DSCR (computed in part 4), what will be your net income in the first year? 6. What is the largest loan a lender is willing to provide you with based on question 4? (Use the fact that this is an IO loan at 7.25%. Also use the loan payment from question 4.)