ࡱ> ^] $\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 XXYę 0I{ 0hYlYY3 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 2007 Gains and Losses Md$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)) 8 Z (0)  ~ \@ . DL,&1|? 0Z,Gz? 0Z,Mb? 0Z,@v? 0Z,? 0Z,L7A`? 0Z,Zd;O? 0Z, ?  Z ?.L`@;Q? %ZZ;I +? %ZZ;P7A`? %ZZ; \(? %ZZ;zG? %ZZ;Dl? %ZZ;MbX9? %ZZ;   %Z Z @d@;Mb? %ZZ;`d;O? %ZZ;Q? %ZZ; V-? %ZZ;"~j? %ZZ;x&1? %ZZ; %ZZ;   %Z Z @h@;Mb? %ZZ;? %ZZ;~jt? %ZZ;Zd;? %ZZ;h|?5? %ZZ;Gz? %ZZ; %ZZ;   %Z Z @l@; On? %ZZ;@v? %ZZ;0? %ZZ;p= ף? %ZZ;? %ZZ;p= ףp? %ZZ; %ZZ;   %Z Z @p@;~jt? %ZZ;S㥛? %ZZ;/$? %ZZ;@l? %ZZ;/$? %ZZ;+? %ZZ; %ZZ;   %Z Z @t@;Gz? %ZZ;Q? %ZZ;ףp= ? %ZZ;l? %ZZ;V9v? %ZZ; %ZZ; %ZZ;   %Z Z @x@; /$? %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?( 000  - 0?(00?(00?(00?(00?(00?(00 ?(0&#@666666666666666=%F8X> ????mGrouped IMR Amortization SchedulesW\A:G4..A:G4 Y= 0W YY<ĐDuration from Current Yearend 0YFraction Unamortized)0>WR0W\A:F9..A:F9z\A:G9..A:G9[ 0Y\A:H9..A:H9L C\A:I9..A:I9W\A:J9..A:J9\A:K9..A:K9 0Yqq.     }SCHEDULESGouped IMR Amortization SchedulesWA:G4..A:G4 Y= 0W YY<Đuration from Current Yearend 0Yraction Unamortized)0>WR0WA:F9..A:F9zA:G9..A:G9[ 0YA:H9..A:H9L CA:I9..A:I9WA:J9..A:J9A:K9..A:K9 0Y"  $ 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 TT $ > for ZB Gains and Losses#! for 2007 Gains and Losses [ $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-`@ ZDK?(`"?(;On?( rh?( ףp= ?(l?((~  @-d@ ZDbX9?(= ףp=?(Zd;O?(Zd;O?(rh|?(V-?((~  @-h@ ZDʡE?(q= ףp?(jt?(?(ʡE?(ʡE?((~  @-l@ ZDV-?(S㥛?( +?(Q?(Cl?(+?((~  @-p@ ZDJ +?(X9v?(/$?(Zd;O?(x?(((~  @-t@ ZD r?(bX9?(Mb?(l?(ʡE?(((~  @-x@ 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@C7<3Rj @(33:7Ҡy% @(33f `aa@(33>)?(33f?(33PĹ$@?(33 $p,7777777777>>6=%F8X> " Oh+'0 PXh| оٷ Dan SwansonMicrosoft Excel@< @}Tx@h2G: #  @  Y  '' ' X-  -##- @ !#-!!$- @ !#!-22$- @ !#2-CC$- @ !#C-TT$- @ !#T-ee$- @ !#e-vv$- @ !#v-$- @ !#-$- @ !#-$- @ !#-$- @ !#-$- @ !#-X- @ !W-pp- @ !p-- @ !-  - @ ! -WW- @ !W-  @ !#- -$- @ !$-##- @ !#-Courier-  2 1d 2 $2d 2 53d 2 F4d 2 W5d 2 h6d 2 y7d 2 8d 2 9d 2 10 2 11 2 FAd 2 Bd 2 Cd 2 -Dd"System-'- X$Times New Roman-  2 &YearTimes New Roman-  2 2007 -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 2007 Gains and Lossess42  Interest Rate = 6.00% 2 ?Duration .2 Calendar Years to Maturity -'- X-  -X- @ !X-- @ !-'՜.+,0 0 8@ H   amort tablecalcANN1ANN5IDISC'amort table'!Print_Areacalc!Print_Area'amort table'!Print_Area_MIPRN  Worksheets Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLNOPQRSTVWXYZ[\Root EntryFBook SummaryInformation(MDocumentSummaryInformation8U