Load Value No. Of Instl

Asset Cost : 1,720,000 Net Finance : 1,720,000 Flat Rate : 5.554 PPD : Tenure : 48 No. of Instl. : 48 Instl. In Adv. : (1) Moritorium : 2 Mgmt. Fee : Loading : in instl. Amt. Load Value No. of Instl. 38300 1 43911 47

0 0 Split Disbm't : No Disbm't Amt. Disbm't Delay 0 1,720,000 0

None : Program 0 : P'dic Inflow : Upfront disc. : Credit Pd. Broker : Sourcing : Commision 100 : Upfront % - : Periodic % - : Term % Monthly : Scheme Periodicity : Disc't Rate 18 : IRR Guess 13.6 : Interest Tax Rate 20 : TDS Rate 60 : TDS Refund Delay No : Margin Money to us None : IRR Dilution : Agmt. Date

Deal IRR net of Brk. : Deal IRR gross of Brk. : Accounting IRR : Client's IRR :

9.750% 9.750% 9.75% 9.75%

Exposure : Disbursement Amt. : Interest Amt. : Agreement Value : Total Instlm't : EMI Amount : Instl. Amt. 1 : Instl. Amt. 2 : Instl. Amt. 3 : Instl. Amt. 4 : Instl. Amt. 5 : Subvention Flow : Commision Instl. :

100.00% 1,720,000 382,117 2,102,117 2,102,117 43,794 38,300 43,911 -

Client Name : Group Name :

Proposed By

Recommended By

Approved By

S. No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

Description Asset Cost Net Finance Split Disbursement Disbursement Amount 1 Disbursement Delay 1 Disbursement Amount 2 Disbursement Delay 2 Margin to us Flat Rate PPD Tenure No. of Instl. No. of Adv. Instls. Moritorium Mgmt. Fee Support Program P'dic Inflow Vendor Upfront disc. Vendor Credit Pd. Sourcing Commision Upfront % Periodic % Term % Periodicity Cost of Funds Interest Tax Rate TDS Rate TDS Refund Delay IRR Guess IRR Dilution Loading Load1 LoadPd1 Load2 LoadPd2 Load3 LoadPd3 Load4 LoadPd4 Load5 LoadPd5 Interest Charged Agreement Value EMI Amount Actual Disbursement Margin Money

Name Value AC 1720000 NF 1720000 SPTD 0 SDA1 0 DD1 0 SDA2 1720000 DD2 0 MTU 0 FR 0.06 PPD T 48.00 NOI 48.00 NOAI (1.00) M 2 MF SP None PI 0 VUD 0 VCP 0 S 1 C 0 UC 0 PC 0 TC 0 P 12 COF 0.00 ITR 0.136 TDSR 0.2 TDSRD 60 IRRG 0.18 ITD 0 L 2 Cummulative L1 38300 38300 LP1 1 1 L2 43911 2102117 LP2 47 48 L3 0 2102117 LP3 0 48 L4 0 2102117 LP4 0 48 L5 0 2102117 LP5 0 48 IC 382117 AV 2102117 EMIA 43794 AD 1720000 MM 0

Supprot Program Name None Customised TDec5.0 TDec8.0 TJan5.0 TJan6.5 TJan7.0 TJan7.5 TJan8.0 TJan8.5 TJan9.0 TJan9.5 TApr10.5 TApr9.5 TApr9.0 TApr8.5 TApr8.0 TApr7.5 TApr7.0 TApr6.0

1 Yr. 0 0 0 0 10 9 8 7 6 5 4 3 0 196 325 455 584 713 843 1102

2 Yrs.

3 Yrs. 0 0 0 0 11 10 9 8 7 6 5 4 0 184 314 444 574 704 834 1094

None 0 0 35 0 12 11 10 9 8 7 6 283 0 132 261 391 520 649 779 1038

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56

Instl. Stream 38,300 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 -

Pure Instl. 38,300 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 -

A/c Flows (1,720,000) 38,300 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 -

