## What Is the Future Value of Uneven Cash Flows?

Future Value is the total amount of the Present Value and Total Interest. To calculate the future value of uneven cash flows, the future value for each cash flow is calculated, then all values are added to get the total future value.

The formula for calculating the future value of uneven cash flow is given below.

`FV = CF0 * (1+r)^ n + CF1 * (1+r)^ n-1+ CF2 * (1+r)^ n-2 + ……. +CFn`

**CF** represents the Cash Flow, **r** represents Interest Rate and **n** indicates the Total Number of Payment Periods.

## How to Calculate the Future Value of Uneven Cash Flows in Excel: 3 Ways

### Method 1 – Using the FV Function to Calculate the Future Value of Uneven Cash Flows Excel

We have a dataset containing the Time Period (Year), Cash Flow, and the Rate of an investment. We will use this dataset to calculate the future value using the **FV** function.

**Steps:**

- Select cell
**D5**. - Insert the following formula.

`=FV($C$12,$B$10-B5,,C5)`

- Press
**Enter**to get the Future Value. - Drag down the
**Fill Handle**tool to**AutoFill**the formula for the rest of the cells.

- You will get all the values to the future value for each time period using the
**FV**function.

- Select cell
**C13**. - Insert the following formula.

`=SUM(D5:D10)`

- You will get the Total Future Value which is in negative form.

- To convert the value into a positive one, select cell
**C13**and insert the following formula.

`=-SUM(D5:D10)`

- You will get your desired total future value in Excel.

**Read More: **How to Calculate Present Value of Future Cash Flows in Excel

### Method 2 – Use of NPV and FV Functions to Calculate the Future Value of Uneven Cash Flows

We have a dataset containing the Time Period (Year), Cash Flow, Rate, and Total No. of Payment Periods of an investment.

**Steps:**

- Select cell
**C14**. - Insert the following formula.

`=NPV(C12,C5:C10)`

- Press
**Enter**to get the Future Value.

- Select cell
**C15**. - Insert the following formula.

`=FV(C12,C13,,C14)`

- Press
**Enter**to get the Future Value.

- Select cell
**C15**. - Insert the following formula.

`=-FV(C12,C13,,C14)`

- You will get your desired future value in Excel.

**Read More: **Calculate NPV for Monthly Cash Flows with Formula in Excel

### Method 3 – Manually Calculating the Future Value of Uneven Cash Flows in Excel

**Steps:**

- Select cell
**D5**. - Insert the following formula.

`=C5*(1+$C$12)^($B$10-B5)`

- Press
**Enter**to get the future value. - Drag down the
**Fill Handle**tool to**AutoFill**the formula for the rest of the cells.

- You will get all the future values for each time period.

- Select cell
**C13**. - Insert the following formula.

`=SUM(D5:D10)`

- You will get your desired Total Future Value of uneven cash flows.

**Read More: **How to Calculate Future Value in Excel with Different Payments

## Practice Section

We’ve included a practice section in the file so you can test out these methods.

## Download the Practice Workbook

**Related Articles**

- How to Calculate Present Value of Uneven Cash Flows in Excel
- How to Apply Present Value of Annuity Formula in Excel
- How to Calculate Future Value of Growing Annuity in Excel
- How to Calculate Future Value with Inflation in Excel
- How to Calculate Present Value of Lump Sum in Excel
- How to Calculate Present Value in Excel with Different Payments
- How to Apply Future Value of an Annuity Formula in Excel

**<< Go Back to ****Time Value Of Money In Excel ****|** **Excel for Finance**** | ****Learn Excel**