Most useful Finance formulas and functions in Excel

Undoubtedly Excel is the most used tool in Finance Industry.

Whether you are working as a financial professional or a financial planner or want to plan your own finance, Excel has many formulas related to Financial calculations.



1) Period Payment (PMT): This formula is used for calculating period payments like EMI, monthly income plan, etc.

Apart from PMT, there are other related functions like:

- IPMT & PPMT which gives interest component and principal component for a period



- CUMIPMT & CUMPRINC gives cumulative interest for the period range.

2) Future Value (FV): This formula is used for calculating Future value for current value, payments for a given period of time, and interest rate


3) Present Value(PV): This formula is used for calculating the Present value for future amounts, payments for a given period of time, and interest rate.






Please check this video for complete understanding.

Also attaching the sample file.



Comments

Post a Comment

Popular posts from this blog

How to make Interactive Dashboard on Excel and PowerPoint using Slicer

Image
If you want to make very interactive dashboards in Excel and Powerpoint, Slicer is the feature that you are looking for. Slicer is useful in doing data interaction very easily, be it a Table, Pivot table or any chart. Slicer is a very interactive and single touch alternate to Filter. Also if you have to give your excel to someone for presentation, he/she can manage the same easily using slicer. The slicer can be used in PowerPoint to make interactive presentations and better visualization. In this video Slicer usage with various options is explained with 5 examples. How to apply slicer on a table and properties of a slicer, like size, colour etc? How to apply slicers on multiple fields of a table? How to apply slicer on Pivot Table and Chart? How to apply Slicer on multiple Pivot tables and Charts using the connection and control them using a single slicer? How to use the slicer on Powerpoint? How to insert Slicer: Slicer Options/Styles: Samples: Slicer in PowerPoint
Read more