Cashflow.xls
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Cashflow.xls as PDF for free.
More details
- Words: 313
- Pages: 2
AIB SMALL BUSINESS RECOVERY SCHEME Two Year Cashflow Forecast [Enter Business Name] 3 easy steps for completion: 1. Calculate the projected Profit & Loss for (a) current year and (b) next financial year 2. Estimate increase/decrease in working capital 3. Complete simple Cashflow Forecast using calculations from 1 and 2 above. To complete this template, you will need the following: • Profit & Loss Account and Balance Sheet for your last financial year and • Projected Profit & Loss and Balance Sheet for your current financial year
1. Projected Profit & Loss Statement 12 months to xx/xx/xx € 0 0 0 0 0 0 0 0
Sales (excluding VAT) Less Cost of goods sold Gross Profit Salaries & Overheads Directors Remuneration Selling, General & Admin Expenses Depreciation Total operating expenses Operating Income (Gross Profit - Total Operating Expenses) Less Interest Expense Profit Before Tax Less Corporation Tax Profit after Tax
0 0 0 0 0
12 months to xx/xx/xx € 0 0 0 0 0 0 0 0 0 0 0 0 0
2. Projected Working Capital Requirement At start of financial year Debtors Add Stock Less Creditors
€ 0 0 0
€ 0 0 0
Net Working Capital @ start of year At end of financial year Debtors Add Stock Less Creditors
0
0
0 0 0
0 0 0
Net Working Capital @ end of year
0
0
Net Movement in Working Capital
0
0
Profit after Tax Plus Depreciation & Interest Less Drawings inclusive of tax (Sole Traders/Partnerships) Less net movement in Working Capital Net Cash from Operating Activities
€ 0 0 0 0 0
€ 0 0 0 0 0
Less Capital Expenditure Less Repayments on all loans (Capital & Interest)
0 0
0 0
3. Cashflow Statement Summary
05/10
Net increase in Cash (Net Cash from Op Activities less Cap Ex & Bank Debt Repayments)
0
0
05/10
1. Projected Profit & Loss Statement 12 months to xx/xx/xx € 0 0 0 0 0 0 0 0
Sales (excluding VAT) Less Cost of goods sold Gross Profit Salaries & Overheads Directors Remuneration Selling, General & Admin Expenses Depreciation Total operating expenses Operating Income (Gross Profit - Total Operating Expenses) Less Interest Expense Profit Before Tax Less Corporation Tax Profit after Tax
0 0 0 0 0
12 months to xx/xx/xx € 0 0 0 0 0 0 0 0 0 0 0 0 0
2. Projected Working Capital Requirement At start of financial year Debtors Add Stock Less Creditors
€ 0 0 0
€ 0 0 0
Net Working Capital @ start of year At end of financial year Debtors Add Stock Less Creditors
0
0
0 0 0
0 0 0
Net Working Capital @ end of year
0
0
Net Movement in Working Capital
0
0
Profit after Tax Plus Depreciation & Interest Less Drawings inclusive of tax (Sole Traders/Partnerships) Less net movement in Working Capital Net Cash from Operating Activities
€ 0 0 0 0 0
€ 0 0 0 0 0
Less Capital Expenditure Less Repayments on all loans (Capital & Interest)
0 0
0 0
3. Cashflow Statement Summary
05/10
Net increase in Cash (Net Cash from Op Activities less Cap Ex & Bank Debt Repayments)
0
0
05/10
More Documents from "ElgaNurhikmah"
3922-article Text-6870-1-10-20170927
October 2019 16
Cashflow.xls
August 2019 17
364-1508-1-pb
October 2019 24