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


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=500250