Future value formula help

[WBIGGS1000]

Need help with the Excel formula for determining future values. The example I have is $100,000 @6% compounded annually for 5 years with no further deposits. Thanks in advance for the assistance.

[#2]

@WBIGGS1000 

Like this?

[#3]

@WBIGGS1000 

FVSCHEDULE is the function used to arrive at the future value.  The return matches @Riny_van_Eekelen 's solution.  There's always at least 2-3 ways to do something in Excel.  Hopefully one of the solutions provided fits your need.

=FVSCHEDULE(principal,schedule)