copy of examples sent to tm
TRANSCRIPT
-
8/13/2019 Copy of Examples Sent to TM
1/82
Exhibit 2(1) Cash Flow Analysis with Cash Collateral
Securitised pool Rs. 100 crore
Average pool yield 11%
Average pool tenor 12 months
Securities issued (par value) Rs. 100% crore
Coupon on securities 9%
Average tenor of securities 12 months
CE: Cash collateral Rs. 5 crore
Cash f lows (only pr incipals)
Months Cash
collectio
n
Interest Principal
collectio
n
Closing
Principal
Securities
amortisati
on
Cash
shortfall/s
urplus
Cl. Bal
of CC
A B C B - C
0 100
1 8.84 0.92 7.92 92.08 8.3 (0.38) 4.622 8.84 0.84 7.99 84.08 8.3 (0.31) 4.32
3 8.84 0.77 8.07 76.02 8.3 (0.23) 4.08
4 8.84 0.70 8.14 67.88 8.3 (0.16) 3.92
5 8.84 0.62 8.22 59.66 8.3 (0.08) 3.84
6 8.84 0.55 8.29 51.37 8.3 (0.01) 3.83
7 8.84 0.47 8.37 43.00 8.3 0.07 3.90
8 8.84 0.39 8.44 34.56 8.3 0.14 4.04
9 8.84 0.32 8.52 26.04 8.3 0.22 4.26
10 8.84 0.24 8.60 17.44 8.3 0.30 4.56
11 8.84 0.16 8.68 8.76 8.3 0.38 4.9412 8.84 0.08 8.76 0.00 8.7 0.06 5.00
Total 100.00 100.00
-
8/13/2019 Copy of Examples Sent to TM
2/82
Exhibit 2(2) Cash Collateral and OC
Securitised pool Rs. 100 crore
Average pool yield 11%
Average pool tenor 12 months
Securities issued (par Rs. 96 crore Overcollateralization 4 crore
Coupon on securities 9%
Average tenor of securities 12 monthsCE: Cash collateral Rs. 3 crore
Credit loss (% of opening pool re 3%
recognized on 90 day basis)
Cash f lows (only principals)
Months
Cashcollection
Interest
Principal
collection
Cashdefaulted
Lossrecognised
Closing
Principal
Securities
amortization
CCBalance
beforeutilization
CCutilised
CCbalanceafter
utilization
Cashw/dby
originator
CCbalanceafter
originator'sw/d
OCbalance
0 1001 8.82 0.92 7.90 0.25 91.85 8.00 3.00 0.10 2.90 0.00 2.90 4.00
2 8.79 0.84 7.95 0.25 83.65 8.00 2.90 0.05 2.85 0.00 2.85 4.00
3 8.77 0.77 8.00 0.25 0.75 75.40 8.00 2.85 0.00 2.85 0.00 2.85 3.25
4 8.74 0.69 8.05 0.25 67.10 8.00 2.85 (0.05) 2.90 0.00 2.90 3.25
5 8.71 0.62 8.09 0.25 58.76 8.00 2.90 (0.09) 2.99 0.00 2.99 3.25
6 8.67 0.54 8.13 0.25 0.75 50.38 8.00 2.99 (0.13) 3.12 0.12 3.00 2.50
7 8.63 0.46 8.16 0.25 41.97 8.00 3.00 (0.16) 3.16 0.16 3.00 2.50
8 8.57 0.38 8.19 0.25 33.53 8.00 3.00 (0.19) 3.19 0.19 3.00 2.50
9 8.51 0.31 8.20 0.25 0.75 25.08 8.00 3.00 (0.20) 3.20 0.20 3.00 1.75
10 8.43 0.23 8.20 0.25 16.63 8.00 3.00 (0.20) 3.20 0.20 3.00 1.75
11 8.30 0.15 8.15 0.25 8.23 8.00 3.00 (0.15) 3.15 0.15 3.00 1.75
12 8.05 0.08 7.98 0.25 0.75 0.00 8.00 3.00 0.02 2.98 0.00 2.98 1.00
Total 97.00 3.00 3.00 96.00 (1.00) 1.02
Securitised pool Rs. 100 crore
Average pool yield 0.11
Average pool tenor 12 months
Securities issued (par Rs. 96 crore
Coupon on securities 0.09
Average tenor of securities 12 months
CE: Cash collateral Rs. 3 crore
Credit loss (% of opening pool re 0.03
recognized on 90 day basis)
Cash f lows (only principals)
Month
s
Princi
pal
collect
ion
Loss Closing
Principal
Securi
ties
amorti
zation
CC
Balance
before
withdra
wal
Cash
withdra
wn by
originat
or
CC
balanc
e after
withdr
awal
Excess
collate
ral
balanc
e
-
8/13/2019 Copy of Examples Sent to TM
3/82
A B C D= Rs.
100 cr-(
B+C)
E F=Rs.
3cr + B
E
G G = F
G
H =
Rs. 4
cr - C0 100.00
1 7.92 92.08 8.00 2.92 0.00 2.92 4.00
2 7.99 84.08 8.00 2.92 0.00 2.92 4.00
3 8.07 0.75 75.27 8.00 2.98 0.00 2.98 3.254 8.06 67.21 8.00 3.04 0.04 3.00 3.25
5 8.13 59.07 8.00 3.18 0.18 3.00 3.25
6 8.21 0.75 50.11 8.00 3.39 0.39 3.00 2.50
7 8.16 41.95 8.00 3.55 0.55 3.00 2.50
8 8.24 33.71 8.00 3.79 0.79 3.00 2.50
9 8.31 0.75 24.65 8.00 4.10 1.10 3.00 1.75
10 8.14 16.51 8.00 4.24 1.24 3.00 1.75
11 8.22 8.29 8.00 4.46 1.46 3.00 1.75
12 7.54 0.75 0.00 8.00 4.00 1.00 3.00 1.00
Total 97 3.00 96.00
-
8/13/2019 Copy of Examples Sent to TM
4/82
Exhibit 2(3) Yield Supplement I
Pool Rs. 100 crore
Pool break up
High yielding portion Rs. 70 crore @ 11% 7.70%
Low yielding portion Rs. 30 crore @ 7% 2.10%
Average APR 9.80%
Months Opening bal EMI Interest Principal DF PV DF PV
0 7.0% 7.67%
1 30.00 1.34 0.18 1.17 0.99 1.34 0.99 1.33
2 28.83 1.34 0.17 1.17 0.99 1.33 0.99 1.33
3 27.66 1.34 0.16 1.18 0.98 1.32 0.98 1.32
4 26.47 1.34 0.15 1.19 0.98 1.31 0.97 1.31
5 25.29 1.34 0.15 1.20 0.97 1.30 0.97 1.30
6 24.09 1.34 0.14 1.20 0.97 1.30 0.96 1.29
7 22.89 1.34 0.13 1.21 0.96 1.29 0.96 1.28
8 21.68 1.34 0.13 1.22 0.95 1.28 0.95 1.28
9 20.46 1.34 0.12 1.22 0.95 1.27 0.94 1.2710 19.24 1.34 0.11 1.23 0.94 1.27 0.94 1.26
11 18.01 1.34 0.11 1.24 0.94 1.26 0.93 1.25
12 16.77 1.34 0.10 1.25 0.93 1.25 0.93 1.24
13 15.52 1.34 0.09 1.25 0.93 1.25 0.92 1.24
14 14.27 1.34 0.08 1.26 0.92 1.24 0.91 1.23
15 13.01 1.34 0.08 1.27 0.92 1.23 0.91 1.22
16 11.74 1.34 0.07 1.27 0.91 1.22 0.90 1.21
17 10.47 1.34 0.06 1.28 0.91 1.22 0.90 1.21
18 9.19 1.34 0.05 1.29 0.90 1.21 0.89 1.20
19 7.90 1.34 0.05 1.30 0.90 1.20 0.89 1.19
20 6.60 1.34 0.04 1.30 0.89 1.20 0.88 1.18
21 5.30 1.34 0.03 1.31 0.89 1.19 0.87 1.17
22 3.98 1.34 0.02 1.32 0.88 1.18 0.87 1.17
23 2.66 1.34 0.02 1.33 0.87 1.17 0.86 1.16
24 1.34 1.34 0.01 1.34 0.87 1.17 0.86 1.15
Total 30.00 29.80
Difference 0.20
=
-
8/13/2019 Copy of Examples Sent to TM
5/82
Opening bal EMI
-30 0.638% Months 0 1 2 3
0.20 $0.01 $1.35 7.66% EMI of original loans 1.34 1.34 1.34
$0.01 $1.35 EMI on yield supplement 0.01 0.01 0.01
$0.01 $1.35 Total EMI (cash flows) -30 1.35 1.35 1.35
$0.01 $1.35 Yield (per month) 0.64%
$0.01 $1.35 Yield (per yer) 7.66%
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
$0.01 $1.35
-
8/13/2019 Copy of Examples Sent to TM
6/82
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
1.34 1.34 1.34 1.34 1.34 1.34 1.34 1.34 1.34 1.34 1.34 1.34 1.34 1.34 1.34 1.34 1.34 1.34 1.34
0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01
1.35 1.35 1.35 1.35 1.35 1.35 1.35 1.35 1.35 1.35 1.35 1.35 1.35 1.35 1.35 1.35 1.35 1.35 1.35
-
8/13/2019 Copy of Examples Sent to TM
7/82
23 24
1.34 1.34
0.01 0.01
1.35 1.35
-
8/13/2019 Copy of Examples Sent to TM
8/82
Exhibit 2(4) Yield Supplement II
Pool Rs. 100 crore
Pool break up
High yielding portion Rs. 70 crore @ 11% 7.70%
Low yielding portion Rs. 30 crore @ 7% 2.10%
Average APR 9.80%
Months Opening bal EMI Interest Principal DF PV DF PV
0 7% 7.67%
1 70.00 3.26 0.64 2.62 0.99 3.24 0.99 3.24
2 67.38 3.26 0.62 2.64 0.99 3.22 0.99 3.22
3 64.73 3.26 0.59 2.67 0.98 3.21 0.98 3.20
4 62.07 3.26 0.57 2.69 0.98 3.19 0.97 3.18
5 59.37 3.26 0.54 2.72 0.97 3.17 0.97 3.16
6 56.65 3.26 0.52 2.74 0.97 3.15 0.96 3.14
7 53.91 3.26 0.49 2.77 0.96 3.13 0.96 3.12
8 51.14 3.26 0.47 2.79 0.95 3.11 0.95 3.10
9 48.35 3.26 0.44 2.82 0.95 3.10 0.94 3.0810 45.53 3.26 0.42 2.85 0.94 3.08 0.94 3.06
11 42.68 3.26 0.39 2.87 0.94 3.06 0.93 3.04
12 39.81 3.26 0.36 2.90 0.93 3.04 0.93 3.02
13 36.91 3.26 0.34 2.92 0.93 3.02 0.92 3.00
14 33.99 3.26 0.31 2.95 0.92 3.01 0.91 2.98
15 31.04 3.26 0.28 2.98 0.92 2.99 0.91 2.97
16 28.06 3.26 0.26 3.01 0.91 2.97 0.90 2.95
17 25.06 3.26 0.23 3.03 0.91 2.96 0.90 2.93
18 22.02 3.26 0.20 3.06 0.90 2.94 0.89 2.91
19 18.96 3.26 0.17 3.09 0.90 2.92 0.89 2.89
20 15.87 3.26 0.15 3.12 0.89 2.90 0.88 2.87
21 12.76 3.26 0.12 3.15 0.89 2.89 0.87 2.85
22 9.61 3.26 0.09 3.17 0.88 2.87 0.87 2.84
23 6.44 3.26 0.06 3.20 0.87 2.85 0.86 2.82
24 3.23 3.26 0.03 3.23 0.87 2.84 0.86 2.80
Total 72.87 72.38
Difference 0.49
-
8/13/2019 Copy of Examples Sent to TM
9/82
Exhibit 3(1) Sequential Paydown
Securitised pool Rs. 100 crore
Average pool yield 11%
Average pool tenor 12 months
Senior PTC A Rs. 80 crore
Mezannine PTC B 12
Subordinate PTC S Rs. 6 croreOvercolateralization Rs. 2 crore
Credit loss (% of opening pool receivables, 0.50%
reckoned at the start of the month)
Paydown Sequential
Cash f lows (only principals)
Months Opening
Principal
Loss Principal
after loss
EMI Interest Principal Closing
principal0
1 100.00 0.50 99.50 8.79 0.91 7.88 91.62
2 91.62 0.46 91.16 8.75 0.84 7.91 83.25
3 83.25 0.42 82.83 8.71 0.76 7.95 74.884 74.88 0.37 74.51 8.66 0.68 7.98 66.53
5 66.53 0.33 66.20 8.62 0.61 8.01 58.18
6 58.18 0.29 57.89 8.58 0.53 8.05 49.85
7 49.85 0.25 49.60 8.53 0.45 8.08 41.52
8 41.52 0.21 41.31 8.49 0.38 8.11 33.20
9 33.20 0.17 33.03 8.45 0.30 8.15 24.89
10 24.89 0.12 24.76 8.41 0.23 8.18 16.58
11 16.58 0.08 16.50 8.36 0.15 8.21 8.29
12 8.29 0.04 8.25 8.32 0.08 8.25 0.00
3.24
-20%
0%
20%
40%
60%
80%
100%
120%
1 2 3 4 5 6 7 8 9 10 11 12
OC
Months
CE and Sequential Paydown
-
8/13/2019 Copy of Examples Sent to TM
10/82
Opening
Balance
Loss Repay-
ment
Closing
balance
Opening
Balance
Loss Repay-
ment
Closing
balance
Opening
Balance
Loss
80 7.88 72.12 12.00 0.00 0.00 12.00 6.00 0.00
72 7.91 64.20 12.00 0.00 0.00 12.00 6.00 0.00
64 7.95 56.26 12.00 0.00 0.00 12.00 6.00 0.0056 7.98 48.28 12.00 0.00 0.00 12.00 6.00 0.00
48 8.01 40.26 12.00 0.00 0.00 12.00 6.00 0.08
40 8.05 32.22 12.00 0.00 0.00 12.00 5.92 0.29
32 8.08 24.14 12.00 0.00 0.00 12.00 5.63 0.25
24 8.11 16.03 12.00 0.00 0.00 12.00 5.38 0.21
16 8.15 7.88 12.00 0.00 0.00 12.00 5.17 0.17
8 7.88 0.00 12.00 0.00 0.30 11.70 5.00 0.12
0 0.00 0.00 11.70 0.00 8.21 3.49 4.88 0.08
0 0.00 0.00 3.49 0.00 3.49 0.00 4.80 0.04
1.24
PTC-A PTC B PT
PTC-A
PTC-B
PTC-S
-
8/13/2019 Copy of Examples Sent to TM
11/82
Repay-
ment
Closing
balance
Opening
Balance
Loss Closing
balance
A B S A
0.00 6.00 2.00 0.50 1.50 20% 8% 2% 25%
0.00 6.00 1.50 0.46 1.04 21% 8% 2% 27%
0.00 6.00 1.04 0.42 0.63 23% 8% 1% 30%0.00 6.00 0.63 0.37 0.25 25% 9% 1% 33%
0.00 5.92 0.25 0.25 0.00 27% 9% 0% 38%
0.00 5.63 0.00 0.00 0.00 31% 10% 0% 45%
0.00 5.38 0.00 0.00 0.00 35% 11% 0% 55%
0.00 5.17 0.00 0.00 0.00 42% 13% 0% 72%
0.00 5.00 0.00 0.00 0.00 52% 16% 0% 107%
0.00 4.88 0.00 0.00 0.00 68% 20% 0% 216%
0.00 4.80 0.00 0.00 0.00 100% 29% 0%
4.76 0.00 0.00 0.00 0.00 100% 58% 0%
SubordinationS Overcollateralization O
-
8/13/2019 Copy of Examples Sent to TM
12/82
B S
67% 33%
63% 25%
59% 17%55% 10%
52% 4%
49%
47%
45%
43%
42%
42%
137%
CE
-
8/13/2019 Copy of Examples Sent to TM
13/82
-
8/13/2019 Copy of Examples Sent to TM
14/82
-
8/13/2019 Copy of Examples Sent to TM
15/82
Exhibit 3(2) Proportionate Paydown
Securitised pool Rs. 100 crore
Average pool yield 11%
Average pool tenor 12 months
Senior PTC A Rs. 80 crore
Mezannine PTC B 10
Subordinate PTC S Rs. 10 croreOvercolateralization Rs. 0 crore
Credit loss (% of opening pool receivables, 0.50%
reckoned at the start of the month)
Paydown proportionate
Cash f lows (only principals)
Months Opening
Principal
Loss Principal
after loss
EMI Interest Principal Closing
principal0
1 100.00 0.50 99.50 8.79 0.91 7.88 91.62
2 91.62 0.46 91.16 8.75 0.84 7.91 83.25
3 83.25 0.42 82.83 8.71 0.76 7.95 74.884 74.88 0.37 74.51 8.66 0.68 7.98 66.53
5 66.53 0.33 66.20 8.62 0.61 8.01 58.18
6 58.18 0.29 57.89 8.58 0.53 8.05 49.85
7 49.85 0.25 49.60 8.53 0.45 8.08 41.52
8 41.52 0.21 41.31 8.49 0.38 8.11 33.20
9 33.20 0.17 33.03 8.45 0.30 8.15 24.89
10 24.89 0.12 24.76 8.41 0.23 8.18 16.58
11 16.58 0.08 16.50 8.36 0.15 8.21 8.29
12 8.29 0.04 8.25 8.32 0.08 8.25 0.00
3.24 96.76
10
-
8/13/2019 Copy of Examples Sent to TM
16/82
Opening
Balance
Loss Repay-
ment
Closing
balance
Opening
Balance
Loss Repay-
ment
Closing
balance
Opening
Balance
Loss
80.00 6.31 73.69 10.00 0.00 0.79 9.21 10.00 0.50
73.69 6.37 67.33 9.21 0.00 0.80 8.42 8.71 0.46
67.33 6.43 60.90 8.42 0.00 0.80 7.61 7.50 0.4260.90 6.49 54.41 7.61 0.00 0.81 6.80 6.37 0.37
54.41 6.55 47.86 6.80 0.00 0.82 5.98 5.32 0.33
47.86 6.62 41.24 5.98 0.00 0.83 5.16 4.34 0.29
41.24 6.68 34.56 5.16 0.00 0.84 4.32 3.45 0.25
34.56 6.75 27.80 4.32 0.00 0.84 3.48 2.64 0.21
27.80 6.82 20.98 3.48 0.00 0.85 2.62 1.92 0.17
20.98 6.90 14.09 2.62 0.00 0.86 1.76 1.28 0.12
14.09 6.98 7.11 1.76 0.00 0.87 0.89 0.74 0.08
7.11 7.11 0.00 0.89 0.00 0.89 0.00 0.29 0.04
80.00 0.00 10.00 3.24
PTC-A PTC B PT
-
8/13/2019 Copy of Examples Sent to TM
17/82
Repay-
ment
Closing
balance
Opening
Balance
Loss Closing
balance
A B S A
0.79 8.71 0.00 0.00 0.00 20% 10% 0% 25%
0.75 7.50 0.00 0.00 0.00 20% 10% 0% 24%
0.72 6.37 0.00 0.00 0.00 19% 9% 0% 24%0.68 5.32 0.00 0.00 0.00 19% 9% 0% 23%
0.64 4.34 0.00 0.00 0.00 18% 8% 0% 22%
0.60 3.45 0.00 0.00 0.00 18% 7% 0% 22%
0.56 2.64 0.00 0.00 0.00 17% 7% 0% 21%
0.52 1.92 0.00 0.00 0.00 17% 6% 0% 20%
0.47 1.28 0.00 0.00 0.00 16% 6% 0% 19%
0.42 0.74 0.00 0.00 0.00 16% 5% 0% 19%
0.36 0.29 0.00 0.00 0.00 15% 4% 0%
0.25 0.00 0.00 0.00 0.00 14% 3% 0%
SubordinationS Overcollateralization O
0%
5%
10%
15%
20%
25%
1 2 3 4 5 6 7 8 9 10 11 12
OC
Months
SO and Proportionate Paydown
PTC-A
PTC-B
PTC-S
-
8/13/2019 Copy of Examples Sent to TM
18/82
B S
100% 0%
95% 0%
89% 0%84% 0%
78% 0%
73%
67%
61%
55%
49%
42%
32%
CE
-
8/13/2019 Copy of Examples Sent to TM
19/82
-
8/13/2019 Copy of Examples Sent to TM
20/82
-
8/13/2019 Copy of Examples Sent to TM
21/82
Exhibit 3(3) Vertical Subordination (distributes cash flows in proportion of original principal)
Securitised pool Rs. 100 crore
Average pool yield 11%
Average pool tenor 12 months
Senior PTC A Rs. 90 crore
Mezannine PTC B 10
Subordinate PTC S Rs. 0 croreOvercolateralization Rs. 0 crore
Credit loss (% of opening pool receivables, 0.50%
reckoned at the start of the month)
Paydown proportionate
Cash f lows (only principals)
Months EMI Intt Opg.
Princial
Repaymt Clg Prin Opening
Principal
Loss Principal
after loss0
1 8.84 0.92 100.00 7.92 92.08 100.00 0.50 99.50
2 8.84 0.84 92.08 7.99 84.08 91.62 0.46 91.163 8.84 0.77 84.08 8.07 76.02 83.25 0.42 82.83
4 8.84 0.70 76.02 8.14 67.88 74.88 0.37 74.51
5 8.84 0.62 67.88 8.22 59.66 66.53 0.33 66.20
6 8.84 0.55 59.66 8.29 51.37 58.18 0.29 57.89
7 8.84 0.47 51.37 8.37 43.00 49.85 0.25 49.60
8 8.84 0.39 43.00 8.44 34.56 41.52 0.21 41.31
9 8.84 0.32 34.56 8.52 26.04 33.20 0.17 33.03
10 8.84 0.24 26.04 8.60 17.44 24.89 0.12 24.76
11 8.84 0.16 17.44 8.68 8.76 16.58 0.08 16.50
12 8.84 0.08 8.76 8.76 0.00 8.29 0.04 8.25
3.24
Proportionate Vertical
Month
PTC A
Repaymt
PTC A Cl
Bal
PTC B
Repaymt
PTC B
Cl Bal SO Ratio
PTC A
Repaymt
PTC A Cl
Bal
PTC B
Repaymt
1 7.09 82.91 0.79 8.71 9.51% 7.13 82.87 0.75
2 7.16 75.74 0.75 7.50 9.01% 7.19 75.68 0.72
3 7.23 68.51 0.72 6.37 8.51% 7.26 68.42 0.69
4 7.30 61.21 0.68 5.32 7.99% 7.33 61.09 0.65
5 7.37 53.84 0.64 4.34 7.46% 7.39 53.69 0.62
6 7.45 46.40 0.60 3.45 6.92% 7.46 46.23 0.58
7 7.52 38.88 0.56 2.64 6.37% 7.53 38.70 0.55
8 7.60 31.28 0.52 1.92 5.78% 7.60 31.10 0.51
9 7.67 23.61 0.47 1.28 5.15% 7.67 23.43 0.48
10 7.76 15.85 0.42 0.74 4.44% 7.74 15.69 0.44
11 7.85 8.00 0.36 0.29 3.48% 7.81 7.88 0.4012 8.00 0.00 0.25 0.00 7.88 0.00 0.36
Total 90.00 6.76 90.00 6.76
Loss 0.00 3.24
Cash flows without loss Cas
-
8/13/2019 Copy of Examples Sent to TM
22/82
EMI Interest Principal Closing
principal
Opening
Balance
Loss Repay-
ment
Closing
balance
Opening
Balance
Loss
8.79 0.91 7.88 91.62 90 7.13 82.87 10.00 0.50
8.75 0.84 7.91 83.25 83 7.19 75.68 8.75 0.468.71 0.76 7.95 74.88 76 7.26 68.42 7.57 0.42
8.66 0.68 7.98 66.53 68 7.33 61.09 6.47 0.37
8.62 0.61 8.01 58.18 61 7.39 53.69 5.44 0.33
8.58 0.53 8.05 49.85 54 7.46 46.23 4.49 0.29
8.53 0.45 8.08 41.52 46 7.53 38.70 3.61 0.25
8.49 0.38 8.11 33.20 39 7.60 31.10 2.82 0.21
8.45 0.30 8.15 24.89 31 7.67 23.43 2.10 0.17
8.41 0.23 8.18 16.58 23 7.74 15.69 1.46 0.12
8.36 0.15 8.21 8.29 16 7.81 7.88 0.89 0.08
8.32 0.08 8.25 0.00 8 7.88 0.00 0.41 0.04
3.24
PTC B
Cl Bal
8.75 9.55%
7.57 9.09%
6.47 8.64%
5.44 8.18%
4.49 7.72%
3.61 7.25%
2.82 6.79%
2.10 6.32%
1.46 5.85%
0.89 5.37%
0.41 4.90%0.00
flows with loss
PTC-A PT
-
8/13/2019 Copy of Examples Sent to TM
23/82
Repay-
ment
Closing
balance
Opening
Balance
Loss Repay-
ment
Closing
balance
Opening
Balance
Loss Closing
balance
0.75 8.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.72 7.57 0.00 0.00 0.00 0.00 0.00 0.00 0.000.69 6.47 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.65 5.44 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.62 4.49 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.58 3.61 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.55 2.82 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.51 2.10 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.48 1.46 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.44 0.89 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.40 0.41 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.36 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
6.76 0.00
10.00
B PTC S Overcollateralization O
0%
5%
10%
15%
20%
25%
1 2 3 4 5 6 7
OC
Months
SO and Proportio
-
8/13/2019 Copy of Examples Sent to TM
24/82
A B S A B S
10% 0% 0% 11% 0% #DIV/0!
10% 0% 0% 11% 0% #DIV/0!9% 0% 0% 10% 0% #DIV/0!
9% 0% 0% 9% 0% #DIV/0!
8% 0% 0% 9% 0% #DIV/0!
8% 0% 0% 8% 0%
7% 0% 0% 8% 0%
7% 0% 0% 7% 0%
6% 0% 0% 7% 0%
6% 0% 0% 6% 0%
5% 0% 0% 0%
5% 0% 0% 0%
Subordination CE
8 9 10 11 12
ate Paydown
PTC-A
PTC-B
PTC-S
-
8/13/2019 Copy of Examples Sent to TM
25/82
-
8/13/2019 Copy of Examples Sent to TM
26/82
-
8/13/2019 Copy of Examples Sent to TM
27/82
-
8/13/2019 Copy of Examples Sent to TM
28/82
Exhibit 4(1) Staggereed Payouts
Securitised pool Rs. 100 crore
Average pool yield 11%
Average pool tenor 12 months
Securities Isued 100 crore
Collection pattern month of billing 80.00%
Next month 12.00% 90 dpdNext second month 3.00% 120 dpd
Loss Next month recovery 70% 3.50% 180 dpd
Loss 1.50%
Staggered payout Month 1 70% of collections
Month 2 20% of collections
Month 3 10% of collections
Cash f lows (only principals)
Months
OpeningPrincipal
Loss Principal
after loss
EMI
(Billings)
Interest Principal Closing
principal
Payouts
(factoring in
credit loss)
0
1 100.00 0.00 100.00 8.84 0.92 7.92 92.08 7.80
2 92.08 0.00 92.08 8.84 0.84 7.99 84.08 7.87
3 84.08 0.00 84.08 8.84 0.77 8.07 76.02 7.95
4 76.02 0.00 76.02 8.84 0.70 8.14 67.88 8.02
5 67.88 0.00 67.88 8.84 0.62 8.22 59.66 8.09
6 59.66 0.00 59.66 8.84 0.55 8.29 51.37 8.17
7 51.37 0.00 51.37 8.84 0.47 8.37 43.00 8.24
8 43.00 0.00 43.00 8.84 0.39 8.44 34.56 8.32
9 34.56 0.00 34.56 8.84 0.32 8.52 26.04 8.39
10 26.04 0.00 26.04 8.84 0.24 8.60 17.44 8.47
11 17.44 0.00 17.44 8.84 0.16 8.68 8.76 8.55
12 8.76 0.00 8.76 8.84 0.08 8.76 0.00 8.63
13 0.00 0.00 0.00
14
15
Total 100.00 98.50
Payins
Months 1 2.00 3 4 5 6 7 8
1 6.34
2 0.95 6.40
3 0.24 0.96 6.45
4 0.28 0.24 0.97 6.51
5 0.28 0.24 0.98 6.576 0.28 0.24 0.99 6.63
7 0.28 0.25 0.99 6.69
8 0.29 0.25 1.00 6.76
9 0.29 0.25 1.01
10 0.29 0.25
11 0.30
12
13
-
8/13/2019 Copy of Examples Sent to TM
29/82
14
15
7.80 7.87 7.95 8.02 8.09 8.17 8.24 8.32
Loss 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50%
Staggered payouts
Months 1 2.00 3 4 5 6 7 8
1 5.46
2 1.56 5.51
3 0.78 1.57 5.56
4 0.79 1.59 5.61
5 0.79 1.60 5.66
6 0.80 1.62 5.72
7 0.81 1.63 5.77
8 0.82 1.65 5.82
9 0.82 1.66
10 0.83
1112
7.80 7.87 7.95 8.02 8.09 8.17 8.24 8.32
Months Payins Normal
payouts
Staggered
payouts
Deviation
(B-A)
Cumul Deviation
(C-A)
Cumul
A B C
1 6.34 7.80 5.46 (1.47) (1.47) 0.88 0.88
2 7.35 7.87 7.07 (0.53) (1.99) 0.27 1.15
3 7.65 7.95 7.92 (0.30) (2.29) (0.27) 0.884 8.00 8.02 7.99 (0.02) (2.31) 0.01 0.89
5 8.07 8.09 8.06 (0.02) (2.33) 0.01 0.90
6 8.15 8.17 8.14 (0.02) (2.35) 0.01 0.91
7 8.22 8.24 8.21 (0.02) (2.37) 0.01 0.91
8 8.30 8.32 8.29 (0.02) (2.40) 0.01 0.92
9 8.37 8.39 8.36 (0.02) (2.42) 0.01 0.93
10 8.45 8.47 10.98 (0.02) (2.44) (2.53) (1.60)
11 8.53 8.55 9.39 (0.02) (2.46) (0.86) (2.46)
12 8.60 8.63 8.63 (0.02) (2.49) (0.02) (2.49)
13 1.61 0.00 0.00 1.61 (0.87) 1.61 (0.87)
14 0.57 0.00 0.00 0.57 (0.31) 0.57 (0.31)
15 0.31 0.00 0.00 0.31 (0.00) 0.31 0.00
98.50 98.50 98.50 (2.49) (2.49) (3.68) (3.68)
Months 1 2.00 3 4 5 6 7 8
1 0.00
2 0.00
3 7.80
4 7.87
-
8/13/2019 Copy of Examples Sent to TM
30/82
5 7.95
6 8.02
7 8.09
8 8.17
9
10
1112
0.00 0.00 7.80 7.87 7.95 8.02 8.09 8.17
Opening overdues
-
8/13/2019 Copy of Examples Sent to TM
31/82
Payins Mismatch Cum
Mismatch
Staggered
payous
PI - SPO Cum PI-
SPO
Wt. Drawal
w/o
staggering
Wt. Drawal
with
staggering
6.34 (1.47) (1.47) 5.46 0.88 0.88 9.6285823 9.6285823
7.35 (0.53) (1.99) 7.07 0.27 1.15 -5.28331 2.7339404
7.65 (0.30) (2.29) 7.92 (0.27) 0.88 -2.659761 -2.400503
8.00 (0.02) (2.31) 7.99 0.01 0.89 -0.167885 0.0646798
8.07 (0.02) (2.33) 8.06 0.01 0.90 -0.148246 0.0571136
8.15 (0.02) (2.35) 8.14 0.01 0.91 -0.128233 0.0494033
8.22 (0.02) (2.37) 8.21 0.01 0.91 -0.10784 0.0415468
8.30 (0.02) (2.40) 8.29 0.01 0.92 -0.087063 0.0335421
8.37 (0.02) (2.42) 8.36 0.01 0.93 -0.065896 0.0253872
8.45 (0.02) (2.44) 10.98 (2.53) (1.60) -0.044333 -5.065228
8.53 (0.02) (2.46) 9.39 (0.86) (2.46) -0.02237 -0.861727
8.60 (0.02) (2.49) 8.63 (0.02) (2.49) 0 0
1.61 1.61 (0.87) 0.00 1.61 (0.87)
0.57 0.57 (0.31) 0.00 0.57 (0.31)
0.31 0.31 (0.00) 0.00 0.31 0.00
98.50 0.9136465 4.306738
0.0117134 0.0552146
9 10 11 12 Total
6.34
7.35
7.65
8.00
8.078.15
8.22
8.30
6.82 8.37
1.02 6.88 8.45
0.26 1.03 6.94 8.53
0.30 0.26 1.04 7.01 8.60
0.30 0.26 1.05 1.61
-
8/13/2019 Copy of Examples Sent to TM
32/82
0.30 0.26 0.57
0.31 0.31
8.39 8.47 8.55 8.63 98.50
1.50% 1.50% 1.50% 1.50%
9 10 11 12 Total payouts
5.46
7.07
7.92
7.99
8.06
8.14
8.21
8.29
5.88 8.36
1.68 8.47 10.98
0.84 8.55 9.398.63 8.63
8.39 8.47 8.55 8.63 98.50
9 10 11 12 Total payouts
0.00
0.00
7.80
7.87
-
8/13/2019 Copy of Examples Sent to TM
33/82
7.95
8.02
8.09
8.17
8.24 8.24
8.32 8.32
8.39 8.3925.65 25.65
8.24 8.32 8.39 25.65 98.50
-
8/13/2019 Copy of Examples Sent to TM
34/82
Exhibit 4(2) Prepayment Risk
Pool 100 crore
Average life 36 months
Average Intt rate-WAC 9.00% p.a
Loss rate 0.25% per month
Prepayment rate 2.00% per month
Perpayment penalty 2.00% of prepaid amt
PTC-A 90.00
Coupon 7.00%
Tenor 32.00
P-Class 0.00
Coupon 7.50%
Tenor 33.00
SO Class 10.00
Coupon 10.00%
Pool cashflowsMonths 0 1 2 3 4 5 6Opening o/s 100.00 95.37 90.89 86.54 82.32 78.24
Credit Loss 0.25 0.24 0.23 0.22 0.21 0.20
Original EMI 3.11
Pool o/s after loss 99.75 95.14 90.66 86.32 82.12 78.04
Prepaid principal 2.00 1.91 1.82 1.73 1.65 1.56
Pool o/s after loss&prep 97.75 93.23 88.84 84.59 80.47 76.48
EMI received 3.11 3.04 2.97 2.90 2.84 2.77
Interest 0.73 0.70 0.67 0.63 0.60 0.57
Principal 2.38 2.34 2.30 2.27 2.23 2.20
Closing o/s 95.37 90.89 86.54 82.32 78.24 74.28
4.3752989 8.493525 12.36472 15.99861 19.40459 22.59174Principal cashflows
Unscheduled principal
Prepayments 2.00 1.91 1.82 1.73 1.65 1.56
Loss met from EIS 0.25 0.24 0.23 0.22 0.21 0.20
Scheduled principal
EMI 2.38 2.34 2.30 2.27 2.23 2.20
Total principal received 4.62 4.49 4.35 4.22 4.09 3.96
Interest cashlows
Interest in EMI 0.73 0.70 0.67 0.63 0.60 0.57
Prepayment penalty 0.04 0.04 0.04 0.03 0.03 0.03
Interest received 0.77 0.74 0.70 0.67 0.64 0.60
Allocation of Principal
Prepayment to P 0.00 0.00 0.00 0.00 0.00 0.00
Other Principal to A 4.62 4.49 4.35 4.22 4.09 3.96
Other Principal to P 0.00 0.00 0.00 0.00 0.00 0.00
Remaining prin to SO 0.00 0.00 0.00 0.00 0.00 0.00
-
8/13/2019 Copy of Examples Sent to TM
35/82
Allocation of Interest
Interest to PTC-A 0.53 0.50 0.47 0.45 0.42 0.40
Interest P-Class 0.00 0.00 0.00 0.00 0.00 0.00
Credit Loss 0.25 0.24 0.23 0.22 0.21 0.20
Total allocation 0.77 0.74 0.70 0.66 0.63 0.59Credit Loss unabsobed 0.00 0.00 0.00 0.00 0.00 0.00
PTC-A
Opening o/s 90.00 85.38 80.89 76.54 72.33 68.24
Repayment of principal 4.62 4.49 4.35 4.22 4.09 3.96
Principal written off
Closing o/s 85.38 80.89 76.54 72.33 68.24 64.28
4.62 8.97 13.05 16.86 20.43 23.77
P-Class
Opening o/s 0.00 0.00 0.00 0.00 0.00 0.00
Repayment from prepaid prin 0.00 0.00 0.00 0.00 0.00 0.00
Repayment from other principal 0.00 0.00 0.00 0.00 0.00 0.00Closing o/s 0.00 0.00 0.00 0.00 0.00 0.00
SO Class
Opening o/s 10.00 10.00 10.00 10.00 10.00 10.00
Repayment of principal 0.00 0.00 0.00 0.00 0.00 0.00
Principal written off 0.00 0.00 0.00 0.00 0.00 0.00
Closing o/s 10.00 10.00 10.00 10.00 10.00 10.00
96.350401 92.75865 89.22395 85.74553 82.32263 78.9545
93.423301 87.20829 81.33669 75.7911 70.55498 65.61255
Cumulative Billings
0
20
40
60
80
100
120
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35
Poolprincipaloutstanding
Months
Pool amortization at 1% and 4% prepayment per month
1% prepeyment
4% prepaymentPer
centreductioninWAL
-
8/13/2019 Copy of Examples Sent to TM
36/82
7 8 9 10 11 12 13 14 15
74.28 70.44 66.72 63.12 59.63 56.25 52.97 49.80 46.74
0.19 0.18 0.17 0.16 0.15 0.14 0.13 0.12 0.12
74.09 70.26 66.55 62.96 59.48 56.11 52.84 49.68 46.62
1.49 1.41 1.33 1.26 1.19 1.12 1.06 1.00 0.93
72.61 68.85 65.22 61.70 58.28 54.98 51.78 48.68 45.68
2.71 2.65 2.59 2.53 2.48 2.42 2.37 2.31 2.26
0.54 0.52 0.49 0.46 0.44 0.41 0.39 0.37 0.34
2.17 2.13 2.10 2.07 2.04 2.01 1.98 1.95 1.92
70.44 66.72 63.12 59.63 56.25 52.97 49.80 46.74 43.77
25.56885 28.34442 30.92665 33.3235 35.54262 37.59144 39.47711 41.20656 42.78647
1.49 1.41 1.33 1.26 1.19 1.12 1.06 1.00 0.93
0.19 0.18 0.17 0.16 0.15 0.14 0.13 0.12 0.12
2.17 2.13 2.10 2.07 2.04 2.01 1.98 1.95 1.92
3.84 3.72 3.60 3.49 3.38 3.27 3.17 3.07 2.97
0.54 0.52 0.49 0.46 0.44 0.41 0.39 0.37 0.34
0.03 0.03 0.03 0.03 0.02 0.02 0.02 0.02 0.02
0.57 0.54 0.52 0.49 0.46 0.43 0.41 0.39 0.36
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
3.84 3.72 3.60 3.49 3.38 3.27 3.17 3.07 2.97
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
-
8/13/2019 Copy of Examples Sent to TM
37/82
0.37 0.35 0.33 0.31 0.29 0.27 0.25 0.23 0.21
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.19 0.18 0.17 0.16 0.15 0.14 0.13 0.12 0.12
0.56 0.53 0.50 0.47 0.44 0.41 0.38 0.36 0.330.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
64.28 60.44 56.72 53.12 49.63 46.25 42.97 39.81 36.74
3.84 3.72 3.60 3.49 3.38 3.27 3.17 3.07 2.97
60.44 56.72 53.12 49.63 46.25 42.97 39.81 36.74 33.77
26.87 29.75 32.43 34.90 37.18 39.28 41.20 42.95 44.54
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00
75.64038 72.37954 69.17125 66.01481 62.90949 59.8546 56.84946 53.89337 50.98567
60.94884 56.54956 52.40114 48.49066 44.80584 41.33498 38.06695 34.9912 32.09766
0%
5%
10%
15%
20%
25%
30%
35%
40%
45%
0.0% 0.5% 1.0% 1.5% 2.0% 2.5% 3.0% 3.5% 4.0% 4.5%
Increase in prepayment rate(monthly mortality)
Increase in prepayment vs. reduction in WAL
-
8/13/2019 Copy of Examples Sent to TM
38/82
16 17 18 19 20 21 22 23 24
43.77 40.89 38.11 35.42 32.82 30.31 27.88 25.53 23.25
0.11 0.10 0.10 0.09 0.08 0.08 0.07 0.06 0.06
43.66 40.79 38.02 35.34 32.74 30.23 27.81 25.46 23.20
0.88 0.82 0.76 0.71 0.66 0.61 0.56 0.51 0.47
42.78 39.97 37.26 34.63 32.08 29.63 27.25 24.95 22.73
2.21 2.16 2.11 2.06 2.02 1.97 1.93 1.88 1.84
0.32 0.30 0.28 0.26 0.24 0.22 0.20 0.19 0.17
1.89 1.86 1.83 1.80 1.78 1.75 1.72 1.70 1.67
40.89 38.11 35.42 32.82 30.31 27.88 25.53 23.25 21.06
44.22331 45.5233 46.69247 47.73664 48.6614 49.47219 50.17423 50.77255 51.27204
0.88 0.82 0.76 0.71 0.66 0.61 0.56 0.51 0.47
0.11 0.10 0.10 0.09 0.08 0.08 0.07 0.06 0.06
1.89 1.86 1.83 1.80 1.78 1.75 1.72 1.70 1.67
2.87 2.78 2.69 2.60 2.52 2.43 2.35 2.27 2.19
0.32 0.30 0.28 0.26 0.24 0.22 0.20 0.19 0.17
0.02 0.02 0.02 0.01 0.01 0.01 0.01 0.01 0.01
0.34 0.32 0.29 0.27 0.25 0.23 0.22 0.20 0.18
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
2.87 2.78 2.69 2.60 2.52 2.43 2.35 2.27 2.19
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
-
8/13/2019 Copy of Examples Sent to TM
39/82
0.20 0.18 0.16 0.15 0.13 0.12 0.10 0.09 0.08
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.11 0.10 0.10 0.09 0.08 0.08 0.07 0.06 0.06
0.31 0.28 0.26 0.24 0.22 0.19 0.17 0.15 0.140.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
33.77 30.90 28.12 25.43 22.82 20.31 17.88 15.53 13.26
2.87 2.78 2.69 2.60 2.52 2.43 2.35 2.27 2.19
30.90 28.12 25.43 22.82 20.31 17.88 15.53 13.26 11.06
45.97 47.26 48.41 49.42 50.30 51.06 51.71 52.24 52.67
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00
48.1257 45.3128 42.54633 39.82564 37.15012 34.51912 31.93206 29.38831 26.88728
29.37676 26.81943 24.417 22.16127 20.04443 18.05905 16.19809 14.45484 12.82293
-
8/13/2019 Copy of Examples Sent to TM
40/82
25 26 27 28 29 30 31 32 33
21.06 18.94 16.89 14.92 13.01 11.17 9.39 7.68 6.03
0.05 0.05 0.04 0.04 0.03 0.03 0.02 0.02 0.02
21.01 18.89 16.85 14.88 12.98 11.14 9.37 7.66 6.01
0.42 0.38 0.34 0.30 0.26 0.22 0.19 0.15 0.12
20.59 18.51 16.51 14.58 12.72 10.92 9.18 7.51 5.89
1.80 1.76 1.72 1.68 1.64 1.61 1.57 1.54 1.50
0.15 0.14 0.12 0.11 0.10 0.08 0.07 0.06 0.04
1.65 1.62 1.60 1.57 1.55 1.52 1.50 1.48 1.46
18.94 16.89 14.92 13.01 11.17 9.39 7.68 6.03 4.44
51.67737 51.99308 52.22352 52.37292 52.44531 52.44462 52.3746 52.23889 52.04097
0.42 0.38 0.34 0.30 0.26 0.22 0.19 0.15 0.12
0.05 0.05 0.04 0.04 0.03 0.03 0.02 0.02 0.02
1.65 1.62 1.60 1.57 1.55 1.52 1.50 1.48 1.46
2.12 2.05 1.98 1.91 1.84 1.78 1.71 1.65 1.59
0.15 0.14 0.12 0.11 0.10 0.08 0.07 0.06 0.04
0.01 0.01 0.01 0.01 0.01 0.00 0.00 0.00 0.00
0.16 0.15 0.13 0.12 0.10 0.09 0.07 0.06 0.05
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
2.12 2.05 1.98 1.91 1.84 1.17 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.61 1.71 1.65 1.59
-
8/13/2019 Copy of Examples Sent to TM
41/82
0.06 0.05 0.04 0.03 0.02 0.01 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.05 0.05 0.04 0.04 0.03 0.03 0.02 0.02 0.02
0.12 0.10 0.08 0.07 0.05 0.03 0.02 0.02 0.020.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
11.06 8.94 6.90 4.92 3.01 1.17 0.00 0.00 0.00
2.12 2.05 1.98 1.91 1.84 1.17 0.00 0.00 0.00
8.94 6.90 4.92 3.01 1.17 0.00 0.00 0.00 0.00
52.99 53.22 53.36 53.42 53.39 35.10 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
10.00 10.00 10.00 10.00 10.00 10.00 9.39 7.68 6.03
0.00 0.00 0.00 0.00 0.00 0.61 1.71 1.65 1.59
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
10.00 10.00 10.00 10.00 10.00 9.39 7.68 6.03 4.44
24.42838 22.01103 19.63466 17.29869 15.00258 12.74575 10.52768 8.347825 6.205648
11.29631 9.869247 8.53628 7.292229 6.132174 5.051448 4.045617 3.110477 2.242036
-
8/13/2019 Copy of Examples Sent to TM
42/82
34 35 36 Total 4.00%
4.44 2.90 1.42 Prepayme WAL
0.01 0.01 0.00 0.0% 18.49
4.42 2.89 1.42 0.5% 17.14 7.3%
0.09 0.06 0.03 1.0% 16.21 12.3%
4.34 2.84 1.39 1.5% 15.35 17.0%
1.47 1.43 1.40 2.0% 14.57 21.2%
0.03 0.02 0.01 2.5% 13.84 25.1%
1.43 1.41 1.39 3.0% 13.17 28.8%
2.90 1.42 0.00 3.5% 12.55 32.1%
51.78422 51.47186 51.10703 1456.70 14.57 4.0% 11.97 35.3%
0.09 0.06 0.03
0.01 0.01 0.00
1.43 1.41 1.39
1.53 1.48 1.42
0.03 0.02 0.01
0.00 0.00 0.00
0.03 0.02 0.01
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
1.53 1.48 1.42
-
8/13/2019 Copy of Examples Sent to TM
43/82
0.00 0.00 0.00
0.00 0.00 0.00
0.01 0.01 0.00
0.01 0.01 0.000.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00 1.0%
0.00 0.00 0.00 1167.33 12.97
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.000.00 0.00 0.00
4.44 2.90 1.42
1.53 1.48 1.42
0.00 0.00 0.00
2.90 1.42 0.00
4.100629 2.03225 1.64E-14
1.436506 0.690297 5.66E-15
-
8/13/2019 Copy of Examples Sent to TM
44/82
-
8/13/2019 Copy of Examples Sent to TM
45/82
-
8/13/2019 Copy of Examples Sent to TM
46/82
Exhibit 5(1) SMM and CPR
Pool Balance Rs. 30,000,000.00
WAC 10%
WAM 360 months
SMM 1%
Month
Opening
balance (Col
1)
Scheduled
Instalment
(Col 2)
Scheduled
Interest
(Col 3)
Scheduled
Principal
(Col 4)
Bal. Afterscheduled
principal (Col
5)
Prepayment
(SMM*Col.5
) (Col 6)
0
1 30,000,000.00 263,271.47 250000 13,271.47 29,986,728.53 299867.29
2 29,686,861.24 260,638.76 247390.5104 13,248.25 29,673,613.00 296736.13
3 29,376,876.87 258,032.37 244807.3072 13,225.06 29,363,651.81 293636.52
4 29,070,015.29 255,452.05 242250.1274 13,201.92 29,056,813.37 290568.13
5 28,766,245.24 252,897.52 239718.7103 13,178.81 28,753,066.42 287530.66
Month 1 2 3 4
Opening balance (Row 1) 30000000.00 29686861.24 29376876.87 29070015.29
Scheduled Instalment (Row 2) 263271.47 260638.76 258032.37 255452.05
Scheduled Interest (Row 3) 250000.00 247390.51 244807.31 242250.13
Scheduled Principal (Row 4) 13271.47 13248.25 13225.06 13201.92
Bal. After scheduled principal (Row 5) 29986728.53 29673613.00 29363651.81 29056813.37
Prepayment (SMM*Row 5) (Row 6) 299867.29 296736.13 293636.52 290568.13
Closing balance (Row 7) 29686861.24 29376876.87 29070015.29 28766245.24
PSA 50% 100% 150%Month CPR 50% CPR 100% CPR 150% SMM 50% SMM 100% SMM 150%
1 0.10% 0.20% 0.30% 0.01% 0.02% 0.03%
2 0.20% 0.40% 0.60% 0.02% 0.03% 0.05%
3 0.30% 0.60% 0.90% 0.03% 0.05% 0.08%
4 0.40% 0.80% 1.20% 0.03% 0.07% 0.10%
5 0.50% 1.00% 1.50% 0.04% 0.08% 0.13%
6 0.60% 1.20% 1.80% 0.05% 0.10% 0.15%
7 0.70% 1.40% 2.10% 0.06% 0.12% 0.18%
8 0.80% 1.60% 2.40% 0.07% 0.13% 0.20%
9 0.90% 1.80% 2.70% 0.08% 0.15% 0.23%
10 1.00% 2.00% 3.00% 0.08% 0.17% 0.25%
11 1.10% 2.20% 3.30% 0.09% 0.19% 0.28%
12 1.20% 2.40% 3.60% 0.10% 0.20% 0.31%
13 1.30% 2.60% 3.90% 0.11% 0.22% 0.33%
14 1.40% 2.80% 4.20% 0.12% 0.24% 0.36%
15 1.50% 3.00% 4.50% 0.13% 0.25% 0.38%
16 1.60% 3.20% 4.80% 0.13% 0.27% 0.41%
-
8/13/2019 Copy of Examples Sent to TM
47/82
17 1.70% 3.40% 5.10% 0.14% 0.29% 0.44%
18 1.80% 3.60% 5.40% 0.15% 0.31% 0.46%
19 1.90% 3.80% 5.70% 0.16% 0.32% 0.49%
20 2.00% 4.00% 6.00% 0.17% 0.34% 0.51%
21 2.10% 4.20% 6.30% 0.18% 0.36% 0.54%
22 2.20% 4.40% 6.60% 0.19% 0.37% 0.57%23 2.30% 4.60% 6.90% 0.19% 0.39% 0.59%
24 2.40% 4.80% 7.20% 0.20% 0.41% 0.62%
25 2.50% 5.00% 7.50% 0.21% 0.43% 0.65%
26 2.60% 5.20% 7.80% 0.22% 0.44% 0.67%
27 2.70% 5.40% 8.10% 0.23% 0.46% 0.70%
28 2.80% 5.60% 8.40% 0.24% 0.48% 0.73%
29 2.90% 5.80% 8.70% 0.24% 0.50% 0.76%
30 3.00% 6.00% 9.00% 0.25% 0.51% 0.78%
31 3.00% 6.00% 9.00% 0.25% 0.51% 0.78%
32 3.00% 6.00% 9.00% 0.25% 0.51% 0.78%
33 3.00% 6.00% 9.00% 0.25% 0.51% 0.78%
34 3.00% 6.00% 9.00% 0.25% 0.51% 0.78%
35 3.00% 6.00% 9.00% 0.25% 0.51% 0.78%
36 3.00% 6.00% 9.00% 0.25% 0.51% 0.78%
37 3.00% 6.00% 9.00% 0.25% 0.51% 0.78%
38 3.00% 6.00% 9.00% 0.25% 0.51% 0.78%
39 3.00% 6.00% 9.00% 0.25% 0.51% 0.78%
40 3.00% 6.00% 9.00% 0.25% 0.51% 0.78%
-
8/13/2019 Copy of Examples Sent to TM
48/82
Closing
balance
(Col 7)
29,686,861.24 0.9900 0.9900
29,376,876.87 0.9801 0.9801
29,070,015.29 0.9703 0.9703
28,766,245.24 0.9606 0.9606
28,465,535.76 0.9510 0.9510
5
28766245.24
252897.52
239718.71
13178.81
28753066.42
287530.66
28465535.76
PSA 50% 100% 150%
CPR 3.00% 6.00% 9.00%
SMM 0.25% 0.51% 0.78%
SMM CPR
0.85% 9.74%
-
8/13/2019 Copy of Examples Sent to TM
49/82
Exhibit 6(1) OC Test for Market Value CDOs
Collateral Rs. crore % CDO tranches Rs. crore %
Senior secured bank loans 200 33.33% Senior notes AA 400 66.67%
CD and CP 120 20.00% Mezannine notes BBB 150 25.00%
BBB high yield debt 130 21.67% Equity unrated 50 8.33%
Convertible bonds 150 25.00%
Total 600 600
OC test for senior notes AA
Collateral Rs. crore Adv. Rate
Senior secured bank loans 200 85%
CD and CP 120 95%
BB- high yield debt 130 71%
Convertible bonds 150 64%
Total 600
AA notes issued
Borrowing amount surplus 12%OC level (minimum permissible)
OC test for mezannine notes BBB
Collateral Rs. crore Adv. Rate
Senior secured bank loans 200 91%
CD and CP 120 95%
BB- high yield debt 130 87%
Convertible bonds 150 81%
Total 600
BB- notes issued
Borrowing amount surplus 63%
OC level (minimum permissible)
-
8/13/2019 Copy of Examples Sent to TM
50/82
Permissble
issue
170.00
114.00
92.30
96.00
472.30
400.00
72.301.27
Permissble
issue
182.00
114.00
113.10
121.50
530.60
150.00
380.60
1.13
-
8/13/2019 Copy of Examples Sent to TM
51/82
Exhibit 9(1) Collection Efficiency I
Securitised pool Rs. 100 crore
Average pool yield 11%
Average pool tenor 12 months
Securities Isued 100 crore
Collection pattern month of billing 80.00%Next month 12.00% 60 dpd
Next second month 3.00% 90 dpd
Loss Next month recovery 70% 3.50% 120 dpd
Loss 1.50%
PTCs issued (principal payable in 10 equal instalments) 72 crore
Coupon on PTCs 9.00%
Cash Flows (Original Schedule)
Months OpeningPrincipal Prepayment Principalafter lossEMI(Billings)
Interest Principal Closingprincipal
0
1 100.00 1.00 99.00 8.75 0.91 7.84 91.16
2 91.16 0.91 90.25 8.66 0.83 7.84 82.41
3 82.41 0.82 81.59 8.58 0.75 7.83 73.76
4 73.76 0.74 73.02 8.49 0.67 7.82 65.20
5 65.20 0.65 64.55 8.41 0.59 7.81 56.74
6 56.74 0.57 56.17 8.32 0.51 7.81 48.36
7 48.36 0.48 47.88 8.24 0.44 7.80 40.08
8 40.08 0.40 39.68 8.16 0.36 7.79 31.89
9 31.89 0.32 31.57 8.07 0.29 7.78 23.78
10 23.78 0.24 23.55 7.99 0.22 7.78 15.77
11 15.77 0.16 15.61 7.91 0.14 7.77 7.84
12 7.84 0.08 7.76 7.83 0.07 7.76 0.00
13 0.00 0.00 0.00
14
15
Total 5.78 93.63 99.41
Payins Principal
Months 1 2.00 3 4 5 6 7 8
1 6.27
2 0.94 6.27
3 0.24 0.94 6.26
4 0.27 0.24 0.94 6.265 0.27 0.23 0.94 6.25
6 0.27 0.23 0.94 6.24
7 0.27 0.23 0.94 6.24
8 0.27 0.23 0.94 6.23
9 0.27 0.23 0.93
10 0.27 0.23
11 0.27
12
-
8/13/2019 Copy of Examples Sent to TM
52/82
13
14
15
7.72 7.72 7.71 7.70 7.70 7.69 7.68 7.67
Loss 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12
Loss 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50%
Payins Interest
Months 1 2 3 4 5 6 7 8
1 0.73
2 0.11 0.66
3 0.03 0.10 0.60
4 0.03 0.02 0.09 0.54
5 0.03 0.02 0.08 0.47
6 0.03 0.02 0.07 0.41
7 0.02 0.02 0.06 0.35
8 0.02 0.02 0.05 0.299 0.02 0.01 0.04
10 0.02 0.01
11 0.01
12
13
14
15
Collection 0.89 0.81 0.74 0.66 0.58 0.51 0.43 0.36
Lost 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01
Actual Cash Flows
Months Opening
Principal
Principal billing Interest
billing
Total
billings
Prepayment Closing
principal
Sch.
principal
collections
Sch. interest
collections
0
1 100 7.84 0.91 8.75 1.00 91.16 6.27 0.73
2 91.16 7.84 0.83 8.66 0.91 82.41 7.21 0.77
3 82.41 7.83 0.75 8.58 0.82 73.76 7.44 0.72
4 73.76 7.82 0.67 8.49 0.74 65.20 7.71 0.68
5 65.20 7.81 0.59 8.41 0.65 56.74 7.70 0.61
6 56.74 7.81 0.51 8.32 0.57 48.36 7.69 0.53
7 48.36 7.80 0.44 8.24 0.48 40.08 7.68 0.45
8 40.08 7.79 0.36 8.16 0.40 31.89 7.68 0.38
9 31.89 7.78 0.29 8.07 0.32 23.78 7.67 0.31
10 23.78 7.78 0.22 7.99 0.24 15.77 7.66 0.23
11 15.77 7.77 0.14 7.91 0.16 7.84 7.66 0.16
12 7.84 7.76 0.07 7.83 0.08 (0.00) 7.65 0.09
13 (0.00) 0.00 0.00 0.00 0.00 (0.00) 1.44 0.02
14 (0.00) 0.00 0.00 0.00 0.00 (0.00) 0.50 0.01
15 (0.00) 0.00 0.00 0.00 0.00 (0.00) 0.27 0.00
Total 93.63 5.78 99.41 6.37 92.23 5.69
-
8/13/2019 Copy of Examples Sent to TM
53/82
Loss 1.40
Billings
Months 1 2 3 4 5 6 7
Pricnipal billings 7.84 7.84 7.83 7.82 7.81 7.81 7.80
Interest billings 0.91 0.83 0.75 0.67 0.59 0.51 0.44
Total billings 8.75 8.66 8.58 8.49 8.41 8.32 8.24
Delinquent Principal
Months
1 2 3 4 5 6 7 8
1 1.57
2 0.63 1.57
3 0.39 0.63 1.57
4 0.12 0.39 0.63 1.56
5 0.12 0.39 0.63 1.56
6 0.12 0.39 0.63 1.56
7 0.12 0.39 0.62 1.568 0.12 0.39 0.62 1.56
9 0.12 0.39 0.62
10 0.12 0.39
11 0.12
12
13
14
15
2.71 2.70 2.70 2.70 2.70 2.69 2.69 2.69
Delinquent Interest
Months
1 2 3 4 5 6 7 8
1 0.18
2 0.07 0.17
3 0.05 0.07 0.15
4 0.01 0.04 0.06 0.13
5 0.01 0.04 0.05 0.12
6 0.01 0.03 0.05 0.10
7 0.01 0.03 0.04 0.09
8 0.01 0.03 0.04 0.07
9 0.01 0.02 0.03
10 0.01 0.02
11 0.0112
13
14
15
-
8/13/2019 Copy of Examples Sent to TM
54/82
Months CCE MCE
1 0.8 0.82 0.8603015 0.921212121
3 0.890502 0.951821243
4 0.9144838 0.987892598
5 0.928872 0.987892598
6 0.9384633 0.987892598
7 0.9453135 0.987892598
8 0.9504505 0.987892598
9 0.9544455 0.987892598
10 0.957641 0.987892598
11 0.960255 0.987892598
12 0.962433 0.987892598
13 0.977091714 0.9822418
15 0.985
Summary Collection
Months
Prep prin Sch prin Add surp Total prin Prin to PTC Interest Intt to PTC
1 1.00 6.27 7.27 7.2 0.73
2 0.91 7.21 0.07 8.19 7.2 0.77
3 0.82 7.44 0.99 9.26 7.2 0.72
4 0.74 7.71 2.06 10.50 7.2 0.685 0.65 7.70 3.30 11.65 7.2 0.61
6 0.57 7.69 4.45 12.71 7.2 0.53
7 0.48 7.68 5.51 13.68 7.2 0.45
8 0.40 7.68 6.48 14.55 7.2 0.38
9 0.32 7.67 7.35 15.34 7.2 0.31
10 0.24 7.66 8.14 16.04 7.2 0.23
11 0.16 7.66 8.84 16.66 0 0.16
12 0.08 7.65 16.66 24.38 0 0.09
75%
80%
85%
90%
95%
100%
105%
0 1 2 3
CCE/MC
E
-
8/13/2019 Copy of Examples Sent to TM
55/82
13 0.00 1.44 24.38 25.82 0 0.02
14 0.00 0.50 25.82 26.32 0 0.01
15 0.00 0.27 26.32 26.60 0 0.00
PTC Amortization
Op bal Repaymnt Cl bal1 72 7.2 64.8
2 64.8 7.2 57.6
3 57.6 7.2 50.4
4 50.4 7.2 43.2
5 43.2 7.2 36
6 36 7.2 28.8
7 28.8 7.2 21.6
8 21.6 7.2 14.4
9 14.4 7.2 7.2
10 7.2 7.2 -1.24E-14
-
8/13/2019 Copy of Examples Sent to TM
56/82
9 10 11 12 Monthly collections
6.27
7.21
7.44
7.717.70
7.69
7.68
7.68
6.23 7.67
0.93 6.22 7.66
0.23 0.93 6.22 7.66
0.27 0.23 0.93 6.21 7.65
-
8/13/2019 Copy of Examples Sent to TM
57/82
0.27 0.23 0.93 1.44
0.27 0.23 0.50
0.27 0.27
7.67 7.66 7.65 7.65 92.23
0.12 0.12 0.12 0.12 1.40
1.50% 1.50% 1.50% 1.50% 0.0150
9 10 11 12 Monthly collections
0.73
0.77
0.72
0.68
0.61
0.53
0.45
0.380.23 0.31
0.03 0.17 0.23
0.01 0.03 0.11 0.16
0.01 0.01 0.02 0.06 0.09
0.01 0.00 0.01 0.02
0.01 0.00 0.01
0.00 0.00
0.29 0.21 0.14 0.07 5.69 97.92
0.00 0.00 0.00 0.00 0.087
1.50%
Total sch.
collections
Opening
overdues
Closing
overdues
Cum TB Cum total
col
CCE MCE
7.00 0 1.75 8.75 7.00 80.0% 80.0%
7.98 1.75 2.43 17.41 14.98 86.0% 92.1%
8.16 2.43 2.85 25.99 23.14 89.1% 95.2%
8.39 2.85 2.95 34.48 31.53 91.4% 98.79%
8.30 2.95 3.05 42.88 39.83 92.9% 98.79%
8.22 3.05 3.15 51.20 48.05 93.8% 98.79%
8.14 3.15 3.25 59.44 56.19 94.5% 98.79%
8.06 3.25 3.35 67.60 64.25 95.0% 98.79%
7.98 3.35 3.45 75.67 72.22 95.4% 98.79%
7.90 3.45 3.54 83.66 80.12 95.8% 98.79%
7.82 3.54 3.64 91.58 87.94 96.0% 98.79%
7.74 3.64 3.73 99.41 95.68 96.2% 98.79%
1.46 3.73 2.28 99.41 97.13 97.7%
0.51 2.28 1.77 99.41 97.65 98.2%
0.27 1.77 1.49 99.41 97.92 98.5%
97.92
-
8/13/2019 Copy of Examples Sent to TM
58/82
8 9 10 11 12 Total
7.79 7.78 7.78 7.77 7.76 93.63 0 0
0.36 0.29 0.22 0.14 0.07 5.78 0 0 5.7806733
8.16 8.07 7.99 7.91 7.83 99.41
9 10 11 12
Monthly
overdues
(prin) 60 dpd 90 dpd 120 dpd
1.57 1.57 0.00 0.00
2.19 1.57 0.63
2.58 1.57 0.63 0.39
2.70 1.56 0.63 0.39
2.70 1.56 0.63 0.39
2.69 1.56 0.63 0.39
2.69 1.56 0.63 0.392.69 1.56 0.62 0.39
1.56 2.69 1.56 0.62 0.39
0.62 1.56 2.68 1.56 0.62 0.39
0.39 0.62 1.55 2.68 1.55 0.62 0.39
0.12 0.39 0.62 1.55 2.68 1.55 0.62 0.39
0.12 0.39 0.62 1.13
0.12 0.39 0.50
0.12 0.12
2.69 2.68 2.68 2.68 32.30 40.14
9 10 11 12
Monthly
overdues
(intt) 60 dpd 90 dpd 120 dpd
0.18 1.7% 0.0% 0.0%
0.24 1.9% 0.8% 0.0%
0.26 2.1% 0.8% 0.5%
0.25 2.4% 1.0% 0.6%
0.22 2.8% 1.1% 0.7%
0.19 3.2% 1.3% 0.8%
0.17 3.9% 1.6% 1.0%
0.14 4.9% 2.0% 1.2%
0.06 0.12 6.5% 2.6% 1.6%
0.02 0.04 0.09 9.9% 4.0% 2.5%
0.01 0.02 0.03 0.07 19.8% 7.9% 5.0%0.004 0.01 0.01 0.01 0.04
0.003 0.01 0.01 0.02
0.002 0.004 0.01
0.001 0.00
-
8/13/2019 Copy of Examples Sent to TM
59/82
4 5 6 7 8 9 10 11 12 13 14 15 16
Months
Behaviour of CCE and MCE
CCE
MCE
0.0%
20.0%
40.0%
60.0%
80.0%
100.0%
120.0%
1 2 3 4 5
%o
ftotalprincipalo/s
Mo
ge ng
-
8/13/2019 Copy of Examples Sent to TM
60/82
-
8/13/2019 Copy of Examples Sent to TM
61/82
-
8/13/2019 Copy of Examples Sent to TM
62/82
-
8/13/2019 Copy of Examples Sent to TM
63/82
150 dpd Current Total o/s
0.00 89.59 91.16
80.22 82.41
71.17 73.76
0.12 62.50 65.20
0.12 54.04 56.74
0.12 45.67 48.36
0.12 37.39 40.080.12 29.20 31.89
0.12 21.10 23.78
0.12 13.08 15.77
0.12 5.16 7.84
0.12 -2.68 0.00
150 dpd Current Original Pool
0.0% 98.3% 100.0% 100 1.57%
0.0% 97.3% 100.0% 2.19%
0.0% 96.5% 100.0% 2.58%
0.2% 95.9% 100.0% 2.70%
0.2% 95.2% 100.0% 2.70%
0.2% 94.4% 100.0% 2.70%
0.3% 93.3% 100.0% 2.69%
0.4% 91.6% 100.0% 2.69%
0.5% 88.7% 100.0% 2.69%
0.7% 83.0% 100.0% 2.69%
1.5% 65.8% 100.0% 2.68%
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
3.00%
1 2 3 4 5 6 7 8 9 10
Month
Deliquency Rate
-
8/13/2019 Copy of Examples Sent to TM
64/82
6 7 8 9 10 11
nths
na ys s
60 dpd
90 dpd
120 dpd
150 dpd
Current
-
8/13/2019 Copy of Examples Sent to TM
65/82
-
8/13/2019 Copy of Examples Sent to TM
66/82
-
8/13/2019 Copy of Examples Sent to TM
67/82
-
8/13/2019 Copy of Examples Sent to TM
68/82
-
8/13/2019 Copy of Examples Sent to TM
69/82
-
8/13/2019 Copy of Examples Sent to TM
70/82
13
14
15
7.80 7.79 7.77 7.76 7.74 7.72 7.70 7.68
Loss 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12
Loss 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50%
Payins Interest
Months 1 2 3 4 5 6 7 8
1 0.73
2 0.11 0.67
3 0.03 0.10 0.60
4 0.03 0.03 0.09 0.54
5 0.03 0.02 0.08 0.48
6 0.03 0.02 0.07 0.41
7 0.02 0.02 0.06 0.35
8 0.02 0.02 0.05 0.299 0.02 0.01 0.04
10 0.02 0.01
11 0.01
12
13
14
15
Collection 0.90 0.82 0.74 0.66 0.59 0.51 0.43 0.36
Lost 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01
Actual Cash Flows
Months Opening
Principal
Principal
billing
Interest
billing
Total
billings
Prepayment Closing
principal
Sch.
principal
collections
Sch. interest
collections
0
1 100 7.92 0.92 8.84 1.00 91.08 6.34 0.73
2 91.08 7.91 0.83 8.74 0.91 82.26 7.28 0.78
3 82.26 7.89 0.75 8.65 0.82 73.55 7.50 0.73
4 73.55 7.88 0.67 8.55 0.74 64.93 7.76 0.69
5 64.93 7.86 0.60 8.46 0.65 56.42 7.75 0.61
6 56.42 7.84 0.52 8.36 0.56 48.02 7.73 0.53
7 48.02 7.82 0.44 8.26 0.48 39.72 7.71 0.46
8 39.72 7.80 0.36 8.16 0.40 31.52 7.69 0.38
9 31.52 7.77 0.29 8.06 0.32 23.43 7.66 0.31
10 23.43 7.74 0.21 7.95 0.23 15.46 7.63 0.23
11 15.46 7.69 0.14 7.84 0.15 7.61 7.59 0.16
12 7.61 7.61 0.07 7.68 0.00 (0.00) 7.52 0.09
13 (0.00) 0.00 0.00 0.00 0.00 (0.00) 1.41 0.02
14 (0.00) 0.00 0.00 0.00 0.00 (0.00) 0.50 0.01
15 (0.00) 0.00 0.00 0.00 0.00 (0.00) 0.27 0.00
Total 93.74 5.81 99.55 6.26 92.33 5.72
-
8/13/2019 Copy of Examples Sent to TM
71/82
Loss 1.41
Billings
Months 1 2 3 4 5 6 7
Pricnipal billings 7.84 7.84 7.83 7.82 7.81 7.81 7.80
Interest billings 0.91 0.83 0.75 0.67 0.59 0.51 0.44
Total billings 8.75 8.66 8.58 8.49 8.41 8.32 8.24
Delinquent Principal
Months
1 2 3 4 5 6 7 8
1 1.58
2 0.63 1.58
3 0.40 0.63 1.58
4 0.12 0.40 0.63 1.58
5 0.12 0.39 0.63 1.57
6 0.12 0.39 0.63 1.57
7 0.12 0.39 0.63 1.568 0.12 0.39 0.63 1.56
9 0.12 0.39 0.62
10 0.12 0.39
11 0.12
12
13
14
15
2.73 2.73 2.72 2.72 2.71 2.71 2.70 2.69
Delinquent Interest
Months
1 2 3 4 5 6 7 8
1 0.18
2 0.07 0.17
3 0.05 0.07 0.15
4 0.01 0.04 0.06 0.13
5 0.01 0.04 0.05 0.12
6 0.01 0.03 0.05 0.10
7 0.01 0.03 0.04 0.09
8 0.01 0.03 0.04 0.07
9 0.01 0.02 0.03
10 0.01 0.02
11 0.0112
13
14
15
-
8/13/2019 Copy of Examples Sent to TM
72/82
Months CCE MCE
1 0.8 0.82 0.8603015 0.9212121
3 0.890502 0.9518212
4 0.9144838 0.9878926
5 0.928872 0.9878926
6 0.9384633 0.9878926
7 0.9453135 0.9878926
8 0.9504505 0.9878926
9 0.9544455 0.9878926
10 0.957641 0.9878926
11 0.960255 0.9878926
12 0.962433 0.9878926
13 0.977091714 0.9822418
15 0.985
Summary Collection
Months
Months Prep prin Sch prin Add surp Total prin Prin to PTC Interest
collections
Add
surplus
Intt to PTC
1 1.00 6.34 7.34 7.6 0.73 0.57
2 0.91 7.28 (0.26) 7.92 7.6 0.78 0.16 0.513 0.82 7.50 0.32 8.65 7.6 0.73 0.26 0.46
4 0.74 7.76 1.05 9.55 7.6 0.69 0.27 0.40
5 0.65 7.75 1.95 10.34 7.6 0.61 0.29 0.34
6 0.56 7.73 2.74 11.03 7.6 0.53 0.27 0.29
7 0.48 7.71 3.43 11.62 7.6 0.46 0.25 0.23
8 0.40 7.69 4.02 12.11 7.6 0.38 0.23 0.17
9 0.32 7.66 4.51 12.49 7.6 0.31 0.21 0.11
10 0.23 7.63 4.89 12.75 7.6 0.23 0.19 0.06
75%
80%
85%
90%
95%
100%
105%
0 2
75%
80%
85%
90%
95%
100%
105%
0 2
-
8/13/2019 Copy of Examples Sent to TM
73/82
11 0.15 7.59 5.15 12.90 0 0.16 0.18
12 0.00 7.52 12.90 20.42 0 0.09 0.16
13 0.00 1.41 20.42 21.83 0 0.02 0.09
14 0.00 0.50 21.83 22.33 0 0.01 0.02
15 0.00 0.27 22.33 22.59 0 0.00 0.01
PTC Amortization 97.77777778
Op bal Repaymnt Cl bal Intt
1 76 7.6 68.4 0.57
2 68.4 7.6 60.8 0.513
3 60.8 7.6 53.2 0.456
4 53.2 7.6 45.6 0.399
5 45.6 7.6 38 0.342
6 38 7.6 30.4 0.285
7 30.4 7.6 22.8 0.228
8 22.8 7.6 15.2 0.171
9 15.2 7.6 7.6 0.114
10 7.6 7.6 0.00 0.057
-
8/13/2019 Copy of Examples Sent to TM
74/82
9 10 11 12 Monthly collections
6.34
7.28
7.50
7.767.75
7.73
7.71
7.69
6.22 7.66
0.93 6.19 7.63
0.23 0.93 6.16 7.59
0.27 0.23 0.92 6.09 7.52
-
8/13/2019 Copy of Examples Sent to TM
75/82
0.27 0.23 0.91 1.41
0.27 0.23 0.50
0.27 0.27
7.66 7.62 7.58 7.50 92.33
0.12 0.12 0.12 0.11 1.41 1.41%
1.50% 1.50% 1.50% 1.50% 0.0150
9 10 11 12 Monthly collections
0.73
0.78
0.73
0.69
0.61
0.53
0.46
0.380.23 0.31
0.03 0.17 0.23
0.01 0.03 0.11 0.16
0.01 0.01 0.02 0.06 0.09
0.01 0.00 0.01 0.02
0.00 0.00 0.01
0.00 0.00
0.28 0.21 0.14 0.07 5.72 98.05
0.00 0.00 0.00 0.00 0.087
1.50%
Total sch.
collections
Total Sch
Col+ Prep
Opening
overdues
Closing
overdues
Cum TB Cum total
sch col
Cum. Tot
act. col
CCE Rev MCE Rev
7.07 8.07 0 1.77 8.84 7.07 8.07 91.31%
8.05 8.97 1.77 2.46 17.58 15.12 17.04 96.90%
8.23 9.05 2.46 2.87 26.23 23.36 24.18 92.19%
8.45 9.19 2.87 2.97 34.78 31.81 32.54 93.57%
8.36 9.00 2.97 3.07 43.23 40.16 40.81 94.40%
8.26 8.83 3.07 3.17 51.59 48.42 48.99 94.95%
8.17 8.65 3.17 3.27 59.85 56.59 57.07 95.35%
8.07 8.47 3.27 3.36 68.02 64.66 65.05 95.64%
7.97 8.28 3.36 3.45 76.08 72.63 72.94 95.88%
7.87 8.10 3.45 3.54 84.03 80.49 80.72 96.06%
7.75 7.91 3.54 3.63 91.87 88.24 88.40 96.22%
7.60 7.60 3.63 3.70 99.55 95.85 95.85 96.28%
1.44 1.44 3.70 2.27 99.55 97.28 97.28 97.72%
0.50 0.50 2.27 1.76 99.55 97.79 97.79 98.23%
0.27 0.27 1.76 1.49 99.55 98.05 98.05 98.50%
98.05 104.32
-
8/13/2019 Copy of Examples Sent to TM
76/82
8 9 10 11 12 Total
7.79 7.78 7.78 7.77 7.76 93.63 0
0.36 0.29 0.22 0.14 0.07 5.78 0
8.16 8.07 7.99 7.91 7.83 99.41
9 10 11 12
Monthly
overdues
(prin) 60 dpd 150 dpd Current
1.58 1.58 0.00 89.49
2.22 1.58 80.05
2.61 1.58 70.94
2.72 1.58 0.12 62.21
2.72 1.57 0.12 53.71
2.71 1.57 0.12 45.31
2.70 1.56 0.12 37.012.70 1.56 0.12 28.82
1.55 2.69 1.55 0.12 20.75
0.62 1.55 2.68 1.55 0.12 12.78
0.39 0.62 1.54 2.66 1.54 0.12 4.95
0.12 0.39 0.62 1.52 2.64 1.52 0.12 -2.64
0.12 0.38 0.61 1.11
0.12 0.38 0.50
0.11 0.11
2.68 2.67 2.65 2.63 32.34 40.17
9 10 11 12
Monthly
overdues
(intt) 60 dpd 150 dpd Current
0.18 1.7% 0.0% 98.3%
0.24 1.9% 0.0% 98.1%
0.26 2.2% 0.0% 97.8%
0.25 2.5% 0.2% 97.3%
0.22 2.8% 0.2% 96.9%
0.20 3.3% 0.3% 96.4%
0.17 4.0% 0.3% 95.7%
0.14 5.1% 0.4% 94.5%
0.06 0.12 6.9% 0.5% 92.5%
0.02 0.04 0.09 10.7% 0.8% 88.5%
0.01 0.02 0.03 0.07 23.3% 1.8% 74.9%0.004 0.01 0.01 0.01 0.04
0.003 0.01 0.01 0.02
0.002 0.003 0.01
0.001 0.00
-
8/13/2019 Copy of Examples Sent to TM
77/82
Total
collection
Total
payouts
C to PO CC CPO CC to CPO
8.07 8.17 98.78% 8.07 8.17 98.78%
8.97 8.11 110.50% 17.04 16.28 104.62%9.05 8.06 112.39% 26.09 24.34 107.19%
9.19 8.00 114.83% 35.27 32.34 109.08%
9.00 7.94 113.38% 44.28 40.28 109.93%
8.83 7.89 111.92% 53.10 48.17 110.26%
8.65 7.83 110.44% 61.75 55.99 110.28%
8.47 7.77 108.94% 70.22 63.76 110.12%
8.28 7.71 107.39% 78.50 71.48 109.82%
8.10 7.7 105.78% 86.60 79.14 109.43%
4 6 8 10 12 14 16
Behaviour of CCE and MCE
CCE
MCE
0.0%
20.0%
40.0%
60.0%
80.0%
100.0%
120.0%
1 3 5 7 9 1
Ageing Analysis
4 6 8 10 12 14 16
Behaviour of CCE and MCE
CCE
MCE
0.0%
20.0%
40.0%
60.0%
80.0%
100.0%
120.0%
1 3 5 7 9 1
-
8/13/2019 Copy of Examples Sent to TM
78/82
-
8/13/2019 Copy of Examples Sent to TM
79/82
-
8/13/2019 Copy of Examples Sent to TM
80/82
-
8/13/2019 Copy of Examples Sent to TM
81/82
Total o/s
91.08
81.63
72.52
63.91
55.40
47.00
38.7030.50
22.42
14.45
6.60
(1.00)
Original Pool
#REF! 100 #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
3.00%
1 2 3 4 5 6 7 8 9 10 11
Deliquency Rate
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
3.00%
1 2 3 4 5 6 7 8 9 10 11
Deliquency Rate
-
8/13/2019 Copy of Examples Sent to TM
82/82
1
60 dpd
90 dpd
120 dpd
150 dpd
Current
1
60 dpd
90 dpd
120 dpd
150 dpd
Current