• Overview
  • Introduction
  • Features
    • Excel functions in EAC Tools
    • Macros for functions in EAC Tools
    • Macros for tables in EAC Tools
    • Macros for sheets in EAC Tools
  • Development
  • System requirements
  • Cybersecurity
  • Installation
  • Uninstallation
• Actuarial Mathematics
  • Mortality assumption
  • Interest rate assumption
  • Single life annuity
  • Joint life annuity
  • Actuarial equivalence
  • Commutation functions
  • Life expectancy and survival
  • Life insurance
  • Mortality improvement
  • Period certain annuity
• Excel Functions in EAC Tools
  • Complete list of functions
  • Single life functions
    • PVSL
    • PVSL12
    • Single life short cut functions
      • PVSLGAM83
      • PVSLGATT2003
      • PVSLPBGC
      • PVSLPPA
      • PVSLUP84
    • Single life level income
      • PVLI
      • PVSLLI
    • Single life cash refund
      • CashRefund
      • CashRefundJ
      • CashRefundPPA
    • Other single life functions
      • EIRSL
      • EIRSL12
      • MTVv8517
      • nEx
      • PreRetDisc
      • SLProb
  • Joint life functions
    • PVJL
    • PVJLX
    • PVJLX_WS
    • PVJL12
    • PVJL3
    • Joint life short cut functions
      • PVJLGAM83
      • PVJLGATT2003
      • PVJLPPA
      • PVJLUP84
    • PVJLLI
    • CashRefundJL
  • Actuarial equivalence functions
    • AE
    • AEERF
    • AELRF
    • AESLtoCL
    • AESLtoJL
    • AESLtoJL_WS
    • AESLtoLI
  • Age, date, more functions
    • AgeM, AgeY, AgeYM
    • AgeToText
    • AgeToTextLong
    • DateAdd
    • DateOfAge
    • DateToText
    • DateToTextLong
    • ElapsedMonths
    • HighAvg
    • SSNDash
  • Defined contribution plan functions
    • AcctBal
  • Commutation functions
    • Cx, Mx, Rx
    • Cxy, Mxy
    • Dx, Nx, Sx
    • Dxy, Nxy
    • Lx, Px, Qx
    • Lxy, Pxy, Qxy
    • LxPPA, PxPPA, QxPPA
    • SLComm
    • Wx
  • Interest rate functions
    • Minimum present value segment rates
      • SegRate
      • SegRateText
      • SegRateTextLong
      • SegRateX
    • Pension plan funding segment rates
      • ARPA
        • SegRateARPA
        • SegRateTextARPA
        • SegRateTextLongARPA
      • PPAMax
        • SegRatePPAMax
        • SegRateTextPPAMax
        • SegRateTextLongPPAMax
    • Treasury rates
      • TRate1
      • TRate3
      • TRate5
      • TRate10
      • TRate101
      • TRate30
      • TRate30IRS
    • Other interest functions
      • AnyRate
      • IntDesc
      • IntDisc
      • Rate120
      • SpotRate
  • Life expectancy and survival functions
    • AgeOfSurvival
    • EAAD
    • EAADPPA
    • RMD
      • IRSTable1, IRSTableSL
      • IRSTable2, IRSTableJL
      • IRSTable3, IRSTableUL
    • LifeExpect
    • LifeExpectJL
    • LifeExpectPPA
    • ProbSurvival
    • ProbSurvivalPPA
    • ProbSurvivalW
  • Life insurance functions
    • DecrLifeIns
    • DecrLifeInsJL
    • DecrLifeInsPPA
    • LifeIns
    • LifeInsJL
    • LifeInsPPA
  • More PV functions
    • EACInfo
    • MortDesc
    • MortProjFactor
    • MortProjFactor2
    • ProjScale
  • Period certain annuity functions
    • PVCO
    • PVCOPPA
  • Regulatory limits and other functions
    • AnyFunction
    • BLS functions
      • AdjustForInflation
      • CCPIU
      • CPIU
      • CPIU3Q
      • CPIW
    • IRS functions
      • Catchup
      • CatchupSIMPLE
      • CompLimit
      • Controli, Controliii
      • CovComp
      • DB415Limit
      • DC415Limit
      • DeferralLimit
      • DeferralLimit403
      • DeferralLimit457
      • DeferralLimitSIMPLE
      • ESOPLimitA, ESOPLimitB
      • HCEAmount
      • IRACatchup
      • IRALimit
      • IRSCOLA
      • KeyAmount
      • NonSpousePct
      • NumExpPay
      • SEPMin
    • PBGC functions
      • PBGCMax
      • PBGCMax50JS
      • PBGCPremium, PBGCPremiumCap, PBGCPremiumME, PBGCPremiumVar
      • PBGCXRACategory
      • PBGCXRAge
      • PVPBGCMax
    • Social Security functions
      • NAE
      • SocSec
      • SSBend1, SSBend2
      • SSBendFam1, SSBendFam2, SSBendFam3
      • SSSGABlind, SSSGANonBlind
      • SSCOLA
      • SSCovDomesticEe, SSCovElectionWrk
      • SSDOBofSSNRAinYear
      • SSEarlyRetDate
      • SSERA, SSEarlyRetAge
      • SSExemptLow, SSExemptHigh
      • SSFactor
      • SSMax
      • SSNormalRetDate
      • SSNRA, SSFRA, SSNormalRetAge
      • SSQC
      • SSTaxRate, SSTaxRateER, SSTaxRateSE
      • WageBase
      • WageBaseMed
      • WageBaseOld
      • WBTableYear
    • Medicare tax rate functions
      • MedTaxRate, MedTaxRateER, MedTaxRateSE
• Excel Tables in EAC Tools
• Excel Sheets in EAC Tools
• How To …
  • How to define a mortality table parameter
  • How to define an interest rate parameter
  • How to define a COLA parameter
  • How to set up a custom mortality table
  • How to set up a custom 1-D mortality improvement scale
  • How to set up a custom 2-D mortality improvement scale
  • How to set up a unisex mortality table
  • How to set up a lifetime income illustration
  • Upgrade from the old version of EAC Utilities
• Mortality Tables
  • Sources of mortality tables
  • List of mortality tables
    • Lump sum mortality tables
    • IRS §430(h) static tables
    • Disabled
    • ERISA
    • Group Annuity Mortality (1951, 1971, 1983, 1994)
    • Individual Annuity Mortality (1949, 1971, 1983, 2000, 2012)
    • Life
    • Other
    • PBGC
    • Pri-2012
    • Pub-2010
    • Pub-2016
    • RP-2000
    • RP-2006
    • RP-2014
    • Railroad Retirement Board
    • Social Security Period Life Tables
• Mortality Improvement Scales
  • Sources of mortality improvement scales
  • List of mortality improvement scales
    • 1-Dimentional mortality improvement scales
    • 2-Dimentional mortality improvement scales
    • MP mortality improvement scales
• Calculation Methodology
  • Summary of methods
  • Fractional ages (UDD)
  • Payments more frequent than annual
  • Woolhouse method
  • Balducci hypothesis
  • Method 0
  • Method 1
  • Method 2
  • Method 8
  • Method 9
• Audit a Formula
• Terms and Conditions
  • End-User License Agreement
  • Payment Policy
  • Privacy Policy
• Technical Support
• Ordering Information
• Acknowledgments