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