Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

How to Use the FV function to calculate total savings account balance

In this example you want to save money for five months. The interest rate is 3.5%. Every month you deposit $500 at the bank. How much money is in your bank account after five months? This question can be answered by using the FV function. It returns the future value of an investment based on [...]

How to use the PV function to decide how much money to invest

In this example you have to decide on the amount of money you want to invest. To solve this problem, you use the PV function, which returns the present value of an investment. This is the total amount that a series of future payments is worth now. Here is the syntax that is used for [...]