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]

`=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.

`=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.

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.

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.

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.

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.

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.

Drop CSV