Once you are a registered and logged-in user, you can click the Assemble button with the description box for the Case Builder Model on the Models’ page of the site.

Data input is completed in 4 stages, or Steps. Inputs such as labels for line items, financial and operational assumptions can be changed later off-line. However, structural parameters of the Model cannot be easily altered once the Model is purchased.

Hence, there are no default settings for structural parameters. The user needs to consider the options provided and to decide what configuration is desired. Structural options are entered at Step 1 and, partially, at Steps 3. Please read more below.

When assembling a model - to proceed to the next Step click ‘Next’. ‘Save’ button remembers all entered data. After saving you can leave the assembly Steps and continue later by clicking ‘Continue’ button at the top of the User Account page.

When inside the assembler, you can always go one Step further by clicking ‘Next’ or return to previous Step by clicking ‘Back’. If you wish to globally restore default dummy values for assembled Model navigate ‘Back’ to Step 1 and click ‘Restore Default’ button. ‘Reset’ button restores default values locally for any current Step. You can always refer to on-line version of the Manual for more details by pressing ‘Help’ button.

Step 1 configures key settings and parameters of the Model. Note that your choices of language, timeline, number of cases, fixed asset classes and debt elements are structural and cannot be easily altered once the Model is purchased. The following table summarise the choices available to users at Step 1 of the Model’s online assembly:

 

Input field

Comment

Select your language

Current available in English or Russian. Note that switching Model’s language would completely reset your language environment including entry forms and commentary fields.

What is the step interval?

Step interval can be set to year, quarter or month. By definition, the combination of the number of periods and periods’ step would set the timeline for your Model.

What is the start date?

The Model assembler would only allow a first date of any month to be the Model’s start date. Non-conforming day of the month entry will automatically revert to the first day of the month chosen by user.

Note that, if your start data is not January 1st then your reporting periods and annual summaries would not fall on calendar quarter and year ends.

How many periods do your require?

Can be set to any integer value between 3 and 60. By definition, the combination of the number of periods and periods’ step would set the timeline for your Model.

Please note that when selecting monthly or quarterly periods you are not restricted to make the total match to full number of years. For example, your project can forecast out for 38 months, or equivalent to 3 years and 2 months. In such a case, the annual summary would only pick up two months in the fourth year of your forecast. The annual DCF and IRR tab would not compute properly unless adjusted accordingly – please refer to section 3.12 of the Manual.

If your project is very short-term, e.g. less than 2 years, additional consideration should be given to IRR calculations as described in section 3.12 of the Manual.

How many Cases in the model?

Can range from 2 to 5. Each case has independent revenue, direct costs and overheads assumptions. Please see details for Step 3 below.

How many Fixed Assets Items in the model?

Can be any integer value between 1 and 5. This is a structural input and cannot be reversed once the Model is purchased. For each class of the Fixed Assets you can create its own amortisation profile as described in Step 7 below. Once you download the Model you can populate data for your forecast investment program. This information is not available for input at the assembly stage on-line.

How many Debt Instruments Items in the model?

 

Allowed range is between 1 and 5. Please note that the first debt element is always present and is an automatic cash sweep, or an overdraft facility. This balances your cash flows irrespective of whether your project or business is cash-generative or cash-consuming in any forecast period. All additional debt elements have manual repayment schedules. You can populate these in accordance with your debt terms once the Model is purchased.

 

This Step has no structural inputs and can be skipped during on-line assembly except for selecting your currency option.

Select your currency option as described below and skip the rest of this Step if you are happy to receive the Model with default labels and values. You can replace any of these off-line when the Model is purchased.

The following table summarise the choices available to users at Step 2 of the Model’s online assembly:
 

Input field

Comment

Labels for Cost of Goods Sold Items

 

By default, you are offered four COGS items. Please also note that you cannot have variations in labels for different Cases.

Labels for Overhead Items

 

By default, you are offered four Overhead items.

Your Corporate Tax Rate

Sets the income (corporate) tax rate. The default (dummy) value is 20%.

Currency, select from list

Customise currency

Sets the Model’s currency. The Model does not conform to any currency coding standard so you can input any name or currency code as needed by typing a text value or a symbol of your choice. For example, your currency can be GBP or £. Alternatively, select most common currency codes from the pull down menu provided.

Currency unit

Sets scales for monetary units. Default value is in thousands, or 000s. If you wish to change to millions or any other scale, you would have to make sure the revenue line in the Model is computing properly – e.g. if your revenues are expressed in millions then your sales volume is assumed to be in millions too.

 

Step 3 has a combination of structural and non-structural elements. The structural elements refer to your choice of fixed vs. variable drivers for cost elements (see detailed description below). The assumptions for your sales forecasts and the values assigned to selected drivers are not structural and can be modified off-line.

Step 3 is broken into the number of sub-steps equivalent to the number of Cases chosen at Step 1. Hence, if you only chose two Cases, only two sub-steps will appear. If you select more, then you should expect to as many sub-steps as chosen at Step 1.

The following step-by-step guide is referring to one Case only as each product input screen is identical to the others. Note that Step 3 field legends react to your choice of inputs from previous Steps. For example, if you configured the Model to be in USD and in 000’s, legends for Step 3 would incorporate your choices as shown in the table below (legends dependent on previous Steps are shown in [square brackets]).

