Tax Client Data Sheet

Document Sample
Tax Client Data Sheet Powered By Docstoc
					Financial Data Sheet

Client Instructions

   Additional clarification for each field is available by placing the mouse cursor
   over all cells with a red triangle located in the upper right corner
1 The Financial Data Sheet (FDS) is used by Enterprise Ireland to generate a standard financial model and
  to calculate standard financial ratios. It is also employed to compute an economic cost benefit ratio.
2 The spreadsheet is password protected - only yellow and blue cells can be modified.
3 Do not insert additional rows or columns nor delete existing ones. Doing so may distort the results of
  the financial model and financial ratios.
4 All monetary figures should be entered in thousands of Euro (€000's).
5 Clients fill in all applicable cells on Company Input Sheet 1 & 2, leaving non-relevant cells empty.
  Company Input Sheet 1 contains the P&L, Balance Sheet and Yearly cash flow
  Company Input Sheet 2 contains the monthly cash flow for the next 12 months - It is not necessary
  for a company to provide a monthly cashflow in this format - this is to assist a company that
  currently does not prepare a monthly cashflow
6 The Base year is normally selected as the latest accounting period which has elapsed, regardless of
  whether audited accounts are available. (New Start-Ups to use 'Base Year+1/ Current Year' for first year of trading).
  e.g. Companies completing FDS in 2011 with a December year-end should select 31/12/2010 as base year.
  However, if at least 10 months of management accounts are available and there is a reasonable expectation
  that the company will meet its end of year projections, the current financial year is the base year.
  e.g. Companies completing FDS in Dec. 2011 with a Dec. year-end should select 31/12/2011 as base year.
7 In the Balance Sheet, ensure that Net Assets in each year equal the total of the Financed By section,
  i.e. that the Balance Sheet balances.
8 The DA inputs the Package in the EI DA Input Sheet - the client does not update the package
9 Immediately prior to circulation to the relevant investment committee, the targets should be agreed and
  a review date set, the proposed review dates are 6 and 12 months AFTER EI money is invested ( for Grants 12 &
   24 months at after approval)
Colour Key

                 Yellow shading represents cells requiring input from the Company.
                 Orange shading represents automatically calculated formulae [password protected].
                 Blue shading represents cells requiring input from Enterprise Ireland staff.


  Last Update   13th May 2011.
Financial Data Sheet
Company Name                                                          Please populate this field
Please Specify

Months
Profit & Loss
                                                        Base Year-2      Base Year-1      Base Year    Current Year    Base Year+2    Base Year+3
Year End                                               DD/MM/YY        DD/MM/YY        DD/MM/YY       DD/MM/YY        DD/MM/YY       DD/MM/YY
Account Status                                            Audited         Audited      Management       Projected       Projected      Projected
                                                            €000's           €000's         €000's          €000's          €000's         €000's
Own Product / Service Produced in Ireland & Exported
Own Product / Service Produced Abroad & sold Abroad
Own Product / Service Produced & Sold in Ireland
Distribution Sales of Other Co's Product
Total Sales                                                      0                0              0               0               0              0
Direct Labour
Purchases
Other Cost of Goods Sold
Cost of Sales                                                    0                0              0               0               0              0
Gross Profit/(Loss)                                              0                0              0               0              0              0

Selling, General & Admin Expenses
Indirect Labour (excluding R&D Salaries)                         0                0              0               0               0              0
  R&D Salaries
  Other R&D expenditure
R&D Expenditure                                                  0                0              0               0               0              0
Other Operating Expenses/(Gains)                                                                                                                    Please provide a brief description of Other
Operating Expenditure                                            0                0              0               0              0              0

Operating Profit/(Loss) - EBITDA                                 0                0              0               0              0              0

Interest Payable
Interest / Dividends (Receivable)
Depreciation
Amortisation
Grant Amortisation (This application only)                                                                       0               0              0
Remitted Profits to Ireland From Foreign Subsidiary
Non-Operating Expenses/(Gains)                                                                                                                      Please provide a brief description of Other
Profit/(Loss) before Tax                                         0                0              0               0              0              0

Tax
Net Profit/(Loss)                                                0                0              0               0              0              0

Dividends
Profit Retained for the Year                                     0                0              0               0              0              0


Additional Information Required
Year End                                               DD/MM/YY DD/MM/YY               DD/MM/YY       DD/MM/YY        DD/MM/YY       DD/MM/YY
No. of Global Employees @ y/e                                                                                                                       Please populate these fields
No. of Irish Based Employees @ y/e                                                                                                                  Please populate these fields
No. of Global R&D Employees @y/e
No. of Irish Based R&D Employees @ y/e
Total Irish Labour Costs (€000's)                                                                                                                   Please populate these fields
Capitalised R&D (€000's)
VAT / PAYE / PRSI paid / (Received) in year
Bank Overdraft (Facility Limit for Projected Years)                                                                                                 Please populate these fields
Invoice discounting (Projected Year End Balance)                                                                                                    Please populate these fields
Site/Buildings Purchase
Site/Buildings Modifications
New Machinery / other Capex
Intangible asset (Excl Capitalised R&D)
Promoters' Equity Investment / (Divestment)
Other Equity Investment / (Divestment)
Dividends Paid to EI
Other Dividends Paid


Balance Sheet
Year End                                               DD/MM/YY DD/MM/YY               DD/MM/YY       DD/MM/YY        DD/MM/YY       DD/MM/YY
                                                            €000's           €000's         €000's          €000's          €000's         €000's
Fixed Assets
  Intangible                                                                                                     0               0              0
  Tangible Fixed Assets                                                                                          0               0              0
  Investments
Total Fixed Assets                                               0                0              0               0              0              0

Current Assets
  Inventory
  Trade Debtors
  Bank/Cash                                                                                                      0               0              0
  Connected Parties / Inter Company Loans
  Prepayments / Other Debtors                                                                                                                       Please provide a brief description of Other
Total Current Assets                                             0                0              0               0              0              0

Current Liabilities
  Bank Overdraft (Facility Limit in Projected Years)                                                             0               0              0
  Invoice discounting (YE Balance)                                                                               0               0              0
  Short Term loans / Leasing (<1 year)
  Trade Creditors
  Accruals / Other Creditors                                                                                                                        Please provide a brief description of Other
Total Current Liabilities                                        0                0              0               0              0              0

Net Current Assets                                               0                0              0               0              0              0

Liabilities > 1 Year
 Long Term Loans
 Leases
 Connected Parties / Inter Company Loans
 Directors / Shareholders Loans
 EI Grant Liability (This application only)                                                                      0               0              0
 Other Long Term Liabilities                                                                                                                        Please provide a brief description of Other



                                                                                                                                           62ac1109-48dc-4aec-8a7c-5b3c064f080f.xls
Total Liabilities > 1 Year                                            0             0                 0               0               0            0

Net Assets                                                            0             0                 0               0               0            0

Financed by
 Preference Shares
 EI Equity Assistance (This application only)                                                                          0               0            0
 Ordinary Shares & Share Premium                                                                                       0               0            0
 Provisions/Grants/Other Reserves                                                                                                                       Please provide a brief description of Other
 Retained Earnings                                                                  0                 0               0               0            0
Shareholders Funds                                                    0             0                 0               0               0            0

Projected Cash Funding Table
Year End                                                   DD/MM/YY DD/MM/YY             DD/MM/YY          DD/MM/YY        DD/MM/YY        DD/MM/YY
                                                                  €000's        €000's            €000's          €000's          €000's       €000's


Cash Flow Statement For the year ended
Profit Retained for the Year                                                                                           0               0            0

Add back; Depreciation / Amortisation                                                                                  0               0            0

Working Capital (Increase)/Decrease
Stocks                                                                                                                0               0            0
Trade Debtors                                                                                                         0               0            0
Prepayments / Other Debtors                                                                                           0               0            0
Trade Creditors                                                                                                       0               0            0
Accruals / Other Creditors                                                                                            0               0            0
Total                                                                                                                 0               0            0

Operating Cash Inflow / (Outflow)                                                                                     0               0            0

Capital Expenditure                                                                                                    0               0            0

Funding Inc/ (Dec)
OverDraft & Invoice Discounting Facility                                                                              0               0            0
Short Term loans / Leasing (<1 year)                                                                                  0               0            0
Long Term Bank Loans/Leasing                                                                                          0               0            0
Convertible/Other Loans                                                                                               0               0            0
Connected Parties / Inter Company Loans                                                                               0               0            0
Directors Loans                                                                                                       0               0            0
EI Equity                                                                                                             0               0            0
EI Grant                                                                                                              0               0            0
Other Equity                                                                                                          0               0            0
Other Reserves                                                                                                        0               0            0
Total                                                                                                                 0               0            0

Non Operating Cash Inflow / (outflow)                                                                                 0               0            0

Net Movement in Cash                                                                                                  0               0            0

Opening Cash Balance - includes Facilities                                                                            0               0            0
Closing Cash (Incl Facilities i.e. available cash)                                                                    0               0            0

Overdraft Facility                                                                                                    0               0            0
Invoice Discounting Balance                                                                                           0               0            0
Net Closing Cash (Excl Short Term Facilities)                         0             0                 0               0               0            0



For Applications receiving >€250k EI support
For Equity investments, upon completion of the EI investment, the following should be agreed with the client and incorporated into the checklist
for validation:
o Key financial & non financial targets at 6 and 12 months post investment
o Review meeting dates that should be no later than 2 months after the target date

For Grant investments, at the time of approval, the following should be agreed with the client:
o Key financial & non financial targets at 12 and 24 months post investment
o Review meeting dates that should be no later than 2 months after the target date
Please capture the Financial Key Performance Indicators below & select the relevant review period


Post Investment Review Targets

Review Period                                                                                              Please Select   Please Select
Target Date                                                                                                 DD/MM/YY        DD/MM/YY
Sales (€000's)
Exports (€000's)
Gross Profit
Gross Margin                                                                                                        n/a             n/a
Opex
EBITDA
EBITDA %                                                                                                            n/a             n/a
Total Debt
Shareholders Funds (€000's)
Closing Cash\ Available Cash
Closing Cash excl ST facilities




                                                                                                                                               62ac1109-48dc-4aec-8a7c-5b3c064f080f.xls
Summary Monthly Cashflow Statement for the NEXT 12 MONTHS

Month End                              MM/YY       MM/YY       MM/YY       MM/YY       MM/YY       MM/YY       MM/YY       MM/YY       MM/YY       MM/YY       MM/YY       MM/YY       Total
                                         €000's      €000's      €000's      €000's      €000's      €000's      €000's      €000's      €000's      €000's      €000's      €000's            €000's
Operating Cash Inflow
Sales receipts - Non Invoice
Discounting Supported                                                                                                                                                                              0
Sales Receipts - Invoice discounting                                                                                                                                                               0
Other Revenue - specify                                                                                                                                                                            0
Other Revenue - specify                                                                                                                                                                            0
Non - Operating Cash Inflow
Loan 1                                                                                                                                                                                             0
Loan 2                                                                                                                                                                                             0
Non EI Equity/Grants
Promoters' Equity Investment                                                                                                                                                                       0
Other Equity Investment                                                                                                                                                                            0
EI Monies (This investment)                                                                                                                                                                        0
Total Cash Receipts                            0           0           0           0           0           0           0           0           0           0           0           0               0
Operating Cash Payments
 Payments to Creditors/Suppliers                                                                                                                                                                   0
 Wages/Salaries                                                                                                                                                                                    0
 Other Cash Operating Expenses                                                                                                                                                                     0
Other Expense 1 - Specify                                                                                                                                                                          0
Other Expense 2 - Specify                                                                                                                                                                          0
Capital Investment                                                                                                                                                                                 0
Dividends
 Dividends Paid to EI                                                                                                                                                                              0
 Other Dividends Paid                                                                                                                                                                              0
Operating Cash Payments
Loan Repayment 1                                                                                                                                                                                   0
Loan Repayment 2                                                                                                                                                                                   0
  Directors Loans/ Related Parties
Payments                                                                                                                                                                                           0
Equity/Grants
 EI Share/Grant Redemptions                                                                                                                                                                        0
 Other Share Redemptions                                                                                                                                                                           0
Total Cash Payments                            0           0           0           0           0           0           0           0           0           0           0           0               0
Total Cash Inflow/(Outflow)                    0           0           0           0           0           0           0           0           0           0           0           0               0
Net Opening Cash (Excl Short
Term Facilities)                               0           0           0           0           0           0           0           0           0           0           0           0               0
Net Closing Cash (Excl Short
Term Facilities)                               0           0           0           0           0           0           0           0           0           0           0           0               0
OverDraft Facility
Inv Disc (Proj Month End Bal)                  0           0           0           0           0           0           0           0           0           0           0           0
Available headroom                             0           0           0           0           0           0           0           0           0           0           0           0
Financial Data Sheet
Company Name

Company Information

Region                                   Please Select
Type of Company                          Please Select
Ownership/Strategic Control              Please Select

Employment Numbers

                                            Base Year-2          Base Year-1             Base Year         Base Year+1     Base Year+2    Base Year+3
Year End                                  DD/MM/YY             DD/MM/YY              DD/MM/YY           DD/MM/YY          DD/MM/YY       DD/MM/YY
Enter Base Irish Employment Level                                                           0

EI Funding
[EI Development Adviser to categorise expected grant & equity package if applicable]
                                            Base Year-2          Base Year-1             Base Year         Base Year+1     Base Year+2    Base Year+3
Year End                                  DD/MM/YY             DD/MM/YY              DD/MM/YY           DD/MM/YY          DD/MM/YY       DD/MM/YY
                                                   €000's                  €000's             €000's             €000's        €000's          €000's
EI Capital Grants                              -                       -                  -
EI Employment Grants                           -                       -                  -
EI HRD/Mgt Development Grants                  -                       -                  -
EI R&D Grants                                  -                       -                  -
EI Marketing & Strategy Grants                 -                       -                  -
Total Grants per Company Input                                                                                       0              0              0



EI Ordinary Shares                             -                       -                  -
EI HPSU CCRPs                                  -                       -                  -
EI Preference Shares                           -                       -                  -
Total EI Equity per Company Input                                                                                    0              0              0



Cost Benefit Ratio
[If you need assistance with this ratio, please contact Commercial Evaluation]
EI Cost Benefit Ratio                                Please enter Company Information above in order to calculate
                                                     the Cost Benefit Ratio.



Drivers of Cost Benefit Ratio
                                                   €000's
Increase   in   Sales                                    0
Increase   in   Exports                                  0
Increase   in   Irish Payroll                            0
Increase   in   Post Tax Profits                         0

Value for Money measures (For i-HPSU it may be necessary to input & calculate these manually below)
                                                   €000's
Total Equity Support (past 7 Years)                 -
Total Grant Support (past 7 Years)                  -

                                            Impacts
                                                                                                Increase
EI Targets*                             Base Year             Year 3                  (€'000)                %
Sales (€000’s)                                            0                    0                  0
Exports (€000’s)                                          0                    0                  0
Employees (Irish Based)                                   0                    0                  0
Productivity**                                          n/a                  n/a

                                      Value for Money Measures
Ratio of                                Benefit to            Cost per new             Cost per           Cost per
Increased                               Cost Ratio            job(this              sustained job      sustained job
Export Sales                                                  application)            (Base Yr)         (Base Yr+3)
To EI Support                                                      €'000                €'000              €'000
Profit & Loss: Company Name                                                         FDS Template as at               13th May 2011.
                                                        Base Year-2   Base Year-1       Base Year   Current Year       Base Year+2    Base Year+3
Year End                                               DD/MM/YY DD/MM/YY DD/MM/YY DD/MM/YY DD/MM/YY DD/MM/YY
Account Status                                             Audited       Audited      Management         Projected       Projected      Projected
                                                            €000's        €000's          €000's           €000's          €000's         €000's
Own Product / Service Produced in Ireland & Exported             0             0               0                0               0              0
Own Product / Service Produced Abroad & sold Abroad              0             0               0                0               0              0
Own Product / Service Produced & Sold in Ireland                 0             0               0                0               0              0
Distribution Sales of Other Co's Product                         0             0               0                0               0              0
Total Sales                                                      0             0               0                0               0              0

Direct Labour                                                    0             0               0                0               0              0
Purchases                                                        0             0               0                0               0              0
Other Cost of Goods Sold                                         0             0               0                0               0              0
Cost of Sales                                                    0             0               0                0               0              0

Gross Profit/(Loss)                                              0             0               0                0               0              0

Selling, General & Admin Expenses                                0             0               0                0               0              0
Indirect Labour (excluding R&D Salaries)                         0             0               0                0               0              0
R&D Expenditure                                                  0             0               0                0               0              0
Other Operating Expenses/(Gains)                                 0             0               0                0               0              0
Operating Expenditure                                            0             0               0                0               0              0

Operating Profit/(Loss) - EBITDA                                 0             0               0                0               0              0

Interest Payable                                                 0             0               0                0               0              0
Interest / Dividends (Receivable)                                0             0               0                0               0              0
Depreciation                                                     0             0               0                0               0              0
Amortisation                                                     0             0               0                0               0              0
Grant Amortisation (This application only)                                                                      0               0              0
Remitted Profits to Ireland From Foreign Subsidiary              0             0               0                0               0              0
Non-Operating Expenses/(Gains)                                   0             0               0                0               0              0
Profit/(Loss) before Tax                                         0             0               0                0               0              0

Tax                                                              0             0               0                0               0              0
Net Profit/(Loss)                                                0             0               0                0               0              0

Dividends                                                        0             0               0                0               0              0
Profit Retained for the Year                                     0             0               0                0               0              0



Balance Sheet: Company Name                                              FDS Template as at 13th May 2011.
Year End                                               DD/MM/YY DD/MM/YY DD/MM/YY DD/MM/YY DD/MM/YY DD/MM/YY
                                                            €000's        €000's          €000's           €000's          €000's         €000's
Fixed Assets
  Intangible                                                     0             0               0                0               0              0
  Tangible Fixed Assets                                          0             0               0                0               0              0
  Investments                                                    0             0               0                0               0              0
Total Fixed Assets                                               0             0               0                0               0              0

Current Assets
  Inventory                                                      0             0               0                0               0              0
  Trade Debtors                                                  0             0               0                0               0              0
  Bank/Cash                                                      0             0               0                0               0              0
  Connected Parties / Inter Company Loans                        0             0               0                0               0              0
  Prepayments / Other Debtors                                    0             0               0                0               0              0
Total Current Assets                                             0             0               0                0               0              0

Current Liabilities
  Bank Overdraft (Facility Limit in Projected Years)             0             0               0                0               0              0
  Invoice discounting (YE Balance)                               0             0               0                0               0              0
  Short Term loans / Leasing (<1 year)                           0             0               0                0               0              0
  Trade Creditors                                                0             0               0                0               0              0
  Accruals / Other Creditors                                     0             0               0                0               0              0
Total Current Liabilities                                        0             0               0                0               0              0

Net Current Assets                                               0             0               0                0               0              0

Liabilities > 1 Year
 Long Term Loans                                                 0             0               0                0               0              0
 Leases                                                          0             0               0                0               0              0
 Connected Parties / Inter Company Loans                         0             0               0                0               0              0
 Directors / Shareholders Loans                                  0             0               0                0               0              0

                                                                                62ac1109-48dc-4aec-8a7c-5b3c064f080f.xls
 EI Grant Liability (This application only)                                        0         0            0
 Other Long Term Liabilities                               0   0        0          0         0            0
Total Liabilities > 1 Year                                 0   0        0          0         0            0

Net Assets                                                 0   0        0          0         0            0

Financed by
 Preference Shares                                         0   0        0          0         0            0
 EI Equity Assistance (This application only)                                      0         0            0
 Ordinary Shares & Share Premium                           0   0        0          0         0            0
 Provisions/Grants/Other Reserves                          0   0        0          0         0            0
 Retained Earnings                                         0   0        0          0         0            0
Shareholders Funds                                         0   0        0          0         0            0




BES Redemption amount                                      0
BES Redemption date                             DD/MM/YY




                                                               62ac1109-48dc-4aec-8a7c-5b3c064f080f.xls
Financial Analysis: Company Name

                                                  Base Year-2    Base Year-1      Base Year    Base Year+1    Base Year+2    Base Year+3
Year End                                         DD/MM/YY       DD/MM/YY       DD/MM/YY       DD/MM/YY       DD/MM/YY       DD/MM/YY
Account Status                                      Audited        Audited     Management       Projected      Projected      Projected

Sales, Exports & Profitability
Sales                                                      0              0              0              0              0              0
Exports                                                    0              0              0              0              0              0
Exports as % of Sales                                    n/a            n/a            n/a            n/a            n/a            n/a
International Sales (€000's)                               0              0              0              0              0              0
International Sales as % of Sales                        n/a            n/a            n/a            n/a            n/a            n/a
% Own Manufactured Sales                                 n/a            n/a            n/a            n/a            n/a            n/a
Gross Profit                                               0              0              0              0              0              0
Gross Margin                                             n/a            n/a            n/a            n/a            n/a            n/a
EBITDA                                                     0              0              0              0              0              0
EBITDA %                                                 n/a            n/a            n/a            n/a            n/a            n/a
Net Profit/(Loss) (€000's)                                 0              0              0              0              0              0
Net Margin (post-tax)                                    n/a            n/a            n/a            n/a            n/a            n/a
Return on Capital Employed (ROCE)                        n/a            n/a            n/a            n/a            n/a            n/a
Return on Equity (ROE) [post-tax]                        n/a            n/a            n/a            n/a            n/a            n/a
Value Add                                                  0              0              0              0              0              0

Momentum
Sales Growth %                                           n/a            n/a            n/a            n/a            n/a            n/a
Export Growth %                                          n/a            n/a            n/a            n/a            n/a            n/a

Productivity
Sales per Employee (€000's)                              n/a            n/a            n/a            n/a            n/a            n/a
Value Add To Ireland per Irish employee                  n/a            n/a            n/a            n/a            n/a            n/a
Net Profit per Employee (€000's)                         n/a            n/a            n/a            n/a            n/a            n/a

Research & Development
Total R&D Spend (€000's)                                   0              0              0              0              0              0
R&D as % of Sales                                        n/a            n/a            n/a            n/a            n/a            n/a
R&D Growth %                                             n/a            n/a            n/a            n/a            n/a            n/a

Liquidity/Gearing
Increase in Working Capital (€000's)                     n/a            n/a            n/a            n/a            n/a            n/a
Current Ratio                                            n/a            n/a            n/a            n/a            n/a            n/a
Quick Ratio                                              n/a            n/a            n/a            n/a            n/a            n/a
Shareholders Funds (€000's)                                0              0              0              0              0              0
Total Debt                                                 0              0              0              0              0              0
Net Debt/Equity                                          n/a            n/a            n/a            n/a            n/a            n/a
Net Debt/Equity (ex directors loans)                     n/a            n/a            n/a            n/a            n/a            n/a
Working Capital per €1 Sales                             n/a            n/a            n/a            n/a            n/a            n/a
Debtors Days                                             n/a            n/a            n/a            n/a            n/a            n/a
Creditors Days                                           n/a            n/a            n/a            n/a            n/a            n/a
Stock Days                                               n/a            n/a            n/a            n/a            n/a            n/a
Interest Cover                                           n/a            n/a            n/a            n/a            n/a            n/a
Invoice Discounting as a % of Tr Debtors               0.0%           0.0%           0.0%           0.0%           0.0%           0.0%

Employment
No. of Total Employees at year-end                         0              0              0              0              0              0
No. of Irish Employees at year-end                         0              0              0              0              0              0
Labour Costs per Employee (€000's)                       n/a            n/a            n/a            n/a            n/a            n/a
No. of R&D Employees @y/e                                  0              0              0              0              0              0
No. of Irish R&D Employees @ y/e                           0              0              0              0              0              0

Depreciation \ Amortisation (€000's)
Depreciation Amortisation Expense                          0              0              0              0              0              0

Operating Cashflow (€000's)
Operating Cash Inflow/(Outflow)                                                                         0              0              0

Additional Ratios

Purchases as a % of Sales                                n/a            n/a            n/a            n/a            n/a            n/a
Purchases as a % of COS                                  n/a            n/a            n/a            n/a            n/a            n/a
Purchases as a % of Total Expenditure                    n/a            n/a            n/a            n/a            n/a            n/a
SGA as a % of Sales                                      n/a            n/a            n/a            n/a            n/a            n/a
SGA as a % of OPEX                                       n/a            n/a            n/a            n/a            n/a            n/a
SGA as a % of Total Expenditure                          n/a            n/a            n/a            n/a            n/a            n/a
Other Opex as a % of Sales                               n/a            n/a            n/a            n/a            n/a            n/a
Other Opex as a % of Total Opex                          n/a            n/a            n/a            n/a            n/a            n/a
Other Opex as a % of Total Expenditure                   n/a            n/a            n/a            n/a            n/a            n/a
Operating Expenditure as a % of Sales                    n/a            n/a            n/a            n/a            n/a            n/a
Direct labour as a % of Sales                            n/a            n/a            n/a            n/a            n/a            n/a
Indirect Labour as a % of Sales                          n/a            n/a            n/a            n/a            n/a            n/a
Indirect Labour as a % of Total Opex                     n/a            n/a            n/a            n/a            n/a            n/a
R&D as a % of Sales                                      n/a            n/a            n/a            n/a            n/a            n/a
R&D as a % of Total Opex                                 n/a            n/a            n/a            n/a            n/a            n/a
R&D as a % of Total Expenditure                          n/a            n/a            n/a            n/a            n/a            n/a
Total Irish Labour costs as a % of Sales                 n/a            n/a            n/a            n/a            n/a            n/a
Total Labour costs as a % of Total Expenditure           n/a            n/a            n/a            n/a            n/a            n/a
Total Labour costs as a % of Total Sales                 n/a            n/a            n/a            n/a            n/a            n/a
Average Irish salaries                                   n/a            n/a            n/a            n/a            n/a            n/a
Average Total salaries                                   n/a            n/a            n/a            n/a            n/a            n/a
Depreciation as a % of Tangible Fixed Assets             n/a            n/a            n/a            n/a            n/a            n/a
Stock as a % of Purchases                                n/a            n/a            n/a            n/a            n/a            n/a
Stock Turnover Days                                      n/a            n/a            n/a            n/a            n/a            n/a
Trade Debtors as a % of Sales                            n/a            n/a            n/a            n/a            n/a            n/a
Total Debtors as a % of Sales                            n/a            n/a            n/a            n/a            n/a            n/a
Trade Creditors as a % of Opex + COS                     n/a            n/a            n/a            n/a            n/a            n/a
Creditors as a % of Opex+COS                             n/a            n/a            n/a            n/a            n/a            n/a
Please select from the drop down boxes below to perform a simple scenario analysis, that will
enable the user to understand the impact of variances in sales & costs forecasts.
Please note the following assumptions
1.   Debtors will be directly impacted as a result of a movement in sales
2.   Creditors will be directly impacted as a result of a movement in Purchases
3.   Stock will be directly impacted as a result of a movement in Purchases
4.   Purchases is the only element of Cost of Goods sold which is variable

Scenario Testing                                     DD/MM/YY         DD/MM/YY         DD/MM/YY
Sales                                                    100%             100%             100%
Cost of Sales - Purchases only                           100%             100%             100%
Operating Expenditure                                    100%             100%             100%

Profit & Loss - Scenario Test
                                                       Current Year    Base Year+2      Base Year+3
Year End                                             DD/MM/YY         DD/MM/YY         DD/MM/YY
Account Status                                         Projected        Projected        Projected
                                                            €000's         €000's           €000's
                                                                 0                0              0
Total Sales                                                      0                0              0


Purchases                                                        0                0              0
Other Cost of Sales                                              0                0              0
Gross Profit/(Loss)                                              0                0              0

                                                                 0                0              0
Operating Expenditure                                            0                0              0

Operating Profit/(Loss) - EBITDA                                 0                0              0

Profit/(Loss) before Tax                                         0                0              0

Net Profit/(Loss)                                                0                0              0

Profit Retained for the Year                                     0                0              0


Balance Sheet - Scenario Test
Year End                                            DD/MM/YY          DD/MM/YY        DD/MM/YY
                                                            €000's         €000's           €000's
Total Fixed Assets                                               0                0              0

  Stock                                                          0                0              0
 Debtors                                                         0                0              0
  Bank/Cash                                                      0                0              0
Total Current Assets                                             0                0              0

  Trade Creditors                                                0                0              0
Total Current Liabilities                                        0                0              0

Net Current Assets                                               0                0              0

Total Liabilities > 1 Year                                       0                0              0

Net Assets                                                       0                0              0

Financed by
Retained Earnings                                                0                0              0
Shareholders Funds                                               0                0              0


Projected Cash Funding Table - Scenario Test

Cash Flow Statement For the year ended
Profit Retained for the Year                                     0                0              0

Add back; Depreciation / Amortisation                            0                0              0

Working Capital (inc)/dec
Stocks                                                           0                0              0
Debtors                                                          0                0              0
Prepayments / Other Debtors                                      0                0              0
Creditors                                                        0                0              0
Accruals / Other Creditors                                       0                0              0
Total                                                            0                0              0

Capital Expenditure                                              0                0              0

Funding (inc)/dec
Net Movement in Cash                                             0                0              0



Opening Cash Balance                                             0                0              0
Closing Cash Balance - Available Funds                           0                0              0

Overdraft Facility                                               0                0              0
Invoice Discounting Balance                                      0                0              0
Closing Cash (Excl Facilities i.e. net cash)                     0                0              0
Post Investment Review
The below table should be inserted into the Post Investment Review template

Please note Any deviation from the Key performance indicators should be commented
on



Financial Key Performance Indicators                                  Target Date    DD/MM/YY
                                             Projected       Actual         Actual
Period                                 Please Select Please Select      Variance     Explanation


Sales (€000's)                                      0            0              0
Exports (€000's)                                    0            0              0
Gross Profit                                        0            0              0
Gross Margin                           n/a                    n/a
Opex                                                0            0              0
EBITDA                                              0            0              0
EBITDA %                               n/a                    n/a
Total Debt                                          0            0              0
Shareholders Funds (€000's)                         0            0              0
Closing Cash\ Available Cash                        0            0              0
Closing Cash excl ST facilities                     0            0              0




Financial Key Performance Indicators                                  Target Date    DD/MM/YY
                                             Projected       Actual         Actual
Period                                 Please Select Please Select      Variance     Explanation


Sales (€000's)                                      0            0              0
Exports (€000's)                                    0            0              0
Gross Profit                                        0            0              0
Gross Margin                           n/a                    n/a
Opex                                                0            0              0
EBITDA                                              0            0              0
EBITDA %                               n/a                    n/a
Total Debt                                          0            0              0
Shareholders Funds (€000's)                         0            0              0
Closing Cash\ Available Cash                        0            0              0
Closing Cash excl ST facilities                     0            0              0




Financial Key Performance Indicators                                                 Review Date
                                             Projected       Actual         Actual
Period                                 DD/MM/YY          DD/MM/YY       Variance     Explanation


Sales (€000's)                                      0            0              0
Exports (€000's)                                    0            0              0
Gross Profit                                        0            0              0
Gross Margin                                     n/a          n/a
Opex                                0     0   0
EBITDA                              0     0   0
EBITDA %                          n/a   n/a
Total Debt                          0     0   0
Shareholders Funds (€000's)         0     0   0
Closing Cash\ Available Cash        0     0   0
Closing Cash excl ST facilities     0     0   0
              Review Date   DD/MM/YY




              Review Date   DD/MM/YY




Review Date   DD/MM/YY
Economic Model: Company Name
[EI Internal Use only]

Project Characteristics                                                                                                                                                            Incremental Expenditure
Region [Greater Dublin=1, Rest of State=2, BMW=3]                              0
Startup or Existing [HPSU=1, Other Startup=2, Existing Co=3]                   0
Ownership [Irish=1, Foreign=0]                                                 0
Productivity Fund [No=0, Yes=1]                                                0
                                                     DD/MM/YY           DD/MM/YY DD/MM/YY DD/MM/YY       #VALUE!        #VALUE!    #VALUE!        #VALUE!                          Year 1       Year 2        Year 3       Year 4       Year 5       Year 6       Year 7

Site                                          K                                                                                                                                             0            0             0            0            0            0            0
Site grant                                    %                                                                                                                                             0            0             0            0            0            0            0
Buildings                                     K                                0              0    0                                                                                        0            0             0            0            0            0            0
Building grant                                %                                                                                                                                             0            0             0            0            0            0            0
                                              U
New/existing building(type 1 for new,0 for old)                                                                                                                                             0            0             0            0            0            0            0
Building modifications                        K                                0              0    0                                                                                        0            0             0            0            0            0            0
Building mods. grant                          %                                                                                                                                             0            0             0            0            0            0            0
IDA expend. - building construction           K                                                                                                                                             0            0             0            0            0            0            0
IDA expend. - building modifications          K                                                                                                                                             0            0             0            0            0            0            0
IDA receipts - building construction          K                                                                                                                                             0            0             0            0            0            0            0
IDA receipts - building modifications         K                                                                                                                                             0            0             0            0            0            0            0
Total machinery                               K                                0              0    0                                                                                        0            0             0            0            0            0            0
Irish machinery                               K                                0              0    0                                                                                        0            0             0            0            0            0            0
Machinery grant %                             %                                0              0    0                                                                                        0            0             0            0            0            0            0
Leasing                                       %                                                                                                                                             0            0             0            0            0            0            0
Area rented                                   K                                                                                                                                             0            0             0            0            0            0            0
Rent charged                                  U                                                                                                                                             0            0             0            0            0            0            0
Rent subsidy                                  %                                                                                                                                             0            0             0            0            0            0            0
Training grants                               K                                0              0    0                                                                                        0            0             0            0            0            0            0
Employment grants                             K                                0              0    0                                                                                        0            0             0            0            0            0            0
Mgt. Development grants (please type in )     K                                                                                                                                             0            0             0            0            0            0            0
R & D grants                                  K                                0              0    0                                                                                        0            0             0            0            0            0            0
Interest subsidy                              K                                                                                                                                             0            0             0            0            0            0            0
Loan guarantee                                K                                                                                                                                             0            0             0            0            0            0            0
EI Equity injection - ordinary shares         K                                0              0    0                                                                                        0            0             0            0            0            0            0
EI Equity injection - preference shares       K                                0              0    0                                                                                        0            0             0            0            0            0            0
FEOGA fallback rate                           %                                                                                                                                             0            0             0            0            0            0            0
                                                                                                                                                                                            0            0             0            0            0            0            0
Sales                                       K                       0          0              0    0               0          0              0          0                                   0            0             0            0            0            0            0
Jobs (cumulative)                           U                       0          0              0    0               0          0              0          0                                   0            0             0            0            0            0            0
Payroll                                     K                       0          0              0    0               0          0              0          0                                   0            0             0            0            0            0            0
Post-tax profit                             K                       0          0              0    0               0          0              0          0                                   0            0             0            0            0            0            0
Equity sale - ordinary shares               K                                                                                                                                               0            0             0            0            0            0            0
Dividends from ordinary shares              K                                                                                                                                               0            0             0            0            0            0            0
Dividends and Redemption of Pref Shares     K                                 0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Repaid grants                               K                                                                                                                                               0            0             0            0            0            0            0

IRISH RAW MATERIALS INPUTS                                                                                                                                                                  0            0             0            0            0            0            0
                                                                                                                                                                                            0            0             0            0            0            0            0
Irish   Raw   Materials   1                                     0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Irish   Raw   Materials   2                                     0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Irish   Raw   Materials   3                 K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Irish   Raw   Materials   4                 K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Irish   Raw   Materials   5                 K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
                                                                                                                                                                                            0            0             0            0            0            0            0
IRISH SERVICES INPUTS                                           0             0              0      0             0           0              0          0                                   0            0             0            0            0            0            0
Electricity                                 K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
                                                                                                                                                                                            0            0             0            0            0            0            0
Telecom                                     K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Postage                                     K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Rent                                        K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Rates                                       K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Medical                                     K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Canteen                                     K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Legal                                       K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Audit                                       K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Insurance                                   K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Computer services                           K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Staff education                             K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Contract research                           K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Employee welfare                            K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Water                                       K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Cleaning                                    K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Other 1                                     K                   0             0              0      0             0           0              0          0                                   0            0             0            0            0            0            0
Other 2                                     K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
                                                                                                                                                                                            0            0             0            0            0            0            0
Auto expenses                               K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Travel                                      K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Fuels                                       K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Waste disposal                              K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Freight out                                 K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Plant hire                                  K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Industrial gases                            K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
Office supply                               K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
    Other 3                                 K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
    Other 4                                 K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0
                                                                                                                                                                                            0            0             0            0            0            0            0
Repair/Maintenance                          K                   0             0              0     0              0           0              0          0                                   0            0             0            0            0            0            0




Account Status                                      Region                         Type                 Owner                     Question                  Account Info                        Percentages
None                                                Please Select                  Please Select        Please Select             Please Select             Please Specify                      Please Select
Audited                                             Dublin                         HPSU                 Irish                     No                        Group Consolidated Accounts              125%
Draft Audit                                         Mid East                       Established          Foreign                   Yes                       Group Subsidiary                         110%
Management                                          BMW                                                                                                     Single Entity                            105%
Projected                                           SE/SW/MidW                                                                                                                                       100%
                                                                                                                                                                                                      95%
                                                                                                                                                                                                      90%
                                                                                                                                                                                                      85%
                                                                                                                                                                                                      80%
                                                                                                                                                                                                      75%
                                                                                                                                                                                                      70%
                                                                                                                                                                                                      65%
                                                                                                                                                                                                      60%
                                                                                                                                                                                                      55%
                                                                                                                                                                                                      50%
                                                                                                                                                                                                      45%
                                                                                                                                                                                                      40%

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:77
posted:8/15/2011
language:English
pages:16
Description: Tax Client Data Sheet document sample