Opening Balance Sheet

Help Home  Previous  Next

Guidance on Entering Assumptions > Opening Balance Sheet

To complete the entry of assumptions, values must be entered for an opening balance sheet. This is accessed via the *Output > Balance Sheets menu command. Once values have been entered, recalculate (using *Tools/Setup > Calculate All & Check to confirm that the opening balance sheet balances and that there are no calculation errors in the model. If there is an imbalance, CHECK balance sheet balances at the very bottom will indicate the magnitude and direction of the imbalance.

If the business is a start-up, then the opening balances may be set to zero throughout.

See Also:

Assumptions Report No. 1 - Sales Forecasts

Assumptions Report No. 2 - Materials/Goods, Other Direct Costs & Purchases

Assumptions Report No. 3 - Overhead Expenses

Assumptions Report No. 4 - Fixed Assets

Assumptions Report No. 5 - Funding, Interest Rates & Related Items

Assumptions Report No. 6 - Sales & Related Taxes

Assumptions Report No. 7 - Year-End Credit Balances

Prior-Year Income Statement

Detailed Guidance on Generating Projections

Guidance on Entering Assumptions

Changing Exl-Plan

Online:  Support   Free Registration   Purchase Upgrade