Skip to main content

Outstanding Evolution by Quarter

The data model includes dimensions such as Outstanding Capital, Amortizations, Interests, Net Rent, Charges, and Maturities. The model allows for analyzing Quarterly Outstanding Trends, which display the variations in outstanding amounts quarterly, and also enables the identification of Top Customers by Outstanding Amount, ranking customers based on their outstanding balances each quarter. This facilitates tracking the distribution and trends in financial obligations and customer relationships over time.

Benefits of This Data Model​

  • Improved Financial Analysis: The data model enables in-depth analysis of outstanding capital, amortizations, interests, net rent, charges, and maturities, providing valuable insights into financial trends over time.
  • Enhanced Customer Relationship Management: By identifying top customers based on outstanding amounts each quarter, the model supports effective customer relationship management strategies tailored to customers' financial obligations.
  • Comprehensive Trend Tracking: With dimensions like start date, end date, and quarter descriptions, the model facilitates tracking quarterly outstanding trends, offering a comprehensive view of variations in financial obligations over time.
  • Efficient Portfolio Management: Through dimensions such as transaction type, portfolio, and link number, the model helps in managing and optimizing portfolios by providing insights into transaction details and linkages between various financial elements.

Key Performance Indicators (KPIs)​

  • Outstanding Capital: The total amount of capital that remains outstanding for loans or debts.
  • Amortizations: The gradual paying off of a debt over time through regular payments.
  • Interests: The amount of money charged by a lender for the use of borrowed funds, calculated as a percentage of the principal.
  • Net Rent: The net income generated from rent after deducting expenses like taxes, insurance, and maintenance costs.
  • Charges: Additional costs or fees incurred in relation to the outstanding capital or loans.
  • Maturities: The due dates for the repayment of loans or debts.

Available Visualisations​

View NameDescription
Outstanding Evolution by QuarterShows trends in outstanding amounts by quarter.