ExcelHow to Calculate Yield for Periodic Securities Using YIELD in Excel

When you are architecting a complex financial model dealing with fixed-income securities that pay periodic...

ExcelHow to Calculate Price for Maturity-Paying Securities Using PRICEMAT in Excel

When you are architecting a complex financial model dealing with specialized fixed-income securities that strictly...

ExcelHow to Calculate Price for Discounted Securities Using PRICEDISC in Excel

When you are architecting a complex financial model dealing with discounted securities—bonds or treasury bills...

ExcelHow to Calculate Bond Price per $100 Face Value Using PRICE in Excel

When you are architecting a complex financial model dealing with fixed-income securities that pay periodic...

ExcelHow to Calculate Interest Rates for Fully Invested Securities Using INTRATE in Excel

When you are architecting a financial model dealing with fully invested securities—where the interest is...

ExcelHow to Convert Decimal Prices to Fractions Using DOLLARFR in Excel

When you are architecting a financial model that must interface with legacy trading systems, you...

ExcelHow to Calculate IRR for Irregular Cash Flows Using XIRR in Excel

When you are architecting an advanced financial model that involves highly sporadic, unpredictable capital injections...

ExcelHow to Calculate Investment Duration Using PDURATION in Excel

When you are architecting a long-term financial strategy and you must mathematically calculate the absolute...

ExcelHow to Convert Numbers to Thai Text Using BAHTTEXT in Excel

When you are architecting a complex international financial model within Microsoft Excel, executing currency translation...

ExcelHow to Convert Half-Width to Full-Width Characters Using DBCS in Excel

When you are auditing a legacy database or importing raw text data from specific Asian...

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

When you are architecting a corporate asset management model, calculating the exact chronological depreciation of...

ExcelHow to Convert Decimal Dollars to Fractional Using DOLLARFR in Excel

When you are architecting a fixed-income trading algorithm or analyzing historical bond prices, the mathematical...

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

When you are architecting a massive, multi-decade fixed-income portfolio, manually counting the exact number of...

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

Get the best tech tips delivered straight to your inbox.

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