Step 1: Enter General Information 📝
Navigate to the Debt Management section under the Financing menu.
Click on the "Add a new debt" button.
Fill in the following mandatory fields:
Name of the debt.
Capital amount (excluding tax for leasing).
Entity (if at consolidation level) where you have CashFlow access.
Currency, with the entity’s default currency suggested by default.
Optional fields:
Tags: Add labels like bank name or financing object to categorize your debt.
PDF Documents: Upload related documents (e.g., loan contracts). Files must be PDF and under 50MB.
Create expected transactions: Check this option to automatically create debt installments in your cash positioning module. You should also choose a bank account for your expected transactions.
Step 2: Define Debt Type and Interest Calculation 📊
Select the debt type:
Fixed rate loan
Variable rate loan
Leasing
Other
Choose how to input the amortization schedule:
Import the debt amortization schedule: in this case, no other parameters are needed, Agicap will simply apply the data in the given file. Here are the rules to have a validated file :
Upload an .xlsx file with your schedule.
Ensure it follows the file validation rules:
Each payment's total amount equals the sum of capital and interests.
The capital amount matches the sum of all capital payments.
Column names are correctly labeled (e.g., "Capital," "Interest").
Generate from financing conditions: in this case, you will need to enter the conditions, and Agicap will automatically generate the amortization schedule and compute the interests :
Enter the financing conditions, which differ depending on the debt type :
For Fixed Rate Loans:
Amortization type: Choose between constant amortization, constant annuities, or in fine.
Interest rate: Input as a decimal (e.g., 0.05 for 5%).
Number of instalments: Not necessary for constant annuities. Used for amortization plan generation.
Frequency: Monthly, quarterly, etc.
Loan start date, First instalment date and Capital paid back by installment: Used for amortization plan generation.
For Variable Rate Loans:
Amortization type: Choose between constant amortization or in fine (optional).
Interest rate components:
Margin: Bank's fixed rate.
Index: Reference rate (e.g., Euribor).
Calculation base: 360 or 365 days.
Number of instalments: Used for amortization plan generation. Required if an amortization type is selected
Frequency: Used only for amortization plan generation. Required if an amortization type is selected.
Loan start date, First instalment date and Capital paid back by installment: are used to compute the number of days for the interests of the first instalment. Required if an amortization type is selected.
Additional options:
Customize index value dates if different from the standard 2 days before installment date.
Add hedging instruments like caps or swaps to mitigate interest rate risks.
For Leasing:
Rent excluding tax and VAT rate.
Number of rents.
Frequency: Payment intervals.
First rent increased and Purchase options (if applicable).
💡 Note: For variable rate loans, Agicap automatically updates future interest calculations based on the latest index values.
Step 3: Review and Adjust the Debt Schedule 📅
Preview the generated or imported amortization schedule.
Optional Adjustments: Recompute interests automatically:
Active: Agicap recalculates interests based on updated conditions, ignoring manual changes to greyed-out columns.
Inactive: Agicap retains all values from the imported file, including interests.
Download the schedule as an Excel file if needed.
Finalize by clicking "Save".
💡 Tips
Use Tags: Organize and filter your debts using tags for easier management.
Expected Transactions: Enabling automatic expected transactions helps with cash positioning and bank account planning.
Document Storage: Keep all related documents in one place by uploading PDFs to each debt entry.
Hedging Instruments: Protect against interest rate fluctuations by adding caps or swaps to variable rate loans.
FAQ ❓
How do I add hedging instruments to my variable rate loan?
To add hedging instruments:
In Step 2, under Interest Calculation, click on "Add a hedging instrument".
Select the type (Cap or Swap).
Enter the rate, duration, and notional amount percentage.
Customize the period and amount as needed.
Can I edit the amortization schedule after creating the debt?
Yes, you can:
Edit the debt entry from the Debt Management page.
In Step 3, import a new schedule or adjust financing conditions in Step 2 to regenerate it.
Save the changes to update the schedule.
How do expected transactions linked to a debt work?
When you enable Create expected transactions related to this debt:
Agicap generates expected transactions for installments due in the next 6 months.
These transactions appear in your cash positioning and are automatically updated.
They are automatically deleted once due and cannot be manually reconciled.
Can I assign debts to different entities within a consolidation?
Yes:
When adding a debt at the consolidation level, select the entity on which you have CashFlow access.
Users can only add or edit debts for entities they have access to.
What if my debt has payment dates outside 1900 to 2100?
Currently, Agicap supports payment due dates only within the 1900 to 2100 range. Payments outside this range cannot be added.