What is the balance on the original loan

Assignment Help Finance Basics
Reference no: EM133114451

You purchased a 16,000 SF warehouse building 6 years ago for $577,000. You are considering refinancing.

Currently, rental rates average $5.25/SF. Market vacancies are 7%. The subject OER is stable around 31%. Market cap rates are now 6.5%.

Your lender has proposed refinancing. Below are the original loan terms from 6 years ago and the new proposed loan terms.

ORIGINAL LOAN (OLD)

NEW LOAN

6.5% interest rate

25-year amortization (monthly)

65% LTV ratio

Minimum 1.50 DCR

3% prepayment penalty (3% of loan balance at time of prepayment)

4.75% interest rate

30-year amortization (monthly)

75% LTV ratio

Minimum 1.50 DCR

 

Determine the following:

1. What is the balance on the original loan at the end of year 6?

2. What is the prepayment penalty for the original loan based on the balance at the end of year 6?

3. The current NOI based on the current market terms.

4. The current market value based on the current NOI (from B3) and current market cap rate.

5. The maximum amount you can borrow today based on the new loan's LTV and the current market value (from B4).

6. The new annual debt service (ADS) based on the new loan terms.

7. What is the net disbursement for the new loan based on the max amount borrowed (from B5) and the prepayment penalty for the original/old loan (from B2)?

8. What is the effective borrowing cost for the new loan based on the new loan terms and the net disbursement (from B7)? (Don't forget to annualize the rate.)

9. What is the DCR for the new loan based on the current estimated NOI (from B3)?

10. Does the property qualify for this new loan based on its current income? Why or why not?

Reference no: EM133114451

Questions Cloud

How much will you have saved up when you retire : Today is your 22nd birthday and you have just started your first job out of college. You decide that you will put $10,000 into a retirement account every
How much accounts receivable is the firm expected : Compuglobal Corp. currently has $660,000 in accounts receivable and generated $4,650,000 in sales (all on credit) during the year that just ended. The firm's da
Improve the performance of the business : Putting on your consultant's hat what recommendations would you make to grow or improve the performance of the business?
What was the purpose of the clique : What clique are you a part of in your current organization (or a prior organization). What was the purpose of the clique?
What is the balance on the original loan : You purchased a 16,000 SF warehouse building 6 years ago for $577,000. You are considering refinancing.
Explain to a group of people without a background in finance : Explain to a group of people without a background in finance, using language they can understand and without jargon, why the equity risk premium (ERP) is, simul
Calculate the standard deviation : Now you construct your portfolio by determining the optimal weight of each asset. For each period, calculate the standard deviation of 10 alphas you have comput
Effective annual cost of the loan for cold ice inc : Cold Ice Inc. requires $360,000 in short-term credit and is currently arranging a loan with its bank. Cold Ice plans to use the funds for 6 months, the annual r
Calculate the davidson wacc using retained earnings : (1) Calculate the Davidson's WACC using Retained Earnings as the equity component cost.

Reviews

Write a Review

Finance Basics Questions & Answers

  Solution in mathematical terms and words

What if you are a "risk-taker"? Explain your solution in mathematical terms and words. Post a spreadsheet if you wish.

  Determine the internal rate of return

Determine the internal rate of return on the following? project: An initial outlay of $11 500 resulting in a cash inflow of $2 648 at the end of each year.

  Different potential investments

Why might two different investors select two different potential investments if one investment had a higher return and a higher risk over the other investment?

  What is the delivered price

The invoice had an April 8 date. Levin received the goods on April 19 and paid the invoice on April 25.

  Employees of commercial banks in malaysia

With the help of examples, discuss FOUR (4) aspects of the code of conduct stipulated by Bank Negara Malaysia which govern all employees of commercial banks in

  Suggest that pretest sensitization had occurred

Explain how you could redesign the experiment to see whether pretest sensitization occurred. (Hint: You will probably use a 3 x 2 factorial design.) What pattern of results would suggest that pretest sensitization had occurred?

  Explain the firm cost of equity

The earnings, dividends, and stock price of Shelby Inc. are expected to grow at 7% per year in the future. Shelby's common stock sells for $30 per share, its la

  Determine the value of the bond

The 18?-year, ?$1,000 par value bonds of Waco Industries pay 7 percent interest annually. The market price of the bond is ?$875?, and the? market's required

  Price ratio analysis for internet companies given the

price ratio analysis for internet companies given the information below for hooyah corporation compute the expected

  Theory problems based on us regulations

Theory problems based on US regulations and distinguish between economies of scale and economies of scope

  Find the present value of the derivative

Using risk-neutral valuation, derive a formula for a derivative that pays cash flows over the next two periods. Assume the risk-free rate is 4 percent per period.

  How will the new inventory system impact your recommendation

Which option should you choose? (Hint - value the store's ongoing operations as a perpetuity) How will the new inventory system impact your recommendation?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd