Bond | search
Click here to view Bond news from 60+ newspapers.
Bookmark or Share- Excel functions (by category) - Microsoft SupportWorksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
- DURATION function - Microsoft SupportThe DURATION function, one of the Financial functions, returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price's response to changes in yield.
- YIELD function - Microsoft SupportReturns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield. Syntax. YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])
- Financial functions (reference) - Microsoft SupportFinancial functions (reference) Applies To. To get detailed information about a function, click its name in the first column. Function. Description. ACCRINT function. Returns the accrued interest for a security that pays periodic interest. ACCRINTM function. Returns the accrued interest for a security that pays interest at maturity.
- MDURATION function - Microsoft SupportThe settlement date is the date a buyer purchases a coupon, such as a bond. The maturity date is the date when a coupon expires. For example, suppose a 30-year bond is issued on January 1, 2008, and is purchased by a buyer six months later.
More
