ammended to drive allignemnt - test file only ke variable h loan financials retail 10_may_2005

Upload: aiyaz

Post on 06-Jul-2018

218 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    1/76

    HOME LOANS. INTEREST FORECAST BASED ON VARIABLE INT£9,529,

    1

     YEAR 1 ( 2005 ) YEAR 1 ( 2005 )

    FTP Rate (forecast) 9.75 12

    GBP GBP

    L!"# D$%&'%*(A##'"++,) 6-500-000.00 6-500-00

    L!"# D$%&'%*(M!#/+,) 812-500.00 541-66

    O'%"#*$# L!"# (B$##$#) 3-315-682.00 3-368-08

     Y"+, ",# 285-705.81 1-235-28

    M"$# 4.75 4

    A" T (,"%) 15.00 1

    Iterest rate 14!50" 16

    $tsta%&' Baace   9-529-976 9-529

    I#% C/"* L!"#% *$%&'%* M!#/+, R",#% E#*$# B"+"# I#%

    *T+ 1 0!00 0!00 0!00 0!00 3,80

    *T+ 2 0!00 0!00 0!00 0!00 49,83

    *T+ 3 0!00 0!00 0!00 0!00 56,17

    *T+ 4 0!00 0!00 0!00 0!00 62,49

    *T+ 5 9,817!71 812,500!00 11,094!69 811,223!01 68,78

    *T+ 6 9,809!99 1,623,723!01 22,171!95 1,611,361!06 75,06

    *T+ 7 24,379!47 2,423,861!06 33,097!84 2,415,142!68 81,31

    *T+ 8 34,091!83 3,227,642!68 44,073!49 3,217,661!02 87,55

    *T+ 9 43,788!92 4,030,161!02 55,031!88 4,018,918!06 93,76

    *T+ 10 53,470!78 4,831,418!06 65,973!06 4,818,915!79 99,96

    *T+ 11 63,137!42 5,631,415!79 76,897!03 5,617,656!17 106,13

    *T+ 12 72,788!87 6,430,156!17 87,803!84 6,415,141!20 112,29

    C+!%$# B"+"# 285-705.81 6-415-141.20

    -r 1 *et Iterest o -1 .oa 114-834.72

    -r 1 *et Iterest o -2 .oa 319-92

    -r 1 *et Iterest o -3 .oa

    -r 1 *et Iterest o -4 .oa

    -r 1 *et Iterest o -5 .oa /era'e .oa 3,500,000!00 3,500,00

    *o of oas er r 2

    S / "%%'$!#%

    Interest income ov Year 1 Year 2 Year 3 Year 4

    Interest Income

     Year 1 Loans   1,276,511 114,835 301,464 294,815 287,1

     Year 2 Loans   1,640,953 - 319,923 448,824 440,8

     Year 3 Loans   2,720,169 - - 752,317 991,9

     Year 4 Loans   2,853,134 - - ###   1,306,0

     Year 5 Loans   1,888,131 - - ###

    Total Interest 10,378,898 114,835 621,387 1,495,955 3,026,0

    ca'e rate 145 150 160 1

    S+$# E'$"+# Interest income ov Year 1 Year 2 Year 3 Year 4

     Year 1 Loans £8,804 £792 £2,010 £1,843 £1, Year 2 Loans £11,317 £0 £2,133 £2,805 £2,

     Year 3 Loans £18,760 £0 £0 £4,702 £5, Year 4 Loans £19,677 £0 £0 £0 £7,

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    2/76

    L!"# C"+'+"!  £9,529,976 £21,045,826 £32,812,321 £45,458,481

    E# V"+'% L!"# S'",

    .oa /o$t 6,415,141!20 ce%$e% Paet

     /$a Iterest Rate 14!50 " ce%$e% *$er of Paets

    .oa Per&o% & -ears 15 /ct$a *$er of Paets

    *$er of Paets Per -ear 12 Tota ar Paets

    tart :ate of .oa 1;1;2005 Tota Iterest

    t&oa tra Paets

    L#* N"

    $#$"+

    1 2;1;2005 < 6,415,141!20 < 87,598!81 < < 87,598!81 < 10,082!52

    2 3;1;2005 6,405,058!68 87,598!81 87,598!81 10,204!35

    3 4;1;2005 6,394,854!33 87,598!81 87,598!81 10,327!65

    4 5;1;2005 6,384,526!68 87,598!81 87,598!81 10,452!44

    5 6;1;2005 6,374,074!24 87,598!81 87,598!81 10,578!74

    6 7;1;2005 6,363,495!49 87,598!81 87,598!81 10,706!57

    7 8;1;2005 6,352,788!92 87,598!81 87,598!81 10,835!94

    8 9;1;2005 6,341,952!98 87,598!81 87,598!81 10,966!88

    9 10;1;2005 6,330,986!10 87,598!81 87,598!81 11,099!39

    10 11;1;2005 6,319,886!71 87,598!81 87,598!81 11,233!5111 12;1;2005 6,308,653!20 87,598!81 87,598!81 11,369!25

    12 1;1;2006 6,297,283!95 87,598!81 87,598!81 11,506!63

    13 2;1;2006 6,285,777!32 87,598!81 87,598!81 11,645!67

    14 3;1;2006 6,274,131!66 87,598!81 87,598!81 11,786!38

    15 4;1;2006 6,262,345!27 87,598!81 87,598!81 11,928!80

    16 5;1;2006 6,250,416!47 87,598!81 87,598!81 12,072!94

    17 6;1;2006 6,238,343!53 87,598!81 87,598!81 12,218!82

    18 7;1;2006 6,226,124!70 87,598!81 87,598!81 12,366!47

    19 8;1;2006 6,213,758!24 87,598!81 87,598!81 12,515!90

    20 9;1;2006 6,201,242!34 87,598!81 87,598!81 12,667!13

    21 10;1;2006 6,188,575!21 87,598!81 87,598!81 12,820!19

    22 11;1;2006 6,175,755!02 87,598!81 87,598!81 12,975!10

    23 12;1;2006 6,162,779!92 87,598!81 87,598!81 13,131!88

    24 1;1;2007 6,149,648!03 87,598!81 87,598!81 13,290!56

    25 2;1;2007 6,136,357!47 87,598!81 87,598!81 13,451!1626 3;1;2007 6,122,906!32 87,598!81 87,598!81 13,613!69

    27 4;1;2007 6,109,292!63 87,598!81 87,598!81 13,778!19

    28 5;1;2007 6,095,514!44 87,598!81 87,598!81 13,944!68

    29 6;1;2007 6,081,569!76 87,598!81 87,598!81 14,113!17

    30 7;1;2007 6,067,456!59 87,598!81 87,598!81 14,283!71

    31 8;1;2007 6,053,172!88 87,598!81 87,598!81 14,456!30

    32 9;1;2007 6,038,716!58 87,598!81 87,598!81 14,630!98

    33 10;1;2007 6,024,085!59 87,598!81 87,598!81 14,807!77

    34 11;1;2007 6,009,277!82 87,598!81 87,598!81 14,986!70

    35 12;1;2007 5,994,291!12 87,598!81 87,598!81 15,167!79

    36 1;1;2008 5,979,123!33 87,598!81 87,598!81 15,351!07

    37 2;1;2008 5,963,772!26 87,598!81 87,598!81 15,536!56

    38 3;1;2008 5,948,235!70 87,598!81 87,598!81 15,724!29

    39 4;1;2008 5,932,511!40 87,598!81 87,598!81 15,914!30

    40 5;1;2008 5,916,597!11 87,598!81 87,598!81 16,106!59

    41 6;1;2008 5,900,490!52 87,598!81 87,598!81 16,301!21

    42 7;1;2008 5,884,189!30 87,598!81 87,598!81 16,498!19

    43 8;1;2008 5,867,691!11 87,598!81 87,598!81 16,697!54

    44 9;1;2008 5,850,993!57 87,598!81 87,598!81 16,899!30

    45 10;1;2008 5,834,094!27 87,598!81 87,598!81 17,103!50

    46 11;1;2008 5,816,990!77 87,598!81 87,598!81 17,310!17

    47 12;1;2008 5,799,680!60 87,598!81 87,598!81 17,519!33

    48 1;1;2009 5,782,161!26 87,598!81 87,598!81 17,731!03

    49 2;1;2009 5,764,430!24 87,598!81 87,598!81 17,945!28

    50 3;1;2009 5,746,484!96 87,598!81 87,598!81 18,162!12

    51 4;1;2009 5,728,322!85 87,598!81 87,598!81 18,381!57

    52 5;1;2009 5,709,941!27 87,598!81 87,598!81 18,603!68

    53 6;1;2009 5,691,337!59 87,598!81 87,598!81 18,828!48

    N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    3/76

    $#$"+N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    54 7;1;2009 5,672,509!11 87,598!81 87,598!81 19,055!99

    55 8;1;2009 5,653,453!12 87,598!81 87,598!81 19,286!25

    56 9;1;2009 5,634,166!87 87,598!81 87,598!81 19,519!29

    57 10;1;2009 5,614,647!58 87,598!81 87,598!81 19,755!15

    58 11;1;2009 5,594,892!43 87,598!81 87,598!81 19,993!86

    59 12;1;2009 5,574,898!57 87,598!81 87,598!81 20,235!45

    60 1;1;2010 5,554,663!12 87,598!81 87,598!81 20,479!96

    61 2;1;2010 5,534,183!15 87,598!81 87,598!81 20,727!43

    62 3;1;2010 5,513,455!73 87,598!81 87,598!81 20,977!8863 4;1;2010 5,492,477!84 87,598!81 87,598!81 21,231!37

    64 5;1;2010 5,471,246!47 87,598!81 87,598!81 21,487!91

    65 6;1;2010 5,449,758!56 87,598!81 87,598!81 21,747!56

    66 7;1;2010 5,428,011!00 87,598!81 87,598!81 22,010!34

    67 8;1;2010 5,406,000!66 87,598!81 87,598!81 22,276!30

    68 9;1;2010 5,383,724!36 87,598!81 87,598!81 22,545!47

    69 10;1;2010 5,361,178!89 87,598!81 87,598!81 22,817!90

    70 11;1;2010 5,338,360!99 87,598!81 87,598!81 23,093!61

    71 12;1;2010 5,315,267!38 87,598!81 87,598!81 23,372!66

    72 1;1;2011 5,291,894!72 87,598!81 87,598!81 23,655!08

    73 2;1;2011 5,268,239!63 87,598!81 87,598!81 23,940!91

    74 3;1;2011 5,244,298!72 87,598!81 87,598!81 24,230!20

    75 4;1;2011 5,220,068!52 87,598!81 87,598!81 24,522!98

    76 5;1;2011 5,195,545!54 87,598!81 87,598!81 24,819!30

    77 6;1;2011 5,170,726!24 87,598!81 87,598!81 25,119!20

    78 7;1;2011 5,145,607!04 87,598!81 87,598!81 25,422!72

    79 8;1;2011 5,120,184!32 87,598!81 87,598!81 25,729!91

    80 9;1;2011 5,094,454!41 87,598!81 87,598!81 26,040!82

    81 10;1;2011 5,068,413!59 87,598!81 87,598!81 26,355!48

    82 11;1;2011 5,042,058!11 87,598!81 87,598!81 26,673!94

    83 12;1;2011 5,015,384!17 87,598!81 87,598!81 26,996!25

    84 1;1;2012 4,988,387!92 87,598!81 87,598!81 27,322!45

    85 2;1;2012 4,961,065!47 87,598!81 87,598!81 27,652!60

    86 3;1;2012 4,933,412!87 87,598!81 87,598!81 27,986!74

    87 4;1;2012 4,905,426!13 87,598!81 87,598!81 28,324!91

    88 5;1;2012 4,877,101!22 87,598!81 87,598!81 28,667!17

    89 6;1;2012 4,848,434!05 87,598!81 87,598!81 29,013!56

    90 7;1;2012 4,819,420!49 87,598!81 87,598!81 29,364!14

    91 8;1;2012 4,790,056!34 87,598!81 87,598!81 29,718!9692 9;1;2012 4,760,337!38 87,598!81 87,598!81 30,078!06

    93 10;1;2012 4,730,259!32 87,598!81 87,598!81 30,441!51

    94 11;1;2012 4,699,817!81 87,598!81 87,598!81 30,809!34

    95 12;1;2012 4,669,008!47 87,598!81 87,598!81 31,181!62

    96 1;1;2013 4,637,826!85 87,598!81 87,598!81 31,558!40

    97 2;1;2013 4,606,268!44 87,598!81 87,598!81 31,939!73

    98 3;1;2013 4,574,328!71 87,598!81 87,598!81 32,325!67

    99 4;1;2013 4,542,003!04 87,598!81 87,598!81 32,716!27

    100 5;1;2013 4,509,286!77 87,598!81 87,598!81 33,111!59

    101 6;1;2013 4,476,175!18 87,598!81 87,598!81 33,511!69

    102 7;1;2013 4,442,663!49 87,598!81 87,598!81 33,916!62

    103 8;1;2013 4,408,746!86 87,598!81 87,598!81 34,326!45

    104 9;1;2013 4,374,420!41 87,598!81 87,598!81 34,741!23

    105 10;1;2013 4,339,679!18 87,598!81 87,598!81 35,161!02

    106 11;1;2013 4,304,518!17 87,598!81 87,598!81 35,585!88107 12;1;2013 4,268,932!28 87,598!81 87,598!81 36,015!88

    108 1;1;2014 4,232,916!41 87,598!81 87,598!81 36,451!07

    109 2;1;2014 4,196,465!34 87,598!81 87,598!81 36,891!52

    110 3;1;2014 4,159,573!82 87,598!81 87,598!81 37,337!29

    111 4;1;2014 4,122,236!53 87,598!81 87,598!81 37,788!45

    112 5;1;2014 4,084,448!08 87,598!81 87,598!81 38,245!06

    113 6;1;2014 4,046,203!02 87,598!81 87,598!81 38,707!19

    114 7;1;2014 4,007,495!83 87,598!81 87,598!81 39,174!90

    115 8;1;2014 3,968,320!93 87,598!81 87,598!81 39,648!26

    116 9;1;2014 3,928,672!67 87,598!81 87,598!81 40,127!35

    117 10;1;2014 3,888,545!32 87,598!81 87,598!81 40,612!22

    118 11;1;2014 3,847,933!10 87,598!81 87,598!81 41,102!95

    119 12;1;2014 3,806,830!15 87,598!81 87,598!81 41,599!61

    120 1;1;2015 3,765,230!54 87,598!81 87,598!81 42,102!27

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    4/76

    $#$"+N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    121 2;1;2015 3,723,128!27 87,598!81 87,598!81 42,611!01

    122 3;1;2015 3,680,517!26 87,598!81 87,598!81 43,125!89

    123 4;1;2015 3,637,391!37 87,598!81 87,598!81 43,647!00

    124 5;1;2015 3,593,744!37 87,598!81 87,598!81 44,174!40

    125 6;1;2015 3,549,569!97 87,598!81 87,598!81 44,708!17

    126 7;1;2015 3,504,861!80 87,598!81 87,598!81 45,248!39

    127 8;1;2015 3,459,613!41 87,598!81 87,598!81 45,795!15

    128 9;1;2015 3,413,818!26 87,598!81 87,598!81 46,348!50

    129 10;1;2015 3,367,469!76 87,598!81 87,598!81 46,908!55130 11;1;2015 3,320,561!21 87,598!81 87,598!81 47,475!36

    131 12;1;2015 3,273,085!85 87,598!81 87,598!81 48,049!02

    132 1;1;2016 3,225,036!83 87,598!81 87,598!81 48,629!61

    133 2;1;2016 3,176,407!21 87,598!81 87,598!81 49,217!22

    134 3;1;2016 3,127,189!99 87,598!81 87,598!81 49,811!93

    135 4;1;2016 3,077,378!06 87,598!81 87,598!81 50,413!82

    136 5;1;2016 3,026,964!24 87,598!81 87,598!81 51,022!99

    137 6;1;2016 2,975,941!25 87,598!81 87,598!81 51,639!52

    138 7;1;2016 2,924,301!73 87,598!81 87,598!81 52,263!50

    139 8;1;2016 2,872,038!23 87,598!81 87,598!81 52,895!01

    140 9;1;2016 2,819,143!22 87,598!81 87,598!81 53,534!16

    141 10;1;2016 2,765,609!06 87,598!81 87,598!81 54,181!03

    142 11;1;2016 2,711,428!03 87,598!81 87,598!81 54,835!72

    143 12;1;2016 2,656,592!31 87,598!81 87,598!81 55,498!32

    144 1;1;2017 2,601,093!99 87,598!81 87,598!81 56,168!92

    145 2;1;2017 2,544,925!07 87,598!81 87,598!81 56,847!63

    146 3;1;2017 2,488,077!44 87,598!81 87,598!81 57,534!54

    147 4;1;2017 2,430,542!90 87,598!81 87,598!81 58,229!75

    148 5;1;2017 2,372,313!15 87,598!81 87,598!81 58,933!36

    149 6;1;2017 2,313,379!79 87,598!81 87,598!81 59,645!47

    150 7;1;2017 2,253,734!32 87,598!81 87,598!81 60,366!19

    151 8;1;2017 2,193,368!14 87,598!81 87,598!81 61,095!61

    152 9;1;2017 2,132,272!53 87,598!81 87,598!81 61,833!85

    153 10;1;2017 2,070,438!68 87,598!81 87,598!81 62,581!01

    154 11;1;2017 2,007,857!67 87,598!81 87,598!81 63,337!19

    155 12;1;2017 1,944,520!48 87,598!81 87,598!81 64,102!52

    156 1;1;2018 1,880,417!96 87,598!81 87,598!81 64,877!09

    157 2;1;2018 1,815,540!87 87,598!81 87,598!81 65,661!02

    158 3;1;2018 1,749,879!84 87,598!81 87,598!81 66,454!43159 4;1;2018 1,683,425!42 87,598!81 87,598!81 67,257!42

    160 5;1;2018 1,616,168!00 87,598!81 87,598!81 68,070!11

    161 6;1;2018 1,548,097!89 87,598!81 87,598!81 68,892!63

    162 7;1;2018 1,479,205!26 87,598!81 87,598!81 69,725!08

    163 8;1;2018 1,409,480!18 87,598!81 87,598!81 70,567!59

    164 9;1;2018 1,338,912!59 87,598!81 87,598!81 71,420!28

    165 10;1;2018 1,267,492!31 87,598!81 87,598!81 72,283!28

    166 11;1;2018 1,195,209!04 87,598!81 87,598!81 73,156!70

    167 12;1;2018 1,122,052!34 87,598!81 87,598!81 74,040!68

    168 1;1;2019 1,048,011!66 87,598!81 87,598!81 74,935!33

    169 2;1;2019 973,076!33 87,598!81 87,598!81 75,840!80

    170 3;1;2019 897,235!52 87,598!81 87,598!81 76,757!21

    171 4;1;2019 820,478!31 87,598!81 87,598!81 77,684!70

    172 5;1;2019 742,793!62 87,598!81 87,598!81 78,623!39

    173 6;1;2019 664,170!23 87,598!81 87,598!81 79,573!42174 7;1;2019 584,596!81 87,598!81 87,598!81 80,534!93

    175 8;1;2019 504,061!88 87,598!81 87,598!81 81,508!06

    176 9;1;2019 422,553!82 87,598!81 87,598!81 82,492!95

    177 10;1;2019 340,060!87 87,598!81 87,598!81 83,489!74

    178 11;1;2019 256,571!13 87,598!81 87,598!81 84,498!57

    179 12;1;2019 172,072!56 87,598!81 87,598!81 85,519!60

    180 1;1;2020 86,552!96 87,598!81 86,552!96 85,507!11

    181 2;1;2020 0!00 87,598!81 0!00 0!00

    182 3;1;2020 0!00 87,598!81 0!00 0!00

    183 4;1;2020 0!00 87,598!81 0!00 0!00

    184 5;1;2020 0!00 87,598!81 0!00 0!00

    185 6;1;2020 0!00 87,598!81 0!00 0!00

    186 7;1;2020 0!00 87,598!81 0!00 0!00

    187 8;1;2020 0!00 87,598!81 0!00 0!00

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    5/76

    $#$"+N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    188 9;1;2020 0!00 87,598!81 0!00 0!00

    189 10;1;2020 0!00 87,598!81 0!00 0!00

    190 11;1;2020 0!00 87,598!81 0!00 0!00

    191 12;1;2020 0!00 87,598!81 0!00 0!00

    192 1;1;2021 0!00 87,598!81 0!00 0!00

    193 2;1;2021 0!00 87,598!81 0!00 0!00

    194 3;1;2021 0!00 87,598!81 0!00 0!00

    195 4;1;2021 0!00 87,598!81 0!00 0!00

    196 5;1;2021 0!00 87,598!81 0!00 0!00197 6;1;2021 0!00 87,598!81 0!00 0!00

    198 7;1;2021 0!00 87,598!81 0!00 0!00

    199 8;1;2021 0!00 87,598!81 0!00 0!00

    200 9;1;2021 0!00 87,598!81 0!00 0!00

    201 10;1;2021 0!00 87,598!81 0!00 0!00

    202 11;1;2021 0!00 87,598!81 0!00 0!00

    203 12;1;2021 0!00 87,598!81 0!00 0!00

    204 1;1;2022 0!00 87,598!81 0!00 0!00

    205 2;1;2022 0!00 87,598!81 0!00 0!00

    206 3;1;2022 0!00 87,598!81 0!00 0!00

    207 4;1;2022 0!00 87,598!81 0!00 0!00

    208 5;1;2022 0!00 87,598!81 0!00 0!00

    209 6;1;2022 0!00 87,598!81 0!00 0!00

    210 7;1;2022 0!00 87,598!81 0!00 0!00

    211 8;1;2022 0!00 87,598!81 0!00 0!00

    212 9;1;2022 0!00 87,598!81 0!00 0!00

    213 10;1;2022 0!00 87,598!81 0!00 0!00

    214 11;1;2022 0!00 87,598!81 0!00 0!00

    215 12;1;2022 0!00 87,598!81 0!00 0!00

    216 1;1;2023 0!00 87,598!81 0!00 0!00

    217 2;1;2023 0!00 87,598!81 0!00 0!00

    218 3;1;2023 0!00 87,598!81 0!00 0!00

    219 4;1;2023 0!00 87,598!81 0!00 0!00

    220 5;1;2023 0!00 87,598!81 0!00 0!00

    221 6;1;2023 0!00 87,598!81 0!00 0!00

    222 7;1;2023 0!00 87,598!81 0!00 0!00

    223 8;1;2023 0!00 87,598!81 0!00 0!00

    224 9;1;2023 0!00 87,598!81 0!00 0!00

    225 10;1;2023 0!00 87,598!81 0!00 0!00226 11;1;2023 0!00 87,598!81 0!00 0!00

    227 12;1;2023 0!00 87,598!81 0!00 0!00

    228 1;1;2024 0!00 87,598!81 0!00 0!00

    229 2;1;2024 0!00 87,598!81 0!00 0!00

    230 3;1;2024 0!00 87,598!81 0!00 0!00

    231 4;1;2024 0!00 87,598!81 0!00 0!00

    232 5;1;2024 0!00 87,598!81 0!00 0!00

    233 6;1;2024 0!00 87,598!81 0!00 0!00

    234 7;1;2024 0!00 87,598!81 0!00 0!00

    235 8;1;2024 0!00 87,598!81 0!00 0!00

    236 9;1;2024 0!00 87,598!81 0!00 0!00

    237 10;1;2024 0!00 87,598!81 0!00 0!00

    238 11;1;2024 0!00 87,598!81 0!00 0!00

    239 12;1;2024 0!00 87,598!81 0!00 0!00

    240 1;1;2025 0!00 87,598!81 0!00 0!00241 2;1;2025 0!00 87,598!81 0!00 0!00

    242 3;1;2025 0!00 87,598!81 0!00 0!00

    243 4;1;2025 0!00 87,598!81 0!00 0!00

    244 5;1;2025 0!00 87,598!81 0!00 0!00

    245 6;1;2025 0!00 87,598!81 0!00 0!00

    246 7;1;2025 0!00 87,598!81 0!00 0!00

    247 8;1;2025 0!00 87,598!81 0!00 0!00

    248 9;1;2025 0!00 87,598!81 0!00 0!00

    249 10;1;2025 0!00 87,598!81 0!00 0!00

    250 11;1;2025 0!00 87,598!81 0!00 0!00

    251 12;1;2025 0!00 87,598!81 0!00 0!00

    252 1;1;2026 0!00 87,598!81 0!00 0!00

    253 2;1;2026 0!00 87,598!81 0!00 0!00

    254 3;1;2026 0!00 87,598!81 0!00 0!00

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    6/76

    $#$"+N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    255 4;1;2026 0!00 87,598!81 0!00 0!00

    256 5;1;2026 0!00 87,598!81 0!00 0!00

    257 6;1;2026 0!00 87,598!81 0!00 0!00

    258 7;1;2026 0!00 87,598!81 0!00 0!00

    259 8;1;2026 0!00 87,598!81 0!00 0!00

    260 9;1;2026 0!00 87,598!81 0!00 0!00

    261 10;1;2026 0!00 87,598!81 0!00 0!00

    262 11;1;2026 0!00 87,598!81 0!00 0!00

    263 12;1;2026 0!00 87,598!81 0!00 0!00264 1;1;2027 0!00 87,598!81 0!00 0!00

    265 2;1;2027 0!00 87,598!81 0!00 0!00

    266 3;1;2027 0!00 87,598!81 0!00 0!00

    267 4;1;2027 0!00 87,598!81 0!00 0!00

    268 5;1;2027 0!00 87,598!81 0!00 0!00

    269 6;1;2027 0!00 87,598!81 0!00 0!00

    270 7;1;2027 0!00 87,598!81 0!00 0!00

    271 8;1;2027 0!00 87,598!81 0!00 0!00

    272 9;1;2027 0!00 87,598!81 0!00 0!00

    273 10;1;2027 0!00 87,598!81 0!00 0!00

    274 11;1;2027 0!00 87,598!81 0!00 0!00

    275 12;1;2027 0!00 87,598!81 0!00 0!00

    276 1;1;2028 0!00 87,598!81 0!00 0!00

    277 2;1;2028 0!00 87,598!81 0!00 0!00

    278 3;1;2028 0!00 87,598!81 0!00 0!00

    279 4;1;2028 0!00 87,598!81 0!00 0!00

    280 5;1;2028 0!00 87,598!81 0!00 0!00

    281 6;1;2028 0!00 87,598!81 0!00 0!00

    282 7;1;2028 0!00 87,598!81 0!00 0!00

    283 8;1;2028 0!00 87,598!81 0!00 0!00

    284 9;1;2028 0!00 87,598!81 0!00 0!00

    285 10;1;2028 0!00 87,598!81 0!00 0!00

    286 11;1;2028 0!00 87,598!81 0!00 0!00

    287 12;1;2028 0!00 87,598!81 0!00 0!00

    288 1;1;2029 0!00 87,598!81 0!00 0!00

    289 2;1;2029 0!00 87,598!81 0!00 0!00

    290 3;1;2029 0!00 87,598!81 0!00 0!00

    291 4;1;2029 0!00 87,598!81 0!00 0!00

    292 5;1;2029 0!00 87,598!81 0!00 0!00293 6;1;2029 0!00 87,598!81 0!00 0!00

    294 7;1;2029 0!00 87,598!81 0!00 0!00

    295 8;1;2029 0!00 87,598!81 0!00 0!00

    296 9;1;2029 0!00 87,598!81 0!00 0!00

    297 10;1;2029 0!00 87,598!81 0!00 0!00

    298 11;1;2029 0!00 87,598!81 0!00 0!00

    299 12;1;2029 0!00 87,598!81 0!00 0!00

    300 1;1;2030 0!00 87,598!81 0!00 0!00

    301 2;1;2030 0!00 87,598!81 0!00 0!00

    302 3;1;2030 0!00 87,598!81 0!00 0!00

    303 4;1;2030 0!00 87,598!81 0!00 0!00

    304 5;1;2030 0!00 87,598!81 0!00 0!00

    305 6;1;2030 0!00 87,598!81 0!00 0!00

    306 7;1;2030 0!00 87,598!81 0!00 0!00

    307 8;1;2030 0!00 87,598!81 0!00 0!00308 9;1;2030 0!00 87,598!81 0!00 0!00

    309 10;1;2030 0!00 87,598!81 0!00 0!00

    310 11;1;2030 0!00 87,598!81 0!00 0!00

    311 12;1;2030 0!00 87,598!81 0!00 0!00

    312 1;1;2031 0!00 87,598!81 0!00 0!00

    313 2;1;2031 0!00 87,598!81 0!00 0!00

    314 3;1;2031 0!00 87,598!81 0!00 0!00

    315 4;1;2031 0!00 87,598!81 0!00 0!00

    316 5;1;2031 0!00 87,598!81 0!00 0!00

    317 6;1;2031 0!00 87,598!81 0!00 0!00

    318 7;1;2031 0!00 87,598!81 0!00 0!00

    319 8;1;2031 0!00 87,598!81 0!00 0!00

    320 9;1;2031 0!00 87,598!81 0!00 0!00

    321 10;1;2031 0!00 87,598!81 0!00 0!00

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    7/76

    $#$"+N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    322 11;1;2031 0!00 87,598!81 0!00 0!00

    323 12;1;2031 0!00 87,598!81 0!00 0!00

    324 1;1;2032 0!00 87,598!81 0!00 0!00

    325 2;1;2032 0!00 87,598!81 0!00 0!00

    326 3;1;2032 0!00 87,598!81 0!00 0!00

    327 4;1;2032 0!00 87,598!81 0!00 0!00

    328 5;1;2032 0!00 87,598!81 0!00 0!00

    329 6;1;2032 0!00 87,598!81 0!00 0!00

    330 7;1;2032 0!00 87,598!81 0!00 0!00331 8;1;2032 0!00 87,598!81 0!00 0!00

    332 9;1;2032 0!00 87,598!81 0!00 0!00

    333 10;1;2032 0!00 87,598!81 0!00 0!00

    334 11;1;2032 0!00 87,598!81 0!00 0!00

    335 12;1;2032 0!00 87,598!81 0!00 0!00

    336 1;1;2033 0!00 87,598!81 0!00 0!00

    337 2;1;2033 0!00 87,598!81 0!00 0!00

    338 3;1;2033 0!00 87,598!81 0!00 0!00

    339 4;1;2033 0!00 87,598!81 0!00 0!00

    340 5;1;2033 0!00 87,598!81 0!00 0!00

    341 6;1;2033 0!00 87,598!81 0!00 0!00

    342 7;1;2033 0!00 87,598!81 0!00 0!00

    343 8;1;2033 0!00 87,598!81 0!00 0!00

    344 9;1;2033 0!00 87,598!81 0!00 0!00

    345 10;1;2033 0!00 87,598!81 0!00 0!00

    346 11;1;2033 0!00 87,598!81 0!00 0!00

    347 12;1;2033 0!00 87,598!81 0!00 0!00

    348 1;1;2034 0!00 87,598!81 0!00 0!00

    349 2;1;2034 0!00 87,598!81 0!00 0!00

    350 3;1;2034 0!00 87,598!81 0!00 0!00

    351 4;1;2034 0!00 87,598!81 0!00 0!00

    352 5;1;2034 0!00 87,598!81 0!00 0!00

    353 6;1;2034 0!00 87,598!81 0!00 0!00

    354 7;1;2034 0!00 87,598!81 0!00 0!00

    355 8;1;2034 0!00 87,598!81 0!00 0!00

    356 9;1;2034 0!00 87,598!81 0!00 0!00

    357 10;1;2034 0!00 87,598!81 0!00 0!00

    358 11;1;2034 0!00 87,598!81 0!00 0!00

    359 12;1;2034 0!00 87,598!81 0!00 0!00360 1;1;2035 0!00 87,598!81 0!00 0!00

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    8/76

    £59,249,393

     

    < 87,598!81

    180

    180

    <

    < 9,352,644!30

    I#% M"$# NII ",# N!

     < 77,516!29 < 6,405,058!68 4!75" 25,353!36 1

    77,394!46 6,394,854!33 4!75" 25,312!97 2

    77,271!16 6,384,526!68 4!75" 25,272!08 3

    77,146!36 6,374,074!24 4!75" 25,230!71 4

    77,020!06 6,363,495!49 4!75" 25,188!84 5

    76,892!24 6,352,788!92 4!75" 25,146!46 6

    76,762!87 6,341,952!98 4!75" 25,103!56 7

    76,631!93 6,330,986!10 4!75" 25,060!15 8

    76,499!42 6,319,886!71 4!75" 25,016!22 9

    76,365!30 6,308,653!20 4!75" 24,971!75 1076,229!56 6,297,283!95 4!75" 24,926!75 11

    76,092!18 6,285,777!32 4!75" 24,881!20 12

    75,953!14 6,274,131!66 4!75" 24,835!10 13

    75,812!42 6,262,345!27 4!75" 24,788!45 14

    75,670!01 6,250,416!47 4!75" 24,741!23 15

    75,525!87 6,238,343!53 4!75" 24,693!44 16

    75,379!98 6,226,124!70 4!75" 24,645!08 17

    75,232!34 6,213,758!24 4!75" 24,596!13 18

    75,082!91 6,201,242!34 4!75" 24,546!58 19

    74,931!68 6,188,575!21 4!75" 24,496!44 20

    74,778!62 6,175,755!02 4!75" 24,445!70 21

    74,623!71 6,162,779!92 4!75" 24,394!34 22

    74,466!92 6,149,648!03 4!75" 24,342!36 23

    74,308!25 6,136,357!47 4!75" 24,289!75 2474,147!65 6,122,906!32 4!75" 24,236!50 25

    73,985!12 6,109,292!63 4!75" 24,182!62 26

    73,820!62 6,095,514!44 4!75" 24,128!08 27

    73,654!13 6,081,569!76 4!75" 24,072!88 28

    73,485!63 6,067,456!59 4!75" 24,017!02 29

    73,315!10 6,053,172!88 4!75" 23,960!48 30

    73,142!51 6,038,716!58 4!75" 23,903!25 31

    72,967!83 6,024,085!59 4!75" 23,845!34 32

    72,791!03 6,009,277!82 4!75" 23,786!72 33

    72,612!11 5,994,291!12 4!75" 23,727!40 34

    72,431!02 5,979,123!33 4!75" 23,667!36 35

    72,247!74 5,963,772!26 4!75" 23,606!60 36

    72,062!25 5,948,235!70 4!75" 23,545!10 37

    71,874!51 5,932,511!40 4!75" 23,482!86 38

    71,684!51 5,916,597!11 4!75" 23,419!86 3971,492!22 5,900,490!52 4!75" 23,356!11 40

    71,297!59 5,884,189!30 4!75" 23,291!58 41

    71,100!62 5,867,691!11 4!75" 23,226!28 42

    70,901!27 5,850,993!57 4!75" 23,160!18 43

    70,699!51 5,834,094!27 4!75" 23,093!29 44

    70,495!31 5,816,990!77 4!75" 23,025!59 45

    70,288!64 5,799,680!60 4!75" 22,957!07 46

    70,079!47 5,782,161!26 4!75" 22,887!72 47

    69,867!78 5,764,430!24 4!75" 22,817!54 48

    69,653!53 5,746,484!96 4!75" 22,746!50 49

    69,436!69 5,728,322!85 4!75" 22,674!61 50

    69,217!23 5,709,941!27 4!75" 22,601!85 51

    68,995!12 5,691,337!59 4!75" 22,528!21 52

    68,770!33 5,672,509!11 4!75" 22,453!68 53

    E#*$#B"+"#

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    9/76

    I#% M"$# NII ",# N!E#*$#B"+"#

    68,542!82 5,653,453!12 4!75" 22,378!25 54

    68,312!56 5,634,166!87 4!75" 22,301!91 55

    68,079!52 5,614,647!58 4!75" 22,224!65 56

    67,843!66 5,594,892!43 4!75" 22,146!45 57

    67,604!95 5,574,898!57 4!75" 22,067!31 58

    67,363!36 5,554,663!12 4!75" 21,987!21 59

    67,118!85 5,534,183!15 4!75" 21,906!14 60

    66,871!38 5,513,455!73 4!75" 21,824!10 61

    66,620!92 5,492,477!84 4!75" 21,741!06 6266,367!44 5,471,246!47 4!75" 21,657!02 63

    66,110!89 5,449,758!56 4!75" 21,571!96 64

    65,851!25 5,428,011!00 4!75" 21,485!88 65

    65,588!47 5,406,000!66 4!75" 21,398!75 66

    65,322!51 5,383,724!36 4!75" 21,310!58 67

    65,053!34 5,361,178!89 4!75" 21,221!33 68

    64,780!91 5,338,360!99 4!75" 21,131!01 69

    64,505!20 5,315,267!38 4!75" 21,039!60 70

    64,226!15 5,291,894!72 4!75" 20,947!08 71

    63,943!73 5,268,239!63 4!75" 20,853!45 72

    63,657!90 5,244,298!72 4!75" 20,758!68 73

    63,368!61 5,220,068!52 4!75" 20,662!77 74

    63,075!83 5,195,545!54 4!75" 20,565!70 75

    62,779!51 5,170,726!24 4!75" 20,467!46 76

    62,479!61 5,145,607!04 4!75" 20,368!03 77

    62,176!09 5,120,184!32 4!75" 20,267!40 78

    61,868!89 5,094,454!41 4!75" 20,165!55 79

    61,557!99 5,068,413!59 4!75" 20,062!47 80

    61,243!33 5,042,058!11 4!75" 19,958!15 81

    60,924!87 5,015,384!17 4!75" 19,852!56 82

    60,602!56 4,988,387!92 4!75" 19,745!70 83

    60,276!35 4,961,065!47 4!75" 19,637!55 84

    59,946!21 4,933,412!87 4!75" 19,528!09 85

    59,612!07 4,905,426!13 4!75" 19,417!31 86

    59,273!90 4,877,101!22 4!75" 19,305!19 87

    58,931!64 4,848,434!05 4!75" 19,191!72 88

    58,585!24 4,819,420!49 4!75" 19,076!87 89

    58,234!66 4,790,056!34 4!75" 18,960!64 90

    57,879!85 4,760,337!38 4!75" 18,843!00 9157,520!74 4,730,259!32 4!75" 18,723!94 92

    57,157!30 4,699,817!81 4!75" 18,603!45 93

    56,789!47 4,669,008!47 4!75" 18,481!49 94

    56,417!19 4,637,826!85 4!75" 18,358!06 95

    56,040!41 4,606,268!44 4!75" 18,233!15 96

    55,659!08 4,574,328!71 4!75" 18,106!72 97

    55,273!14 4,542,003!04 4!75" 17,978!76 98

    54,882!54 4,509,286!77 4!75" 17,849!26 99

    54,487!22 4,476,175!18 4!75" 17,718!19 100

    54,087!12 4,442,663!49 4!75" 17,585!54 101

    53,682!18 4,408,746!86 4!75" 17,451!29 102

    53,272!36 4,374,420!41 4!75" 17,315!41 103

    52,857!58 4,339,679!18 4!75" 17,177!90 104

    52,437!79 4,304,518!17 4!75" 17,038!72 105

    52,012!93 4,268,932!28 4!75" 16,897!86 10651,582!93 4,232,916!41 4!75" 16,755!29 107

    51,147!74 4,196,465!34 4!75" 16,611!01 108

    50,707!29 4,159,573!82 2,363,595!56

    50,261!52 4,122,236!53

    49,810!36 4,084,448!08

    49,353!75 4,046,203!02

    48,891!62 4,007,495!83

    48,423!91 3,968,320!93

    47,950!54 3,928,672!67

    47,471!46 3,888,545!32

    46,986!59 3,847,933!10

    46,495!86 3,806,830!15

    45,999!20 3,765,230!54

    45,496!54 3,723,128!27

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    10/76

    I#% M"$# NII ",# N!E#*$#B"+"#

    44,987!80 3,680,517!26

    44,472!92 3,637,391!37

    43,951!81 3,593,744!37

    43,424!41 3,549,569!97

    42,890!64 3,504,861!80

    42,350!41 3,459,613!41

    41,803!66 3,413,818!26

    41,250!30 3,367,469!76

    40,690!26 3,320,561!2140,123!45 3,273,085!85

    39,549!79 3,225,036!83

    38,969!19 3,176,407!21

    38,381!59 3,127,189!99

    37,786!88 3,077,378!06

    37,184!98 3,026,964!24

    36,575!82 2,975,941!25

    35,959!29 2,924,301!73

    35,335!31 2,872,038!23

    34,703!80 2,819,143!22

    34,064!65 2,765,609!06

    33,417!78 2,711,428!03

    32,763!09 2,656,592!31

    32,100!49 2,601,093!99

    31,429!89 2,544,925!07

    30,751!18 2,488,077!44

    30,064!27 2,430,542!90

    29,369!06 2,372,313!15

    28,665!45 2,313,379!79

    27,953!34 2,253,734!32

    27,232!62 2,193,368!14

    26,503!20 2,132,272!53

    25,764!96 2,070,438!68

    25,017!80 2,007,857!67

    24,261!61 1,944,520!48

    23,496!29 1,880,417!96

    22,721!72 1,815,540!87

    21,937!79 1,749,879!84

    21,144!38 1,683,425!4220,341!39 1,616,168!00

    19,528!70 1,548,097!89

    18,706!18 1,479,205!26

    17,873!73 1,409,480!18

    17,031!22 1,338,912!59

    16,178!53 1,267,492!31

    15,315!53 1,195,209!04

    14,442!11 1,122,052!34

    13,558!13 1,048,011!66

    12,663!47 973,076!33

    11,758!01 897,235!52

    10,841!60 820,478!31

    9,914!11 742,793!62

    8,975!42 664,170!23

    8,025!39 584,596!817,063!88 504,061!88

    6,090!75 422,553!82

    5,105!86 340,060!87

    4,109!07 256,571!13

    3,100!23 172,072!56

    2,079!21 86,552!96

    1,045!85 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/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    11/76

    I#% M"$# NII ",# N!E#*$#B"+"#

    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 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!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 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 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

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    12/76

    I#% M"$# NII ",# N!E#*$#B"+"#

    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 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!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 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 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

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    13/76

    I#% M"$# NII ",# N!E#*$#B"+"#

    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 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!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

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    14/76

    L!"# C"+'+"! 

    E# V"+'% L!"# S'",

    .oa /o$t 9,529,975!54 ce%$e% Paet

     /$a Iterest Rate 16!85 " ce%$e% *$er of Paets

    .oa Per&o% & -ears 15 /ct$a *$er of Paets

    *$er of Paets Per -ear 12 Tota ar Paets

    tart :ate of .oa 1;1;2006 Tota Iterest

    t&oa tra Paets

    L#* N"

    $#$"+

    1 2;1;2006 < 9,529,975!54 < 145,654!81 < < 145,654!81 < 11,838!07

    2 3;1;2006 9,518,137!47 145,654!81 145,654!81 12,004!29

    3 4;1;2006 9,506,133!18 145,654!81 145,654!81 12,172!85

    4 5;1;2006 9,493,960!33 145,654!81 145,654!81 12,343!78

    5 6;1;2006 9,481,616!55 145,654!81 145,654!81 12,517!11

    6 7;1;2006 9,469,099!44 145,654!81 145,654!81 12,692!87

    7 8;1;2006 9,456,406!57 145,654!81 145,654!81 12,871!10

    8 9;1;2006 9,443,535!48 145,654!81 145,654!81 13,051!83

    9 10;1;2006 9,430,483!65 145,654!81 145,654!81 13,235!10

    10 11;1;2006 9,417,248!55 145,654!81 145,654!81 13,420!9411 12;1;2006 9,403,827!61 145,654!81 145,654!81 13,609!39

    12 1;1;2007 9,390,218!22 145,654!81 145,654!81 13,800!49

    13 2;1;2007 9,376,417!73 145,654!81 145,654!81 13,994!27

    14 3;1;2007 9,362,423!45 145,654!81 145,654!81 14,190!78

    15 4;1;2007 9,348,232!68 145,654!81 145,654!81 14,390!04

    16 5;1;2007 9,333,842!64 145,654!81 145,654!81 14,592!10

    17 6;1;2007 9,319,250!54 145,654!81 145,654!81 14,797!00

    18 7;1;2007 9,304,453!54 145,654!81 145,654!81 15,004!77

    19 8;1;2007 9,289,448!77 145,654!81 145,654!81 15,215!46

    20 9;1;2007 9,274,233!31 145,654!81 145,654!81 15,429!11

    21 10;1;2007 9,258,804!20 145,654!81 145,654!81 15,645!76

    22 11;1;2007 9,243,158!44 145,654!81 145,654!81 15,865!46

    23 12;1;2007 9,227,292!98 145,654!81 145,654!81 16,088!23

    24 1;1;2008 9,211,204!75 145,654!81 145,654!81 16,314!14

    25 2;1;2008 9,194,890!61 145,654!81 145,654!81 16,543!22

    26 3;1;2008 9,178,347!39 145,654!81 145,654!81 16,775!51

    27 4;1;2008 9,161,571!88 145,654!81 145,654!81 17,011!07

    28 5;1;2008 9,144,560!81 145,654!81 145,654!81 17,249!93

    29 6;1;2008 9,127,310!88 145,654!81 145,654!81 17,492!15

    30 7;1;2008 9,109,818!73 145,654!81 145,654!81 17,737!77

    31 8;1;2008 9,092,080!97 145,654!81 145,654!81 17,986!84

    32 9;1;2008 9,074,094!13 145,654!81 145,654!81 18,239!40

    33 10;1;2008 9,055,854!73 145,654!81 145,654!81 18,495!51

    34 11;1;2008 9,037,359!22 145,654!81 145,654!81 18,755!22

    35 12;1;2008 9,018,604!00 145,654!81 145,654!81 19,018!57

    36 1;1;2009 8,999,585!42 145,654!81 145,654!81 19,285!63

    37 2;1;2009 8,980,299!80 145,654!81 145,654!81 19,556!43

    38 3;1;2009 8,960,743!37 145,654!81 145,654!81 19,831!03

    39 4;1;2009 8,940,912!33 145,654!81 145,654!81 20,109!4940 5;1;2009 8,920,802!84 145,654!81 145,654!81 20,391!87

    41 6;1;2009 8,900,410!97 145,654!81 145,654!81 20,678!20

    42 7;1;2009 8,879,732!77 145,654!81 145,654!81 20,968!56

    43 8;1;2009 8,858,764!21 145,654!81 145,654!81 21,262!99

    44 9;1;2009 8,837,501!22 145,654!81 145,654!81 21,561!56

    45 10;1;2009 8,815,939!66 145,654!81 145,654!81 21,864!32

    46 11;1;2009 8,794,075!34 145,654!81 145,654!81 22,171!33

    47 12;1;2009 8,771,904!01 145,654!81 145,654!81 22,482!65

    48 1;1;2010 8,749,421!36 145,654!81 145,654!81 22,798!35

    49 2;1;2010 8,726,623!01 145,654!81 145,654!81 23,118!47

    50 3;1;2010 8,703,504!54 145,654!81 145,654!81 23,443!10

    51 4;1;2010 8,680,061!44 145,654!81 145,654!81 23,772!28

    52 5;1;2010 8,656,289!17 145,654!81 145,654!81 24,106!08

    53 6;1;2010 8,632,183!09 145,654!81 145,654!81 24,444!57

    N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    15/76

    $#$"+N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    54 7;1;2010 8,607,738!52 145,654!81 145,654!81 24,787!81

    55 8;1;2010 8,582,950!71 145,654!81 145,654!81 25,135!87

    56 9;1;2010 8,557,814!84 145,654!81 145,654!81 25,488!82

    57 10;1;2010 8,532,326!01 145,654!81 145,654!81 25,846!73

    58 11;1;2010 8,506,479!29 145,654!81 145,654!81 26,209!66

    59 12;1;2010 8,480,269!63 145,654!81 145,654!81 26,577!69

    60 1;1;2011 8,453,691!94 145,654!81 145,654!81 26,950!88

    61 2;1;2011 8,426,741!06 145,654!81 145,654!81 27,329!32

    62 3;1;2011 8,399,411!74 145,654!81 145,654!81 27,713!0763 4;1;2011 8,371,698!68 145,654!81 145,654!81 28,102!20

    64 5;1;2011 8,343,596!47 145,654!81 145,654!81 28,496!81

    65 6;1;2011 8,315,099!67 145,654!81 145,654!81 28,896!95

    66 7;1;2011 8,286,202!72 145,654!81 145,654!81 29,302!71

    67 8;1;2011 8,256,900!01 145,654!81 145,654!81 29,714!17

    68 9;1;2011 8,227,185!84 145,654!81 145,654!81 30,131!40

    69 10;1;2011 8,197,054!44 145,654!81 145,654!81 30,554!50

    70 11;1;2011 8,166,499!94 145,654!81 145,654!81 30,983!54

    71 12;1;2011 8,135,516!40 145,654!81 145,654!81 31,418!60

    72 1;1;2012 8,104,097!81 145,654!81 145,654!81 31,859!77

    73 2;1;2012 8,072,238!04 145,654!81 145,654!81 32,307!13

    74 3;1;2012 8,039,930!91 145,654!81 145,654!81 32,760!78

    75 4;1;2012 8,007,170!14 145,654!81 145,654!81 33,220!79

    76 5;1;2012 7,973,949!35 145,654!81 145,654!81 33,687!27

    77 6;1;2012 7,940,262!08 145,654!81 145,654!81 34,160!29

    78 7;1;2012 7,906,101!79 145,654!81 145,654!81 34,639!96

    79 8;1;2012 7,871,461!83 145,654!81 145,654!81 35,126!36

    80 9;1;2012 7,836,335!47 145,654!81 145,654!81 35,619!60

    81 10;1;2012 7,800,715!87 145,654!81 145,654!81 36,119!75

    82 11;1;2012 7,764,596!12 145,654!81 145,654!81 36,626!94

    83 12;1;2012 7,727,969!18 145,654!81 145,654!81 37,141!24

    84 1;1;2013 7,690,827!94 145,654!81 145,654!81 37,662!76

    85 2;1;2013 7,653,165!18 145,654!81 145,654!81 38,191!61

    86 3;1;2013 7,614,973!57 145,654!81 145,654!81 38,727!89

    87 4;1;2013 7,576,245!68 145,654!81 145,654!81 39,271!69

    88 5;1;2013 7,536,973!99 145,654!81 145,654!81 39,823!13

    89 6;1;2013 7,497,150!87 145,654!81 145,654!81 40,382!31

    90 7;1;2013 7,456,768!55 145,654!81 145,654!81 40,949!35

    91 8;1;2013 7,415,819!21 145,654!81 145,654!81 41,524!3492 9;1;2013 7,374,294!86 145,654!81 145,654!81 42,107!42

    93 10;1;2013 7,332,187!45 145,654!81 145,654!81 42,698!67

    94 11;1;2013 7,289,488!77 145,654!81 145,654!81 43,298!23

    95 12;1;2013 7,246,190!54 145,654!81 145,654!81 43,906!21

    96 1;1;2014 7,202,284!33 145,654!81 145,654!81 44,522!73

    97 2;1;2014 7,157,761!60 145,654!81 145,654!81 45,147!90

    98 3;1;2014 7,112,613!69 145,654!81 145,654!81 45,781!85

    99 4;1;2014 7,066,831!84 145,654!81 145,654!81 46,424!71

    100 5;1;2014 7,020,407!13 145,654!81 145,654!81 47,076!59

    101 6;1;2014 6,973,330!54 145,654!81 145,654!81 47,737!62

    102 7;1;2014 6,925,592!92 145,654!81 145,654!81 48,407!94

    103 8;1;2014 6,877,184!98 145,654!81 145,654!81 49,087!67

    104 9;1;2014 6,828,097!31 145,654!81 145,654!81 49,776!94

    105 10;1;2014 6,778,320!37 145,654!81 145,654!81 50,475!89

    106 11;1;2014 6,727,844!48 145,654!81 145,654!81 51,184!66107 12;1;2014 6,676,659!83 145,654!81 145,654!81 51,903!37

    108 1;1;2015 6,624,756!45 145,654!81 145,654!81 52,632!18

    109 2;1;2015 6,572,124!27 145,654!81 145,654!81 53,371!23

    110 3;1;2015 6,518,753!04 145,654!81 145,654!81 54,120!65

    111 4;1;2015 6,464,632!39 145,654!81 145,654!81 54,880!59

    112 5;1;2015 6,409,751!80 145,654!81 145,654!81 55,651!21

    113 6;1;2015 6,354,100!60 145,654!81 145,654!81 56,432!64

    114 7;1;2015 6,297,667!95 145,654!81 145,654!81 57,225!05

    115 8;1;2015 6,240,442!90 145,654!81 145,654!81 58,028!59

    116 9;1;2015 6,182,414!31 145,654!81 145,654!81 58,843!40

    117 10;1;2015 6,123,570!91 145,654!81 145,654!81 59,669!66

    118 11;1;2015 6,063,901!25 145,654!81 145,654!81 60,507!53

    119 12;1;2015 6,003,393!72 145,654!81 145,654!81 61,357!15

    120 1;1;2016 5,942,036!57 145,654!81 145,654!81 62,218!71

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    16/76

    $#$"+N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    121 2;1;2016 5,879,817!86 145,654!81 145,654!81 63,092!36

    122 3;1;2016 5,816,725!50 145,654!81 145,654!81 63,978!29

    123 4;1;2016 5,752,747!21 145,654!81 145,654!81 64,876!65

    124 5;1;2016 5,687,870!56 145,654!81 145,654!81 65,787!62

    125 6;1;2016 5,622,082!94 145,654!81 145,654!81 66,711!39

    126 7;1;2016 5,555,371!55 145,654!81 145,654!81 67,648!13

    127 8;1;2016 5,487,723!42 145,654!81 145,654!81 68,598!02

    128 9;1;2016 5,419,125!40 145,654!81 145,654!81 69,561!25

    129 10;1;2016 5,349,564!14 145,654!81 145,654!81 70,538!01130 11;1;2016 5,279,026!14 145,654!81 145,654!81 71,528!48

    131 12;1;2016 5,207,497!66 145,654!81 145,654!81 72,532!86

    132 1;1;2017 5,134,964!80 145,654!81 145,654!81 73,551!34

    133 2;1;2017 5,061,413!45 145,654!81 145,654!81 74,584!12

    134 3;1;2017 4,986,829!33 145,654!81 145,654!81 75,631!41

    135 4;1;2017 4,911,197!92 145,654!81 145,654!81 76,693!40

    136 5;1;2017 4,834,504!52 145,654!81 145,654!81 77,770!30

    137 6;1;2017 4,756,734!21 145,654!81 145,654!81 78,862!33

    138 7;1;2017 4,677,871!88 145,654!81 145,654!81 79,969!69

    139 8;1;2017 4,597,902!20 145,654!81 145,654!81 81,092!60

    140 9;1;2017 4,516,809!60 145,654!81 145,654!81 82,231!27

    141 10;1;2017 4,434,578!33 145,654!81 145,654!81 83,385!93

    142 11;1;2017 4,351,192!39 145,654!81 145,654!81 84,556!81

    143 12;1;2017 4,266,635!58 145,654!81 145,654!81 85,744!13

    144 1;1;2018 4,180,891!45 145,654!81 145,654!81 86,948!12

    145 2;1;2018 4,093,943!33 145,654!81 145,654!81 88,169!02

    146 3;1;2018 4,005,774!31 145,654!81 145,654!81 89,407!06

    147 4;1;2018 3,916,367!25 145,654!81 145,654!81 90,662!48

    148 5;1;2018 3,825,704!77 145,654!81 145,654!81 91,935!53

    149 6;1;2018 3,733,769!24 145,654!81 145,654!81 93,226!46

    150 7;1;2018 3,640,542!78 145,654!81 145,654!81 94,535!52

    151 8;1;2018 3,546,007!26 145,654!81 145,654!81 95,862!95

    152 9;1;2018 3,450,144!30 145,654!81 145,654!81 97,209!03

    153 10;1;2018 3,352,935!27 145,654!81 145,654!81 98,574!01

    154 11;1;2018 3,254,361!27 145,654!81 145,654!81 99,958!15

    155 12;1;2018 3,154,403!12 145,654!81 145,654!81 101,361!73

    156 1;1;2019 3,053,041!39 145,654!81 145,654!81 102,785!02

    157 2;1;2019 2,950,256!37 145,654!81 145,654!81 104,228!29

    158 3;1;2019 2,846,028!09 145,654!81 145,654!81 105,691!83159 4;1;2019 2,740,336!26 145,654!81 145,654!81 107,175!92

    160 5;1;2019 2,633,160!34 145,654!81 145,654!81 108,680!85

    161 6;1;2019 2,524,479!49 145,654!81 145,654!81 110,206!91

    162 7;1;2019 2,414,272!59 145,654!81 145,654!81 111,754!39

    163 8;1;2019 2,302,518!19 145,654!81 145,654!81 113,323!61

    164 9;1;2019 2,189,194!58 145,654!81 145,654!81 114,914!86

    165 10;1;2019 2,074,279!72 145,654!81 145,654!81 116,528!46

    166 11;1;2019 1,957,751!26 145,654!81 145,654!81 118,164!72

    167 12;1;2019 1,839,586!54 145,654!81 145,654!81 119,823!94

    168 1;1;2020 1,719,762!60 145,654!81 145,654!81 121,506!47

    169 2;1;2020 1,598,256!12 145,654!81 145,654!81 123,212!63

    170 3;1;2020 1,475,043!50 145,654!81 145,654!81 124,942!74

    171 4;1;2020 1,350,100!76 145,654!81 145,654!81 126,697!14

    172 5;1;2020 1,223,403!62 145,654!81 145,654!81 128,476!18

    173 6;1;2020 1,094,927!44 145,654!81 145,654!81 130,280!20174 7;1;2020 964,647!24 145,654!81 145,654!81 132,109!55

    175 8;1;2020 832,537!69 145,654!81 145,654!81 133,964!59

    176 9;1;2020 698,573!10 145,654!81 145,654!81 135,845!67

    177 10;1;2020 562,727!43 145,654!81 145,654!81 137,753!17

    178 11;1;2020 424,974!25 145,654!81 145,654!81 139,687!46

    179 12;1;2020 285,286!79 145,654!81 145,654!81 141,648!90

    180 1;1;2021 143,637!89 145,654!81 143,637!89 141,620!97

    181 2;1;2021 0!00 145,654!81 0!00 0!00

    182 3;1;2021 0!00 145,654!81 0!00 0!00

    183 4;1;2021 0!00 145,654!81 0!00 0!00

    184 5;1;2021 0!00 145,654!81 0!00 0!00

    185 6;1;2021 0!00 145,654!81 0!00 0!00

    186 7;1;2021 0!00 145,654!81 0!00 0!00

    187 8;1;2021 0!00 145,654!81 0!00 0!00

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    17/76

    $#$"+N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    188 9;1;2021 0!00 145,654!81 0!00 0!00

    189 10;1;2021 0!00 145,654!81 0!00 0!00

    190 11;1;2021 0!00 145,654!81 0!00 0!00

    191 12;1;2021 0!00 145,654!81 0!00 0!00

    192 1;1;2022 0!00 145,654!81 0!00 0!00

    193 2;1;2022 0!00 145,654!81 0!00 0!00

    194 3;1;2022 0!00 145,654!81 0!00 0!00

    195 4;1;2022 0!00 145,654!81 0!00 0!00

    196 5;1;2022 0!00 145,654!81 0!00 0!00197 6;1;2022 0!00 145,654!81 0!00 0!00

    198 7;1;2022 0!00 145,654!81 0!00 0!00

    199 8;1;2022 0!00 145,654!81 0!00 0!00

    200 9;1;2022 0!00 145,654!81 0!00 0!00

    201 10;1;2022 0!00 145,654!81 0!00 0!00

    202 11;1;2022 0!00 145,654!81 0!00 0!00

    203 12;1;2022 0!00 145,654!81 0!00 0!00

    204 1;1;2023 0!00 145,654!81 0!00 0!00

    205 2;1;2023 0!00 145,654!81 0!00 0!00

    206 3;1;2023 0!00 145,654!81 0!00 0!00

    207 4;1;2023 0!00 145,654!81 0!00 0!00

    208 5;1;2023 0!00 145,654!81 0!00 0!00

    209 6;1;2023 0!00 145,654!81 0!00 0!00

    210 7;1;2023 0!00 145,654!81 0!00 0!00

    211 8;1;2023 0!00 145,654!81 0!00 0!00

    212 9;1;2023 0!00 145,654!81 0!00 0!00

    213 10;1;2023 0!00 145,654!81 0!00 0!00

    214 11;1;2023 0!00 145,654!81 0!00 0!00

    215 12;1;2023 0!00 145,654!81 0!00 0!00

    216 1;1;2024 0!00 145,654!81 0!00 0!00

    217 2;1;2024 0!00 145,654!81 0!00 0!00

    218 3;1;2024 0!00 145,654!81 0!00 0!00

    219 4;1;2024 0!00 145,654!81 0!00 0!00

    220 5;1;2024 0!00 145,654!81 0!00 0!00

    221 6;1;2024 0!00 145,654!81 0!00 0!00

    222 7;1;2024 0!00 145,654!81 0!00 0!00

    223 8;1;2024 0!00 145,654!81 0!00 0!00

    224 9;1;2024 0!00 145,654!81 0!00 0!00

    225 10;1;2024 0!00 145,654!81 0!00 0!00226 11;1;2024 0!00 145,654!81 0!00 0!00

    227 12;1;2024 0!00 145,654!81 0!00 0!00

    228 1;1;2025 0!00 145,654!81 0!00 0!00

    229 2;1;2025 0!00 145,654!81 0!00 0!00

    230 3;1;2025 0!00 145,654!81 0!00 0!00

    231 4;1;2025 0!00 145,654!81 0!00 0!00

    232 5;1;2025 0!00 145,654!81 0!00 0!00

    233 6;1;2025 0!00 145,654!81 0!00 0!00

    234 7;1;2025 0!00 145,654!81 0!00 0!00

    235 8;1;2025 0!00 145,654!81 0!00 0!00

    236 9;1;2025 0!00 145,654!81 0!00 0!00

    237 10;1;2025 0!00 145,654!81 0!00 0!00

    238 11;1;2025 0!00 145,654!81 0!00 0!00

    239 12;1;2025 0!00 145,654!81 0!00 0!00

    240 1;1;2026 0!00 145,654!81 0!00 0!00241 2;1;2026 0!00 145,654!81 0!00 0!00

    242 3;1;2026 0!00 145,654!81 0!00 0!00

    243 4;1;2026 0!00 145,654!81 0!00 0!00

    244 5;1;2026 0!00 145,654!81 0!00 0!00

    245 6;1;2026 0!00 145,654!81 0!00 0!00

    246 7;1;2026 0!00 145,654!81 0!00 0!00

    247 8;1;2026 0!00 145,654!81 0!00 0!00

    248 9;1;2026 0!00 145,654!81 0!00 0!00

    249 10;1;2026 0!00 145,654!81 0!00 0!00

    250 11;1;2026 0!00 145,654!81 0!00 0!00

    251 12;1;2026 0!00 145,654!81 0!00 0!00

    252 1;1;2027 0!00 145,654!81 0!00 0!00

    253 2;1;2027 0!00 145,654!81 0!00 0!00

    254 3;1;2027 0!00 145,654!81 0!00 0!00

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    18/76

    $#$"+N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    255 4;1;2027 0!00 145,654!81 0!00 0!00

    256 5;1;2027 0!00 145,654!81 0!00 0!00

    257 6;1;2027 0!00 145,654!81 0!00 0!00

    258 7;1;2027 0!00 145,654!81 0!00 0!00

    259 8;1;2027 0!00 145,654!81 0!00 0!00

    260 9;1;2027 0!00 145,654!81 0!00 0!00

    261 10;1;2027 0!00 145,654!81 0!00 0!00

    262 11;1;2027 0!00 145,654!81 0!00 0!00

    263 12;1;2027 0!00 145,654!81 0!00 0!00264 1;1;2028 0!00 145,654!81 0!00 0!00

    265 2;1;2028 0!00 145,654!81 0!00 0!00

    266 3;1;2028 0!00 145,654!81 0!00 0!00

    267 4;1;2028 0!00 145,654!81 0!00 0!00

    268 5;1;2028 0!00 145,654!81 0!00 0!00

    269 6;1;2028 0!00 145,654!81 0!00 0!00

    270 7;1;2028 0!00 145,654!81 0!00 0!00

    271 8;1;2028 0!00 145,654!81 0!00 0!00

    272 9;1;2028 0!00 145,654!81 0!00 0!00

    273 10;1;2028 0!00 145,654!81 0!00 0!00

    274 11;1;2028 0!00 145,654!81 0!00 0!00

    275 12;1;2028 0!00 145,654!81 0!00 0!00

    276 1;1;2029 0!00 145,654!81 0!00 0!00

    277 2;1;2029 0!00 145,654!81 0!00 0!00

    278 3;1;2029 0!00 145,654!81 0!00 0!00

    279 4;1;2029 0!00 145,654!81 0!00 0!00

    280 5;1;2029 0!00 145,654!81 0!00 0!00

    281 6;1;2029 0!00 145,654!81 0!00 0!00

    282 7;1;2029 0!00 145,654!81 0!00 0!00

    283 8;1;2029 0!00 145,654!81 0!00 0!00

    284 9;1;2029 0!00 145,654!81 0!00 0!00

    285 10;1;2029 0!00 145,654!81 0!00 0!00

    286 11;1;2029 0!00 145,654!81 0!00 0!00

    287 12;1;2029 0!00 145,654!81 0!00 0!00

    288 1;1;2030 0!00 145,654!81 0!00 0!00

    289 2;1;2030 0!00 145,654!81 0!00 0!00

    290 3;1;2030 0!00 145,654!81 0!00 0!00

    291 4;1;2030 0!00 145,654!81 0!00 0!00

    292 5;1;2030 0!00 145,654!81 0!00 0!00293 6;1;2030 0!00 145,654!81 0!00 0!00

    294 7;1;2030 0!00 145,654!81 0!00 0!00

    295 8;1;2030 0!00 145,654!81 0!00 0!00

    296 9;1;2030 0!00 145,654!81 0!00 0!00

    297 10;1;2030 0!00 145,654!81 0!00 0!00

    298 11;1;2030 0!00 145,654!81 0!00 0!00

    299 12;1;2030 0!00 145,654!81 0!00 0!00

    300 1;1;2031 0!00 145,654!81 0!00 0!00

    301 2;1;2031 0!00 145,654!81 0!00 0!00

    302 3;1;2031 0!00 145,654!81 0!00 0!00

    303 4;1;2031 0!00 145,654!81 0!00 0!00

    304 5;1;2031 0!00 145,654!81 0!00 0!00

    305 6;1;2031 0!00 145,654!81 0!00 0!00

    306 7;1;2031 0!00 145,654!81 0!00 0!00

    307 8;1;2031 0!00 145,654!81 0!00 0!00308 9;1;2031 0!00 145,654!81 0!00 0!00

    309 10;1;2031 0!00 145,654!81 0!00 0!00

    310 11;1;2031 0!00 145,654!81 0!00 0!00

    311 12;1;2031 0!00 145,654!81 0!00 0!00

    312 1;1;2032 0!00 145,654!81 0!00 0!00

    313 2;1;2032 0!00 145,654!81 0!00 0!00

    314 3;1;2032 0!00 145,654!81 0!00 0!00

    315 4;1;2032 0!00 145,654!81 0!00 0!00

    316 5;1;2032 0!00 145,654!81 0!00 0!00

    317 6;1;2032 0!00 145,654!81 0!00 0!00

    318 7;1;2032 0!00 145,654!81 0!00 0!00

    319 8;1;2032 0!00 145,654!81 0!00 0!00

    320 9;1;2032 0!00 145,654!81 0!00 0!00

    321 10;1;2032 0!00 145,654!81 0!00 0!00

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    19/76

    $#$"+N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    322 11;1;2032 0!00 145,654!81 0!00 0!00

    323 12;1;2032 0!00 145,654!81 0!00 0!00

    324 1;1;2033 0!00 145,654!81 0!00 0!00

    325 2;1;2033 0!00 145,654!81 0!00 0!00

    326 3;1;2033 0!00 145,654!81 0!00 0!00

    327 4;1;2033 0!00 145,654!81 0!00 0!00

    328 5;1;2033 0!00 145,654!81 0!00 0!00

    329 6;1;2033 0!00 145,654!81 0!00 0!00

    330 7;1;2033 0!00 145,654!81 0!00 0!00331 8;1;2033 0!00 145,654!81 0!00 0!00

    332 9;1;2033 0!00 145,654!81 0!00 0!00

    333 10;1;2033 0!00 145,654!81 0!00 0!00

    334 11;1;2033 0!00 145,654!81 0!00 0!00

    335 12;1;2033 0!00 145,654!81 0!00 0!00

    336 1;1;2034 0!00 145,654!81 0!00 0!00

    337 2;1;2034 0!00 145,654!81 0!00 0!00

    338 3;1;2034 0!00 145,654!81 0!00 0!00

    339 4;1;2034 0!00 145,654!81 0!00 0!00

    340 5;1;2034 0!00 145,654!81 0!00 0!00

    341 6;1;2034 0!00 145,654!81 0!00 0!00

    342 7;1;2034 0!00 145,654!81 0!00 0!00

    343 8;1;2034 0!00 145,654!81 0!00 0!00

    344 9;1;2034 0!00 145,654!81 0!00 0!00

    345 10;1;2034 0!00 145,654!81 0!00 0!00

    346 11;1;2034 0!00 145,654!81 0!00 0!00

    347 12;1;2034 0!00 145,654!81 0!00 0!00

    348 1;1;2035 0!00 145,654!81 0!00 0!00

    349 2;1;2035 0!00 145,654!81 0!00 0!00

    350 3;1;2035 0!00 145,654!81 0!00 0!00

    351 4;1;2035 0!00 145,654!81 0!00 0!00

    352 5;1;2035 0!00 145,654!81 0!00 0!00

    353 6;1;2035 0!00 145,654!81 0!00 0!00

    354 7;1;2035 0!00 145,654!81 0!00 0!00

    355 8;1;2035 0!00 145,654!81 0!00 0!00

    356 9;1;2035 0!00 145,654!81 0!00 0!00

    357 10;1;2035 0!00 145,654!81 0!00 0!00

    358 11;1;2035 0!00 145,654!81 0!00 0!00

    359 12;1;2035 0!00 145,654!81 0!00 0!00360 1;1;2036 0!00 145,654!81 0!00 0!00

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    20/76

     

    < 145,654!81

    180

    180

    <

    < 16,687,889!46

    I#% E#*$# B"+"# M"$# NII ",# N!

     < 133,816!74 < 9,518,137!47 4!75" 37,675!96 1

    133,650!51 9,506,133!18 4!75" 37,628!44 2

    133,481!95 9,493,960!33 4!75" 37,580!26 3

    133,311!03 9,481,616!55 4!75" 37,531!40 4

    133,137!70 9,469,099!44 4!75" 37,481!85 5

    132,961!94 9,456,406!57 4!75" 37,431!61 6

    132,783!71 9,443,535!48 4!75" 37,380!66 7

    132,602!98 9,430,483!65 4!75" 37,329!00 8

    132,419!71 9,417,248!55 4!75" 37,276!61 9

    132,233!87 9,403,827!61 4!75" 37,223!48 10132,045!41 9,390,218!22 4!75" 37,169!61 11

    131,854!31 9,376,417!73 4!75" 37,114!99 12

    131,660!53 9,362,423!45 4!75" 37,059!59 13

    131,464!03 9,348,232!68 4!75" 37,003!42 14

    131,264!77 9,333,842!64 4!75" 36,946!46 15

    131,062!71 9,319,250!54 4!75" 36,888!70 16

    130,857!81 9,304,453!54 4!75" 36,830!13 17

    130,650!04 9,289,448!77 4!75" 36,770!73 18

    130,439!34 9,274,233!31 4!75" 36,710!51 19

    130,225!69 9,258,804!20 4!75" 36,649!43 20

    130,009!04 9,243,158!44 4!75" 36,587!50 21

    129,789!35 9,227,292!98 4!75" 36,524!70 22

    129,566!57 9,211,204!75 4!75" 36,461!02 23

    129,340!67 9,194,890!61 4!75" 36,396!44 24

    129,111!59 9,178,347!39 4!75" 36,330!96 25

    128,879!29 9,161,571!88 4!75" 36,264!56 26

    128,643!74 9,144,560!81 4!75" 36,197!22 27

    128,404!87 9,127,310!88 4!75" 36,128!94 28

    128,162!66 9,109,818!73 4!75" 36,059!70 29

    127,917!04 9,092,080!97 4!75" 35,989!49 30

    127,667!97 9,074,094!13 4!75" 35,918!29 31

    127,415!41 9,055,854!73 4!75" 35,846!09 32

    127,159!29 9,037,359!22 4!75" 35,772!88 33

    126,899!59 9,018,604!00 4!75" 35,698!64 34

    126,636!23 8,999,585!42 4!75" 35,623!36 35

    126,369!18 8,980,299!80 4!75" 35,547!02 36

    126,098!38 8,960,743!37 4!75" 35,469!61 37

    125,823!77 8,940,912!33 4!75" 35,391!11 38

    125,545!31 8,920,802!84 4!75" 35,311!51 39125,262!94 8,900,410!97 4!75" 35,230!79 40

    124,976!60 8,879,732!77 4!75" 35,148!94 41

    124,686!25 8,858,764!21 4!75" 35,065!94 42

    124,391!81 8,837,501!22 4!75" 34,981!78 43

    124,093!25 8,815,939!66 4!75" 34,896!43 44

    123,790!49 8,794,075!34 4!75" 34,809!88 45

    123,483!47 8,771,904!01 4!75" 34,722!12 46

    123,172!15 8,749,421!36 4!75" 34,633!13 47

    122,856!46 8,726,623!01 4!75" 34,542!88 48

    122,536!33 8,703,504!54 4!75" 34,451!37 49

    122,211!71 8,680,061!44 4!75" 34,358!58 50

    121,882!53 8,656,289!17 4!75" 34,264!48 51

    121,548!73 8,632,183!09 4!75" 34,169!06 52

    121,210!24 8,607,738!52 4!75" 34,072!30 53

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    21/76

    I#% E#*$# B"+"# M"$# NII ",# N!

    120,867!00 8,582,950!71 4!75" 33,974!18 54

    120,518!93 8,557,814!84 4!75" 33,874!68 55

    120,165!98 8,532,326!01 4!75" 33,773!79 56

    119,808!08 8,506,479!29 4!75" 33,671!48 57

    119,445!15 8,480,269!63 4!75" 33,567!73 58

    119,077!12 8,453,691!94 4!75" 33,462!53 59

    118,703!92 8,426,741!06 4!75" 33,355!85 60

    118,325!49 8,399,411!74 4!75" 33,247!67 61

    117,941!74 8,371,698!68 4!75" 33,137!97 62117,552!60 8,343,596!47 4!75" 33,026!74 63

    117,158!00 8,315,099!67 4!75" 32,913!94 64

    116,757!86 8,286,202!72 4!75" 32,799!55 65

    116,352!10 8,256,900!01 4!75" 32,683!56 66

    115,940!64 8,227,185!84 4!75" 32,565!94 67

    115,523!40 8,197,054!44 4!75" 32,446!67 68

    115,100!31 8,166,499!94 4!75" 32,325!73 69

    114,671!27 8,135,516!40 4!75" 32,203!09 70

    114,236!21 8,104,097!81 4!75" 32,078!72 71

    113,795!04 8,072,238!04 4!75" 31,952!61 72

    113,347!68 8,039,930!91 4!75" 31,824!73 73

    112,894!03 8,007,170!14 4!75" 31,695!05 74

    112,434!01 7,973,949!35 4!75" 31,563!55 75

    111,967!54 7,940,262!08 4!75" 31,430!20 76

    111,494!51 7,906,101!79 4!75" 31,294!99 77

    111,014!85 7,871,461!83 4!75" 31,157!87 78

    110,528!44 7,836,335!47 4!75" 31,018!83 79

    110,035!21 7,800,715!87 4!75" 30,877!83 80

    109,535!05 7,764,596!12 4!75" 30,734!86 81

    109,027!87 7,727,969!18 4!75" 30,589!88 82

    108,513!57 7,690,827!94 4!75" 30,442!86 83

    107,992!04 7,653,165!18 4!75" 30,293!78 84

    107,463!19 7,614,973!57 4!75" 30,142!60 85

    106,926!92 7,576,245!68 4!75" 29,989!31 86

    106,383!12 7,536,973!99 4!75" 29,833!86 87

    105,831!68 7,497,150!87 4!75" 29,676!22 88

    105,272!49 7,456,768!55 4!75" 29,516!38 89

    104,705!46 7,415,819!21 4!75" 29,354!28 90

    104,130!46 7,374,294!86 4!75" 29,189!92 91103,547!39 7,332,187!45 4!75" 29,023!24 92

    102,956!13 7,289,488!77 4!75" 28,854!23 93

    102,356!57 7,246,190!54 4!75" 28,682!84 94

    101,748!59 7,202,284!33 4!75" 28,509!04 95

    101,132!08 7,157,761!60 4!75" 28,332!81 96

    100,506!90 7,112,613!69 4!75" 28,154!10 97

    99,872!95 7,066,831!84 4!75" 27,972!88 98

    99,230!10 7,020,407!13 4!75" 27,789!11 99

    98,578!22 6,973,330!54 4!75" 27,602!77 100

    97,917!18 6,925,592!92 4!75" 27,413!81 101

    97,246!87 6,877,184!98 4!75" 27,222!19 102

    96,567!14 6,828,097!31 4!75" 27,027!89 103

    95,877!87 6,778,320!37 4!75" 26,830!85 104

    95,178!92 6,727,844!48 4!75" 26,631!05 105

    94,470!15 6,676,659!83 4!75" 26,428!45 10693,751!43 6,624,756!45 4!75" 26,222!99 107

    93,022!62 6,572,124!27 4!75" 26,014!66 108

    92,283!58 6,518,753!04

    91,534!16 6,464,632!39

    90,774!21 6,409,751!80

    90,003!60 6,354,100!60

    89,222!16 6,297,667!95

    88,429!75 6,240,442!90

    87,626!22 6,182,414!31

    86,811!40 6,123,570!91

    85,985!14 6,063,901!25

    85,147!28 6,003,393!72

    84,297!65 5,942,036!57

    83,436!10 5,879,817!86

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    22/76

    I#% E#*$# B"+"# M"$# NII ",# N!

    82,562!44 5,816,725!50

    81,676!52 5,752,747!21

    80,778!16 5,687,870!56

    79,867!18 5,622,082!94

    78,943!41 5,555,371!55

    78,006!68 5,487,723!42

    77,056!78 5,419,125!40

    76,093!55 5,349,564!14

    75,116!80 5,279,026!1474,126!33 5,207,497!66

    73,121!95 5,134,964!80

    72,103!46 5,061,413!45

    71,070!68 4,986,829!33

    70,023!40 4,911,197!92

    68,961!40 4,834,504!52

    67,884!50 4,756,734!21

    66,792!48 4,677,871!88

    65,685!12 4,597,902!20

    64,562!21 4,516,809!60

    63,423!53 4,434,578!33

    62,268!87 4,351,192!39

    61,097!99 4,266,635!58

    59,910!67 4,180,891!45

    58,706!68 4,093,943!33

    57,485!79 4,005,774!31

    56,247!75 3,916,367!25

    54,992!32 3,825,704!77

    53,719!27 3,733,769!24

    52,428!34 3,640,542!78

    51,119!29 3,546,007!26

    49,791!85 3,450,144!30

    48,445!78 3,352,935!27

    47,080!80 3,254,361!27

    45,696!66 3,154,403!12

    44,293!08 3,053,041!39

    42,869!79 2,950,256!37

    41,426!52 2,846,028!09

    39,962!98 2,740,336!2638,478!89 2,633,160!34

    36,973!96 2,524,479!49

    35,447!90 2,414,272!59

    33,900!41 2,302,518!19

    32,331!19 2,189,194!58

    30,739!94 2,074,279!72

    29,126!34 1,957,751!26

    27,490!09 1,839,586!54

    25,830!86 1,719,762!60

    24,148!33 1,598,256!12

    22,442!18 1,475,043!50

    20,712!07 1,350,100!76

    18,957!66 1,223,403!62

    17,178!63 1,094,927!44

    15,374!61 964,647!2413,545!26 832,537!69

    11,690!22 698,573!10

    9,809!13 562,727!43

    7,901!63 424,974!25

    5,967!35 285,286!79

    4,005!90 143,637!89

    2,016!92 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/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    23/76

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    24/76

    I#% E#*$# B"+"# M"$# NII ",# N!

    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 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!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 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 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

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    25/76

    I#% E#*$# B"+"# M"$# NII ",# N!

    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 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!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

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    26/76

    L!"# C"+'+"! 

    E# V"+'% L!"# S'",

    .oa /o$t 21,045,825!91 ce%$e% Paet < 336,657!56

     /$a Iterest Rate 17!85 " ce%$e% *$er of Paets 180

    .oa Per&o% & -ears 15 /ct$a *$er of Paets 180

    *$er of Paets Per -ear 12 Tota ar Paets <

    tart :ate of .oa 1;1;2007 Tota Iterest < 39,552,535!09

    t&oa tra Paets

    L#* N"

    $#$"+ I#%

    1 2;1;2007 < 21,045,825!91 < 336,657!56 < < 336,657!56 < 23,600!90 < 313,056!66

    2 3;1;2007 21,022,225!01 336,657!56 336,657!56 23,951!96 312,705!60

    3 4;1;2007 20,998,273!04 336,657!56 336,657!56 24,308!25 312,349!31

    4 5;1;2007 20,973,964!79 336,657!56 336,657!56 24,669!83 311,987!73

    5 6;1;2007 20,949,294!96 336,657!56 336,657!56 25,036!80 311,620!76

    6 7;1;2007 20,924,258!16 336,657!56 336,657!56 25,409!22 311,248!34

    7 8;1;2007 20,898,848!94 336,657!56 336,657!56 25,787!18 310,870!38

    8 9;1;2007 20,873,061!76 336,657!56 336,657!56 26,170!77 310,486!79

    9 10;1;2007 20,846,890!99 336,657!56 336,657!56 26,560!06 310,097!50

    10 11;1;2007 20,820,330!93 336,657!56 336,657!56 26,955!14 309,702!4211 12;1;2007 20,793,375!79 336,657!56 336,657!56 27,356!10 309,301!46

    12 1;1;2008 20,766,019!70 336,657!56 336,657!56 27,763!02 308,894!54

    13 2;1;2008 20,738,256!68 336,657!56 336,657!56 28,175!99 308,481!57

    14 3;1;2008 20,710,080!68 336,657!56 336,657!56 28,595!11 308,062!45

    15 4;1;2008 20,681,485!57 336,657!56 336,657!56 29,020!46 307,637!10

    16 5;1;2008 20,652,465!11 336,657!56 336,657!56 29,452!14 307,205!42

    17 6;1;2008 20,623,012!97 336,657!56 336,657!56 29,890!24 306,767!32

    18 7;1;2008 20,593,122!72 336,657!56 336,657!56 30,334!86 306,322!70

    19 8;1;2008 20,562,787!86 336,657!56 336,657!56 30,786!09 305,871!47

    20 9;1;2008 20,532,001!77 336,657!56 336,657!56 31,244!03 305,413!53

    21 10;1;2008 20,500,757!74 336,657!56 336,657!56 31,708!79 304,948!77

    22 11;1;2008 20,469,048!95 336,657!56 336,657!56 32,180!46 304,477!10

    23 12;1;2008 20,436,868!49 336,657!56 336,657!56 32,659!14 303,998!42

    24 1;1;2009 20,404,209!35 336,657!56 336,657!56 33,144!95 303,512!61

    25 2;1;2009 20,371,064!40 336,657!56 336,657!56 33,637!98 303,019!58

    26 3;1;2009 20,337,426!42 336,657!56 336,657!56 34,138!34 302,519!22

    27 4;1;2009 20,303,288!08 336,657!56 336,657!56 34,646!15 302,011!41

    28 5;1;2009 20,268,641!93 336,657!56 336,657!56 35,161!51 301,496!05

    29 6;1;2009 20,233,480!42 336,657!56 336,657!56 35,684!54 300,973!02

    30 7;1;2009 20,197,795!88 336,657!56 336,657!56 36,215!35 300,442!21

    31 8;1;2009 20,161,580!53 336,657!56 336,657!56 36,754!05 299,903!51

    32 9;1;2009 20,124,826!48 336,657!56 336,657!56 37,300!77 299,356!79

    33 10;1;2009 20,087,525!71 336,657!56 336,657!56 37,855!62 298,801!94

    34 11;1;2009 20,049,670!09 336,657!56 336,657!56 38,418!72 298,238!84

    35 12;1;2009 20,011,251!38 336,657!56 336,657!56 38,990!20 297,667!36

    36 1;1;2010 19,972,261!18 336,657!56 336,657!56 39,570!18 297,087!39

    37 2;1;2010 19,932,691!00 336,657!56 336,657!56 40,158!78 296,498!78

    38 3;1;2010 19,892,532!22 336,657!56 336,657!56 40,756!14 295,901!42

    39 4;1;2010 19,851,776!08 336,657!56 336,657!56 41,362!39 295,295!1740 5;1;2010 19,810,413!68 336,657!56 336,657!56 41,977!66 294,679!90

    41 6;1;2010 19,768,436!03 336,657!56 336,657!56 42,602!08 294,055!49

    42 7;1;2010 19,725,833!95 336,657!56 336,657!56 43,235!78 293,421!78

    43 8;1;2010 19,682,598!17 336,657!56 336,657!56 43,878!91 292,778!65

    44 9;1;2010 19,638,719!26 336,657!56 336,657!56 44,531!61 292,125!95

    45 10;1;2010 19,594,187!64 336,657!56 336,657!56 45,194!02 291,463!54

    46 11;1;2010 19,548,993!62 336,657!56 336,657!56 45,866!28 290,791!28

    47 12;1;2010 19,503,127!34 336,657!56 336,657!56 46,548!54 290,109!02

    48 1;1;2011 19,456,578!80 336,657!56 336,657!56 47,240!95 289,416!61

    49 2;1;2011 19,409,337!85 336,657!56 336,657!56 47,943!66 288,713!90

    50 3;1;2011 19,361,394!19 336,657!56 336,657!56 48,656!82 288,000!74

    51 4;1;2011 19,312,737!37 336,657!56 336,657!56 49,380!59 287,276!97

    52 5;1;2011 19,263,356!77 336,657!56 336,657!56 50,115!13 286,542!43

    53 6;1;2011 19,213,241!64 336,657!56 336,657!56 50,860!59 285,796!97

    N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    27/76

    $#$"+ I#%N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    54 7;1;2011 19,162,381!05 336,657!56 336,657!56 51,617!14 285,040!42

    55 8;1;2011 19,110,763!91 336,657!56 336,657!56 52,384!95 284,272!61

    56 9;1;2011 19,058,378!96 336,657!56 336,657!56 53,164!17 283,493!39

    57 10;1;2011 19,005,214!79 336,657!56 336,657!56 53,954!99 282,702!57

    58 11;1;2011 18,951,259!80 336,657!56 336,657!56 54,757!57 281,899!99

    59 12;1;2011 18,896,502!23 336,657!56 336,657!56 55,572!09 281,085!47

    60 1;1;2012 18,840,930!13 336,657!56 336,657!56 56,398!73 280,258!84

    61 2;1;2012 18,784,531!41 336,657!56 336,657!56 57,237!66 279,419!90

    62 3;1;2012 18,727,293!75 336,657!56 336,657!56 58,089!07 278,568!4963 4;1;2012 18,669,204!69 336,657!56 336,657!56 58,953!14 277,704!42

    64 5;1;2012 18,610,251!54 336,657!56 336,657!56 59,830!07 276,827!49

    65 6;1;2012 18,550,421!48 336,657!56 336,657!56 60,720!04 275,937!52

    66 7;1;2012 18,489,701!43 336,657!56 336,657!56 61,623!25 275,034!31

    67 8;1;2012 18,428,078!18 336,657!56 336,657!56 62,539!90 274,117!66

    68 9;1;2012 18,365,538!28 336,657!56 336,657!56 63,470!18 273,187!38

    69 10;1;2012 18,302,068!10 336,657!56 336,657!56 64,414!30 272,243!26

    70 11;1;2012 18,237,653!81 336,657!56 336,657!56 65,372!46 271,285!10

    71 12;1;2012 18,172,281!35 336,657!56 336,657!56 66,344!88 270,312!69

    72 1;1;2013 18,105,936!47 336,657!56 336,657!56 67,331!76 269,325!80

    73 2;1;2013 18,038,604!71 336,657!56 336,657!56 68,333!32 268,324!25

    74 3;1;2013 17,970,271!40 336,657!56 336,657!56 69,349!77 267,307!79

    75 4;1;2013 17,900,921!62 336,657!56 336,657!56 70,381!35 266,276!21

    76 5;1;2013 17,830,540!27 336,657!56 336,657!56 71,428!27 265,229!29

    77 6;1;2013 17,759,112!00 336,657!56 336,657!56 72,490!77 264,166!79

    78 7;1;2013 17,686,621!23 336,657!56 336,657!56 73,569!07 263,088!49

    79 8;1;2013 17,613,052!16 336,657!56 336,657!56 74,663!41 261,994!15

    80 9;1;2013 17,538,388!75 336,657!56 336,657!56 75,774!03 260,883!53

    81 10;1;2013 17,462,614!72 336,657!56 336,657!56 76,901!17 259,756!39

    82 11;1;2013 17,385,713!55 336,657!56 336,657!56 78,045!07 258,612!49

    83 12;1;2013 17,307,668!48 336,657!56 336,657!56 79,205!99 257,451!57

    84 1;1;2014 17,228,462!49 336,657!56 336,657!56 80,384!18 256,273!38

    85 2;1;2014 17,148,078!30 336,657!56 336,657!56 81,579!90 255,077!66

    86 3;1;2014 17,066,498!41 336,657!56 336,657!56 82,793!40 253,864!16

    87 4;1;2014 16,983,705!01 336,657!56 336,657!56 84,024!95 252,632!61

    88 5;1;2014 16,899,680!06 336,657!56 336,657!56 85,274!82 251,382!74

    89 6;1;2014 16,814,405!24 336,657!56 336,657!56 86,543!28 250,114!28

    90 7;1;2014 16,727,861!96 336,657!56 336,657!56 87,830!61 248,826!95

    91 8;1;2014 16,640,031!34 336,657!56 336,657!56 89,137!09 247,520!4792 9;1;2014 16,550,894!25 336,657!56 336,657!56 90,463!01 246,194!55

    93 10;1;2014 16,460,431!24 336,657!56 336,657!56 91,808!65 244,848!91

    94 11;1;2014 16,368,622!59 336,657!56 336,657!56 93,174!30 243,483!26

    95 12;1;2014 16,275,448!29 336,657!56 336,657!56 94,560!27 242,097!29

    96 1;1;2015 16,180,888!02 336,657!56 336,657!56 95,966!85 240,690!71

    97 2;1;2015 16,084,921!17 336,657!56 336,657!56 97,394!36 239,263!20

    98 3;1;2015 15,987,526!81 336,657!56 336,657!56 98,843!10 237,814!46

    99 4;1;2015 15,888,683!71 336,657!56 336,657!56 100,313!39 236,344!17

    100 5;1;2015 15,788,370!32 336,657!56 336,657!56 101,805!55 234,852!01

    101 6;1;2015 15,686,564!77 336,657!56 336,657!56 103,319!91 233,337!65

    102 7;1;2015 15,583,244!86 336,657!56 336,657!56 104,856!79 231,800!77

    103 8;1;2015 15,478,388!07 336,657!56 336,657!56 106,416!54 230,241!02

    104 9;1;2015 15,371,971!53 336,657!56 336,657!56 107,999!48 228,658!08

    105 10;1;2015 15,263,972!04 336,657!56 336,657!56 109,605!98 227,051!58

    106 11;1;2015 15,154,366!07 336,657!56 336,657!56 111,236!37 225,421!20107 12;1;2015 15,043,129!70 336,657!56 336,657!56 112,891!01 223,766!55

    108 1;1;2016 14,930,238!69 336,657!56 336,657!56 114,570!26 222,087!30

    109 2;1;2016 14,815,668!43 336,657!56 336,657!56 116,274!49 220,383!07

    110 3;1;2016 14,699,393!94 336,657!56 336,657!56 118,004!08 218,653!48

    111 4;1;2016 14,581,389!86 336,657!56 336,657!56 119,759!39 216,898!17

    112 5;1;2016 14,461,630!48 336,657!56 336,657!56 121,540!81 215,116!75

    113 6;1;2016 14,340,089!67 336,657!56 336,657!56 123,348!73 213,308!83

    114 7;1;2016 14,216,740!94 336,657!56 336,657!56 125,183!54 211,474!02

    115 8;1;2016 14,091,557!40 336,657!56 336,657!56 127,045!64 209,611!92

    116 9;1;2016 13,964,511!76 336,657!56 336,657!56 128,935!45 207,722!11

    117 10;1;2016 13,835,576!31 336,657!56 336,657!56 130,853!36 205,804!20

    118 11;1;2016 13,704,722!95 336,657!56 336,657!56 132,799!81 203,857!75

    119 12;1;2016 13,571,923!14 336,657!56 336,657!56 134,775!20 201,882!36

    120 1;1;2017 13,437,147!93 336,657!56 336,657!56 136,779!99 199,877!58

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    28/76

    $#$"+ I#%N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    121 2;1;2017 13,300,367!95 336,657!56 336,657!56 138,814!59 197,842!97

    122 3;1;2017 13,161,553!36 336,657!56 336,657!56 140,879!45 195,778!11

    123 4;1;2017 13,020,673!91 336,657!56 336,657!56 142,975!04 193,682!52

    124 5;1;2017 12,877,698!87 336,657!56 336,657!56 145,101!79 191,555!77

    125 6;1;2017 12,732,597!08 336,657!56 336,657!56 147,260!18 189,397!38

    126 7;1;2017 12,585,336!90 336,657!56 336,657!56 149,450!67 187,206!89

    127 8;1;2017 12,435,886!22 336,657!56 336,657!56 151,673!75 184,983!81

    128 9;1;2017 12,284,212!47 336,657!56 336,657!56 153,929!90 182,727!66

    129 10;1;2017 12,130,282!57 336,657!56 336,657!56 156,219!61 180,437!95130 11;1;2017 11,974,062!96 336,657!56 336,657!56 158,543!37 178,114!19

    131 12;1;2017 11,815,519!59 336,657!56 336,657!56 160,901!71 175,755!85

    132 1;1;2018 11,654,617!88 336,657!56 336,657!56 163,295!12 173,362!44

    133 2;1;2018 11,491,322!76 336,657!56 336,657!56 165,724!14 170,933!43

    134 3;1;2018 11,325,598!63 336,657!56 336,657!56 168,189!28 168,468!28

    135 4;1;2018 11,157,409!34 336,657!56 336,657!56 170,691!10 165,966!46

    136 5;1;2018 10,986,718!25 336,657!56 336,657!56 173,230!13 163,427!43

    137 6;1;2018 10,813,488!12 336,657!56 336,657!56 175,806!93 160,850!64

    138 7;1;2018 10,637,681!19 336,657!56 336,657!56 178,422!05 158,235!51

    139 8;1;2018 10,459,259!14 336,657!56 336,657!56 181,076!08 155,581!48

    140 9;1;2018 10,278,183!06 336,657!56 336,657!56 183,769!59 152,887!97

    141 10;1;2018 10,094,413!47 336,657!56 336,657!56 186,503!16 150,154!40

    142 11;1;2018 9,907,910!31 336,657!56 336,657!56 189,277!40 147,380!17

    143 12;1;2018 9,718,632!91 336,657!56 336,657!56 192,092!90 144,564!66

    144 1;1;2019 9,526,540!02 336,657!56 336,657!56 194,950!28 141,707!28

    145 2;1;2019 9,331,589!74 336,657!56 336,657!56 197,850!16 138,807!40

    146 3;1;2019 9,133,739!58 336,657!56 336,657!56 200,793!18 135,864!38

    147 4;1;2019 8,932,946!39 336,657!56 336,657!56 203,779!98 132,877!58

    148 5;1;2019 8,729,166!41 336,657!56 336,657!56 206,811!21 129,846!35

    149 6;1;2019 8,522,355!20 336,657!56 336,657!56 209,887!53 126,770!03

    150 7;1;2019 8,312,467!67 336,657!56 336,657!56 213,009!60 123,647!96

    151 8;1;2019 8,099,458!06 336,657!56 336,657!56 216,178!12 120,479!44

    152 9;1;2019 7,883,279!94 336,657!56 336,657!56 219,393!77 117,263!79

    153 10;1;2019 7,663,886!17 336,657!56 336,657!56 222,657!25 114,000!31

    154 11;1;2019 7,441,228!92 336,657!56 336,657!56 225,969!28 110,688!28

    155 12;1;2019 7,215,259!64 336,657!56 336,657!56 229,330!57 107,326!99

    156 1;1;2020 6,985,929!06 336,657!56 336,657!56 232,741!87 103,915!69

    157 2;1;2020 6,753,187!19 336,657!56 336,657!56 236,203!90 100,453!66

    158 3;1;2020 6,516,983!29 336,657!56 336,657!56 239,717!43 96,940!13159 4;1;2020 6,277,265!86 336,657!56 336,657!56 243,283!23 93,374!33

    160 5;1;2020 6,033,982!63 336,657!56 336,657!56 246,902!07 89,755!49

    161 6;1;2020 5,787,080!56 336,657!56 336,657!56 250,574!74 86,082!82

    162 7;1;2020 5,536,505!82 336,657!56 336,657!56 254,302!04 82,355!52

    163 8;1;2020 5,282,203!78 336,657!56 336,657!56 258,084!78 78,572!78

    164 9;1;2020 5,024,119!00 336,657!56 336,657!56 261,923!79 74,733!77

    165 10;1;2020 4,762,195!21 336,657!56 336,657!56 265,819!91 70,837!65

    166 11;1;2020 4,496,375!30 336,657!56 336,657!56 269,773!98 66,883!58

    167 12;1;2020 4,226,601!33 336,657!56 336,657!56 273,786!87 62,870!69

    168 1;1;2021 3,952,814!46 336,657!56 336,657!56 277,859!45 58,798!12

    169 2;1;2021 3,674,955!01 336,657!56 336,657!56 281,992!61 54,664!96

    170 3;1;2021 3,392,962!41 336,657!56 336,657!56 286,187!25 50,470!32

    171 4;1;2021 3,106,775!16 336,657!56 336,657!56 290,444!28 46,213!28

    172 5;1;2021 2,816,330!88 336,657!56 336,657!56 294,764!64 41,892!92

    173 6;1;2021 2,521,566!24 336,657!56 336,657!56 299,149!26 37,508!30174 7;1;2021 2,222,416!98 336,657!56 336,657!56 303,599!11 33,058!45

    175 8;1;2021 1,918,817!87 336,657!56 336,657!56 308,115!15 28,542!42

    176 9;1;2021 1,610,702!73 336,657!56 336,657!56 312,698!36 23,959!20

    177 10;1;2021 1,298,004!37 336,657!56 336,657!56 317,349!75 19,307!81

    178 11;1;2021 980,654!62 336,657!56 336,657!56 322,070!32 14,587!24

    179 12;1;2021 658,584!30 336,657!56 336,657!56 326,861!12 9,796!44

    180 1;1;2022 331,723!18 336,657!56 331,723!18 326,788!80 4,934!38

    181 2;1;2022 0!00 336,657!56 0!00 0!00 0!00

    182 3;1;2022 0!00 336,657!56 0!00 0!00 0!00

    183 4;1;2022 0!00 336,657!56 0!00 0!00 0!00

    184 5;1;2022 0!00 336,657!56 0!00 0!00 0!00

    185 6;1;2022 0!00 336,657!56 0!00 0!00 0!00

    186 7;1;2022 0!00 336,657!56 0!00 0!00 0!00

    187 8;1;2022 0!00 336,657!56 0!00 0!00 0!00

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    29/76

    $#$"+ I#%N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    188 9;1;2022 0!00 336,657!56 0!00 0!00 0!00

    189 10;1;2022 0!00 336,657!56 0!00 0!00 0!00

    190 11;1;2022 0!00 336,657!56 0!00 0!00 0!00

    191 12;1;2022 0!00 336,657!56 0!00 0!00 0!00

    192 1;1;2023 0!00 336,657!56 0!00 0!00 0!00

    193 2;1;2023 0!00 336,657!56 0!00 0!00 0!00

    194 3;1;2023 0!00 336,657!56 0!00 0!00 0!00

    195 4;1;2023 0!00 336,657!56 0!00 0!00 0!00

    196 5;1;2023 0!00 336,657!56 0!00 0!00 0!00197 6;1;2023 0!00 336,657!56 0!00 0!00 0!00

    198 7;1;2023 0!00 336,657!56 0!00 0!00 0!00

    199 8;1;2023 0!00 336,657!56 0!00 0!00 0!00

    200 9;1;2023 0!00 336,657!56 0!00 0!00 0!00

    201 10;1;2023 0!00 336,657!56 0!00 0!00 0!00

    202 11;1;2023 0!00 336,657!56 0!00 0!00 0!00

    203 12;1;2023 0!00 336,657!56 0!00 0!00 0!00

    204 1;1;2024 0!00 336,657!56 0!00 0!00 0!00

    205 2;1;2024 0!00 336,657!56 0!00 0!00 0!00

    206 3;1;2024 0!00 336,657!56 0!00 0!00 0!00

    207 4;1;2024 0!00 336,657!56 0!00 0!00 0!00

    208 5;1;2024 0!00 336,657!56 0!00 0!00 0!00

    209 6;1;2024 0!00 336,657!56 0!00 0!00 0!00

    210 7;1;2024 0!00 336,657!56 0!00 0!00 0!00

    211 8;1;2024 0!00 336,657!56 0!00 0!00 0!00

    212 9;1;2024 0!00 336,657!56 0!00 0!00 0!00

    213 10;1;2024 0!00 336,657!56 0!00 0!00 0!00

    214 11;1;2024 0!00 336,657!56 0!00 0!00 0!00

    215 12;1;2024 0!00 336,657!56 0!00 0!00 0!00

    216 1;1;2025 0!00 336,657!56 0!00 0!00 0!00

    217 2;1;2025 0!00 336,657!56 0!00 0!00 0!00

    218 3;1;2025 0!00 336,657!56 0!00 0!00 0!00

    219 4;1;2025 0!00 336,657!56 0!00 0!00 0!00

    220 5;1;2025 0!00 336,657!56 0!00 0!00 0!00

    221 6;1;2025 0!00 336,657!56 0!00 0!00 0!00

    222 7;1;2025 0!00 336,657!56 0!00 0!00 0!00

    223 8;1;2025 0!00 336,657!56 0!00 0!00 0!00

    224 9;1;2025 0!00 336,657!56 0!00 0!00 0!00

    225 10;1;2025 0!00 336,657!56 0!00 0!00 0!00226 11;1;2025 0!00 336,657!56 0!00 0!00 0!00

    227 12;1;2025 0!00 336,657!56 0!00 0!00 0!00

    228 1;1;2026 0!00 336,657!56 0!00 0!00 0!00

    229 2;1;2026 0!00 336,657!56 0!00 0!00 0!00

    230 3;1;2026 0!00 336,657!56 0!00 0!00 0!00

    231 4;1;2026 0!00 336,657!56 0!00 0!00 0!00

    232 5;1;2026 0!00 336,657!56 0!00 0!00 0!00

    233 6;1;2026 0!00 336,657!56 0!00 0!00 0!00

    234 7;1;2026 0!00 336,657!56 0!00 0!00 0!00

    235 8;1;2026 0!00 336,657!56 0!00 0!00 0!00

    236 9;1;2026 0!00 336,657!56 0!00 0!00 0!00

    237 10;1;2026 0!00 336,657!56 0!00 0!00 0!00

    238 11;1;2026 0!00 336,657!56 0!00 0!00 0!00

    239 12;1;2026 0!00 336,657!56 0!00 0!00 0!00

    240 1;1;2027 0!00 336,657!56 0!00 0!00 0!00241 2;1;2027 0!00 336,657!56 0!00 0!00 0!00

    242 3;1;2027 0!00 336,657!56 0!00 0!00 0!00

    243 4;1;2027 0!00 336,657!56 0!00 0!00 0!00

    244 5;1;2027 0!00 336,657!56 0!00 0!00 0!00

    245 6;1;2027 0!00 336,657!56 0!00 0!00 0!00

    246 7;1;2027 0!00 336,657!56 0!00 0!00 0!00

    247 8;1;2027 0!00 336,657!56 0!00 0!00 0!00

    248 9;1;2027 0!00 336,657!56 0!00 0!00 0!00

    249 10;1;2027 0!00 336,657!56 0!00 0!00 0!00

    250 11;1;2027 0!00 336,657!56 0!00 0!00 0!00

    251 12;1;2027 0!00 336,657!56 0!00 0!00 0!00

    252 1;1;2028 0!00 336,657!56 0!00 0!00 0!00

    253 2;1;2028 0!00 336,657!56 0!00 0!00 0!00

    254 3;1;2028 0!00 336,657!56 0!00 0!00 0!00

  • 8/17/2019 Ammended to Drive Allignemnt - Test File Only KE Variable H Loan Financials Retail 10_May_2005

    30/76

    $#$"+ I#%N!.

    ",#D"

    B$##$#B"+"#

    S/*'+*",#

    E:"",#

    T!"+",#

    255 4;1;2028 0!00 336,657!56 0!00 0!00 0!00

    256 5;1;2028 0!00 336,657!56 0!00 0!00 0!00

    257 6;1;2028 0!00 336,657!56 0!00 0!00 0!00

    258 7;1;2028 0!00 336,657!56 0!00 0!00 0!00

    259 8;1;2028 0!00 336,657!56 0!00 0!00 0!00

    260 9;1;2028 0!00 336,657!56 0!00 0!00 0!00

    261 10;1;2028 0!00 336,657!56 0!00 0!00 0!00

    262 11;1;2028 0!00 336,657!56 0!00 0!00 0!00

    263 12;1;2028 0!00 336,657!56 0!00 0!00 0!00264 1;1;2029 0!00 336,657!56 0!00 0!00 0!00

    265 2;1;2029 0!00 336,657!56 0!00 0!00 0!00

    266 3;1;2029 0!00 336,657!56 0!00 0!00 0!00

    267 4;1;2029 0!00 336,657!56 0!00 0!00 0!00

    268 5;1;2029 0!00 336,657!56 0!00 0!00 0!00

    269 6;1;2029 0!00 336,657!56 0!00 0!00 0!00

    270 7;1;2029 0!00 336,657!56 0!00 0!00 0!00

    271 8;1;2029 0!00 336,657!56 0!00 0!00 0!00

    272 9;1;2029 0!00 336,657!56 0!00 0!00 0!00

    273 10;1;2029 0!00 336,657!56 0!00 0!00 0!00

    274 11;1;2029 0!00 336,657!56 0!00 0!00 0!00

    275 12;1;2029 0!00 336,657!56 0!00 0!00 0!00

    276 1;1;2030 0!00 336,657!56 0!00 0!00 0!00

    277 2;1;2030 0!00 336,657!56 0!00 0!00 0!00

    278 3;1;2030 0!00 336,657!56 0!00 0!00 0!00

    279 4;1;2030 0!00 336,657!56 0!00 0!00 0!00

    280 5;1;2030 0!00 336,657!56 0!00 0!00 0!00

    281 6;1;2030 0!00 336,657!56 0!00 0!00 0!00

    282 7;1;2030 0!00 336,657!56 0!00 0!00 0!00

    283 8;1;2030 0!00 336,657!56 0!00 0!00 0!00

    284 9;1;2030 0!00 336,657!56 0!00 0!00 0!00

    285 10;1;2030 0!00 336,657!56 0!00 0!00 0!00

    286 11;1;2030 0!00 336,657!56 0!00 0!00 0!00

    287 12;1;2030 0!00 336,657!56 0!00 0!00 0!00

    288 1;1;2031 0!00 336,657!56 0!00 0!00 0!00

    289 2;1;2031 0!00 336,657!56 0!00 0!00 0!00

    290 3;1;2031 0!00 336,657!56 0!00 0!00 0!00

    291 4;1;2031 0!00 336,657!56 0!00 0!00 0!00

    292 5;1;2031 0!00 336,657!56 0!00 0!00 0!00293 6;1;2031 0!00 336,657!56 0!00 0!00 0!00

    294 7;1;2031 0!00 336,657!56 0!00 0!00 0!00

    295 8;1;2031 0!00 336,657!56 0!00 0!00 0!00

    296 9;1;2031 0!00 336,657!56 0!00 0!00 0!00

    297 10;1;2031 0!00 336,657!56 0!00 0!00 0!00

    298 11;1;2031 0!00 336,657!56 0!00 0!00 0!00

    299 12;1;2031 0!00 336,657!56 0!00 0!00 0!00

    300 1;1;2032 0!00 336,657!56 0!00 0!00 0!00

    301 2;1;2032 0!00 336,657!56 0!00 0!00 0!00

    302 3;1;2032 0!00 336,657!56 0!00 0!00 0!00

    303 4;1;2032 0!00 336,657!56 0!00 0!00 0!00

    304 5;1;2032 0!00 336,657!56 0!00 0!00 0!00

    305 6;1;2032 0!00 336,657!56 0!00 0!00 0!00

    306 7;1;2032 0!00 336,657!56 0!00 0!00 0!00

    307 8;1;2032 0!00 336,657!56 0!00 0!00 0!00308 9;1;2032 0!00 336,657!56 0!00 0!00 0!00

    309 10;1;2032 0!00 336,657!56 0!00 0!00 0!00

    310 11;1;2032 0!00 336,657!56 0!00 0!00 0!00

    311 12;1;2032 0!00 336,657!56 0!00 0!00 0!00

    312 1;1;2033 0!00 336,657!56 0!00 0!00 0!00

    313 2;1;2033 0!00 336,657!56 0!00 0!00 0!00

    314 3;1;2033 0!00 336,657!56 0!00 0!00 0!00

    315 4;1;2033 0!00 336,657!56 0!00 0!00 0!00

    316 5;1;2033 0!00 336,657!56 0!00 0!00 0!00

    317 6;1;2033 0!00 336,657!56 0!00 0!00 0!00

    318 7;1;2033 0!00 336,657!56 0!00 0!00 0!00

    319 8;1;2033 0!00 336,657!56 0!00 0!00 0!00

    320 9;1;2033 0!00 336,657!56 0!00 0!00 0!00

    321 10;1;2033 0!00 336,