Question

In: Finance

A property has an expected first-year NOI of $1 million. Recent sales of similar properties indicate...

A property has an expected first-year NOI of $1 million. Recent sales of similar properties indicate that a first-year (or going-in) cap rate of 12% is reasonable for valuation purposes. A lender requires a minimum DSCR of 1.25x and will loan up to 75% of appraised value on a first mortgage. Say the mortgage interest rate is 6.75%, payments are monthly, and the amortization period is 20 years. (10 points)  Hint: solve for the debt service.

a)   

What is the implied loan size using the DSCR criteria?
What is the implied loan size using the LTV criteria?

b) Based on your response to the previous question(s): What is the maximum-sized loan a risk-adverse lender will advance? (5 points)

  • The loan amount based on the DSCR criteria.
  • The loan amount based on the LTV criteria.

c) Suppose 10-year Treasury bond yields in the bond market are 7.5% Bond Equivalent Yield (BEY), and the mortgage market requires a contract yield risk premium of 225 basis points above the BEY. If a property has an annual net operating income (NOI) of $400,000, and the underwriting criteria require a debt service coverage ratio (DSCR) of at least 1.25x, then what is the maximum loan that can be offered assuming a 30-year amortization rate and monthly payments on the mortgages? (10 points) Hint: first find the mortgage equivalent yield, and then solve for the debt service.

MEY (%):
Annual Debt Service:
Monthly Debt Service:
Loan Amount:

Solutions

Expert Solution

Part (a):

Given,

First year NOI= $1 Million, Minimum DSCR=1.25x

Therefore, maximum monthly loan payment = ($1Million/12)/1.25 = $ 66,666.67

Loan amount corresponding to the above monthly payments (Implied loan size using DSCR criteria)= $8,767,730.43 as follows:

Also given, Cap rate= 12% and LTV=75%

Property value= NOI/Cap rate= $1,000,000/0.12 = $ 8,333,333.33

Implied loan size using LTV criteria= $ 8,333,333.33 *75% = $6,250,000

Part (b):

A risk averse lender will advance the loan amount based on LTV criteria, ie., $6,250,000 being the lower of the two.

Part (c):

Given, Bond equivalent yield (BEY)= 7.5% and risk premium= 225 bps.

Mortgage equivalent yield (MEY)= BEY+Risk premium= 7.5% + 2.25% = 9.75%

Also given, initial NOI= $400,000 and Minimum DSCR=1.25x

Therefore, annual Debt service= $400,000/1.25= $320,000

Monthly debt service= $320,000/12 = $ 26,666.67

Loan amount corresponding to the monthly debt service= $3,103,827.01 as follows:


Related Solutions

A property that can be purchased for $1.7 million has an expected first year NOI of...
A property that can be purchased for $1.7 million has an expected first year NOI of $190,000. An investor is considering two loan alternatives: LOAN A: A 70% loan-to-value ratio, with interest at 7.5% per annum. The loan will require level monthly payments to amortize the principle over 20 years. LOAN B: An 80% loan-to-value ratio, with interest at 8% per annum. This loan will require level monthly payments to amortize the principal over 25 years. Fore each loan, determine:...
A property is expected to have NOI of $100,000 the first year. The NOI is expected...
A property is expected to have NOI of $100,000 the first year. The NOI is expected to increase by 3 percent per year thereafter. Assume that the appraiser would estimate the value in year 10 by using a 10 percent capitalization rate. The appraised value of the property is currently $1 million and the lender is willing to make a 90 percent LTV loan with a contract interest rate of 9 percent, and it will be amortized with fixed monthly...
A property has first year NOI of $1.5 million. NOI grows at 7% during the next...
A property has first year NOI of $1.5 million. NOI grows at 7% during the next two years. In year four, NOI goes drops 50% due to a lost tenant. You are very lucky and replace the tenant. Year five NOI is 4X year four. (continues below…) What is year 5 NOI? continue…You have a $10 million mortgage on this property, at 5% interest, amortization of twenty years. There are two partners who have invested $3 million total in the...
An industrial property recently sold for $5,500,000. First-year NOI is $440,000. NOI is expected to increase...
An industrial property recently sold for $5,500,000. First-year NOI is $440,000. NOI is expected to increase annually by 4% over the next decade. The expected holding period is 7 years. 1. What would terminal cap rate be appropriate? 2. what is the relationship between today's cap rate and the going out cap rate? 3. In addition to capitalizing income, there is a second method to estimate terminal value describe the method and provide a numerical example.
A property that can be purchased for $1.7 million has an expected first-year net operating income...
A property that can be purchased for $1.7 million has an expected first-year net operating income of $190,000. An investor is considering two loan alternatives: LOAN A: a 70% loan-to-value ratio, with interest at 7.5% per annum; the loan will require level monthly payments to amortize the principal over 20 years. LOAN B: an 80% loan-to-value ratio, with interest at 8% per annum; this loan will require level monthly payments to amortize the principal over 25 years. For each loan,...
You purchase a brand-new property that had an NOI of $12 million last year (year 0)....
You purchase a brand-new property that had an NOI of $12 million last year (year 0). NOI is expected to grow at 5% a year. In order to maintain this growth, you hire a management team to manage the property and they charge 3% of NOI per annum. The risk-free rate is 1%. 1. You go to bank ABC to take out an amortized loan. The going-in cap rate for the property is 6%. They are willing to lend you...
Powder Rangers has expected sales of $3 million a year. Variable costs are expected to be...
Powder Rangers has expected sales of $3 million a year. Variable costs are expected to be 55 percent of sales and fixed operating costs are $800000 a year. Total capital is presently $1000000 and must be expanded to $2000000 to generate the anticipated sales level. The company presently has no debt outstanding, and 50000 shares of stock. Additional common stock could be sold for $10 a share. The interest rate on new debt would be 6 percent and the tax...
Consider a Property with expected future NOI of $25,000 per year for the next 5 years (starting one year from now).
Consider a Property with expected future NOI of $25,000 per year for the next 5 years (starting one year from now). After that, the operating cash flow will step up 20% to $30,000 for the following 5 years. Assume no capital- and leasing expenses.(a) If you expect to sell the property 10 years from now at a going-out cap rate of 10%, what is the value of the property if the required return is 12%?(b) Now suppose the seller of...
An apartment building has the following investment characteristics: Year 1 NOI $2,500,000 Year 2 NOI $2,600,000...
An apartment building has the following investment characteristics: Year 1 NOI $2,500,000 Year 2 NOI $2,600,000 Year 3 NOI $2,704,000 Year 4 NOI $2,812,000 You plan to purchase the asset at a 5% initial cap rate and to sell it 3 years later, also at a 5% cap rate. You plan to use a loan at 60% LTV to purchase the asset. The loan will be interest-only (no amortization) at a 4% annual interest rate. Answer the following: What is...
An office building has the following investment characteristics: Year 1 NOI $2,100,000 Year 2 NOI $2,200,000...
An office building has the following investment characteristics: Year 1 NOI $2,100,000 Year 2 NOI $2,200,000 Year 3 NOI $2,300,000 Year 4 NOI $2,400,000 Initial (going in) cap rate 7% Loan Principal $18,000,000 Interest rate 5% Amortization 30 years Exit cap rate 8% Holding period 3 years Solve for each of the following: Purchase price Loan to value ratio Annual debt service Debt service coverage ratio for year 1 Loan balance at the end of year 3 Equity (Levered) IRR
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT