ࡱ> ^] ~$\p Dan Swanson 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@"1`Courier1`Arial1`Arial1`Arial1`Arial1`Times New Roman1 `Times New Roman"$"#,##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%                + ) , *  !       # "  &  & " "  "  8 ``i̜̙3f3333f3ffff333ff333f33f33BBB amort table bcalc ~$ 1 B:'^  dMbP?_*+%D  KBMHP LaserJet 4Si@w XXYG050\Y`YtY]0@MSUDOHP LaserJet 4Si<d "_XX??calcU}   1                                  Year~ `@ Interest Rate~ @ a angle 5X/P@ BC , C-,A a angle 1Xh? BC ,C-,A  +# Grouped Amortization Schedules .& for the Interest Maintenance Reserve F 0 for DB Gains and Losses#! for 2008 Gains and Losses MP$7 D = C,dB%  Interest Rate = 6.00%   Duration" Calendar Years to Maturity   From!  (Residential Mortgages)   Current   Yearend  Yearend)  Z   over 25)  Z 21-25)  Z 16-20)  Z 11-15)  Z 6-10)  Z 2-5)  Z 1 0) Z ) Z ) Z (21-30)) Z (11-20)) Z(3-10)) Z(1-2)) $ Z (0)  ~ `@ . DL,&1|? 0Z,Gz? 0Z,Mb? 0Z,@v? 0Z,? 0Z,L7A`? 0Z,Zd;O? 0Z, ?  Z ?.Ld@;Q? %ZZ;I +? %ZZ;P7A`? %ZZ; \(? %ZZ;zG? %ZZ;Dl? %ZZ;MbX9? %ZZ;   %Z Z @h@;Mb? %ZZ;`d;O? %ZZ;Q? %ZZ; V-? %ZZ;"~j? %ZZ;x&1? %ZZ; %ZZ;   %Z Z @l@;Mb? %ZZ;? %ZZ;~jt? %ZZ;Zd;? %ZZ;h|?5? %ZZ;Gz? %ZZ; %ZZ;   %Z Z @p@; On? %ZZ;@v? %ZZ;0? %ZZ;p= ף? %ZZ;? %ZZ;p= ףp? %ZZ; %ZZ;   %Z Z @t@;~jt? %ZZ;S㥛? %ZZ;/$? %ZZ;@l? %ZZ;/$? %ZZ;+? %ZZ; %ZZ;   %Z Z @x@;Gz? %ZZ;Q? %ZZ;ףp= ? %ZZ;l? %ZZ;V9v? %ZZ; %ZZ; %ZZ;   %Z Z @|@; /$? %ZZ;@9v? %ZZ;jt? %ZZ;(? %ZZ;? %ZZ; %ZZ; %ZZ;   %Z Z  @@;`d;O? %ZZ;P7A`? %ZZ;? %ZZ;̡E? %ZZ;䥛 ? %ZZ; %ZZ; %ZZ;   %Z Z "@@;jt? %ZZ;Q? %ZZ;A`"? %ZZ;I +? %ZZ;Zd;O? %ZZ; %ZZ; %ZZ;   %Z Z $@@;? %ZZ;l? %ZZ;v/? %ZZ;+η? %ZZ;Q? %ZZ; %ZZ; %ZZ;   %Z Z &@@;S㥛? %ZZ; ? %ZZ;Q? %ZZ;ʡE? %ZZ; %ZZ; %ZZ; %ZZ;   %Z Z (@@;&1? %ZZ; /$? %ZZ;T㥛 ? %ZZ;Q? %ZZ; %ZZ; %ZZ; %ZZ;   %Z Z *@@;`9v? %ZZ;I +? %ZZ; rh? %ZZ;&1? %ZZ; %ZZ; %ZZ; %ZZ;   %Z Z ,@@(;Mb? %ZZ;Mb? %ZZ;8On? %ZZ;Mb? %ZZ; %ZZ; %ZZ; %ZZ;   %Z Z .@ @(; rh? %ZZ;? %ZZ;~jt? %ZZ;I +? %ZZ; %ZZ; %ZZ; %ZZ;  %Z Z D,l'qqILTO!L6666666666666 ! " # $ % & ' ( ) * + , - . / 0  0@! @(; @On? !%ZZ ; A`"? !%ZZ ; V-? !%ZZ ;  !%ZZ ;  !%ZZ ;  !%ZZ ;  !%ZZ ;  ! %Z Z !1@"!@( ;!~jt? "%Z Z!;!x&1? "%Z Z!;!v/? "%Z Z!;! "%Z Z!;! "%Z Z!;! "%Z Z!;! "%Z Z!;!  " %Z Z! "2@#"@(!;"E? #%Z!Z";"h|?5? #%Z!Z";"/$? #%Z!Z";" #%Z!Z";" #%Z!Z";" #%Z!Z";" #%Z!Z";"  # %Z! Z" #3@$#@(";#pt? $%Z"Z#;#T㥛 ? $%Z"Z#;#:v? $%Z"Z#;# $%Z"Z#;# $%Z"Z#;# $%Z"Z#;# $%Z"Z#;#  $ %Z" Z# $4@%$@(#;$Xd;O? %%Z#Z$;$x&? %%Z#Z$;$;On? %%Z#Z$;$ %%Z#Z$;$ %%Z#Z$;$ %%Z#Z$;$ %%Z#Z$;$  % %Z# Z$ %5@&%@($;%~jt? &%Z$Z%;%T㥛 ? &%Z$Z%;% &%Z$Z%;% &%Z$Z%;% &%Z$Z%;% &%Z$Z%;% &%Z$Z%;%  & %Z$ Z% &6@'&@(%;&8v? '%Z%Z&;&? '%Z%Z&;& '%Z%Z&;& '%Z%Z&;& '%Z%Z&;& '%Z%Z&;& '%Z%Z&;&  ' %Z% Z& '7@('@(&;'S㥫? (%Z&Z';'l? (%Z&Z';' (%Z&Z';' (%Z&Z';' (%Z&Z';' (%Z&Z';' (%Z&Z';'  ( %Z& Z' (8@)(@(';(V-? )%Z'Z(;(Zd;O? )%Z'Z(;( )%Z'Z(;( )%Z'Z(;( )%Z'Z(;( )%Z'Z(;( )%Z'Z(;(  ) %Z' Z( )9@*)ğ@((;)X9v? *%Z(Z);)Mb? *%Z(Z);) *%Z(Z);) *%Z(Z);) *%Z(Z);) *%Z(Z);) *%Z(Z);)  * %Z( Z) *:@+*ȟ@();*V-? +%Z)Z*;* +%Z)Z*;* +%Z)Z*;* +%Z)Z*;* +%Z)Z*;* +%Z)Z*;* +%Z)Z*;*  + %Z) Z* +;@,+̟@(*;+Zd;O? ,%Z*Z+;+ ,%Z*Z+;+ ,%Z*Z+;+ ,%Z*Z+;+ ,%Z*Z+;+ ,%Z*Z+;+ ,%Z*Z+;+  , %Z* Z+ ,<@-,П@(+;, rh? -%Z+Z,;, -%Z+Z,;, -%Z+Z,;, -%Z+Z,;, -%Z+Z,;, -%Z+Z,;, -%Z+Z,;,  - %Z+ Z, -=@.-ԟ@(,;-/$? .%Z,Z-;- .%Z,Z-;- .%Z,Z-;- .%Z,Z-;- .%Z,Z-;- .%Z,Z-;- .%Z,Z-;-  . %Z, Z- .>@..؟@(-;.y&1|? %Z-Z.;. %Z-Z.;. %Z-Z.;. %Z-Z.;. %Z-Z.;. %Z-Z.;. %Z-Z.;.  0 %Z- Z.  / 0?(4 000  - 0?(00?(00?(00?(00?(00?(00 ?(0&#@666666666666666=%F8X> ????mGrouped IMR Amortization SchedulesxW\A:G4..A:G4X:0|WXXDANDuration from Current Yearend;0XFraction Unamortized0>W0W:9..:9:9..:9<0X\A:H9..A:H9E\A:I9..A:I9W\A:J9..A:J9\A:K9..A:K9"80Xqq.     }SCHEDULESGouped IMR Amortization SchedulesxWA:G4..A:G4X:0|WXXDANuration from Current Yearend;0Xraction Unamortized0>W0W:9..:9:9..:9<0XA:H9..A:H9EA:I9..A:I9WA:J9..A:J9A:K9..A:K9"80X"  ~$ 4cf  dMbP?_*+%&A&?'?MHP LaserJet 4Si@w XXGouped IMR A@MSUDOHP LaserJet 4Si<d "_XX?? amort tableU}  bl 4                            ! " # Calculations Page+# Grouped Amortization Schedules .& for the Interest Maintenance Reserve T,$T > for ZB Gains and Losses#! for 2008 Gains and Losses [p$E Z  = C),dB%  Interest Rate = 6.00%  Duration" Calendar Years to Maturity   From!  (Residential Mortgages)   Current Yearend Yearend-  over D1B  over 25:  $D1B-D0B21-25:  $D1B-D0B16-20:  $D1B-D0B11-15:  $D1B-D0B6-10:  $D1B-D0B2-5 1 0!    "(21-30)"(11-20)"(3-10) (1-2)  (0)~ -`@ ZD-?(FLL0@ LL1@ ]L0@LC5,L0@LCc,A?L0@L1@C,L1@LL2@BBL3@AGz?(rh|?(^I +?(ffffff?(-?(MbX9?(~  ?.L-d@ ZDK?(`"?(;On?( rh?( ףp= ?(l?((~  @-h@ ZDbX9?(= ףp=?(Zd;O?(Zd;O?(rh|?(V-?((~  @-l@ ZDʡE?(q= ףp?(jt?(?(ʡE?(ʡE?((~  @-p@ ZDV-?(S㥛?( +?(Q?(Cl?(+?((~  @-t@ ZDJ +?(X9v?(/$?(Zd;O?(x?(((~  @-x@ ZD r?(bX9?(Mb?(l?(ʡE?(((~  @-|@ ZD-?(n?(I +?( r?(x&?(((~   @-@ ZD ףp= ?(#~j?(!rh?(S?(Zd;?(((~  "@-@ ZDʡE?(V-?(Zd;?(jt?(Q?(((~  $@-@ ZDFx?(#FLL0@ LL1@ ]L0@LC5,L0@LCc,A?L0@L1@C,L1@LL2@BBL3@A;On?( rh?(Mb?((((~  &@-@ ZDS㥛?(v/?(`"?(ˡE?((((~  (@-@ ZDʡE?(ףp= ?(l?(Mb?((((~  *@-@ ZDQ?(;On?(d;O?(jt?((((~  ,@-@ ZDV-?(!rh?(Cl?(I +?((((~  .@ -@ ZDS㥛?( -?( = ףp=?( ( ( ( ( ~   0@!- @ ZD  ~jt?(! $C?(! x&?(! (! (! (! (!~ !1@"-!@ ZD!!= ףp=?("!Gz?("!ʡE?("!("!("!("!("~ ! "2@#-"@ !ZD""!rh?(#"Cl?(#"Q?(#"(#"(#"(#"(#~ " #3@$-#@ "ZD##v?($#X9v?($#;On?($#($#($#($#($~ # @t!DILTOM7777777777777777$ % & ' ( ) * + , - . / 0 1 2 3 $4@%-$@ #ZD$$)\(?(%$$.MLL0@ LL1@ ]L0@LC5,L0@LCc,A?L0@L1@C,L1@LL2@BBL3@A$^I +?(%$$(%$$(%$$(%$$(%$$(%$~ $ %5@&-%@ $ZD%%J +?(&$%h|?5?(&$%(&$%(&$%(&$%(&$%(&$~ % &6@'-&@ %ZD&&(\?('$& rh?('$&('$&('$&('$&('$&('$~ & '7@(-'@ &ZD''M?(($'X9v?(($'(($'(($'(($'(($'(($~ ' (8@)-(@ 'ZD((v/?()$(Mb?()$(()$(()$(()$(()$(()$~ ( )9@*-)ğ@ (ZD))sh|??(*$)(*$)(*$)(*$)(*$)(*$)(*$~ ) *:@+-*ȟ@ )ZD**S㥻?(+$*(+$*(+$*(+$*(+$*(+$*(+$~ * +;@,-+̟@ *ZD++X9v?(,$+(,$+(,$+(,$+(,$+(,$+(,$~ + ,<@--,П@ +ZD,,y&1?(-$,(-$,(-$,(-$,(-$,(-$,(-$~ , -=@.--ԟ@ ,ZD--y&1|?(.$-(.$-(.$-(.$-(.$-(.$-(.$~ - .>@.-.؟@ -ZD..($.(2$.(2$.(2$.(2$.(2$.(2$~ .  / 00>@9@4@.@$@@#?0 019@4@.@$@@?#1 2/P@(32Y22OC ,L0@L1@C:,A2/P@(322/P@(322/P@(322/P@(322t @(322h?(323L$0*@(3M33CL0@L1@C,L1@L2@C73Rj @(33:7Ҡy% @(33f `aa@(33>)?(33f?(33PĹ$@?(33 $p,7777777777>>6=%F8X> " Oh+'0 PXh| оٷ Dan SwansonMicrosoft Excel@< @}Tx@8G: #  @  Y  '' ' Xh- h h-##- @ !#-!!$- @ !#!-22$- @ !#2-CC$- @ !#C-TT$- @ !#T-ee$- @ !#e-vv$- @ !#v-$- @ !#-$- @ !#-$- @ !#-$- @ !#-$- @ !#-X- @ !W-pp- @ !p-- @ !-  - @ ! -WW- @ !W̻- ̻ @ !#- h-$- @ !$-##- @ !#-Courier- ̻ 2 1 2 $2 2 53 2 F4 2 W5 2 h6 2 y7 2 8 2 9 2 10 2 11 2 FA 2 B 2 C 2 -D"SystemS-'-̻ X$Times New Roman-  2 &YearTimes New Roman-  2 2008 -2 #& Interest Rate- 2 #6.00%i  -2 4& a angle 5R@ 2 44.332 E& a angle 1RQ 2 E0.97<2 gl# Grouped Amortization Schedules @2 xe& for the Interest Maintenance Reserve 92 z! for 2008 Gains and Lossess42  Interest Rate = 6.00% 2 ?Duration .2 Calendar Years to Maturity -'- X-  -X- @ !X-- @ !-'n՜.+,0 0 8@ H   amort tablecalcANN1ANN5IDISC'amort table'!Print_Areacalc!Print_Area'amort table'!Print_Area_MIPRN  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLNOPQRSTVWXYZ[\Root EntryF`(Book SummaryInformation(MDocumentSummaryInformation8U