Solved

excel interest payable

Posted on 2014-10-03
7
99 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 80

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
Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

 
LVL 80

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

730 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