I have formula for finding monthly payment with four fields
- Loan Amount
- Interest Rate
- Terms of loan
- Monthly Payment
Formula: Monthly Payment =Loan amount * ((1 + Interest rate per annum/100) ^ Term of loan) / Term of loan / 12
Now I want to find
- Loan Amount
- Interest Rate
- Terms of loan
if any of three fields are populated.
I have also formula for calculating loan amount based on interest rate, terms of loan and monthly payment.
Formula: Loan amount = Monthly Payment/ ((1 + Interest rate per annum/100) ^ Term of loan) * Term of loan * 12
But it does not calculating perfect figure.
Any one can give me these three formulas for calculating loan amount/interest rate/terms of loan (java script will be more appreciated)
Here is mine,
the formula :
nerdWallet
Hope this helps in someway