| 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 | ||
| Sales | |||||||||||||
| Private | 0% | £12,860 | £10,966 | £11,435 | £12,889 | £13,001 | £15,777 | £15,998 | £24,960 | £26,522 | £20,009 | £19,650 | £22,103 |
| Public | 0% | £3,852 | £7,884 | £7,200 | £8,965 | £8,566 | £7,600 | £9,705 | £11,245 | £11,780 | £11,999 | £12,300 | £12,089 |
| Other | 0% | £800 | £955 | £900 | £1,190 | £2,450 | £2,133 | £2,100 | £4,656 | £4,500 | £4,622 | £4,800 | £4,688 |
| Total Sales | £17,512 | £19,805 | £19,535 | £23,044 | £24,017 | £25,510 | £27,803 | £40,861 | £42,802 | £36,630 | £36,750 | £38,880 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Private | £1,800 | £1,535 | £1,601 | £1,804 | £1,820 | £2,209 | £2,240 | £3,494 | £3,713 | £2,801 | £2,751 | £3,094 | |
| Public | £385 | £788 | £720 | £897 | £857 | £760 | £971 | £1,125 | £1,178 | £1,200 | £1,230 | £1,209 | |
| Other | £40 | £48 | £45 | £60 | £123 | £107 | £105 | £233 | £225 | £231 | £240 | £234 | |
| Subtotal Direct Cost of Sales | £2,226 | £2,371 | £2,366 | £2,760 | £2,799 | £3,075 | £3,315 | £4,852 | £5,116 | £4,232 | £4,221 | £4,538 | |
| 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 | ||
| Event Specialist | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Site Manager | 0% | £735 | £907 | £735 | £735 | £735 | £735 | £1,245 | £1,400 | £1,245 | £875 | £875 | £875 |
| Other | 0% | £586 | £800 | £586 | £586 | £586 | £586 | £844 | £895 | £844 | £844 | £895 | £895 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £4,321 | £4,707 | £4,321 | £4,321 | £4,321 | £4,321 | £5,089 | £5,295 | £5,089 | £4,719 | £4,770 | £4,770 | |
| 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 | £17,512 | £19,805 | £19,535 | £23,044 | £24,017 | £25,510 | £27,803 | £40,861 | £42,802 | £36,630 | £36,750 | £38,880 | |
| Direct Cost of Sales | £2,226 | £2,371 | £2,366 | £2,760 | £2,799 | £3,075 | £3,315 | £4,852 | £5,116 | £4,232 | £4,221 | £4,538 | |
| Other Costs of Sales | £15 | £13 | £15 | £16 | £16 | £16 | £19 | £22 | £22 | £13 | £15 | £14 | |
| Total Cost of Sales | £2,241 | £2,384 | £2,381 | £2,776 | £2,815 | £3,091 | £3,334 | £4,874 | £5,138 | £4,245 | £4,236 | £4,552 | |
| Gross Margin | £15,271 | £17,421 | £17,154 | £20,268 | £21,202 | £22,419 | £24,469 | £35,987 | £37,664 | £32,385 | £32,514 | £34,328 | |
| Gross Margin % | 87.21% | 87.96% | 87.81% | 87.95% | 88.28% | 87.88% | 88.01% | 88.07% | 88.00% | 88.41% | 88.47% | 88.29% | |
| Expenses | |||||||||||||
| Payroll | £4,321 | £4,707 | £4,321 | £4,321 | £4,321 | £4,321 | £5,089 | £5,295 | £5,089 | £4,719 | £4,770 | £4,770 | |
| Sales & Marketing & Other Expenses | £9,015 | £10,748 | £9,982 | £10,260 | £10,315 | £10,415 | £12,418 | £18,015 | £16,615 | £13,290 | £11,975 | £12,965 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £43 | £43 | £43 | £43 | £43 | £43 | £43 | £43 | £43 | £43 | £43 | £43 | |
| Insurance | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | |
| Rent | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | |
| Payroll Taxes | 12% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £13,521 | £15,640 | £14,488 | £14,766 | £14,821 | £14,921 | £17,692 | £23,495 | £21,889 | £18,194 | £16,930 | £17,920 | |
| Profit Before Interest and Taxes | £1,750 | £1,781 | £2,666 | £5,502 | £6,381 | £7,498 | £6,777 | £12,492 | £15,775 | £14,191 | £15,584 | £16,408 | |
| EBITDA | £1,750 | £1,781 | £2,666 | £5,502 | £6,381 | £7,498 | £6,777 | £12,492 | £15,775 | £14,191 | £15,584 | £16,408 | |
| Interest Expense | £17 | £50 | £47 | £44 | £41 | £38 | £35 | £33 | £30 | £27 | £24 | £21 | |
| Taxes Incurred | £416 | £415 | £629 | £1,310 | £1,521 | £1,790 | £1,618 | £2,990 | £3,779 | £3,399 | £3,734 | £3,933 | |
| Net Profit | £1,318 | £1,315 | £1,990 | £4,148 | £4,818 | £5,669 | £5,123 | £9,469 | £11,966 | £10,765 | £11,826 | £12,454 | |
| Net Profit/Sales | 7.52% | 6.64% | 10.19% | 18.00% | 20.06% | 22.22% | 18.43% | 23.17% | 27.96% | 29.39% | 32.18% | 32.03% | |
| 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 | £7,005 | £7,922 | £7,814 | £9,218 | £9,607 | £10,204 | £11,121 | £16,344 | £17,121 | £14,652 | £14,700 | £15,552 | |
| Cash from Receivables | £0 | £5,604 | £11,241 | £11,797 | £12,844 | £14,138 | £14,888 | £16,040 | £20,860 | £25,138 | £23,706 | £22,016 | |
| Subtotal Cash from Operations | £7,005 | £13,526 | £19,055 | £21,014 | £22,451 | £24,342 | £26,009 | £32,384 | £37,981 | £39,790 | £38,406 | £37,568 | |
| 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 | £4,000 | £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 | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £7,005 | £17,526 | £19,055 | £21,014 | £22,451 | £24,342 | £26,009 | £32,384 | £37,981 | £39,790 | £38,406 | £37,568 | |
| 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 | £4,321 | £4,707 | £4,321 | £4,321 | £4,321 | £4,321 | £5,089 | £5,295 | £5,089 | £4,719 | £4,770 | £4,770 | |
| Bill Payments | £477 | £14,309 | £13,919 | £13,277 | £15,006 | £14,951 | £15,891 | £18,185 | £27,728 | £25,842 | £20,173 | £20,204 | |
| Subtotal Spent on Operations | £4,798 | £19,016 | £18,240 | £17,598 | £19,327 | £19,272 | £20,980 | £23,480 | £32,817 | £30,561 | £24,943 | £24,974 | |
| 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 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| 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 | £4,798 | £19,016 | £18,590 | £17,948 | £19,677 | £19,622 | £21,330 | £23,830 | £33,167 | £30,911 | £25,293 | £25,324 | |
| Net Cash Flow | £2,206 | (£1,490) | £465 | £3,066 | £2,773 | £4,720 | £4,679 | £8,554 | £4,814 | £8,879 | £13,113 | £12,245 | |
| Cash Balance | £4,506 | £3,016 | £3,481 | £6,547 | £9,321 | £14,041 | £18,719 | £27,273 | £32,087 | £40,966 | £54,079 | £66,323 | |
| 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 | £2,300 | £4,506 | £3,016 | £3,481 | £6,547 | £9,321 | £14,041 | £18,719 | £27,273 | £32,087 | £40,966 | £54,079 | £66,323 |
| Accounts Receivable | £0 | £10,507 | £16,786 | £17,266 | £19,296 | £20,863 | £22,031 | £23,825 | £32,301 | £37,122 | £33,963 | £32,306 | £33,618 |
| Inventory | £0 | £2,448 | £2,609 | £2,602 | £3,037 | £3,079 | £3,383 | £3,647 | £5,337 | £5,628 | £4,655 | £4,643 | £4,991 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £2,300 | £17,462 | £22,411 | £23,350 | £28,880 | £33,262 | £39,454 | £46,191 | £64,911 | £74,837 | £79,584 | £91,028 | £104,933 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £2,300 | £17,462 | £22,411 | £23,350 | £28,880 | £33,262 | £39,454 | £46,191 | £64,911 | £74,837 | £79,584 | £91,028 | £104,933 |
| 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 | £13,844 | £13,478 | £12,777 | £14,509 | £14,423 | £15,296 | £17,259 | £26,860 | £25,169 | £19,502 | £19,470 | £21,270 |
| Current Borrowing | £2,000 | £2,000 | £6,000 | £5,650 | £5,300 | £4,950 | £4,600 | £4,250 | £3,900 | £3,550 | £3,200 | £2,850 | £2,500 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £2,000 | £15,844 | £19,478 | £18,427 | £19,809 | £19,373 | £19,896 | £21,509 | £30,760 | £28,719 | £22,702 | £22,320 | £23,770 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £2,000 | £15,844 | £19,478 | £18,427 | £19,809 | £19,373 | £19,896 | £21,509 | £30,760 | £28,719 | £22,702 | £22,320 | £23,770 |
| Paid-in Capital | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 |
| Retained Earnings | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) |
| Earnings | £0 | £1,318 | £2,633 | £4,623 | £8,771 | £13,589 | £19,258 | £24,381 | £33,851 | £45,817 | £56,582 | £68,408 | £80,862 |
| Total Capital | £300 | £1,618 | £2,933 | £4,923 | £9,071 | £13,889 | £19,558 | £24,681 | £34,151 | £46,117 | £56,882 | £68,708 | £81,162 |
| Total Liabilities and Capital | £2,300 | £17,462 | £22,411 | £23,350 | £28,880 | £33,262 | £39,454 | £46,191 | £64,911 | £74,837 | £79,584 | £91,028 | £104,933 |
| Net Worth | £300 | £1,618 | £2,933 | £4,923 | £9,071 | £13,889 | £19,558 | £24,681 | £34,151 | £46,117 | £56,882 | £68,708 | £81,162 |
| 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 | ||
| Sales | |||||||||||||
| Private | 0% | £12,860 | £10,966 | £11,435 | £12,889 | £13,001 | £15,777 | £15,998 | £24,960 | £26,522 | £20,009 | £19,650 | £22,103 |
| Public | 0% | £3,852 | £7,884 | £7,200 | £8,965 | £8,566 | £7,600 | £9,705 | £11,245 | £11,780 | £11,999 | £12,300 | £12,089 |
| Other | 0% | £800 | £955 | £900 | £1,190 | £2,450 | £2,133 | £2,100 | £4,656 | £4,500 | £4,622 | £4,800 | £4,688 |
| Total Sales | £17,512 | £19,805 | £19,535 | £23,044 | £24,017 | £25,510 | £27,803 | £40,861 | £42,802 | £36,630 | £36,750 | £38,880 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Private | £1,800 | £1,535 | £1,601 | £1,804 | £1,820 | £2,209 | £2,240 | £3,494 | £3,713 | £2,801 | £2,751 | £3,094 | |
| Public | £385 | £788 | £720 | £897 | £857 | £760 | £971 | £1,125 | £1,178 | £1,200 | £1,230 | £1,209 | |
| Other | £40 | £48 | £45 | £60 | £123 | £107 | £105 | £233 | £225 | £231 | £240 | £234 | |
| Subtotal Direct Cost of Sales | £2,226 | £2,371 | £2,366 | £2,760 | £2,799 | £3,075 | £3,315 | £4,852 | £5,116 | £4,232 | £4,221 | £4,538 | |
| 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 | ||
| Event Specialist | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Site Manager | 0% | £735 | £907 | £735 | £735 | £735 | £735 | £1,245 | £1,400 | £1,245 | £875 | £875 | £875 |
| Other | 0% | £586 | £800 | £586 | £586 | £586 | £586 | £844 | £895 | £844 | £844 | £895 | £895 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £4,321 | £4,707 | £4,321 | £4,321 | £4,321 | £4,321 | £5,089 | £5,295 | £5,089 | £4,719 | £4,770 | £4,770 | |
| 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 | £17,512 | £19,805 | £19,535 | £23,044 | £24,017 | £25,510 | £27,803 | £40,861 | £42,802 | £36,630 | £36,750 | £38,880 | |
| Direct Cost of Sales | £2,226 | £2,371 | £2,366 | £2,760 | £2,799 | £3,075 | £3,315 | £4,852 | £5,116 | £4,232 | £4,221 | £4,538 | |
| Other Costs of Sales | £15 | £13 | £15 | £16 | £16 | £16 | £19 | £22 | £22 | £13 | £15 | £14 | |
| Total Cost of Sales | £2,241 | £2,384 | £2,381 | £2,776 | £2,815 | £3,091 | £3,334 | £4,874 | £5,138 | £4,245 | £4,236 | £4,552 | |
| Gross Margin | £15,271 | £17,421 | £17,154 | £20,268 | £21,202 | £22,419 | £24,469 | £35,987 | £37,664 | £32,385 | £32,514 | £34,328 | |
| Gross Margin % | 87.21% | 87.96% | 87.81% | 87.95% | 88.28% | 87.88% | 88.01% | 88.07% | 88.00% | 88.41% | 88.47% | 88.29% | |
| Expenses | |||||||||||||
| Payroll | £4,321 | £4,707 | £4,321 | £4,321 | £4,321 | £4,321 | £5,089 | £5,295 | £5,089 | £4,719 | £4,770 | £4,770 | |
| Sales & Marketing & Other Expenses | £9,015 | £10,748 | £9,982 | £10,260 | £10,315 | £10,415 | £12,418 | £18,015 | £16,615 | £13,290 | £11,975 | £12,965 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £43 | £43 | £43 | £43 | £43 | £43 | £43 | £43 | £43 | £43 | £43 | £43 | |
| Insurance | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | £22 | |
| Rent | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | |
| Payroll Taxes | 12% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £13,521 | £15,640 | £14,488 | £14,766 | £14,821 | £14,921 | £17,692 | £23,495 | £21,889 | £18,194 | £16,930 | £17,920 | |
| Profit Before Interest and Taxes | £1,750 | £1,781 | £2,666 | £5,502 | £6,381 | £7,498 | £6,777 | £12,492 | £15,775 | £14,191 | £15,584 | £16,408 | |
| EBITDA | £1,750 | £1,781 | £2,666 | £5,502 | £6,381 | £7,498 | £6,777 | £12,492 | £15,775 | £14,191 | £15,584 | £16,408 | |
| Interest Expense | £17 | £50 | £47 | £44 | £41 | £38 | £35 | £33 | £30 | £27 | £24 | £21 | |
| Taxes Incurred | £416 | £415 | £629 | £1,310 | £1,521 | £1,790 | £1,618 | £2,990 | £3,779 | £3,399 | £3,734 | £3,933 | |
| Net Profit | £1,318 | £1,315 | £1,990 | £4,148 | £4,818 | £5,669 | £5,123 | £9,469 | £11,966 | £10,765 | £11,826 | £12,454 | |
| Net Profit/Sales | 7.52% | 6.64% | 10.19% | 18.00% | 20.06% | 22.22% | 18.43% | 23.17% | 27.96% | 29.39% | 32.18% | 32.03% | |
| 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 | £7,005 | £7,922 | £7,814 | £9,218 | £9,607 | £10,204 | £11,121 | £16,344 | £17,121 | £14,652 | £14,700 | £15,552 | |
| Cash from Receivables | £0 | £5,604 | £11,241 | £11,797 | £12,844 | £14,138 | £14,888 | £16,040 | £20,860 | £25,138 | £23,706 | £22,016 | |
| Subtotal Cash from Operations | £7,005 | £13,526 | £19,055 | £21,014 | £22,451 | £24,342 | £26,009 | £32,384 | £37,981 | £39,790 | £38,406 | £37,568 | |
| 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 | £4,000 | £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 | £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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £7,005 | £17,526 | £19,055 | £21,014 | £22,451 | £24,342 | £26,009 | £32,384 | £37,981 | £39,790 | £38,406 | £37,568 | |
| 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 | £4,321 | £4,707 | £4,321 | £4,321 | £4,321 | £4,321 | £5,089 | £5,295 | £5,089 | £4,719 | £4,770 | £4,770 | |
| Bill Payments | £477 | £14,309 | £13,919 | £13,277 | £15,006 | £14,951 | £15,891 | £18,185 | £27,728 | £25,842 | £20,173 | £20,204 | |
| Subtotal Spent on Operations | £4,798 | £19,016 | £18,240 | £17,598 | £19,327 | £19,272 | £20,980 | £23,480 | £32,817 | £30,561 | £24,943 | £24,974 | |
| 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 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| 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 | £4,798 | £19,016 | £18,590 | £17,948 | £19,677 | £19,622 | £21,330 | £23,830 | £33,167 | £30,911 | £25,293 | £25,324 | |
| Net Cash Flow | £2,206 | (£1,490) | £465 | £3,066 | £2,773 | £4,720 | £4,679 | £8,554 | £4,814 | £8,879 | £13,113 | £12,245 | |
| Cash Balance | £4,506 | £3,016 | £3,481 | £6,547 | £9,321 | £14,041 | £18,719 | £27,273 | £32,087 | £40,966 | £54,079 | £66,323 | |
| 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 | £2,300 | £4,506 | £3,016 | £3,481 | £6,547 | £9,321 | £14,041 | £18,719 | £27,273 | £32,087 | £40,966 | £54,079 | £66,323 |
| Accounts Receivable | £0 | £10,507 | £16,786 | £17,266 | £19,296 | £20,863 | £22,031 | £23,825 | £32,301 | £37,122 | £33,963 | £32,306 | £33,618 |
| Inventory | £0 | £2,448 | £2,609 | £2,602 | £3,037 | £3,079 | £3,383 | £3,647 | £5,337 | £5,628 | £4,655 | £4,643 | £4,991 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £2,300 | £17,462 | £22,411 | £23,350 | £28,880 | £33,262 | £39,454 | £46,191 | £64,911 | £74,837 | £79,584 | £91,028 | £104,933 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £2,300 | £17,462 | £22,411 | £23,350 | £28,880 | £33,262 | £39,454 | £46,191 | £64,911 | £74,837 | £79,584 | £91,028 | £104,933 |
| 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 | £13,844 | £13,478 | £12,777 | £14,509 | £14,423 | £15,296 | £17,259 | £26,860 | £25,169 | £19,502 | £19,470 | £21,270 |
| Current Borrowing | £2,000 | £2,000 | £6,000 | £5,650 | £5,300 | £4,950 | £4,600 | £4,250 | £3,900 | £3,550 | £3,200 | £2,850 | £2,500 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £2,000 | £15,844 | £19,478 | £18,427 | £19,809 | £19,373 | £19,896 | £21,509 | £30,760 | £28,719 | £22,702 | £22,320 | £23,770 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £2,000 | £15,844 | £19,478 | £18,427 | £19,809 | £19,373 | £19,896 | £21,509 | £30,760 | £28,719 | £22,702 | £22,320 | £23,770 |
| Paid-in Capital | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 | £3,665 |
| Retained Earnings | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) | (£3,365) |
| Earnings | £0 | £1,318 | £2,633 | £4,623 | £8,771 | £13,589 | £19,258 | £24,381 | £33,851 | £45,817 | £56,582 | £68,408 | £80,862 |
| Total Capital | £300 | £1,618 | £2,933 | £4,923 | £9,071 | £13,889 | £19,558 | £24,681 | £34,151 | £46,117 | £56,882 | £68,708 | £81,162 |
| Total Liabilities and Capital | £2,300 | £17,462 | £22,411 | £23,350 | £28,880 | £33,262 | £39,454 | £46,191 | £64,911 | £74,837 | £79,584 | £91,028 | £104,933 |
| Net Worth | £300 | £1,618 | £2,933 | £4,923 | £9,071 | £13,889 | £19,558 | £24,681 | £34,151 | £46,117 | £56,882 | £68,708 | £81,162 |