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