Interest Prin. Repay 13,976 (13,976) 14,089 24,211 13,892 30,019 13,648 30,263 13,403 30,508 13,155 30,756 12,905 31,006 12,653 31,258 12,399 31,512 12,143 31,768 11,885 32,026 11,624 32,287 11,362 32,549 11,098 32,813 10,831 33,080 10,562 33,349 10,291 33,620 10,018 33,893 9,743 34,168 9,465 34,446 9,185 34,726 8,903 35,008 8,619 35,292 8,332 35,579 8,043 35,868 7,751 36,160 7,457 36,454 7,161 36,750 6,863 37,048 6,562 37,349 6,258 37,653 5,952 37,959 5,644 38,267 5,333 38,578 5,019 38,892 4,703 39,208 4,385 39,526 4,064 39,847 3,740 40,171 3,414 40,497 3,084 40,827 2,753 41,158 2,418 41,493 2,081 41,830 1,741 42,170 1,399 42,512 1,053 42,858 705 43,206 354 43,557 (0) 0 (0) 0 (0) 0 (0) 0 (0) 0 (0) 0

Prin. Bal. 1,720,000 1,733,976 1,709,765 1,679,746 1,649,483 1,618,975 1,588,219 1,557,212 1,525,954 1,494,442 1,462,674 1,430,647 1,398,361 1,365,812 1,332,999 1,299,919 1,266,570 1,232,950 1,199,057 1,164,889 1,130,443 1,095,717 1,060,709 1,025,417 989,837 953,969 917,809 881,356 844,606 807,558 770,209 732,556 694,597 656,330 617,752 578,860 539,652 500,126 460,279 420,108 379,610 338,784 297,626 256,133 214,303 172,133 129,621 86,763 43,557 (0) (0) (0) (0) (0) (0) (0)

PPD -

Bal. Instl. Period Date (2,102,117) 0 30-Dec-99 (2,102,117) 1 30-Jan-00 (2,063,817) 2 28-Feb-00 (2,019,906) 3 28-Mar-00 (1,975,995) 4 28-Apr-00 (1,932,084) 5 28-May-00 (1,888,173) 6 28-Jun-00 (1,844,262) 7 28-Jul-00 (1,800,351) 8 28-Aug-00 (1,756,440) 9 28-Sep-00 (1,712,529) 10 28-Oct-00 (1,668,618) 11 28-Nov-00 (1,624,707) 12 28-Dec-00 (1,580,796) 13 28-Jan-01 (1,536,885) 14 28-Feb-01 (1,492,974) 15 28-Mar-01 (1,449,063) 16 28-Apr-01 (1,405,152) 17 28-May-01 (1,361,241) 18 28-Jun-01 (1,317,330) 19 28-Jul-01 (1,273,419) 20 28-Aug-01 (1,229,508) 21 28-Sep-01 (1,185,597) 22 28-Oct-01 (1,141,686) 23 28-Nov-01 (1,097,775) 24 28-Dec-01 (1,053,864) 25 28-Jan-02 (1,009,953) 26 28-Feb-02 (966,042) 27 28-Mar-02 (922,131) 28 28-Apr-02 (878,220) 29 28-May-02 (834,309) 30 28-Jun-02 (790,398) 31 28-Jul-02 (746,487) 32 28-Aug-02 (702,576) 33 28-Sep-02 (658,665) 34 28-Oct-02 (614,754) 35 28-Nov-02 (570,843) 36 28-Dec-02 (526,932) 37 28-Jan-03 (483,021) 38 28-Feb-03 (439,110) 39 28-Mar-03 (395,199) 40 28-Apr-03 (351,288) 41 28-May-03 (307,377) 42 28-Jun-03 (263,466) 43 28-Jul-03 (219,555) 44 28-Aug-03 (175,644) 45 28-Sep-03 (131,733) 46 28-Oct-03 (87,822) 47 28-Nov-03 (43,911) 48 28-Dec-03 49 28-Jan-04 50 28-Feb-04 51 28-Mar-04 52 28-Apr-04 53 28-May-04 54 28-Jun-04 55 28-Jul-04

