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”. |
Related Topics