Description: The Bank Loan Report project aims to develop an insightful analysis tool for monitoring and assessing lending activities and performance within our bank. By analyzing key loan-related metrics, the report facilitates data-driven decisions and strategic planning to optimize lending strategies.
Objective: The objective of the Bank Loan Report project is to provide detailed insights into crucial loan metrics over time, enabling stakeholders to gauge the health of the loan portfolio and identify trends to inform lending strategies effectively.
- Total Loan Applications: Number of loan applications received within a specified period, indicating demand for loans.
- Total Funded Amount: Aggregate amount of funds disbursed as loans, reflecting the extent of lending activity.
- Total Amount Received: Cumulative amount received from borrowers, essential for assessing cash flow and loan repayment.
- Average Interest Rate: Mean interest rate across all loans, indicating the overall cost of lending.
- Average Debt-to-Income Ratio (DTI): Average ratio of borrower's debt compared to their income, providing insights into borrower financial health.
- Good Loan Metrics: Measure performance of 'Good Loans' including application percentage, funded amount, and total received amount.
- Bad Loan Metrics: Measure performance of 'Bad Loans' including application percentage, funded amount, and total received amount.
- Summary Dashboard: Provides an overview of key loan metrics and performance indicators.
- Overview Dashboard: Visualizes critical loan-related metrics and trends using various chart types.
- Details Dashboard: Offers a comprehensive view of essential loan data, including borrower profiles and loan performance.
