How to Calculate Arithmetic Gradient Series Cash Flow Formulas
Question details
The user needs to understand and apply the mathematical formulas to calculate the present value and future value of an arithmetic gradient series of cash flows.

- Product
- Spreadsheet
- Device & OS
- not provided
- Scenario
- Performing financial analysis or engineering economics evaluations where projected cash flows increase or decrease by a constant amount in each consecutive period.
- Observed behavior
- Looking for the exact formulas, variable definitions, and structural approach to evaluate gradient cash flows.
Ensure you have accurately identified your base variables: the initial cash flow amount, the constant period-over-period change (gradient), the interest rate per period, and the total number of periods.
Apply Standard Engineering Economics Formulas
Use the standard present-value (PV) or future-value (FV) mathematical formulas to evaluate the uniform series and the gradient series components.
An arithmetic gradient series consists of two parts: a base annuity (the constant initial cash flow) and the gradient (the constant amount by which the cash flow changes each period). You calculate the total value by summing the present or future values of both parts.
Define your variables: P (initial cash flow or base annuity), G (the constant arithmetic change between periods), i (interest or discount rate per period), and n (total number of periods).
Apply the formula: PV = P × (P/A, i, n) + G × (P/G, i, n). Use standard financial tables or mathematical equivalents to find the Uniform Series Present Worth factor (P/A) and the Arithmetic Gradient Present Worth factor (P/G).
If you need the future equivalent, apply the formula: FV = P × (F/A, i, n) + G × (F/G, i, n). This converts both the base annuity and the gradient change into their cumulative future value at the end of period n.

Use WPS Spreadsheet for Financial Modeling
WPS Spreadsheet provides powerful calculation capabilities, allowing you to organize variables and compute arithmetic gradient series formulas automatically without manual factor lookup.
- 1. Open a Blank Workbook: Launch WPS Spreadsheet and create a new blank workbook to set up your financial model.
- 2. Set Up Your Variables Table: In cells A1 through A4, enter the labels: Initial Cash Flow (P), Gradient (G), Interest Rate (i), and Periods (n). Input their corresponding numerical values in cells B1 through B4.
- 3. Build the Cash Flow Schedule: Create a schedule by listing periods 1 to n in a column. In the adjacent column, calculate the cash flow for each period using the formula: Base Cash Flow + (Period - 1) × Gradient.
- 4. Calculate Net Present Value: Use the built-in =NPV() function on your generated schedule of cash flows, utilizing the interest rate in your variables table to instantly find the total Present Value.

Frequently Asked Questions
What is the difference between an arithmetic and geometric gradient series?
An arithmetic gradient series changes by a constant absolute amount (e.g., adding $50 each period), whereas a geometric gradient series changes by a constant percentage rate (e.g., growing by 5% each period).
How do I calculate the P/G factor manually?
The mathematical formula for the arithmetic gradient present worth factor is: (P/G, i, n) = [ (1 + i)^n - 1 - n×i ] / [ i^2 × (1 + i)^n ]. You can use this directly in a spreadsheet formula.
Can I use standard NPV functions for a gradient series in a spreadsheet?
Yes. Instead of using the complex algebraic formulas, you can map out each period's calculated cash flow in a single column, and then use the spreadsheet's =NPV(rate, value1, [value2], ...) function to find the exact present value.




