Solved

excel interest payable

Posted on 2014-10-03
7
105 Views
Last Modified: 2015-08-25
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
0
Comment
Question by:faquue
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 81

Accepted Solution

by:
David Johnson, CD, MVP earned 200 total points
ID: 40360330
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
 
LVL 26

Assisted Solution

by:ProfessorJimJam
ProfessorJimJam earned 300 total points
ID: 40360449
please find attached  two ways calculating it.
C--Users-Jamil-Desktop-Book1.xlsx
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40360634
see the attached example as well.
C--Users-Jamil-Downloads-Calculate-Inter
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 81

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 200 total points
ID: 40360682
@ProfessorJimJam  what is the file extension ?? .xls xlsm?
0
 
LVL 26

Assisted Solution

by:ProfessorJimJam
ProfessorJimJam earned 300 total points
ID: 40360690
it is xlsx   without macro.
C--Users-Jamil-Downloads-Calculate-Inter
0
 
LVL 26

Assisted Solution

by:ProfessorJimJam
ProfessorJimJam earned 300 total points
ID: 40367859
Thanks Netminder.

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

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question