You need to sign in to do that
Don't have an account?
Jason D Moore
Calculating the "LOAN PERIOD"
I am trying to create a SALESFORCE formula that calculates the "Loan Period" using the following fields:
Interest Rate [ 6.00% ]
Loan Period [ ? ]
Annual Loan Instalments [ 52 ]
Total Loan Instalments [ 1,560 ]
Loan Repayment [ 150 ]
Similar Microsoft Formula: NPER (rate, pmt, pv, [fv], [type])
Does anyone have the SALESFORCE formula that can calculate the "Loan Period" using these fields? Thanks
Interest Rate [ 6.00% ]
Loan Period [ ? ]
Annual Loan Instalments [ 52 ]
Total Loan Instalments [ 1,560 ]
Loan Repayment [ 150 ]
Similar Microsoft Formula: NPER (rate, pmt, pv, [fv], [type])
Does anyone have the SALESFORCE formula that can calculate the "Loan Period" using these fields? Thanks
THIS FORMULA HAS THE SAME RESULT AS THE MS EXCEL "NPER" FORMULA
Loan_Period__c = LOG((Loan_Repayment__c /(Loan_Repayment__c - (Loan_Amount__c * ( Interest_Rate__c/52))))) / (52 * LOG((1+(Interest_Rate__c /52))))
All Answers
I have an Apex Helper call SodaFinancialHelper. I jsut copy past some of my function here . hope this help
THIS FORMULA HAS THE SAME RESULT AS THE MS EXCEL "NPER" FORMULA
Loan_Period__c = LOG((Loan_Repayment__c /(Loan_Repayment__c - (Loan_Amount__c * ( Interest_Rate__c/52))))) / (52 * LOG((1+(Interest_Rate__c /52))))
You can find it at: https://github.com/jeffdonthemic/apex-financials
Jeff Douglas
Trailhead