| 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 | |||||||||||||
| Miles of Shipping | 12,000 | 18,000 | 27,000 | 37,800 | 52,920 | 55,566 | 58,344 | 61,262 | 64,325 | 67,541 | 70,918 | 74,464 | |
| Preferred Client Accounts | 0 | 1 | 2 | 4 | 7 | 8 | 9 | 10 | 10 | 11 | 12 | 14 | |
| Total Unit Sales | 12,000 | 18,001 | 27,002 | 37,804 | 52,927 | 55,574 | 58,353 | 61,272 | 64,335 | 67,552 | 70,930 | 74,478 | |
| 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 | |
| Miles of Shipping | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | |
| Preferred Client Accounts | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | |
| Sales | |||||||||||||
| Miles of Shipping | £15,600 | £23,400 | £35,100 | £49,140 | £68,796 | £72,236 | £75,848 | £79,640 | £83,622 | £87,803 | £92,193 | £96,803 | |
| Preferred Client Accounts | £0 | £1,000 | £2,000 | £4,000 | £7,000 | £8,000 | £9,000 | £10,000 | £10,000 | £11,000 | £12,000 | £14,000 | |
| Total Sales | £15,600 | £24,400 | £37,100 | £53,140 | £75,796 | £80,236 | £84,848 | £89,640 | £93,622 | £98,803 | £104,193 | £110,803 | |
| 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 | |
| Miles of Shipping | 50.00% | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 |
| Preferred Client Accounts | 10.00% | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 |
| Direct Cost of Sales | |||||||||||||
| Miles of Shipping | £7,800 | £11,700 | £17,550 | £24,570 | £34,398 | £36,118 | £37,924 | £39,820 | £41,811 | £43,902 | £46,097 | £48,401 | |
| Preferred Client Accounts | £0 | £100 | £200 | £400 | £700 | £800 | £900 | £1,000 | £1,000 | £1,100 | £1,200 | £1,400 | |
| Subtotal Direct Cost of Sales | £7,800 | £11,800 | £17,750 | £24,970 | £35,098 | £36,918 | £38,824 | £40,820 | £42,811 | £45,002 | £47,297 | £49,801 | |
| 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 | ||
| CEO | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| COO | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Sales/Marketing Associate | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Administrator | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Truck Drivers (Non-Job Payroll) | £1,000 | £1,200 | £1,440 | £1,584 | £1,901 | £2,091 | £2,300 | £2,530 | £2,783 | £3,061 | £3,367 | £3,704 | |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 8 | 8 | |
| Total Payroll | £13,000 | £13,200 | £13,440 | £16,584 | £16,901 | £17,091 | £17,300 | £17,530 | £17,783 | £18,061 | £18,367 | £18,704 | |
| 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 | £15,600 | £24,400 | £37,100 | £53,140 | £75,796 | £80,236 | £84,848 | £89,640 | £93,622 | £98,803 | £104,193 | £110,803 | |
| Direct Cost of Sales | £7,800 | £11,800 | £17,750 | £24,970 | £35,098 | £36,918 | £38,824 | £40,820 | £42,811 | £45,002 | £47,297 | £49,801 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £7,800 | £11,800 | £17,750 | £24,970 | £35,098 | £36,918 | £38,824 | £40,820 | £42,811 | £45,002 | £47,297 | £49,801 | |
| Gross Margin | £7,800 | £12,600 | £19,350 | £28,170 | £40,698 | £43,318 | £46,024 | £48,820 | £50,811 | £53,802 | £56,897 | £61,001 | |
| Gross Margin % | 50.00% | 51.64% | 52.16% | 53.01% | 53.69% | 53.99% | 54.24% | 54.46% | 54.27% | 54.45% | 54.61% | 55.05% | |
| Expenses | |||||||||||||
| Payroll | £13,000 | £13,200 | £13,440 | £16,584 | £16,901 | £17,091 | £17,300 | £17,530 | £17,783 | £18,061 | £18,367 | £18,704 | |
| Marketing/Promotion | £6,000 | £6,000 | £16,000 | £6,000 | £6,000 | £6,000 | £16,000 | £6,000 | £6,000 | £16,000 | £6,000 | £6,000 | |
| Depreciation | £4,580 | £4,580 | £4,580 | £4,580 | £4,580 | £4,580 | £4,580 | £4,580 | £4,580 | £6,038 | £6,038 | £6,038 | |
| Truck Maintenance/Repair | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £800 | £800 | £800 | |
| 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 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Payroll Taxes | 15% | £2,535 | £2,865 | £3,347 | £4,360 | £5,167 | £5,332 | £5,507 | £5,691 | £5,878 | £6,084 | £6,302 | £6,541 |
| Licenses and Permitting | 15% | £0 | £0 | £1,000 | £0 | £0 | £1,000 | £0 | £0 | £5,000 | £0 | £0 | £1,000 |
| Web Hosting and Development | £300 | £218 | £238 | £259 | £282 | £307 | £335 | £365 | £398 | £434 | £473 | £516 | |
| Total Operating Expenses | £31,315 | £31,763 | £43,505 | £36,683 | £37,830 | £39,210 | £48,622 | £39,066 | £44,539 | £51,718 | £42,281 | £43,899 | |
| Profit Before Interest and Taxes | (£23,515) | (£19,163) | (£24,155) | (£8,513) | £2,868 | £4,108 | (£2,598) | £9,754 | £6,272 | £2,084 | £14,616 | £17,103 | |
| EBITDA | (£18,935) | (£14,583) | (£19,575) | (£3,933) | £7,448 | £8,688 | £1,982 | £14,334 | £10,852 | £8,122 | £20,654 | £23,141 | |
| Interest Expense | £61 | £60 | £58 | £57 | £55 | £53 | £51 | £48 | £46 | £1,168 | £1,133 | £1,100 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£23,576) | (£19,223) | (£24,214) | (£8,570) | £2,813 | £4,055 | (£2,649) | £9,706 | £6,226 | £916 | £13,483 | £16,003 | |
| Net Profit/Sales | -151.13% | -78.78% | -65.27% | -16.13% | 3.71% | 5.05% | -3.12% | 10.83% | 6.65% | 0.93% | 12.94% | 14.44% | |
| 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 | £3,900 | £6,100 | £9,275 | £13,285 | £18,949 | £20,059 | £21,212 | £22,410 | £23,405 | £24,701 | £26,048 | £27,701 | |
| Cash from Receivables | £0 | £6,240 | £15,220 | £23,380 | £34,241 | £48,917 | £58,623 | £62,022 | £65,553 | £68,823 | £72,289 | £76,258 | |
| Subtotal Cash from Operations | £3,900 | £12,340 | £24,495 | £36,665 | £53,190 | £68,976 | £79,835 | £84,432 | £88,958 | £93,524 | £98,337 | £103,959 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 8.00% | £1,248 | £1,952 | £2,968 | £4,251 | £6,064 | £6,419 | £6,788 | £7,171 | £7,490 | £7,904 | £8,335 | £8,864 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £135,000 | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £5,148 | £14,292 | £27,463 | £40,916 | £59,254 | £75,395 | £86,623 | £91,603 | £96,448 | £236,428 | £106,673 | £112,823 | |
| 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 | £13,000 | £13,200 | £13,440 | £16,584 | £16,901 | £17,091 | £17,300 | £17,530 | £17,783 | £18,061 | £18,367 | £18,704 | |
| Bill Payments | £720 | £21,738 | £26,425 | £43,202 | £40,911 | £51,603 | £54,880 | £65,356 | £58,064 | £65,325 | £73,538 | £66,430 | |
| Subtotal Spent on Operations | £13,720 | £34,938 | £39,865 | £59,786 | £57,812 | £68,693 | £72,180 | £82,886 | £75,847 | £83,386 | £91,905 | £85,134 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £1,248 | £1,952 | £2,968 | £4,251 | £6,064 | £6,419 | £6,788 | £7,171 | £7,490 | £7,904 | £8,335 | £8,864 | |
| Principal Repayment of Current Borrowing | £100 | £110 | £121 | £133 | £146 | £161 | £177 | £195 | £215 | £237 | £261 | £144 | |
| 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 | £3,750 | £3,750 | |
| 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 | £175,000 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £15,068 | £37,000 | £42,954 | £64,170 | £64,022 | £75,273 | £79,145 | £90,253 | £83,552 | £266,527 | £104,252 | £97,892 | |
| Net Cash Flow | (£9,920) | (£22,708) | (£15,491) | (£23,254) | (£4,768) | £122 | £7,477 | £1,350 | £12,896 | (£30,099) | £2,421 | £14,931 | |
| Cash Balance | £80,080 | £57,372 | £41,882 | £18,628 | £13,860 | £13,982 | £21,459 | £22,809 | £35,705 | £5,605 | £8,026 | £22,957 | |
| 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 | £90,000 | £80,080 | £57,372 | £41,882 | £18,628 | £13,860 | £13,982 | £21,459 | £22,809 | £35,705 | £5,605 | £8,026 | £22,957 |
| Accounts Receivable | £0 | £11,700 | £23,760 | £36,365 | £52,840 | £75,446 | £86,705 | £91,718 | £96,927 | £101,590 | £106,870 | £112,726 | £119,570 |
| 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 | £110,000 | £111,780 | £101,132 | £98,247 | £91,468 | £109,306 | £120,687 | £133,177 | £139,736 | £157,295 | £132,475 | £140,752 | £162,527 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £550,000 | £550,000 | £550,000 | £550,000 | £550,000 | £550,000 | £550,000 | £550,000 | £550,000 | £550,000 | £725,000 | £725,000 | £725,000 |
| Accumulated Depreciation | £0 | £4,580 | £9,160 | £13,740 | £18,320 | £22,900 | £27,480 | £32,060 | £36,640 | £41,220 | £47,258 | £53,296 | £59,334 |
| Total Long-term Assets | £550,000 | £545,420 | £540,840 | £536,260 | £531,680 | £527,100 | £522,520 | £517,940 | £513,360 | £508,780 | £677,742 | £671,704 | £665,666 |
| Total Assets | £660,000 | £657,200 | £641,972 | £634,507 | £623,148 | £636,406 | £643,207 | £651,117 | £653,096 | £666,075 | £810,217 | £812,456 | £828,193 |
| 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 | £20,876 | £24,981 | £41,850 | £39,195 | £49,786 | £52,693 | £63,429 | £55,897 | £62,865 | £71,328 | £64,095 | £67,723 |
| Current Borrowing | £5,000 | £4,900 | £4,790 | £4,669 | £4,536 | £4,390 | £4,229 | £4,052 | £3,857 | £3,642 | £3,405 | £3,144 | £3,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £5,000 | £25,776 | £29,771 | £46,519 | £43,731 | £54,176 | £56,922 | £67,481 | £59,754 | £66,507 | £74,733 | £67,239 | £70,723 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £135,000 | £131,250 | £127,500 |
| Total Liabilities | £5,000 | £25,776 | £29,771 | £46,519 | £43,731 | £54,176 | £56,922 | £67,481 | £59,754 | £66,507 | £209,733 | £198,489 | £198,223 |
| Paid-in Capital | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 |
| Retained Earnings | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) |
| Earnings | £0 | (£23,576) | (£42,799) | (£67,013) | (£75,583) | (£72,770) | (£68,715) | (£71,364) | (£61,658) | (£55,432) | (£54,515) | (£41,033) | (£25,030) |
| Total Capital | £655,000 | £631,424 | £612,201 | £587,987 | £579,417 | £582,230 | £586,285 | £583,636 | £593,342 | £599,568 | £600,485 | £613,967 | £629,970 |
| Total Liabilities and Capital | £660,000 | £657,200 | £641,972 | £634,507 | £623,148 | £636,406 | £643,207 | £651,117 | £653,096 | £666,075 | £810,217 | £812,456 | £828,193 |
| Net Worth | £655,000 | £631,424 | £612,201 | £587,987 | £579,417 | £582,230 | £586,285 | £583,636 | £593,342 | £599,568 | £600,485 | £613,967 | £629,970 |
| 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 | |||||||||||||
| Miles of Shipping | 12,000 | 18,000 | 27,000 | 37,800 | 52,920 | 55,566 | 58,344 | 61,262 | 64,325 | 67,541 | 70,918 | 74,464 | |
| Preferred Client Accounts | 0 | 1 | 2 | 4 | 7 | 8 | 9 | 10 | 10 | 11 | 12 | 14 | |
| Total Unit Sales | 12,000 | 18,001 | 27,002 | 37,804 | 52,927 | 55,574 | 58,353 | 61,272 | 64,335 | 67,552 | 70,930 | 74,478 | |
| 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 | |
| Miles of Shipping | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | £1.30 | |
| Preferred Client Accounts | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | |
| Sales | |||||||||||||
| Miles of Shipping | £15,600 | £23,400 | £35,100 | £49,140 | £68,796 | £72,236 | £75,848 | £79,640 | £83,622 | £87,803 | £92,193 | £96,803 | |
| Preferred Client Accounts | £0 | £1,000 | £2,000 | £4,000 | £7,000 | £8,000 | £9,000 | £10,000 | £10,000 | £11,000 | £12,000 | £14,000 | |
| Total Sales | £15,600 | £24,400 | £37,100 | £53,140 | £75,796 | £80,236 | £84,848 | £89,640 | £93,622 | £98,803 | £104,193 | £110,803 | |
| 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 | |
| Miles of Shipping | 50.00% | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 | £0.65 |
| Preferred Client Accounts | 10.00% | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 |
| Direct Cost of Sales | |||||||||||||
| Miles of Shipping | £7,800 | £11,700 | £17,550 | £24,570 | £34,398 | £36,118 | £37,924 | £39,820 | £41,811 | £43,902 | £46,097 | £48,401 | |
| Preferred Client Accounts | £0 | £100 | £200 | £400 | £700 | £800 | £900 | £1,000 | £1,000 | £1,100 | £1,200 | £1,400 | |
| Subtotal Direct Cost of Sales | £7,800 | £11,800 | £17,750 | £24,970 | £35,098 | £36,918 | £38,824 | £40,820 | £42,811 | £45,002 | £47,297 | £49,801 | |
| 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 | ||
| CEO | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| COO | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Sales/Marketing Associate | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Administrator | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Truck Drivers (Non-Job Payroll) | £1,000 | £1,200 | £1,440 | £1,584 | £1,901 | £2,091 | £2,300 | £2,530 | £2,783 | £3,061 | £3,367 | £3,704 | |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 8 | 8 | |
| Total Payroll | £13,000 | £13,200 | £13,440 | £16,584 | £16,901 | £17,091 | £17,300 | £17,530 | £17,783 | £18,061 | £18,367 | £18,704 | |
| 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 | £15,600 | £24,400 | £37,100 | £53,140 | £75,796 | £80,236 | £84,848 | £89,640 | £93,622 | £98,803 | £104,193 | £110,803 | |
| Direct Cost of Sales | £7,800 | £11,800 | £17,750 | £24,970 | £35,098 | £36,918 | £38,824 | £40,820 | £42,811 | £45,002 | £47,297 | £49,801 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £7,800 | £11,800 | £17,750 | £24,970 | £35,098 | £36,918 | £38,824 | £40,820 | £42,811 | £45,002 | £47,297 | £49,801 | |
| Gross Margin | £7,800 | £12,600 | £19,350 | £28,170 | £40,698 | £43,318 | £46,024 | £48,820 | £50,811 | £53,802 | £56,897 | £61,001 | |
| Gross Margin % | 50.00% | 51.64% | 52.16% | 53.01% | 53.69% | 53.99% | 54.24% | 54.46% | 54.27% | 54.45% | 54.61% | 55.05% | |
| Expenses | |||||||||||||
| Payroll | £13,000 | £13,200 | £13,440 | £16,584 | £16,901 | £17,091 | £17,300 | £17,530 | £17,783 | £18,061 | £18,367 | £18,704 | |
| Marketing/Promotion | £6,000 | £6,000 | £16,000 | £6,000 | £6,000 | £6,000 | £16,000 | £6,000 | £6,000 | £16,000 | £6,000 | £6,000 | |
| Depreciation | £4,580 | £4,580 | £4,580 | £4,580 | £4,580 | £4,580 | £4,580 | £4,580 | £4,580 | £6,038 | £6,038 | £6,038 | |
| Truck Maintenance/Repair | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £800 | £800 | £800 | |
| 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 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Payroll Taxes | 15% | £2,535 | £2,865 | £3,347 | £4,360 | £5,167 | £5,332 | £5,507 | £5,691 | £5,878 | £6,084 | £6,302 | £6,541 |
| Licenses and Permitting | 15% | £0 | £0 | £1,000 | £0 | £0 | £1,000 | £0 | £0 | £5,000 | £0 | £0 | £1,000 |
| Web Hosting and Development | £300 | £218 | £238 | £259 | £282 | £307 | £335 | £365 | £398 | £434 | £473 | £516 | |
| Total Operating Expenses | £31,315 | £31,763 | £43,505 | £36,683 | £37,830 | £39,210 | £48,622 | £39,066 | £44,539 | £51,718 | £42,281 | £43,899 | |
| Profit Before Interest and Taxes | (£23,515) | (£19,163) | (£24,155) | (£8,513) | £2,868 | £4,108 | (£2,598) | £9,754 | £6,272 | £2,084 | £14,616 | £17,103 | |
| EBITDA | (£18,935) | (£14,583) | (£19,575) | (£3,933) | £7,448 | £8,688 | £1,982 | £14,334 | £10,852 | £8,122 | £20,654 | £23,141 | |
| Interest Expense | £61 | £60 | £58 | £57 | £55 | £53 | £51 | £48 | £46 | £1,168 | £1,133 | £1,100 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£23,576) | (£19,223) | (£24,214) | (£8,570) | £2,813 | £4,055 | (£2,649) | £9,706 | £6,226 | £916 | £13,483 | £16,003 | |
| Net Profit/Sales | -151.13% | -78.78% | -65.27% | -16.13% | 3.71% | 5.05% | -3.12% | 10.83% | 6.65% | 0.93% | 12.94% | 14.44% | |
| 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 | £3,900 | £6,100 | £9,275 | £13,285 | £18,949 | £20,059 | £21,212 | £22,410 | £23,405 | £24,701 | £26,048 | £27,701 | |
| Cash from Receivables | £0 | £6,240 | £15,220 | £23,380 | £34,241 | £48,917 | £58,623 | £62,022 | £65,553 | £68,823 | £72,289 | £76,258 | |
| Subtotal Cash from Operations | £3,900 | £12,340 | £24,495 | £36,665 | £53,190 | £68,976 | £79,835 | £84,432 | £88,958 | £93,524 | £98,337 | £103,959 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 8.00% | £1,248 | £1,952 | £2,968 | £4,251 | £6,064 | £6,419 | £6,788 | £7,171 | £7,490 | £7,904 | £8,335 | £8,864 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £135,000 | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £5,148 | £14,292 | £27,463 | £40,916 | £59,254 | £75,395 | £86,623 | £91,603 | £96,448 | £236,428 | £106,673 | £112,823 | |
| 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 | £13,000 | £13,200 | £13,440 | £16,584 | £16,901 | £17,091 | £17,300 | £17,530 | £17,783 | £18,061 | £18,367 | £18,704 | |
| Bill Payments | £720 | £21,738 | £26,425 | £43,202 | £40,911 | £51,603 | £54,880 | £65,356 | £58,064 | £65,325 | £73,538 | £66,430 | |
| Subtotal Spent on Operations | £13,720 | £34,938 | £39,865 | £59,786 | £57,812 | £68,693 | £72,180 | £82,886 | £75,847 | £83,386 | £91,905 | £85,134 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £1,248 | £1,952 | £2,968 | £4,251 | £6,064 | £6,419 | £6,788 | £7,171 | £7,490 | £7,904 | £8,335 | £8,864 | |
| Principal Repayment of Current Borrowing | £100 | £110 | £121 | £133 | £146 | £161 | £177 | £195 | £215 | £237 | £261 | £144 | |
| 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 | £3,750 | £3,750 | |
| 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 | £175,000 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £15,068 | £37,000 | £42,954 | £64,170 | £64,022 | £75,273 | £79,145 | £90,253 | £83,552 | £266,527 | £104,252 | £97,892 | |
| Net Cash Flow | (£9,920) | (£22,708) | (£15,491) | (£23,254) | (£4,768) | £122 | £7,477 | £1,350 | £12,896 | (£30,099) | £2,421 | £14,931 | |
| Cash Balance | £80,080 | £57,372 | £41,882 | £18,628 | £13,860 | £13,982 | £21,459 | £22,809 | £35,705 | £5,605 | £8,026 | £22,957 | |
| 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 | £90,000 | £80,080 | £57,372 | £41,882 | £18,628 | £13,860 | £13,982 | £21,459 | £22,809 | £35,705 | £5,605 | £8,026 | £22,957 |
| Accounts Receivable | £0 | £11,700 | £23,760 | £36,365 | £52,840 | £75,446 | £86,705 | £91,718 | £96,927 | £101,590 | £106,870 | £112,726 | £119,570 |
| 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 | £110,000 | £111,780 | £101,132 | £98,247 | £91,468 | £109,306 | £120,687 | £133,177 | £139,736 | £157,295 | £132,475 | £140,752 | £162,527 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £550,000 | £550,000 | £550,000 | £550,000 | £550,000 | £550,000 | £550,000 | £550,000 | £550,000 | £550,000 | £725,000 | £725,000 | £725,000 |
| Accumulated Depreciation | £0 | £4,580 | £9,160 | £13,740 | £18,320 | £22,900 | £27,480 | £32,060 | £36,640 | £41,220 | £47,258 | £53,296 | £59,334 |
| Total Long-term Assets | £550,000 | £545,420 | £540,840 | £536,260 | £531,680 | £527,100 | £522,520 | £517,940 | £513,360 | £508,780 | £677,742 | £671,704 | £665,666 |
| Total Assets | £660,000 | £657,200 | £641,972 | £634,507 | £623,148 | £636,406 | £643,207 | £651,117 | £653,096 | £666,075 | £810,217 | £812,456 | £828,193 |
| 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 | £20,876 | £24,981 | £41,850 | £39,195 | £49,786 | £52,693 | £63,429 | £55,897 | £62,865 | £71,328 | £64,095 | £67,723 |
| Current Borrowing | £5,000 | £4,900 | £4,790 | £4,669 | £4,536 | £4,390 | £4,229 | £4,052 | £3,857 | £3,642 | £3,405 | £3,144 | £3,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £5,000 | £25,776 | £29,771 | £46,519 | £43,731 | £54,176 | £56,922 | £67,481 | £59,754 | £66,507 | £74,733 | £67,239 | £70,723 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £135,000 | £131,250 | £127,500 |
| Total Liabilities | £5,000 | £25,776 | £29,771 | £46,519 | £43,731 | £54,176 | £56,922 | £67,481 | £59,754 | £66,507 | £209,733 | £198,489 | £198,223 |
| Paid-in Capital | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 | £718,000 |
| Retained Earnings | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) | (£63,000) |
| Earnings | £0 | (£23,576) | (£42,799) | (£67,013) | (£75,583) | (£72,770) | (£68,715) | (£71,364) | (£61,658) | (£55,432) | (£54,515) | (£41,033) | (£25,030) |
| Total Capital | £655,000 | £631,424 | £612,201 | £587,987 | £579,417 | £582,230 | £586,285 | £583,636 | £593,342 | £599,568 | £600,485 | £613,967 | £629,970 |
| Total Liabilities and Capital | £660,000 | £657,200 | £641,972 | £634,507 | £623,148 | £636,406 | £643,207 | £651,117 | £653,096 | £666,075 | £810,217 | £812,456 | £828,193 |
| Net Worth | £655,000 | £631,424 | £612,201 | £587,987 | £579,417 | £582,230 | £586,285 | £583,636 | £593,342 | £599,568 | £600,485 | £613,967 | £629,970 |