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…
Posted inFinance Understanding Medium-Term Notes (MTNs) in Excel Formulas A medium-term note (MTN) is a type of debt that is issued by a borrower…