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