Solved

# excel interest payable

Posted on 2014-10-03
67 Views
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
Question by:faquue
• 4
• 2

LVL 78

Accepted Solution

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

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

ID: 40360634
see the attached example as well.
0

LVL 78

Assisted Solution

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

LVL 25

Assisted Solution

ProfessorJimJam earned 300 total points
ID: 40360690
it is xlsx   without macro.
0

LVL 25

Assisted Solution

ProfessorJimJam earned 300 total points
ID: 40367859
Thanks Netminder.

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

## Featured Post

### 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 …

#### Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!