Looking for ways to know how to calculate **Future Value **of **uneven cash flows **in Excel? We can calculate the **Future Value **of both even and **uneven cash flows **in Excel. Here, you will find **3 **ways to calculate **Future Value **of **uneven cash flows **in Excel.

**Table of Contents**hide

## Download Practice Workbook

## What Is Future Value of Uneven Cash Flows?

**Future Value** is the total amount of the **Present Value** and **Total Interest**. The** Future Value **can be calculated for both **even **and **uneven cash flow**. To calculate the **Future value** of **uneven cash flows** first **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`

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

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

Here, we will show **3 **different ways to calculate the **Future Value** of **uneven cash flows** in Excel by using different **functions **and **manually **calculating by using the **formula**.

### 1. Using FV Function to Calculate Future Value of Uneven Cash Flows Excel

In the first method, we will show you how to calculate the **Future Value** by using **the FV function**. The **FV function **is used to find out the **Future Value** of **investment **in different **conditions**. It returns a **negative **value which indicates an **outflow **of **cash**.

Here, we have a dataset containing the **Time Period (Year)**, **Cash Flow, **and **Rate **of an investment. Now, we will use this dataset to calculate the **Future Value **using the **FV function**.

Follow the steps given below to do it on your own.

**Steps:**

- Firstly, select Cell
**D5**. - Then insert the following formula.

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

Here, in **the FV function,** we selected Cell **C12** as the **rate **and **fixed **this Cell using** $ **sign. Then, selected the **subtraction **of Cell **B10 **and Cell **B5 **as the **nper **and Cell **C5 **as **pv**.

- After that, press
**ENTER**to get the value of the**Future Value**. - Then, drag down the
**Fill Handle**tool to**AutoFill**the formula for the rest of the cells.

- Finally, you will get all the values to the
**Future Value**for each**Time Period**using the**FV function**.

- Next, select Cell
**C13**. - Then insert the following formula.

`=SUM(D5:D10)`

Here, we used **the SUM function** to **add **the values of Cell range** D5:D10**.

- Now, you will get the value of the
**Total Future Value**which is in**negative**form.

- Then, to convert the value into a
**positive**one select Cell**C13**. - After that, insert the following formula.

`=-SUM(D5:D10)`

Here, we used a **(-)** sign in front of the **SUM function **to **convert **the **Total Future Value **into a **positive **one.

- Finally, you will get your desired
**Total Future Value**in Excel.

**Read More: ****How to Create Cash Flow Statement Format in Excel**

**Similar Readings**

**Create Cash Flow Statement Format with Indirect Method in Excel****How to Calculate Payback Period in Excel (With Easy Steps)****Calculate IRR in Excel for Monthly Cash Flow (4 Ways)****How to Create Monthly Cash Flow Statement Format in Excel****Calculate Cumulative Cash Flow in Excel (with Quick Steps)**

### 2. Use of NPV and FV Functions to Calculate Future Value of Uneven Cash Flows

Now, we will show you how to calculate **Future Value **of **uneven cash flows **using the **NPV **and **FV **functions in Excel. The **NPV function** returns the **Net Present value** of an **investment **using a given **rate**.

Here, we have a dataset containing the **Time Period (Year)**, **Cash Flow**, **Rate, **and **Total No of Payment Period **of an investment. Now, we will use this dataset to calculate the **Future Value **using the **FV **and **NPV **functions.

Go through the steps given below to do it on your own.

**Steps:**

- In the beginning, select Cell
**C14**. - Then, insert the following formula.

`=NPV(C12,C5:C10)`

Here, in **the NPV function,** we selected Cell **C12** as the **rate** and Cell range **C5:C10 **as **values**.

- After that, press
**ENTER**to get the value of the**Future Value**.

- Now, select Cell
**C15**. - Next, insert the following formula.

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

Now, in **the FV function,** we selected Cell **C12** as the **rate, **Cell **C13 **as the **nper **and Cell **C14 **as **pv**.

- After that, press
**ENTER**to get the value of the**Future Value**.

- Then, to convert the value into a
**positive**one select Cell**C15**. - Next, insert the following formula.

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

Here, we used a **(-)** sign in front of the **FV function **to **convert **the **Future Value **into a **positive **one.

- Finally, you will get your desired
**Future Value**in Excel.

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

### 3. Manually Calculating Future Value of Uneven Cash Flows in Excel

In the final method, we will **Manually Calculate **the **Future Value** in Excel. Follow the steps given below to do it on your own.

**Steps:**

- Firstly, select Cell
**D5**. - Then, insert the following formula.

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

Here, we used the conventional **formula **to calculate the **Future Value **given **above**. In the formula, Cell **C5 **is the **Cash Flow**, Cell **C12 **is the **Interest Rate** and the subtraction of Cell **B10 **and Cell **B5 **represents the **Compounding Period**.

- After that, press
**ENTER**to get the value of the**Future Value**. - Then, drag down the
**Fill Handle**tool to**AutoFill**the formula for the rest of the cells.

- Finally, you will get all the values to the
**Future Value**for each**Time Period**.

- Next, select Cell
**C13**. - Then insert the following formula.

`=SUM(D5:D10)`

In the formula, we used the **SUM function** to **add **the values of Cell range** D5:D10**.

- Finally, you will get your desired
**Total Future Value**of**uneven cash flows**in Excel by**manually calculating**.

**Read More: ****How to Calculate Payback Period with Uneven Cash Flows**

## Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

## Conclusion

So, in this article, you will find **3 **ways to calculate **Future Value **of **uneven cash flows **in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit **ExcelDemy** for many more articles like this. Thank you!

**Related Articles**

**How to Calculate Incremental Cash Flow in Excel (2 Examples)****Create Cash Flow Projection Format in Excel****How to Calculate Net Cash Flow in Excel (3 Suitable Examples)****Prepare Daily Cash Flow Statement Format in Excel****How to Calculate Operating Cash Flow in Excel (2 Easy Ways)****Apply Discounted Cash Flow Formula in Excel****Create Cash Flow Statement Format Using Direct Method in Excel**