ࡱ> _^ Fɀ\pRushabh Parekh Ba==ss!;Q$8X@"1Arial1Arial1Arial1Arial1 Arial1$Arial1Arial1Arial1Arial""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-?"0 A "\ #,##0_);\("0 A "\ #,##0\)I""0 A "\ #,##0_);[Red]\("0 A "\ #,##0\)K#"0 A "\ #,##0.00_);\("0 A "\ #,##0.00\)U("0 A "\ #,##0.00_);[Red]\("0 A "\ #,##0.00\){;_("0 A "\ * #,##0_);_("0 A "\ * \(#,##0\);_("0 A "\ * "-"_);_(@_).)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)C_("0 A "\ * #,##0.00_);_("0 A "\ * \(#,##0.00\);_("0 A "\ * "-"??_);_(@_)61_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)72_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_)?:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                       8@ @ 8@ @ 8@ @ 8!@ @ 8!@ @ 8!@ @ 8!!@ @ 8@ @ 8!@ @  @ @  $@ @ 0@ @ 4@ @ 0@ <@ 4@  ,@ @  <@  <@ @ 0@ (  ` Advance+Varying Int-Inst 2Balance+Varying Int-InstR Advance+EMIKw Balance+EMI,Trj03 A@@  h# Inst No or Loan AmountLInt rateiInterestIInstallment amtABalance to reduceRB Balance LoanLB I=i/12/100*LRB=A=ILB=L-RBLoan Amount= Rs 600,000/-No of installments=36Load period= 3 yrsInterest rate= varyingInstallment = VaryingNote: No installment this time(If this value <=0, then the loan is overtValue of B8(L) = Value of G7(LB) Also note that due to advanced payment, no interest in the first month6The columns L and A are filled manually for each monthMon. NoNote the last Inst<The columns L and A are filled using autofill for each monthtValue of B8(L) = Value of G7(LB) Also note that due to balance payment, 12% interest in the first monthsValue of B8(L) = Value of G7(LB) Also note that due to advance payment, no interest in the first monthInstallment = Rs 19200/- fixed^Interest rate=10% fixed (Effective rate of interest is 9.9988% if bank waves off the Rs 12.94)sValue of B8(L) = Value of G7(LB) Also note that due to blance payment, 10% interest in the first month_Interest rate=10% fixed (Effective rate of interest is 9.99885% if bank waves off the Rs 13.05)Installment = Rs 19360/- fixed*p [OU Fɀ 0@%0  dMbP?_*+%"??U}  } } }  } 0            @  *@ @ ,@ ,@ ,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@                           $?%O"A&) & D D  d~ &@! &@  D D ! (@!A  D D  * +++ ~ "@ )@!A D ~ #(@ #@   .#LL d~ #L@ #@   .# LL #`k!A   .# LL~ @ !`k!A   ."L~ !(@ !L@  ~ !@ !İ@   !I!A ~  @!I!A ~ !(@!Gz!@ ~ !@!R@ !('!A ~  @!('!A ~ !(@!s@ ~ !L@! F%u"Q@ !w-! A ~  @!w-! A ~ !(@!4@ ~ !@!veD@ !ᖏm A ~  @!ᖏm A ~ !&@!9F@ ~ !@!8cl@ !2kA ~  @!2kA ~ !&@!]@ ~ !j@!U޺@ !7A ~  "@!7A ~ !&@!ڷS@ ~ !j@!U  +@ !ouA ~  $@!ouA ~ !&@!ըlnH@ ~ !j@!Ud@ !&C"&4A ~  &@!&C"&4A ~ !&@!Cflҋ@ ~ !@!^@ !;=A ~  (@!;=A ~ !&@!M@ ~ !L@!lWN@ !7o;cA ~  *@!7o;cA ~ !&@!=8.@ ~ !!=8. !-߃A  ~  ,@!-߃A ~ !&@!.Xw@ ~ !@!tЩ 2@ !%0A ~  .@!%0A ~ !&@! wR@ ~ !j@!i1@ !p"6A ~  0@!p"6A ~ !$@!\gJ1@ ~ !L@!(&L@ !{8A ~  1@!{8A ~ !$@!n+o@ ~ !j@! <@ !ܴwA ~  2@!ܴwA ~ !$@!گC@ ~ !j@! gi@ !@  ~ !@ !4oȍ=@@   ! 7.A! ~ ! 7@!! 7.A! ~ !!$@!!K@! ~ !!j@!! G@! !!Eˣ{C A" ~ " 8@"!Eˣ{C A" ~ "!$@"!8PH6@" ~ "!j@"! z[v@" "!T\xt A# ~ # 9@#!T\xt A# ~ #!$@#!H8<,8@# ~ #!L@#!|><}@# #!4ЙA$ ~ $ :@$!4ЙA$ ~ $!$@$!щ_@$ ~ $!@$!c%:@$ $!HoA% ~ % ;@%!HoA% ~ %!"@%!&V@% ~ %!L@%! @% %!>A& ~ & <@&!>A& ~ &!"@&!WS@& ~ &!j@&!wD@& &!Oڂc7.A' ~ ' =@'!Oڂc7.A' ~ '!"@'!/@' ~ '!L@'!Z@' '!e@( ~ ( >@(!e@( ~ (!"@(! ȋ@( ~ (!@(!u(t@( (!LK@) ~ ) ?@)!LK@) ~ )!"@)! pq @) ~ )!L@)!8@) )!bdnA@* ~ * @@*!bdnA@* ~ *!"@*!;AKS@* ~ *!@*!Ve@* *!2J@+ ~ + @@+!2J@+ ~ +!"@+!(΁@+ ~ +!j@+!s@+ +!ZHb*@, ~ , A@,!ZHb*@, ~ ,!"@,!0(x@, ~ ,!@,!<=]'@, ,!+yg-@- ~ - A@-!+yg-@- ~ -!"@-!͈Y&m@- ~ -!j@-!rL#.@- -!4@. ~ . B@.!4@. ~ .!"@.!ivJ@. ~ .'&A.!_@. .'Gq?h  . /$ ,  (  pb  6G0*HI@ b I]`H( >@     7 Fɀ 0J3EQ  dMbP?_*+%"??U}  } } }  } 0            @  *@ @ ,@ ,@ ,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@                           $?%O"A&(@) &p@ D D  d~ &@! &X@  D D ! ( !A  D D  * +++ ~ "@ ) !A D ~ #(@ #@   .#LL d~ #L@ #@   .# LL #!A   .# LL~ @ !!A   ."L~ !(@ !@  ~ !@ !fffff@   !3333y!A ~  @!3333y!A ~ !(@!K7I^@ ~ !@!X9ȶ@ !ʡEX!A ~  @!ʡEX!A ~ !(@!3@ ~ !L@!92@ !L|!A ~  @!L|!A ~ !(@!C{dbֵ@ ~ !@!^B$@ !COo A ~  @!COo A ~ !&@!͵Kn@ ~ !@!.%O@ !޺) A ~  @!޺) A ~ !&@!n@ ~ !j@!~H@ !t/rA ~  "@!t/rA ~ !&@!k2>@ ~ !j@!Ys@ !"<A ~  $@!"<A ~ !&@!{V׃@ ~ !j@!8!O* @ !XA ~  &@!XA ~ !&@!uǰ@ ~ !@!/E@ !A ~  (@!A ~ !&@!-,7@ ~ !L@!;i0@ !vA ~  *@!vA ~ !&@!:¨@ ~ !!:¨ ! %:A  ~  ,@! %:A ~ !&@!΀e @ ~ !@!|̟<@ !T.BA ~  .@!T.BA ~ !&@!-B=\Ϯ@ ~ !j@!Wx@ !jU-A ~  0@!jU-A ~ !$@!ZOc@ ~ !L@!l'@ !2DA ~  1@!2DA ~ !$@!c7@ ~ !j@!NC -@ !8A ~  2@!8A ~ !$@!uGx@ ~ !j@!]dZ@ !eA ~  3@!eA ~ !$@! O @ ~ !@!Gv@ !q"A ~  4@!q"A ~ !$@!̫%@ ~ !j@!g_@ !gxb6A ~  5@!gxb6A ~ !$@!òtG~@ ~ !L@!ig7@ !aA  BXbbD ,@!,@",@#,@$,@%,@&,@',@(,@),@*,@+,@,,@-,@.,@/~ 6@ !aA  ~ !$@ !ȼ@  ~ !@ !ghj@1@   !vJkwA! ~ ! 7@!!vJkwA! ~ !!$@!!ؔ@! ~ !!j@!!d7@! !!Ԁ:j(A" ~ " 8@"!Ԁ:j(A" ~ "!$@"!fRb@" ~ "!j@"!%Sg@" "!o.[ A# ~ # 9@#!o.[ A# ~ #!$@#!v`.@# ~ #!L@#!iy@# #!0 A$ ~ $ :@$!0 A$ ~ $!$@$!DA$P@$ ~ $!@$!컍@$ $!EA% ~ % ;@%!EA% ~ %!"@%!X Д@% ~ %!L@%!~@% %!ZA& ~ & <@&!ZA& ~ &!"@&!k6@& ~ &!j@&!Gr6@& &!7^A' ~ ' =@'!7^A' ~ '!"@'!p;sl@' ~ '!L@'!b>@' '!]s@( ~ ( >@(!]s@( ~ (!"@(!O锍@( ~ (!@(!Sc@( (!\@) ~ ) ?@)!\@) ~ )!"@)!fɵu@) ~ )!L@)!n@) )!l(@* ~ * @@*!l(@* ~ *!"@*!]/n&@* ~ *!@*!u^@* *!eYUv@+ ~ + @@+!eYUv@+ ~ +!"@+!8ͤ@+ ~ +!j@+!3@+ +!A>@, ~ , A@,!A>@, ~ ,!"@,!H{@, ~ ,!@,!B܋@, ,!y@- ~ - A@-!y@- ~ -!"@-!v8r@- ~ -!j@-!*5@- -!l^v@. ~ . B@.!l^v@. ~ .!"@.!Suy\@. ~ .'c].!v@. .'~a5h  . /$ ,   . 5h (  pb  6G0*HI@ b I]` ( >@     7 Fɀ /`Sjhu  dMbP?_*+%"??U}  } } }  } /            @  *@ @ ,@ ,@ ,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@                           $?%O"A&) & D D  d~ &@! &@  D D ! (!A  D D  * +++ ~ "@ )!A D ~ #$@ #@   .#LL d #@ D  # @   .# LL #PI!A   .# LL~ @ !PI!A   ."L !$@D  !UUUUUp@   #@  ."L !VUUUG@   !0 A ~  @!0 A !$@.!L!a `@ #@ !PO*@ !l f A ~  @!l f A !$@!\~@ #@ !=@ !>8A ~  @!>8A !$@!Q@ #@ !vW@ !(GEA ~  @!(GEA !$@!7j@ #@ !+1<@ !ՀѸcA ~  @!ՀѸcA !$@!U @ #@ !Uz@ !,98(A ~  "@!,98(A !$@![^2@ #@ !)yhs@ !:A ~  $@!:A !$@!c(c@ #@ !;5@ !-JA ~  &@!-JA !$@!RbJ@ #@ !Jkg8@ !PPH6YA ~  (@!PPH6YA !$@!hg@ #@ !%Fy@ !"sleA ~  *@!"sleA !$@!h47@ #@ !2I@ !/ęoA ~  ,@!/ęoA !$@!@ #@ !{@ !k wA ~  .@!k wA !$@!r>@ #@ !J@=@ !ϊ}A ~  0@!ϊ}A !$@!h f@ #@ !|@ !xƁA ~  1@!xƁA !$@!$@ #@ !@ !7~A ~  2@!7~A !$@!y@ #@ !Ɛf@ !+ilA ~  3@!+ilA !$@!a,A& ~ & <@&!>A& &!$@'&!jwፗ@& &#@' &!8!f@& &!hDA' ~ ' =@'!hDA' '!$@('!y zE@' '#@( '!h_ @' '!@( ~ ( >@(!@( (!$@)(!}E @( (#@) (!x;O@( (!3YS@) ~ ) ?@)!3YS@) )!$@*)!AgY%@) )#@* )!4mX@) )! @* ~ * @@*! @* *!$@+*! 7+Ac@* *#@+ *!H@* *!ښl^@+ ~ + @@+!ښl^@+ +!$@,+!`뗃@+ +#@, +!@#@+ +!7gU9@, ~ , A@,!7gU9@, ,!$@-,![p}@, ,#@- ,!>I@, ,!:i6@@- ~ - A@-!:i6@@- -!$@.-!,_fs@- -#@. -!ep@- -!O@. ~ . B@.!O@. .!$@ .!c@. .#@  .!",zM@. .'x )@Sh  ." $   . Sh . 0 (   pb  6G0*HI@ b I]`t(  >@     7 Fɀ / x&^  dMbP?_*+%"??U}  } } }  } /            @  *@ @ ,@ ,@ ,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@    ! "                      $?%O"A&$@) &@ D D  d~ &@! & @  D D ! (P!A  D D  * +++ ~ "@ )P!A D  #$@ D  #UUUUU@   .#LL d #@ D  #VUUUG@   .# LL #0n!A   .# LL~ @ !0n!A   ."L #$@  ."L !a `@   #@  ."L !PO*@   !l A ~  @!l A #$@ !\@ #@ !=@ !{o A ~  @!{o A #$@ !Q@ #@ !vW@ !P" A ~  @!P" A #$@ !7j'@ #@ !+1<@ !ՀѸc@A ~  @!ՀѸc@A #$@ !U ߪ@ #@ !Uz@ !,98TA ~  @!,98TA #$@ ! /-@ #@ !)yhs@ !fA ~  "@!fA #$@ !c(c\@ #@ !;5@ !-vA ~  $@!-vA #$@ !RbJ\@ #@ !Jkg8@ !PPH6A ~  &@!PPH6A #$@ !hgZ@ #@ !%Fy@ !"slA ~  (@!"slA #$@ !h47V@ #@ !2I@ !/ęA ~  *@!/ęA #$@ !P@ #@ !{@ !k A ~  ,@!k A #$@ !r>H@ #@ !J@=@ !ϊ˩A ~  .@!ϊ˩A #$@ !h f=@ #@ !|@ !xƭA ~  0@!xƭA #$@ !$0@ #@ !@ !7~A ~  1@!7~A #$@ !y!@ #@ !Ɛf@ !+ilA ~  2@!+ilA #$@ !a,@(!fѬA( (#$@) (!,y@( (#@) (!4mX@( (! @) ~ ) ?@)! @) )#$@* )! 7+Ac@) )#@* )!H@) )!ښl@* ~ * @@*!ښl@* *#$@+ *!`뗈@* *#@+ *!@#@* *!ٛ@+ ~ + @@+!ٛ@+ +#$@, +!a-@+ +#@, +!>I@+ +!:i6@@, ~ , A@,!:i6@@, ,#$@- ,!-_f}@, ,#@- ,!ep@, ,!]ŭ@- ~ - A@-!]ŭ@- -#$@. -!ots@- -#@. -!",zM@- -!#A><@. ~ . B@.!#A><@. .#$@  .!Кusd@. .#@  .!^@. .'b)*@th  ."  .  . th@(  pb  6G0*HI@ b I]`$( >@     7 Oh+'0@HTl sRushabh ParekhMicrosoft Excel@(@@՜.+,0 PXd lt| cA Advance+Varying Int-InstBalance+Varying Int-Inst Advance+EMI Balance+EMI  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMOPQRSTUWXYZ[\]Root Entry FWorkbookSummaryInformation(NDocumentSummaryInformation8V