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

ExcelHow to Calculate the Discount Rate of a Security Using DISC in Excel

When you are auditing a massive financial portfolio in Microsoft Excel, calculating the exact discount...

ExcelHow to Calculate Internal Rate of Return for Irregular Cash Flows Using XIRR in Excel

When you are architecting a massive financial model for a startup investment or a complex...

ExcelHow to Calculate Days to the Next Coupon Date Using COUPDAYSNC in Excel

When you are executing a massive financial audit of a corporate bond portfolio in Microsoft...

ExcelHow to Calculate Accrued Interest on Securities Using ACCRINT in Excel

When you are architecting a massive investment portfolio spreadsheet in Microsoft Excel, calculating the accrued...

ExcelHow to Calculate Interest for a Specific Period Using ISPMT in Excel

When you are architecting a massive financial amortization schedule in Microsoft Excel, calculating the exact...

ExcelHow to Translate Numbers to Thai Text Using the BAHTTEXT Function in Excel

When you are managing a massive international financial database in Microsoft Excel, you may encounter...

ExcelHow to Convert Numbers to Different Bases Using the BASE Function in Excel

When you are designing a highly technical networking database or auditing low-level computer science algorithms...

Get the best tech tips delivered straight to your inbox.

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