ExcelHow to Calculate the Equivalent Interest Rate of an Investment Using RRI in Excel
When you are analyzing the performance of a long-term capital investment where you know the...
ExcelHow to Calculate Interest Paid During a Specific Period Using ISPMT in Excel
When you are managing a structured investment or a specific type of loan where the...
ExcelHow to Calculate the Amount Received at Maturity Using RECEIVED in Excel
When you invest initial capital into a fully invested security (such as a commercial paper...
ExcelHow to Convert Fractional Prices to Decimals Using DOLLARDE in Excel
When you are executing financial modeling on specific legacy debt instruments (like certain U.g. Treasury...
ExcelHow to Calculate the Interest Rate of a Fully Invested Security Using INTRATE in Excel
When you purchase a fully invested security (such as a commercial paper or a short-term...
ExcelHow to Calculate Accrued Interest at Maturity Using ACCRINTM in Excel
When you are trading a highly specific class of debt instruments that do not pay...
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 Investment Timeframes Using PDURATION in Excel
When you are architecting a long-term investment strategy and you know exactly how much initial...
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 Modified Macaulay Duration Using MDURATION in Excel
When you are architecting a high-level financial risk model to evaluate a bond portfolio’s extreme...
ExcelHow to Calculate Bond Equivalent Yield for a T-Bill Using TBILLEQ in Excel
When you are architecting a financial model to evaluate a short-term, zero-coupon government debt instrument...
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,...