ExcelHow to Use Power Query in Microsoft Excel to Automate Data Cleaning
Introduction Data analysts often spend a significant amount of time manually cleaning and formatting raw...
ExcelHow to Use the YIELDMAT Function to Calculate Yield at Maturity in Excel
The Anomaly of the Final Payout If you purchase a standard corporate bond, calculating your...
ExcelHow to Use the COUPNCD Function to Calculate the Next Coupon Date in Excel
The Calendar Crisis In the world of corporate finance, missing an interest payment (a “coupon”...
ExcelHow to Use the PRICEMAT Function to Calculate Bond Prices at Maturity in Excel
The Mathematical Exception In standard bond finance, when you purchase a corporate bond, the corporation...
ExcelHow to Use the TBILLPRICE Function to Calculate Treasury Bill Prices in Excel
The Price of Government Debt Unlike standard corporate bonds, United States Treasury Bills (T-Bills) do...
ExcelHow to Use the TBILLEQ Function to Calculate Treasury Bill Equivalent Yields in Excel
The Incomparable Treasury Bill If you are an investor analyzing corporate bonds, comparing two different...
ExcelHow to Use the ODDLYIELD Function to Calculate Odd Last Period Bond Yields in Excel
The Mathematical Distortion In standard bond finance, consistency is the foundation of every single formula....
ExcelHow to Use the ODDLPRICE Function to Calculate Odd Last Period Bond Prices in Excel
The Odd Last Period Problem In standard bond finance, a corporate bond is mathematically symmetrical....
ExcelHow to Use the ODDFYIELD Function to Calculate Odd First Period Bond Yields in Excel
The Mathematical Anomaly In the world of corporate finance, a standard bond is perfectly symmetrical....
ExcelHow to Use the ODDFPRICE Function to Calculate Odd First Period Bond Prices in Excel
The Broken Bond Calendar In standard bond finance, everything is perfectly symmetrical. If a corporation...
ExcelHow to Use the YIELDDISC Function to Calculate Discounted Bond Yields in Excel
The Math of the Zero-Coupon Return If you purchase a standard corporate bond, calculating your...
ExcelHow to Use the DISC Function to Calculate Bond Discount Rates in Excel
The Mystery of the Discounted Bond Unlike standard corporate bonds that pay you interest every...
ExcelHow to Use the RECEIVED Function to Calculate Bond Receipts in Excel
The Confusion of Fully Invested Bonds In standard fixed-income finance, calculating the value of a...
ExcelHow to Use the PRICEDISC Function to Calculate Discounted Bond Prices in Excel
The Math of the Discounted Bond In the world of high-level finance, not all bonds...
ExcelHow to Use the ISPMT Function to Calculate Straight-Line Interest in Excel
The Illusion of Even Payments If you take out a standard $500,000 mortgage from a...
ExcelHow to Use the RRI Function to Calculate Interest Rates in Excel
The Hidden Math of Investments In the world of finance, calculating interest rates manually is...
ExcelHow to Use the PDURATION Function to Calculate Investment Time in Excel
The Uncertainty of Investing If you are a financial advisor managing a client’s retirement portfolio,...