Formula for accrued interest of a CD, as of today?

[bubba]

I am trying to determine the accrued interest, as of "today's date", on
a Certificate of Deposit (CD).
The formula needs to be used with a 15 to 20 CD's, each with different
interest rates, principle amounts, and lengths of maturity.

I see several formulas but nothing specific for what I'm trying to do.
However, it seems possible that one of the financial functions can be
made to yield the desired output. Not sure which function to use, and
how to utilize for this application.

Available data:
1. Initial deposit date.
2. Initial deposit amount.
3. Annual rate of return.
4. Length of CD in days

Assumptions:
1. Single deposit at beginning of term.
2. No withdrawals during term.
3. Compounds quarterly.

Desired output:
_Accrued interest to date_, calculated each time I open the
spreadsheet, without having to enter any additional data.

_
_Thanks in advance for any help on this.


John

 

[Bob Greenblatt]

I am trying to determine the accrued interest, as of "today's date", on
a Certificate of Deposit (CD).
The formula needs to be used with a 15 to 20 CD's, each with different
interest rates, principle amounts, and lengths of maturity.

I see several formulas but nothing specific for what I'm trying to do.
However, it seems possible that one of the financial functions can be
made to yield the desired output. Not sure which function to use, and
how to utilize for this application.

Available data:
1. Initial deposit date.
2. Initial deposit amount.
3. Annual rate of return.
4. Length of CD in days

Assumptions:
1. Single deposit at beginning of term.
2. No withdrawals during term.
3. Compounds quarterly.

Desired output:
_Accrued interest to date_, calculated each time I open the
spreadsheet, without having to enter any additional data.

_
_Thanks in advance for any help on this.


John

You should be able to do this with IRR and use now() or today() for the
date. It will automatically update when the sheet is opened.