Metrics define the measurements to meet in a covenant. Scenarios enable you to simulate different cases using different metrics.
Prerequisite
Navigate to the Debt & Derivatives Application
- Log in to your Fairways Debt account and select a customer account, if relevant.
- Navigate to Applications
> Debt & Derivatives.
- Navigate to Entities.
Export an Entity Scenario
- Click the name of the relevant entity.
- Click Settings
> Export to Excel.
The entity scenario details display in a file.
Read the Covenant Overview File
File
| Sheet | Description |
|---|---|
| Covenant Overview | Details of the exported scenario. |
| Manual Metrics | Details of the manual metrics of the scenario. |
| Parameters | Exportation details. |
Covenant Overview Sheet
| Header | Description |
|---|---|
| Transaction | Transaction associated with the covenant. |
| Lender | Lender of the transaction. |
| Covenant | Metric associated with the covenant. |
| Expected Value | Threshold required for the covenant to be compliant. |
| [Period] | Data of the exported scenario. |
Manual Metrics Sheet
| Header | Description |
|---|---|
| Manual Metrics | Name of the manual metric. |
| Format | Data type of the metric. |
| [Period] | Data of the manual metrics applied to the scenario. |
Parameters Sheet
| Header | Description |
|---|---|
| User | User who exported the file. |
| Organization | Organization where the entity belongs. |
| Entity | Name of the entity. |
| Name | Name of the exported file. |
| Timestamp | Date and time at which the file was exported. |
| Analysis Date | Date for which the data displays. |
| Consolidation Currency | Currency applied to the data. |
| Scenario | Name of the exported scenario. |