ExcelHow to Calculate Annual Yield at Maturity Using YIELDMAT in Excel

When you are architecting a complex financial model for a legacy bond that does not...

ExcelHow to Calculate Accrued Interest Using ACCRINT in Excel

When you are architecting a complex fixed-income portfolio in Microsoft Excel, tracking a bond that...

ExcelHow to Calculate Security Price at Maturity Using PRICEMAT in Excel

When you are architecting a financial model for a specific class of security that pays...

ExcelHow to Calculate Specific Period Interest Using ISPMT in Excel

When you are architecting a complex financial model for an investment that pays interest on...

ExcelHow to Calculate Macaulay Duration Using DURATION in Excel

When you are analyzing the volatility of a standard coupon-paying bond in Microsoft Excel, you...

ExcelHow to Calculate Macaulay Duration Using MDURATION in Excel

When you are auditing a highly volatile fixed-income portfolio in Microsoft Excel, you must calculate...

ExcelHow to Calculate Coupon Period Days Using COUPDAYS in Excel

When you are auditing a highly volatile bond portfolio in Microsoft Excel, you must frequently...

ExcelHow to Calculate the Number of Bond Coupons Using COUPNUM in Excel

When you are architecting a complex fixed-income bond portfolio in Microsoft Excel, you must know...

ExcelHow to Calculate Specific Period Interest Using ISPMT in Excel

When you are architecting a highly specific loan amortization schedule in Microsoft Excel, you may...

ExcelHow to Calculate Net Present Value for Irregular Cash Flows Using XNPV in Excel

When you are architecting a financial model for a complex project, cash flows rarely occur...

ExcelHow to Calculate Accrued Interest at Maturity Using ACCRINTM in Excel

When you are auditing a highly complex fixed-income portfolio in Microsoft Excel, calculating the accrued...

ExcelHow to Calculate Bond Prices Using the PRICE Function in Excel

When you are architecting a complex fixed-income trading platform in Microsoft Excel, calculating the exact...

ExcelHow to Calculate the Price of Maturity-Interest Securities Using PRICEMAT in Excel

When you are architecting a complex fixed-income portfolio in Microsoft Excel, calculating the exact theoretical...

ExcelHow to Calculate Security Yields Using YIELD in Excel

When you are architecting a high-frequency trading model in Microsoft Excel, determining the exact percentage...

ExcelHow to Calculate Investment Timeframes Using PDURATION in Excel

When you are architecting a long-term investment strategy in Microsoft Excel, determining exactly how long...

ExcelHow to Calculate Modified Macaulay Duration Using MDURATION in Excel

When you are architecting a highly advanced fixed-income financial model in Microsoft Excel, relying solely...

ExcelHow to Calculate Macaulay Duration Using DURATION in Excel

When you are architecting an advanced fixed-income financial model in Microsoft Excel, calculating the Macaulay...

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.