Skip to main content

Varicent ELT Assistant

Amortization

Calculate amortization by selecting a numeric source column from your data. Use the Amortization tool to comply with ASC 606 preparation, ASC 606 amortization standards, or amortize your sales commissions.

Input

The Amortization tool requires one numeric and two date data sources.

Configuration

Use the following configuration options to configure the Amortization tool.

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In the Pipe builder, add at least two data sources to your pipe. For more information on adding a data source, see the Data Input tool.Data Input

  4. Click symon_add_icon.png + Tool.

    The Tools modal opens, where you can add tools, such as the  Aggregate  tool, to your pipe.

  5. In the Tools modal, search for Amortization and then click + Add tool.

    Note

    You can also find the Amortization tool in the Calculate section.

  6. Click the tool node and drag the line to the next tool to connect the tools. If you need to undo the action, click the line and then click Unlink.

  7. In the configuration pane, under Source column, select a numeric source from your data to use for amortizing.

  8. Under Interest rate, add the interest rate specific to the frequency. If you do not select an interest rate, the default is 0%.

    Tip

    For example, if the interest rate is 1%, and the frequency is quarterly, the interest rate is quarterly.

  9. Under Start with, select the period column to use for when the amortization payments are 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.

  10. Under End with, select the period column to use 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.

  11. Under Frequency, set the frequency of the amortization, choosing from one of 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)

  12. Under Index columns, select any columns from your original data set to display with the amortized values.

  13. Under Equal amortization amounts, select the checkbox to enable. If you enable this option, the values calculated are all for the same period. If you don't activate this option, the calculation accounts for the number of days within each period.