How to Calculate Future Value in Excel with Different Payments: 5 Ideal Methods

Method 1 – Calculate Future Value of Periodic Payments in Excel

Steps:

• Select the cell (C9) where you want to keep the future value.
• Calculate the future value of the given data type, the formula:
`=FV(C5/C8, C6*C8, C7)`

C5 refers to the Annual interest rate, C8 refers to the Periods per year, C6 denotes No. of years and C7 represents the Periodic payment respectively.

• Press Enter to get the desired Future Value.

Method 2 – Count Future Value of Single Payment

Steps:

• Select the cell (C8) where we want to keep the Future Value.
• Calculate the future value of the given single payment, type the formula:
`=FV(C5, C6, C7)`

Cells C5, C6 and C7 denote the values of Annual interest rate, No. of years and Investment, respectively.

• Pressing Enter, you will be able to see the Future Value of the single payment.

Method 3 – Irregular Cash Flow Future Value Calculation in Excel

Steps:

• Select cell D8.
• Gain the future value of the cash flow in cell C8 type the formula:
`=FV(\$C\$4, \$B\$11-B8, 0, -C8)`

C4 and B11 denote the Required Return and the final Period whereas B8 and C8 represent the specific Period and Cash Flow value. In this formula, we have used the dollar sign (\$) to lock the respective cells. It will not shift when you copy the formula.

• Press Enter, we will get the future value of the respective cash flow.
• Get all the future values of the cash flows, we need to drag the cursor (+ sign) until we reach the final cash flow.

• We have got all the future values of the individual cash flows.

• Sum up the values of the individual cash flows to acquire the total future value. We are going to use the SUM function. Type the formula in cell D12:
`=SUM(D8:D11)`

D8:D11 represents the individual future values of the cash flows.

• Press Enter to get the total future value.

Method 4 – Get Future Value for Various Compounding Periods

Steps:

• Select cell D5.
• Get the weekly compounded future value, type the formula:
`=FV(\$C\$11/C5, \$C\$12*C5, \$C\$13)`

We have used dollar signs (\$) for the C11, C12 and C13 cells because we need to keep them unchanged after copying the formula for the cells below.

• Press the Enter key.

• Calculate the future value for the other compounding periods by dragging the cursor (+ sign placed at the bottom right corner of the cell) to the cell of the final compounding period.

• We calculated the future values of all types of compounding periods.

Method 5 – Create Future Value Calculator for Both Periodic & Single Payment

Define the arguments in this manner:

• rate (periodic interest rate): C5/C10 (annual interest rate / periods per year)
• nper (total number of payment periods): C6*C10 (number of years * periods per year)
• pmt (periodic payment amount): C7
• pv (initial investment): C8
• type (when payments are due): C9
• compounding periods per year: C10

To calculate the desired future value, we need to combine the arguments.

• Next, we need to select cell C11 and type the formula:
`=FV(C5/C10, C6*C10, C7, C8, C10)`

• Pressing the Enter key, the desired future value will be visible the same as in the picture below.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Sagufta Tarannum

Sagufta Tarannum, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, contributes significantly as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep interest in research and innovation, she actively engages with Excel. In her role, Sagufta not only skillfully addresses challenging issues but also demonstrates enthusiasm and expertise in gracefully navigating intricate situations, underscoring her unwavering commitment to consistently delivering exceptional content. Her interests are Advanced... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF