Linha Microsiga Protheus - Inglês

Páginas filhas
  • Calculation Methodology for CDI Investments (Financial Process Script - SIGAFIN)

The calculation of the variation in CDI accrued between periods is performed according to the following formula:

 

where:

C = result of the rates DI-CETIP Over using the percentage highlighted, from the initial date (included) up to the final date (exclusive), calculated with the rounding of 8 (eight) decimal places.

n = total number of rates DI-CETIP Over, where n an integer.

p = highlighted percentage for payment, with 4 (four) decimal places.

 = Rate DI-CETIP Over, expressed in days, calculated with the rounding of 8 (eight) decimal places.

For CDI rates published up to 12/31/97, the formula DI-CETIP Over must be used: :

Formula 1

, where: k = 1, 2, ..., n


Example:

Percentage highlighted for payment: 97.5000

K

DI

TDI (DI/3000)

TDI * (P/100)

(1+TDI * (P/100)) * k-1 = Fator k

1

16.62

0.00554000

0.00540150

1.00540150

2

16.63

0.00554333

0.00540475

1.01083544

3

16.74

0.00558000

0.00544050

1.01633489

4

16.70

0.00556667

0.00542750

1.02185105


k-1 = (1+TDI * (p/100) of k -1, except when k=1, once the multiplier is 1.

For the CDI rates published after 1/1/98, the formula must be:

Formula 2

, where: k = 1, 2, ..., n


Example:

Percentage highlighted for payment: 97.5000

K

DI

TDI (DI/3000)

TDI * (P/100)

(1+TDI * (P/100)) * k-1 = Fator k

1

16.62

0.00061031

0.00059505

1.000580174

2

16.63

0.00061065

0.00059538

1.001161008

3

16.74

0.00061439

0.00059903

1.001745742

4

16.70

0.00061303

0.00059770

1.002329521


Multiplying K for CDI balance, the updated value is presented (includes interest). Subtracting the balance of the updated value, the amount presented is the interest.


Tip:

As the rate DI-CETIP Over was published until 12/31/97 on a monthly basis, formula 1 was used to calculate the variation. However, if even after 12/31/97 the rate is still registered in SM2 on a monthly basis, the parameter MV_BASECDI must be used for the system to calculate income correctly.