Report on Loan Portfolio quality based on a given dataset

Report on Loan Portfolio quality based on a given dataset Paper details: Based on the given dataset (xls format) ‘I. state observations made on the portfolio based on the data supplied 2. In terms of the quality of the portfolio, state whether it is increasing or decreasing over time 3. State observations regarding the reserve coverage against riskiness of the portfolio 4. What additional data fields, if any. would you require to make more informed observations 5. Data quality. State whether there are any apparent issues with data quality including completeness. accuracy and validity Clearly state all assumptions made in arriving at observations and prepare a short presentation (no longer than 13 minutes) for the credit risk manager using visual aids and key indicators in order to support the observations.