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%%

jeff jeffy answered 2 years ago

Next > < Previous

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...

Subjects