Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 19th 05, 03:09 PM
MrTaxGuy
 
Posts: n/a
Default 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   Report Post  
Old September 19th 05, 03:25 PM
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Old September 19th 05, 06:20 PM
GeorgeF
 
Posts: n/a
Default


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
looking for a calendar template that I can import multiple dates bkrizman Excel Discussion (Misc queries) 0 June 1st 05 11:16 PM
calculate interest between two dates Arvind Khanna via OfficeKB.com Excel Worksheet Functions 1 June 1st 05 01:18 PM
calculation of interest between two dates Arvind Khanna via OfficeKB.com Excel Worksheet Functions 2 May 26th 05 10:19 AM
COUNTIF With Multiple Dates, Columns and Text Shannon Excel Worksheet Functions 4 November 26th 04 11:12 PM
Seach Column and return multiple dates to another worksheet? Mcasteel Excel Worksheet Functions 0 November 10th 04 07:41 PM


All times are GMT +1. The time now is 06:34 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017