You need to sign in to do that
Don't have an account?
Jason D Moore
I am trying to create a formula in SALESFORCE that calculates the "Loan Amount" using the following fields:
Interest Rate [ 6.00% ]
Loan Term [ 30 ]
Annual Loan Instalments [ 52 ]
Total Loan Instalments [ 1,560 ]
Loan Repayment [ 300 ]
Loan Amount [ ? ]
Similar Microsoft Excel Formula: PV (rate, nper, pmt, [fv], [type])
Does anyone have the SALESFORCE formula that can calculate the "Loan Amount" using these fields?
Calculating the "LOAN AMOUNT"
I am trying to create a formula in SALESFORCE that calculates the "Loan Amount" using the following fields:
Interest Rate [ 6.00% ]
Loan Term [ 30 ]
Annual Loan Instalments [ 52 ]
Total Loan Instalments [ 1,560 ]
Loan Repayment [ 300 ]
Loan Amount [ ? ]
Similar Microsoft Excel Formula: PV (rate, nper, pmt, [fv], [type])
Does anyone have the SALESFORCE formula that can calculate the "Loan Amount" using these fields?
Loan_Amount__c = (Loan_Repayment__c * (((1+( Interest_Rate__c /52))^ Term__c) -1))/(( Interest_Rate__c /52)*((1+( Interest_Rate__c /52))^ Term__c))
All Answers
Mark as best answer, If it resloves !!
Please check below link
http://https://success.salesforce.com/answers?id=90630000000gh0qAAA
Salesforce was able to help build this PV formula for me. It works for a regular payment stream. They said they were going to create a knowledge article based on the formula they were able to build so that others could benefit from it. I need to look and see if its published out there yet.
Check these formula sheets
https://na1.salesforce.com/help/doc/en/salesforce_formulas_cheatsheet.pdf
If you did not find answers :(
Please help me to elabrote more about functionality of formula with an example, i can help you to design
Mark as resloved if it helps :) :)
Thanks,
Bhanu Prakash
visit ForceLearn.com (https://www.forcelearn.com/)
Loan_Amount__c = (Loan_Repayment__c * (((1+( Interest_Rate__c /52))^ Term__c) -1))/(( Interest_Rate__c /52)*((1+( Interest_Rate__c /52))^ Term__c))
Loan_Amount1__c *( (ROI1__c * 100) /12/100)*((1+((ROI1__c*100) / 12/100)) ^ Tenure1__c) /(((1+((ROI1__c*100)/12/100)) ^ Tenure1__c) -1)
ROI1__c = When are you define Percentage filed that time Multiply bu 100(Rate of Interest).
Tenure1__c = Month
Loan_Amount1__c = Enter Loan Amount