Making New Projections

Help Home  Previous  Next

Very Quick Start > Building New Projections

To start constructing a new set of projections, reload WORKPLAN.XLS (or TESTPLAN.XLS) and immediately save it with an appropriate new file name. Then proceed as outlined below.

Note that assumptions and forecasts should only be entered into the designated assumption reports. Output reports (e.g. Income Statements, Cashflow Projections etc.) contain extensive formulae which generate the projections. The only exceptions are the prior-year income statement in the Income Statements and the opening balance sheet in the Balance Sheets which must be entered directly into these reports.

Be sure to save the Exl-Plan XLS file at regular intervals. When doing this, use incrementing file names e.g. PLAN-1, PLAN-2 etc. so that you can easily step backwards if necessary.

Steps

 

Initiating Keystrokes

Remove all existing assumptions

 

ALT+L, L

 

 

Enter basic data about the business, projection start date and currency

 

ALT+L, B

 

 

Enter title for the new model

 

ALT+L, T

 

 

Enter annual assumptions

 

ALT+A etc.

 

 

Enter opening balance sheet & prior year income statement

 

ALT+U, I ALT+U, B

 

 

Final recalculation

 

ALT+L, A

 

 

View Dashboard

 

ALT+U, D

 

 

Save projections

 

ALT+F, S

 

 

Review output reports & charts

 

ALT+U, ALT+C

 

 

Print reports & charts

 

ALT+N, ALT+R

 

See also Quik-Start at the Start worksheet and Online Tutorials.

See Also:

Online Tutorials

Using Exl-Plan

Erasing Existing Values

Gathering & Entering Assumptions

Structuring a Model

Model-Building Procedure

Summary of Procedure for Generating Projections

Detailed Guidance on Generating Projections

Guidance on Entering Assumptions



Online:  Support   Free Registration   Purchase Upgrade