Outstanding Evolution by Day
The data model captures outstanding capital, amortizations, interests, net rent, and charges through views like Daily Outstanding Totals displaying daily outstanding amounts, Weekly Evolution showing weekly trends, Monthly Performance with aggregated monthly metrics, Customer Trends identifying outstanding trends by customers, and Product Breakdown segmenting outstanding by product categories. Additionally, maturities detail the repayment dates for the outstanding capital or debt.
Benefits of This Data Model
- Improved Financial Analysis: The data model allows for comprehensive tracking of outstanding capital, amortizations, interests, net rent, and charges, enabling detailed financial analysis for decision-making.
- Enhanced Performance Monitoring: With views like Daily Outstanding Totals, Weekly Evolution, and Monthly Performance, the data model provides insights into trends over different time frames, facilitating improved performance monitoring.
- Customer-Centric Insights: Through Customer Trends, the data model offers visibility into outstanding trends by customers, enabling businesses to tailor strategies and services based on customer behavior.
- Product Optimization: The Product Breakdown view segments outstanding by product categories, helping businesses identify profitable products and optimize their product offerings.
- Efficient Debt Management: By detailing repayment dates for outstanding capital or debt with the Maturities measure, the data model supports efficient debt management and planning.
Key Performance Indicators (KPIs)
- Outstanding Capital: The total amount of money that remains to be paid in capital at a specific point in time.
- Amortizations: The gradual paying off of a debt through regular installment payments over a set period, which decreases the outstanding balance.
- Interests: The amount of money charged by a lender to a borrower for the use of assets, calculated as a percentage of the principal sum.
- Net Rent: The total revenue generated from renting out a property after deducting expenses like maintenance, insurance, and taxes.
- Charges: Any additional fees or costs incurred in relation to the outstanding capital, such as processing fees, late payment charges, or other penalties.
- Maturities: The dates on which the outstanding capital or debt is due to be repaid in full.
Available Visualisations
| View Name | Description |
|---|---|
| Outstanding Evolution by Day | Shows total outstanding amount per day. |