Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the following information provide an analysis that answers the questions at the end of the assignment. Purchase Price: $4,250,000 Rents: Tenant Unit 1 Unit

Given the following information provide an analysis that answers the questions at the end of the assignment.

Purchase Price: $4,250,000

Rents:

Tenant

Unit 1

Unit 2

Unit 3

Unit 4

Unit 5

Unit 6

Unit 7

Unit 8

Monthly Rent

$5,400

$5,400

$6,200

$3,500

$3,600

$3,300

$3,700

$3,100

Year 1 NOI: $248,678

NOI Growth Rate: 2.6%

Loan:

LTV: 75%

Amortization Period: 25 years, Term: 10 years

Interest Rate: 3.35%

Lender Points: 2%

Selling Costs: 3%

Going Out Cap Rate: 5.5%

Discount Rate: 10%

Questions:

  1. What is the going in cap rate? 5.85%
  2. What is year 1 PGI? $410,400
  3. What is the DSCR?
  4. What is your Initial Investment? $3,187,500
  5. What is the sale price after the five-year hold? $3,272,500
  6. What is the loan balance at sale? $977,500
  7. What is the NPV for this project? $176,322
  8. What id the IRR for this project? 33.33%
  9. What is the DCF for this project?
  10. What is the reversion amount?

The bolded answers are the ones I have so far but I believe they are wrong, can someone help and make sure if they are right too and help me answer the other questions as well?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Institutional Asset Management

Authors: Frank J Fabozzi, Francesco A Fabozzi

1st Edition

9811220034, 9789811220036

More Books

Students also viewed these Finance questions

Question

Brief the importance of span of control and its concepts.

Answered: 1 week ago

Question

What is meant by decentralisation?

Answered: 1 week ago

Question

=+7. Are shareholders in a firm investors or gamblers?

Answered: 1 week ago