please fill in the yellow. I am totally lost
1 INPUTS 2 HOLDING PERIOD 3 YEARS 3 UNITS 50 4 MARKET RENT (MONTHLY PER UNIT 5 800 5 RENT INCREASE PER YEAR 190 6 INITIAL PURCHASE PRICE $ 2,000,000 7 VACANCY LOSS 4% 8 CREDIT LOSS 9 OPERATING EXPENSE RATIO 40% 10 CAPITAL EXPENDITURES 10% OF EGI 11 SELLINO EXPENSES 12 GONG OUT CAP RATE 10.00% 13 DISCOUNT RATE 12.00% 14 15 16 Note Compute the payment using both options to see which mortonge the subject property is for in qualities for both choose the mortgage with the lowest EBC) 17 MORTGAGE OPTION 1 MORTGAGE OPTION 2: 18 ASSUME YOU BORROW AT MAXIMUM LTM BUT YOU MUST MEET THE MINDCR 19 MAXLIV 8596 20 MIN Debi Coverage Ratio (DCR) 1.40 175 21 TERM (YEARS) 15 15 22 AMORTIZATION YEARS) 30 151 23 INTEREST RATE 700% 6 50%! 24 CLOSING COSTS 25 GRIGNATION FEE (Lender) 100% 100% 26 OTHER NONLENDER FEES 2.500 5 2.500 27 UNDERWRITING FEE (Lender) $ 3005 300 28 APRAISAL 300S 300 20 SURVEY 500 50 8023 N PV PMT FV 34 MORTGAGE OPTION 1 EBC 35 36 PMT 37 OMB 38 EBC 39 40 Debt Coverage Risto 41 Quality for this mortgage? 42 1 INPUTS 2 HOLDING PERIOD 3 YEARS 3 UNITS 50 4 MARKET RENT (MONTHLY PER UNIT 5 800 5 RENT INCREASE PER YEAR 190 6 INITIAL PURCHASE PRICE $ 2,000,000 7 VACANCY LOSS 4% 8 CREDIT LOSS 9 OPERATING EXPENSE RATIO 40% 10 CAPITAL EXPENDITURES 10% OF EGI 11 SELLINO EXPENSES 12 GONG OUT CAP RATE 10.00% 13 DISCOUNT RATE 12.00% 14 15 16 Note Compute the payment using both options to see which mortonge the subject property is for in qualities for both choose the mortgage with the lowest EBC) 17 MORTGAGE OPTION 1 MORTGAGE OPTION 2: 18 ASSUME YOU BORROW AT MAXIMUM LTM BUT YOU MUST MEET THE MINDCR 19 MAXLIV 8596 20 MIN Debi Coverage Ratio (DCR) 1.40 175 21 TERM (YEARS) 15 15 22 AMORTIZATION YEARS) 30 151 23 INTEREST RATE 700% 6 50%! 24 CLOSING COSTS 25 GRIGNATION FEE (Lender) 100% 100% 26 OTHER NONLENDER FEES 2.500 5 2.500 27 UNDERWRITING FEE (Lender) $ 3005 300 28 APRAISAL 300S 300 20 SURVEY 500 50 8023 N PV PMT FV 34 MORTGAGE OPTION 1 EBC 35 36 PMT 37 OMB 38 EBC 39 40 Debt Coverage Risto 41 Quality for this mortgage? 42