Bank Loan Report Dashboard — Excel

Built a two-page loan portfolio dashboard using PivotTables and PivotCharts on a 38.6K-application dataset.

• Segmented loans by quality, term, and purpose to identify credit risk concentration.

• Tracked funded vs. received amounts, interest rates, and debt-to-income ratios to support credit risk monitoring.