ExcelHow to Calculate the Yield of a Periodic-Interest Security Using YIELD in Excel
When you are architecting a financial model to evaluate the absolute profitability of a bond...
ExcelHow to Calculate Accrued Interest at Maturity Using ACCRINTM in Excel
When you are architecting a financial model for a highly specific debt instrument that pays...
ExcelHow to Calculate Accrued Interest for a Security Using ACCRINT in Excel
When you are executing a secondary market transaction for a standard bond that pays periodic...
ExcelHow to Calculate Interest Paid During a Specific Period Using ISPMT in Excel
When you are architecting a complex amortization schedule for a specialized financial loan—specifically a loan...
ExcelHow to Calculate the Number of Payable Coupons Using COUPNUM in Excel
When you are architecting a complex financial model for a massive portfolio of fixed-income securities,...
ExcelHow to Calculate Days in a Coupon Period Using COUPDAYS in Excel
When you are architecting a high-precision financial model for bond trading and you must calculate...
ExcelHow to Calculate the Interest Rate for a Fully Invested Security Using INTRATE in Excel
When you are architecting a complex financial model for a fully invested security (where interest...
ExcelHow to Calculate Bond Price per $100 Face Value Using PRICE in Excel
When you are architecting a complex financial model for corporate or government bonds that distribute...
ExcelHow to Calculate the Number of Periods to Reach a Target Value Using PDURATION in Excel
When you are architecting a complex financial model and you must calculate the exact chronological...
ExcelHow to Calculate Yield for Maturity-Paying Bonds Using YIELDMAT in Excel
When you are architecting a complex financial model dealing specifically with zero-coupon bonds or structured...
ExcelHow to Calculate Future Value With Variable Rates Using FVSCHEDULE in Excel
When you are architecting a complex financial model for a long-term investment (like a variable-rate...
ExcelHow to Calculate Net Present Value for Irregular Cash Flows Using XNPV in Excel
When you are architecting a complex financial model for a capital investment where the cash...
ExcelHow to Calculate Internal Rate of Return for Irregular Cash Flows Using XIRR in Excel
When you are architecting a complex financial model for a private equity investment or a...
ExcelHow to Calculate Treasury Bill Yield Based on Price Using TBILLYIELD in Excel
When you are architecting a complex financial model dealing specifically with government-issued Treasury bills, calculating...
ExcelHow to Calculate Treasury Bill Equivalent Yield Using TBILLEQ in Excel
When you are architecting a complex financial model dealing specifically with government-issued Treasury bills, calculating...
ExcelHow to Calculate Compound Growth Rates Using RRI in Excel
When you are analyzing the mathematical performance of a long-term investment (like a mutual fund...
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...