19 Financial Functions in Excel

Financial Functions in Excel Tutorial If you are working in any back or financial institutions then you must know financial functions in excel. Just imagine yourself in a loan department of the bank and you are required to tell the monthly EMI amount to the customer based on loan amount, tenure and interest rate. With the help of PMT function in excel you can quickly tell the monthly EMI amount to the customer. In this blog we will show you Present Value Function (PV), Future Value Function (FV), Net Present Value Function (NPV), Payment Function (PMT), investment function like IRR, MIRR, RATE function, XIRR, IPMT function etc.…