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)

Calculate Future Value of Periodic Payments in Excel

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.

Calculate Future Value of Periodic Payments in Excel

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)

Irregular Cash Flow Future Value Calculation in Excel

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.

Irregular Cash Flow Future Value Calculation in Excel

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

Irregular Cash Flow Future Value Calculation in Excel

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)

Irregular Cash Flow Future Value Calculation in Excel

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)

Get Future Value for Various Compounding Periods

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.

Get Future Value for Various Compounding Periods

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