ACCRINTM() Financial Function

  • Thread starter Thread starter Zumble
  • Start date Start date
Z

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
 
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.
 
Back
Top