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

  1. CF
  2. 2nd CLR WORK
  3. Enter CF0 and press ENTER
  4. Scroll to C01 and enter the first cash flow
  5. Scroll to F01 and enter the frequency if not 1
  6. 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