ࡱ> RSQ ` Worksheet"&Tools&WindowChart"&Tools&Window(Visual Basic Module"&Tools&Window\pv-luannv Ba==;X/8X@"1YArial1YArial1YArial1YArial1YArial1YArial1YTahoma1 YTahoma1 YTahoma1YTahoma1YTahoma1YTahoma1 YTahoma1YTahoma"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)% "$"#,##0.0_);[Red]\("$"#,##0.0\)#,##0.0_);[Red]\(#,##0.0\) 0.0% mm/dd/yyGeneral;[Red]\-General 0;[Red]\-00_) mm/dd/yy_)0_);[Red]\(0\)mmmm\ d\,\ yyyy "$"#,##0.00 0.000%&               & &     1  ( (  ( &    (  (   & @@ @ ` @ @  ` @ @  `@ ` `` &        /     /   /   /        ! ,  / +  /  ,  / *               7  7 ( 7 ( 7  7  7  Date Fixed Text8NZzccc`ѩ̙3f333f3ffff333ff333f33f33BBB\`%Biweekly Payment Amortizationa Variables2_Example:_Look:_Series:_Shading:! DATA_01;( IntroPrintArea; # Look1Area;O # Look2Area;O # Look3Area;O # Look4Area;O # Look5Area;O   ;H + TemplatePrintArea;I "~& First 26 PaymentsPayment Payment # Principal Interest (Payments for Calendar Years after Year 1YearDo Not Delete #Periods in first year calendar year_Example_Shading_Series_LookOfficeReady 3.0Loan principal amountAnnual interest rate Base yearLoan start dateDate of first paymentAnnual loan paymentsInterest over term of loanSum of all paymentsInputs Key Figures Payment DateBeginning BalanceCumulative PrincipalCumulative Interest Ending BalanceLoan period in years (30 max.) Biweekly payments&Biweekly Mortgage Payment Amortization" .!cc  ,H7-Xa`}`cr'}  dMbP?_*+%&?'?(?)?MnMicrosoft Office Document Image/d,,Letterwidm"G,,??U} } $ } m }  } }    @Z@@@@@@@@ @ @ @ ,@ @@@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ :   A BC A BC  DE~ @' DE@?Hzy@*$D B DE~ 7@ DEk?{GJ@ U$DB$DB$'DDDB;A B 01~ 3.@ DEf?̤^AP$$B$$B$DDD B DE~ 8T@ DER?4333(A <$$B$DD B  DE~ 9D@ ;/. DE,2|@%DDB ./.  >  J J J J J J J J J KKKKKKKKK 5 5?D B, 6|@DDB8 <j#A"D D B8 <{GJ@ "D D BK <QȔ@ 5$ LD B$D D  B <{Gᚇ@  D &:,DB$LDA B7 <QȔ@!D  $  B7 <{Gᚇ@!D  $  BO <q= #A9$ L$ B$D D  B5@/&%D L B@6@*$ (D  B;=q= #A%$ $  B={GJ@+&!D $ BK=GzΔ@ 5$DB$DD B=(\@ A=fffffˤ@+$D D BA=Q@+$D D BJ =#A4$LDB$DD B5@6@4*,(L B;=#A%$ $  B={GJ@=Ԕ@ >4,LLB$LL B=Q@ =33335@5+,LL B=> ף@5+,LL B =L4#A > 4,LLB$LL B5@6@=L4#A/%, , B={GJ@=(\ڔ@ =v@ =ףp=Ѵ@=> ףp@ =#A 5@6.@=#A={GJ@=R@ =Hzi@ =Q @=(b@ =]uV#A 5@6J@=]uV#A={GJ@=Gz@ =(\]@ =أp=C@=@ =#A 5@6f@=#A={GJ@=zG@ =)\P@ =Hzn?@=Q8@ =|Gl#A 5 @6@=|Gl#A={GJ@=> ףp@ =q= ףD@ =(@=o@ =(\#A 5"@6@=(\#A={GJ@=q= ף@ = ףp=8@ => ף}@=GzV@ =أpu#A 5$@6@=أpu#A={GJ@=p= @ =p= +@ =R @=(\O<@ = #A 5&@6֠@= #A={GJ@=أp= @ == ףp@ =̽@=Q@ =r#A 5(@6@=r#A={GJ@= ףp= @ =ףp= @ =GzT_@=(\O@ =z|#A 5*@6@=z|#A={GJ@=> ףp@ =q= ף@ ={G@=@ =]ucr#A 5,@6*@=]ucr#A={GJ@=Hz@ =\(@ =(\R@=(\a@ =Qg#A 5.@6F@=Qg#A={GJ@=R@ =Hz@ =GJ@=p= 7@ =G]#A 50@6b@=G]#A={GJ@=\(%@ =33333@ = ףp@=ףp=J>@ =HzR#A 51@6~@=HzR#A={GJ@=fffff+@ =QԆ@ =q= SI@=)\•@ =GaH#A 52@6@=GaH#A={GJ@=q= ף1@ = ףp=Ȇ@ =Hzn@=@ =(\=#A 53@ 6@ 4&*,(L B=(\=#A={GJ@=R7@ >&4,LLB$LL B=Hz@ =@ 5&+,LL B=Gzԃ@ 5&+,LL B =2#A  >& 4,LLB$LL BD!l(F6X(~`ieJ  @! @" @# @$ @% @& @' @( @) @* ;@+ @, @- @. @/ @0 @1 @2 @3 @4 @5 @6 @7 @8 @9 @: @; @< @= @> @? @ 54@! 6ҡ@! =2#A  / &%, , B ={GJ@  =\(>@  =33333@   =(\C@! =z@! =RK(#A! !55@"!6@"!=RK(#A! !={GJ@!!=> ףpD@! !=q= ף@! !=gfff@"!=X@"! =L#A" "56@#"6 @#"=L#A" "={GJ@""=QJ@" "=Gz@" "=@#"=3333S@#" = ף#A# #57@$#6&@$#= ף#A# #={GJ@##=أp= Q@# #== ףp@# #=(\A@$#=Qu@$# =k[#A$ $58@%$6B@%$=k[#A$ $={GJ@$$=QW@$ $={G|@$ $=zG@%$=(\I@%$ =)\¯"A% %59@&%6^@&%=)\¯"A% %={GJ@%%=q= ף]@% %= ףp=p@% %=]v@&%=Gz@&% = ף"A& &5:@&6z@ &= ף"A& &={GJ@&&=Rc@& &=Hzc@& &= Q!@&=Q@ & =GN"A ' (( )F )H )F )F )F )J ) *GIGGGK * ?+4X@)$+ D BK+<]ucr#A+5$& D% & Bf B[+<Hzy@+E$& )DD  $ $" BA+<p=c@++$& D+D+ BA+<z+@ +$& D+D+ BU+<$\"A?$& #DDDB8A B + ?,5\@-)$, D+ B;,=$\"A,%$+ $+ B,=Hzy@,,O,HE,)DL  $ ," Bi,=Qn@,S$+7D,D,D,  $,D,D," BA,=pQ~@+$+D,D, B,=fffm=!A,H,H>,"DLDB8A B , -5`@.-3-<), L B-=fffm=!A,-/-<%, , B-=Hzy@G,-=p= w@G-]-<S,7LLL  ,LL" B-=Pz>@-5-<+,LL B-=\ A, - .5d@/-.=\ A--.=Hzy@,.=(\@--.= G@--.=A, . /5h@0-/=A.-/=Hzy@,/=@ ף0@.-/= \y@.-/=WA, / 05l@1-0=WA/-0=Hzy@,0=Q3@/-0== @/-0={G7A, 0 15p@2-1={G7A0-1=Hzy@,1=`@0-1= Q8@0-1={G 7A, 1 25t@3-2={G 7A1-2=Hzy@,2=(\•s@1-2=Ga@1-2=(\A, 2 35x@4-3=(\A2-3=Hzy@,3=(\@2-3=@z{@2-3=ףp=AA, 3 45|@5-4=ףp=AA3-4=Hzy@,4=Q@3-4= Gẕ@3-4= A, 4 55@6-5= A4-5=Hzy@,5=px@4-5=@ ף @4-5=̨A, 5 65@7-6=̨A5-6=Hzy@,6=\P/@5-6=`R@5-6=Q@, 6 75@8-7=Q@6-7=Hzy@,7=@6-7=(\ި@6-7=(g@, 7 85@9-8=(g@7-8=Hzy@,8=@7-8=)\w@7-8== ף@C@, 8 95@:-9== ף@C@8-9=Hzy@,9== ף@C@8-9=Q6k@8-9=, 9 :5|;-:=\|9-:=3|,:=|9-:=´|9-:=|, : ;5|<-;=|:-;=3|,;=3|:-;=|:-;=|, ; <5|=-<=|;-<=3|,<=|;-<=|;-<=f|, < =5|>=3=H ), L B==f|<=/=H %, , B==3|,==|<=]=H S,7LLL  ,LL" B==|<=5=H +,LL B==Q|, = >5|?=>=Q|==>=3 |,>=|==>=Q|==>=z|, > ?5|@=?=z |>=?=3$|,?=(|>=?=G,|>=?=0|, ? DlJ(b$@ @A @B @C @D @E @F @G @H @I @54|A=@=8|?=@=3<|,@=@|?=@=D|?=@=H|, @ A5L|B=A=P|@=A=3T|,A=X|@=A=\\|@=A=`|, A B5d|C=B=(h|A=B=l|,B=p|A=B=t|A=B=x|, B C5||D=C=׀|B=C=|,C=|B=C= |B=C=f|, C D5|E=D=f|C=D=|,D=|C=D=פ|C=D=|, D E5|F=E=|D=E=|,E=|D=E=|D=E=|, E F5|G=F=|E=F=|,F=|E=F=G|E=F=|, F G5|H=G=|F=G=|,G=f|F=G=|F=G=|H, G H5|=H=|H=H=|H,H=|H=H=p|G=H=|, H I!!!             " # #$%&&' % &&'(ĝ@D AE &&'%&&'6%|@ D AED $ B~ &? &'6%@ DAED $B~ &@ &'6%@ DAED $B~ &@ &'6%@ DAED $B~ &@ &'6%.@ DAED $B~ &@ &'6%J@ DAED $B~ &@ &'z&2VVVVV                                6%f@ DAED $B~ &@ &'6%@ DAED $B~ & @ &'6%@ DAED $B~ &"@ &'6%@ DAED $B~ &$@ &'6%֠@ DAED $B~ &&@ &'6%@ DAED $B~ &(@ &'6%@ DAED $B~ &*@ &'6% DAED $B~ &,@ &'6% DAED $B~ &.@ &'6% DAED $B~ &0@ &'6% DAED $B~ &1@ &'6% DAED $B~ &2@ &'6% DAED $B~ &3@ &'6% D AED $ B~ &4@ &'6% D!AED $!B~ &5@ &'6% D"AED $"B~ &6@ &'6% D#AED $#B~ &7@ &'6% D$AED $$B~ &8@ &'6% D%AED $%B~ &9@ &'6% D&AED $&B~ &:@ &'#)@+ %B &&'%&*' %&1&*@D%@Bf'%~ &?)&w@ED!')\E'A+ DD%&@ L&u@+.$L LB!'GV&A, DD%&@&Pt@,!'$A- DD%&@&r@-!'Qu#A. DD%&@&q@.!'ףp=_!A/ DD%&@&n@/!'Q~pA0 DD%&@&k@0!'\H!A1 DD%& @&`h@1!'3333A2 DD%&"@& e@2!' ףp݂A3 DDD lVVVVVVVVVVVVVVVVVVVV7Wjmmmmmm                        %&$@&a@3!'z3A4 DD%&&@&@]@4!'q= A5 DD%&(@&V@5!'Qx*A6 DD%&*@&@P@6!' A7 DD%&,@&C@7!'(\B@8 DD%&.@&*@8!'Hzy@9 DD%&0@&9!': DD%&1@&:!'; DD%&2@&;!'< DD%&3@&<!'= DD%&4@&=!'> DD%&5@&>!'? DD%&6@&?!'@ DD%&7@&@!'A DD%&8@&A!'B DD%&9@&B!'C DD%&:@&C!'D DD%&;@&D!'E DD%&<@&E!'F DD%&=@&F!'G DD%&>@&G!'H DD +,~ ,-0 mmmmmmmmmmmmmmmmmmmmm>@<d         )*)*)*)*)*)*7bbggDggh/h  &hGhh'h    dMbP?_*+%&A Page &PMHP LaserJet IIILDLLW"!/I"!  dLg[GI;,,EVICECAPABILITIESd f "d,,??U        ~ ? <>@7 Oh+'0 hp|  TemplateZoneMicrosoft Excel@ Z@.&@v9z)p| Microsoft Excel@ Z@.&@v9z) Amortizh(@H P _TemplateID TC010566181033Named Ranges  !"#$%&'()*+,-./0123456789:;<=>?@IRoot Entry FpT_8TWorkbookSummaryInformation(,DocumentSummaryInformation84  ՜.+,D՜.+, px  8| TemplateZoneG  Biweekly Payment Amortization,'Biweekly Payment Amortization'!Print_AreaTemplatePrintArea  WorksheetsNamed RangesOh+'0 h