EXCEL ASSIGNMENT $3$:

QUESTION $3\mathrm{.}1$

Using the raw data provided, please prepare a summary report with the following seven $(7)$ zip codes. Example for demo purpose:

$890212$

$890265$

$290895$

$8.91331$

$691351$

$891356$

$891360$

QUESTION $3\mathrm{.}2$

WHAT IS THE AGGREGATE CREDIT UTILIZATION RATE FOR THE ABOVE $7$ ZIP CODES AS A WHOLE? $($HINTS: CREDIT UTILIZATION RATE $=$ LOAN BALANCES $/$ LOAN COMMITMENTS$)$