Calculates the interest rate for a fully invested security.
Cú pháp
INTRATE(settlement, maturity, investment, redemption, [basis])Đối số
settlementbắt buộc
The security's settlement date.
maturitybắt buộc
The security's maturity date.
investmentbắt buộc
The amount invested in the security.
redemptionbắt buộc
The amount to be received at maturity.
basistùy chọn
The type of day count basis to use (0-4).
The INTRATE function determines the interest rate for a security that pays interest at maturity. It uses the investment amount and the redemption value to calculate the annual yield based on the time between the settlement and maturity dates.
=INTRATE("2023-01-01", "2024-01-01", 1000, 1050)→0.05Calculates a 5% interest rate for a $1000 investment returning $1050 after one year.
Enter dates
Ensure the settlement and maturity dates are in a recognized date format.
Input financial values
Provide the investment cost and the final redemption value as positive numbers.
Calculate result
Apply the function to return the annual interest rate.
It determines how days are counted, such as US 30/360 or actual/365.