header

Using Excel's FV Function

The future value of this investment is given by:

=FV(B5,B7,0,-B8,0)

Where the periodic rate is stored in B5, the number of periods is stored in B7, and the present value is stored in B8. Notice that we are entering the negative of the present value since it represents a cash outflow.