Answer via Excel. Thank you

Data for Questions 3 \& 4 Assume the following for a stablized real estate project: \begin{tabular}{|l|r|l|} \hline Number of Apartments: & 25 & units. \\ \hline Monthly Rent (Year 1): & $3,500 & per month. \\ \hline Rental Growth Rate: & 3.5000% & per year. \\ \hline Expense Ratio: & 56.0000% & (of rental revenues) \\ \hline Miscellaneous Income: & $19,500 & per year \\ \hline Misc. Income Growth Rate: & 2.5000% & per year. \\ \hline & & \\ \hline Going-In Cap Rate: & 6.7000% & per year. \\ \hline Going-Out Cap Rate: & 6.2000% & per year. \\ \hline Holding Period: & years. \\ \hline \\ \hline estion 3: & & \\ \hline Assume an interest-only loan at 6\% and the following underwriting constraints. What \\ \hline Maximum Loan Amount Given the Following Constraints: \\ \hline Maximum Loan-To-Value: & & \\ \hline Minimum Debt Service Coverage Ratio: & & \\ \hline Minimum Debt Yield: & & \\ \hline \end{tabular} Answer: Question 4: Construct an income statement and calculate the following: Unleverage Yield Cash on Cash (Leveraged) Yield. Annual DSCR Unleveraged Holding Period Return Unleveraged Holding Period Profit Unleveraged Holding Period Investment Mulitple Leveraged Holding Period Return Leveraged Holding Period Profit Leveraged Holding Period Investment Mulitple Answer: \begin{tabular}{|l|} \hline NOI \\ \hline Sale Value \\ \hline \end{tabular} Unleveraged Cash Flow Unleveraged Yield Unleveraged Holding Period Profit Unleveraged Holding Period Multiple Unleveraged Holding Period Return Debt Service Loan / Repayment Leveraged Cash Flow Leveraged Yield Leveraged Holding Period Profit Leveraged Holding Period Multiple Leveraged Holding Period Return