TS&TNbTh T VT&Times New RomanT VT&ArialNew RomanT VT&ArialNew RomanT VT&ArialNew RomanT VT&ArialNew RomanT VT&ArialNew RomanT VT&Times New RomanT VT&Times New RomanT VT&Times New RomanT VT&Times New RomanT VT&Times New RomanT VT&Times New RomanT $VT&Times New RomanT VT&Times New RomanT VT&Times New RomanT VT&pArialNew RomanT VT&ArialNew RomanT VT&ArialNew RomanT VT&ArialNew RomanT 0VT&Arial NarrowanT VT&Arial NarrowanT VT&ArialNarrowanT VT&Times New RomanT VT&Times New RomanT VT&Arial NarrowanT VT&Arial NarrowanT ZT 3ZT  ZT  ZT B3ZT C ZT D ZT db ZT  ZT  ZT  ZT UPa!ZT  ZT  ZT  ZT  ZT  ZT  ZT  ZT  ZT PPa!ZT PP a!ZT PP a!ZT PU a!ZT  ZT  ZT  ZT  ZT  ZT 3ZT  ZT  ZT  ZT  ZT  ZT c2ZT c2ZT 3ZT  ZT   ZT   ZT  ZT  ZT  ZT  ZT  ZT  ZT c2ZT c2ZT !ZT !ZT !ZT !ZT !ZT !ZT !ZT 3ZT 3ZT !ZT !ZT !ZT !ZT  ZT  ZT 3ZT  ZT !ZT Db ZT ` ZT !ZT Db ZT b ZT D b2ZT ` ZT (q ZT   ZT   ZT  ZT  ZT  ZT  ZT  ZT !ZT !ZT #ZT  #ZT #ZT  #ZT a'ZT  a'ZT #ZT #ZT   ZT 3ZT   "\T      kTkT@ kTdkTkT kTkTkTWkT fTeT:eTeTeTeTeTeTeTeTeT eT eT eT eT eTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeT eT!YeT"eT#eT$YeT2eT3PeT5JeT6eT7eT8eT9eT:eT;eT<eT=eT>eT?eT@eTBeTCeTDeTEeTFeTGeTHeTIeTJeTKeTLeTM1]Tp]T p]T p]T p]T p]T p]Tp]Tp]Tp^T@^TB^TC^TD^TE Print Area??$oTPTgTvr8`=/r8`=/dtu#Tr8`=/d&% ))Real Estate Worksheet ) ) ) )   ) ) ) ) ) )  QLoan Information R R R R R  Purchase Price[T (@      Percent Down[T %4@?%     Annual Interest Rate[T >@?%    PWorksheet Area  P  PDown Payment!&@d   $     O  O  OLoan Amount&@   1st yr interest expense r=@G  O  O  OLoan Fee @?  1st yr principal ϶@F  O  O  O 8Monthly Payment \Üdlv@1   1st yr payment   uoKѰ@ P    O  O  O              O  O  O  SIncome TMonthly  TAnnual  S  S  TTotal    O  O  O Total Rent @   @   Monthly Rent # Units      O  O  O Vacancy Allowance 1/12 UUUUUR@   @[T  &@[T  '      O  O  O,Net Income -UUUUU@  -:@    !:@    O  O  O        O  O  OUExpenseVMonthly VAnnual U U VTotal  O  O  O Payment!Üdlv@  !uoKѰ@]Accessed Value[T (@   O  O  O Property Tax!UUUUUui@  !@  [Property Tax Rate9v?   O  O  O Maintenance!I@  [T =b [    O  O  O Insurance!*M@  [T =@     O  O  O*Total Expenses+aNJ2@ P+uoKq@ P   (!uoKq@     O  O  O  ! !   !  O  O  OWCash FlowXMonthly XAnnual WXNo. of houses XTotal  O  O  O!.Net Income - Total Expense/{,b@  /8)B@   "[T %$@/ZiC@    O  O  O " # # " # #  O  O  OYReturn on Investment Z Z Z Z Z  O  O  O0Appreciation Rate 1 yr. 0T㥛 ? 7 8   O  O  O/9Total Investment (Down Payment+Loan Fee) :;@   0 0 3  0Appreciation 1 yr 0;`(@   0 4 5  .9Total Investment including Appreciation 1#;(\@   4 4 5   0 0 ; 0 4 6  ! 0ROI 1st yr no appreciation  0  3  4  4  5    #!9Cash Flow / Total Investment !0!<WÞ?   !4 !4 !5 ! ! "0 "0 "5 "4 "4 "5 " "$#0ROI 1st yr with appreciation #0 #5 #0 #4 #6 # #2$9Cash Flow+Appreciation+Principal/Investment $9)$<ov?    $4 $4 $5 $ $ %2 %2 %2 %2 %2 %2 % % &2 &2 &2 &2 &2 &2 & & ' ' ' ' ' ' ' ' ( ( ( ( ( ( ( ( ) ) ) ) ) ) ) ) * * * * * * * * + + + + + + + + , , , , , , , , - - - - - - - - . . . . . . . . / / / / / / / / 0 0 0 0 0 0 0 0!2@Mortgage and Loan Analysis 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 45Analysis 5 5 5 5%5Amount financed (From Above) 55B&@ҿ 6 6 6 6 6(6Annual interest (From Above) 66@Ͽ 7 7 7 7 7"7Duration of loan (in years) 7[T 7C>@ 8 8 8 8 88Start date of loan 8[T 8H@ 9 9 9 9 9 9A 9A 9D ::Monthly payments :>:EÜdlv@. d 8; ; ; ; ; ;;Total number of payments ;2;Fv@" ?; < < < < <"<Yearly principal + interest <"<EuoKѰ@ ; = = = = = =A =A =D > > > > >>Principal amount >>E&@;q? a:CT"5To display each month's calculations, extend the table by select-;;3H? To display each month's calculations, extend the table by select- ? ??Finance charges ?8?Gspm@(   ;; @Lb@R:CT"5ing the bottom row of data and filling down to row;;39@ing the bottom row of data and filling down to row @ @ @7@ w@':CT"5; ;;@Total cost @*@Gspm@  ;  @L  @L  @L  @L  @L @L @L @L A A A A AA AA AA BMBIPMT NO.BIPAYMENT DATEBIBEGINNING BALANCEBIINTERESTBIPRINCIPALBIBALANCEBIACCUMULATIVE INTERESTBIACCUMULATIVE PRINCIPAL  BM  BM  BM  BM  BM BM BM BM CN[T C CJ@;C&@:;-Cfs@6 d  ;$Cn-+H@:: ;*CV@ ;Cfs@;Cn-+H@;  CN  CN  CN  CN  CN CN CN CN DND @  jDK@Z>= <>= 6 <>= 6 <8<;6;DV@;-D|fbs@6 d  ;0Dn9NH@ :  ;*D#Y@ ;$D6*d@ ;$DM= <>= 6 <>= 6 <8<;6;E#Y@;-E靲E^s@6 d  ;0E pH@ :  ;*EA&H@ ;$E*4@ ;$Ej:b@ ;  EN  EN  EN  EN  EN EN EN ENF @  jF`@Z>= <>= 6 <>= 6 <8<;6;FA&H@;-F%Z`Ys@6 d  ;0F@NYH@ :  ;*FmN @ ;$Fqrtn`@ ;$FvR_h@ ;G @  jG@@Z>= <>= 6 <>= 6 <8<;6;GmN @;-GӯDUs@6 d  ;0GРH@ :  ;*GEr@ ;$G]5@ ;$Grn@ ;H @  jH @Z>= <>= 6 <>= 6 <8<;6;HEr@;-HJ_4Qs@6 d  ;0H[H@ :  ;*H΁Y;@ ;$H_ @ ;$H?br@ ;I @  jI @Z>= <>= 6 <>= 6 <8<;6;I΁Y;@;-IpvLs@6 d  ;0I0H@ :  ;*Iǵ~@ ;$I@ ;$Iu%u@ ;J @  jJ @Z>= <>= 6 <>= 6 <8<;6;Jǵ~@;-JbF`1Hs@6 d  ;0JX !I@ :  ;*J @ ;$J1TW@ ;$J}{%x@ ;K "@  jK@Z>= <>= 6 <>= 6 <8<;6;K @;-KCs@6 d  ;0K` eEI@ :  ;*K[b@ ;$K@ ;$K Ҥ{@ ;L $@  jL`@Z>= <>= 6 <>= 6 <8<;6;L[b@;-L0?s@6 d  ;0LH.iI@ :  ;*L ;M@ ;$Lꦃ(@ ;$Lob~@ ;M &@  jM@@Z>= <>= 6 <>= 6 <8<;6;M ;M@;-M+QL:s@6 d  ;0M:I@ :  ;*M:ZmϤ@ ;$M1-CW@ ;$M\q$@ ;N (@  jN@Z>= <>= 6 <>= 6 <8<;6;N:ZmϤ@;-N6s@6 d  ;0N`}I@ :  ;*N$/8@ ;$Nr=@ ;$N϶@ ;