Excel financial functions are useful for calculating loan or investment performance in Microsoft Excel. These financial functions can calculates all types of financial analysis, such as loan payments, interest rates, length of time to payoff loans, future value of investments, investment returns, and much more. This page provides details on Excel financial functions and links to how to guides showing how to use these Excel financial functions.
PMT – calculates the payment for a loan
RATE – calculates the interest rate for a period for a loan or investment
PV – calculates the present value of a loan or investment
FV – calculates the future value of a loan or investment
NPER – calculates the number of periods for a loan or investment
NPV – calculates the net present value of an investment
IRR – calculates the internal rate of return of an investment