Simulated individual loan data using Excel’s RAND functions with AI refinement, built interactive Power BI dashboards and analyzed credit risk by debt group – finding that despite some high DTI segments, the overall portfolio remained within safe limits, with consistent trends across income levels and regions.