ࡱ>   T\p Fleming, Dave B amort tablecalc/ __123Graph_A;.8__123Graph_ASCHEDULES;./ __123Graph_B;.8__123Graph_BSCHEDULES;./ __123Graph_C;.8__123Graph_CSCHEDULES;./ __123Graph_D;.8__123Graph_DSCHEDULES;./ __123Graph_E;.8__123Graph_ESCHEDULES;./ __123Graph_F;.8__123Graph_FSCHEDULES;./ __123Graph_X;.8__123Graph_XSCHEDULES;.(_Fill;. $ANN1:$ANN5:%IDISC:$ ;0 $ ;4 0 Print_Area_MI;0 &PRN;.=%F8X@"1Courier1Arial1Arial1Arial1Arial1Times New Roman1 Times New Roman1Courier1Arial1 Arial1Arial1 Arial1 Arial1Arial1Arial1,9Arial19Arial19Arial1>Arial1 Arial1Arial1?Arial1h9Cambria1Arial1 Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.00_)0_)0.0%                                          A.I.  + ) , *    @q @Y X  A.I.    A,I,  A~I~   qp !       # "  &  & " "  "   20% - Accent1H 20% - Accent1 ef  20% - Accent2H" 20% - Accent2 ef  20% - Accent3<& 20% - Accent3  20% - Accent4<* 20% - Accent4  20% - Accent5H. 20% - Accent5 ef  20% - Accent6H2 20% - Accent6  ef  40% - Accent1H 40% - Accent1 L  40% - Accent2H# 40% - Accent2 L˭  40% - Accent3<' 40% - Accent3  40% - Accent4H+ 40% - Accent4 L  40% - Accent5H/ 40% - Accent5 L  40% - Accent6H3 40% - Accent6  L  60% - Accent1H 60% - Accent1 23  60% - Accent2H$ 60% - Accent2 23  60% - Accent3H( 60% - Accent3 23  60% - Accent4H, 60% - Accent4 23f  60% - Accent5H0 60% - Accent5 23 ! 60% - Accent6H4 60% - Accent6  23Ў  "Accent1<Accent1 Dr  #Accent2<!Accent2 }1  $Accent3<%Accent3   %Accent4<)Accent4   &Accent5<-Accent5 [  'Accent6<1Accent6  pG (Bad4Bad  ) Calculation| Calculation  }  * Check Cellz Check Cell  ????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextB5Explanatory Text 0Good6Good  a 1 Heading 1B Heading 1 DTjDr 2 Heading 2B Heading 2 DTj? 3 Heading 3B Heading 3 DTj23 4 Heading 44 Heading 4 DTj5InputpInput ̙ ??v 6 Linked CellF Linked Cell } 7Neutral<Neutral  e"Normal8Noteb Note   9OutputrOutput  ???????????? ???:$Percent;Title,Title DTj<TotalHTotal DrDr= Warning Text: Warning Text 8 ``i̜̙3f3333f3ffff333ff333f33f33BBBn amort table calc  T 1BboG  dMbP?_*+%D  KB&?'?(?)?M оٷ Laser 1402t C odXXLetter`DINU"0 QU0 SMTJ < IUPH%xAkA/* QǢZQMl Ci&ReBz_"G?WZ ٰ&JL[{3!;o޼9[MHQ4zx/r mda?J1+n5LiWsQx' ?!,zn.t"ϙ)h a^AUY.VP*O:d2܃}exM)Q52))Yu袔WMd} Q.'I\uɜ&dZxBHH @]9S[e<nN#kzT8nگh s%g蔬ׄL:fx-7D/O"YJ~m@ׇه>ϝ-3:ϳձϰچ\>X]Ȱޗ*+ޱĖ?ꕴ6o4.;,6%)̲*ݱᲹ,ѲⱹY/O*WRP>}qÁOlK!!р8< < <"_XX??calcU}  ? 1                                  >Year~ @@> Interest Rate~ A@> a angle 5XBuָ@BC  C-A> a angle 1XBڿ9?BC C-A> CC +G# Grouped Amortization SchedulesGGGGGGGG .G& for the Interest Maintenance ReserveGGGGGGGG FG0 for DB Gains and Losses#! for 2023 Gains and LossesGGGGGGGG MG 7 D = CdB%  Interest Rate = 5.00%GGGGGGGG CC  DDuration" GCalendar Years to Maturity GGGGGGGG  DFrom! H (Residential Mortgages) HHHHHHHH  DCurrent CC  DYearend E Yearend) E Z   over 25) E Z 21-25) E Z 16-20) E Z 11-15) E Z 6-10) E Z 2-5) E Z 1 E0)BZ )BZ B)EZ (21-30))E0Z (11-20))E0Z(3-10))E) Z(1-2)) E)Z (0) CC ~ BF@ . DL,CMb?%Z,Cjt?Z,C rh?Z,C&1?Z,C@v?.Z,C/$?Z,CV-?Z, C?Z B?.LF@ ;C@On?%ZZ;Cjt?%ZZ;Cl?+%ZZ;CV-?%ZZ;CS㥻?%ZZ;Cn?,%ZZ;Cx&1?%ZZ; C%Z Z B@F@ ;C@On? %ZZ;C@v? %ZZ;C~jt?%ZZ;CZd;?-%ZZ;C rh?%ZZ;Cx&1?)%ZZ;C%ZZ; C%Z Z B@F@ ;C~jt?$%ZZ;C`&1?%ZZ;CGz?(%ZZ;CMb?0%ZZ;CX9v?%ZZ;C[d;O?%ZZ;C%ZZ; C%Z Z B@F@ ;C /$?%ZZ;C&1?%ZZ;C /$?&%ZZ;Cx&?$%ZZ;CT㥛 ?%ZZ;C rh?$%ZZ;C%ZZ; C%Z Z B@F@ ;C /$?!%ZZ;CQ?%ZZ;Cףp= ?!%ZZ;CQ?%ZZ;CS㥛?%ZZ;C+?%%ZZ;C%ZZ; C%Z Z B@F@ ;CI +?%ZZ;CMb?%ZZ;C`d;O?%ZZ;C833333?(%ZZ;Crh|?%ZZ;C%ZZ;C.%ZZ; C%Z Z B@F@ ;Cjt?%ZZ;C@7A`?%ZZ;C@ +?-%ZZ;C(?%ZZ;CJ +?#%ZZ;C%ZZ;C)%ZZ; C%Z Z B @F@ ;Cjt?%ZZ;CQ?)%ZZ;C@v?-%ZZ;C$~j?%ZZ;CV-?,%ZZ;C*%ZZ;C%ZZ; C%Z Z B"@F@ ;C v?%ZZ;C@On?)%ZZ;CS㥫?%ZZ;Cht? %ZZ;CI +?!%ZZ;C%ZZ;C%ZZ; C%Z Z B$@Fğ@ ;CS㥛?%ZZ;C ?&%ZZ;Cp&1?%ZZ;CK?%ZZ;CQ?%ZZ;C%ZZ;C!%ZZ; C%Z Z B&@Fȟ@ ;C V-?%ZZ;CGz?"%ZZ;CQ?$%ZZ;C/$?-%ZZ;C%ZZ;C%ZZ;C%ZZ; C%Z Z B(@F̟@ ;CQ?"%ZZ;C /$?%ZZ;CT㥛 ?%ZZ;Cx&?%ZZ;C%%ZZ;C#%ZZ;C%ZZ; C%Z Z B*@FП@ ;C@9v?)%ZZ;Cףp= ?*%ZZ;Cp= ף?%ZZ;C?%ZZ;C"%ZZ;C%ZZ;C%ZZ; C%Z Z B,@Fԟ@ ;C rh?%ZZ;CMb?%ZZ;CQ?(%ZZ;CQ?'%ZZ;C(%ZZ;C%ZZ;C(%ZZ; C%Z Z B.@F؟@ ;C rh?(%ZZ;CH +?%ZZ;C@..F @. ;.C~jtx?'%Z-Z.;.C'%Z-Z.;.C*%Z-Z.;.C,%Z-Z.;.C#%Z-Z.;.C-%Z-Z.;.C.%Z-Z.;. C0 %Z- Z.  /CC 0C?0000  - 0C?000C?000C?000C?000C?000C?@900 C?0&#@666666666666666=%F8X>   T 4|0  dMbP?_*+%&A&?'?(?)?M оٷ Laser 14020{t C odXXLetter%%LosseDINU"0 QU0 SMTJ < IUPH%xAkA/* QǢZQMl Ci&ReBz_"G?WZ ٰ&JL yL2d͛yzK3)"BPbnЖB,,]'_ #cVZǔ~%<.|d|'$E<9b B x>8ؘ&Ob5b񤳧&=ؗS²ƶ-ܳ,ߟއ.tSIҟ<Inʧ=Y$L:; for ZB Gains and Losses#! for 2023 Gains and LossesGGGGGGGG [G E Z  = C)dB%  Interest Rate = 5.00%GGGGGGGG  DDuration" GCalendar Years to Maturity GGGGGGGG  DFrom! G (Residential Mortgages) GGGGGGGG  DCurrent DYearend EYearend- E  over D1B  over 25: E $D1B-D0B21-25: E $D1B-D0B16-20: E $D1B-D0B11-15: E $D1B-D0B6-10: E $D1B-D0B2-5 E1 I0J E  E EK(21-30)K(11-20)K(3-10) E(1-2)  E(0)~ F-F@ZDCX9v?#FLL0@ LL1@ ]L0@LC5L0@LCcA?L0@L1@CL1@LL2@BBL3@ACV-?C~jt?Cv?CtV?CX9v?Cx&1?~  CF?.L-F@ZDC^I +?C +?CʡE?Csh|??CzG?C +?C~  CF@-F@ZDCd;O?Cjt?CuV?+CK?C$C?C/$?C@9~  CF@-F@ZDCCl?CQ?C-?Csh|??C~jt?C~jt?"C~  CF@-F@ZDCZd;O?CMbX9?C;On?Cv?C +?C+?C~  CF@-F@ZDCp= ף?C$C?CˡE?Cw/?CX9v?CC~  CF@-F@ZDCV-?C= ףp=?CQ?,CX9v?Cv/?CC~  CF@-F@ZDC^I +?Cv/?(CʡE?CV-?Cp= ף?C)C~  CF @-F@ZDCffffff?CMb?C}?5^I?Cn?Ch|?5?*CC~  CF"@-F@ZDC rh?Cx?C(\?,Csh|??CQ?CC(~  CF$@-Fğ@ZDCNbX9?#FLL0@ LL1@ ]L0@LC5L0@LCcA?L0@L1@CL1@LL2@BBL3@ACDl?CS㥛?C +?CCC~  CF&@-Fȟ@ZDC-?CMb?-CV-?Cjt?CCC~  CF(@-F̟@ZDC7A`?!C ףp= ?)CDl? C ףp= ?!C!C(C ~  CF*@-FП@ZDCm?(C?!C/$?C{Gz?'C'C!C~  CF,@-Fԟ@ZDC#~j?"Cjt?C/$?C{Gz?$C"C C~  CF.@-F؟@ ZDCS? CuV? CE?C#C CC~  C F0@ - Fܟ@!ZD  CX9v? C|?5^?& CT㥛 ?$ C% C% C% C$~ C!F1@!-!F@"ZD!!Csh|??)!CʡE?%!C;On?!C(!C(!C!C~ ! C"F2@"-"F@#ZD""CZd;?"C9v?#"CL7A`?!"C"C"C#"C~ " C#F3@#-#F@$ZD##Cv/?$#C rh?$#CMb?"#C#C#C$#C"~ # C@t!DILTOM7777777777777777$ % & ' ( ) * + , - . / 0 1 2 3 $F4@$-$F@%ZD$$CM?'$$.MLL0@ LL1@ ]L0@LC5L0@LCcA?L0@L1@CL1@LL2@BBL3@A$C/$?'$$C$$C&$$C&$$C&$$C$~ $ C%F5@%-%F@&ZD%%CK?&$%CCl?$%C$%C)$%C#$%C-$%C%$~ % C&F6@&-&F@'ZD&&C)\(?*$&CX9v?*$&C#$&C*$&C.$&C*$&C&$~ & C'F7@'-'F@(ZD''CL7A`?+$'Cy&1?+$'C#$'C$'C+$'C+$'C'$~ ' C(F8@(-(F@)ZD((Cn?,$(Cy&1|?,$(C+$(C,$(C,$(C$(C!$~ ( C)F9@)-)F@*ZD))C~jt?-$)C$)C%$)C-$)C-$)C'$)C)$~ ) C*F:@*-*F@+ZD**CMbX?.$*C.$*C&$*C.$*C$*C.$*C*$~ * C+F;@+-+F@,ZD++Cv/?$+C$+C'$+C $+C)$+C$+C-$~ + C,F<@,-,F@-ZD,,C9v?$,C$,C.$,C+$,C$,C$,C($~ , C-F=@---F@.ZD--C~jtx?%$-C"$-C)$-C"$-C$$-C$-C-$~ - C.F>@.-.F @2ZD..C$.C$.C*$.C$.C$.C,$.C.$~ . C /CC 00B>@B9@B4@B.@B$@B@L?0 C01B9@B4@B.@B$@B@B?L1 C2Buָ@32Y22OC L0@L1@C:A2Buָ@322Buָ@222Buָ@322Buָ@322Bٞ @322Bڿ9?323B5 @23M33CL0@L1@CL1@L2@C73BD{ @233BuD@333B&7g@233Bp2?233B!?233Bpl?33 C$p,7777777777>>6=%F8X>  Oh+'0HP`x оٷFleming, DaveMicrosoft Excel@li@}Tx@Y ՜.+,0 0 8@ H   amort tablecalcANN1ANN5IDISC'amort table'!Print_Areacalc!Print_Area'amort table'!Print_Area_MIPRN  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuwxyz{|}Root EntryFBook SummaryInformation(vDocumentSummaryInformation8~