| Sales 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 | ||
| Unit Sales | |||||||||||||
| Velour Drawstring Pouch | 0% | 7,000 | 7,000 | 15,000 | 25,000 | 25,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 75,000 | 75,000 |
| Leather Drawstring Pouch | 0% | 1,500 | 1,500 | 3,000 | 5,000 | 5,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 75,000 | 75,000 |
| Round Bottom Pouch | 0% | 2,250 | 2,250 | 3,000 | 3,750 | 3,750 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 11,250 | 11,250 |
| Pen/Mug & Eyeglass Bag | 0% | 1,800 | 1,800 | 2,400 | 3,000 | 3,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 9,000 | 9,000 |
| Metal Lip Eyeglass Bag | 0% | 750 | 750 | 1,000 | 1,250 | 1,250 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 3,750 | 3,750 |
| Assorted Jewelry Rolls | 0% | 675 | 675 | 900 | 1,125 | 1,125 | 2,250 | 2,250 | 2,250 | 2,250 | 2,250 | 3,375 | 3,375 |
| Satin Bags | 0% | 750 | 750 | 1,000 | 1,250 | 1,250 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 3,375 | 3,375 |
| Message Imprinting | 0% | 14,725 | 14,725 | 25,300 | 40,375 | 40,375 | 80,750 | 80,750 | 80,750 | 80,750 | 80,750 | 180,750 | 180,750 |
| Die Charges | 0% | 20 | 20 | 25 | 30 | 30 | 50 | 50 | 50 | 50 | 50 | 60 | 60 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 29,470 | 29,470 | 51,625 | 80,780 | 80,780 | 161,550 | 161,550 | 161,550 | 161,550 | 161,550 | 361,560 | 361,560 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Velour Drawstring Pouch | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | |
| Leather Drawstring Pouch | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | |
| Round Bottom Pouch | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | |
| Pen/Mug & Eyeglass Bag | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | |
| Metal Lip Eyeglass Bag | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | |
| Assorted Jewelry Rolls | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | |
| Satin Bags | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | |
| Message Imprinting | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | |
| Die Charges | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Sales | |||||||||||||
| Velour Drawstring Pouch | £1,540 | £1,540 | £3,300 | £5,500 | £5,500 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £16,500 | £16,500 | |
| Leather Drawstring Pouch | £540 | £540 | £1,080 | £1,800 | £1,800 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £27,000 | £27,000 | |
| Round Bottom Pouch | £1,800 | £1,800 | £2,400 | £3,000 | £3,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £9,000 | £9,000 | |
| Pen/Mug & Eyeglass Bag | £972 | £972 | £1,296 | £1,620 | £1,620 | £3,240 | £3,240 | £3,240 | £3,240 | £3,240 | £4,860 | £4,860 | |
| Metal Lip Eyeglass Bag | £450 | £450 | £600 | £750 | £750 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £2,250 | £2,250 | |
| Assorted Jewelry Rolls | £3,375 | £3,375 | £4,500 | £5,625 | £5,625 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £16,875 | £16,875 | |
| Satin Bags | £330 | £330 | £440 | £550 | £550 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,485 | £1,485 | |
| Message Imprinting | £1,473 | £1,473 | £2,530 | £4,038 | £4,038 | £8,075 | £8,075 | £8,075 | £8,075 | £8,075 | £18,075 | £18,075 | |
| Die Charges | £750 | £750 | £938 | £1,125 | £1,125 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £2,250 | £2,250 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £11,230 | £11,230 | £17,084 | £24,008 | £24,008 | £47,640 | £47,640 | £47,640 | £47,640 | £47,640 | £98,295 | £98,295 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Velour Drawstring Pouch | 0.00% | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 |
| Leather Drawstring Pouch | 0.00% | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 |
| Round Bottom Pouch | 0.00% | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 |
| Pen/Mug & Eyeglass Bag | 0.00% | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 |
| Metal Lip Eyeglass Bag | 0.00% | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 |
| Assorted Jewelry Rolls | 0.00% | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 |
| Satin Bags | 0.00% | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 |
| Message Imprinting | 0.00% | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 |
| Die Charges | 0.00% | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 |
| Other | 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 |
| Direct Cost of Sales | |||||||||||||
| Velour Drawstring Pouch | £770 | £770 | £1,650 | £2,750 | £2,750 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £8,250 | £8,250 | |
| Leather Drawstring Pouch | £270 | £270 | £540 | £900 | £900 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £13,500 | £13,500 | |
| Round Bottom Pouch | £900 | £900 | £1,200 | £1,500 | £1,500 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £4,500 | £4,500 | |
| Pen/Mug & Eyeglass Bag | £486 | £486 | £648 | £810 | £810 | £1,620 | £1,620 | £1,620 | £1,620 | £1,620 | £2,430 | £2,430 | |
| Metal Lip Eyeglass Bag | £225 | £225 | £300 | £375 | £375 | £750 | £750 | £750 | £750 | £750 | £1,125 | £1,125 | |
| Assorted Jewelry Rolls | £1,688 | £1,688 | £2,250 | £2,813 | £2,813 | £5,625 | £5,625 | £5,625 | £5,625 | £5,625 | £8,438 | £8,438 | |
| Satin Bags | £165 | £165 | £220 | £275 | £275 | £550 | £550 | £550 | £550 | £550 | £743 | £743 | |
| Message Imprinting | £1,031 | £1,031 | £1,771 | £2,826 | £2,826 | £5,653 | £5,653 | £5,653 | £5,653 | £5,653 | £12,653 | £12,653 | |
| Die Charges | £500 | £500 | £625 | £750 | £750 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,500 | £1,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £6,034 | £6,034 | £9,204 | £12,999 | £12,999 | £25,748 | £25,748 | £25,748 | £25,748 | £25,748 | £53,138 | £53,138 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Production Personnel | |||||||||||||
| Imprint | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | |
| Shipping | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | |
| Sales and Marketing Personnel | |||||||||||||
| Marvin | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Sales Reps | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | |
| General and Administrative Personnel | |||||||||||||
| Customer Service | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Other Personnel | |||||||||||||
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £11,500 | £11,500 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £11,230 | £11,230 | £17,084 | £24,008 | £24,008 | £47,640 | £47,640 | £47,640 | £47,640 | £47,640 | £98,295 | £98,295 | |
| Direct Cost of Sales | £6,034 | £6,034 | £9,204 | £12,999 | £12,999 | £25,748 | £25,748 | £25,748 | £25,748 | £25,748 | £53,138 | £53,138 | |
| Production Payroll | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £8,034 | £8,034 | £11,204 | £14,999 | £14,999 | £27,748 | £27,748 | £27,748 | £27,748 | £27,748 | £57,138 | £57,138 | |
| Gross Margin | £3,195 | £3,195 | £5,880 | £9,009 | £9,009 | £19,893 | £19,893 | £19,893 | £19,893 | £19,893 | £41,158 | £41,158 | |
| Gross Margin % | 28.45% | 28.45% | 34.42% | 37.52% | 37.52% | 41.76% | 41.76% | 41.76% | 41.76% | 41.76% | 41.87% | 41.87% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | |
| Advertising/Promotion | £0 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Travel | £300 | £300 | £2,000 | £500 | £4,000 | £5,000 | £500 | £300 | £500 | £4,000 | £500 | £1,000 | |
| Miscellaneous | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Other Sales and Marketing Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales and Marketing Expenses | £5,300 | £9,300 | £11,000 | £9,500 | £13,000 | £14,000 | £9,500 | £9,300 | £9,500 | £13,000 | £9,500 | £10,000 | |
| Sales and Marketing % | 47.20% | 82.82% | 64.39% | 39.57% | 54.15% | 29.39% | 19.94% | 19.52% | 19.94% | 27.29% | 9.66% | 10.17% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Marketing/Promotion | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Utilities | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Payroll Taxes | 20% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| General and Administrative % | 87.27% | 87.27% | 57.37% | 40.82% | 40.82% | 20.57% | 20.57% | 20.57% | 20.57% | 20.57% | 9.97% | 9.97% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Total Operating Expenses | £15,100 | £19,100 | £20,800 | £19,300 | £22,800 | £23,800 | £19,300 | £19,100 | £19,300 | £22,800 | £19,300 | £19,800 | |
| Profit Before Interest and Taxes | (£11,905) | (£15,905) | (£14,921) | (£10,291) | (£13,791) | (£3,908) | £593 | £793 | £593 | (£2,908) | £21,858 | £21,358 | |
| EBITDA | (£11,905) | (£15,905) | (£14,921) | (£10,291) | (£13,791) | (£3,908) | £593 | £793 | £593 | (£2,908) | £21,858 | £21,358 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £417 | £625 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£11,905) | (£15,905) | (£14,921) | (£10,291) | (£13,791) | (£3,908) | £593 | £793 | £593 | (£2,908) | £21,441 | £20,733 | |
| Net Profit/Sales | -106.01% | -141.63% | -87.34% | -42.87% | -57.45% | -8.20% | 1.24% | 1.66% | 1.24% | -6.10% | 21.81% | 21.09% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £374 | £11,230 | £11,425 | £17,314 | £24,008 | £24,795 | £47,640 | £47,640 | £47,640 | £47,640 | £49,329 | |
| Subtotal Cash from Operations | £0 | £374 | £11,230 | £11,425 | £17,314 | £24,008 | £24,795 | £47,640 | £47,640 | £47,640 | £47,640 | £49,329 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £50,000 | £25,000 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £50,000 | £0 | £50,000 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £374 | £11,230 | £61,425 | £17,314 | £74,008 | £24,795 | £47,640 | £47,640 | £47,640 | £97,640 | £74,329 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £11,500 | £11,500 | |
| Bill Payments | £253 | £7,733 | £11,657 | £13,536 | £20,634 | £29,224 | £55,454 | £37,541 | £37,354 | £37,664 | £42,862 | £94,502 | |
| Subtotal Spent on Operations | £9,753 | £17,233 | £21,157 | £23,036 | £30,134 | £38,724 | £64,954 | £47,041 | £46,854 | £47,164 | £54,362 | £106,002 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £9,753 | £17,233 | £21,157 | £23,036 | £30,134 | £38,724 | £64,954 | £47,041 | £46,854 | £47,164 | £54,362 | £106,002 | |
| Net Cash Flow | (£9,753) | (£16,859) | (£9,927) | £38,389 | (£12,820) | £35,283 | (£40,158) | £599 | £786 | £476 | £43,278 | (£31,674) | |
| Cash Balance | £107,647 | £90,788 | £80,860 | £119,249 | £106,430 | £141,713 | £101,554 | £102,153 | £102,939 | £103,415 | £146,693 | £115,019 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £117,400 | £107,647 | £90,788 | £80,860 | £119,249 | £106,430 | £141,713 | £101,554 | £102,153 | £102,939 | £103,415 | £146,693 | £115,019 |
| Accounts Receivable | £0 | £11,230 | £22,085 | £27,939 | £40,522 | £47,215 | £70,847 | £93,692 | £93,692 | £93,692 | £93,692 | £144,347 | £193,314 |
| Inventory | £40,000 | £33,966 | £27,932 | £18,728 | £14,299 | £14,299 | £28,322 | £28,322 | £28,322 | £28,322 | £28,322 | £58,451 | £58,451 |
| Other Current Assets | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Total Current Assets | £177,400 | £172,842 | £160,804 | £147,527 | £194,070 | £187,943 | £260,882 | £243,568 | £244,168 | £244,953 | £245,429 | £369,491 | £386,784 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total Assets | £182,400 | £177,842 | £165,804 | £152,527 | £199,070 | £192,943 | £265,882 | £248,568 | £249,168 | £249,953 | £250,429 | £374,491 | £391,784 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £7,347 | £11,213 | £12,857 | £19,691 | £27,355 | £54,202 | £36,296 | £36,103 | £36,296 | £39,679 | £92,300 | £63,860 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £50,000 | £75,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £7,347 | £11,213 | £12,857 | £19,691 | £27,355 | £54,202 | £36,296 | £36,103 | £36,296 | £39,679 | £142,300 | £138,860 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £7,347 | £11,213 | £12,857 | £19,691 | £27,355 | £54,202 | £36,296 | £36,103 | £36,296 | £39,679 | £142,300 | £138,860 |
| Paid-in Capital | £200,000 | £200,000 | £200,000 | £200,000 | £250,000 | £250,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 |
| Retained Earnings | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) |
| Earnings | £0 | (£11,905) | (£27,810) | (£42,730) | (£53,021) | (£66,813) | (£70,720) | (£70,128) | (£69,335) | (£68,743) | (£71,650) | (£50,209) | (£29,477) |
| Total Capital | £182,400 | £170,495 | £154,591 | £139,670 | £179,379 | £165,588 | £211,680 | £212,273 | £213,065 | £213,658 | £210,750 | £232,191 | £252,923 |
| Total Liabilities and Capital | £182,400 | £177,842 | £165,804 | £152,527 | £199,070 | £192,943 | £265,882 | £248,568 | £249,168 | £249,953 | £250,429 | £374,491 | £391,784 |
| Net Worth | £182,400 | £170,495 | £154,590 | £139,670 | £179,379 | £165,587 | £211,680 | £212,272 | £213,065 | £213,657 | £210,750 | £232,191 | £252,923 |
| Sales 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 | ||
| Unit Sales | |||||||||||||
| Velour Drawstring Pouch | 0% | 7,000 | 7,000 | 15,000 | 25,000 | 25,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 75,000 | 75,000 |
| Leather Drawstring Pouch | 0% | 1,500 | 1,500 | 3,000 | 5,000 | 5,000 | 10,000 | 10,000 | 10,000 | 10,000 | 10,000 | 75,000 | 75,000 |
| Round Bottom Pouch | 0% | 2,250 | 2,250 | 3,000 | 3,750 | 3,750 | 7,500 | 7,500 | 7,500 | 7,500 | 7,500 | 11,250 | 11,250 |
| Pen/Mug & Eyeglass Bag | 0% | 1,800 | 1,800 | 2,400 | 3,000 | 3,000 | 6,000 | 6,000 | 6,000 | 6,000 | 6,000 | 9,000 | 9,000 |
| Metal Lip Eyeglass Bag | 0% | 750 | 750 | 1,000 | 1,250 | 1,250 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 3,750 | 3,750 |
| Assorted Jewelry Rolls | 0% | 675 | 675 | 900 | 1,125 | 1,125 | 2,250 | 2,250 | 2,250 | 2,250 | 2,250 | 3,375 | 3,375 |
| Satin Bags | 0% | 750 | 750 | 1,000 | 1,250 | 1,250 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 3,375 | 3,375 |
| Message Imprinting | 0% | 14,725 | 14,725 | 25,300 | 40,375 | 40,375 | 80,750 | 80,750 | 80,750 | 80,750 | 80,750 | 180,750 | 180,750 |
| Die Charges | 0% | 20 | 20 | 25 | 30 | 30 | 50 | 50 | 50 | 50 | 50 | 60 | 60 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 29,470 | 29,470 | 51,625 | 80,780 | 80,780 | 161,550 | 161,550 | 161,550 | 161,550 | 161,550 | 361,560 | 361,560 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Velour Drawstring Pouch | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | |
| Leather Drawstring Pouch | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | £0.36 | |
| Round Bottom Pouch | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | |
| Pen/Mug & Eyeglass Bag | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | £0.54 | |
| Metal Lip Eyeglass Bag | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | |
| Assorted Jewelry Rolls | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | |
| Satin Bags | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | £0.44 | |
| Message Imprinting | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | |
| Die Charges | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | £37.50 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Sales | |||||||||||||
| Velour Drawstring Pouch | £1,540 | £1,540 | £3,300 | £5,500 | £5,500 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £16,500 | £16,500 | |
| Leather Drawstring Pouch | £540 | £540 | £1,080 | £1,800 | £1,800 | £3,600 | £3,600 | £3,600 | £3,600 | £3,600 | £27,000 | £27,000 | |
| Round Bottom Pouch | £1,800 | £1,800 | £2,400 | £3,000 | £3,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £9,000 | £9,000 | |
| Pen/Mug & Eyeglass Bag | £972 | £972 | £1,296 | £1,620 | £1,620 | £3,240 | £3,240 | £3,240 | £3,240 | £3,240 | £4,860 | £4,860 | |
| Metal Lip Eyeglass Bag | £450 | £450 | £600 | £750 | £750 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £2,250 | £2,250 | |
| Assorted Jewelry Rolls | £3,375 | £3,375 | £4,500 | £5,625 | £5,625 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £16,875 | £16,875 | |
| Satin Bags | £330 | £330 | £440 | £550 | £550 | £1,100 | £1,100 | £1,100 | £1,100 | £1,100 | £1,485 | £1,485 | |
| Message Imprinting | £1,473 | £1,473 | £2,530 | £4,038 | £4,038 | £8,075 | £8,075 | £8,075 | £8,075 | £8,075 | £18,075 | £18,075 | |
| Die Charges | £750 | £750 | £938 | £1,125 | £1,125 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £2,250 | £2,250 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £11,230 | £11,230 | £17,084 | £24,008 | £24,008 | £47,640 | £47,640 | £47,640 | £47,640 | £47,640 | £98,295 | £98,295 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Velour Drawstring Pouch | 0.00% | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 | £0.11 |
| Leather Drawstring Pouch | 0.00% | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 | £0.18 |
| Round Bottom Pouch | 0.00% | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 | £0.40 |
| Pen/Mug & Eyeglass Bag | 0.00% | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 | £0.27 |
| Metal Lip Eyeglass Bag | 0.00% | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 | £0.30 |
| Assorted Jewelry Rolls | 0.00% | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 |
| Satin Bags | 0.00% | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 | £0.22 |
| Message Imprinting | 0.00% | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 | £0.07 |
| Die Charges | 0.00% | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 |
| Other | 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 |
| Direct Cost of Sales | |||||||||||||
| Velour Drawstring Pouch | £770 | £770 | £1,650 | £2,750 | £2,750 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £8,250 | £8,250 | |
| Leather Drawstring Pouch | £270 | £270 | £540 | £900 | £900 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £13,500 | £13,500 | |
| Round Bottom Pouch | £900 | £900 | £1,200 | £1,500 | £1,500 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £4,500 | £4,500 | |
| Pen/Mug & Eyeglass Bag | £486 | £486 | £648 | £810 | £810 | £1,620 | £1,620 | £1,620 | £1,620 | £1,620 | £2,430 | £2,430 | |
| Metal Lip Eyeglass Bag | £225 | £225 | £300 | £375 | £375 | £750 | £750 | £750 | £750 | £750 | £1,125 | £1,125 | |
| Assorted Jewelry Rolls | £1,688 | £1,688 | £2,250 | £2,813 | £2,813 | £5,625 | £5,625 | £5,625 | £5,625 | £5,625 | £8,438 | £8,438 | |
| Satin Bags | £165 | £165 | £220 | £275 | £275 | £550 | £550 | £550 | £550 | £550 | £743 | £743 | |
| Message Imprinting | £1,031 | £1,031 | £1,771 | £2,826 | £2,826 | £5,653 | £5,653 | £5,653 | £5,653 | £5,653 | £12,653 | £12,653 | |
| Die Charges | £500 | £500 | £625 | £750 | £750 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,500 | £1,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £6,034 | £6,034 | £9,204 | £12,999 | £12,999 | £25,748 | £25,748 | £25,748 | £25,748 | £25,748 | £53,138 | £53,138 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Production Personnel | |||||||||||||
| Imprint | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | |
| Shipping | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £2,000 | £2,000 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | |
| Sales and Marketing Personnel | |||||||||||||
| Marvin | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Sales Reps | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | |
| General and Administrative Personnel | |||||||||||||
| Customer Service | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Other Personnel | |||||||||||||
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £11,500 | £11,500 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £11,230 | £11,230 | £17,084 | £24,008 | £24,008 | £47,640 | £47,640 | £47,640 | £47,640 | £47,640 | £98,295 | £98,295 | |
| Direct Cost of Sales | £6,034 | £6,034 | £9,204 | £12,999 | £12,999 | £25,748 | £25,748 | £25,748 | £25,748 | £25,748 | £53,138 | £53,138 | |
| Production Payroll | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £8,034 | £8,034 | £11,204 | £14,999 | £14,999 | £27,748 | £27,748 | £27,748 | £27,748 | £27,748 | £57,138 | £57,138 | |
| Gross Margin | £3,195 | £3,195 | £5,880 | £9,009 | £9,009 | £19,893 | £19,893 | £19,893 | £19,893 | £19,893 | £41,158 | £41,158 | |
| Gross Margin % | 28.45% | 28.45% | 34.42% | 37.52% | 37.52% | 41.76% | 41.76% | 41.76% | 41.76% | 41.76% | 41.87% | 41.87% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | |
| Advertising/Promotion | £0 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Travel | £300 | £300 | £2,000 | £500 | £4,000 | £5,000 | £500 | £300 | £500 | £4,000 | £500 | £1,000 | |
| Miscellaneous | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Other Sales and Marketing Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales and Marketing Expenses | £5,300 | £9,300 | £11,000 | £9,500 | £13,000 | £14,000 | £9,500 | £9,300 | £9,500 | £13,000 | £9,500 | £10,000 | |
| Sales and Marketing % | 47.20% | 82.82% | 64.39% | 39.57% | 54.15% | 29.39% | 19.94% | 19.52% | 19.94% | 27.29% | 9.66% | 10.17% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Marketing/Promotion | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Utilities | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Payroll Taxes | 20% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| General and Administrative % | 87.27% | 87.27% | 57.37% | 40.82% | 40.82% | 20.57% | 20.57% | 20.57% | 20.57% | 20.57% | 9.97% | 9.97% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Total Operating Expenses | £15,100 | £19,100 | £20,800 | £19,300 | £22,800 | £23,800 | £19,300 | £19,100 | £19,300 | £22,800 | £19,300 | £19,800 | |
| Profit Before Interest and Taxes | (£11,905) | (£15,905) | (£14,921) | (£10,291) | (£13,791) | (£3,908) | £593 | £793 | £593 | (£2,908) | £21,858 | £21,358 | |
| EBITDA | (£11,905) | (£15,905) | (£14,921) | (£10,291) | (£13,791) | (£3,908) | £593 | £793 | £593 | (£2,908) | £21,858 | £21,358 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £417 | £625 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£11,905) | (£15,905) | (£14,921) | (£10,291) | (£13,791) | (£3,908) | £593 | £793 | £593 | (£2,908) | £21,441 | £20,733 | |
| Net Profit/Sales | -106.01% | -141.63% | -87.34% | -42.87% | -57.45% | -8.20% | 1.24% | 1.66% | 1.24% | -6.10% | 21.81% | 21.09% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £374 | £11,230 | £11,425 | £17,314 | £24,008 | £24,795 | £47,640 | £47,640 | £47,640 | £47,640 | £49,329 | |
| Subtotal Cash from Operations | £0 | £374 | £11,230 | £11,425 | £17,314 | £24,008 | £24,795 | £47,640 | £47,640 | £47,640 | £47,640 | £49,329 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £50,000 | £25,000 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £50,000 | £0 | £50,000 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £374 | £11,230 | £61,425 | £17,314 | £74,008 | £24,795 | £47,640 | £47,640 | £47,640 | £97,640 | £74,329 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £11,500 | £11,500 | |
| Bill Payments | £253 | £7,733 | £11,657 | £13,536 | £20,634 | £29,224 | £55,454 | £37,541 | £37,354 | £37,664 | £42,862 | £94,502 | |
| Subtotal Spent on Operations | £9,753 | £17,233 | £21,157 | £23,036 | £30,134 | £38,724 | £64,954 | £47,041 | £46,854 | £47,164 | £54,362 | £106,002 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £9,753 | £17,233 | £21,157 | £23,036 | £30,134 | £38,724 | £64,954 | £47,041 | £46,854 | £47,164 | £54,362 | £106,002 | |
| Net Cash Flow | (£9,753) | (£16,859) | (£9,927) | £38,389 | (£12,820) | £35,283 | (£40,158) | £599 | £786 | £476 | £43,278 | (£31,674) | |
| Cash Balance | £107,647 | £90,788 | £80,860 | £119,249 | £106,430 | £141,713 | £101,554 | £102,153 | £102,939 | £103,415 | £146,693 | £115,019 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £117,400 | £107,647 | £90,788 | £80,860 | £119,249 | £106,430 | £141,713 | £101,554 | £102,153 | £102,939 | £103,415 | £146,693 | £115,019 |
| Accounts Receivable | £0 | £11,230 | £22,085 | £27,939 | £40,522 | £47,215 | £70,847 | £93,692 | £93,692 | £93,692 | £93,692 | £144,347 | £193,314 |
| Inventory | £40,000 | £33,966 | £27,932 | £18,728 | £14,299 | £14,299 | £28,322 | £28,322 | £28,322 | £28,322 | £28,322 | £58,451 | £58,451 |
| Other Current Assets | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Total Current Assets | £177,400 | £172,842 | £160,804 | £147,527 | £194,070 | £187,943 | £260,882 | £243,568 | £244,168 | £244,953 | £245,429 | £369,491 | £386,784 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total Assets | £182,400 | £177,842 | £165,804 | £152,527 | £199,070 | £192,943 | £265,882 | £248,568 | £249,168 | £249,953 | £250,429 | £374,491 | £391,784 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £7,347 | £11,213 | £12,857 | £19,691 | £27,355 | £54,202 | £36,296 | £36,103 | £36,296 | £39,679 | £92,300 | £63,860 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £50,000 | £75,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £7,347 | £11,213 | £12,857 | £19,691 | £27,355 | £54,202 | £36,296 | £36,103 | £36,296 | £39,679 | £142,300 | £138,860 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £7,347 | £11,213 | £12,857 | £19,691 | £27,355 | £54,202 | £36,296 | £36,103 | £36,296 | £39,679 | £142,300 | £138,860 |
| Paid-in Capital | £200,000 | £200,000 | £200,000 | £200,000 | £250,000 | £250,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 |
| Retained Earnings | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) | (£17,600) |
| Earnings | £0 | (£11,905) | (£27,810) | (£42,730) | (£53,021) | (£66,813) | (£70,720) | (£70,128) | (£69,335) | (£68,743) | (£71,650) | (£50,209) | (£29,477) |
| Total Capital | £182,400 | £170,495 | £154,591 | £139,670 | £179,379 | £165,588 | £211,680 | £212,273 | £213,065 | £213,658 | £210,750 | £232,191 | £252,923 |
| Total Liabilities and Capital | £182,400 | £177,842 | £165,804 | £152,527 | £199,070 | £192,943 | £265,882 | £248,568 | £249,168 | £249,953 | £250,429 | £374,491 | £391,784 |
| Net Worth | £182,400 | £170,495 | £154,590 | £139,670 | £179,379 | £165,587 | £211,680 | £212,272 | £213,065 | £213,657 | £210,750 | £232,191 | £252,923 |