Outstanding Evolution by Year
The data model includes views that capture the outstanding evolution by year, monthly outstanding trend, quarterly performance analysis, and yearly growth comparison. Measures such as outstanding capital, amortizations, interests, net rent, charges, and maturities are utilized to analyze trends, variations, progress, and growth rates related to loan repayments, investments, rental income, expenses, fees, and payments due over specific time intervals for informed credit and collection strategy decisions.
Benefits of This Data Model
- Enhanced Trend Analysis: The data model allows for in-depth analysis of outstanding balances over different time frames, enabling identification of trends and patterns for strategic decision-making.
- Granular Performance Evaluation: By utilizing measures such as outstanding capital, amortizations, interests, net rent, charges, and maturities, the data model enables detailed performance evaluation concerning loan repayments, investments, rental income, expenses, and payments due.
- Improved Decision-Making: The data model provides a comprehensive view of quarterly performance and yearly growth comparison, empowering stakeholders to make well-informed decisions related to credit and collection strategies.
Key Performance Indicators (KPIs)
- Outstanding Capital: The total amount of capital that is yet to be repaid on a loan or investment over time.
- Amortizations: The gradual paydown of a loan or investment over time through scheduled payments comprising both interest and principal amounts.
- Interests: The total amount of interest accrued on a loan or investment over time that needs to be paid in addition to the principal amount.
- Net Rent: The total rental income received after deducting any expenses or costs associated with the property or asset.
- Charges: Any additional fees or costs incurred in relation to the loan, investment, or asset that need to be accounted for.
- Maturities: The total amount of principal and interest payments due on a loan or investment at specific time intervals as they become payable.
Available Visualisations
| View Name | Description |
|---|---|
| Outstanding Evolution by Year | Tracks outstanding balances year-over-year to identify trends and patterns. |