How do I calc interest using 2 interest rates in 1 calendar year

G

Guest

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.
 
B

Bob Phillips

Assuming the rates are in B1, B2

=1000*((DATE(2005,6,30)-DATE(2005,1,2))/(DATE(2006,1,1)-DATE(2005,1,1))*B1)+
1000*((DATE(2005,9,9)-DATE(2005,6,30))/(DATE(2006,1,1)-DATE(2005,1,1))*B1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I calc interest when using multiple dates within a given ye 2
Help on Interest calculation? Advanced maths ? 16
Code question date, year days ... 5
Break on Calendar Year 4
Excel macro to calc payment/payoff of credit card 1
Calc Prorated Cost based Specific Days in a Gven Month & Year Range. 3
Nesting "IF" statements 5
INT((MONTH($C$1:$C$7)+2)/3)=$A$2 2

Top