Spreadsheet: dan_hyvl__4805__PEAK2001 1-18 10yr for RFP
Sheet: PEAK Max Penal Sum

SURETY AND LIQUIDATION PAYMENT CALCULATIONS
 | USES | SOURCES
GPA | Redemption | Debt | 4 | Scheduled | Replenish | Interest | Reserve | Surety
Termination | Price | Service | Days | Debt | Reserve | Payment | Account | Maximum
Date |  | Payment | Accrued | Service | Account | Reserve | Accrued | Penal
 | Due First Day | Lagged | Interest | Deposits | Surety | Account | Due | Sum
 | Of Subsequent | 1 Month | Due | Lagged | Draw | Surety
 | Month | (Negative | (Negative | 2 months | (Negative | Draw |  | Liquidation
 |  | Source) | Source) |  | Source) | 0.0625 |  | Payment
2001-05-31 00:00:00 | 406741793.7571428 |  | -341232.0144444444 |  | 0 | 0 | 0 | 407083025.7715873
2001-06-30 00:00:00 | 408935428.1357143 |  | -341232.0144444444 | 0 | 0 | 0 | 0 | 409276660.1501588
2001-07-31 00:00:00 | 411129062.5142857 |  | -341232.0144444444 | 0 | 0 | 0 | 0 | 411470294.5287302
2001-08-31 00:00:00 | 413322696.8928571 |  | -341232.0144444444 | 3743460.18 | 0 | 0 | 0 | 409920468.7273016
2001-09-30 00:00:00 | 415516331.2714286 |  | -341232.0144444444 | 7359683.58 | 0 | 0 | 0 | 408497879.7058731
2001-10-31 00:00:00 | 417539990.65 |  | -341232.0144444444 | 14825957.94 | 0 | 0 | 0 | 403055264.7244444
2001-11-30 00:00:00 | 397491058.4166667 | -22154440.65 | -280734.4555555555 | 18430085.34 | -3724355.31 | -20044.27336979166 | 0 | 405240547.765592
2001-12-31 00:00:00 | 399596566.8333333 | 0 | -280734.4555555555 | 467.6700000017881 | 0 | 0 | 0 | 399876833.6188889
2002-01-31 00:00:00 | 401702075.25 | 0 | -280734.4555555555 | 3937244.52 | 0 | 0 | 0 | 398045565.1855556
2002-02-28 00:00:00 | 403807583.6666667 | 0 | -280734.4555555555 | 8109887.765000002 | 0 | 0 | 0 | 395978430.3572223
2002-03-31 00:00:00 | 405913092.0833333 | 0 | -280734.4555555555 | 12319521.76 | 0 | 0 | 0 | 393874304.7788889
2002-04-30 00:00:00 | 407744150.5 | 0 | -280734.4555555555 | 16011124.22 | 0 | 0 | 0 | 392013760.7355555
2002-05-31 00:00:00 | 386178686.8333333 | -23611050.5 | -272744.9111111111 | 19951025.665 | -3660024.834999997 | -19062.62934895832 | 0 | 393790544.0437933
2002-06-30 00:00:00 | 388224273.6666667 | 0 | -272744.9111111111 | 0 | 0 | 0 | 0 | 388497018.5777778
2002-07-31 00:00:00 | 390269860.5 | 0 | -272744.9111111111 | 3731089.610371886 | 0 | 0 | 0 | 386811515.8007392
2002-08-31 00:00:00 | 392315447.3333333 | 0 | -272744.9111111111 | 7334645.133153116 | 0 | 0 | 0 | 385253547.1112913
2002-09-30 00:00:00 | 394361034.1666667 | 0 | -272744.9111111111 | 11059526.59869137 | 0 | 0 | 0 | 383574252.4790865
2002-10-31 00:00:00 | 396160271 | 0 | -272744.9111111111 | 14787123.44201421 | 0 | 0 | 0 | 381645892.4690969
2002-11-30 00:00:00 | 376024550.4166667 | -22127521 | -265573.3888888889 | 18389042.98553295 | -3738478.014467053 | -20120.28098063865 | 0 | 383787200.1154703
2002-12-31 00:00:00 | 378016350.8333333 | 0 | -265573.3888888889 | 123.0308247357607 | 0 | 0 | 0 | 378281801.1913975
2003-01-31 00:00:00 | 380008151.25 | 0 | -265573.3888888889 | 4840628.453399862 | 0 | 0 | 0 | 375433096.1854891
2003-02-28 00:00:00 | 381999951.6666667 | 0 | -265573.3888888889 | 10003180.39818728 | 0 | 0 | 0 | 372262344.6573683
2003-03-31 00:00:00 | 383991752.0833333 | 0 | -265573.3888888889 | 15243181.5159234 | 0 | 0 | 0 | 369014143.9562988
2003-04-30 00:00:00 | 385570052.5 | 0 | -265573.3888888889 | 19875579.0236176 | 0 | 0 | 0 | 365960046.8652713
2003-05-31 00:00:00 | 358980769.5833333 | -28490802.5 | -253535.9444444444 | 24806615.05478218 | -3684187.445217818 | -19188.47627717614 | 0 | 366621868.8944905
2003-06-30 00:00:00 | 360882289.1666667 | 0 | -253535.9444444444 | 0 | 0 | 0 | 0 | 361135825.1111111
2003-07-31 00:00:00 | 362783808.75 | 0 | -253535.9444444444 | 3749254.56692697 | 0 | 0 | 0 | 359288090.1275175
2003-08-31 00:00:00 | 364685328.3333333 | 0 | -253535.9444444444 | 7401382.264915964 | 0 | 0 | 0 | 357537482.0128618
2003-09-30 00:00:00 | 366586847.9166667 | 0 | -253535.9444444444 | 11199743.76282463 | 0 | 0 | 0 | 355640640.0982864
2003-10-31 00:00:00 | 368206042.5 | 0 | -253535.9444444444 | 15023081.24933352 | 0 | 0 | 0 | 353436497.1951109
2003-11-30 00:00:00 | 347343803.625 | -22702117.5 | -245317.15 | 18779912.10112666 | -3922205.398873337 | -21109.09155643636 | 0 | 355454640.6643031
2003-12-31 00:00:00 | 349183682.25 | 0 | -245317.15 | 99.05981205031276 | 0 | 0 | 0 | 349428900.3401879
2004-01-31 00:00:00 | 351023560.875 | 0 | -245317.15 | 4817580.040883632 | 0 | 0 | 0 | 346451297.9841163
2004-02-29 00:00:00 | 352863439.5 | 0 | -245317.15 | 9956594.42869654 | 0 | 0 | 0 | 343152162.2213035
2004-03-31 00:00:00 | 354703318.125 | 0 | -245317.15 | 15199893.36557911 | 0 | 0 | 0 | 339748741.9094208
2004-04-30 00:00:00 | 356100246.75 | 0 | -245317.15 | 20014106.02669987 | 0 | 0 | 0 | 336331457.8733001
2004-05-31 00:00:00 | 329086142.875 | -28757271.75 | -232422.3833333333 | 24962853.43620566 | -3794418.313794345 | -19762.59538434555 | 0 | 336927164.4813064
2004-06-30 00:00:00 | 330829310.75 | 0 | -232422.3833333333 | 0 | 0 | 0 | 0 | 331061733.1333333
2004-07-31 00:00:00 | 332572478.625 | 0 | -232422.3833333333 | 3862010.026770955 | 0 | 0 | 0 | 328942890.9815624
2004-08-31 00:00:00 | 334315646.5 | 0 | -232422.3833333333 | 7624438.443134855 | 0 | 0 | 0 | 326923630.4401985
2004-09-30 00:00:00 | 336058814.375 | 0 | -232422.3833333333 | 11537372.95206928 | 0 | 0 | 0 | 324753863.806264
2004-10-31 00:00:00 | 337478782.25 | 0 | -232422.3833333333 | 15476152.30575172 | 0 | 0 | 0 | 322235052.3275816
2004-11-30 00:00:00 | 315764377.5416667 | -23387007.25 | -223013.6722222222 | 19346631.86305933 | -4040375.386940666 | -21745.07586721539 | 0 | 324089887.0636374
2004-12-31 00:00:00 | 317436980.0833333 | 0 | -223013.6722222222 | 193.9185504354537 | 0 | 0 | 0 | 317659799.8370051
2005-01-31 00:00:00 | 319109582.625 | 0 | -223013.6722222222 | 5231573.606908821 | 0 | 0 | 0 | 314101022.6903134
2005-02-28 00:00:00 | 320782185.1666667 | 0 | -223013.6722222222 | 10812285.4079595 | 0 | 0 | 0 | 310192913.4309294
2005-03-31 00:00:00 | 322454787.7083333 | 0 | -223013.6722222222 | 16539799.75995528 | 0 | 0 | 0 | 306138001.6206002
2005-04-30 00:00:00 | 323604865.25 | 0 | -223013.6722222222 | 21648360.90978215 | 0 | 0 | 0 | 302179518.01244
2005-05-31 00:00:00 | 294226767.9166667 | -30936615.25 | -207802.3888888889 | 27091142.75518835 | -3845472.494811647 | -20028.50257714399 | 0 | 302145543.797756
2005-06-30 00:00:00 | 295785285.8333333 | 0 | -207802.3888888889 | 0 | 0 | 0 | 0 | 295993088.2222222
2005-07-31 00:00:00 | 297343803.75 | 0 | -207802.3888888889 | 3915073.411449628 | 0 | 0 | 0 | 293636532.7274393
2005-08-31 00:00:00 | 298902321.6666667 | 0 | -207802.3888888889 | 7728945.810551276 | 0 | 0 | 0 | 291381178.2450043
2005-09-30 00:00:00 | 300460839.5833333 | 0 | -207802.3888888889 | 11695131.80485081 | 0 | 0 | 0 | 288973510.1673714
2005-10-31 00:00:00 | 301660557.5 | 0 | -207802.3888888889 | 15687252.80808132 | 0 | 0 | 0 | 286181107.0808076
2005-11-30 00:00:00 | 279437629.9166667 | -23703107.5 | -197357.3222222222 | 19609438.25246532 | -4093669.247534681 | -22031.90046416235 | 0 | 287844357.6344225
2005-12-31 00:00:00 | 280917809.8333333 | 0 | -197357.3222222222 | 414.9747261479497 | 0 | 0 | 0 | 281114752.1808294
2006-01-31 00:00:00 | 282397989.75 | 0 | -197357.3222222222 | 5299725.006292943 | 0 | 0 | 0 | 277295622.0659293
2006-02-28 00:00:00 | 283878169.6666667 | 0 | -197357.3222222222 | 10950737.98977226 | 0 | 0 | 0 | 273124788.9991167
2006-03-31 00:00:00 | 285358349.5833333 | 0 | -197357.3222222222 | 16768001.48387668 | 0 | 0 | 0 | 268787705.4216788
2006-04-30 00:00:00 | 286274679.5 | 0 | -197357.3222222222 | 21969142.09595111 | 0 | 0 | 0 | 264502894.7262711
2006-05-31 00:00:00 | 256196672.6666667 | -31435079.5 | -180943.0222222222 | 27514521.88286529 | -3920557.617134709 | -20419.57092257661 | 0 | 264239150.4940809
2006-06-30 00:00:00 | 257553745.3333333 | 0 | -180943.0222222222 | 0 | 0 | 0 | 0 | 257734688.3555556
2006-07-31 00:00:00 | 258910818 | 0 | -180943.0222222222 | 3993560.326795592 | 0 | 0 | 0 | 255098200.6954266
2006-08-31 00:00:00 | 260267890.6666667 | 0 | -180943.0222222222 | 7883456.503188752 | 0 | 0 | 0 | 252565377.1857001
2006-09-30 00:00:00 | 261624963.3333333 | 0 | -180943.0222222222 | 11928269.92750617 | 0 | 0 | 0 | 249877636.4280494
2006-10-31 00:00:00 | 262581361 | 0 | -180943.0222222222 | 15999086.48809612 | 0 | 0 | 0 | 246763217.5341261
2006-11-30 00:00:00 | 239681516.9583333 | -24169436 | -169278.9277777778 | 19997493.55465245 | -4171942.445347555 | -22453.16246628024 | 0 | 248217133.9392725
2006-12-31 00:00:00 | 240951108.9166667 | 0 | -169278.9277777778 | 969.6177171431482 | 0 | 0 | 0 | 241119418.2267273
2007-01-31 00:00:00 | 242220700.875 | 0 | -169278.9277777778 | 5400267.346797093 | 0 | 0 | 0 | 236989712.4559807
2007-02-28 00:00:00 | 243490292.8333333 | 0 | -169278.9277777778 | 11154683.55315799 | 0 | 0 | 0 | 232504888.2079531
2007-03-31 00:00:00 | 244759884.7916667 | 0 | -169278.9277777778 | 17082685.37422499 | 0 | 0 | 0 | 227846478.3452194
2007-04-30 00:00:00 | 245418526.75 | 0 | -169278.9277777778 | 22388203.65351544 | 0 | 0 | 0 | 223199602.0242623
2007-05-31 00:00:00 | 214499176.2083333 | -32055551.75 | -151493.4944444445 | 28049222.7011306 | -4006329.048869401 | -20866.29712952813 | 0 | 222684194.0976461
2007-06-30 00:00:00 | 215635377.4166667 | 0 | -151493.4944444445 | 0 | 0 | 0 | 0 | 215786870.9111111
2007-07-31 00:00:00 | 216771578.625 | 0 | -151493.4944444445 | 4081975.019994033 | 0 | 0 | 0 | 212841097.0994504
2007-08-31 00:00:00 | 217907779.8333333 | 0 | -151493.4944444445 | 8057488.772542129 | 0 | 0 | 0 | 210001784.5552357
2007-09-30 00:00:00 | 219043981.0416667 | 0 | -151493.4944444445 | 12190829.57345091 | 0 | 0 | 0 | 207004644.9626602
2007-10-31 00:00:00 | 219733232.25 | 0 | -151493.4944444445 | 16350228.50157919 | 0 | 0 | 0 | 203534497.2428652
2007-11-30 00:00:00 | 196076642.125 | -24695207.25 | -138482.2833333333 | 20434412.82360522 | -4260794.426394783 | -22931.35889205525 | 0 | 204759644.620015
2007-12-31 00:00:00 | 197115259.25 | 0 | -138482.2833333333 | 807.4302924536169 | 0 | 0 | 0 | 197252934.1030409
2008-01-31 00:00:00 | 198153876.375 | 0 | -138482.2833333333 | 5675275.722445943 | 0 | 0 | 0 | 192617082.9358874
2008-02-29 00:00:00 | 199192493.5 | 0 | -138482.2833333333 | 11719122.32956567 | 0 | 0 | 0 | 187611853.4537677
2008-03-31 00:00:00 | 200231110.625 | 0 | -138482.2833333333 | 17944221.9434469 | 0 | 0 | 0 | 182425370.9648864
2008-04-30 00:00:00 | 200581627.75 | 0 | -138482.2833333333 | 23713167.42032828 | 0 | 0 | 0 | 177006942.613005
2008-05-31 00:00:00 | 167714306.9583333 | -33755702.75 | -118450.9277777778 | 29660716.12471758 | -4094986.625282422 | -21328.05534001262 | 0 | 176044059.192016
2008-06-30 00:00:00 | 168602688.9166667 | 0 | -118450.9277777778 | 0 | 0 | 0 | 0 | 168721139.8444444
2008-07-31 00:00:00 | 169491070.875 | 0 | -118450.9277777778 | 4174070.116170671 | 0 | 0 | 0 | 165435451.6866071
2008-08-31 00:00:00 | 170379452.8333333 | 0 | -118450.9277777778 | 8238754.10514992 | 0 | 0 | 0 | 162259149.6559612
2008-09-30 00:00:00 | 171267834.7916667 | 0 | -118450.9277777778 | 12464284.32979383 | 0 | 0 | 0 | 158922001.3896506
2008-10-31 00:00:00 | 171658391.75 | 0 | -118450.9277777778 | 16715918.90985213 | 0 | 0 | 0 | 155060923.7679256
2008-11-30 00:00:00 | 147194790.1666667 | -25243291.75 | -103958.6888888889 | 20889407.69541904 | -4353884.054580964 | -23432.36209930727 | 0 | 156029949.3268168
2008-12-31 00:00:00 | 147974480.3333333 | 0 | -103958.6888888889 | 44.12310721725225 | 0 | 0 | 0 | 148078394.899115
2009-01-31 00:00:00 | 148754170.5 | 0 | -103958.6888888889 | 5794986.194423273 | 0 | 0 | 0 | 143063142.9944656
2009-02-28 00:00:00 | 149533860.6666667 | 0 | -103958.6888888889 | 11963381.56177091 | 0 | 0 | 0 | 137674437.7937846
2009-03-31 00:00:00 | 150313550.8333333 | 0 | -103958.6888888889 | 18318156.89579002 | 0 | 0 | 0 | 132099352.6264322
2009-04-30 00:00:00 | 150353191 | 0 | -103958.6888888889 | 24008207.83634739 | 0 | 0 | 0 | 126448941.8525415
2009-05-31 00:00:00 | 116691162.5833333 | -34280141 | -82415.01111111112 | 30088709.06825829 | -4191431.931741707 | -21830.37464448806 | 0 | 125178271.8325723
2009-06-30 00:00:00 | 117309275.1666667 | 0 | -82415.01111111112 | 0 | 0 | 0 | 0 | 117391690.1777778
2009-07-31 00:00:00 | 117927387.75 | 0 | -82415.01111111112 | 4272803.572942927 | 0 | 0 | 0 | 113736999.1881682
2009-08-31 00:00:00 | 118545500.3333333 | 0 | -82415.01111111112 | 8433075.619704505 | 0 | 0 | 0 | 110194839.7247399
2009-09-30 00:00:00 | 119163612.9166667 | 0 | -82415.01111111112 | 12757420.5746107 | 0 | 0 | 0 | 106488607.3531671
2009-10-31 00:00:00 | 119228700.5 | 0 | -82415.01111111112 | 17107909.83403205 | 0 | 0 | 0 | 102203205.6770791
2009-11-30 00:00:00 | 93896393.79166667 | -25829675.5 | -66315.83888888889 | 21377102.66884493 | -4452572.831155069 | -23963.4996121193 | 0 | 102891818.7924778
2009-12-31 00:00:00 | 94393762.58333333 | 0 | -66315.83888888889 | 288.6015446260571 | 0 | 0 | 0 | 94459789.82067758
2010-01-31 00:00:00 | 94891131.375 | 0 | -66315.83888888889 | 5924313.888175582 | 0 | 0 | 0 | 89033133.3257133
2010-02-28 00:00:00 | 95388500.16666667 | 0 | -66315.83888888889 | 12226146.77027734 | 0 | 0 | 0 | 83228669.23527822
2010-03-31 00:00:00 | 95885868.95833333 | 0 | -66315.83888888889 | 18714410.59803967 | 0 | 0 | 0 | 77237774.19918254
2010-04-30 00:00:00 | 95582187.75 | 0 | -66315.83888888889 | 24525077.35363264 | 0 | 0 | 0 | 71123426.23525624
2010-05-31 00:00:00 | 60878447.875 | -35026212.75 | -42996.38333333333 | 30739167.44484949 | -4287045.305150513 | -22328.36096432559 | 0 | 69517863.22959869
2010-06-30 00:00:00 | 61200920.75 | 0 | -42996.38333333333 | 0 | 0 | 0 | 0 | 61243917.13333333
2010-07-31 00:00:00 | 61523393.625 | 0 | -42996.38333333333 | 4371998.954617449 | 0 | 0 | 0 | 57194391.05371588
2010-08-31 00:00:00 | 61845866.5 | 0 | -42996.38333333333 | 8628301.298805403 | 0 | 0 | 0 | 53260561.58452793
2010-09-30 00:00:00 | 62168339.375 | 0 | -42996.38333333333 | 13051913.13020585 | 0 | 0 | 0 | 49159422.62812749
2010-10-31 00:00:00 | 61878712.25 | 0 | -42996.38333333333 | 17501704.4860571 | 0 | 0 | 0 | 44420004.14727624
2010-11-30 00:00:00 | 35648706.04166666 | -26418837.25 | -42996.38333333333 | 21867029.87656406 | -4551807.373435944 | -24497.57440564484 | 0 | 44819814.74627753
2010-12-31 00:00:00 | 35837537.08333334 | 0 | -42996.38333333333 | 425.5759741738439 | 0 | 0 | 0 | 35880107.89069249
2011-01-31 00:00:00 | 36026368.125 | 0 | -42996.38333333333 | 6043093.535737748 | 0 | 0 | 0 | 30026270.97259558
2011-02-28 00:00:00 | 36215199.16666666 | 0 | -42996.38333333333 | 12471130.64846154 | 0 | 0 | 0 | 23787064.90153846
2011-03-31 00:00:00 | 36404030.20833334 | 0 | -25177.47222222222 | 19089327.32575911 | 0 | 0 | 0 | 17339880.35479645
2011-04-30 00:00:00 | 35727986.25 | 0 | -25177.47222222222 | 25016358.77270395 | 0 | 0 | 0 | 10736804.94951828