Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

please fill in the yellow. I am totally lost image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fixed Income Securities Tools For Todays Markets

Authors: Bruce Tuckman, Angel Serrat

3rd Edition

0470891696, 978-0470891698

More Books

Students also viewed these Finance questions