Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are considering the purchase of an apartment complex. Purchase price: $775,000 Holding period is four years Cap rate is expected to be 7% in

You are considering the purchase of an apartment complex.

  • Purchase price: $775,000
  • 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%

Year

NOI

1

$103,085

2

$108,361

3

$113,875

4

$119,636

5

$125,651

  1. Calculate the NPV of this project assuming that you do not take any mortgages
  2. You take a $620,000 mortgage. Your annual debt payment is $54,593. The outstanding loan balance at the end of year 4 is $596,558. Calculate the NPV of this project.

Please show work on excel or how to do on calculator

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

Students also viewed these Finance questions