Learn finance, banking, risk, data science and fintech

Present Value and Future Value of Uneven Cash Flows – Using BA II Plus Calculator

We have looked at the PV/FV calculations for single sums of money and for annuities in which all the cash flows are equal. However, there may be an investment, where the cash flows are not equal. We will now look at how to calculate the PV and FV of such an uneven series of cash flows.

Look at the following cash flows:

 uneven-cash-flow

Assuming an interest rate of 8%, we will now calculate the present value and future value of this uneven series of cash flows.

Future Value

To calculate the future value of this series of cash flows, we will need to treat each cash flow as independent and calculate its future value. We will adopt the procedure that we used to calculate the future value of a single cash flow.

The following calculations are demonstrated using BA II Plus calculator.

FV1: PV = -500, N = 4, I/Y = 8. CPT > FV = -$680.244

FV2: PV = -600, N = 3, I/Y = 8. CPT > FV = -$755.827

FV3: PV = +1,000, N = 2, I/Y = 8. CPT > FV = +$1,166.400

FV4: PV = +1,500, N = 1, I/Y = 8. CPT > FV = +$1,620

FV5: PV = +2,000, N = 0, I/Y = 8. CPT > FV = +$2,000

Future Value of cash flows = Sum of all Future Values = $3350.328

Present Value

To calculate the future value of this series of cash flows, we will need to treat each cash flow as independent and calculate its future value. We will adopt the procedure that we used to calculate the present value of a single cash flow.

PV1: FV = -500, N = 1, I/Y = 8. CPT > PV = -$462.963

PV2: FV = -600, N = 2, I/Y = 8. CPT > PV = -$514.403

PV3: FV = +1,000, N = 3, I/Y = 8. CPT > PV = +$793.832

PV4: FV = +1,500, N = 4, I/Y = 8. CPT > PV = +$1,102.545

PV5: FV = +2,000, N = 5, I/Y = 8. CPT > PV = +$1,361.166

Future Value of cash flows = Sum of all Future Values = $2280.177

The present value of the uneven series of cash flows can also be calculated using the Cash Flow (CF) key and NPV function.

Try our courses on Data Science for Finance. JOIN FREE

Leave a Reply

Your email address will not be published. Required fields are marked *

Name *

This site uses Akismet to reduce spam. Learn how your comment data is processed.