Current Value Calculation suffers influence from system interest (market opportunity), used to calculate deflation of values to current value (parameter MV_JUROS).

The value shown on Quotation Analysis is used as reference for current value, according to interest rate and payment condition used on the quotation.

Example of formula used to prepare calculation

in a Quotation with:

• Quantity = 100
• Unit Value = R$ 9.00
• Total Value = R$ 900.00
• Payment Condition = 30 days
• Financial Rate = 5.00%
• ICMS Rate = 18.00%

OnQuotation Analysis the current value is = R$ 858.54, because:

ValPres = 900.00 / (  (  1 + ( 5 / 100 ) ) **  ( 29 / 30 ) )

ValPres = 900.00 /  (  1.05  **  ( 0.96666667 ) )

ValPres = 900.00 /  1.04829373

ValPres = 858.54

In case of ICMS incidence, after calculating the current value, make the deduction.

18% from 900.00 = 162.00  

ValPres =  858.54 -  162.00

ValPres =  696.54

If Payment Condition is on the field Cond. Days (E4_DDD) equals D = Date, the amount is calculated on 29 days. If you wish to use 30 days, edit the field Cond. Days to out of day and the calculation will be:

ValPres =  900,00 / (  (  1 + ( 5 / 100 ) ) **  ( 30 / 30 ) )

ValPres =  900.00 /  (  1.05  **  ( 1 ) )

ValPres =  900.00 /  1.05

ValPres =  857.14

ValPres =  857.14 -  162.00

ValPres =  695.14

Calculation of the same Quotation using a Payment Condition with 3 equal installments 30,60 and 90 days:

Make the calculation in each installment of 300,00 and sum:

ValPres1Parc  :=  300,00 / (  (  1 + ( 5 / 100 ) ) **  ( 30 / 30 ) )

ValPres1Parc :=  300.00 /  (  1.05  **  ( 1 ) )

ValPres1Parc :=  300.00 /  1.05

ValPres1Parc :=  285.71428571

ValPres2Parc :=  300.00 / (  (  1 + ( 5 / 100 ) ) **  ( 60 / 30 ) )

ValPres2Parc :=  300.00 /  (  1.05  **  ( 2 ) )

ValPres2Parc :=  300.00 /  1.1025000

ValPres2Parc :=  272.10884354

ValPres3Parc :=  300.00 / (  (  1 + ( 5 / 100 ) ) **  ( 90 / 30 ) )

ValPres3Parc :=  300.00 /  (  1.05  **  ( 3 ) )

ValPres3Parc :=  300.00 /  1.157625000

ValPres3Parc :=  259.15127956

CURRENT VALUE = 285.71428571 + 272.10884354 + 259.15127956

CURRENT VALUE = 816.97 – 162.00 (ICMS), if any

CURRENT VALUE = 654.97  

FORMULA SINTAXE:

Installment Current Value = Installment Value  / (  (  1+ ( Interest Rate)  )  **  ( Installment Term / 30 )  )

End Current Value = sum of current value of installments