ACCRINT Formula

Excel 2010 ACCRINT Formula Displays the total interest gained from an investment product over a certain timeframe
1. Go to Formula tab
2. Click on Financial
3. Select ACCRINT

4. The function arguments window will pop up
5. In the issue input box enter the issue date for the security enclosed with quotes
6. In the first interest input box enter the first date that interest will be paid enclosed with quotes
7. In the settlement input box enter the settlement date for the product enclosed with quotes
8. In the Rate input box the annual rate of interest (percentage)
9. In the Par input box enter the value of the security

10. In the Frequency input box enter the number of annual interest payments
11. In the Basis input box enter 0 or leave blank if you want the average number of days to be 30 days per month

12. Click OK
13. As you can see from my inputs the outputted annual payments I will receive will be 12.50 pounds sterling

Keywords: Financial formula, Excel 2010 ACCRINT Formula , Excel 2010, ACCRINT Formula