About Cash Flow Curves
Different curve types produce different cash flow curves:
This type of curve: | Does this: |
|---|---|
Calculation | Generates a curve based on sigma and mu values. |
Data from Cost Sheet column | Generates curves based on cost sheet column data. Cost sheet columns entered manually are not included in the curve. |
Manual | Generates a curve based on data that was manually entered into the cash flow sheet, at the project level or CBS level. For this type of curve, users will need to specify the start and end date for the curve. |
Combination Manual and Calculation | Generates a calculation curve with the option of entering values manually. This allows users to plot graphs based on manually entered forecast information, but starting at the end of actual values. This type of curve also allows users to force manually entered numbers to the foot of the column in the Cost Sheet. |
Extrapolate vs. Interpolate
When users create a cash flow curve, they have the option of extrapolating the actual cost based on a provided data set. For example, they can estimate (extrapolate) the cash flow curve for this year based on last year's data. They will need to specify which data from last year's Cash Flow Sheet they want to base the extrapolation on.
Interpolation is estimating the cash flow curve based on known start and end values. There is not an equivalent option to "interpolate" as there is for "extrapolate based on data set," but it is possible to interpolate data by specifying end point cost data. For interpolation, the curve will be based on a specified end point. The base curve and interpolated curve will merge together if the end values are the same.
Users can show both extrapolation and interpolation by specifying an "S Curve" and a beginning calculation point. The curve will be generated from the last point of actual data. To create such a curve at the CBS level, Unifier calculates the extrapolated and interpolated data based on an end point and then sums all the curve points to display one curve from the period where the first value appears.
Last Published Monday, June 3, 2024