Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I calc interest when using multiple dates within a given ye
I am trying to calculate interest using 2 interest rates in 1 calendar year.
Example: Lets say that from January 1, 2005 through June 30, 2005 the interest rate is 5 percent and the interest rate from July 1, 2005 through December 31, 2005 is 2 percent. How much interest is due on $1000.00 if the accrual date starts on 03/01/2005 and is paid on 09/09/2005? Currently, I have a formula that will calculate interest for a given year as long as the interest rate does not change mid-year. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
looking for a calendar template that I can import multiple dates | Excel Discussion (Misc queries) | |||
calculate interest between two dates | Excel Worksheet Functions | |||
calculation of interest between two dates | Excel Worksheet Functions | |||
COUNTIF With Multiple Dates, Columns and Text | Excel Worksheet Functions | |||
Seach Column and return multiple dates to another worksheet? | Excel Worksheet Functions |