Cash Flow Worksheet

Use the Cash Flow worksheet to solve problems with unequal cash flows.

To solve problems with equal cash flows, use the TVM worksheet. Time-Value-of-Money and Amortization Worksheets

To access the Cash Flow worksheet and initial cash flow value (CFo), press '.
To access the cash flow amount and frequency variables (Cnn/Fnn), press # or ".
To access the discount rate variable (I), press (.
To compute net present value (NPV), net future value (NFV), payback (PB), and discounted payback (DPB), press # or " and C for each variable.
To compute the internal rate of return (IRR), press ).
To compute the modified internal rate of return (MOD), press # to access the reinvestment rate (RI) variable, key in a value, and press #.

Topic Links