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...