Annex VI Calculation of Average Maturity- An Illustration

Calculation of Average Maturity- An Illustration

Annex VI

ABC LTD.

Loan Amount = USD 2 million

Date of drawal/ Drawal repayment (MM/DD/YYYY)

Repayment Balance

No. of Days** balance with the borrower

Product= (Col.4 * Col. 5)/ (Loan amount * 360)

Col. 1 05/11/2007 06/05/2007 08/31/2007 12/27/2008 06/27/2009 12/27/2009 06/27/2010 12/27/2010 06/27/2011 12/27/2011 06/27/2012

Col. 2 0.75 0.50 0.75

Col. 3

0.20 0.25 0.25 0.30 0.25 0.25 0.25 0.25

Col. 4 0.75 1.25 2.00 1.80 1.55 1.30 1.00 0.75 0.50 0.25 0.00

Col. 5 24 85

477 180 180 180 180 180 180 180

Col. 6 0.0250 0.1476 1.3250 0.4500 0.3875 0.3250 0.2500 0.1875 0.1250 0.0625

Average Maturity= 3.2851 ** Calculated by = DAYS360 (firstdate, seconddate, 360)

57

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download