Planned Amortization Structure (PAC)
Inputs Mortgage Amount Coupon Rate Term PSA Band 1 PSA Band 2 $ 50,000.00 120. 10.0% 15.0% 5.0%
900.00000000 800.00000000 700.00000000 600.00000000 500.00000000 400.00000000 300.00000000 200.00000000 100.00000000 0.00000000 1 15
Monthly Coupon PSA 1 PSA 2
0. 43. 34. 0. 0. 0. 0.
Cash Flows ($)
on Structure (PAC)
CP1 CP2 PAC
15
29
43
57
71
85
99 113
Time (In months)
Decimal Results :
Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
8
BMB 50000.00000000 49779.06051145 49552.41021720 49320.07657230 49082.08851486 48838.47646152 48589.27230232 48334.50939508 48074.22255911 47808.44806844 47537.22364448 47260.58844807 46978.58307105 46691.24952722 46398.63124278 46100.77304620 45797.72115757 45489.52317737 45176.22807477 44857.88617534 44534.54914825 44206.26999292 43873.10302525 43535.10386321 43192.32941199 42844.83784865 42492.68860628 42135.94235761 41774.66099826 41408.90762938 41038.74653989 40667.18545841 40294.21030961 39919.80691780 39543.96100626 39166.65819653 38787.88400772 38407.62385584 38025.86305309 37642.58680720 37257.78022070 36871.42829028 36483.51590610
Payment 717.35474201 717.30308676 717.19977721 717.04482525 716.83825379 716.58009666 716.27039865 715.90921547 715.49661372 715.03267089 714.51747530 713.95112608 713.33373312 712.66541705 711.94630916 711.17655136 710.35629613 709.48570647 708.56495580 707.59422794 706.57371699 705.50362729 704.38417332 703.21557963 701.99808074 700.73192105 699.41735475 698.05464571 696.64406740 695.18590276 693.68044407 692.17807196 690.67877630 689.18254687 687.68937335 686.19924529 684.71215215 683.22808326 681.74702781 680.26897488 678.79391337 677.32183208 675.85271960
Interest 500.00000000 497.79060511 495.52410217 493.20076572 490.82088515 488.38476462 485.89272302 483.34509395 480.74222559 478.08448068 475.37223644 472.60588448 469.78583071 466.91249527 463.98631243 461.00773046 457.97721158 454.89523177 451.76228075 448.57886175 445.34549148 442.06269993 438.73103025 435.35103863 431.92329412 428.44837849 424.92688606 421.35942358 417.74660998 414.08907629 410.38746540 406.67185458 402.94210310 399.19806918 395.43961006 391.66658197 387.87884008 384.07623856 380.25863053 376.42586807 372.57780221 368.71428290 364.83515906
44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92
36094.02785110 35702.94880035 35310.26332033 34915.95586835 34520.01079183 34122.41232764 33723.14460153 33322.19162742 32919.53730681 32515.16542816 32109.05966630 31701.20358183 31291.58062053 30880.17411285 30466.96727333 30051.94320009 29635.08487436 29216.37515995 28795.79680290 28373.33243096 27948.96455330 27522.67556010 27094.44772229 26664.26319129 26232.10399878 25797.95205654 25361.78915641 24923.59697022 24483.35704985 24041.05082738 23596.65961528 23150.16460680 22701.54687637 22250.78738017 21797.86695687 21342.76632851 20885.46610154 20425.94676810 19964.18870749 19500.17218797 19033.87736875 18565.28430240 18094.37293764 17621.12312249 17145.51460801 16667.52705259 16187.14002688 15704.33301952 15219.08544382
674.38656439 672.92335470 671.46307861 670.00572401 668.55127854 667.09972966 665.65106456 664.20527019 662.76233323 661.32224007 659.88497680 658.45052919 657.01888266 655.59002226 654.16393265 652.74059809 651.32000236 649.90212879 648.48696019 647.07447881 645.66466634 644.25750381 642.85297158 641.45104929 640.05171579 638.65494906 637.26072619 635.86902326 634.47981529 633.09307610 631.70877828 630.32689301 628.94738999 627.57023725 626.19540103 624.82284560 623.45253305 622.08442308 620.71847276 619.35463623 617.99286440 616.63310458 615.27530006 613.91938961 612.56530700 611.21298027 609.86233109 608.51327382 607.16571452
360.94027851 357.02948800 353.10263320 349.15955868 345.20010792 341.22412328 337.23144602 333.22191627 329.19537307 325.15165428 321.09059666 317.01203582 312.91580621 308.80174113 304.66967273 300.51943200 296.35084874 292.16375160 287.95796803 283.73332431 279.48964553 275.22675560 270.94447722 266.64263191 262.32103999 257.97952057 253.61789156 249.23596970 244.83357050 240.41050827 235.96659615 231.50164607 227.01546876 222.50787380 217.97866957 213.42766329 208.85466102 204.25946768 199.64188707 195.00172188 190.33877369 185.65284302 180.94372938 176.21123122 171.45514608 166.67527053 161.87140027 157.04333020 152.19085444
93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120
14731.37664540 14241.18591120 13748.49247986 13253.27555400 12755.51431450 12255.18793738 11752.27561385 11246.75657408 10738.61011577 10227.81563860 9714.35268606 9198.20099684 8679.34056844 8157.75173688 7633.41527779 7106.31253646 6576.42559805 6043.73751447 5508.23261353 4969.89693151 4428.71883722 3884.68996666 3337.80668958 2788.07254920 2235.50264529 1680.13238214 1122.03783657 561.39672443
605.81954978 604.47466529 603.13093414 601.78821483 600.44634878 599.10515737 597.76443830 596.42396101 595.08346105 593.74263289 592.40112077 591.05850684 589.71429559 588.36789307 587.01857870 585.66546620 584.30744822 582.94311580 581.57063746 580.18757111 578.79055821 577.37479940 575.93309268 574.45390935 572.91706338 571.28216014 569.44815775 567.01069167
147.31376645 142.41185911 137.48492480 132.53275554 127.55514314 122.55187937 117.52275614 112.46756574 107.38610116 102.27815639 97.14352686 91.98200997 86.79340568 81.57751737 76.33415278 71.06312536 65.76425598 60.43737514 55.08232614 49.69896932 44.28718837 38.84689967 33.37806690 27.88072549 22.35502645 16.80132382 11.22037837 5.61396724
Amortized 217.35474201 219.51248165 221.67567503 223.84405953 226.01736864 228.19533205 230.37767563 232.56412152 234.75438813 236.94819020 239.14523885 241.34524160 243.54790241 245.75292178 247.95999673 250.16882089 252.37908456 254.59047469 256.80267506 259.01536619 261.22822551 263.44092736 265.65314307 267.86454100 270.07478662 272.28354256 274.49046869 276.69522214 278.89745742 281.09682646 283.29297867 285.50621737 287.73667321 289.98447770 292.24976329 294.53266333 296.83331207 299.15184470 301.48839728 303.84310680 306.21611117 308.60754918 311.01756054
Prepayment 3.58474654 7.13781260 10.65796987 14.14399791 17.59468470 21.00882714 24.38523161 27.72271445 31.02010254 34.27623376 37.48995756 40.66013543 43.78564142 46.86536266 49.89819985 52.88306774 55.81889564 58.70462790 61.53922437 64.32166091 67.05092982 69.72604031 72.34601897 74.90991022 77.41677672 79.86569981 82.25577998 84.58613721 86.85591146 89.06426302 88.26810281 87.46893143 86.66671860 85.86143385 85.05304645 84.24152548 83.42683980 82.60895805 81.78784862 80.96347970 80.13581925 79.30483500 78.47049446
Principal payment 220.93948855 226.65029425 232.33364490 237.98805744 243.61205334 249.20415919 254.76290724 260.28683597 265.77449067 271.22442397 276.63519641 282.00537702 287.33354383 292.61828444 297.85819658 303.05188864 308.19798020 313.29510260 318.34189943 323.33702710 328.27915532 333.16696767 337.99916204 342.77445122 347.49156334 352.14924238 356.74624866 361.28135935 365.75336889 370.16108948 371.56108148 372.97514880 374.40339181 375.84591154 377.30280973 378.77418881 380.26015188 381.76080275 383.27624590 384.80658650 386.35193042 387.91238418 389.48805500
EMB 49779.06051145 49552.41021720 49320.07657230 49082.08851486 48838.47646152 48589.27230232 48334.50939508 48074.22255911 47808.44806844 47537.22364448 47260.58844807 46978.58307105 46691.24952722 46398.63124278 46100.77304620 45797.72115757 45489.52317737 45176.22807477 44857.88617534 44534.54914825 44206.26999292 43873.10302525 43535.10386321 43192.32941199 42844.83784865 42492.68860628 42135.94235761 41774.66099826 41408.90762938 41038.74653989 40667.18545841 40294.21030961 39919.80691780 39543.96100626 39166.65819653 38787.88400772 38407.62385584 38025.86305309 37642.58680720 37257.78022070 36871.42829028 36483.51590610 36094.02785110
313.44628588 315.89386670 318.36044541 320.84616532 323.35117063 325.87560639 328.41961855 330.98335392 333.56696016 336.17058579 338.79438014 341.43849338 344.10307645 346.78828113 349.49425992 352.22116609 354.96915361 357.73837719 360.52899216 363.34115450 366.17502080 369.03074821 371.90849436 374.80841738 377.73067580 380.67542850 383.64283463 386.63305356 389.64624479 392.68256782 395.74218212 398.82524694 401.93192123 405.06236345 408.21673146 411.39518231 414.59787203 417.82495540 421.07658568 424.35291435 427.65409072 430.98026156 434.33157068 437.70815839 441.11016092 444.53770975 447.99093083 451.46994362 454.97486008
77.63276488 76.79161332 75.94700657 75.09891120 74.24729356 73.39211973 72.53335557 71.67096669 70.80491848 69.93517607 69.06170433 68.18446792 67.30343122 66.41855839 65.52981332 64.63715965 63.74056079 62.83997987 61.93537978 61.02672316 60.11397239 59.19708960 58.27603664 57.35077514 56.42126643 55.48747163 54.54935156 53.60686681 52.65997769 51.70864427 50.75282635 49.79248349 48.82757498 47.85805985 46.88389690 45.90504466 44.92146141 43.93310521 42.93993384 41.94190487 40.93897563 39.93110321 38.91824447 37.90035609 36.87739450 35.84931596 34.81607653 33.77763208 32.73393834
391.07905076 392.68548001 394.30745198 395.94507653 397.59846418 399.26772611 400.95297411 402.65432061 404.37187865 406.10576186 407.85608448 409.62296130 411.40650768 413.20683952 415.02407324 416.85832574 418.70971440 420.57835706 422.46437194 424.36787766 426.28899320 428.22783780 430.18453100 432.15919252 434.15194224 436.16290013 438.19218619 440.23992037 442.30622248 444.39121209 446.49500848 448.61773044 450.75949620 452.92042330 455.10062836 457.30022697 459.51933344 461.75806060 464.01651952 466.29481922 468.59306635 470.91136476 473.24981515 475.60851448 477.98755542 480.38702571 482.80700735 485.24757570 487.70879842
35702.94880035 35310.26332033 34915.95586835 34520.01079183 34122.41232764 33723.14460153 33322.19162742 32919.53730681 32515.16542816 32109.05966630 31701.20358183 31291.58062053 30880.17411285 30466.96727333 30051.94320009 29635.08487436 29216.37515995 28795.79680290 28373.33243096 27948.96455330 27522.67556010 27094.44772229 26664.26319129 26232.10399878 25797.95205654 25361.78915641 24923.59697022 24483.35704985 24041.05082738 23596.65961528 23150.16460680 22701.54687637 22250.78738017 21797.86695687 21342.76632851 20885.46610154 20425.94676810 19964.18870749 19500.17218797 19033.87736875 18565.28430240 18094.37293764 17621.12312249 17145.51460801 16667.52705259 16187.14002688 15704.33301952 15219.08544382 14731.37664540
458.50578333 462.06280618 465.64600935 469.25545929 472.89120563 476.55327800 480.24168216 483.95639527 487.69735989 491.46447651 495.25759391 499.07649688 502.92088991 506.79037571 510.68442593 514.60234084 518.54319224 522.50574065 526.48831133 530.48860180 534.50336984 538.52789973 542.55502579 546.57318386 550.56203692 554.48083632 558.22777939 561.39672443
31.68495088 30.63062516 29.57091651 28.50578021 27.43517149 26.35904554 25.27735761 24.19006303 23.09711728 21.99847604 20.89409531 19.78393152 18.66794165 17.54608339 16.41831541 15.28459757 14.14489135 12.99916029 11.84737068 10.68949250 9.52550072 8.35537735 7.17911459 5.99672006 4.80822622 3.61370925 2.41333275 1.20747898
490.19073421 492.69343133 495.21692586 497.76123951 500.32637712 502.91232353 505.51903977 508.14645830 510.79447717 513.46295254 516.15168922 518.86042840 521.58883155 524.33645910 527.10274133 529.88693840 532.68808359 535.50490094 538.33568201 541.17809429 544.02887056 546.88327708 549.73414038 552.56990391 555.37026315 558.09454557 560.64111214 562.60420341
14241.18591120 13748.49247986 13253.27555400 12755.51431450 12255.18793738 11752.27561385 11246.75657408 10738.61011577 10227.81563860 9714.35268606 9198.20099684 8679.34056844 8157.75173688 7633.41527779 7106.31253646 6576.42559805 6043.73751447 5508.23261353 4969.89693151 4428.71883722 3884.68996666 3337.80668958 2788.07254920 2235.50264529 1680.13238214 1122.03783657 561.39672443 -1.20747898
TP 720.93948855 724.44089936 727.85774707 731.18882316 734.43293849 737.58892381 740.65563026 743.63192992 746.51671626 749.30890465 752.00743286 754.61126150 757.11937454 759.53077971 761.84450901 764.05961910 766.17519177 768.19033437 770.10418018 771.91588885 773.62464681 775.22966760 776.73019230 778.12548985 779.41485746 780.59762086 781.67313472 782.64078293 783.49997887 784.25016578 781.94854688 779.64700339 777.34549491 775.04398072 772.74241980 770.44077077 768.13899196 765.83704130 763.53487643 761.23245457 758.92973262 756.62666708 754.32321406
BMB1 50000.00000000 49779.81104121 49554.65177891 49324.53915860 49089.49113029 48849.52664754 48604.66566632 48354.92914349 48100.33903505 47840.91829406 47576.69086834 47307.68169780 47033.91671152 46755.42282459 46472.22793454 46184.36091767 45891.85162488 45594.73087740 45293.03046212 44986.78312670 44676.02257436 44360.78345841 44041.10137654 43717.01286471 43388.55539094 43055.76734868 42718.68804995 42377.35771830 42031.81748135 41682.10936318 41328.27627642 40972.70467998 40615.37823197 40256.28046104 39895.39476535 39532.70441160 39168.19253406 38801.84213351 38433.63607630 38063.55709334 37691.58777905 37317.71059042 36941.90784595
Payment1 717.35474201 717.31390170 717.23222058 717.10970501 716.94636814 716.74222996 716.49731728 716.21166368 715.88530955 715.51830205 715.11069507 714.66254927 714.17393199 713.64491728 713.07558586 712.46602505 711.81632882 711.12659769 710.39693873 709.62746549 708.81829803 707.96956279 707.08139261 706.15392668 705.18731046 704.18169566 703.13724017 702.05410804 700.93246937 699.77250030 698.57438292 697.37817871 696.18388152 694.99148513 693.80098320 692.61236931 691.42563695 690.24077947 689.05779013 687.87666205 686.69738826 685.51996161 684.34437485
Interest1 500.00000000 497.79811041 495.54651779 493.24539159 490.89491130 488.49526648 486.04665666 483.54929143 481.00339035 478.40918294 475.76690868 473.07681698 470.33916712 467.55422825 464.72227935 461.84360918 458.91851625 455.94730877 452.93030462 449.86783127 446.76022574 443.60783458 440.41101377 437.17012865 433.88555391 430.55767349 427.18688050 423.77357718 420.31817481 416.82109363 413.28276276 409.72704680 406.15378232 402.56280461 398.95394765 395.32704412 391.68192534 388.01842134 384.33636076 380.63557093 376.91587779 373.17710590 369.41907846
752.01932927 749.71496802 747.41008518 745.10463521 742.79857210 740.49184939 738.18442013 735.87623689 733.56725172 731.25741614 728.94668114 726.63499711 724.32231388 722.00858065 719.69374597 717.37775774 715.06056315 712.74210866 710.42233997 708.10120197 705.77863873 703.45459340 701.12900822 698.80182443 696.47298222 694.14242069 691.81007775 689.47589007 687.13979297 684.80172037 682.46160463 680.11937650 677.77496497 675.42829710 673.07929793 670.72789025 668.37399446 666.01752828 663.65840660 661.29654110 658.93184003 656.56420779 654.19354453 651.81974570 649.44270150 647.06229624 644.67840762 642.29090590 639.89965286
36564.16172466 36184.45426509 35802.76736428 35419.08277675 35033.38211351 34645.64684104 34255.85828030 33863.99760571 33470.04584417 33073.98387404 32675.79242419 32275.45207299 31872.94324735 31468.24622176 31061.34111734 30652.20790087 30240.82638392 29827.17622191 29411.23691319 28992.98779824 28572.40805877 28149.47671692 27724.17263446 27296.47451204 26866.36088849 26433.81014008 25998.80047997 25561.30995754 25121.31645795 24678.79770162 24233.73124388 23786.09447464 23335.86461820 22883.01873313 22427.53371225 21969.38628281 21508.55300674 21045.01028109 20578.73433868 20109.70124893 19637.88691896 19163.26709494 18685.81736376 18205.51315507 17722.32974374 17236.24225276 16747.22565675 16255.25478606 15760.30433166
683.17062055 681.99869115 680.82857891 679.66027592 678.49377409 677.32906512 676.16614053 675.00499160 673.84560938 672.68798469 671.53210807 670.37796980 669.22555985 668.07486789 666.92588325 665.77859490 664.63299144 663.48906106 662.34679150 661.20617007 660.06718355 658.92981820 657.79405970 656.65989314 655.52730290 654.39627268 653.26678539 652.13882312 651.01236703 649.88739733 648.76389314 647.64183243 646.52119191 645.40194691 644.28407123 643.16753705 642.05231471 640.93837255 639.82567672 638.71419091 637.60387612 636.49469032 635.38658813 634.27952044 633.17343389 632.06827040 630.96396655 629.86045280 628.75765275
365.64161725 361.84454265 358.02767364 354.19082777 350.33382114 346.45646841 342.55858280 338.63997606 334.70045844 330.73983874 326.75792424 322.75452073 318.72943247 314.68246222 310.61341117 306.52207901 302.40826384 298.27176222 294.11236913 289.92987798 285.72408059 281.49476717 277.24172634 272.96474512 268.66360888 264.33810140 259.98800480 255.61309958 251.21316458 246.78797702 242.33731244 237.86094475 233.35864618 228.83018733 224.27533712 219.69386283 215.08553007 210.45010281 205.78734339 201.09701249 196.37886919 191.63267095 186.85817364 182.05513155 177.22329744 172.36242253 167.47225657 162.55254786 157.60304332
637.50450066 635.10529045 632.70185066 630.29399505 627.88152026 625.46420291 623.04179591 620.61402404 618.18057833 615.74110893 613.29521608 610.84243837 608.38223724 605.91397646 603.43689411 600.95006377 598.45233957 595.94227609 593.41800815 590.87706361 588.31605893 585.73017675 583.11220727 580.45062941 577.72528960 574.89586939 571.86149051 568.21817065
15262.34885090 14761.36277431 14257.32041361 13750.19597126 13239.96355166 12726.59717463 12210.07079133 11690.35830346 11167.43358634 10641.27051695 10111.84300809 9579.12505051 9043.09076519 8503.71446907 7960.97075854 7414.83461705 6865.28155620 6312.28780388 5755.83056099 5195.88836078 4632.44158746 4065.47325321 3494.97021739 2920.92521493 2343.34049996 1762.23511725 1177.66182913 589.75777226
627.65548204 626.55384726 625.45264450 624.35175768 623.25105649 622.15039395 621.04960333 619.94849440 618.84684871 617.74441360 616.64089463 615.53594569 614.42915606 613.32003312 612.20797896 611.09225784 609.97195020 608.84588575 607.71254291 606.56989256 605.41514394 604.24430886 603.05140271 601.82684598 600.55386674 599.19890549 597.67802582 595.65534998
152.62348851 147.61362774 142.57320414 137.50195971 132.39963552 127.26597175 122.10070791 116.90358303 111.67433586 106.41270517 101.11843008 95.79125051 90.43090765 85.03714469 79.60970759 74.14834617 68.65281556 63.12287804 57.55830561 51.95888361 46.32441587 40.65473253 34.94970217 29.20925215 23.43340500 17.62235117 11.77661829 5.89757772
Amortized1 217.35474201 219.51579129 221.68570279 223.86431342 226.05145684 228.24696349 230.45066062 232.66237225 234.88191920 237.10911911 239.34378639 241.58573229 243.83476487 246.09068904 248.35330651 250.62241588 252.89781257 255.17928892 257.46663411 259.75963423 262.05807229 264.36172820 266.67037885 268.98379803 271.30175655 273.62402217 275.95035968 278.28053086 280.61429456 282.95140667 285.29162016 287.65113191 290.03009920 292.42868052 294.84703554 297.28532520 299.74371161 302.22235813 304.72142936 307.24109112 309.78151047 312.34285571 314.92529639
Prepayment1 2.83421677 5.64347102 8.42691751 11.18371490 13.91302591 16.61401773 19.28586221 21.92773620 24.53882178 27.11830661 29.66538415 32.17925399 34.65912206 37.10420100 39.51371036 41.88687691 44.22293491 46.52112636 48.78070132 51.00091812 53.18104366 55.32035367 57.41813298 59.47367573 61.48628572 63.45527655 65.37997198 67.25970610 69.09382361 70.88168009 70.27997629 69.67531610 69.06767173 68.45701517 67.84331820 67.22655235 66.60668894 65.98369907 65.35755360 64.72822317 64.09567816 63.45988876 62.82082490
Principal payment1 220.18895879 225.15926230 230.11262031 235.04802832 239.96448275 244.86098122 249.73652283 254.59010844 259.42074098 264.22742572 269.00917054 273.76498628 278.49388694 283.19489004 287.86701687 292.50929279 297.12074748 301.70041528 306.24733542 310.76055234 315.23911594 319.68208188 324.08851182 328.45747377 332.78804227 337.07929872 341.33033165 345.54023695 349.70811817 353.83308675 355.57159644 357.32644801 359.09777093 360.88569569 362.69035374 364.51187755 366.35040055 368.20605721 370.07898296 371.96931429 373.87718863 375.80274447 377.74612129
317.52900330 320.15414850 322.80090527 325.46944815 328.15995295 330.87259671 333.60755773 336.36501554 339.14515094 341.94814595 344.77418383 347.62344907 350.49612738 353.39240568 356.31247208 359.25651589 362.22472760 365.21729884 368.23442237 371.27629208 374.34310296 377.43505103 380.55233336 383.69514802 386.86369401 390.05817128 393.27878059 396.52572354 399.79920245 403.09942032 406.42658070 409.78088769 413.16254573 416.57175957 420.00873411 423.47367422 426.96678464 430.48826974 434.03833333 437.61717842 441.22500693 444.86201937 448.52841450 452.22438889 455.95013645 459.70584788 463.49170998 467.30790494 471.15460943
62.17845626 61.53275231 60.88368226 60.23121509 59.57531951 58.91596403 58.25311686 57.58674600 56.91681919 56.24330390 55.56616737 54.88537657 54.20089821 53.51269875 52.82074439 52.12500105 51.42543441 50.72200988 50.01469258 49.30344739 48.58823889 47.86903143 47.14578905 46.41847554 45.68705439 44.95148884 44.21174183 43.46777605 42.71955387 41.96703743 41.21018853 40.44896875 39.68333934 38.91326130 38.13869533 37.35960185 36.57594101 35.78767267 34.99475641 34.19715154 33.39481709 32.58771181 31.77579419 30.95902244 30.13735453 29.31074813 28.47916071 27.64254946 26.80087133
379.70745957 381.68690081 383.68458753 385.70066324 387.73527247 389.78856074 391.86067459 393.95176154 396.06197013 398.19144985 400.34035120 402.50882564 404.69702559 406.90510443 409.13321647 411.38151695 413.65016202 415.93930872 418.24911495 420.57973947 422.93134185 425.30408246 427.69812241 430.11362355 432.55074840 435.00966012 437.49052243 439.99349959 442.51875633 445.06645774 447.63676924 450.22985644 452.84588508 455.48502088 458.14742944 460.83327607 463.54272565 466.27594241 469.03308975 471.81432997 474.61982402 477.44973118 480.30420869 483.18341133 486.08749098 489.01659601 491.97087069 494.95045440 497.95548076
475.03199353 478.94021952 482.87944037 486.84979796 490.85142097 494.88442220 498.94889542 503.04491137 507.17251284 511.33170843 515.52246455 519.74469518 523.99824840 528.28288843 532.59827137 536.94391167 541.31913464 545.72300771 550.15423730 554.61100896 559.09072806 563.58957633 568.10170054 572.61759383 577.12046174 581.57655432 585.90140753 589.75777226
25.95408306 25.10214118 24.24500199 23.38262163 22.51495606 21.64196110 20.76359246 19.87980575 18.99055655 18.09580043 17.19549303 16.28959013 15.37804771 14.46082211 13.53787011 12.60914918 11.67461768 10.73423518 9.78796291 8.83576436 7.87760619 6.91345949 5.94330193 4.96712114 3.98492097 2.99673380 2.00264935 1.00290082
500.98607659 504.04236070 507.12444236 510.23241959 513.36637703 516.52638330 519.71248787 522.92471712 526.16306939 529.42750886 532.71795758 536.03428532 539.37629612 542.74371054 546.13614148 549.55306085 552.99375232 556.45724289 559.94220021 563.44677332 566.96833425 570.50303582 574.04500247 577.58471497 581.10538271 584.57328812 587.90405687 590.76067308
EMB1 49779.81104121 49554.65177891 49324.53915860 49089.49113029 48849.52664754 48604.66566632 48354.92914349 48100.33903505 47840.91829406 47576.69086834 47307.68169780 47033.91671152 46755.42282459 46472.22793454 46184.36091767 45891.85162488 45594.73087740 45293.03046212 44986.78312670 44676.02257436 44360.78345841 44041.10137654 43717.01286471 43388.55539094 43055.76734868 42718.68804995 42377.35771830 42031.81748135 41682.10936318 41328.27627642 40972.70467998 40615.37823197 40256.28046104 39895.39476535 39532.70441160 39168.19253406 38801.84213351 38433.63607630 38063.55709334 37691.58777905 37317.71059042 36941.90784595 36564.16172466
TP1 720.18895879 722.95737272 725.65913810 728.29341990 730.85939405 733.35624770 735.78317949 738.13939988 740.42413133 742.63660866 744.77607923 746.84180325 748.83305405 750.74911829 752.58929622 754.35290196 756.03926373 757.64772405 759.17764004 760.62838361 761.99934169 763.28991646 764.49952559 765.62760242 766.67359618 767.63697221 768.51721215 769.31381414 770.02629298 770.65418039 768.85435921 767.05349481 765.25155325 763.44850030 761.64430140 759.83892166 758.03232589 756.22447854 754.41534373 752.60488522 750.79306642 748.97985038 747.16519975
CP1 0.75052977 1.48352665 2.19860897 2.89540326 3.57354444 4.23267611 4.87245077 5.49253004 6.09258493 6.67229599 7.23135363 7.76945825 8.28632048 8.78166142 9.25521279 9.70671713 10.13592804 10.54261032 10.92654013 11.28750524 11.62530512 11.93975114 12.23066671 12.49788744 12.74126128 12.96064865 13.15592257 13.32696879 13.47368589 13.59598539 13.09418767 12.59350858 12.09394165 11.59548042 11.09811840 10.60184911 10.10666607 9.61256276 9.11953270 8.62756935 8.13666620 7.64681671 7.15801431
36184.45426509 35802.76736428 35419.08277675 35033.38211351 34645.64684104 34255.85828030 33863.99760571 33470.04584417 33073.98387404 32675.79242419 32275.45207299 31872.94324735 31468.24622176 31061.34111734 30652.20790087 30240.82638392 29827.17622191 29411.23691319 28992.98779824 28572.40805877 28149.47671692 27724.17263446 27296.47451204 26866.36088849 26433.81014008 25998.80047997 25561.30995754 25121.31645795 24678.79770162 24233.73124388 23786.09447464 23335.86461820 22883.01873313 22427.53371225 21969.38628281 21508.55300674 21045.01028109 20578.73433868 20109.70124893 19637.88691896 19163.26709494 18685.81736376 18205.51315507 17722.32974374 17236.24225276 16747.22565675 16255.25478606 15760.30433166 15262.34885090
745.34907681 743.53144346 741.71226117 739.89149101 738.06909360 736.24502915 734.41925739 732.59173760 730.76242857 728.93128859 727.09827544 725.26334637 723.42645806 721.58756664 719.74662764 717.90359596 716.05842586 714.21107094 712.36148408 710.50961745 708.65542244 706.79884963 704.93984876 703.07836868 701.21435729 699.34776152 697.47852723 695.60659917 693.73192091 691.85443476 689.97408168 688.09080118 686.20453126 684.31520821 682.42276656 680.52713890 678.62825572 676.72604522 674.82043313 672.91134246 670.99869321 669.08240213 667.16238232 665.23854288 663.31078842 661.37901854 659.44312726 657.50300226 655.55852407
6.67025245 6.18352455 5.69782401 5.21314420 4.72947850 4.24682024 3.76516274 3.28449928 2.80482315 2.32612755 1.84840570 1.37165075 0.89585582 0.42101401 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000
14761.36277431 14257.32041361 13750.19597126 13239.96355166 12726.59717463 12210.07079133 11690.35830346 11167.43358634 10641.27051695 10111.84300809 9579.12505051 9043.09076519 8503.71446907 7960.97075854 7414.83461705 6865.28155620 6312.28780388 5755.83056099 5195.88836078 4632.44158746 4065.47325321 3494.97021739 2920.92521493 2343.34049996 1762.23511725 1177.66182913 589.75777226 -1.00290082
653.60956510 651.65598844 649.69764649 647.73437931 645.76601255 643.79235505 641.81319579 639.82830015 637.83740525 635.84021403 633.83638766 631.82553582 629.80720377 627.78085523 625.74584907 623.70140702 621.64656789 619.58012093 617.50050582 615.40565693 613.29275013 611.15776835 608.99470464 606.79396712 604.53878771 602.19563929 599.68067517 596.65825080
0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000
PAC 720.18895879 722.95737272 725.65913810 728.29341990 730.85939405 733.35624770 735.78317949 738.13939988 740.42413133 742.63660866 744.77607923 746.84180325 748.83305405 750.74911829 752.58929622 754.35290196 756.03926373 757.64772405 759.17764004 760.62838361 761.99934169 763.28991646 764.49952559 765.62760242 766.67359618 767.63697221 768.51721215 769.31381414 770.02629298 770.65418039 768.85435921 767.05349481 765.25155325 763.44850030 761.64430140 759.83892166 758.03232589 756.22447854 754.41534373 752.60488522 750.79306642 748.97985038 747.16519975
CP2 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000
745.34907681 743.53144346 741.71226117 739.89149101 738.06909360 736.24502915 734.41925739 732.59173760 730.76242857 728.93128859 727.09827544 725.26334637 723.42645806 721.58756664 719.69374597 717.37775774 715.06056315 712.74210866 710.42233997 708.10120197 705.77863873 703.45459340 701.12900822 698.80182443 696.47298222 694.14242069 691.81007775 689.47589007 687.13979297 684.80172037 682.46160463 680.11937650 677.77496497 675.42829710 673.07929793 670.72789025 668.37399446 666.01752828 663.65840660 661.29654110 658.93184003 656.56420779 654.19354453 651.81974570 649.44270150 647.06229624 644.67840762 642.29090590 639.89965286
0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.00000000 0.05288167 0.52583822 0.99786271 1.46896228 1.93914411 2.40841548 2.87678371 3.34425622 3.81084053 4.27654425 4.74137507 5.20534082 5.66844947 6.13070910 6.59212793 7.05271439 7.51247705 7.97142468 8.42956629 8.88691111 9.34346863 9.79924865 10.25426126 10.70851694 11.16202654 11.61480136 12.06685318 12.51819434 12.96883780 13.41879718 13.86808692 14.31672230 14.76471964 15.21209636 15.65887122
637.50450066 635.10529045 632.70185066 630.29399505 627.88152026 625.46420291 623.04179591 620.61402404 618.18057833 615.74110893 613.29521608 610.84243837 608.38223724 605.91397646 603.43689411 600.95006377 598.45233957 595.94227609 593.41800815 590.87706361 588.31605893 585.73017675 583.11220727 580.45062941 577.72528960 574.89586939 571.86149051 568.21817065
16.10506444 16.55069799 16.99579584 17.44038426 17.88449228 18.32815214 18.77139988 19.21427611 19.65682692 20.09910510 20.54117158 20.98309746 21.42496653 21.86687877 22.30895496 22.75134325 23.19422832 23.63784484 24.08249767 24.52859332 24.97669119 25.42759160 25.88249737 26.34333771 26.81349811 27.29976990 27.81918466 28.44008015
Explanation
This calculator demonstrates the cash flows in PAC bonds and companion bonds. PACs have a principle payment schedule that can be maintained over a range of prepayment rates. Taking the minimum of two schedules creates PAC redemption schedules.The two schedules correspond to the principal cash flows available from the underlying collateral when it is amortized at two prepayment rates knoen as PAC band.