Question: You have decided to use the same going-in cap rate as the terminal cap rate at the end of Year 5, without adding a risk

 You have decided to use the same going-in cap rate as

You have decided to use the same going-in cap rate as the terminal cap rate at the end of Year 5, without adding a risk premium.

1. What is the terminal cap rate and estimated sale price for Year 5 in [a] of the table?

2. What value do you project the value in [b] of the table? It is recommended that you refrain from rounding off until you complete your calculations.

3. The value in [b]:

4. What is the internal rate of return (IRR) for this investment?

5. Compute the net present value (NPV) using a required return rate of 9%. Based on this analysis, is this investment option a good choice for you? Why or why not? NPV: Would this be a good investment option for you?: Yes/No Reasons:

Please note that we will not be computing IRR using monthly cash flows; instead, for simplicity in Q6, we will directly use the annual summary in the table. Please note that we will not be computing NPV using monthly cash flows; instead, for simplicity in Q6, we will directly use the annual summary in the table.

\begin{tabular}{|c|c|c|c|c|c|c|} \hline End of Year & 0 & 1 & 2 & 3 & 4 & 5 \\ \hline Purchase price & ($11,000,000) & & & & & \\ \hline Net Operating Income (NOI) & & 901,375 & 900,681 & 899,962 & 943,700 & 961,855 \\ \hline Estimated Sales Price & & & & & & {[a]} \\ \hline Cash flow & ($11,000,000) & 901,375 & 900,681 & 899,962 & 943,700 & {[b]} \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!