software

i am getting a loan of Rs10000/- @ 10% pa with monthly rests and the
loan is payable in 18 months (15 months for principal and 3 months for
interest portion). can i have a formula to find out the EMI for the
loan together with the intt as well as the FV of my loan? hlp pl..??!!

-via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=498386Your terminology is very specific to your home country. Unless you have someone
there who is monitoring this group, you'll have to rephrase your question so we
can understand the terms.

What is quot;/-quot;?
What are quot;monthly restsquot;?
Why do you pay off the principal first and the interest last? Most payments are
amortized principal and interest.
What is quot;EMIquot;?

--
Regards,
Fredquot;via135quot; gt; wrote in message
...
gt;
gt; i am getting a loan of Rs10000/- @ 10% pa with monthly rests and the
gt; loan is payable in 18 months (15 months for principal and 3 months for
gt; interest portion). can i have a formula to find out the EMI for the
gt; loan together with the intt as well as the FV of my loan? hlp pl..??!!
gt;
gt; -via135
gt;
gt;
gt; --
gt; via135
gt; ------------------------------------------------------------------------
gt; via135's Profile:
gt; www.excelforum.com/member.php...oamp;userid=26725
gt; View this thread: www.excelforum.com/showthread...hreadid=498386
gt;

yes..mr fred!
you are absolutely correct!
i give below the particulars!
1) quot;/quot; nothing but decimal separator quot;.quot; and quot;-quot; means quot;no decimalquot;
2) quot;monthly restsquot; means interest being applied for monthly products
ie) month end balance.
3) interest is applied on quot;simple interest basisquot; and not on
quot;compounding effectquot;. ie) interest is applied for the month end balance
of principal amount and the interest amount is transferred to another
account for which no interest is applied. that's why the repayment is
being separately fixed for principal amp; interest.

hope i have detailed the things enough and u have understood?

-via135Fred Smith Wrote:
gt; Your terminology is very specific to your home country. Unless you have
gt; someone
gt; there who is monitoring this group, you'll have to rephrase your
gt; question so we
gt; can understand the terms.
gt;
gt; What is quot;/-quot;?
gt; What are quot;monthly restsquot;?
gt; Why do you pay off the principal first and the interest last? Most
gt; payments are
gt; amortized principal and interest.
gt; What is quot;EMIquot;?
gt;
gt; --
gt; Regards,
gt; Fred
gt;
gt;
gt; quot;via135quot; gt; wrote in
gt; message
gt; ...
gt; gt;
gt; gt; i am getting a loan of Rs10000/- @ 10% pa with monthly rests and the
gt; gt; loan is payable in 18 months (15 months for principal and 3 months
gt; for
gt; gt; interest portion). can i have a formula to find out the EMI for the
gt; gt; loan together with the intt as well as the FV of my loan? hlp
gt; pl..??!!
gt; gt;
gt; gt; -via135
gt; gt;
gt; gt;
gt; gt; --
gt; gt; via135
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; via135's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=26725
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=498386
gt; gt;--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=498386
reminding for help!!!

4) EMI means Equated Monthly Instalments..?

-via135

via135 Wrote:
gt; yes..mr fred!
gt; you are absolutely correct!
gt; i give below the particulars!
gt; 1) quot;/quot; nothing but decimal separator quot;.quot; and quot;-quot; means quot;no decimalquot;
gt; 2) quot;monthly restsquot; means interest being applied for monthly products
gt; ie) month end balance.
gt; 3) interest is applied on quot;simple interest basisquot; and not on
gt; quot;compounding effectquot;. ie) interest is applied for the month end balance
gt; of principal amount and the interest amount is transferred to another
gt; account for which no interest is applied. that's why the repayment is
gt; being separately fixed for principal amp; interest.
gt;
gt; hope i have detailed the things enough and u have understood?
gt;
gt; -via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=498386