At this Step you can (repeated for each Case):
 

Input field

Comment

Default Value > [Base]

Name your case for easy of reference. Note that you can re-label cases off-line in the purchased copy of the Model.

Revenue Assumptions

For First Forecast Period

  Volume, [‘000s]

  Average Price, [USD]

  Revenue, [‘000s USD]

For [N] Next Forecast Periods

  Volume Growth, % per annum

  Price Growth, % per annum

Captures forecasts for physical sales volume and product pricing assumptions. Note that data for the first forecast period is entered in absolute terms is the base level for driving subsequent periods by growth rates.

If you do not wish to have independent drivers for volume and pricing, then set the volume of sales and its growth factor to 1 and 0 respectively. Your pricing and revenue lines will then show identical data for all forecast periods.

Cost of Goods Sold Assumptions

[Raw Materials] * 4 elements

For First Forecast Period

  [‘000s USD] 

For [N] Next Forecast Periods

  Fixed / Variable Driver

  Input, %

Overhead Assumptions

[Administration] * 4 elements

For First Forecast Period

  [‘000s USD] 

For [N] Next Forecast Periods

  Fixed / Variable Driver

  Input, %

Captures forecasts for cost of goods sold and overhead assumptions. Note that data for the first forecast period is entered in absolute terms as the base level for driving subsequent periods by growth or margin rates.

The fixed/variable driver input requires user to identify the type of driver for each cost element: fixed cost element will forecast out at growth rates set by user; variable cost element is modelled as a percentage of revenue (e.g. margin driven). This choice is structural and cannot be reversed once the Model is purchased. 

By default, all COGS elements are preset to be variable costs, while all overhead elements are fixed costs. You can change fixed-variable assumption on item-by-item basis irrespective whether such item belongs to COGS or Overheads category.

However, fixed-variable settings for the first Case is universal for all Cases. It is not possible to have Raw Materials as a fixed cost for [Base] Case and then as a variable for  [Optimistic] Case. The choice is driven by the logic of your business and not by an operating Case.

 

This Step has no structural inputs and can be skipped during on-line assembly if you are happy to have the downloaded Model populated with dummy numbers.

You can replace dummies off-line once the purchased Model is downloaded. If you choose to insert your assumptions, note that such data or similar financial information on your business or project is stored on our servers for seventy-two hours only. Beyond this timeframe, the data in the archived Model reverts to dummy numbers.

The following table summarise the choices available to users at Step 4 of the assembly:
 

Input field

Comment

‘Clear Balance’ button

If your project or business is a green field and has no prior history then the opening balance sheet can be set to zero. The Clear Balance button on the right hand side of the input form will null all balance sheet items with one click.

Long Term Assets

  Gross PP&E

  Accumulated Depreciation

  Net Fixed Assets

  Financial Investments

  Deferred Tax Assets

  [Other Long Term Assets]

Current Assets

  Cash

  [Debtors]

  [Inventory]

  [Other CA]

Current Liabilities

  [Creditors]

  [Short Term Revolver]

  [Other CL]

Long Term Liabilities

  [Bank Debt Tranche A – D]

  [Other Long Term Liabilities]

Equity & Reserves

Allows populating data for your opening balance sheet items. The balance sheet structure is fixed (except for number of debt elements selected at Step 1) and cannot be changed.

Note that Step 4 field legends react to your choice of inputs from previous Steps. For example, if you configured your Model to have two debt facilities and custom named them, Step 4 would incorporate your choices (legends dependent on previous Steps are shown in [square brackets]).

If your historic balance sheet has more items than what is provided for by the assembler, we suggest you analytically aggregate these to match the number of items allowed in the Model.

This step also allows for entry of interest rates assumptions for cash/debt items and days turnover ratios for calculating the working capital requirements. These are not structural changes and can be changed later off-line.

To change interest rates assumptions directly in the Model go to the opening balance sheet tab. Working capital drivers can be found in the working capital tab of the Model.

Check

You cannot proceed to the next input step if the total assets and liabilities values do not match. The check field at the bottom of the input screen would indicate an error if there is a mismatch.


You are done customising your Model.

After completing Step 4 you can click ‘Next’ and select ‘Request Demo’ button. The demo version of the Model would be assembled and appear in your User Account available for download. You will receive a notification via email that your demo is ready. Requesting a demo is free.

The demo version would not have any live formulae or links. Otherwise all formats, settings and labels would be exactly as profiled by you during the on-line assembly stage.

Please note that the input form does not allow for entry of your CapEx programme. It should not be a cause of concern that the demo version does not show any investments going forward throughout the forecast periods.

CapEx programme and depreciation rates can be populated off-line when working with the Excel file of the purchased Model. Most labels for line items, currency, units and more can also be changed with ease. Please refer to following section of the Manual for details.

Please study the demo to ensure that all the structural and labelling elements come out as desired. If something is not right at this stage, you can assemble a new model with revised input parameters.

Alternatively, you can proceed to Buy options and get a fully functioning Model delivered to your User Account. You can always convert any of your demos stored in the User Account to a live working Model by clicking on Buy option next to the demo Model you wish to purchase.