Spreadsheet: richard_shapiro__32163__CE2 Pack Template 2506 (FINAL VERSION)
Sheet: CE2 PL Analysis

 | Q1 Actual |  |  |  |  |  |  |  |  |  |  | Q2 |  |  |  | YTD |  |  | Forecast July To Dec |  |  |  | Forecast Full Year |  |  |  |  |  |  |  |  |  |  |  |  | Forecast APRIL TO DEC.
 | Actual | Budget | [NAME] |  |  |  |  |  |  |  | Q2 | Q2 | [NAME] |  | YTD | YTD | YTD |  | FC | CE1 | [NAME] |  | FC | CE1 | [NAME] |  |  |  |  |  |  |  |  |  |  | FC | Budget | [NAME]
 | Q1 | Q1 | Q1 |  |  |  |  |  |  |  | Actuals (incl June CE1) | CE1 | Q2 |  | Actual | Budget | [NAME] |  |  | July - Dec | July - Dec |  |  | Full Year | Full Year |  |  |  |  |  |  |  |  |  |  | April - Dec. | April - Dec. | April - Dec.
 | 0 |  | 0 |  |  |  | Total Gross Margin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | Jul-Dec has been reduced inline with revised headcount of 25 (plan was 32) |  |  |  | Summary April /May costs
 |  | -1827353 |  |  |  |  | Salaries & Wages
 |  |  |  |  |  |  | - Nil Temps | $0k
 |  |  |  |  |  |  | - April included yearly Expat PAYE | $98k
 |  |  |  |  |  |  | - Rent | $29k
 |  |  |  |  |  |  | - General [NAME] and Wages | $467k
 |  |  |  |  |  |  | Total April & May Actuals | $594k
 |  | -136758 |  |  |  |  | Travel & Entertainment
 |  |  |  |  |  |  | - Travel & Lodgings | $62k
 |  |  |  |  |  |  | - Employee Meals & Ent | $4k
 |  |  |  |  |  |  | - Client Meals & Ent | $2k
 |  |  |  |  |  |  | - Other (Vehicle Fuel) | $2k
 |  |  |  |  |  |  | Total April & May Actuals | $70k |  | 70149
 |  | -100833 |  |  |  |  | Office Expenses
 |  |  |  |  |  |  | - Computer Maintenance/server/
 |  |  |  |  |  |  | - stationary * printing | $2k
 |  | -213227 |  |  |  |  | Consultancy
 |  |  |  |  |  |  | - Recruitment fees | $80k |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | - Translation | $3k
 |  |  |  |  |  |  | - IR Japan PR company
 |  |  |  |  |  |  | - Other Professional Services/Energy
 |  |  |  |  |  |  | - Office Insurance
 |  |  |  |  |  |  | - Other | $104k
 |  |  |  |  |  |  | Total April & May Actuals(see Expense analysis) | $187k
 |  | -222497 |  |  |  |  | Audit & Legal (tax, reg) | $12k
 |  | -526868 |  |  |  |  | Occupancy Costs(rent & utilities) | $35k
 |  | -46224 |  |  |  |  | General & Admin
 |  |  |  |  |  |  | -Employee Fees | $13k
 |  |  |  |  |  |  | -Subscriptions | $68k
 |  |  |  |  |  |  | -Other (incl insurance $8k) | $11k
 |  |  |  |  |  |  | Total April & May Actuals(see Expense analysis) | $92k
 |  | -215600 |  |  |  |  | Mobile Phones/Land Lines/Telerate | $5k
 |  | 0 |  |  |  |  | Taxes Other Than Income | $0k
 |  |  |  |  |  |  | TOTAL G&A | $996k
 |  | -200000 |  |  |  |  | Depreciation & Amortization | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 | 0 |  |  |  |  | Other Expenses | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | TOTAL DIRECT COST
 |  | -250000 |  |  |  |  | Direct Allocations | $418k
 | 0 |  |  |  |  |  | Residual Allocations | $578k |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
 |  | 0 |  |  |  |  | 3rd Party Interest Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 0 | 0 |  |  |  |  | Other Income/Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | INCOME BEFORE INTEREST & TAX | 0 |  |  | - | - | -
 |  | 45 |  |  |  |  | HEADCOUNT | 19 |  |  | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 | 57
 | Q1 Actual |  |  |  |  |  |  |  |  |  |  | Q2 |  |  |  | YTD |  |  | Forecast July To Dec |  |  |  | Forecast Full Year
 | Actual | Budget | [NAME] |  |  |  |  |  |  |  | Q2 | Q2 | [NAME] |  | YTD | YTD | YTD |  | FC | Budget | Varianc |  | FC | Budget | [NAME]
 | Q1 | Q1 | Q1 |  |  |  |  |  |  |  | Actuals | Budget | Q2 |  | Actual | Budget | [NAME] |  | July - Dec. | July - Dec. | July - Dec |  | Full Year | Full year | Full Year
 | 0 |  | 0 |  |  |  | Total Gross Margin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0