Need help computing the formulas for yellow highlighted spots

G A B E F 1 INPUTS 2 HOLDING PERIOD 3 YEARS 3 UNITS 50 4 MARKETRENT MONTHLY PER UNIT S 800 5 RENT INCREASE PER YEAR 1% 6 INITIAL PURCHASE PRICE 2.000.000 7 VACANCY LOSS 4% 8 CREDIT LOSS 1% 9 OPERATING EXPENSE RATIO 40% 10 CAPITAL EXPENDITURES 10% OF EGI 11 SELLING EXPENSES 6% 12 GOING OUT CAP RATE 10.00% 13 DISCOUNT RATE 12.00 14 15 16 Note: Comoule the payment using both lions which measured siles for ansifies for both. choose the mortgage with the lowest EBC) 17 MORTGAGE OPTION 1:1 MORTGAGE OPTION 2: 18 ASSUME YOU BORROW ATMAXIMUM LT. BUT YOU MUST MEET THE MIN DCR 19 MAX LTV 85% 80% 20 MIN Debt Coverage Ratio (DCR) 1.40 1.75 21 TERM YEARS) 15 15 22 AMORTIZATION YEARS) 30 15 23 INTEREST RATE 7.00% 6.50% 24 CLOSING COSTS: 25 ORIGINATION FEE Lender) 1.00% 1.00% 28 OTHER NONLENDER FEES $ 2.500S 2.500 27 UNDERWRITING FEE Lender) S 300S 300 28 APPRAISAL $ 300 $ 300 29 SURVEY 500 S 500 30 TOTAL CLOSING COSTS 31 LENDER CLOSING COSTS 32 33 34 MORTGAGE OPTION 1 EBC 35 N PV PMT FV 38 PMT 37 OMB 38 EBC 39 40 Debt Coverage Ratio 41 slivors made 43 MORTGAGE OPTION 2 EBC N PV PMT FV YEAR O YEAR 1 YEAR 2 YEAR 3 YEAR 4 45 PMT 46 OMB EBC 48 49 Debt Coverage Ratio 50 51 52 PROFORMA 53 54 PGI 55 VCL 56 EGI 57 OE 58 CAPX 59 NOI 60 PURCHASE PRICE 61 62 SP 63 SELLING EXPENSES 18% 64 NSP 65 LOMB 67 TOTAL CASH FLOWS FOR DCF CALCULATION 68 69 DEBT COVERAGE RATIO EACH YEAR) 70 71 GOING IN CAP RATE 72 73 DCF APPROACH TO VALUE luse row 671 74 APPRAISER HAS ASSUMED A HOLDING PERIOD OF 3 YEARS IS APPROPRIATE 75 APPRAISER HAS ASSUMED A DISCOUNTRATE OF 14.515% IS APPROPRIATE 78 YEAR OMARKETVALUE 77 78 DIRECT CAP APPROACH TO VALUE 79 CAP RATE YEAR 2 11.00% 80 CAP RATE YEAR 3 10.00% 81 YEAR 2MARKETVALUE 83 84 OTHER MORTGAGE INFO FOR THE HOLDING PERIOD 85 TOTAL PRINCIPAL PAID 88 TOTAL INTERESTPAID 87 LENDER'S YIELD G A B E F 1 INPUTS 2 HOLDING PERIOD 3 YEARS 3 UNITS 50 4 MARKETRENT MONTHLY PER UNIT S 800 5 RENT INCREASE PER YEAR 1% 6 INITIAL PURCHASE PRICE 2.000.000 7 VACANCY LOSS 4% 8 CREDIT LOSS 1% 9 OPERATING EXPENSE RATIO 40% 10 CAPITAL EXPENDITURES 10% OF EGI 11 SELLING EXPENSES 6% 12 GOING OUT CAP RATE 10.00% 13 DISCOUNT RATE 12.00 14 15 16 Note: Comoule the payment using both lions which measured siles for ansifies for both. choose the mortgage with the lowest EBC) 17 MORTGAGE OPTION 1:1 MORTGAGE OPTION 2: 18 ASSUME YOU BORROW ATMAXIMUM LT. BUT YOU MUST MEET THE MIN DCR 19 MAX LTV 85% 80% 20 MIN Debt Coverage Ratio (DCR) 1.40 1.75 21 TERM YEARS) 15 15 22 AMORTIZATION YEARS) 30 15 23 INTEREST RATE 7.00% 6.50% 24 CLOSING COSTS: 25 ORIGINATION FEE Lender) 1.00% 1.00% 28 OTHER NONLENDER FEES $ 2.500S 2.500 27 UNDERWRITING FEE Lender) S 300S 300 28 APPRAISAL $ 300 $ 300 29 SURVEY 500 S 500 30 TOTAL CLOSING COSTS 31 LENDER CLOSING COSTS 32 33 34 MORTGAGE OPTION 1 EBC 35 N PV PMT FV 38 PMT 37 OMB 38 EBC 39 40 Debt Coverage Ratio 41 slivors made 43 MORTGAGE OPTION 2 EBC N PV PMT FV YEAR O YEAR 1 YEAR 2 YEAR 3 YEAR 4 45 PMT 46 OMB EBC 48 49 Debt Coverage Ratio 50 51 52 PROFORMA 53 54 PGI 55 VCL 56 EGI 57 OE 58 CAPX 59 NOI 60 PURCHASE PRICE 61 62 SP 63 SELLING EXPENSES 18% 64 NSP 65 LOMB 67 TOTAL CASH FLOWS FOR DCF CALCULATION 68 69 DEBT COVERAGE RATIO EACH YEAR) 70 71 GOING IN CAP RATE 72 73 DCF APPROACH TO VALUE luse row 671 74 APPRAISER HAS ASSUMED A HOLDING PERIOD OF 3 YEARS IS APPROPRIATE 75 APPRAISER HAS ASSUMED A DISCOUNTRATE OF 14.515% IS APPROPRIATE 78 YEAR OMARKETVALUE 77 78 DIRECT CAP APPROACH TO VALUE 79 CAP RATE YEAR 2 11.00% 80 CAP RATE YEAR 3 10.00% 81 YEAR 2MARKETVALUE 83 84 OTHER MORTGAGE INFO FOR THE HOLDING PERIOD 85 TOTAL PRINCIPAL PAID 88 TOTAL INTERESTPAID 87 LENDER'S YIELD