California State Controller's seal

Lump Sum Calculators

If you have Microsoft Excel (Macintosh or PC) or a spreadsheet software application that can read an XLS file, you can download a spreadsheet. This spreadsheet will help you calculate the lump sum calculations. This may be useful to help you determine the maximum amounts an employee can defer in a full month and/or partial month.

If you are having difficulty viewing the input calculation screen, press and hold the "Ctrl" key then tap the F10 key to "maximize" the viewing screen.  For a full screen view of the Excel file double click the title bar area.

Partial Month Lump Sum

Full Month Lump Sum