Generic Cashflow Tasks

To specify a generic cashflow, you merely define any sequence of date-amount pairs. The flexibility of generic cashflows enables the user to represent economic alternatives or investments that do not fit into loan, savings, depreciation, or bond specifications.

In the Investment Analysis dialog box, select Investment $\rightarrow $ New $\rightarrow $ Generic Cashflow from the menu bar to open the Generic Cashflow dialog box. Enter RETAIL for the Name as in Figure 55.17.

Figure 55.17: Introducing the Generic Cashflow

Introducing the Generic Cashflow


Right-Clicking within the Cashflow Specification Area

Right-clicking within Generic Cashflow’s Cashflow Specification area reveals the pop-up menu displayed in Figure 55.18. The menu provides many useful tools to assist you in creating these date-amount pairs.

Figure 55.18: Right-Clicking within the Cashflow Specification Area

Right-Clicking within the Cashflow Specification Area


The following sections describe how to use most of these right-click options. The Specify and Forecast menu items are described in the sections Including a Generated Cashflow and Including a Forecasted Cashflow.

Adding a New Date-Amount Pair

To add a new date-amount pair manually, follow these steps:

  1. Right-click in the Cashflow Specification area as shown in Figure 55.18, and release on Add.

  2. Enter 01JAN01 for the date.

  3. Enter 100 for the amount.

Copying a Date-Amount Pair

To copy a selected date-amount pair, follow these steps:

  1. Select the pair you just created.

  2. Right-click in the Cashflow Specification area as shown in Figure 55.18, but this time release on Copy.

Sorting All of the Date-Amount Pairs

Change the second date to 01JAN00. Now the dates are unsorted. Right-click in the Cashflow Specification area as shown in Figure 55.18, and release on Sort.

Deleting a Date-Amount Pair

To delete a selected date-amount pair, follow these steps:

  1. Select a date-amount pair.

  2. Right-click in the Cashflow Specification area as shown in Figure 55.18, and release on Delete.

Clearing All of the Date-Amount Pairs

To clear all date-amount pairs, right-click in the Cashflow Specification area as shown in Figure 55.18, and release on Clear.

Loading Date-Amount Pairs from a Data Set

To load date-amount pairs from a SAS data set into the Cashflow Specification area, follow these steps:

  1. Right-click in the Cashflow Specification area, and release on Load. This opens the Load Dataset dialog box.

  2. Enter SASHELP.RETAIL for Dataset Name.

  3. Click OK to return to the Generic Cashflow dialog box.

If there is a Date variable in the SAS data set, Investment Analysis loads it into the list. If there is no date-time-formatted variable, it loads the first available date or date-time-formatted variable. Investment Analysis then searches the SAS data set for an Amount variable to use. If none exists, it takes the first numeric variable that is not used by the Date variable.

Saving Date-Amount Pairs to a Data Set

To save date-amount pairs from the Cashflow Specification area to a SAS data set, follow these steps:

  1. Right-click in the Cashflow Specification area and release on Save. This opens the Save Dataset dialog box.

  2. Enter the name of the SAS data set for Dataset Name.

  3. Click OK to return to the Generic Cashflow dialog box.

Including a Generated Cashflow

To generate date-amount pairs for the Cashflow Specification area, follow these steps:

  1. Right-click in the Cashflow Specification area and release on Specify. This opens the Flow Specification dialog box.

  2. Select YEAR for the Time Interval.

  3. Enter today’s date for the Starting Date.

  4. Enter 10 for the Number of Periods. The Ending Date updates.

  5. Enter 100 for the level. You can visualize the specification in the Cashflow Chart area (see Figure 55.19).

  6. Click Add to add the specified cashflow to the list in the Generic Cashflow dialog box. Clicking Add also returns you to the Generic Cashflow dialog box.

Figure 55.19: Uniform Cashflow Specification

Uniform Cashflow Specification


Clicking Subtract subtracts the current cashflow from the Generic Cashflow dialog box, and it returns you to the Generic Cashflow dialog box.

You can generate arithmetic and geometric specifications by clicking them within the Series Flow Type area. However, you must enter a value for the Gradient. In both cases the Level value is the value of the list at the Starting Date. With an arithmetic flow type, entries increment by the value Gradient for each Time Interval. With a geometric flow type, entries increase by the factor Gradient for each Time Interval. Figure 55.20 displays an arithmetic cashflow with a Level of 100 and a Gradient of 12.

Figure 55.20: Arithmetic Cashflow Specification

Arithmetic Cashflow Specification


Including a Forecasted Cashflow

To generate date-amount pairs for the Cashflow Specification area, follow these steps:

  1. Right-click in the Cashflow Specification area and release on Forecast to open the Forecast Specification dialog box.

  2. Enter sashelp.retail as the Data Set.

  3. Select SALES for the Analysis Variable.

  4. Click Compute Forecast to generate the forecast. You can visualize the forecast in the Cashflow Chart area (see Figure 55.21).

  5. Click Add to add the forecast to the list in the Generic Cashflow dialog box. Clicking Add also returns you to the Generic Cashflow dialog box.

Figure 55.21: Cashflow Forecast

Cashflow Forecast


Clicking Subtract subtracts the current forecast from the Generic Cashflow dialog box, and it returns you to the Generic Cashflow dialog box.

To review the values from the SAS data set you forecast, click View Table or View Graph.

You can adjust the following values for the SAS data set you forecast: Time ID Variable, Time Interval, and Analysis Variable.

You can adjust the following values for the forecast: the Horizon, the Confidence, and choice of predicted value, lower confidence limit, and upper confidence limit.

Using the Cashflow Chart

Three dialog boxes contain the Cashflow Chart to aide in your visualization of cashflows: Generic Cashflow, Flow Specification, and Forecast Specification. Within this chart, you possess the following tools:

You can click on a bar in the plot and view its Cashflow Date and Cashflow Amount.

You can change the aggregation period of the view with the box in the lower-left corner of the Cashflow Chart. You can take the quarterly sales figures from the previous example, select YEAR as the value for this box, and view the annual sales figures. You can change the number in the box to the right of the horizontal scroll bar to alter the number of entries you want to view. The number in that box must be no greater than the number of entries in the cashflow list. Lessening this number has the effect of zooming in upon a portion of the cashflow. When the number is less than the number of entries in the cashflow list, you can use the scroll bar at the bottom of the chart to scroll through the chart.