function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
David PicksleyDavid Picksley 

How to calculate present value (PV) in formula

I have a formula (see below) which works in Excel and uses the -PV function (in bold). The PV function calculates the present value of a loan based on certain criteria. However, Salesforce doesn't recognise the function...

Is there a similar function/formula I can utilise to get the value I need?

The full formula
  
( Advance_Cost_Less_VAT__c - Predicted_Residual_Value__c /((1+(MAX( Base_Rate__c )+ Rate_Over_Base_Rate__c )/12)^( Subsequent_Rentals__c +IF( Residual_With_Final_Rental__c ="No",1,0))))/(-PV((MAX( Base_Rate__c )+ Rate_Over_Base_Rate__c )/12, Subsequent_Rentals__c ,1)+ Advance_Rentals__c )


  
(-PV((MAX( Base_Rate__c )+ Rate_Over_Base_Rate__c )/12, Subsequent_Rentals__c ,1)+ Advance_Rentals__c )


 
Raj VakatiRaj Vakati
There is no function in PV in salesforce .. you need to calculate the PV function on your own