Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation to determine days between two dates | Excel Worksheet Functions | |||
Compound interest calculation | Excel Worksheet Functions | |||
Compound interest calculation | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |