Loan Portfolio Evaluation

by Jul 29, 2016Financial Services, Success Stories

Objective

  • Our clients, a leading auto financing company in the United States was growing its portfolio inorganically through acquiring small and medium sized portfolios.
  • They were considering a lot of small Auto loan portfolios for acquisition every month and spending a lot of time to manually ‘evaluate’ the portfolio for pricing decisions.
  • We proposed an automated portfolio evaluation tool that’ll do the following things for them-
  • On providing portfolio details and expected profit margins as input, give the discount factor (on the principal outstanding) as output
  • Predict charge-off and pre-payment accounts along with timelines
  • Develop detailed cash flow of the portfolio till it runs off completely

success-finance4

Methodology

  • Used historical data to develop multiple models to predict propensity for all sorts of ‘bad’ future behaviors at account level (write-off/ early pay-off etc.).
  • Developed life time prediction model to output expected timelines of account level charge off/ pay up.
  • The client wanted a simple tool to be used by the CEO’s office. Keeping that in mind, the solution was built into an MS Excel based tool (with VBA backend) that predicts all important portfolio health parameters as well as dynamically builds detailed monthly cash flow for the portfolio under consideration.

success-finance5

Impact

  • Scientific way to evaluate a portfolio under acquisition on all health parameters- short term and long term.
  • The tool minimizes acquisition risk substantially- given the expected profit margins as input,the tool outputs the minimum discount factor (on the portfolio outstanding value) that the client should quote.

     

 

Related Posts

[et_pb_dfbm_blog dfbm_fullwidth=”off” article_distance=”20″ item_animation=”faded” custom_posttypes=”post” include_post_categories=”248″ posts_number=”3″ post_content_background_color=”#f9f9f9″ content_absolute=”on” content_absolute_event=”off” thumb_same_height=”on” define_thumb_height=”300″ header_tag=”h3″ show_content=”excerpt” show_limit_words=”on” show_comments=”off” show_limit_categories=”on” show_author=”off” show_date=”off” read_more=”off” show_pagination=”off” use_inner_shadow=”off” disabled_on=”off|off|off” _builder_version=”3.19.1″ post_body_line_height=”1.5em” post_header_font=”Montserrat||||||||” post_header_font_size=”17px” post_header_line_height=”1em” post_meta_font=”Montserrat||||||||” post_meta_text_color=”#000000″ post_meta_font_size=”11px” post_meta_line_height=”1.2em” post_meta_link_font=”Montserrat|300|||||||” post_meta_link_text_color=”#000000″ post_meta_link_font_size=”11px” post_meta_link_line_height=”1.2em” post_content_line_height=”1em” text_orientation=”left” custom_css_filt_blogs_post_meta=”font-weight: 200;” custom_css_filt_blogs_post_meta_a=”font-weight: 200;” saved_tabs=”all” /]