FINANCIALS – YEAR 1 CASHFLOW
Income T0 Y1 M1 Y1 M2 Y1 M3 Y1 M4 Y1 M5 Y1 M6 Y1 M7 Y1 M8 Y1 M9 Y1 M10 Y1 M11 Y1 M12
Take out sales 47,775 57,330 63,700 71,663 76,440 81,900 88,200 95,550 95,550 95,550 95,550 95,550
Eat in sales 2,389 2,867 3,185 3,372 3,583 3,822 4,095 4,410 4,778 4,778 4,778 4,778
Delivery sales
Total Sales Income 0 50,164 60,197 66,885 75,035 80,023 85,722 92,295 99,960 100,328 100,328 100,328 100,328
Expenditure
Rent 30,000 30,000 30,000 30,000
Rates 3,860 3,860 3,860 3,860 3,860 3,860 3,860 3,860 3,860 3,860 3,860 3,860
Utilities 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Staff 20,445 20,445 20,445 20,445 20,445 20,445 20,445 20,445 20,445 20,445 20,445 20,445
Staff bonuses 2,044 2,044 2,044 2,044 2,044 2,044 2,044 2,044 2,044 2,044 2,044 2,044
Marketing (including printing) 9,000 9,000 818 818 818 818 818 818 818 818 818 818 818
Back Office (Accounts, HR, PAYE) 1,000 0 0 0 0 0 0 0 0 0 0 0
Cleaning 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500
Insurance/Security/Maintenance 250 250 250 250 250 250 250 250 250 250 250 250
Professional Services (Legal, Audit) 5,000 0 0 0 0 0 0 0 0 0 0 0 5000
Depreciation (initial fit out + IT equip) 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500
Food and packaging 17,557 21,069 23,410 26,262 28,008 30,003 32,303 34,986 35,115 35,115 35,115 35,115
Tax (VAT @ 17.5%) 0 0 0 1477 0 0 1886 0 0 2324 0 0
Repairs and seasonal decorations 417 417 417 417 417 417 417 417 417 417 417 417
Tills and computers 333 333 333 333 333 333 333 333 333 333 333 333
Bank charges 903 1,084 1,204 1,351 1,440 1,543 1,661 1,799 1,806 1,806 1,806 1,806
Repayment of initial loan (300,000) 0 0 0 0 0 0 0 0 50,000 0 0 50,000
Capital works and £30k deposit 150,000 0 0 0 0 0 0 0 0 0 0 0 0
Total expenditure 164,000 90,809 55,319 57,781 92,257 62,616 64,713 99,018 69,952 120,088 102,412 70,088 125,088
Income - expenditure -164,000 -40,645 4,877 9,104 -17,222 17,408 21,009 -6,723 30,008 -19,760 -2,085 30,240 -24,760
Cash Brought Forward 300,000 136,000 95,355 100,232 109,336 92,114 109,521 130,530 123,808 153,815 134,055 131,971 162,211
Month closing bank balance 136,000 95,355 100,232 109,336 92,114 109,521 130,530 123,808 153,815 134,055 131,971 162,211 137,450