Balance Sheet Methods

The Balance Sheet Methods worksheet sets the forecasting assumptions for the projected balance sheets.

Adjustments

In the Adjustments column, enter any adjustments necessary to prepare the most recent balance sheet for projection. The corrected balance sheet appears in the Pro Forma Balance Sheet column.

Manual Inputs for Projected Years

The following rows of the worksheet require manual input for the projected years. Enter the data into the white cells in the columns for the projected years.

Minimum Cash Required

Intangible Assets at Cost

Accumulated Amortization

Minimum Short Term Note Balance

Short Term Debt Interest Rate

Stock Issued

Preferred Stock Issued

Treasury Stock Purchases

Preferred Stock Dividends

Projecting the Remaining Accounts

To project the accounts not mentioned in the previous section, repeat these steps for each account:

Select the account that you want to project. To select an account, click anywhere on its row.

Click on the Projections button in the Desktop Toolbar. A dialog box will open.

Use the DCF Projection Dialog Box to set the parameters for projecting the account.