Study the attached thoroughly and rectify the file with formulas and figures using the exact cell numbers as per the notes below:

It's important to note that for the unleveraged Internal Rate of Return (IRR), you're currently indicating that the initial investment equals the sales price in year 10. The true initial investment is recorded in Cell B80, representing your investment at year 0.

Regarding the exit cap rate, it has been established at 150 basis points above the initial capitalization rate, which remains a fixed figure. The calculation of the initial cap rate should reflect the total investment, which is somewhat greater than the purchase price because it includes transaction fees incurred by the buyer.

On the other hand, the leveraged IRR is determined by the cash flow available after paying debt service. Utilizing leverage allows you to invest less capital upfront; however, it's important to remember that annual debt service must be deducted from your Net Operating Income (NOI).

Finally, both the leveraged and unleveraged returns should factor in the cash flow from the sale of the property in year 10. Your current model appears to be omitting these cash flows.

Please review the interest rate on the bank loan according to the provided instructions, as this can significantly influence the total loan amount in relation to the Debt Service Coverage Ratio (DSCR). Show the impacts the total loan amount based on the DSCR.

3 Unit Unit 1 Unit 2 $1,300 month * 15,600 Unit 3 $1,300 month 18,00 Unit 4 $1,700 mont 20,40 $2,100 month 25,200 $3,500 month 42,000 Sub-Total $10,100 month 21.200 Vacancy Less $563 month 5.58% Effective Gross Income Vacancy loss Unit 1 Management Expense 114,435 15,000 Maintenance Expense 17,308 2% Rent Increase 3% 19,615 Expense Increase 23,346 Electricity Expenses $100 month 5.421 Insurance 6.000 Water Expenses $100 month 1900 Operating Expenses - Total Set Onerating Income Cast Purchase Price 975,80-0700 Legal Fees 4.875 Finance Cost Financing Outians Loan by LTV 80100% LTV Ratio $ 780 080 Interest Rate 93% Amortization 20.60 year Lean Constant 11.19% Loan by DSCR Loan per LTV Ratio Concluded Loan Selected Loan Downpayment $652,596. $322.404 Legal Fees Finance Cost Monthly Debt Service Annul Debt Service 6083 Required Equity $332 174 Cash Flow After Debt Service Investor Equity Cas 14 896 Year 100% increase pery $ 15,600 Year Year Unit 2 16,068 Year Year 1 3.00% increase pery 17,047 Year 1 18,000 17 538 20,354 3:00% increase pe 18 540 19.096 20,400 20.259 21,491 22,138 Unit 4 21,012 21,642 22,96 24 149 21.486 24,19 3.00%% increase pe 25.200 25.956 26 617 26 735 27.41 28,363 30.090 42 000 43,260 30,995 31.923 12 85 31.36 Sub-Total 21,200 24.836 Vacancy Less 128 581 132.439 136,412 5 140.904 144,719 $ 149,051 5 153533 5 36,444 158,139 162 853 Effective Gross Income 114,438 Openting Expenses . Total 21.408 125,050 128 501 132.666 $ 136,646 $ 140,745 $ 144967 Net Operating Income 21346 26.189 97.352 27 495 149.316 153,796 94.896 99.862 28 874 30317 102,427 107.723 $ 10 110,456 $ 113,246 $ 116,093 Cash Flow Af 121.962 94.896 99.861 102 421 Discounted Cash Flow 104 047 107,72 3 110,436 5 113,246 $ 1 16,093 118,94 Entry Cap Rate 0.097 Exit Cap Rate NOI 10 3% 94,896 Reversion 1,133,321 Less Costoffak 226,664 Linoas Sak 1,464,721 Net Sale 1,391,485 Unleveraged IRR 1,391,485) 94,896 Leveraged IRR 97 352 (32,174) $ 94,896 3 99,862 $ 10 97,352 102 427 $ 105,047 $ 107,323 $ 110,456 $ 113,246 $ 116,093 118,99 99,862 5 102,427 5 105,047 5 107,123 5 110,456 5 113,246 $ 116,093 5 118,999 Unleveraged IRR 4.42%