Please fill all required fields
EBAR Formula:
Annual Method:
Employee data can be copied and pasted directly from 401ktest.com's test results:
The first 9 columns were placed in the same order as the excel output file created at the end of the testing process.
Happy Testing!
Projected Interest Rate (expected interest rate)
Standard Interest Rate (Should be between 7.5 and 8.5%)
Plan year-end
Retirement age, per plan
Employee Number
Name
Date of birth
(Hire Date)
(hours worked)
Compensation
(401k withheld)
(amt alloc. as catch-up cont)
Profit-Sharing Contribution
Attained age
Actual %
EBAR - Annual method
5/1/2025
12.00
1
225
1/1/2008
0.50
4
10
1/2/2008
21.00
4
10
1/3/2008
2,020.00
4
10
1/4/2008
45.00
4
10
1/5/2008
45.00
4
10
1/6/2008
45.00
4
10
1/7/2008
45.00
4
10
1/8/2008
45.00
4
10
1/9/2008
45.00
4
10
1/10/2008
45.00
4
10
1/11/2008
45.00
4
10
1/12/2008
45.00
4
10
1/13/2008
45.00
4
10
1/14/2008
45.00
4
10
1/15/2008
45.00
4
10
1/16/2008
45.00
4
10
1/17/2008
45.00
4
10
1/18/2008
45.00
4
10
1/19/2008
45.00
4
10
1/20/2008
45.00
4
10
1/21/2008
45.00
4
10
1/22/2008
45.00
4
10
1/23/2008
45.00
4
10
1/24/2008
45.00
4
10
1/25/2008
45.00
4
10
1/26/2008
45.00
4
10
1/27/2008
45.00
4
10
1/28/2008
45.00
4
10
1/29/2008
45.00
4
10
1/30/2008
45.00
4
10
1/31/2008
45.00
4
10
2/1/2008
45.00
4
10
2/2/2008
45.00
4
10
2/3/2008
45.00
4
10
2/4/2008
45.00
4
10
2/5/2008
45.00
4
10
2/6/2008
45.00
4
10
2/7/2008
45.00
4
10
2/8/2008
45.00
4
10
2/9/2008
45.00
4
10
2/10/2008
45.00
4
10
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.