ࡱ>  7\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,>Arial1>Arial1>Arial1>Arial1 Arial1Arial1?Arial1h>Cambria1Arial1 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 @7 6  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 23  60% - Accent5H0 60% - Accent5 23 ! 60% - Accent6H4 60% - Accent6  23  "Accent1<Accent1 O  #Accent2<!Accent2 PM  $Accent3<%Accent3 Y  %Accent4<)Accent4 d  &Accent5<-Accent5 K  'Accent6<1Accent6  F (Bad4Bad  ) Calculation| Calculation  }  * Check Cellz Check Cell  ????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextB5Explanatory Text 0Good6Good  a 1 Heading 1B Heading 1 I}O 2 Heading 2B Heading 2 I}? 3 Heading 3B Heading 3 I}23 4 Heading 44 Heading 4 I}5InputpInput ̙ ??v 6 Linked CellF Linked Cell } 7Neutral<Neutral  e"Normal8Noteb Note   9OutputrOutput  ???????????? ???:$Percent;Title1Title I}%<TotalHTotal OO= Warning Text: Warning Text 8 ``i̜̙3f3333f3ffff333ff333f33f33BBB amort table calc 7 1COp4  dMbP?_*+%D  KB&?'?(?)?M оٷ Laser 1402D!C odXXLetter`DINU"XIj48SMTJHP LaserJet M5035 MFP PCL 6InputBinFORMSOURCERESDLLUniresDLLResolution600dpiFastResFalseOrientationPORTRAITHPOrientRotate180FalseDuplexNONEPaperSizeLETTERHPPaperSizeALMConstraintsEXECUTIVE_JISAlternateLetterHeadFalseRETChoiceTrueHPPaperSizeDuplexConstraintsSTATEMENTMediaTypeAutoEconomodeFalseTextAsBlackFalseTTAsBitmapsSettingTTModeOutlineHPXMLFileUsedhpc50356.xmlPrintQualityGroupPQGroup_3HPPCL6PassThroughTrueCollateONOutputBinAutoStaplingNoneHPDocPropResourceDatahpzhl43e.cabHPColorModeMONOCHROME_MODEHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNTHPBornOnDateHPBODHPJobByJobOverrideJBJOJRConstraintsJRCHDPartialJRHDInstalledJRHDOffHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPManualFeedOrientationFACEDOWNHPOutputBinOrientationFACEDOWNHPManualDuplexPageOrderEvenPagesFirstHPMapManualFeedToTray1FalseHPPrintOnBothSidesManuallyFalseHPCoversFirst_PageHPDuplicateJobNameOverrideSWFWPSAlignmentFilehpzls43ePSServicesOptionPrnStat_SID_242_BID_497_HID_15521PSServices_DeviceandSuppliesStatusTRUEHPSmartHubInet_SID_263_BID_514_HID_265HPSmartHub_OnlinediagnostictoolsTRUEHPSmartHub_SupportandtroubleshootingTRUEHPSmartHub_P< roductmanualsTRUEHPSmartHub_CheckfordriverupdatesTRUEHPSmartHub_ColorprintingaccessusageTRUEHPSmartHub_OrdersuppliesTRUEHPSmartHub_ShowmehowTRUEHPConsumerCustomPaperTrueHPPreAnalysisTrueHPManualDuplexDialogModelModelessHPLpiSelectionNoneXIUPHdLetter o [none] [none]Arial< 4Pd?DFLEMING<Automatic>R 44< dMicrosoft Excel EXCEL.EXEC:\Program Files\Microsoft Office\Office14\EXCEL.EXE<b"_XX??calcU}  ? 1                                  >Year~ @t@> 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 2013 Gains and LossesGGGGGGGG MG 7 D = C dB%  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 ~ BFt@. DL,CMb?Z,Cjt?Z,C rh?Z,C&1?Z,C@v?Z,C/$?Z,CV-? Z, C?Z B?.LFx@;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?%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?0 00 C?0&#@666666666666666=%F8X>  7 4  dMbP?_*+%&A&?'?(?)?MHP LaserJet 4Si0@w XX%%sLosse@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 2013 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-Ft@ZDCX9v?FLL0@ LL1@ ]L0@LC5 L0@LCc A?L0@L1@C L1@LL2@BBL3@ACV-?C~jt?Cv?CtV?CX9v?Cx&1?~  CF?.L-Fx@ZDC^I +?C +?CʡE?Csh|??CzG?C +?C~  CF@-F|@ZDCd;O?Cjt?CuV?CK?C$C?C/$?C~  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= ף?CC~  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@LC5 L0@LCc A?L0@L1@C L1@LL2@BBL3@ACDl?CS㥛?C +?CCC~  CF&@-F@ZDC-?CMb?CV-?Cjt?CCC~  CF(@-F@ZDC7A`?C ףp= ?CDl?C ףp= ?CCC~  CF*@-F@ZDCm?C?C/$?C{Gz?CCC~  CF,@-F@ZDC#~j?Cjt?C/$?C{Gz?CCC~  CF.@-F@ZDCS?CuV?CE?CCCC ~  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@LC5 L0@LCc A?L0@L1@C L1@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@.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 C2Buָ@22Y22OC  L0@L1@C: A2Buָ@222Buָ@222Buָ@222Buָ@222Bٞ @222Bڿ9?323B5 @33M33CL0@L1@C L1@L2@C7@ 3BD{ @333BuD@333B&7g@333Bp2?333B!?333Bpl?33 C$p,7777777777>>6=%F8X>  Oh+'0= PXh оٷFleming, DaveMicrosoft Excel@ x|@}Tx@ [|G<# Z &" WMFC +lW) EMF+ @F, EMF+@``F\PEMF+"@ @ $@ 0@?!@ @     !" !" !  " !  X" !  X" !  X'%    &% #6#% Ld###!??% 6$% Ld##!??% !6$!% Ld!#!!#!??% 26$2% Ld2#22#!??% C6$C% LdC#CC#!??% T6$T% LdT#TT#!??% e6$e% Lde#ee#!??% v6$v% Ldv#vv#!??% 6$% Ld##!??% 6$% Ld##!??% 6$% Ld##!??% 6$% Ld##!??% 6$% Ld##!??% #6X% Ld#W#5!??% #6#% Ld###!??% p6p% Ldppp!??% 6% Ld!??%  6 % Ld   !??% W6W% LdWWW!??'%  Ld""!??%  % 6#% Ld""!??% 6% Ld!??'%  ( &% 6#% Ld"!!??% 6% Ld!??'% % 6#% Ld"!!??% "6"% Ld"""!??!b K!; $$==V(Xx$$AA<C  % '% % V0   % % ( % " " RpCourier t0](0lh0ܿ0tc0N  0 P0Tims New Roman\'0 %tMj9dv%  666  TTAALP1eeTT$0AA$LP2eeTT5AAA5LP3eeTTFRAAFLP4eeTTWcAAWLP5eeTThtAAhLP6eeTTyAAyLP7eeTTAALP8eeTTAALP9eeTX AA LP10TX AA LP11TTFMAAFLPAeeTTAALPBeeTTAALPCeeTT-4AA-LPDee% % " !%   666$XRpTimes New Roman t0](0lh0ܿ0tc0N  0 P0Aril\'0@ %tMj9dv%     Td&= AA&LTYearRpTimes New Roman t0](0lh0ܿ0tc0N  0 P0Tims New Roman\'0@ %tMj9dv%  Td AALT2013 % T&#i1AA&# Lh& WMFC +Interest Rateee%  Tl#1AA#LX5.00%ee  % T&4TBAA&4 L`a angle 5ee@Td4BAA4LT4.43T&ETSAA&E L`a angle 1 QTdESAAELT0.98T AAlg#L Grouped Amortization SchedulesD T0AAex&L for the Interest Maintenance Reserve TAAz!L for 2013 Gains and Losses\TAAL Interest Rate = 5.00% T|?mAA?L\Duration TAALCalendar Years to Maturity % " !%   X' %   ( &% 6X% LdWX!??% 6% Ld!??% " Q|WP(xX( F4(EMF+*@$??FEMF+@   X  '' ' ,X' ,X' ,X-  -##- @ !#-$- @ !#-!!$- @ !#!-22$- @ !#2-CC$- @ !#C-TT$- @ !#T-ee$- @ !#e-vv$- @ !#v-$- @ !#-$- @ !#-$- @ !#-$- @ !#-$- @ !#-#X- @ !5#-##- @ !#-pp- @ !p-- @ !-  - @ ! -WW- @ !W-  @ !"- -#- @ !"-- @ !- -#- @ !!-- @ !--#- @ !!-""- @ !",,        ---$  ---''Courier- 666 2 1V 2 $2V 2 53V 2 F4V 2 W5V 2 h6V 2 y7V 2 8V 2 9V 2 10 2 11 2 FAV 2 BV 2 CV 2 -DV-"System- '- 666,X$Times New Roman-    2 &YearTimes New Roman-   2 2013 - 2 #& Interest Rate-  2 #5.00%i  - 2 4& a angle 5R@ 2 44.432 E& a angle 1RQ 2 E0.98<2 gl# Grouped Amortization Schedules @2 xe& for the Interest Maintenance Reserve 92 z! for 2013 Gains and Lossess42  Interest Rate = 5.00% 2 ?Duration .2 Calendar Years to Maturity - '-  ,X-  -X- @ !X-- @ !-'#A X(՜.+,0 0 8@ H   amort tablecalcANN1ANN5IDISC'amort table'!Print_Areacalc!Print_Area'amort table'!Print_Area_MIPRN  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdeghijklmnopqrstuvwxyz{|}~Root EntryFBook 4SummaryInformation(f=DocumentSummaryInformation8