Our Excel templates provide easy access to many Excel financial functions. You can quickly find the function you need using thr following menu:

You can see 7 groups of functions. If you double click on, for example, 'Investment Interest' item, you will see the following items:

The items are: Investment interest rate functions and Investment interest income functions. If you click on, for example, NPV item, you will see the following window:

To calculate NPV and IRR, you need to enter your data in C column (cash flow values), D1 cell (initial rate of interest for IRR calculation) and E1 cell (rate of interest for NPV calculation). Then click on 'Calculate' button.

If you want to calculate NPV and IRR using Date column (not periodic), then you can click on XNPV or XIRR item.

Annuities Functions

Annutities functions are used to calculate a payment, income, interest rate or number of periods. Annuities payment functions please see below:

Annuities Income, Interest Rates, and number of periods Functions

Securities, amortization and other Financial Excel Functions

Statistical Excel Functions (Correlation, Regression, and more)