Calculating Severance and Notice Pay

An Excel file that teaches how to perform Making Severance and Notice Pay Calculation operation.

Excel Spreadsheet for Calculating Severance and Notice Pay

Service duration and fee parameters are entered into the table. Legal rates are read from a separate table. Seniority and notice amounts are calculated using a formula. Exceptions are explained in the notes section. The summary report shows the results item by item.

Hope it is useful.