ACCRINTM() Financial Function

Giganews Newsgroups
Subject: ACCRINTM() Financial Function
Posted by:  Zumble (Zumb…@Zumble.Zumble)
Date: Thu, 10 Jul 2008

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

Replies