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

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV