ࡱ> wv  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 HP Universal Printing PCL 6InputBinFORMSOURCERESDLLUniresDLLHPDocUISUITrueESPRITSupportedTrueFastRes8bppResolution600dpiPrintQualityGroupPQGroup_11DryTime0Saturation0BlackInkSpreaddefaultHPColorSmartAutomaticHPColorSmart_ColorOptions_EdgeControlNormalHPColorSmart_ColorOptions_HalftoneNoCmdHPColorSmart_Text_NeutralGraysBlackOnlyHPColorSmart_Text_HalftoneDetailHPColorSmart_Text_RGBColorNoCmdHPColorSmart_Graphics_NeutralGraysBlackOnlyHPColorSmart_Graphics_HalftoneDetailHPColorSmart_Graphics_RGBColorNoCmdHPColorSmart_Photo_NeutralGrays4-ColorHPColorSmart_Photo_HalftoneDetailHPColorSmart_Photo_RGBColorNoCmdOrientationPORTRAITHPOrientRotate180FalseDuplexNONEHPPrintOnBothSidesManuallyFalsePaperSizeLETTERHPConsumerCustomPaperTrueMediaTypeAUTOCollateONHPNUseDiffFirstPageChoiceTRUEHPPageExceptionsFileHPCPE210HPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsCoverInsertionHPOutputBinOrientationFACEDOWNPunchingNoneStaplingNoneHPStaplingOpposedFalseEconomodeFalseTextAsBlackFalseAlternateLetterHeadFalseHPSmartHubInet_SID_263_BID_514_HID_265PCFoldingNoneEdgeToEdge_PCFALSEOutputBinAutoSHOutputBinAutoSHPunchingNoneSHFold< ingNoneHPDocPropResourceDatahpchl210.cabHPLpiSelectionNoneJPEGEnableAutoHPEasyColorOnHPMHDLLNameHPFIE210HP_DIBStitch_TintTestDisabledHPMediaTypeTreeviewPopupTrueHPColorModeCOLOR_MODEColorMode24bppTTAsBitmapsSettingTTModeOutlineHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_GROUPNAMEHPBornOnDateHPBODHPColorPlaneHPCPHPInkPdlGrayScaleNoCmdSHRightEdgeStaplPunchRightStaplPunchHPJobByJobOverrideJBJOHPJobAccWoPinTrueHPXMLFileUsedhpcu2106.xmlHPUDMDataMapFilehpcu2106dm.xmlHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPDuplicateJobNameOverrideSWFWHPEnableRAWSpoolingTrueRGBColorDefault-sRGBOutputProfileSHDefaultSHFrontCoverInsertionNoneSHBackCoverInsertionNoneJRConstraintsJRCHDFullJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffHPBestGlossDefaultPSAlignmentFileHPCLS210HPManualDuplexFirstHalfRotateTRUEPaperSizeDefaultForLocaleEuropeanIUPH%xOAǿKCT8Q1+ &vBM$% BOO=ofvlڥI~?3;od޼yGv0 Iŀߩ~| uy3?`_Dk+rR|Gs~OwE^>T~-*_{nҞo} K(%(|InSG*~bɚV퓢i_+xla&= 0Lcf8k˚Nal09~z2vUǀ{wy7' !B!B?* {h< < <"_XX??calcU}  ? 1                                  >Year~ @@> Interest Rate~ A@> a angle 5XB.t@BC  C-A> a angle 1XB*;?BC C-A> CC +G# Grouped Amortization SchedulesGGGGGGGG .G& for the Interest Maintenance ReserveGGGGGGGG FG0 for DB Gains and Losses#! for 2020 Gains and LossesGGGGGGGG MG 7 D = CdB%  Interest Rate = 3.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,Cjt?Z,CQ?#Z,C /$?Z,CMb?Z,C&1?0Z,CK7?-Z,CX9v?Z, C?Z B?.LF@ ;C`d;O?%ZZ;C`9v?%ZZ;CI +?(%ZZ;Cp= ף? %ZZ;Cv/?%ZZ;CCl?%ZZ;CT㥛 ? %ZZ; C%Z Z B@F@ ;Cjt?"%ZZ;C@7A`?'%ZZ;CI +?%ZZ;Cx&?#%ZZ;Ch|?5?%ZZ;CMb?*%ZZ;C%ZZ; C%Z Z B@F@ ;C?,%ZZ;CP7A`?.%ZZ;C`d;O?%ZZ;C@l?%ZZ;CZd;?%ZZ;CCl?.%ZZ;C%ZZ; C%Z Z B@F@ ;C@v?.%ZZ;C rh?"%ZZ;C~jt?%ZZ;CV-?%ZZ;C?%ZZ;C"~j?%ZZ;C%ZZ; C%Z Z B@F@ ;CS㥛?%ZZ;CQ?%ZZ;Cjt?%%ZZ;Cज़ ?%ZZ;CPn?%ZZ;Cl?%ZZ;C$%ZZ; C%Z Z B@F@ ;CS㥛?%ZZ;Cl?%ZZ;C&1?&%ZZ;C~jt?'%ZZ;CX9v?'%ZZ;C%ZZ;C#%ZZ; C%Z Z B@F@ ;C`&1?%ZZ;Cl?%ZZ;C0v?%ZZ;C0?%ZZ;CMb?%ZZ;C&%ZZ;C%ZZ; C%Z Z B @F@ ;CQ?%ZZ;C~jt?%ZZ;CA`"?%ZZ;CxGz?%ZZ;C rh?!%ZZ;C%ZZ;C!%ZZ; C%Z Z B"@F@ ;CQ?%%ZZ;CpGz?!%ZZ;C \(?,%ZZ;Cth|??*%ZZ;CˡE?%ZZ;C!%ZZ;C(%ZZ; C%Z Z B$@F@ ;CQ?%ZZ;CСE?.%ZZ;Cv/?%ZZ;C(\µ?%ZZ;Cy&1?%ZZ;C%ZZ;C%ZZ; C%Z Z B&@F@ ;CMb?%ZZ;C /$? %ZZ;CV-?$%ZZ;C,?%ZZ;C%ZZ;C%ZZ;C+%ZZ; C%Z Z B(@F@ ;CP7A`?%ZZ;C`t?(%ZZ;CQ? %ZZ;CV9v?)%ZZ;C*%ZZ;C%ZZ;C %ZZ; C%Z Z B*@Fğ@ ;C rh?%ZZ;Cףp= ?'%ZZ;CX9v?"%ZZ;C ףp= ?%ZZ;C%ZZ;C#%ZZ;C+%ZZ; C%Z Z B,@Fȟ@ ;C rh?%ZZ;CXd;O?%ZZ;CMb?!%ZZ;CS㥛?%ZZ;C%ZZ;C%ZZ;C)%ZZ; C%Z Z B.@F̟@ ;C0On?%ZZ;CMb?)%ZZ;CJ7A`?)%ZZ;C;On?%ZZ;C-%ZZ;C)%ZZ;C*%ZZ; C %Z Z D,l'qqILTO!L6666666666666 ! " # $ % & ' ( ) * + , - . / 0  B0@  FП@ ; Cl?%ZZ ; CP +?%ZZ ; CQ?'%ZZ ; C!%ZZ ; C%ZZ ; C*%ZZ ; C$%ZZ ; C!%Z Z !B1@!!Fԟ@! ;!C~jt?(%Z Z!;!C&1?%%Z Z!;!C~jt?%Z Z!;!C.%Z Z!;!C(%Z Z!;!C%%Z Z!;!C%Z Z!;! C"%Z Z! "B2@""F؟@" ;"C(?*%Z!Z";"C&1?%Z!Z";"CQ?.%Z!Z";"C+%Z!Z";"C%Z!Z";"C%Z!Z";"C%%Z!Z";" C#%Z! Z" #B3@##Fܟ@# ;#CȡE?%Z"Z#;#CS㥫?*%Z"Z#;#C/$?%Z"Z#;#C&%Z"Z#;#C+%Z"Z#;#C(%Z"Z#;#C&%Z"Z#;# C$%Z" Z# $B4@$$F@$ ;$CСE? %Z#Z$;$C,\(?#%Z#Z$;$Cy&1|?%Z#Z$;$C0%Z#Z$;$C%Z#Z$;$C,%Z#Z$;$C%Z#Z$;$ C%%Z# Z$ %B5@%%F@% ;%Cht?"%Z$Z%;%C&1?$%Z$Z%;%C#%Z$Z%;%C$%Z$Z%;%C%Z$Z%;%C%Z$Z%;%C%Z$Z%;% C&%Z$ Z% &B6@&&F@& ;&CI +? %Z%Z&;&C+?%Z%Z&;&C%Z%Z&;&C)%Z%Z&;&C%Z%Z&;&C%Z%Z&;&C%Z%Z&;& C'%Z% Z& 'B7@''F@' ;'C\d;O?$%Z&Z';'CV-?%Z&Z';'C+%Z&Z';'C%Z&Z';'C%%Z&Z';'C%Z&Z';'C,%Z&Z';' C(%Z& Z' (B8@((F@( ;(C\d;O?%Z'Z(;(C@..F@. ;.C{Gzt?+%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?0 000  - 0C?000C?000C?000C?00C?000C?000 C?0&#@666666666666666=%F8X>   T 40  dMbP?_*+%&A&?'?(?)?MHP LaserJet 4Si0@w XX%%Losse@MSUDOHP LaserJet 4Si<d "_XX?? amort tableU}  ?bl 4                            ! " # ?Calculations Page+G# Grouped Amortization SchedulesGGGGGGGG .G& for the Interest Maintenance ReserveGGGGGGGG TG> for ZB Gains and Losses#! for 2020 Gains and LossesGGGGGGGG [G E Z  = C)dB%  Interest Rate = 3.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@ZDCV-?-FLL0@ LL1@ ]L0@LC5L0@LCcA?L0@L1@CL1@LL2@BBL3@ACQ?CS?C`"?Ch|?5?CV-?CT㥛 ?~  CF?.L-F@ZDCzG?CI +?CQ?CL7A`?"C(\?"C9v?C~  CF@-F@ZDC&1?CFx?CPn?Cn?CbX9?Cv/?)C~  CF@-F@ZDCZd;O?C"~j?C ףp= ?C%C?CzG?+Cl?C~  CF@-F@ZDC{Gz?CS?C/$?CʡE?C(\?Cl?C~  CF@-F@ZDCV-?3Ch|?5?C+?CV-?C/$?CC~  CF@-F@ZDCn?C/$?CtV?C/$?C-?CC~  CF@-F@ZDCB`"?.Cףp= ?Cy&1?Cjt?Crh|?CC!~  CF @-F@ZDCL7A`?C9v?(C`"?CL7A`?C)\(?C C~  CF"@-F@ZDCV-?CMbX?CK7?C/$?Cy&1?CC~  CF$@-F@ZDC`"?#FLL0@ LL1@ ]L0@LC5L0@LCcA?L0@L1@CL1@LL2@BBL3@ACx&1?CbX9?(C}?5^I?CCC)~  CF&@-F@ZDCʡE?C㥛 ?COn?CM?CCC~  CF(@-F@ZDCL7A`?!CZd;O?-CZd;? C#~j?)CC(C ~  CF*@-Fğ@ZDC+?CX9v?!C$C?"C;On? CC!C(~  CF,@-Fȟ@ZDCQ?"C?"CtV?)C;On?$C"C"C"~  CF.@-F̟@ ZDC rh?Cn?&CS?%C#C C#C#~  C F0@ - FП@!ZD  CMb? C-?$ C"~j?$ C C% C$ C$~ C!F1@!-!Fԟ@"ZD!!CtV?)!C1Zd?%!CT㥛 ?.!C'!C !C!C'~ ! C"F2@"-"F؟@#ZD""Cףp= ?"CT㥛 ?)"Cy&1?#"C%"C"C%"C%~ " C#F3@#-#Fܟ@$ZD##CK7?#CMbX?#Cy&1|?'#C#C#C-#C,~ # C@t!DILTOM7777777777777777$ % & ' ( ) * + , - . / 0 1 2 3 $F4@$-$F@%ZD$$Cd;O?!$$.MLL0@ LL1@ ]L0@LC5L0@LCcA?L0@L1@CL1@LL2@BBL3@A$CM?.$$C$$C&$$C$$C$$C$~ $ C%F5@%-%F@&ZD%%Cףp= ?$%CZd;O?$%C&$%C+$%C)$%C&$%C&$~ % C&F6@&-&F@'ZD&&C/$?#$&CA`"?'$&C!$&C*$&C$$&C'$&C$~ & C'F7@'-'F@(ZD''C)\(?&$'C~jt?$'C+$'C,$'C&$'C.$'C+$~ ' C(F8@(-(F@)ZD((CʡE?'$(C~jtx?,$(C-$(C$(C#$(C,$(C.$~ ( C)F9@)-)F@*ZD))C?-$)C*$)C*$)C-$)C%$)C+$)C*$~ ) C*F:@*-*F@+ZD**C#~j?,$*C+$*C,$*C$*C'$*C$*C$~ * C+F;@+-+F@,ZD++CZd;O?$$+C$+C$+C($+C*$+C$+C$~ + C,F<@,-,F@-ZD,,C/$?+$,C $,C$,C.$,C($,C$,C-$~ , C-F=@---F@.ZD--C{Gzt?*$-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 C2B.t@22Y22OC L0@L1@C:A2B.t@322B.t@322B.t@322B.t@222BK*@322B*;?323B՜BY@3M33CL0@L1@CL1@L2@C73Boe/@233B֜@233B<5-L?233B,?33B@Z61?233B] ?333 C$p,7777777777>>6=%F8X>  Oh+'0HP`x ̳Fleming, DaveMicrosoft Excel@"0@}Tx@>>R ՜.+,0 0 8@ H   amort tablecalcANN1ANN5IDISC'amort table'!Print_Areacalc!Print_Area'amort table'!Print_Area_MIPRN  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdeghijklmopqrstuRoot EntryF@@?RBook GSummaryInformation(fDocumentSummaryInformation8n