Business Cashflow Forecast Template 
                                                                                                                                                                                                                                                  Notes
              Business Income:                                Month 1  Month 2   Month 3  Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10         Month 11  Month 12   Totals     Month 1 refers to the commencement of your business (i.e. when sales will be made - if you are a Start-up this could be next month!) 
              Sales for Cash                                                                                                                                                              0Be realistic as sales may not commence immediately
              Sales given with credit terms                                                                                                                                               0Please include details in your Business Plan if you are offering Credit Terms 
              Back to Work Enterprise Allowance                                                                                                                                           0
              Grant Support (if any)                                                                                                                                                      0Grants from EI / LEO / ILDN
              Other Household Income                                                                                                                                                      0Is there any other income coming into the household on a regular basis (Social Welfare, Salary/Wages, Childrens Allowance etc)?
              Microfinance Ireland Loan Amount, if approved                                                                                                                               0Insert the amount of the loan being applied for
              Total of all incomes                                    0        0         0        0        0        0        0        0        0         0         0          0           0
              Outgoings/Business Expenses:                    Month 1  Month 2   Month 3  Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10         Month 11  Month 12   Totals
                                                                                                                                                                                           Please itemise what you will spend the MFI loan funding on  (e.g premises, fixtures & fittings, van, wages & salaries, working capital etc).  If it’s 
              Microfinance Ireland Loan Amount (Use of funds):                                                                                                                             included here, you do not include under the relevant heading below so as to avoid double counting 
              1;                                                                                                                                                                          0
              2;                                                                                                                                                                          0
              3;                                                                                                                                                                          0
              Purchases (stock replacement + supplies)                                                                                                                                    0It is really important that you include a figure to replace stock
              Utility Bills (ESB + Phone + Gas + Insurance etc.)                                                                                                                          0Remember your bills in the winter months will be higher for Electricity, Light + Heat etc
              Business Premises costs (Rent, Rates, Fire insurance.)                                                                                                                      0Who is responsible for the payment of (i) Rates (ii) Insurance?: This should be detailed within the Lease Agreement.
              Staff costs (wages and salaries)                                                                                                                                            0
              Payroll tax (PAYE, PRSI etc)                                                                                                                                                0
              Proposed MFI loan repayments  (C&I), if approved                                                                                                                            0Repayment Calculator / Amount available on MFI's website www.microfinanceireland.ie/loan-calculator
              Transport and delivery costs                                                                                                                                                0Include total costs relating to vehicles (e.g. Car/Van, Insurance, Tax, Diesel/Petrol etc.)
              Marketing and Promotion                                                                                                                                                     0Be realistic as costs for Marketing & Prormotion should be relative to sales
              Owner's Minimum Drawings                                                                                                                                                    0Please visit the examples on the Insolvency Service of Ireland's website for Reasonable Living Expenses  
              Lease Repayments                                                                                                                                                            0Do you have a car / van on HP/ PCP etc. ?
              Other Loan Repayments (Bank, CU, Credit Card etc)                                                                                                                           0Do you have Bank/ Credit Union Loan repayments (holidays, wedding etc) or do you pay money off your credit card?
              Other expenses relating to your business                                                                                                                                    0
              Value Added Tax (VAT)                                                                                                                                                       0The standard VAT rate, if applicable, is 23% but there are 4 other rates
              Miscellanous                                                                                                                                                                0
               
                                                                                                                                                                                          0
              Total Outgoings/Business Expenses                       0        0         0        0        0        0        0        0        0         0         0          0           0
              Income less Outgoings                                   0        0         0        0        0        0        0        0        0         0         0          0           0
              Opening Bank                                                     0         0        0        0        0        0        0        0         0         0          0
              Closing Bank                                            0        0         0        0        0        0        0        0        0         0         0          0           0
              Other points to consider: 
              1. Please tell us, as part of your Business Plan, how you have calculated some of the above figures, eg, Sales, Purchases, Staff costs, etc. 
              2. Be mindful that your business may have an element of seasonality where Sales may be lower in Winter and higher in Summer
              3. Decide the minimum number of staff required for your business -  Can you employ part-time staff ? 
              Help with the spreadsheet:
              Right click on the row number (left hand side) to insert new rows if needed
              You can add rows, change headings to make sure this template is relevant/accurate for your business 
              For more help with your Cashflow Forecast go to our blog on the MFI website https://resources.microfinanceireland.ie/7-financial-projections  
              Last Updated 31 July 2019