Public Formula Library

PURCHWITHWAGEREDPF

Just for viewing purposes. You can store and calculate this formula only inside the application.

Formula name

PURCHWITHWAGEREDPF

Description

Purchasing Pension Fund with salary reduction

Syntax

MaxPurch = CALL("MAXPOSSIBLEPURCHPF",PurchasingMax)
IF MaxPurch = 0
InputErrorAgeOrSalary = 100
ELSE
IF CASHDEP < MaxPurch
Ag = CALL("MAXPOSSIBLEPURCHPF",Ag)
NM = CALL("MAXPOSSIBLEPURCHPF",NM)
PVF1 = TAB(PRESVALFAC,Ag)
PVF2 = TAB(PRESVALFAC,Ag+ 1)
PVFakt = (PVF1 * (12 - NM) + (PVF2 * NM)) / 12
Reduction = RND(((MaxPurch - CASHDEP) * TAB(SALREDFACT,Ag) / PVFakt),0)
PSNew = CALL("MAXPOSSIBLEPURCHPF",PS) - Reduction
PurchasingOpen = MaxPurch - CASHDEP
...

Notes

Ag = Age
NM = Mumber months in Age Ag
PVF= Present value factor
PSNew = reduced insured salary
VBPolicy = Vested benefits policy

Category / Subcategory

Insurance / Pensionfunds

Creator

pkuser@abacal.com

Account

Free

Tags

formula pension fund purchase person age salary reduction

return Register now