Overview

After a projection is created, you can modify its properties and delete it.

Steps: Modify Spreadsheet Title and Included Periods

To modify the title and included periods of an existing projection spreadsheet, follow these steps from the projection page:

1. Click in the upper-right corner of the projection spreadsheet and choose Projection Information.

2. Complete the Edit Projection Information dialog box that appears.

To change the number of periods used in the projection, change the number in the Number of Periods in Projection text box.

If you decrease the number, the application will ask you to verify that you want to delete periods from the projection. If you increase the number, the application adds the appropriate number of periods.

You can modify the number of months in a period by clicking the period in the Projection Information dialog box.

Steps: Change Assumption

You can change the assumption used for each account (line) in the projection. Click here for details on the assumption methods.

To change an assumption, follow these steps:

1. Click the appropriate cell (representing the account for a particular period).

2. From the drop-down list at the top of the spreadsheet, choose the desired assumption method.

3. Type the assumption amount or percent in the text box to the right of the drop-down list box.

4. Click the Calculate link at the top of the spreadsheet to have your changes take effect.

Note: The assumption adjustments you make apply only to this particular projection spreadsheet for this particular client.

Steps: Add Cell Memos

You can view, edit, add, or delete comments for any cell (period data for an account) by means of the Cell Memo feature. When a memo exists for a cell, the cell is highlighted in yellow.

To access the cell memo, follow these steps from the projection page:

1. Right-click a cell.

2. Choose Cell Memo from the menu that appears.

See the Cell Memo (Projection) Dialog Box help topic for more information about the options available.

Steps: Balance Projections

Projections are always in balance; you don't have to click a button or perform any other action to balance a projected spreadsheet.

The application uses two accounts to ensure that each projection balances correctly:

• Assets: Excess Funds (EF). This account is treated like cash.

• Liabilities: Additional Funds Required (AFR). This account is treated like short-term debt.

Interest expense is calculated on AFR if you enter an interest rate. However, interest income is not calculated on EF.

One way to use AFR is to set it up as your revolving-debt account. When analyzing short-term requirements, you can force your short-term debt (lines 77 through 79) to zero by setting up the short-term debt with a Dollar assumption method and a value of zero. The AFR account now shows you anticipated short-term-debt requirements.

Steps: Delete Projection

To delete a projection, follow these steps:

1. Open the Select Projection dialog box by using one of the following access methods:

   • Client page: Click the Select Projection action menu option in the Statement Spreads section on a client page.

   • Recent flyout: Right-click the client and select Statement > Select Projection.

   • Historical statement page: From the historical statement page (which must be in edit mode), click the Projections link at the top of the spreadsheet, or click and choose Statement > Select Projection.

2. Right-click the projection you want to delete.

3. Choose the Delete option.

The projection is now deleted.