ACCRINTM

Definition of NPER:

This formula Calculates the accrued interest of a security that pays interest at maturity.

Sample Usage 

ACCRINTM(DATE(1969,12,31),DATE(1999,12,31),0.05,100,0)

 ACCRINTM(A2,B2,C2,D2,2)

Syntax

ACCRINTM(issue, maturity, rate, redemption, [day_count_convention])

• issue - The date the security was initially issued.

• maturity - The maturity date of the security.

• rate - The annualized rate of interest.
• redemption - The redemption value of the security.
• day_count_convention - [ OPTIONAL - 0 by default ] - An indicator of what day count method to use.

• • 0 indicates US (NASD) 30/360 - This assumes 30 day months and 360 day years as per the National Association of Securities Dealers standard, and performs specific adjustments to entered dates which fall at the end of months.

• • 1 indicates Actual/Actual - This calculates based upon the actual number of days between the specified dates, and the actual number of days in the intervening years. Used for US Treasury Bonds and Bills, but also the most relevant for non-financial use.

• • 2 indicates Actual/360 - This calculates based on the actual number of days between the specified dates, but assumes a 360 day year.

• • 3 indicates Actual/365 - This calculates based on the actual number of days between the specified dates, but assumes a 365 day year.

• • 4 indicates European 30/360 - Similar to 0, this calculates based on a 30 day month and 360 day year, but adjusts end-of-month dates according to European financial conventions.

Notes

• issue and maturity should be entered using DATE, TO_DATE or other date parsing functions rather than by entering text.

Step 1. To use the ACCRINTM Formula, start with the Excellentable you would like to edit. 

Step 2. Then type the NPER formula into the cell you have chosen to display the outcome:

Step 3. Fill in the 5 values- In this example I have chosen 5 values that are the same. 

By adding the values you would like to calculate, Excellentable generates the outcome:

See Also

YIELDDISC: Calculates the annual yield of a discount (non-interest-bearing) security, based on price.

YIELD: Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price.

RECEIVED: Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date.

PRICEMAT: Calculates the price of a security paying interest at maturity, based on expected yield.

PRICEDISC: Calculates the price of a discount (non-interest-bearing) security, based on expected yield.

PRICE: Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.

DURATION: Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value.

DISC: Calculates the discount rate of a security based on price.

COUPPCD: Calculates last coupon, or interest payment, date before the settlement date.

COUPNUM: Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.

COUPNCD: Calculates next coupon, or interest payment, date after the settlement date.

COUPDAYSNC: Calculates the number of days from the settlement date until the next coupon, or interest payment.

COUPDAYS: Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.

COUPDAYBS: Calculates the number of days from the first coupon, or interest payment, until settlement.

ACCRINTM: Calculates the accrued interest of a security that pays interest at maturity.