XPo=B4/$B$4B4 = S x0

1/(1+i)^x= (1+$D$1)^-A4D1 = i le tauxA4 = ge 0

1/(1+i)^0,5= (1+$D$1)^-0,5D1 = i le taux

1Px=B5/B4B5 = S x1 B4 = S x0

1dx=1-F4F4 =1Px

DxXPo * 1/(1+i)^x

CxDx0 * (1-Sx1/Sx0) * (1+$i%$)^-0,5

Nx=SOMME (H4:$H$110)Somme de Dx

Mx=SOMME (I4:$I$110)Somme de Cx

contrat vie entire = Cd * Mx/Dx

P = Cd * Mx/Nx

contrat capital diffr = Cv * Dx+n/Dx

P = Cv * Dx+n/(Nx Nx+n)

contrat temporaire dcs = Cd * (Mx-Mx+n)/Dx

P = Cd * (Mx-Mx+n)/(Nx - Nx+n)

contrat mixte(C dcs + C cap diffr) = Cd * (Mx-Mx+n)/Dx + Cv * Dx+n/Dx

P= (Cd *(Mx-Mx+n)+ Cv*Dx+n)/(Nx - Nx+n)

Prime commerciale

contrat capital diffr

= CV * Dx+n / Dx P = CV * Dx+n / (Nx - Nx+n)

' = 1/(1-Com) * (Cv*(Nx - Nx+n)/Dx + Cv * Dx+n/Dx)

P' = 1/((1-Com) * (Nx - Nx+n)) * (FGCv * Cv * (Nx - Nx+n) + Cv * Dx+n )

contrat temporaire dcs = Cd * (Mx - Mx+n) / Dx P = Cd * (Mx - Mx+n) / (Nx - Nx+n)

' = 1/(1-Com) * (FGCv * Cd * (Nx - Nx+n) / Dx + Cd * (Mx - Mx+n) / Dx)

P' = 1/((1-Com) * (Nx - Nx+n)) * (FGCv * Cd * (Nx - Nx+n) + Cd * (Mx - Mx+n) )