Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 View this thread: http://www.excelforum.com/showthread...hreadid=392413 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How can we use Excel to calculate interest with daily compounding | Excel Discussion (Misc queries) | |||
In excel the formula bar behaves differently on different machines | Excel Discussion (Misc queries) | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |