Creating Amortization Rows

Amortization rows, when selected, display an amortization table. These rows include a variable and equation. It can also have an optional label. (It must be present but can be ""). It also can include the keyword noemail.

Amortization Basics

This is the basic structure of an amortization row:

"" A variable:amTable(...) ::
"Label" A variable:amTable(...) ::

Text label displayed to the template's user. It is optional, as demonstrated by the first structural example above. When excluded, the label "Amortization Table" is displayed. The label is not used in an equation (variables are). This can be a single word (i.e. Periods) or multiple words (i.e., "Present Value"). If multiple words it must be in quotation marks. (details here)

This letter indicates that this row is an amortization type.

Reference name for the row. This variable must be unique for each row. (details here)

Colon [:]
Separates the variable from equation. If there is no equation then the colon should be eliminated as well.

Formula to calculate. Amortization rows always use the amTable function.

Double-Colon [::]
Indicates the end of the row. This is optional for the template's final row.


Keywords help define special characteristics of the row. For amortization tables there is only one keyword available, noemail. It is optional:

"" A noemail variable:amTable(...) ::

Normally amortization tables are attached to the email message. The keyword noemail will keep the amortization table from being included when sent.