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…
Posted inFinance
Understanding Floating Rate Notes in Excel Formulas
A floating rate note (FRN) is a type of bond that pays interest based on…
Posted inFinance
Hedging Interest Rate Risk with a STRIP in Excel
A strip is a type of interest rate derivative that allows the holder to hedge…
Posted inFinance
Understanding Cross-Market Spread Futures Contracts in Excel
A cross-market spread futures contract is a type of derivative that allows traders to bet…
