Written by Calculates the number of periods required for an investment to attain a specified value at a given interest rate.
Calculates the net present value of an investment using a series of periodic cash inflows and a specified discount rate.
Determines the number of payment periods required for an investment given consistent periodic payments and a fixed interest rate.
Determines the annual nominal interest rate based on the effective interest rate and the number of times interest is compounded annually.
Determines the modified internal rate of return for an investment by analyzing periodic cash flows and the variance between financing interest rates and returns on reinvested revenue.
Determines the modified Macaulay duration of an investment that pays interest periodically, such as a U.S. Treasury Bond, according to anticipated yield.
The ISPMT function determines the interest accrued over a specified duration of an investment.
Determines the internal rate of return for an investment using a series of cash flows over time.
Determines the interest payment for an investment based on fixed periodic payments and a stable interest rate.
Determines the effective interest rate associated with purchasing an investment for one price and subsequently selling it for another, excluding any interest or dividends that the investment might yield.