What is the NPV$?$

Monthly Rental 1000 ft sq units 2000 ft sq units Seond floor suites Vacancy/collection loss Operating expense ratio %EGI Capital expenditures %EGI Holding period years Upfront financing costs as % of loan Loan percent of purchase Tax liability Annual rental increase Loan interest rate Loan term yrs Going out cap rate = Sell Exp Total acquisition price: Net Loan Proceeds Acquisition Costs Equity/Down Payment Loan pmt/mo Loan pmt/yr Units to Rent 2 1 5 11.0% 42.0% 6.0% 4 3.0% 73.0% 30.0% 3.3% 7.2% 30 8.9% 4.0% $ 1,104,785.00 $ 806,493.05 24,194.79 $ 322,486.74 $5,474.38 $65,692.56 Per Unit $ 1,724.00 $ 2,057.00 $ 1,610.00 $ 20,688.00 $ 24,684.00 $ 19,320.00 $ 41,376.00 $ 24,684.00 $ 96,600.00 PGI Vac/Col Loss EGI Total Op Exp CAPEX NOI Debt Service BTFC $ (322,486.74) 1 $ 162,660.00 $ 17,892.60 $ 144,767.40 60,802.31 8,686.04 75,279.05 65,692.56 9,586.49 9,586.49 2 $ 168,027.78 $ 18,483.06 $ 149,544.72 62,808.78 8,972.68 77,763.26 65,692.56 12,070.70 12,070.70 3 $ 173,572.70 $ 19,093.00 $ 154,479.70 64,881.47 9,268.78 80,329.44 65,692.56 14,636.89 14,636.89 4 $ 179,300.60 $ 19,723.07 $ 159,577.53 $ 67,022.56 $ 9,574.65 $ 82,980.32 $ 65,692.56 $ 17,287.76 $ 888,732.49 $ 906,020.25 Total CF IRR NPV Single Year Return Measures: Going in cap rate, RO Cash-On-Cash Return, COC Multiplier (EGIM) Operating expense ratio, OER Loan-to-value ratio, LTV Debt coverage ratio, DCR Debt yield ratio, DYR NSP N RBM BTER 6.81% 2.97% 7.63 42.00% 73.00% 1.15 9.33% $932,363.10 $ 37,294.52 $ 895,068.57 0.864 $5,474.38 312 $6,336.09 $ 888,732.49