Hi,

I know about the ACCRINTM() function in Excel which returns the
Interest-Accrued
between the Issue date and the Settlement date
at a given Rate
for a given "Par" (= "amount").

What I need is a function that will return me the Rate
when I have the Issue date and the Settlement date
and the Interest-Accrued
and the Amount.

Any help appreciated.

TIA
Zumble

ACCRINTM = par x rate x A/D

ACCRINTM is Accrued Interest.

Par is the security's par value.

A = Number of accrued days counted according to a monthly basis. For
interest at maturity items, the number of days from the issue date to the
maturity date is used.

D = Annual Year Basis.

So ...

Rate = Accrued Interest/par x D/A

... I think ... ;-) Good Luck.

"Zumble" wrote:

> Hi,
>
> I know about the ACCRINTM() function in Excel which returns the
> Interest-Accrued
> between the Issue date and the Settlement date
> at a given Rate
> for a given "Par" (= "amount").
>
> What I need is a function that will return me the Rate
> when I have the Issue date and the Settlement date
> and the Interest-Accrued
> and the Amount.
>
> Any help appreciated.
>
> TIA
> Zumble
>
>
>