Excel Formulas

Returns the modified Macauley duration for a security with an assumed par value of $100

Returns the modified internal rate of return for a series of periodic cash flows

Returns the nominal annual interest rate

Returns the number of periods for an investment

Returns the net present value of an investment based on a series of periodic cash flows and a discount rate