ACCRINTM() Financial Function

[Zumble]

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

 

[ND Pard]

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.