+ Reply to Thread
Results 1 to 3 of 3

Need explanation regarding ACCRINTM()

  1. #1
    Registered User
    Join Date
    07-15-2014
    Location
    chennai
    MS-Off Ver
    MS Office 2013
    Posts
    11

    Need explanation regarding ACCRINTM()

    Hi
    ACCRINTM = par x rate x A/D
    In this formula,how is the value of "A" and "D" Calculated.I couldn't understand the explanation given in help document.Could you please help me?

  2. #2
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: Need explanation regarding ACCRINTM()

    From what I understand when reading that it seems the A is the difference in day between the issue and maturity for this function. D would be the number of days in a year. The default is 30/360 so if you do not specify a accrual basis it will assume 30 days per month, 360 days per year regardless of the actual number of days in that month.
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!

  3. #3
    Registered User
    Join Date
    07-15-2014
    Location
    chennai
    MS-Off Ver
    MS Office 2013
    Posts
    11

    Re: Need explanation regarding ACCRINTM()

    Thank you for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] explanation of formula please
    By twiggywales in forum Excel General
    Replies: 10
    Last Post: 04-14-2020, 04:53 PM
  2. [SOLVED] VBA explanation
    By extremis in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 08-09-2013, 10:33 AM
  3. [SOLVED] Explanation on Arrays
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2013, 06:58 PM
  4. VBA explanation
    By Darel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2011, 02:00 AM
  5. Explanation
    By ro55co in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-29-2008, 08:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1