During the past five years Punjab & Sind Bank (PSB) witnessed strong growth in business and advances. Growth over the past five years has been ~ 1.5-1.6x the industry growth. PSB has experienced growth in advances and deposits, with total advances growing at a CAGR of 36.24% over the last five fiscals, and total deposits growing at a CAGR of 28.24% over the last five fiscals. It has also experienced significant improvement in asset quality and as on March 31, 2010 its net NPA was 0.36%, compared to the net NPA of 8.11% as on March 31, 2005. As on September 30, 2010, its net
NPA was 0.44%.

It’s IPO has generated enormous interest in the investor community (both retail and institutional). Many potential investors want a financial model in MS Excel, which can help them in a thorough analysis of the company. Creating such models have always been a time-taking and daunting exercise. We have created an integrated valuation model based on publicly available information. It is available as an open-source model for any user. Kindly note that this model is meant for information purpose only.

The complete structure of the model and formulas, linkages etc. have been kept open to allow for any modification on the part of the user.

You can contact the authors or Pristine for any query you have regarding the model or in general.