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. |
#2
|
|||
|
|||
response in .programming
-- HTH Bob Phillips "MrTaxGuy" wrote in message ... 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. |
#3
|
|||
|
|||
Mr TaxGuy You have presented a reduced question from a more general topic. However, if this is your question and is based on SIMPLE Interest (no compounding), then the interest charge is: 1000*(.05+.02)/2 or $35 I hope this is what you were asking. GeorgeF -- GeorgeF ------------------------------------------------------------------------ GeorgeF's Profile: http://www.excelforum.com/member.php...o&userid=24124 View this thread: http://www.excelforum.com/showthread...hreadid=468829 |
Reply |
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 |