ExcelHow to Calculate Accrued Interest for a Bond Using ACCRINT in Excel
When you purchase a secondary-market debt instrument (a bond) between its standard coupon payment dates,...
ExcelHow to Calculate the Yield of a Security Paying Interest at Maturity Using YIELDMAT in Excel
When you are analyzing a highly specific class of debt instruments that do not pay...
ExcelHow to Calculate the Price of a Security Paying Interest at Maturity Using PRICEMAT in Excel
When you are executing a financial valuation on a specific class of debt instruments that...
ExcelHow to Calculate the Nominal Interest Rate Using NOMINAL in Excel
When you are analyzing a loan or an investment product, financial institutions often heavily advertise...
ExcelHow to Calculate the Price of a Security with an Odd Last Period Using ODDLPRICE in Excel
When you are executing a financial valuation on a secondary-market debt instrument where the final...
ExcelHow to Calculate the Price of a Security with an Odd First Period Using ODDFPRICE in Excel
When you are architecting a pricing model for a highly specific debt instrument on the...
ExcelHow to Calculate Internal Rate of Return for Non-Periodic Cash Flows Using XIRR in Excel
When you are architecting a complex financial model to evaluate the absolute viability of an...
ExcelHow to Calculate Net Present Value for Non-Periodic Cash Flows Using XNPV in Excel
When you are architecting a complex financial model to evaluate the profitability of an investment,...
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 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 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 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 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...