This metric measures the average length of time individuals are employed by the organization. To calculate tenure, subtract an employee's (employment) start date from the current date or termination date when employee has departed and calculate the average for all employees.
Fortunately, Excel can be used to create an amortization schedule. The amortization schedule template below can be used for a variable number of periods, as well as extra payments and variable interest rates.