Cash Flow Forecast Example - Bank of St. Helena: Introduction

Document Sample
Cash Flow Forecast Example - Bank of St. Helena: Introduction Powered By Docstoc
					                                                                             EXAMPLE CASH FLOW FORECAST



                          Month 1      Month 2      Month 3      Month 4      Month 5      Month 6      Month 7      Month 8      Month 9     Month 10    Month 11    Month 12         Total
INCOME
                                                                                                                                                                                       £0.00
Sales: drinks                £0.00     £100.00      £180.00      £300.00      £480.00      £730.00     £1,060.00    £1,460.00    £1,900.00    £2,330.00   £2,680.00   £2,880.00   £14,100.00
Sales: food                  £0.00      £80.00      £140.00      £240.00      £390.00      £600.00      £870.00     £1,200.00    £1,560.00    £1,910.00   £2,200.00   £2,370.00   £11,560.00
Sales: other                 £0.00      £25.00       £40.00       £70.00      £110.00      £170.00      £250.00      £340.00      £440.00      £540.00     £620.00     £670.00     £3,275.00
Bank loan                £3,000.00                                                                                                                                                 £3,000.00
Owner Investment         £5,000.00                                                                                                                                                 £5,000.00
                                                                                                                                                                                       £0.00
                                                                                                                                                                                       £0.00
              £13.20                                                                                                                                                                   £0.00
            £354.00                                                                                                                                                                    £0.00
Total Income:            £8,000.00     £205.00      £360.00      £610.00      £980.00     £1,500.00    £2,180.00    £3,000.00    £3,900.00    £4,780.00   £5,500.00   £5,920.00   £36,935.00

EXPENDITURE
                                                                                                                                                                                       £0.00
Equipment Purchase        £500.00      £250.00                                                                                                                                      £750.00
Installation & fitting    £250.00      £150.00                                                                                                                                      £400.00
Legal Fees                £100.00                                                                                                                                                   £100.00
Rent                      £200.00      £200.00      £200.00      £200.00      £200.00      £200.00      £200.00      £200.00      £200.00      £200.00     £200.00     £200.00     £2,400.00
Electricity                £50.00       £50.00       £50.00       £50.00       £50.00       £50.00        £50.00       £50.00       £50.00       £50.00      £50.00      £50.00     £600.00
Wages (staff)             £100.00      £100.00      £100.00      £100.00      £100.00      £100.00      £100.00      £250.00      £250.00      £250.00     £250.00     £250.00     £1,950.00
Owner salary              £250.00      £250.00      £250.00      £250.00      £250.00      £250.00      £250.00      £250.00      £250.00      £250.00     £250.00     £250.00     £3,000.00
Bank loan repayments      £130.00      £130.00      £130.00      £130.00      £130.00      £130.00      £130.00      £130.00      £130.00      £130.00     £130.00     £130.00     £1,560.00
Supplies: drinks           £70.00      £126.00      £210.00      £336.00      £511.00      £742.00     £1,022.00    £1,330.00    £1,631.00    £1,876.00   £2,016.00   £2,156.00   £12,026.00
Supplies: food             £56.00       £98.00      £168.00      £273.00      £420.00      £609.00      £840.00     £1,092.00    £1,337.00    £1,540.00   £1,659.00   £1,778.00    £9,870.00
Supplies: other            £18.00       £28.00       £49.00       £77.00      £119.00      £175.00      £238.00      £308.00      £378.00      £434.00     £469.00     £504.00     £2,797.00
                                                                                                                                                                                       £0.00
                                                                                                                                                                                       £0.00
                                                                                                                                                                                       £0.00
Total Expenditure:       £1,724.00   £1,382.00     £1,157.00    £1,416.00    £1,780.00    £2,256.00    £2,830.00    £3,610.00    £4,226.00    £4,730.00   £5,024.00   £5,318.00   £35,453.00

Net Cash                 £6,276.00   (£1,177.00)    (£797.00)    (£806.00)    (£800.00)    (£756.00)    (£650.00)    (£610.00)    (£326.00)     £50.00     £476.00     £602.00     £1,482.00

BANK ACCOUNT
Opening Balance
              £0.00
Balance                  £6,276.00   £5,099.00     £4,302.00    £3,496.00    £2,696.00    £1,940.00    £1,290.00     £680.00      £354.00      £404.00     £880.00    £1,482.00

DISCLAIMER: this spreadsheet is provided "as is" with no guarantee of performance.




   C:\Docstoc\Working\pdf\697a4d06-5759-40d7-8671-894881e4822d.xls Example, page 1 of 2, printed 10/13/2012 2:53 PM
                                                                          EXAMPLE CASH FLOW FORECAST



                        Month 1      Month 2      Month 3      Month 4      Month 5      Month 6      Month 7      Month 8      Month 9   Month 10   Month 11   Month 12   Total
INCOME
                                                                                                                                                                           £0.00
        Your                                                                                                                                                               £0.00
      income                                                                                                                                                               £0.00
     categories                                                                                                                                                            £0.00
         go                                                                                                                                                                £0.00
        here                                                                                                                                                               £0.00
                                                                                                                                                                           £0.00
                                                                                                                                                                           £0.00
                                                                                                                                                                           £0.00
                                                                                                                                                                           £0.00
Total Income:              £0.00        £0.00        £0.00        £0.00       £0.00        £0.00        £0.00        £0.00        £0.00     £0.00      £0.00      £0.00    £0.00

EXPENDITURE
                                                                                                                                                                           £0.00
        Your                                                                                                                                                               £0.00
    Expenditure                                                                                                                                                            £0.00
     categories                                                                                                                                                            £0.00
         go                                                                                                                                                                £0.00
        here                                                                                                                                                               £0.00
                                                                                                                                                                           £0.00
                                                                                                                                                                           £0.00
                                                                                                                                                                           £0.00
                                                                                                                                                                           £0.00
                                                                                                                                                                           £0.00
                                                                                                                                                                           £0.00
                                                                                                                                                                           £0.00
                                                                                                                                                                           £0.00
                                                                                                                                                                           £0.00
Total Expenditure:         £0.00        £0.00        £0.00        £0.00       £0.00        £0.00        £0.00        £0.00        £0.00     £0.00      £0.00      £0.00    £0.00

Net Cash                   £0.00        £0.00        £0.00        £0.00       £0.00        £0.00        £0.00        £0.00        £0.00     £0.00      £0.00      £0.00    £0.00

BANK ACCOUNT
Opening Balance
              £0.00
Balance                    £0.00        £0.00        £0.00        £0.00       £0.00        £0.00        £0.00        £0.00        £0.00     £0.00      £0.00      £0.00

DISCLAIMER: this spreadsheet is provided "as is" with no guarantee of performance.




  C:\Docstoc\Working\pdf\697a4d06-5759-40d7-8671-894881e4822d.xls Blank for you to complete, page 2 of 2, printed 10/13/2012 2:53 PM

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:10/13/2012
language:Unknown
pages:2