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.

Frequently Asked Questions

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.

Related Functions

Get smart about your data.

Connect, sync, and query data from 37+ data sources, without code.
Get unlimited access free for 14 days.