Spreadsheet: 854414d1704297422-filter-function-how-to-condense-a-worksheet-after-filtering-condensing-filtered-data-setsv2-1-
Sheet: Summary

 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  | MORTGAGE
 |  | SEARCH (Any Field)
 |  |  |  |  | Δ FTP Rate
 | Segment | [NAME] | Previous Balance | Start | PIF / Matured | Update Balance | Update Product | Default FTP Rate | Override FTP Rate | Legacy Ftp Rate | Input -> Calc | Rate Type Change | Zero Coupon | Fixed Rate | Floating (No Reset) | Floating (Floored) | Floating | New Contracts | End | Current Balance | Δ Rate Total | Post PIF Balance | Update to Curr Balance | Interim Balance |  | RCMFTPRIPP | RCNFOTCT | WRBTCPB | UTCPP | ACCETNA | ITNA
113000 |  |  | 1936790974.425 | 0.0195729508175834
181000 |  | Mortgage | 21029666.425 | 0.0281366698777373 | 5.325668632926578e-05 | 6.911198042725344e-05 | 0 | 0 | 0 | 0 | -7.62980742884702e-06 | 0 | 0 | 8.867633544183876e-05 | 0 | 2.911222657129994e-07 | -7.052446980018427e-08 | 0 | 0.02834030567030273 | 20621235 | 0.0002036357925654238 | 20958065.31 | 20621235 | 20621235
 |  | Mortgage | 11176339.385 | 0.03029690599518314 | 4.622053560211087e-06 | -2.373570815912898e-05 | 0 | 3.891886233320808e-05 | 0 | 0 | -0.0001714859876133483 | 0 | 0 | 0 | 0 | 0 | 5.101493414988729e-06 | 0 | 0.0301503267087191 | 11075729.2 | -0.0001465792864640694 | 11160692.8 | 11075729.2 | 11075729.2
 |  | Mortgage | 47002308.795 | 0.02779518628893941 | 0 | 4.537110625977767e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.274790561490349e-05 | 0 | 0.0001170787355132822 | 0 | 0.02798038403632737 | 46528260.34 | 0.0001851977473879633 | 47002308.795 | 46528260.34 | 46528260.34
 |  | Mortgage | 1851497380.88 | 0.01912056158176747 | -3.321443578997024e-06 | -4.965727940065001e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.629497980677656e-07 | 2.919733488338792e-05 | 0 | 8.282038807926495e-07 | 0 | 0.01914246289881064 | 1841960571.665 | 2.190131704318631e-05 | 1850137501.98 | 1841960571.665 | 1841960571.665
 |  | Mortgage | 877140.545 | 0.04918487321525537 | 0 | -2.402058915426664e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.04918247115633994 | 877276.755 | -2.402058915426664e-06 | 877140.545 | 877276.755 | 877276.755
 |  | Mortgage | 5208138.395 | 0.04361472728124288 | -1.047409925407361e-05 | 3.317262786434183e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.04360757044477524 | 5204391.72 | -7.156836467639427e-06 | 5211417.215 | 5204391.72 | 5204391.72
 |  | Mortgage | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0
 |  | Coupon data SUMMARY | 318526287.4 | 0.05376509228982909
 |  | Mortgage | 21029666.425 | 0.0452798306267119 | 7.651407298900348e-06 | -1.566646890275442e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8.924320003142393e-05 | 0 | 0 | 0 | 0.04536105876513948 | 20621235 | 8.122813842756986e-05 | 20958065.31 | 20621235 | 20621235
 |  | Mortgage | 11176339.385 | 0.05505747711042688 | 2.825950724079374e-05 | 5.640342731469405e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05509137696039914 | 11075729.2 | 3.389984997226314e-05 | 11160692.8 | 11075729.2 | 11075729.2
 |  | Mortgage | 32148657.23 | 0.04730613404991596 | -4.859253603642366e-05 | 0.0001051461002883891 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.001357934009323609 | 0 | 1.103113803159729e-05 | 0 | 0.04873165276152308 | 31204114.925 | 0.001425518711607172 | 32105132.245 | 31204114.925 | 31204114.925
 |  | Mortgage | 2811800.245 | 0.08673430093312265 | 0 | 3.282211395311263e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0009451149234898918 | 0 | 0.0001628802175748694 | 0 | 0.0878455782855829 | 2800962.73 | 0.001111277352460072 | 2811800.245 | 2800962.73 | 2800962.73
 |  | Mortgage | 53642866.3 | 0.04754775866979707 | -6.056791616449592e-05 | 4.924711049318631e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -4.749700914954667e-06 | 0 | 0 | 0 | 0.04753168816321082 | 52402579.225 | -1.607050658626428e-05 | 52558751.305 | 52402579.225 | 52402579.225
 |  | Mortgage | 192364730.45 | 0.05674522594889457 | -0.0001413063737676912 | -0.0002741199352937138 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0004231848285619101 | 0.0008395657832620551 | 0.0002429723858361521 | 0 | 0.05783552263749345 | 188738171.605 | 0.001090296688598712 | 191145539.235 | 188738171.605 | 188738171.605
 |  | Mortgage | 5352227.365 | 0.06108635910621484 | 0 | 3.897798796156926e-07 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.06108674888609446 | 5329525.05 | 3.897798796156926e-07 | 5352227.365 | 5329525.05 | 5329525.05
 |  | Spread data SUMMARY | 1936790974.425 | 0.01452647084663772
 |  | Mortgage | 21029666.425 | 0.0171431607489746 | -4.560527903036543e-05 | -8.477844933000786e-05 | 0 | 0 | 0 | 0 | 7.62980742884702e-06 | 0 | 0 | -8.867633544183876e-05 | 8.924320003142393e-05 | -2.911222657129994e-07 | 7.052446980018427e-08 | 0 | 0.01702075309483676 | 20621235 | -0.0001224076541378539 | 20958065.31 | 20621235 | 20621235
 |  | Mortgage | 11176339.385 | 0.02476057111524374 | 2.363745368058265e-05 | 2.937605089059839e-05 | 0 | -3.891886233320808e-05 | 0 | 0 | 0.0001714859876133483 | 0 | 0 | 0 | 0 | 0 | -5.101493414988729e-06 | 0 | 0.02494105025168004 | 11075729.2 | 0.0001804791364363325 | 11160692.8 | 11075729.2 | 11075729.2
 |  | Mortgage | 47002308.795 | 0.01816873109547171 | 0 | -1.684720814797494e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9.049028901130939e-05 | 0 | 0.0002702187010681067 | 0 | 0.0185125928774033 | 46528260.34 | 0.0003438617819314411 | 47002308.795 | 46528260.34 | 46528260.34
 |  | Mortgage | 1851497380.88 | 0.01434429652044114 | 8.98265527089076e-07 | -2.84074797225059e-06 | 0 | 0 | 0 | 2.783448179547934e-05 | 0 | 0 | 0 | -1.629497980677656e-07 | 3.257051196289745e-05 | 0 | 1.670657378863629e-05 | 0 | 0.01441930265574494 | 1841960571.665 | 7.500613530378378e-05 | 1850137501.98 | 1841960571.665 | 1841960571.665
 |  | Mortgage | 877140.545 | 0.004605764823227963 | 0 | 8.012112886687794e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.004613776936114651 | 877276.755 | 8.012112886687794e-06 | 877140.545 | 877276.755 | 877276.755
 |  | Mortgage | 5208138.395 | 0.01556227409959313 | 1.649705578154331e-05 | -4.535254489221319e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01557423590088546 | 5204391.72 | 1.196180129232199e-05 | 5211417.215 | 5204391.72 | 5204391.72
 |  | Mortgage | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0