Posted inFinance
Understanding Bond-Equivalent Yields for Treasury Bills in Excel
Bond-equivalent yield (BEY) is a way of comparing the returns of different bonds that have…
Posted inFinance
Understanding Bond Yield in the Final Coupon Period: Excel Formula and Calculation
Bond yield is the rate of return that a bond investor can expect to earn…
Posted inFinance
Understanding Bond Simple Yield to Maturity (YTM) Calculation in Excel
Bond simple yield to maturity (YTM) is an estimate of the annual return that an…
Posted inFinance
Understanding Bond Current Yield in Excel
Bond current yield is a measure of the annual income that a bond generates, relative…
Posted inFinance
Understanding Bond Yield to Maturity in Excel
Bond yield to maturity (YTM) is the total rate of return that an investor would…
Posted inFinance
Understanding Ex-Dividend Dates and Calculations in Excel
Ex-dividend is a term that describes when a stock is traded without the right to…
Posted inFinance
Understanding Coupon Dates and Interest Calculation in Excel
A bond is a type of debt instrument that pays interest to the bondholder periodically…
Posted inFinance
Calculating Accrued Interest on Bonds using Excel
Bond accrued interest is the amount of interest that a bond earns, but has not…
Posted inFinance
Understanding Bond Pricing in Excel
Bond pricing is the process of determining the fair value of a bond. A bond…
Posted inFinance
Understanding Asset-Backed Securities in Excel
Asset-backed securities are financial instruments that are backed by a group of assets, such as…