The effective cost of the participation loan can be calculated by considering the monthly mortgage payments, the excess NOI payments, and the increase in property value.
1. Monthly Mortgage Payments:
The loan amount is $1,125,000 and the contract interest rate is 5.5 percent. The loan term is 20 years, which is equivalent to 240 months. We can use a loan amortization formula to calculate the monthly mortgage payment.
2. Excess NOI Payments:
The lender will receive 50 percent of the NOI in excess of $100,000 each year until the loan is repaid. We need to calculate the excess NOI for each year and find the present value of these payments over the 10-year period.
3. Increase in Property Value:
The lender will also receive 50 percent of any increase in the value of the property. We need to calculate the increase in property value over the 10-year period and find the present value of this payment.
4. Prepayment Penalty:
If the loan is repaid before year 5, there is a substantial prepayment penalty. However, since we are assuming the loan is held for 10 years, this penalty does not apply.
5. Effective Cost Calculation:
To calculate the effective cost of the participation loan, we add the present value of the excess NOI payments and the present value of the increase in property value to the loan amount. We then divide this total by the present value of the monthly mortgage payments.
Please note that specific calculations and formulas are required to find the monthly mortgage payment, excess NOI payments, increase in property value, and present value calculations. It would be helpful to have these additional details to provide a more accurate and precise answer.
If you have any further questions or need assistance with specific calculations, please let me know.