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…
Posted inFinance Understanding Bond Warrants in Excel Formulas Bond warrants are a type of derivative that give the holder the right, but not…
Posted inFinance Understanding and Calculating Perpetual Bonds in Microsoft Excel A perpetual bond is a type of bond that has no maturity date and pays…
Posted inFinance Stripping a Bond in Excel Stripping a bond means separating its principal and interest payments into two different securities that…
Posted inFinance Understanding Zero-Coupon Bonds in Excel Formulas A zero-coupon bond is a type of bond that does not pay any interest to…
Posted inFinance Understanding and Calculating Returns on Index-Linked Bonds using Excel Index-linked bonds are a type of bond that pays interest and principal based on an…