Forum Discussion
Future value formula help
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.
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)