Question

You plan to purchase a property which has an expected NOI of $200,000. You plan to borrow $1,500,000 at a 5% annual rate for 30 years. What is the DCR for this investment?

If the property in #9 is being purchased at an 8% cap rate, assuming the same loan information what is the LTV for this purchase?

show work

Answer #1

DCR = NOI / Loan payments

Loan payment constitutes both, Principal as well as interest

Loan amount = 1,500,000, Rate = 5%, Period = 30 years.

Present value factor as per annuity table for 5%, 30 years = 15.3725 (As per annuity table)

Therefore annual payment for the loan would be = 1,500,000 / 15.3725 = 97,576 (Principal + Interest)

**Thus, DCR = 200,000/97,576 = 2.05**

Cap rate = NOI / Vaue of property

Thius 8% = 200,000 / Value

Value = 2,500,000

**LTV = Loan amount / Value = 1,500,000 / 2,500,000 =
60%**

You are interested in purchasing a commercial property. You
project that the property’s NOI next year will be $1,200,000. The
current cap rate for similar properties is 8%. You are interested
in acquiring a loan with a 30-year amortization term at a 6% annual
interest rate. Based on the two metrics provided below calculate
the loan amount. You must show all your calculations to receive
full credit. (a) LTV = 75% [8 points] (b) DCR = 1.35

A property has NOI of 1,000,000 and would trade at a cap rate of
5%. You can borrow at a 60% LTV, 5% interest rate and
25-year amortization schedule.
What is the value of the property?
What is your debt service coverage?

7) A Value-Added Investment: A
“for sale” property has high vacancy. Based on its weak NOI and the
seller’s valuation, the property has a cap rate of 3%. Because of
the risk (empty space), you are willing to purchase the property at
a much higher (above market) going-in cap rate, even though the
market has an overall cap rate of 8%. It is your belief that you
have found some niche tenants for the property. In the first year,
NOI...

1. Calculate NOI for below T12 (Fairbanks, Alaska).
GPR: $1M
Loss to Lease: $10k
Vacancy: $50k
Controllable Expenses: $300k
Non Controllable Expenses: $175k
2. Using the same NOI and appropriate cap rate for this city, what
is the value of the property (aprox.)? Show work.
3. Loan sizing using LTV methodology. A banker indicated that they
can give you "70%" loan with a 5% interest rate and 25 year
amortization. What is the amount you think you can get for...

You are interested in purchasing a commercial property. You
project that the property’s NOI nextyear will be $1,200,000. The
current cap rate for similar properties is 8%. You are interested
in acquiring a loan with a 30-year amortization term at a 6% annual
interest rate. Based on the two metrics provided below calculate
the loan amount. You must show all your calculations to receive
full credit.
14. Given the following information calculate the property’s NOI
[8 points] and BTCF [7...

A property has a projected year 1 NOI of $200,000. NOI is
projected to grow by 4% per year for the following 2 years, then by
2% per year for the subsequent 2 years at a 1% constant rate
afterward. Given a required return of 13%, what is the value of the
property today if you sell at the end of year 5?

You are considering the purchase of an apartment building with
the following information:
Purchase
price
$12,500,000
Expected year 1
NOI
$1,000,000
Expected annual NOI
growth
4%
Expected Exit Cap
Rate
8.5%
Holding
Period
3 years
Solve for each of the following:
Initial (going in) cap rate
__________
NOI for Year
4
____________
Expected sales price end of year
3
______________
Net Present Value at 9% Discount...

You are considering the purchase of an apartment building with
the following information:
Purchase price $12,500,000
Expected year 1 NOI $1,000,000
Expected annual NOI growth 4%
Expected Exit Cap Rate 8.5%
Holding Period 3 years
Solve for each of the following:
Initial (going in) cap
rate
NOI for Year 4
Expected sales price end of year 3
Net Present Value at 9% Discount Rate
IRR
Would you buy this...

Last year, a property had an NOI $100,000 which is expected to
increase by 3% per year. The investment horizon is 3 years at which
time you expect the cap rate to be 10%. Determine the value of the
property using the Discounted Cash Flow approach, for the
three-year period. Use a 10% discount rate for the yearly cash
flows and a 10% rate for the terminal value.
a. $1,052,810
b. $1,109,024
c. $1,369,990
d. $1,084,394
e. $984,397

You are considering the purchase of an apartment complex.
• Purchase price: $775,000
•BTCF:
Year
NOI
1
$103,085
2
$108,361
3
$113,875
4
$119,636
5
$125,651
•Holding period is four years
•Cap rate is expected to be 7% in year 4
•Selling expenses will be 5% of the sale price
•The 4-year Treasury bill rate is 3% and your risk premium for
this project is 8%
a) Calculate the NPV of this project assuming that you do not
take any...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 3 minutes ago

asked 5 minutes ago

asked 14 minutes ago

asked 14 minutes ago

asked 14 minutes ago

asked 19 minutes ago

asked 22 minutes ago

asked 23 minutes ago

asked 26 minutes ago

asked 29 minutes ago

asked 29 minutes ago