# INTRATE

Formulas / INTRATE
Calculate the annual effective interest rate for a security that is fully invested.
`=INTRATE(settlement, maturity, investment, redemption, [basis])`
• Settlement - date of the security
• Maturity - date of the security
• Investment - amount originally invested
• Redemption - amount received at maturity
• Basis - [OPTIONAL]

## Examples

• `=INTRATE(DATE(2017,7,6),DATE(2020,1,15),895,1000,0)`

The function can be used to calculate the annual effective interest rate on a bond. For example, this returns 4.65%, which is the annual effective interest rate for a bond with a price of \$895 and a redemption value of \$1000.

• The function can also be used to calculate the annual effective interest rate on a bond that has been held for a period of time. For example, this returns the 4.65% annual effective interest rate for a bond with a price of \$895 that has been held for 6 months.

• `=INTRATE(DATE(2020,1,1),DATE(2020,2,1),1000,1100,0)`

The function can also be used to calculate the annual effective interest rate on a bond that has not been held for a period of time. For example, this returns the 4.00% annual effective interest rate for a bond with a price of \$1000 and a redemption value of \$1100.

## Summary

The INTRATE function calculates the interest rate of a fully invested security based on the settlement, maturity, investment, redemption, and basis arguments.

• The INTRATE function calculates the annual effective interest rate for a security that has been fully invested, which does not pay periodic interest before it matures.
• Interest income is the difference between the redemption value of the security and the original investment.
• The arguments for the INTRATE function are settlement, maturity, investment, and redemption.
• The optional basis argument controls how days are counted in the data set.

What is the INTRATE function?
The INTRATE function is a Sourcetable function that calculates the interest rate for a security that is fully invested. It is used to determine the amount of interest that a security accrues over time.
What are the arguments for the INTRATE function?
The arguments for the INTRATE function are:
• Settlement: The date the security is purchased.
• Maturity: The date the security matures.
• Investment: The amount invested in the security.
• Redemption: The amount received when the security matures.
• Basis: The day count basis used in the calculation.
How do I use the INTRATE function?
The INTRATE function is used by entering the arguments into the function. For example, to calculate the interest rate for a security that is purchased on January 1st, matures on June 1st, and has an investment amount of \$100, redemption amount of \$110, and basis of 0, the function would be entered as follows:
=INTRATE(1/1/2019, 6/1/2019, 100, 110, 0)
The result of this function would be the interest rate received from the security.