Emi & Fv!

[via135]

reminding again for help!!!

i need a formula to get the result for the following:

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..??!!

i give below the meanings for my terminology!

1) "/" nothing but decimal separator "." and "-" means "no decimal"

2) "monthly rests" means interest being applied for monthly products ie, month end balance.
3) interest is applied on "simple interest basis" and not on "compounding effect". 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 & interest.

4) EMI means Equated Monthly Instalments..?


-via135

[Fred Smith]

Your 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 "/-"?
What are "monthly rests"?
Why do you pay off the principal first and the interest last? Most payments are
amortized principal and interest.
What is "EMI"?

--
Regards,
Fred


"via135" <[email protected]> wrote in message
news:[email protected]...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=498386
>

[via135]

yes..mr fred!
you are absolutely correct!
i give below the particulars!
1) "/" nothing but decimal separator "." and "-" means "no decimal"
2) "monthly rests" means interest being applied for monthly products ie) month end balance.
3) interest is applied on "simple interest basis" and not on "compounding effect". 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 & interest.

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

-via135

Your 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 "/-"?
What are "monthly rests"?
Why do you pay off the principal first and the interest last? Most payments are
amortized principal and interest.
What is "EMI"?

--
Regards,
Fred


"via135" <[email protected]> wrote in message
news:[email protected]...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=498386
>

[via135]

reminding for help!!!

4) EMI means Equated Monthly Instalments..?

-via135

yes..mr fred!
you are absolutely correct!
i give below the particulars!
1) "/" nothing but decimal separator "." and "-" means "no decimal"
2) "monthly rests" means interest being applied for monthly products ie) month end balance.
3) interest is applied on "simple interest basis" and not on "compounding effect". 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 & interest.

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

-via135