Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Arvind Khanna via OfficeKB.com
 
Posts: n/a
Default calculation of interest between two dates

i had a unique problem. i have to calculate interest on some amount with
relation to some period of fiscal year. for ex

interest on 100 from 1/7/2000 to 31/1/2005(dd/mm/yyyy)

when rate of interest is
1/4/2000 to 31/3/2001 is 12%
1/4/2001 to 31/3/2002 is 11%
1/4/2002 to 31/3/2003 is 10%
1/4/2003 to 31/3/2004 is 12%
1/4/2004 to 31/3/2005 is 8%

kindly help
Arvind

--
Message posted via http://www.officekb.com
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

For each row
1) subtract the earlier date from (1+ the later date) to get the # of days
at that interest rate
2) divide the number of days by the # of days in the year
3) multiply the result by the interest rate times the principal amount
4) sum your results


"Arvind Khanna via OfficeKB.com" wrote:

i had a unique problem. i have to calculate interest on some amount with
relation to some period of fiscal year. for ex

interest on 100 from 1/7/2000 to 31/1/2005(dd/mm/yyyy)

when rate of interest is
1/4/2000 to 31/3/2001 is 12%
1/4/2001 to 31/3/2002 is 11%
1/4/2002 to 31/3/2003 is 10%
1/4/2003 to 31/3/2004 is 12%
1/4/2004 to 31/3/2005 is 8%

kindly help
Arvind

--
Message posted via http://www.officekb.com

  #3   Report Post  
Arvind Khanna via OfficeKB.com
 
Posts: n/a
Default

hi
this does not solve my problem. i wish to enter the 1st date (7/5/2000) and
last date (today or any date ) and the amount on which interest is to be
calculated at simple rate.

Arvind

--
Message posted via http://www.officekb.com
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
Calculation to determine days between two dates Dubleaa Excel Worksheet Functions 3 March 17th 05 04:27 AM
Compound interest calculation Ira Hayes Excel Worksheet Functions 2 January 13th 05 01:20 PM
Compound interest calculation Ira Hayes Excel Discussion (Misc queries) 7 January 13th 05 01:18 PM
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:43 PM
due dates Niki New Users to Excel 4 January 10th 05 05:11 PM


All times are GMT +1. The time now is 06:27 AM.

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

About Us

"It's about Microsoft Excel"