ExcelHow to Calculate the Next Coupon Date Using COUPNCD in Excel

When you are architecting an algorithmic trading model for fixed-income securities, you must mathematically calculate...

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

When you are auditing a highly complex amortization schedule, you often need to calculate the...

ExcelHow to Calculate the Price of a Security Using the PRICE Function in Excel

When you are architecting a complex fixed-income trading algorithm, calculating the absolute market value of...

ExcelHow to Calculate Accrued Interest Paid at Maturity Using ACCRINTM in Excel

When you are auditing a highly specialized fixed-income portfolio, utilizing standard periodic interest formulas will...

ExcelHow to Calculate Cumulative Interest Paid on a Loan Using CUMIPMT in Excel

When you are architecting a complex debt amortization schedule for a massive corporate loan or...

ExcelHow to Calculate Double-Declining Depreciation Using DDB in Excel

When you are architecting a corporate tax strategy, standard straight-line depreciation is mathematically insufficient for...

ExcelHow to Calculate Fixed-Declining Asset Depreciation Using DB in Excel

When you are architecting a corporate balance sheet, calculating the depreciation of a massive physical...

ExcelHow to Calculate Yield for Bonds Paid at Maturity Using YIELDMAT in Excel

When you are architecting a portfolio containing zero-coupon bonds or highly specialized debt instruments that...

ExcelHow to Calculate Bond Price with an Irregular Last Period Using ODDLPRICE in Excel

When you are auditing a highly complex fixed-income security, a standard corporate bond will pay...

ExcelHow to Calculate Bond Price with an Irregular First Period Using ODDFPRICE in Excel

When you are architecting a complex fixed-income portfolio, bonds rarely possess perfectly symmetrical coupon periods....

ExcelHow to Calculate Modified Macaulay Duration Using MDURATION in Excel

When you are architecting a high-frequency bond trading algorithm, knowing the simple maturity date of...

ExcelHow to Calculate Cumulative Principal Paid Using CUMPRINC in Excel

When you are architecting a complex corporate tax strategy, knowing the principal reduction for a...

ExcelHow to Calculate the Bond Equivalent Yield of a T-Bill Using TBILLEQ in Excel

When you are architecting a complex portfolio containing government debt instruments, comparing a short-term Treasury...

ExcelHow to Calculate Principal Payments Using PPMT in Excel

When you are architecting a massive corporate loan amortization schedule, knowing the total payment (interest...

ExcelHow to Calculate NPV for Irregular Cash Flows Using XNPV in Excel

When you are architecting a complex financial model, standard Net Present Value (NPV) functions rely...

ExcelHow to Calculate Kurtosis Using the KURT Function in Excel

When you are analyzing a massive array of statistical data—such as high-frequency trading returns or...

ExcelHow to Calculate Future Value with Variable Rates Using FVSCHEDULE in Excel

When you are architecting a complex financial model for a variable-rate investment (like a certificate...

Get the best tech tips delivered straight to your inbox.

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