2022/11/09 - Fairways Debt - New fields in the template provided to import transactions - Update your Template!

Fairways Debt enables you to batch/bulk import transactions using a dedicated template, provided as an Excel file.

This template has been enriched with new fields as a result of the implementation of constant annuities extended beyond the transaction maturity and the equivalent compounding rate.

From now on, please make sure you use the latest template version.

You will find below the list of the new fields grouped in the relevant tabs.

  • Tab Imp_NewCreditFacilityDrawingFor
    • Equivalent Compounding Rate
    • Annual Capitalization Frequency

      Both fields are optional and can only be used with a "Fixed" index.

  • Tab Imp_NewBondForm
    • Extended Constant Annuity Date

      This field can only be used with a "Fixed" index and is mandatory if the amortization type selected is "Extended Constant Annuity" (otherwise, it is optional).

  • Tab Imp_NewVanillaLoanForm
    • Extended Constant Annuity Date

      This field can only be used with a "Fixed" index and is mandatory if the amortization type selected is "Extended Constant Annuity" (otherwise, it is optional).

    • Equivalent Compounding Rate
    • Annual Capitalization Frequency

      All fields are optional and can only be used with a "Fixed" index.

Was this article helpful?
0 out of 0 found this helpful