ࡱ> 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% - Accent3H& 20% - Accent3 ef  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% - Accent3H' 40% - Accent3 L  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̜̙3f3333f3ffff333ff333f33f33BBB amort table ʓcalc  T 1Bzo_  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 5XB2-$@BC  C-A> a angle 1XBY~_?BC C-A> CC +G# Grouped Amortization SchedulesGGGGGGGG .G& for the Interest Maintenance ReserveGGGGGGGG FG0 for DB Gains and Losses#! for 2019 Gains and LossesGGGGGGGG MG 7 D = CdB%  Interest Rate = 4.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,CGz?Z,C@v?Z,C~jt?Z,CQ?Z,CS㥫?Z,CHzG?Z,CGz? Z, C?Z B?.LF@;CGz?%ZZ;C&1?%ZZ;CGz?%ZZ;CZd;?%ZZ;C"~j?%ZZ;CQ?%ZZ;C)\(? %ZZ; C%Z Z B@F@;C /$?%ZZ;CV-?%ZZ;CE?%ZZ;CMb?%ZZ;CV-?%ZZ;CS㥛 ?%ZZ;C %ZZ; C%Z Z B@F@;CI +?%ZZ;CQ?%ZZ;Cpt?%ZZ;Cx&?%ZZ;CQ?%ZZ;CCl?%ZZ;C %ZZ; C%Z Z B@F@;C`d;O?%ZZ;CMb?%ZZ;Cףp= ?%ZZ;CHl?%ZZ;C?%ZZ;Cx&1?%ZZ;C %ZZ; C%Z Z B@F@;Cjt?%ZZ;CMb?%ZZ;CMb?%ZZ;C8On?%ZZ;CS㥛?%ZZ;C~jt?%ZZ;C %ZZ; C%Z Z B@F@;C?%ZZ;C rh?%ZZ;Cjt?%ZZ;C033333?%ZZ;CQ?%ZZ;C%ZZ;C %ZZ; C%Z Z B@F@;C@v?%ZZ;CQ?%ZZ;C&1?%ZZ;C0?%ZZ;C~jt?%ZZ;C%ZZ;C %ZZ; C%Z Z B @F@;CS㥛?%ZZ;Cl?%ZZ;C@v?%ZZ;C ~j?%ZZ;CQ?%ZZ;C%ZZ;C %ZZ; C%Z Z B"@F@;CS㥛?%ZZ;C~jt?%ZZ;C \(?%ZZ;C/$?%ZZ;Ckt?%ZZ;C%ZZ;C %ZZ; C%Z Z B$@F@;C V-?%ZZ;CpGz?%ZZ;C&1?%ZZ;CI +?%ZZ;Cy&1?%ZZ;C%ZZ;C %ZZ; C%Z Z B&@F@;C`9v?%ZZ;CСE?%ZZ;CQ?%ZZ;C$~j?%ZZ;C%ZZ;C%ZZ;C %ZZ; C%Z Z B(@F@;C@9v?%ZZ;Cpt?%ZZ;CZd;?%ZZ;Cp= ף?%ZZ;C%ZZ;C%ZZ;C %ZZ; C%Z Z B*@F@;CP7A`?%ZZ;Cףp= ?%ZZ;CMb?%ZZ;CMb?%ZZ;C%ZZ;C%ZZ;C %ZZ; C%Z Z B,@Fğ@;C rh?%ZZ;C`d;O?%ZZ;CL7A`?%ZZ;Cx&1?%ZZ;C%ZZ;C%ZZ;C %ZZ; C%Z Z B.@Fȟ@;CQ?%ZZ;CH +?%ZZ;CQ?%ZZ;C{Gz?%ZZ;C%ZZ;C%ZZ;C %ZZ; C %Z Z D,l'qqILTO!L6666666666666 ! " # $ % & ' ( ) * + , - . / 0  B0@  F̟@ ; Cl? %ZZ ; C? %ZZ ; CMb? %ZZ ; C %ZZ ; C %ZZ ; C %ZZ ; C %ZZ ; C!%Z Z !B1@!!FП@!;!C~jt?!%Z Z!;!C8v?!%Z Z!;!C&1?!%Z Z!;!C!%Z Z!;!C!%Z Z!;!C!%Z Z!;!C! %Z Z!;! C"%Z Z! "B2@""Fԟ@";"CxGz?"%Z!Z";"C(\(?"%Z!Z";"Cl?"%Z!Z";"C"%Z!Z";"C"%Z!Z";"C"%Z!Z";"C" %Z!Z";" C#%Z! Z" #B3@##F؟@#;#C /$?#%Z"Z#;#Cv/?#%Z"Z#;#CI +?#%Z"Z#;#C#%Z"Z#;#C#%Z"Z#;#C#%Z"Z#;#C# %Z"Z#;# C$%Z" Z# $B4@$$Fܟ@$;$Cht?$%Z#Z$;$Ch|?5?$%Z#Z$;$CMb?$%Z#Z$;$C$%Z#Z$;$C$%Z#Z$;$C$%Z#Z$;$C$ %Z#Z$;$ C%%Z# Z$ %B5@%%F@%;%Cףp= ?%%Z$Z%;%CS㥫?%%Z$Z%;%C%%Z$Z%;%C%%Z$Z%;%C%%Z$Z%;%C%%Z$Z%;%C% %Z$Z%;% C&%Z$ Z% &B6@&&F@&;&CMb?&%Z%Z&;&CI +?&%Z%Z&;&C&%Z%Z&;&C&%Z%Z&;&C&%Z%Z&;&C&%Z%Z&;&C& %Z%Z&;& C'%Z% Z& 'B7@''F@';'C~jt?'%Z&Z';'CY9v?'%Z&Z';'C'%Z&Z';'C'%Z&Z';'C'%Z&Z';'C'%Z&Z';'C' %Z&Z';' C(%Z& Z' (B8@((F@(;(C&1?(%Z'Z(;(C~jt?(%Z'Z(;(C(%Z'Z(;(C(%Z'Z(;(C(%Z'Z(;(C(%Z'Z(;(C( %Z'Z(;( C)%Z' Z( )B9@))F@);)C8v?)%Z(Z);)Cy&1|?)%Z(Z);)C)%Z(Z);)C)%Z(Z);)C)%Z(Z);)C)%Z(Z);)C) %Z(Z);) C*%Z( Z) *B:@**F@(*;*CL +?*%Z)Z*;*C*%Z)Z*;*C*%Z)Z*;*C*%Z)Z*;*C*%Z)Z*;*C*%Z)Z*;*C* %Z)Z*;* C+%Z) Z* +B;@++F@(+;+C+?+%Z*Z+;+C+%Z*Z+;+C+%Z*Z+;+C+%Z*Z+;+C+%Z*Z+;+C+%Z*Z+;+C+ %Z*Z+;+ C,%Z* Z+ ,B<@,,F@(,;,Cx&1?,%Z+Z,;,C,%Z+Z,;,C,%Z+Z,;,C,%Z+Z,;,C,%Z+Z,;,C,%Z+Z,;,C, %Z+Z,;, C-%Z+ Z, -B=@--F@(-;-C rh?-%Z,Z-;-C-%Z,Z-;-C-%Z,Z-;-C-%Z,Z-;-C-%Z,Z-;-C-%Z,Z-;-C- %Z,Z-;- C.%Z, Z- .B>@..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?0 00 C?0 0&#@666666666666666=%F8X>     T 4H  dMbP?_*+%&A&?'?(?)?MHP LaserJet 4Si0 0,@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 2019 Gains and LossesGGGGGGGG [G E Z  = C)dB%  Interest Rate = 4.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@ZDCGz?FLL0@ LL1@ ]L0@LC5L0@LCcA?L0@L1@CL1@LL2@BBL3@AC/$?C1Zd?C ףp= ?CʡE?CGz?C)\(?~  CF?.L-F@ZDC ףp= ?C㥛 ?C&1?CJ +?CQ?CQ?C~  CF@-F@ZDC|?5^?C(\?C?C ףp= ?C5^I ?CZd;O?C~  CF@-F@ZDCDl?C?CCl?CL7A`?C^I +?C333333?C~  CF@-F@ZDC!rh?C-?CCl?C㥛 ?CtV?C~jt?C~  CF@-F@ZDC)\(?Cn?C{Gz?CMb?CʡE?CC~  CF@-F@ZDC\(\?CDl?Cl?CCl?C%C?CC~  CF@-F@ZDCI +?C%C?CZd;O?C`"?CK7A?CC~  CF @-F@ZDCDl?C\(\?CS?Cn?Cv/?CC~  CF"@-F@ZDC?C/$?CS?C"~j?Cy&1?CC~  CF$@-F@ZDCZd;?#FLL0@ LL1@ ]L0@LC5L0@LCcA?L0@L1@CL1@LL2@BBL3@ACw/?Cjt?C rh?CCC~  CF&@-F@ZDCzG?CZd;O?C'1Z?C333333?CCC~  CF(@-F@ZDCS?CV-?C r?C(\µ?CCC~  CF*@-F@ZDCE?C#~j?C'1Z?C~jt?CCC~  CF,@-Fğ@ZDCX9v?CI +?CT㥛 ?C{Gz?CCC~  CF.@-Fȟ@ZDC9v?C1Zd?CK?CCCC ~  C F0@ - F̟@ ZD  Cq= ףp?  Cx&1?  Ch|?5?  C  C  C  C!~ C!F1@!-!FП@!ZD!!CMbX9?!!Cw/?!!Cx&?!!C!!C!!C!!C"~ ! C"F2@"-"Fԟ@"ZD""CS?""CMbX?""CQ?""C""C""C""C#~ " C#F3@#-#F؟@#ZD##C333333?##C1Zd?##CMb?##C##C##C##C$~ # C@t!DILTOM7777777777777777$ % & ' ( ) * + , - . / 0 1 2 3 $F4@$-$Fܟ@$ZD$$C r?$$$.MLL0@ LL1@ ]L0@LC5L0@LCcA?L0@L1@CL1@LL2@BBL3@A$Cףp= ?$$$C$$$C$$$C$$$C$$$C%$~ $ C%F5@%-%F@%ZD%%C rh?%$%CB`"۹?%$%C%$%C%$%C%$%C%$%C&$~ % C&F6@&-&F@&ZD&&C(\?&$&Cv/?&$&C&$&C&$&C&$&C&$&C'$~ & C'F7@'-'F@'ZD''C`"?'$'C9v?'$'C'$'C'$'C'$'C'$'C($~ ' C(F8@(-(F@(ZD((C r?($(Cy&1|?($(C($(C($(C($(C($(C)$~ ( C)F9@)-)F@)ZD))Cn?)$)C)$)C)$)C)$)C)$)C)$)C*$~ ) C*F:@*-*F@*ZD**C ףp= ?*$*C*$*C*$*C*$*C*$*C*$*C+$~ * C+F;@+-+F@+ZD++C&1?+$+C+$+C+$+C+$+C+$+C+$+C,$~ + C,F<@,-,F@,ZD,,CZd;O?,$,C,$,C,$,C,$,C,$,C,$,C-$~ , C-F=@---F@-ZD--C~jtx?-$-C-$-C-$-C-$-C-$-C-$-C.$~ - C.F>@.-.F@.ZD..C.$.C.$.C.$.C.$.C.$.C.$.C2$~ . C /CC 00B>@B9@B4@B.@B$@B@L?0 C01B9@B4@B.@B$@B@B?L1 C2B2-$@22Y22OC L0@L1@C:A2B2-$@222B2-$@222B2-$@222B2-$@222B"U @222BY~_?323B$ @33M33CL0@L1@CL1@L2@C73B\F@333B{[@333B6~v]b@333B먯?333B%q?333BL+7ѣ?333 C$p,7777777777>>6=%F8X>  Oh+'0HP`x оٷFleming, DaveMicrosoft Excel@"0@}Tx@Q0 ՜.+,0 0 8@ H   amort tablecalcANN1ANN5IDISC'amort table'!Print_Areacalc!Print_Area'amort table'!Print_Area_MIPRN  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdeghijklmopqrstuRoot EntryFBook _SummaryInformation(fDocumentSummaryInformation8n