TS&TbTm T VT&Courier New T 0VT&Courier New T 0VT&Courier New T 0VT&`Courier New T 0VT&aCourier New T 0ZT  ZT  ZT B ZT C ZT D ZT F ZT  ZT  ZT  ZT  ZT   ZT  ZT D ZT F ZT  ZT C ZT F ZT   Y\T   kTkT8kTkT5kTfTeT ,eT ,1^T ^T 0^T0^Tp prncpl  rateؒ  termؒ  period  pmtؒ  pmtsؒ   $oTPTgTv=/=/dtu#T=/d&% MORTGAGE LOAN ANALYSIS  Principal  [T j@  Annual interest  [T @Term (years)  [T  >@Periods per year  [T 2Start date   [T  @  Monthly Payment'1O@ 8  No. of Payments     v@          2 Fill Down from row 17 (2nd payment) to row: pw@     Pmt  Pmt Beginning    Additional  Ending Cumulative  No.  Date Balance Interest PrincipalPrincipal Balance Interest[T  @ j@" UUUUU@  -ྊԯV@? ;" P Yd@  UUUUU@ @  %@>= 6P Yd@"m{j@  -:V@? ;"NaR^@  4a:_@   @  %@>= 6NaR^@" KJ2z@  -V@? ;" &0X@  Ć_^@                                                                                                                                                                                                               ! ! ! ! ! ! " " " " " " # # # # # # $ $ $ $ $ $ % % % % % % & & & & & & ' ' ' ' ' ' ( ( ( ( ( ( ) ) ) ) ) ) * * * * * * + + + + + + , , , , , , - - - - - - . . . . . . / / / / / / 0 0 0 0 0 0 1 1 1 1 1 1 2 2 2 2 2 2 3 3 3 3 3 3 4 4 4 4 4 4 5 5 5 5 5 5 6 6 6 6 6 6 7 7 7 7 7 7 8 8 8 8 8 8 9 9 9 9 9 9 : : : : : : ; ; ; ; ; ; < < < < < < = = = = = = > > > > > > ? ? ? ? ? ? @ @ @ @ @ @ A A A A A A B B B B B B C C C C C C D D D D D D E E E E E E F F F F F F G G G G G G H H H H H H I I I I I I J J J J J J K K K K K K L L L L L L M M M M M M N N N N N N O O O O O O P P P P P P Q Q Q Q Q Q R R R R R R S S S S S S T T T T T T U U U U U U V V V V V V W W W W W W X X X X X X Y Y Y Y Y Y Z Z Z Z Z Z [ [ [ [ [ [ \ \ \ \ \ \ ] ] ] ] ] ] ^ ^ ^ ^ ^ ^ _ _ _ _ _ _ ` ` ` ` ` ` a a a a a a b b b b b b c c c c c c d d d d d d e e e e e e f f f f f f g g g g g g h h h h h h i i i i i i j j j j j j k k k k k k l l l l l l m m m m m m n n n n n n o o o o o o p p p p p p q q q q q q r r r r r r s s s s s s t t t t t t u u u u u u v v v v v v w w w w w w x x x x x x y y y y y y z z z z z z { { { { { { | | | | | | } } } } } } ~ ~ ~ ~ ~ ~