Question: PLEASE SHOW WORK AND ALL FORMULAS USED, THANK YOU! this is all the question provides A property is expected to have NOI of $100,000 in

 PLEASE SHOW WORK AND ALL FORMULAS USED, THANK YOU! this is

PLEASE SHOW WORK AND ALL FORMULAS USED, THANK YOU!

this is all the question provides

A property is expected to have NOI of $100,000 in the first year. The NOI is expected to increase by 3 percent per year thereafter. The appraised value of the property is currently $1 million and the lender is willing to make a $900,000 participation loan with a contract interest rate of 8 percent. The loan will be amortized with equal monthly payments over a 20-year term (a constant payment mortgage). In addition to the regular mortgage payments, the lender will receive 50 percent of the NOI in excess of $100,000 each year until the loan is repaid. The lender also will receive 50 percent of any increase in the value of the property. The loan includes a substantial prepayment penalty for repayment before year 5, and the balance of the loan is due in year 10. (If the property has not been sold, the participation will be based on the appraised value of the property.) Assume that the appraiser would estimate the value in year 10 by dividing the NOI for year 11 by a 10 percent capitalization rate. a) How much is the mortgage payment per year? b) How much the lender receives for the appreciation of the property value in year 10? c) Please list the cash flow to lender from year 0 to year 10. d) Calculate the effective cost (in percentage) to the borrower of the participation loan assuming the loan is held for 10 years. Note that this is also the expected return to the lender (in percentage)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!