Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I calc interest using 2 interest rates in 1 calendar year
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I calc interest using 2 interest rates in 1 calendar year
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) -- 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loan amortization schedule for variable interest rates | Excel Worksheet Functions | |||
Compounded Interest Rates | Excel Discussion (Misc queries) | |||
interest rates on savings accounts | Excel Worksheet Functions | |||
CD Interest Rates and Lengths Comparisons | Excel Discussion (Misc queries) | |||
Excel formula for monthly interest rates | Excel Worksheet Functions |