Skip to main content

Varicent ELT Help Center

Amortization

Abstract

Calculate amortization by selecting a numeric source column from your data.

Select a numeric source column from your data to use for amortization. Configure the following fields to calculate the amortization:

Table 35. Amortization tool configuration

Field

Description

Source column

Select a numeric source from your data to use for amortizing.

Interest rate

Add the interest rate specific to the frequency. For example, if the interest rate is 1%, and the frequency is quarterly, the interest rate is quarterly. Note: If you do not select an interest rate, the default is 0%.

Start with

The date column in which the first amortization payment is due. The minimum start date determines the date from the data. Varicent ELT automatically determines the start date.

Note

The Start with date column must be different than the End with column.

End with

The date column in your data for the maximum end date for the amortization. Varicent ELT automatically determines the end date.

Note

The End with date column must be different than the Start with column.

Frequency

Select the frequency of the amortization. Choose from the following options:

  • Annually (Once a year)

  • Quarterly (Four times a year)

  • Monthly (12 times a year)

  • Biweekly (26 times a year)

  • Weekly (52 times a year)

Index columns

Select any columns from your original data set to display with the amortized values.

Equal amortization amounts

Select to enable.If you enable this option, the values calculated are all for the same per period. If you disable this option, the calculation accounts for the number of days within each period.



When to use this tool

Use this tool to comply with ASC 606 preparation, ASC 606 amortization standards or amortize your sales commissions.