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