Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Management Expert

You are considering the purchase of a small office building in Brooklyn. The property contains 20,000 square feet of rentable space and is currently occupied by multiple tenants each with differing maturities on their respective leases.

The vacancy rate is 3%.

No lease is currently shorter than 1 year.

The annual rent in the 1st year of ownership is $35/sq ft.

You will hire a management firm to collect the rent which will charge you collection costs of 2% per dollar of rent.

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 40% 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 6.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 (NOI – Interest expense) 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 6.25%. Also use the loan payment from question 4.)

7. The seller’s asking price for the property is $7,000,000. If the lender has a maximum 70% LTV requirement what is the most the bank will lend you? (Only based on the LTV requirement.)

8. The loan must satisfy both the minimum DSCR of 1.2 and maximum LTV of 70%.

What is the biggest loan the borrower can get?

9. If you buy the property at the asking price of $7,000,000 using the biggest loan you can get (from question 8), what will your down payment be?

10. What is the annual mortgage payment on the loan in question 8?

11. If you buy the property at the asking price of $7,000,000, what will your ‘going in’ Cap Rate be?

12. If the annual irr for this property is 8.5%, then based on the cap rate in question 11, what does this imply is expected NOI growth rate for this property?

13. You do research and find that similar properties are selling at 5.5% - 6% cap rate range. Using this cap rate range, what will be the price range for this property?

14. Suppose you buy the property at the asking price of $7,000,000 and own it for exactly 1 year.

You make the down-payment in part (9).

You collect the NOI in part (3).

You make the annual mortgage payment in part (10).

In two years, the NOI is expected to be the same.

You sell the property at the end of year 1, at a cap rate of 50 basis points below the cap rate in part (11) and you pay off the loan balance when you sell.

Compute the IRR on this investment.

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M92746211

Have any Question?


Related Questions in Financial Management

1 in week four the focus was on analysis tools for

1. In week four, the focus was on analysis tools for determining solutions. In week five, we discussed groups and you also completed an assignment on analysis tools used for groups/teams. This week, one of the topics is ...

Scenario your team has been hired to provide financial

Scenario: Your team has been hired to provide financial analysis for a start-up company, Bobble in Style, which produces customized bobble heads. The bobble heads are made out of less rigid materials and are more true to ...

Assignmentbullthe dual mandate of the federal reservebullis

Assignment • The Dual Mandate of the Federal Reserve • Is Monetizing Government Debt such a good idea? • How the Federal Reserve Controls the Monetary Base • Explain inflation. What are some causes of inflation? • What a ...

Phenomenology assignmentimportantplease use level 1 headers

PHENOMENOLOGY ASSIGNMENT IMPORTANT: Please use Level 1 Headers in your paper so that I can easily discern what part of the assignment you are addressing. Since there are 5 questions in this assignment, you would need 6 L ...

Part a-budgeting amp financial analysisassume the following

Part A-Budgeting & Financial Analysis Assume the following data for Spring Break Corp: Statement of Income:                                               Balance Sheet: 2017                                                ...

Part 1 interest ratesmany managers do not understand the

Part 1: Interest Rates Many managers do not understand the various ways that interest rates can affect business decisions. For example, if your company decided to build a plant with a 30-year life and short-term debt fin ...

Consumer behavior assignment - personality and

Consumer Behavior Assignment - Personality and Lifestyles 1. What are some products that make their appeals primarily to the id? What are some products that make their appeals to the superego? Do products make an appeal ...

Introductionthroughout this course the focus has been on

Introduction Throughout this course, the focus has been on the problem-solving model and learning how to complete the steps. In addition, you learned how to utilize analysis tools to help you with some of the problem-sol ...

Please post the answer directly i will buyben wants to

Please post the answer Directly. I will buy. Ben wants to design a risky portfolio from two funds, Momentum Fund and Value Fund. Momentum Fund has an expected return of 35% and a standard deviation of return of 40%. Valu ...

Objectivedemonstrate the ability to perform financial

OBJECTIVE Demonstrate the ability to perform financial calculations and analysis related to the concepts covered in this course. PURPOSE The purpose of this project is to give you practical experi- ence with financial co ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As