How to use the ACCRINTM function
The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity.
Formula in cell C7:
Excel Function Syntax
ACCRINTM(issue, settlement, rate, par, [basis])
Arguments
issue | Required. The security's issue date. |
settlement | Required. The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. |
rate | Required. The security's annual coupon rate. |
par | Required. The security's par value. Default value is $1,000. |
[basis] | Optional. The type of day count basis to use. |
Basis | Day count basis |
---|---|
0 (default value) | US (NASD) 30/360 |
1 | Actual/actual |
2 | Actual/360 |
3 | Actual/365 |
4 | European 30/360 |
Functions in 'Financial'
The ACCRINTM function function is one of many functions in the 'Financial' category.
How to use the ACCRINT function
The ACCRINT function calculates the accrued interest for a security that pays periodic interest. Formula in cell C9: =ACCRINT(C2,C3,C4,C5,C6,C7,C8) Excel […]
How to use the ACCRINTM function
The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity. Formula in cell C7: =ACCRINTM(C2,C3,C4,C5,C6) […]
How to use the AMORDEGRC function
The AMORDEGRC function calculates the depreciation for each accounting period. This function is designed for the French accounting system. Formula […]
How to use the AMORLINC function
The AMORLINC function calculates the depreciation for each accounting period. This function is designed for the French accounting system. Formula […]
How to use the CUMIPMT function
The CUMIPMT function calculates the accumulated interest based on a start and end period on a loan. The image above shows […]
How to use the CUMPRINC function
The CUMPRINC function calculates the accumulated principal based on a start and end period on a loan. The image above shows […]
The DB function calculates the depreciation of an asset for a given period using the fixed-declining balance method. Formula in […]
The DDB function calculates the depreciation of an asset for a given period using the double-declining balance method or based […]
How to use the DOLLARFR function
The DOLLARFR function converts a decimal number to its equivalent in fractional numbers, used in securities denominated in dollars. Excel […]
How to use the EFFECT function
The EFFECT function calculates the effective annual interest rate, given the nominal annual interest rate and the number of compounding […]
The FV function returns the future value of an investment based on a constant interest rate. You can use FV […]
The IPMT function calculates the interest payment for a specific period for an investment based on repeated constant payments and a […]
The ISPMT calculates the interest paid during a specific period of an investment. Formula in cell B3: =ISPMT(0.1/12,1,4*12,10000) Excel Function […]
How to use the NOMINAL function
The NOMINAL function calculates the nominal annual interest rate based on the effective rate and the number of compounding periods […]
How to use the PDURATION function
The PDURATION function calculates how many periods required by an investment to reach a given amount based on a percentage […]
The PMT function returns the payment amount needed for borrowing a fixed sum of money based on constant payments and […]
The PPMT function calculates the principal payment for a specific period for an investment based on repeated constant payments and a […]
How to use the PRICEMAT function
The PRICEMAT function calculates the price per $100 nominal value of a bond that pays interest at maturity. Formula in […]
The RATE function returns the interest rate per period of an annuity. Formula in cell E3: =RATE(B3,C3,D3) Excel Function Syntax […]
The RRI function calculates the growth of an investment in percent per period. Formula in cell C6: =RRI(C2, C3, C4) […]
The SYD function calculates the yearly asset depreciation of a given year. Formula in cell C6: =SYD(C2,C3,C4,C5) Excel Function Syntax […]
How to use the TBILLPRICE function
The TBILLPRICE function calculates the par amount (face value) for a Treasury bill. Formula in cell C6: =TBILLPRICE(C2,C3,C4) Excel Function […]
How to use the TBILLYIELD function
The TBILLYIELD function calculates the yield for a Treasury bill. Formula in cell C6: =TBILLYIELD(C2,C3,C4) Excel Function Syntax TBILLYIELD(settlement, maturity, […]
The VDB function calculates the depreciation of an asset for a given period using the double-declining balance method or based […]
The XNPV function calculates the net present value for cash flows that may or may not be periodic. Net present […]
The YIELD function calculates the yield for a security that pays interest. The YIELD function is designed to calculate the […]
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form