People from across the country showed substantial interest in Reverse Mortgage Loan. And there were queries from ‘formula to calculate monthly payment’ to ‘paying the amount back to bank’. We cover all of this below:
Installment Amount = ((PV*LTVR-OTDA)*I)/ (((1+I)^n)-1)
Where, PV=Property Value;
OTDA=One Time Disbursement Amount;
n=No. Of Installment Payments;
I= the value of ‘I’ will depend on Disbursement Frequency selected.
Property Value (PV) = 10, 00,000
LTV Ratio (LTVR) =80%
One Time Disbursement Amount (OTDA) =0
Loan Disbursement Period=15 Years
Interest Rate (IR) = 9.25 %
Calculations: On the basis of the inputs:
The disbursement frequency selected is Monthly so ‘I’ will be IR/12(i.e. 9.25%/12)
No. of installment payments (n) will be calculated monthly e.g. if 15 is selected then the n=15*12=180
Putting the values in the formula:
Installment Amount=Rs.2, 070;
Here is a detailed example of Mr. Sharma, 62 years of age and own a property worth Rupees 1.5 Crores in Gurgaon. Mr. Sharma lives with his wife 59 years of age. Both his sons are married and settled abroad. On knowing about the merits of Reverse Mortgage Loan (RML), Mr. Sharma decided to check on the eligibility and monthly payment that he will be getting.
While he is clearly eligible for the same (find Reverse Mortgage Loan Eligibility criteria), he found it rather cumbersome to calculate the monthly payment that he will receive.
Property Value PV = 1.5 Crores (15000000)
Loan to Value Ratio (LTVR) = 80% (As specified by RBI)
One Time Disbursement Amount (OTDA) = 0 (No amount is disbursed in one go, instead banks pay monthly payments to applicant)
Loan Disbursement Period (n) = 15 years or 180 months
Disbursement frequency = Monthly
Current Interest Rate (I) = 10.25% yearly or (10.25/12)% = 0.854167% monthly
Calculating the monthly installment amount by putting all these value in given formula in excel:
Installment Amount = (((PV*LTVR)-OTDA)*I)/ (((1+I)^n)-1)
Installment amount = 28294
So, Mr. Sharma will be getting a monthly payment of Rupees 28294 for 15 years. Upon completion of 15 years, Mr. Sharma can either extend his Reverse Mortgage Loan (RML) payments or pay the outstanding amount to bank to get back his house.