calculator
BA II Plus: Cash Flow Worksheet Step by Step
Enter uneven and repeated cash flows correctly in the BA II Plus CF worksheet.
TL;DR
The CF worksheet handles uneven cash flows and repeated cash flow frequencies. Correct CF0 signs and Fnn frequencies are the main source of exam-day errors.
Formula Reference
Discounted cash flow
Value = sum[CF_t / (1 + r)^t]
The CF worksheet stores the cash flow stream for NPV and IRR.
BA II Plus Keystrokes
- CF
- 2nd CLR WORK
- Enter CF0 and press ENTER
- Scroll to C01 and enter the first cash flow
- Scroll to F01 and enter the frequency if not 1
- Continue for each cash flow block
Worked Example
- Cash flows: -100, 20, 20, 50.
- Enter CF0 = -100, C01 = 20, F01 = 2, C02 = 50, F02 = 1.
- Then use NPV or IRR as needed.
Common Mistakes
- Entering repeated cash flows separately and making a navigation error.
- Skipping CF0.
- Forgetting to clear the worksheet.
Related Guides
- BA II Plus: NPV Calculation Step by Step - Exact BA II Plus keystrokes for net present value with a worked capital budgeting example.
- BA II Plus: IRR Calculation Step by Step - Exact BA II Plus workflow for calculating IRR from uneven project cash flows.
- NPV and IRR Calculations for CFA Level I - Capital budgeting guide for net present value, internal rate of return, and BA II Plus cash flow worksheet inputs.