|
Navigation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Base Model |
|
|
Global |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
|
|
Project Name |
Project_Name |
|
|
Financial
Robot |
|
|
|
Model Revision |
Model_Date |
|
|
03 Sep 14 |
|
|
|
|
Model Name |
Model_Name |
|
|
Base Model |
|
|
|
|
|
|
|
|
|
Period Start Date |
Date_BoP |
|
|
01 Sep 14 |
01 Oct 14 |
01 Nov 14 |
01 Dec 14 |
01 Jan 15 |
01 Feb 15 |
01 Mar 15 |
01 Apr 15 |
01 May 15 |
01 Jun 15 |
01 Jul 15 |
01 Aug 15 |
01 Sep 15 |
01 Oct 15 |
01 Nov 15 |
01 Dec 15 |
01 Jan 16 |
01 Feb 16 |
01 Mar 16 |
01 Apr 16 |
01 May 16 |
01 Jun 16 |
01 Jul 16 |
01 Aug 16 |
01 Sep 16 |
01 Oct 16 |
01 Nov 16 |
01 Dec 16 |
01 Jan 17 |
01 Feb 17 |
01 Mar 17 |
01 Apr 17 |
01 May 17 |
01 Jun 17 |
01 Jul 17 |
01 Aug 17 |
01 Sep 17 |
|
|
Period End Date |
Date_EoP |
|
31 Aug 14 |
30 Sep 14 |
31 Oct 14 |
30 Nov 14 |
31 Dec 14 |
31 Jan 15 |
28 Feb 15 |
31 Mar 15 |
30 Apr 15 |
31 May 15 |
30 Jun 15 |
31 Jul 15 |
31 Aug 15 |
30 Sep 15 |
31 Oct 15 |
30 Nov 15 |
31 Dec 15 |
31 Jan 16 |
29 Feb 16 |
31 Mar 16 |
30 Apr 16 |
31 May 16 |
30 Jun 16 |
31 Jul 16 |
31 Aug 16 |
30 Sep 16 |
31 Oct 16 |
30 Nov 16 |
31 Dec 16 |
31 Jan 17 |
28 Feb 17 |
31 Mar 17 |
30 Apr 17 |
31 May 17 |
30 Jun 17 |
31 Jul 17 |
31 Aug 17 |
30 Sep 17 |
|
|
|
|
|
Month Counter |
Month_Count |
|
1.0 |
2.0 |
3.0 |
4.0 |
5.0 |
6.0 |
7.0 |
8.0 |
9.0 |
10.0 |
11.0 |
12.0 |
13.0 |
14.0 |
15.0 |
16.0 |
17.0 |
18.0 |
19.0 |
20.0 |
21.0 |
22.0 |
23.0 |
24.0 |
25.0 |
26.0 |
27.0 |
28.0 |
29.0 |
30.0 |
31.0 |
32.0 |
33.0 |
34.0 |
35.0 |
36.0 |
37.0 |
|
|
Quarter Counter |
Quarter_Count |
|
1.0 |
1.0 |
1.0 |
2.0 |
2.0 |
2.0 |
3.0 |
3.0 |
3.0 |
4.0 |
4.0 |
4.0 |
5.0 |
5.0 |
5.0 |
6.0 |
6.0 |
6.0 |
7.0 |
7.0 |
7.0 |
8.0 |
8.0 |
8.0 |
9.0 |
9.0 |
9.0 |
10.0 |
10.0 |
10.0 |
11.0 |
11.0 |
11.0 |
12.0 |
12.0 |
12.0 |
13.0 |
|
|
Year Counter |
Year_Count |
|
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
4.0 |
|
|
Number of Periods Flag |
Nperiod |
|
12.0 |
|
|
Time step name |
step_name |
|
Months |
|
|
Income Tax |
CT |
|
20.0% |
|
|
Currency |
FX |
|
GBP |
|
|
Currency Unit |
X |
|
000s |
|
|
|
Input Labels for P&L
and BS items =>> |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
COGS Items |
|
Central Costs & Overheads Operating Assumptions |
|
|
Capex & Dep'n |
|
|
|
|
|
Name or Name Range |
Assign Value |
|
Name or Name Range |
Assign Value |
|
Name or Name Range |
Assign Value |
|
|
|
|
COGS1 |
|
Raw Materials |
|
CCosts1 |
|
Sales & Marketing |
|
FAssets1 |
|
Buildings |
|
|
|
|
COGS2 |
|
Personnel |
|
CCosts2 |
|
Administration |
|
FAssets2 |
|
Machines |
|
|
|
|
COGS3 |
|
Fuel & Utilities |
|
CCosts3 |
|
Rent & Leases |
|
FAssets3 |
|
Equipment |
|
|
|
|
COGS4 |
|
Rent & Leases |
|
CCosts4 |
|
Consulting |
|
FAssets4 |
|
Land |
|
|
|
|
COGS5 |
|
Other COGS |
|
CCosts5 |
|
Other CC |
|
|
|
|
|
|
|
|
|
|
Working Capital Items |
|
Debt & Long Term Balance Sheet Items |
|
|
|
|
|
|
Name or Name Range |
Assign Value |
|
Name or Name Range |
Assign Value |
|
|
|
|
|
Wcapital1 |
|
Debtors |
|
OtherLTA |
|
Other Long Term Assets |
|
|
|
|
|
Wcapital2 |
|
Inventory |
|
OtherLTL |
|
Other Long Term
Liabilities |
|
|
|
|
|
Wcapital3 |
|
Creditors |
|
Revolver |
|
Short Term Revolver |
|
|
|
|
|
|
Wcapital4 |
|
Other CA |
|
LTDebt1 |
|
Bank Debt Tranche A |
|
|
|
|
|
|
Wcapital5 |
|
Other CL |
|
LTDebt2 |
|
Bank Debt Tranche B |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
>> End of Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|