Nper Function
Nper Function is used for calculating number of periods for an investment based on periodic, constant payments and constant interest rate.
Beat Excel! Get to next level in Excel!
PMT Function
Pmt function is used for calculating payment of a loan based on constant payments and constant interest rate. In other words, it helps you calculate...
FV Function
FV Function is used for calculating the future value of a current amount of money. As discussed in Time Value of Money, value of an...
PV Function
PV Function is used for calculating the present value of a future amount of money. As discussed in Time Value of Money, value of an...
Time Value of Money
This post is a explainatory post for Financial Functions of Excel. In order to understand some of the financial functions, you need to have a...
Excel Gantt Chart
Here is an easy way of creating an Excel Gantt Chart which is pretty responsive and looks nice. It is actually a bar chart formatted...
