Forum Discussion

JayGardner's avatar
JayGardner
Copper Contributor
Nov 18, 2021

Future Value of Cash Flows Function

I would like to calculate the FV of a stream of cash flows.  The FV function in Excel requires that the Payments made in every period be the same amount per period.  Is there a function that allows f...
Formulas and Functions
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Dec 11, 2021

Hi JayGardner 

 

For a variable payment stream, you need to define the stream structure and then apply FV() function against each periodic payment.

 

I have made a sample calculation in the attached file for more understanding and clarity.

 

 

Hope this will help you.

 

Thanks

Tauqeer

Resources