Please refer to the excel sheet for the case study $$ Ridge Business Center. Use functions of Excel wherever necessary, no macros should be used for the case study. Calculate Levered IRR on the investment using the data provided.

Investor A & B both invested $$100,000$ in a private investment and were promised $10\%$ IRR.

$-$ A received $$15,000$ in Year $1$ and $$5000$ in Year $2$

$-$ B received $$10,000$ in Year $1$ and $$10,000$ in Year $2$

Both of them exited the investment at the end of $2$nd year. Even though both got $10\%$ IRR on their investments, what could be the possible reason for B$$s unhappiness?

Bond yields are inversely related to Interest Rates. What is the explanation for this relationship?

What is DSCR$?$ Why is it important to lenders?

Our client is a real estate private equity company that focuses on multifamily acquisitions. A property we are looking at has a net operating income $($NOI$)$ of $$567,678.$ The asking price is $$10,650,567.$

What is the cap rate?