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) )
Top Related