Solved

excel interest payable

Posted on 2014-10-03
7
67 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
  • 4
  • 2
7 Comments
 
LVL 78

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 25

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 25

Expert Comment

by:ProfessorJimJam
ID: 40360634
see the attached example as well.
C--Users-Jamil-Downloads-Calculate-Inter
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 78

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 25

Assisted Solution

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

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Suggested Solutions

This collection of functions covers all the normal rounding methods of just about any numeric value.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

706 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now