Financial Data Sheet V.2

Document Sample
Financial Data Sheet V.2 Powered By Docstoc
					Financial Data Sheet

Client Instructions

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' for first year of trading).
  e.g. Companies completing FDS in 2008 with a December year-end should select 31/12/2007 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. 2008 with a Dec. year-end should select 31/12/2008 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

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   2nd July 2009
Financial Data Sheet
[Insert Company Name]
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)
  R&D Salaries
  Other R&D expenditure
R&D Expenditure                                                  0              0              0               0              0              0
Other Operating Expenses/(Gains)
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 Subsidary
Non-Operating Expenses/(Gains)
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 - Employment & Capitalised R&D
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
No. of Irish Based Employees @ y/e
No. of R&D Employees @y/e
No. of Irish R&D Employees @ y/e
Total Irish Labour Costs (€000's)
Capitalised R&D (€000's)


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                                                                                                     0              0              0
  Investments
Total Fixed Assets                                               0              0              0               0              0              0

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

Current Liabilities
  Bank Overdraft
  Invoice discounting
  Short Term loans / Leasing (<1 year)
  Trade Creditors
  Accruals / Other Creditors
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 Loans
EI Grant Liability (This application only)                                                                       0               0               0
Other Long Term Liabilities
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
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 Receipts                                           -            -            -
Revenues                                                                                                         0               0               0
Sales receipts                                          -            -                   -
Interest/Dividends Received                                                                                      0               0               0
Other Revenues/Other Grants

Loans Facilities Total                                                                                           0               0               0
Bank Overdraft                                                                                                   0               0               0
Invoice disc / Leasing                                                                                           0               0               0
Short Term loans (<1 year)                                                                                       0               0               0
Long Term Bank Loans/Leasing                                                                                     0               0               0
Directors Loans                                                                                                  0               0               0
Related Parties                                                                                                  0               0               0
Convertible/Other Loans                                                                                          0               0               0

Equity/Grants
Promoters' Equity Investment
Other Equity Investment                                 -            -                   -
EI Equity Investment                                    -            -                   -                       0               0               0
EI Grants (this proposal only)                                                                                   0               0               0

Total Cash Receipts                                     -            -                   -                       0               0               0

Cash Payments
Operating Expenses                                                                                       0               0               0
 Payments to Creditors/Suppliers                        -            -                   -
 Wages/Salaries                                         -            -                   -                       0               0               0
 Other Cash Operating Expenses                          -            -                   -

Interest Paid                                           -            -                   -                       0               0               0
Taxation Paid (Do not include VAT)                      -            -                   -

Capital Investment
 Site/Buildings Purchase                                -            -                   -
 Site/Buildings Modifications                           -            -                   -
 New Machinery / other Capex                            -            -                   -
 Intangible asset (Incl Capitalised R&D)                -            -                   -

Dividends
 Dividends Paid to EI                                   -            -                   -
 Other Dividends Paid                                   -            -                   -

Loans Repayment Total                                   -            -                   -                       0               0               0
 Bank Overdraft Payments                                                                                         0               0               0
 Invoice Discounting/Leasing Payments                                                                            0               0               0
 Short term Loan Payments                                                                                        0               0               0
 Long Term Bank Loans/Leasing Payments                  -            -                   -                       0               0               0
 Other Long Term Liabilities Redeemed                                                                            0               0               0
 Related Parties Payments                                                                                        0               0               0
 Directors Loans Redeemed                               -            -                   -                       0               0               0

Equity/Grants
 EI Share/Grant Redemptions                             -            -                   -
 Other Share Redemptions                                -            -                   -

Total Cash Payments                                                                                              0               0               0

Total Cash Inflow/(Outflow)                             -            -                   -                       0               0               0

Opening Cash Balance                                    -            -                   -                       0               0               0
Closing Cash (incl Facilities i.e. available cash)      -            -                   -                       0               0               0
Net Cash Position - excludes Facilities                      0               0                   0               0               0               0
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
Cash Receipts
Revenues
Sales receipts                                                                                                                                                                                         0
Interest/Dividends Received                                                                                                                                                                            0
Other Revenues/Other Grants                                                                                                                                                                            0


Loans Facilities Total
Bank Overdraft                                                                                                                                                                                         0
Invoice disc / Leasing                                                                                                                                                                                 0
Short Term loans (<1 year)                                                                                                                                                                             0
Long Term Bank Loans/Leasing                                                                                                                                                                           0
Directors Loans                                                                                                                                                                                        0
Related Parties                                                                                                                                                                                        0
Convertible/Other Loans                                                                                                                                                                                0


Equity/Grants
Promoters' Equity Investment                                                                                                                                                                           0
Other Equity Investment                                                                                                                                                                                0


Total Cash Receipts                                0           0           0           0           0           0           0           0           0           0           0           0               0


Cash Payments
Operating Expenses
 Payments to Creditors/Suppliers                                                                                                                                                                       0
 Wages/Salaries                                                                                                                                                                                        0
 Other Cash Operating Expenses                                                                                                                                                                         0


Interest Paid                                                                                                                                                                                          0
Taxation Paid (Do not include VAT)                                                                                                                                                                     0


Capital Investment
 Site/Buildings Purchase                                                                                                                                                                               0
 Site/Buildings Modifications                                                                                                                                                                          0
 New Machinery / other Capex                                                                                                                                                                           0
 Intangible asset (Incl Capitalised R&D)                                                                                                                                                               0


Dividends
 Dividends Paid to EI                                                                                                                                                                                  0
 Other Dividends Paid                                                                                                                                                                                  0


Loans Repayment Total
 Bank Overdraft Payments                                                                                                                                                                               0
 Invoice Discounting/Leasing Payments                                                                                                                                                                  0
 Short term Loan Payments                                                                                                                                                                              0
 Long Term Bank Loans/Leasing Payments                                                                                                                                                                 0
 Other Long Term Liabilities Redeemed                                                                                                                                                                  0
 Related Parties Payments                                                                                                                                                                              0
 Directors Loans Redeemed                                                                                                                                                                              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


DA to Insert Package
EI Equity Investment                                                                                                                                                                                   0
EI Grants (this proposal only)                                                                                                                                                                         0


Opening Cash Balance                               0           0           0           0           0           0           0           0           0           0           0           0               0
Closing Cash Balance                               0           0           0           0           0           0           0           0           0           0           0           0               0


OverDraft Facility
Invoice Discounting Facility
Available headroom                                 0           0           0           0           0           0           0           0           0           0           0           0
Financial Data Sheet
Company Name
Company Information
[EI Development Adviser to provide basic clients details necessary for cost benefit model]
Region                            Please Select
Type of Company                   Please Select
Ownership/Strategic Control       Please Select
Growth Fund Application?          Please Select

Employment Numbers
[EI Development Adviser to enter base employment figure]
                                         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 Irish Payroll                           0
Increase in Post Tax Profits                        0

Value for Money measures

Ratio of Increased Export sales to EI
Support
Cost Per New Job Created
Track Record & Projections
Month
                                           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 (€000's)                                     0             0             0              0             0               0
Exports (€000's)                                   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
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                                       n/a           n/a           n/a            n/a           n/a             n/a
Value Add To Ireland                               0             0             0              0             0               0
Momentum
Sales Growth %                                                 n/a           n/a            n/a           n/a             n/a
Export Growth %                                                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 employee                 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
Liquidity/Gearing
Working Capital Increase (€000's)                 n/a             0             0             0             0                0
Total Debt                                          0             0             0             0             0                0
Shareholders Funds (€000's)                         0             0             0             0             0                0
Current Ratio                                     n/a           n/a           n/a           n/a           n/a              n/a
Net Debt/Equity                                   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
Employment
Global Employees at year-end                        0             0             0             0             0                0
Irish Employees at year-end                         0             0             0             0             0                0
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
Base Employment = 0

Funding Table
Month
Year End                                  DD/MM/YY DD/MM/YY DD/MM/YY                      Total
                                               €000's        €000's        €000's        €000's                  Funding Table Summary              Please Select
Operating                                                                                                        Requirements                          €000's
Sources                                                                                                          Net Operational outflow
Sales Receipts                                      0             0             0             0                  Capex
Other Revenue                                       0             0             0             0                  EI Share/Grant Redemptions
                                                    0             0             0             0                  Other Equity Redemptions
                                                                                                                 Short Term Loans Repayments
Requirements                                                                                                     Long Term Loans Repayments
Operating Expenses                                  0             0             0             0                  Unspent Cash
Interest Paid                                       0             0             0             0                                                                 0
Taxation                                            0             0             0             0
                                                    0             0             0             0
                                                                                                                 Sources
Operating Cash Inflow                               0             0             0             0                  Opening Cash position
                                                                                                                 Net Operational Inflow
Non-Operating                                                                                                    Short Term Loan Borrowing
Sources                                                                                                          Long Term Loan Borrowing
EI Equity                                           0             0             0             0                  EI
EI Grants                                           0             0             0             0                  Non EI Equity
Other Equity                                        0             0             0             0                  Additional Cash Required                       0
Short Term Bank Financing                           0             0             0             0                                                                 0
Long Term Bank Loans/Leasing                        0             0             0             0
Related Parties Loans                               0             0             0             0
Convertible/Other Loans                             0             0             0             0
                                                    0             0             0             0
                                                                                                                 i-HPSU Cost of the Business Plan
Requirements
Capital Expenditure                                 0             0             0             0
EI Dividends                                        0             0             0             0
Other Dividends                                     0             0             0             0
EI Share/Grant Redemptions                          0             0             0             0
Other Share Redemptions                             0             0             0             0
Short Term Bank Financing Payments                  0             0             0             0
Long Term Bank Loans/Leasing Payments               0             0             0             0
Directors / Related Parties Redemptions             0             0             0             0
                                                    0             0             0             0

Non-Operating Cash Inflow                           0             0             0             0

Total Cash Inflow                                   0             0             0             0
Total Cash Outflow                                  0             0             0             0
Total Net Cash Inflow                               0             0             0             0
Opening Cash                                        0             0             0
Closing Cash\ Available Cash                        0             0             0

Closing Cash excl facilities                        0             0             0



BES Redemption amount                               0
BES Redemption date                         00/Jan/00
Financial Analysis

                                             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 %                                            0%                  0%                0%              0%              0%              0%
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 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                   0                 0               0               0               0
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

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)
Total Operating Revenues                                                                                    0               0               0
Total Operating Expenses                                                                                    0               0               0
Operating Cash Inflow/(Outflow)                                                                             0               0               0
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


Credit Purchases                                        0              0              0
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

  Bank/Cash                                             0              0              0
Total Current Assets                                    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
Year End                                    DD/MM/YY         DD/MM/YY       DD/MM/YY
                                                   €000's         €000's         €000's
Cash Receipts
Revenues
Sales receipts                                          0              0              0

Total Cash Receipts                                     0              0              0

Cash Payments
Operating Expenses
 Payments to Creditors/Suppliers                        0              0              0
 Wages/Salaries & Other Operating Expenses              0              0              0

Total Cash Payments                                     0              0              0

Total Cash Inflow/(Outflow)                             0              0              0

Opening Cash Balance                                    0              0              0
Closing Cash Balance                                    0              0              0