Question

In: Finance

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. The expected before-tax cash flow (NOI minus annual debt service) as a percentage of the equity investment.

Solutions

Expert Solution

The calculation is as follows –

Particular

LOAN A

LOAN B

Purchase Price of Property

$1.7 million

$1.7 million

First Year NOI (NOI)

$190,000

$190,000

Loan-to-value ratio

70%

80%

Loan Amount

$1.19 million (i.e. 70% of 1.7 m)

$1.36 million (i.e. 80% of 1.7 m)

Equity Amount (Equity)

$0.51 m

$0.34 m

Payment frequency

Monthly

Monthly

No of months for repayment

240 (20yrs * 12)

300 (25yrs*12)

Interest Rate Monthly

7.5%/12

8%/12

In excel, formula used for calculating monthly payments

=PMT(rate, nper,pv)

=PMT(7.5%/12, 240, 1.19)

=PMT(rate, nper,pv)

=PMT(8%/12, 300,1.36)

Hence, Monthly debt servicing

$9,587

$10,497

Yearly Debt Servicing (Debt Service)

$115,039

$125,960

Ratio=(NOI – Debt Service)/Equity

=(190,000 – 115,039)/510,000

=14.7%%

=(190,000-125,960)/340,000

=18.8%%


Related Solutions

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,...
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...
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...
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.
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...
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...
You purchased a rental property that generates $50,000 during the first year. The property will produce...
You purchased a rental property that generates $50,000 during the first year. The property will produce an additional 49 cash flows growing at a rate of 4 percent per year. If the interest rate is 8 percent compounded yearly and rental payments are made at the beginning of each year, what should the value of this property be?
2. A property was purchased by an investor. The property is expected to produce $120,000 of...
2. A property was purchased by an investor. The property is expected to produce $120,000 of annual net operating income in year 1; increasing $10,000 every year thereafter. The owner intends to sell the property at the end of year 5. a. Assuming the bank requires a 1.2 debt coverage service ratio based on the expected first year NOI, what is the maximum monthly mortgage payment? b. Assuming the mortgage has a 6% annual interest rate, amortizes over 30 years,...
A property was purchased by an investor. The property is expected to produce $120,000 of annual...
A property was purchased by an investor. The property is expected to produce $120,000 of annual net operating income in year 1; increasing $10,000 every year thereafter. The owner intends to sell the property at the end of year 5. a. Assuming the bank requires a 1.2 debt coverage service ratio based on the expected first year NOI, what is the maximum monthly mortgage payment? b. Assuming the mortgage has a 6% annual interest rate, amortizes over 30 years, with...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT