Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 3rd 05, 05:31 AM
V NARENDRAN
 
Posts: n/a
Default 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   Report Post  
Old August 3rd 05, 12:13 PM
Bryan Hessey
 
Posts: n/a
Default


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
How can we use Excel to calculate interest with daily compounding Duke Carey Excel Discussion (Misc queries) 0 June 1st 05 12:08 AM
In excel the formula bar behaves differently on different machines vijay Excel Discussion (Misc queries) 0 May 20th 05 06:27 AM
Excel VB-Copy formula down until adjacent cell (left) is blank? Tony P. Excel Discussion (Misc queries) 1 May 18th 05 06:11 PM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 10:18 PM


All times are GMT +1. The time now is 05:52 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017