Remember Me?

#1
August 3rd 05, 05:31 AM
 V NARENDRAN Posts: n/a
simple interest formula in excel

I would like to know the formula to be used for calculation of Simple
interest in excel . For compount interest it is Fv as i gather

#2
August 3rd 05, 12:13 PM
 Bryan Hessey Posts: n/a

There are many formula for calculating compound interest by the month or
by the day etc.

The calculation for simple interest is the amount of loan outstanding
times the interest rate for the period, which, for a 10% rate charged
monthly would give you
Loan outstanding * 10 / 1200

However, you might need to check the law in your country, and then
ensure that no interest is charged on any previous interest debited.
This could occur if a payment were not received for a period, or if a
payment of less than the interest for the period was received.

V NARENDRAN Wrote:
I would like to know the formula to be used for calculation of Simple
interest in excel . For compount interest it is Fv as i gather

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM Duke Carey Excel Discussion (Misc queries) 0 June 1st 05 12:08 AM vijay Excel Discussion (Misc queries) 0 May 20th 05 06:27 AM Tony P. Excel Discussion (Misc queries) 1 May 18th 05 06:11 PM Serena Excel Worksheet Functions 4 November 11th 04 11:18 PM

All times are GMT +1. The time now is 08:20 AM.