Functions
INTRATE
Interest rate for fully invested security
Try it
When to use it
When should I use INTRATE?
Use INTRATE to find the annualised interest rate of a fully-invested security — one that pays no interim coupons but earns a return at redemption, like a Treasury bill.
Used in
Syntax
INTRATE(settlement, maturity, investment, redemption, [basis])Examples
=INTRATE(DATE(2010,1,2),DATE(2019,12,31),90,140,2) // => 0.0547945205479452
=INTRATE(DATE(2008,2,15),DATE(2008,5,15),1000000,1014420) // => 0.05768
=INTRATE(DATE(2010,1,2),DATE(2039,12,31),100,150,1) // => 0.01666971136280599