57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113

-

-

-

(0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0)

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

(0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0)

-

-

56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112

28-Aug-04 28-Sep-04 28-Oct-04 28-Nov-04 28-Dec-04 28-Jan-05 28-Feb-05 28-Mar-05 28-Apr-05 28-May-05 28-Jun-05 28-Jul-05 28-Aug-05 28-Sep-05 28-Oct-05 28-Nov-05 28-Dec-05 28-Jan-06 28-Feb-06 28-Mar-06 28-Apr-06 28-May-06 28-Jun-06 28-Jul-06 28-Aug-06 28-Sep-06 28-Oct-06 28-Nov-06 28-Dec-06 28-Jan-07 28-Feb-07 28-Mar-07 28-Apr-07 28-May-07 28-Jun-07 28-Jul-07 28-Aug-07 28-Sep-07 28-Oct-07 28-Nov-07 28-Dec-07 28-Jan-08 28-Feb-08 28-Mar-08 28-Apr-08 28-May-08 28-Jun-08 28-Jul-08 28-Aug-08 28-Sep-08 28-Oct-08 28-Nov-08 28-Dec-08 28-Jan-09 28-Feb-09 28-Mar-09 28-Apr-09

114 115 116 117 118 119 120

-

2,102,117

0.81%

(0) (0) (0) (0) (0) (0) (0) 382,117

0 0 0 0 0 0 0 1,720,000

(0) (0) (0) (0) (0) (0) (0) -

-

-

113 114 115 116 117 118 119 120

28-May-09 28-Jun-09 28-Jul-09 28-Aug-09 28-Sep-09 28-Oct-09 28-Nov-09 28-Dec-09

Instl.-PPD 38,300 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 -

MF -

Client Flow (1,720,000) 38,300 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 -

Disbm't 1,720,000 -

Disc. -

Subvention -

Int. Tax 1,901 1,916 1,889 1,856 1,823 1,789 1,755 1,721 1,686 1,651 1,616 1,581 1,545 1,509 1,473 1,436 1,400 1,362 1,325 1,287 1,249 1,211 1,172 1,133 1,094 1,054 1,014 974 933 892 851 810 768 725 683 640 596 553 509 464 419 374 329 283 237 190 143 96 48 (0) (0) (0) (0) (0) (0)

TDS Flows 2,795 2,818 2,778 2,730 2,681 2,631 2,581 2,531 2,480 2,429 2,377 2,325 2,272 2,220 2,166 2,112 2,058 2,004 1,949 1,893 1,837 1,781 1,724 1,666 1,609 1,550 1,491 1,432 1,373 1,312 1,252 1,190 1,129 1,067 1,004 941 877 813 748 683 617 551 484 416 348 280 211 141 71 (0) (0) (0) (0) (0) (0)

-

-

-

-

-

-

(0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0) (0)

(0) (0) (0) (0) (0) (2,795) (2,818) (2,778) (2,730) (2,681) (2,631) (2,581) (2,531) (2,480) (2,429) (2,377) (2,325) (2,272) (2,220) (2,166) (2,112) (2,058) (2,004) (1,949) (1,893) (1,837) (1,781) (1,724) (1,666) (1,609) (1,550) (1,491) (1,432) (1,373) (1,312) (1,252) (1,190) (1,129) (1,067) (1,004) (941) (877) (813) (748) (683) (617) (551) (484) (416) (348) (280) (211) (141) (71) (0) (0) (0)

-

-

0.81%

-

-

-

(0) (0) (0) (0) (0) (0) (0) 51,968

(0) (0) (0) (0) (0) (0) (0) 0 (0)

Net Flow1 (1,720,000) 38,300 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 -

Commision -

Net Flow2 (1,720,000) 38,300 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 43,911 -

-

-

-

0.81%

0

0.81%