Navigation
Case Builder Model
Global                                                                                                                                  
Field Name
Project Name Project_Name Financial Robot  
Model Revision Model_Date 14 Jan 14    
Model Name Model_Name Case Builder Model  
Period Start Date Date_BoP 01 Jan 14 01 Apr 14 01 Jul 14 01 Oct 14 01 Jan 15 01 Apr 15 01 Jul 15 01 Oct 15 01 Jan 16 01 Apr 16 01 Jul 16 01 Oct 16 01 Jan 17 01 Apr 17 01 Jul 17 01 Oct 17 01 Jan 18 01 Apr 18 01 Jul 18 01 Oct 18
Period End Date Date_EoP 31 Dec 13 31 Mar 14 30 Jun 14 30 Sep 14 31 Dec 14 31 Mar 15 30 Jun 15 30 Sep 15 31 Dec 15 31 Mar 16 30 Jun 16 30 Sep 16 31 Dec 16 31 Mar 17 30 Jun 17 30 Sep 17 31 Dec 17 31 Mar 18 30 Jun 18 30 Sep 18 31 Dec 18
Month Counter Month_Count 3.0  6.0  9.0  12.0  15.0  18.0  21.0  24.0  27.0  30.0  33.0  36.0  39.0  42.0  45.0  48.0  51.0  54.0  57.0  60.0 
Quarter Counter Quarter_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 
Year Counter Year_Count 1.0  1.0  1.0  1.0  2.0  2.0  2.0  2.0  3.0  3.0  3.0  3.0  4.0  4.0  4.0  4.0  5.0  5.0  5.0  5.0 
Number of Periods Flag Nperiod 4.0 
Time step duration, Days step_d 91.3 
Time step name step_name Quarters  
Income Tax CT 20.0%
Currency FX USD
Currency Unit X 000s
Input Labels for P&L and BS items =>>                                                                                                                                
COGS Items Central Costs & Overheads Operating Assumptions   Capex & Dep'n Schedule  
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 FAssets3 Equipment
COGS4 Leases CCosts4 Consulting
Working Capital Items Debt & Long Term Balance Sheet Items   Íàçâàíèÿ Ñöåíàðèåâ  
Name or Name Range Assign Value Name or Name Range Assign Value Name or Name Range Assign Value
Wcapital1 Debtors OtherLTA Other LT Assets CaseLabel_A Base
Wcapital2 Inventory OtherLTL Other LT Libilities CaseLabel_B Optimistic
Wcapital3 Creditors Revolver Short Term Revolver CaseLabel_C Banking
Wcapital4 Other CA LTDebt1 Bank Debt Tranche A CaseLabel_D Conservative
Wcapital5 Other CL LTDebt2 Bank Debt Tranche B CaseLabel_E Stress
LTDebt3 Bank Debt Tranche C
>> End of Sheet