# Accrued Interest total with quarterly rate changes

1. ## Accrued Interest total with quarterly rate changes

Summary:
I have an amount of \$170 (D76). The starting date is 7/15/05 (D66). Payment date of interest is 12/15/2012 (D3). Interest rate change on a quarterly basis. These rate amount are located in D32 - D55 and H32-H55. Interest should be compounded daily. I have attached the file for your review.

Cells K71-K76:
I need to write a formula that will calculate the related interest on the amounts in D71-D76. Is there a look-up feature that can do this? Or, should I just work out a formula for each quarter period?1291-Working.xlsx

Thank you for the help.
Tim

2. ## Re: Accrued Interest total with quarterly rate changes

the value in D76 is \$184.78
the value in C76 is 170...days
??

3. ## Re: Accrued Interest total with quarterly rate changes

Stock of a foreign company was purchased on 7/15/05 (D66) and sold on 10/31/11 (E66), with a gain of \$2500 (F66). The gain is allocated on a per day basis. The amount of days in the year of sale is 304 (H66) and provides a year of sale gain of \$330 (J66). The 304 days in the year of sale is considered non-interest bearing day (no interest is to be added to the amount of this tax). The remaining amount of days of 1,996 are considered interest bearing days - keep reading as it will make since later. These days are counted backwards in time allocated the gain to the appropriate tax year (C71-C76). The gain for each tax year (D71-D76) is taxed on the marginal rate the tax payer had for that year. (This is entered E18-E20 & K18-K20.) The tax for each year is calculated in F71-F76, related foreign taxes are entered in the next cell and subtracted from the tax, provided a net tax increase in H71-H76. Here is were the interest part comes up. Because the tax is from a prior year, interest is to be added to the tax amount. The interest rates and the quarterly period they are for have been entered in C32/D32 - C55/D55 and G32/H55 - G55/H55. I need a formula that will find the interest rates to be used to calculated the interest on each tax year up to the payment dated entered in D3.
Thank you!

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1