What is the indicated equity dividend rate (RE) of a property with a sale price of $400,000, an NOI of $35,000, and mortgage terms of 9.75% interest for 25 years, fully amortized with monthly payments and a loan-to-value ratio of 65%?
Total Mortgage Payment per year = Monthly Payment * 12
Monthly Payment = Loan Value / PVAF(0.8125%,300)
Monthly Payment = 400000 * 65% / 112.21614
Monthly Payment = $2316.96
Total Mortgage Payment per year = Monthly Payment * 12
Total Mortgage Payment per year = $2316.96 * 12
Total Mortgage Payment per year = $27803.49
Down Payment = Sale Price * (1 - Loan Value) = 400000 * 35% = $140000
Indicated Equity Dividend Rate = (NOI - Mortgage Payments) / Down payment
Indicated Equity Dividend Rate = (35000 - 27803.49) / 140000
Indicated Equity Dividend Rate = 5.14%
Please upvote if satisfied
Get Answers For Free
Most questions answered within 1 hours.