excel interest payable

I need a excel formula that calculates interest payable based on the following values. So if I put in an amount the start data 1/5/2004  and the end date 1/8/2008 it would give me the amount of interest owed

Year     Daily Rate
2004      0.000055
2005      0.000082
2006      0.000137
2007      0.000164
2008      0.000137
2009      0.000082
2010      0.000055
2011      0.000027
2012      0.000027
2013      0.000027
2014      0.000027
faquueAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
David Johnson, CD, MVPConnect With a Mentor OwnerCommented:
you would need a starting value and for each DAY add the interest, then add the interest to the starting value and compute for the next day
you would need a starting date and an ending date. it is not as simple since the principal increases every time the interest is calculated.
0
 
ProfessorJimJamConnect With a Mentor Commented:
please find attached  two ways calculating it.
C--Users-Jamil-Desktop-Book1.xlsx
0
 
ProfessorJimJamCommented:
see the attached example as well.
C--Users-Jamil-Downloads-Calculate-Inter
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
David Johnson, CD, MVPConnect With a Mentor OwnerCommented:
@ProfessorJimJam  what is the file extension ?? .xls xlsm?
0
 
ProfessorJimJamConnect With a Mentor Commented:
it is xlsx   without macro.
C--Users-Jamil-Downloads-Calculate-Inter
0
 
ProfessorJimJamConnect With a Mentor Commented:
Thanks Netminder.

i have shortened the file name and hereby re-uploaded
CalculateInter.xlsx
0
All Courses

From novice to tech pro — start learning today.