ࡱ> hg ` Worksheet"&Tools&WindowChart"&Tools&Window(Visual Basic Module"&Tools&Window\pThomas W Baker Ba==X/8X@"1gArial1gArial1gArial1gArial1gArial1gArial1gTahoma1gTahoma1gTahoma1 gTahoma1;gTahoma1gTahoma1;gTahoma1gTahoma"$"#,##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\);_(* "-"??_);_(@_)4/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_)0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_) ;0.00;0.0083_(* #,##0.000_);_(* \(#,##0.000\);_(* "-"??_);_(@_) 0.0% #,##0.0 dd\-mmm\-yy_)0_) mm/dd/yy_) mm/dd/yy0_);[Red]\(0\)#,##0.0_);\(#,##0.0\) "$"#,##0.00 0.000%&               & &     1 &! &!& & &&X ' ''`' ''``'` '`'`` % &  &  & && & &&!  %! &!  '7  & 7  '  7  ' 7  &  7     %      . &  .   .   . && & &   ' ,  ' ,  '  ,  Date Fixed Text8ccc ``NZz̙3f3333f3ffff333ff333f33f33BBB\`9Mortgage Amortization( Variables2_Example:_Look:_Order1_Series:_Shading:! DATA_01;( IntroPrintArea; # Look1Area;; # Look2Area;; # Look3Area;; # Look4Area;; # Look5Area;;   ;7 + TemplatePrintArea;7 "C2Mortgage AmortizationYearMonth Principal Interest PrincipalInterest DO NOT ERASEJanFebMarAprMayJunJulAugSepOctNovDecMonths Base YearYears Last YearMos in Last Yr_Example_Shading_Series_LookOfficeReady 3.0Loan principal amountAnnual interest rateLoan period in yearsBase year of loanBase month of loanAnnual loan paymentsMonthly paymentsInterest in first calendar yearInterest over term of loanSum of all paymentsInputs Key FiguresPayments in First 12 Months(Yearly Schedule of Balances and PaymentsBeginning BalanceCumulative PrincipalCumulative InterestEnding BalancePayment Payment: mrX]cc  0UH+nsv~  dMbP?_*+%&?'?(?)?MKhp deskjet 6122 series!@m߀d,ertBe@RLd0Arial8sBeںںhp deskjet 6122 series122 series,LocalOnly,DrvConvert"U,,??U} } $} I }  } m} @Z@h@@@@@@@ h@ @ @ @ @@@@@@@@@@@h@@@@@@@@/ 0$11111111/('(((((((( C(DDE C)DDE) @AB7 @# ABV =5 @DADADADAB$ D   B ***+++*) @AB8 @$ ABk =G56UDADADADAB$"D DDB;A B ***+++*) @ AB9 @% ABf =5PDADADADAB$Dec%  Bf B ***+++*) @!AB: @& AB_ =5 IDADADADAB$$%7B B ***+++*) @"AB9 @' ABX =5BDADADADAB$D D B )**+++*(  C*$ DDDDDDDE , 2 4 4, 40 4 4 4- 4. 3/ ,--...- ); ; %$   $ B+ < 5 D% BfJan6 =5  D A $B =G5  *  L@A ,@B =5  0  &L@ALLB =G5  ;  1L@ALL@ AB> =h5 (D A% @(B> =Gd5 (D A% @(B =5  0  &L@ALLB )**+++* ); ;D5 %D  D B+ <H5 D% BfFeb =5  *  L@A ,B =G5   =5   =G5  > =5 (D A% @(B> =G5 (D A% @(B =5   )**+++* ); ;l5%D  D B+ <p5D% BfMar =5   =G5   =,5   =G(5  > =05 (D A% @(B> =45 (D A% @(B =85  )**+++*);;5%D  D B+<5D% BfApr=@5 =G<5 =5 =G5 >=5(D A% @(B>=G5 (D A% @(B =5  )**+++*);;5%D  D B+<5D% BfMay=5 =G5 =l5 =Gh5 >=p5(D A% @(B>=t5 (D A% @(B =x5  )**+++*);;5%D  D B+<5D% BfJun=5 =G|5 =D5 =G@5 >=H5(D A% @(B>=L5 (D A% @(B =P5  )**+++*);; 5%D  D B+<5D% BfJul=X5 =GT5 =5 =G5 >= 5(D A% @(B>=$5 (D A% @(B =(5  )**+++*);;45%D  D B+<85D% BfAug=05 =G,5 =5 =G5 >=5(D A% @(B>=G5 (D A% @(B =5  )**+++*);;\5%D  D B+<`5D% BfSep=5 =G5 =5 =G5 >=5(D A% @(B>=p5 (D A% @(B =5  )**+++*);;5%D  D B+;5D% BfOct=5 =G5 =5 =G5 >=5(D A% @(B>=5 (D A% @(B =5  )**+++*);;5%D  D B+<5D% BfNov=5 =G5 =|5 =Gx5 >=5(D A% @(B>=„5 (D A% @(B =5  )**+++*);;5%D  D B+<5 D% BfDec=5 =G5 =T5 =GP5 >=X5(D A% @(B>=\5 (D A% @(B =`5   )**+++*( C+$DDDDDDE, 2 4, 41 4 4 6- 4. 5/ -,--...-)f;5PDAA&9D Jan  D% B"BJ>54DA %   D"B:>5$DAD @ B<>5&DADDB<>5 &DADDB<>l5&DADDBo>p5YDAED DD DD D"B>d5v7lLAXLL@ :LAL@ LL@B8""B *)**+++*)`;5JDA6%@BD@ D"B6>h5 DA $B>t577-LAL@ , BB<>x5&DADDB<>|5&DADDB>4507&LALLB>Ԁ507&LALLB>\5 *)**+++*)`;5JDA6%@BD@ D"B>`5*+ LA ,B>5>50+&LALLB>!50+&LALLB>85>\5>T5 *)**+++*)`;5JDA6%@BD@ D"B>X5>5>5>5><5>d5>L5 *)**+++*)`; 5JDA6%@BD@ D"B>P5>5>5>V5>@5>5>{D5 *)**+++*)`;$5 JDA6%@BD@ D"B>{H5>5>5>K5>D5 >y5 >+<5  *)**+++*DA*l@,V,@,@aaa @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@89:;<=>? )` ;(5!JDA6%@BD@ D"B >+@5 >5  >5  >-5  >H5! >~5! >L45! *)**+++*!)`!;,5"JD A6% @BD@ D "B!>L85!>5!!>5!!>25!!>L5"!>5"!>p,5"! *)**+++*")`";05#JD!A6%!@BD@ D!"B">p05 ">5"">5"">5"">P5#">5#">$5#" *)**+++*#)`#;45$JD"A6%"@BD@ D""B#>(5!#>5##>5##>5##>T5$#>5$#>V5$# *)**+++*$)`$;85%JD#A6%#@BD@ D#"B$>V 5"$>5$$>5$$> 5$$>X5%$>5%$>A5%$ *)**+++*%)`%;<5&JD$A6%$@BD@ D$"B%>A5#%>5%%>5%%>5%%>\5&%>5 5&%>2 5&% *)**+++*&)`&;@5'JD%A6%%@BD@ D%"B&>25$&>$5&&>(5&&>@,5&&>`5'&>Y05'&>]5'& *)**+++*')`';D5(JD&A6%&@BD@ D&"B'>]5%'>45''>85''>><5''>d5('>@5('>5(' *)**+++*()`(;H5)JD'A6%'@BD@ D'"B(>5&(>D5((>H5((>L5((>h5)(>P5)(> 5)( *)**+++*))`);L5*JD(A6%(@BD@ D("B)> 5')>T5))>X5))>\5))>l5*)>`5*)>5*) *)**+++**)`*;P5+JD)A6%)@BD@ D)"B*>5(*>d5**> h5**>;l5**>hp5+*>p5+*>5+* *)**+++*+)`+;T5,JD*A6%*@BD@ D*"B+>5)+>t5++>x5++>>|5++>Xt5,+>р5,+>5,+ *)**+++*,)`,;X5 -JD+A6%+@BD@ D+"B,>5(*,*,7 LA ,B,>5(,,>5(,,0,7 &LALLB,>5(,,0,7 &LALLB,>"x5(-,>5(-,>5(-, *)**+++*-)`-;\5 .JD,A6%,@BD@ D,"B->5(+,->5(-->5(-,->l5(-,->|5(.->d5(.->5(.- *)**+++*.)`.;`5 /JD-A6%-@BD@ D-"B.>5(,,.>5(..>5(.,.>5(.,.>5(/.>5(/.>5(/. *)**+++*/)`/;d5 0JD.A6%.@BD@ D."B/>5(-,/>5(//>5(/,/>c5(/,/>w5(0/>5(0/>V5(0/ *)**+++*0)`0;h5 1JD/A6%/@BD@ D/"B0>V5(.,0>5(00>5(0,0>5(0,0>5(10>5(10>5(10 *)**+++*1)`1;l5 2JD0A6%0@BD@ D0"B1>5(/,1>5(11>5(1,1>K5(1,1>_5(21>5(21>5(21 *)**+++*2)`2;p5 3JD1A6%1@BD@ D1"B2>5(0,2>5(22>C5(2,2>5(2,2>5(32>}5(32>5(32 *)**+++*3)`3;t5 4JD2A6%2@BD@ D2"B3>5(1,3>5(33>/5(3,3>5(3,3>ؔ5(43>5(43>5(43 *)**+++*4)`4;x5 5JD3A6%3@BD@ D3"B4>5(2,4>5(44>5(4,4> 5(4,4>K5(54>5(54>5(54 *)**+++*5)`5;|5 6JD4A6%4@BD@ D4"B5>5(3,5>5(55>5(5,5>5(5,5>g5(65>z 5(65>5(65 *)**+++*6)`6;5 7JD5A6%5@BD@ D5"B6>5(4,6>$5(66>(5(6,6>,5(6,6>5(76>05(76>5(76 *)**+++*7)`7;5  JD6A6%6@BD@ D6"B7>5(5,7>G5(77>5(7,7>s5(7,7>5( 7>5(7>5(77 *)**+++*(8???????(9???????(:???????(;???????(<???????(=???????(>???????(?D%laaaaaaaaaaaaaaaaaaaaaaa,,,,,,,@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_(@(A(B(C(D(E(F(G(H(I(J(K(L(M(N(O(P(Q(R(S(T(U(V(W(X(Y(Z([(\(](^(_Dl,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,`abcdefghijklmnopqrstuvwxyz{|}~(`(a(b(c(d(e(f(g(h(i(j(k(l(m(n(o(p(q(r(s(t(u(v(w(x(y(z({(|(}(~(Dl,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,((((((((((((((((((((((((((((((((Dl,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,   (((((((((((((((((((((((((((((  ( ! ~ ? j ? TDBsAr%B@A&DBsAr%B@B !Dl,,,,,,,,,,,,,,,,,,,,,,,,,,,,,B,                                 ~ @  @(/ %L LB !  ~ @  @( !  ~ @  @( !  ~ @  @( !  ~ @  @( !  ~ @  @( ! ~  @  @( ! ~ "@  "@( ! ~ $@  $@( ! ~ &@  &@( ! ~ (@  (@(  !( ! O "8@ 9D Jan !Jan% B@ B! 8 DD   ! (  $@D  B! DD   !  (   ,@L B! DD   !  (  ! DD   ! D   (  !  DD   # D  (  !  DD   ! D   (  !  DD   f# 5 PD<DDD BsArJan  B B  (  !  DD   !(@ D  (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  (   ,@L B! DD   !  (  ! DD   !Dluuuuuuuuuu,vvvvvvvvvv             (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  (  ! DD   !  $(  ! %  DD  %%&dvvvvvvvvv>@<dr   7bb,ggDgghoh    7   ǫ  dMbP?_*+%&A Page &P"P??U     ~ ? <>@7 Oh+'0 hp| Thomas W BakerMicrosoft Excel@'@FT.&@m՜.+,D՜.+,t `ht  3$TemplateZone by KMT Software, Inc. Mortgage Amortization#'Mortgage Amortization'!Print_AreaTemplatePrintArea  Worksheets Named RangesX 8@ _TemplateIDTC010566201033  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVXYZ[\]^`abcdefRoot Entry FWorkbookSummaryInformation(WDocumentSummaryInformation8_