Excel Functions in EAC ToolsExcel Functions in EAC Tools\Defined contribution plan functionsDefined contribution plan functions\AcctBal

AcctBal

AcctBal returns a projected (defined contribution) account balance, optionally taking into account statutory amounts including:

·        compensation limits,

·        elective deferral limits,

·        catch-up contributions.

Syntax

AcctBal (CurrentAge, ProjectedAge, CurrentBal, Salary, ContribRate, SalIncRate, ROR, Inflation, CurrentDate, [ContributionTiming], [ApplyCompLimit], [ApplyDeferralLimit], [ApplyCatchUp])

Parameter Name

Description

CurrentAge

Age at CurrentDate.

ProjectedAge

Age to project the account balance to.

CurrentBal

Account balance at CurrentDate.

Salary

Compensation for the year beginning on the CurrentDate.

ContribRate

Percent of annual salary contributed to the account.

SalIncRate

Rate of future increase in salary.

ROR

Effective annual rate of return on account balance.

Inflation

Rate of inflation as measured by CPI-U to project future IRS limits.

CurrentDate

Date of current age, salary, and account balance.

ContributionTiming

Method of interest calculation in year of contribution:

·        0 = contribution gets 1/2 year's interest

·        1 = contribution made at year-end with no interest

Optional, default = 0.

ApplyCompLimit

401(a)(17) compensation limit:

·        yes = “y,yes, 1

·        no = “n,no, 0, blank

Optional, default = “no”.

ApplyDeferralLimit

402(g)(1) elective deferral limit:

·        yes = “y,yes, 1

·        no = “n,no, 0, blank

Optional, default = “no”.

ApplyCatchUp

414(v)(2)(B)(i) catch-up contribution. Applies only if ApplyDeferralLimit is used.

·        yes = “y,yes, 1

·        no = “n,no, 0, blank

Optional, default = “no”.