SayPeople

Starting from science and ending nowhere…

Business Research Technology 

Microsoft Excel Tutorial – What is the ACCRINT function?

Usman Zafar Paracha 0 Comments , , , , ,
Microsoft Excel Tutorial - ACCRINT Function

This post contains the illustration to use ACCRINT function in Microsoft Excel. Check SayPeople.com for more information.

ACCRINT Function Rectangle.881 SayPeople.com SayPeople.com Rectangle.880 SayPeople.com SayPeople.com Rectangle.878 SayPeople.com SayPeople.com Rectangle.843 SayPeople.com SayPeople.com Rectangle.844 SayPeople.com SayPeople.com Rectangle.826 SayPeople.com SayPeople.com Rectangle.1068 SayPeople.com SayPeople.com Rectangle.796 ACCRINT Function ACCRINT Function Rectangle.831 ACCRINT(issue, first_interest, settlement, rate, par, frequen… ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) Dynamic connector.832 Dynamic connector.835 example example 2-D word balloon.842 A financial function to calculate the accrued interest for a … A financial function to calculate the accrued interest for a security that pays periodic interest. Dynamic connector.846 gives gives Sheet.77 Sheet.78 Rectangle.851 Rectangle.853 issue: The issue date of the security. issue: The issue date of the security. Rectangle.854 settlement: The settlement date of the security. settlement: The settlement date of the security. Rectangle.855 rate: The annual interest rate of the security. rate: The annual interest rate of the security. Rectangle.856 par: The face value or par value of the security. par: The face value or par value of the security. Rectangle.857 frequency: The number of coupon payments per year (e.g., 2 fo… frequency: The number of coupon payments per year (e.g., 2 for semi-annual, 4 for quarterly). Rectangle.858 [basis]: The day-count basis to use in calculations. It is us… [basis]: The day-count basis to use in calculations. It is usually omitted or set to 0, which represents the U.S. (NASD) 30/360 basis. Rectangle.860 [calc_method]: 0 to calculate accrued interest from first int… [calc_method]: 0 to calculate accrued interest from first interest to settlement, and 1 to calculate accrued interest from issue to settlement Dynamic connector.862 Rectangle.864 Required Required Dynamic connector.865 Rectangle.866 Required Required Dynamic connector.867 Rectangle.868 Required Required Dynamic connector.869 Rectangle.870 Required Required Dynamic connector.871 Rectangle.872 Required Required Dynamic connector.873 Rectangle.874 Optional Optional Dynamic connector.875 Rectangle.876 Optional Optional Dynamic connector.877

You can also get Usman’s book on “Basic Biostatistics with Basic Steps in Microsoft Excel” here: https://amzn.to/40XjM1K (Affiliate link)

Usman Zafar Paracha

Usman Zafar Paracha is a sort of entrepreneur. He is the author of "Color Atlas of Statistics", and the owner of an Android game "Faily Rocket."

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.