Written by The TBILLEQ function in Excel is a financial function used to calculate the equivalent yield of a Treasury bill based on its discount rate and the number of days until maturity. Understanding how to leverage this function can help financial analysts and investors clearly evaluate the returns on Treasury bills, allowing for informed decision-making in the realm of fixed-income securities.
Description To calculate the accrued interest for a stock/bond or other security that pays interest at maturity Syntax ACCRINTM(issue, settlement, rate, par, [basis]) Issue: when the security was issues. Date is in entered as DATE() function or a sequential serial number ex: 8/29/2001 is 44437 Settlement: maturity date rate: annual coupon rate par: par value […]
Description To calculate the accrued interest for a stock/bond or other security with periodic interest Syntax ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) Issue: when the security was issues. Date is in entered as DATE() function or a sequential serial number ex: 8/29/2001 is 44437 First_interest: when first interest is due Settlement: when the […]