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.
Watch the Amortization tool video to learn more.
Input
The Amortization tool requires one numeric and two date data sources.
Configuration
Use the following configuration options to configure the Amortization tool.
Go to the Pipes module from the side navigation bar.
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.
In the Pipe builder, add a data source to your pipe. For more information on adding a data source, see the Data Input tool.
Click
+ Tool.The Tools modal opens, where you can add tools, such as the Aggregate tool, to your pipe.
In the Tools modal, search for Amortization and then click + Add tool.
Note
You can also find the Amortization tool in the Calculate section.
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.
In the configuration pane, under Source column, select a numeric source from your data to use for amortizing.
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.
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. The tool automatically determines the start date.
Note
The Start with date column must be different than the End with column.
Under End with, select the period column to use for the maximum end date for the amortization. The tool automatically determines the end date.
Note
The End with date column must be different than the Start with column.
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)
Under Index columns, select any columns from your original data set to display with the amortized values.
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.
Usage example
Let's say that you want to analyze and identify trends in sales volume over multiple years in a specific region, using the following data:
Date | Total Sales Volume | Year | Date Add | Index |
|---|---|---|---|---|
2021-02-28 | 555470.58 | 2021 | 2021-11-30 | 63 |
2021-02-07 | 7222110 | 2021 | 2021-11-30 | 58 |
2021-03-21 | 496190.99 | 2021 | 2021-11-30 | 64 |
2021-03-21 | 393826.35 | 2021 | 2021-11-30 | 97 |
Using the Amortization tool, you can set the configuration to the Total Sales Volume column at an interest rate of 1% and the date range during which the interest accrues. In our example, we are applying a date range of 2021-01-03 to 2021-11-30, and a quarterly frequency. With this, you'll see the following data:
2021-Q1 | 2021-Q2 | 2021-Q3 | 2021-Q4 | Index | Total Sales Volume |
|---|---|---|---|---|---|
197234.36 | 201617.34 | 201617.34 | 0.00 | 63 | 555470.58 |
186610.30 | 180525.19 | 186610.30 | 186610.30 | 58 | 7222110 |
166252.90 | 169947.41 | 169947.41 | 0.00 | 64 | 496190.99 |
0.00 | 0.00 | 0.00 | 397764.61 | 97 | 393826.35 |