Future value formula. The basic future value can be calculated using the formula: where FV is the future value of the asset or investment, PV is the present or initial value (not to be confused with PV which is calculated backwards from the FV), r is the Annual interest rate (not compounded, not APY) in decimal, t is the time in years, Being able to calculate out the future value of an investment after years of compounding will help you to make goals and measure your progress toward them. Fortunately, calculating compound interest is as easy as opening up excel and using a simple function- the future value formula. Future value formula example 2 An individual decides to invest $10,000 per year (deposited at the end of each year) at an interest rate of 6%, compounded annually. The value of the investment after 5 years can be calculated as follows