Make an argument to senior management as to whether the bank should expand or contract its mortgage exposure to lower income borrowers.

The location of choice is Cleveland Ohio. Graphs and tables are definitely needed. I pulled data some data on 3 separate spreadsheets.
A couple of paragraphs on the banks, the background on MSA’s (employment is the most important fundamental for housing).

Housing Data using

Analysis. Tell me whether the bank is performing well in its requirements regarding supporting housing for lower-income households in your msa.

Final point. The main goal here is to demonstrate to me your ability to make assessments backed by a broad set of disparate information. This is both hard data and broad regional and firm trends. Creativity is highly encouraged