Can you please review the question below as well as the calculations and tell me where the mistakes are?

What is the NOI, Net Cash Flow, Return on Equity and Loan Constant for a multifamily apartment building, given the following information? 1. Number of Units: 200 1 Br. 60 . 2 Br. 100 . 3 br. 40 2. Average Base Rents: 1 Br. $850 per month .2 Br. $1,100 per month 3 br. $1,300 per month 3. Trash Recovery: $30 per month, per unit 4. Utility Recovery: $110 per month, per unit 5. Vacancy: 5.5% 6. Operating Expenses: 40% of Effective Gross Income 7. Concessions: 1.0% 8. Rents Written Off: 1.5% 9. Cap Rate: 8.0% 10. Loan to Value: 75% 11. Mortgage Interest Rate: 5.75% 12. Amortization: 13. Debt Service: Student Calculate 30 years B U 1 D No. of Units Average Base Rent Month ($) Total Rent (5) 2 1 Br. 60 850 612000 3 2 Br. 100 1100 1320000 4 3 Br. 40 1300 624000 5 Total Rent 200 2556000 6 7 Calculation of Net Operating Profit 8 Particulars Amount (S) 9 Rent 2556000 10 Trash Recovery 6000 11 Utility Recovery 22000 12 Gross Income 2584000 13 Vacancy 129200 14 Effective Gross Income 2454800 15 Operating Expneses 981920 16 Concessions 24548 17 Rent Write-off 36822 18 Operating Profit 1411510 19 20 Calculation of other requirements 21 Particulars Amount 22 Capitalization Rate 8% 23 Investment (5) 17643875 24 Loan to Value 75% 25 Loan Value (5) 13232906.3 26 Mortgage Interest Rate 5.75% 27 Amotization 30 28 Debt Service ($) 935781.36 29 Loan Constant 7.07% 30 Equity (5) 4410969 31 Return on Equity 32% 32 Cash Flow ($) 512550.64 C B No. of Units 60 100 40 =SUM(B2:34) Average Base Rent Month (S) 850 1100 1300 D Total Rent (5) =C2*12*B2 1=C3*12*B3 =C4*12*B4 =SUMD2:D4) 1 2 1 Br. 3 2 Br. 4 3 Br. 5 Total Rent 6 7 Calculation of Net Operating Profit 8 Particulars 9 Rent 10 Trash Recovery 11 Utility Recovery 12 Gross Income 13 Vacancy 14 Effective Gross Income 15 Operating Expneses 16 Concessions 17 Rent Write-off 18 Operating Profit 19 20 Calculation of other requirements 21 Particulars 22 Capitalization Rate 23 Investment (5) 24 Loan to Value 25 Loan Value ($) 26 Mortgage Interest Rate 27 Amotization 28 Debt Service ($) 29 Loan Constant 30 Equity (5) 31 Return on Equity 32 Cash Flow (S) Amount (5) =D5 1=30*B5 =110*B5 =SUM(B9:B11) =5%*B12 =B12-B13 =40%*B14 =B14*1% =1.5%*B14 =B14-SUM(B15:B17) Amount 0.08 =B18/B22 0.75 =B23*B24 0.0575 30 =PMT(B26,B27,-B25) =B28/B25 =B23-B25 =B18/B30 =B18+B17-B28