| 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 | |||||||||||||
| Security Guards | £6,000 | £10,800 | £19,440 | £34,992 | £55,987 | £78,382 | £94,058 | £96,880 | £99,787 | £102,780 | £105,864 | £109,040 | |
| Security Audits | £500 | £700 | £980 | £1,372 | £1,921 | £2,689 | £3,765 | £5,271 | £7,379 | £10,331 | £14,463 | £20,248 | |
| Commissions | £0 | £500 | £700 | £980 | £1,372 | £1,921 | £2,689 | £3,765 | £5,271 | £7,379 | £10,331 | £14,463 | |
| Total Sales | £6,500 | £12,000 | £21,120 | £37,344 | £59,280 | £82,992 | £100,513 | £105,916 | £112,436 | £120,490 | £130,657 | £143,750 | |
| 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 | |
| Job Supplies | £300 | £540 | £972 | £1,750 | £2,799 | £3,919 | £4,703 | £4,844 | £4,989 | £5,139 | £5,293 | £5,452 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £300 | £540 | £972 | £1,750 | £2,799 | £3,919 | £4,703 | £4,844 | £4,989 | £5,139 | £5,293 | £5,452 | |
| 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 | ||
| Chindit Batten | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Viipuri Hatchez | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Administrative/Call Center Assistants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| 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 | £6,500 | £12,000 | £21,120 | £37,344 | £59,280 | £82,992 | £100,513 | £105,916 | £112,436 | £120,490 | £130,657 | £143,750 | |
| Direct Cost of Sales | £300 | £540 | £972 | £1,750 | £2,799 | £3,919 | £4,703 | £4,844 | £4,989 | £5,139 | £5,293 | £5,452 | |
| Security Guard Labor | £3,575 | £6,600 | £11,616 | £20,539 | £32,604 | £45,646 | £55,282 | £58,254 | £61,840 | £66,270 | £71,861 | £79,063 | |
| Total Cost of Sales | £3,875 | £7,140 | £12,588 | £22,289 | £35,403 | £49,565 | £59,985 | £63,098 | £66,829 | £71,409 | £77,155 | £84,515 | |
| Gross Margin | £2,625 | £4,860 | £8,532 | £15,055 | £23,877 | £33,427 | £40,528 | £42,818 | £45,607 | £49,082 | £53,503 | £59,236 | |
| Gross Margin % | 40.38% | 40.50% | 40.40% | 40.31% | 40.28% | 40.28% | 40.32% | 40.43% | 40.56% | 40.73% | 40.95% | 41.21% | |
| Expenses | |||||||||||||
| Payroll | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Marketing/Promotion | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £2,000 | £2,000 | £2,000 | |
| Depreciation | £28 | £34 | £39 | £45 | £50 | £56 | £61 | £67 | £72 | £78 | £84 | £89 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Surety Bond | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Payroll Taxes | 15% | £1,136 | £1,590 | £2,342 | £3,681 | £5,491 | £7,447 | £9,492 | £9,938 | £10,476 | £11,140 | £11,979 | £13,059 |
| Employee Benefits | 10% | £758 | £1,060 | £1,562 | £2,454 | £3,660 | £4,965 | £6,328 | £6,625 | £6,984 | £7,427 | £7,986 | £8,706 |
| Training | 15% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Licenses and Permits | £500 | £600 | £700 | £700 | £800 | £800 | £900 | £900 | £1,000 | £1,000 | £1,000 | £8,000 | |
| Total Operating Expenses | £10,422 | £11,284 | £12,643 | £14,879 | £18,001 | £21,267 | £28,782 | £29,530 | £30,532 | £30,645 | £32,049 | £40,855 | |
| Profit Before Interest and Taxes | (£7,797) | (£6,424) | (£4,111) | £176 | £5,875 | £12,160 | £11,746 | £13,288 | £15,075 | £18,436 | £21,454 | £18,381 | |
| EBITDA | (£7,769) | (£6,390) | (£4,072) | £220 | £5,926 | £12,216 | £11,807 | £13,355 | £15,147 | £18,514 | £21,537 | £18,470 | |
| Interest Expense | £60 | £58 | £55 | £53 | £50 | £48 | £45 | £43 | £40 | £38 | £35 | £33 | |
| Taxes Incurred | (£2,357) | (£1,944) | (£1,250) | £37 | £1,748 | £3,634 | £3,510 | £3,974 | £4,510 | £5,520 | £6,426 | £5,505 | |
| Net Profit | (£5,500) | (£4,537) | (£2,916) | £86 | £4,078 | £8,479 | £8,191 | £9,272 | £10,524 | £12,879 | £14,993 | £12,844 | |
| Net Profit/Sales | -84.61% | -37.81% | -13.81% | 0.23% | 6.88% | 10.22% | 8.15% | 8.75% | 9.36% | 10.69% | 11.48% | 8.93% | |
| 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 | £1,950 | £3,600 | £6,336 | £11,203 | £17,784 | £24,898 | £30,154 | £31,775 | £33,731 | £36,147 | £39,197 | £43,125 | |
| Cash from Receivables | £0 | £2,427 | £6,603 | £11,805 | £20,841 | £34,330 | £50,349 | £64,635 | £72,376 | £76,575 | £81,712 | £88,139 | |
| Subtotal Cash from Operations | £1,950 | £6,027 | £12,939 | £23,008 | £38,625 | £59,228 | £80,502 | £96,410 | £106,107 | £112,723 | £120,909 | £131,264 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 7.00% | £455 | £840 | £1,478 | £2,614 | £4,150 | £5,809 | £7,036 | £7,414 | £7,871 | £8,434 | £9,146 | £10,063 |
| 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 | £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 | £2,405 | £6,867 | £14,418 | £25,622 | £42,775 | £65,037 | £87,538 | £103,824 | £113,978 | £121,157 | £130,055 | £141,326 | |
| 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,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Bill Payments | £266 | £8,123 | £12,753 | £20,438 | £33,811 | £51,796 | £70,917 | £84,405 | £88,753 | £94,029 | £99,801 | £108,088 | |
| Subtotal Spent on Operations | £4,266 | £12,123 | £16,753 | £24,438 | £37,811 | £55,796 | £78,917 | £92,405 | £96,753 | £102,029 | £107,801 | £116,088 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £455 | £840 | £1,478 | £2,614 | £4,150 | £5,809 | £7,036 | £7,414 | £7,871 | £8,434 | £9,146 | £10,063 | |
| Principal Repayment of Current Borrowing | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| 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 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £5,121 | £13,363 | £18,631 | £27,452 | £42,361 | £62,005 | £86,353 | £100,219 | £105,023 | £110,864 | £117,347 | £126,551 | |
| Net Cash Flow | (£2,716) | (£6,496) | (£4,214) | (£1,830) | £414 | £3,032 | £1,185 | £3,606 | £8,954 | £10,293 | £12,708 | £14,775 | |
| Cash Balance | £37,284 | £30,788 | £26,575 | £24,745 | £25,159 | £28,191 | £29,376 | £32,982 | £41,936 | £52,229 | £64,937 | £79,712 | |
| 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 | £40,000 | £37,284 | £30,788 | £26,575 | £24,745 | £25,159 | £28,191 | £29,376 | £32,982 | £41,936 | £52,229 | £64,937 | £79,712 |
| Accounts Receivable | £0 | £4,550 | £10,523 | £18,704 | £33,040 | £53,695 | £77,459 | £97,470 | £106,975 | £113,305 | £121,072 | £130,820 | £143,307 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £40,000 | £41,834 | £41,312 | £45,279 | £57,785 | £78,854 | £105,650 | £126,845 | £139,957 | £155,240 | £173,301 | £195,757 | £223,019 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,000 | £1,200 | £1,400 | £1,600 | £1,800 | £2,000 | £2,200 | £2,400 | £2,600 | £2,800 | £3,000 | £3,200 | £3,400 |
| Accumulated Depreciation | £0 | £28 | £62 | £101 | £145 | £196 | £251 | £313 | £380 | £452 | £530 | £614 | £703 |
| Total Long-term Assets | £1,000 | £1,172 | £1,338 | £1,499 | £1,655 | £1,804 | £1,949 | £2,087 | £2,220 | £2,348 | £2,470 | £2,586 | £2,697 |
| Total Assets | £41,000 | £43,006 | £42,650 | £46,778 | £59,439 | £80,658 | £107,599 | £128,933 | £142,177 | £157,588 | £175,771 | £198,343 | £225,716 |
| 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,706 | £12,086 | £19,331 | £32,106 | £49,447 | £68,109 | £81,452 | £85,625 | £90,712 | £96,215 | £103,995 | £118,723 |
| Current Borrowing | £5,000 | £4,800 | £4,600 | £4,400 | £4,200 | £4,000 | £3,800 | £3,600 | £3,400 | £3,200 | £3,000 | £2,800 | £2,600 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £5,000 | £12,506 | £16,686 | £23,731 | £36,306 | £53,447 | £71,909 | £85,052 | £89,025 | £93,912 | £99,215 | £106,795 | £121,323 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £5,000 | £12,506 | £16,686 | £23,731 | £36,306 | £53,447 | £71,909 | £85,052 | £89,025 | £93,912 | £99,215 | £106,795 | £121,323 |
| Paid-in Capital | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 |
| Retained Earnings | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) |
| Earnings | £0 | (£5,500) | (£10,036) | (£12,953) | (£12,866) | (£8,789) | (£310) | £7,881 | £17,153 | £27,677 | £40,556 | £55,549 | £68,393 |
| Total Capital | £36,000 | £30,500 | £25,964 | £23,047 | £23,134 | £27,211 | £35,690 | £43,881 | £53,153 | £63,677 | £76,556 | £91,549 | £104,393 |
| Total Liabilities and Capital | £41,000 | £43,006 | £42,650 | £46,778 | £59,439 | £80,658 | £107,599 | £128,933 | £142,177 | £157,588 | £175,771 | £198,343 | £225,716 |
| Net Worth | £36,000 | £30,500 | £25,964 | £23,047 | £23,134 | £27,211 | £35,690 | £43,881 | £53,153 | £63,677 | £76,556 | £91,549 | £104,393 |
| 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 | |||||||||||||
| Security Guards | £6,000 | £10,800 | £19,440 | £34,992 | £55,987 | £78,382 | £94,058 | £96,880 | £99,787 | £102,780 | £105,864 | £109,040 | |
| Security Audits | £500 | £700 | £980 | £1,372 | £1,921 | £2,689 | £3,765 | £5,271 | £7,379 | £10,331 | £14,463 | £20,248 | |
| Commissions | £0 | £500 | £700 | £980 | £1,372 | £1,921 | £2,689 | £3,765 | £5,271 | £7,379 | £10,331 | £14,463 | |
| Total Sales | £6,500 | £12,000 | £21,120 | £37,344 | £59,280 | £82,992 | £100,513 | £105,916 | £112,436 | £120,490 | £130,657 | £143,750 | |
| 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 | |
| Job Supplies | £300 | £540 | £972 | £1,750 | £2,799 | £3,919 | £4,703 | £4,844 | £4,989 | £5,139 | £5,293 | £5,452 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £300 | £540 | £972 | £1,750 | £2,799 | £3,919 | £4,703 | £4,844 | £4,989 | £5,139 | £5,293 | £5,452 | |
| 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 | ||
| Chindit Batten | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Viipuri Hatchez | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Administrative/Call Center Assistants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| 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 | £6,500 | £12,000 | £21,120 | £37,344 | £59,280 | £82,992 | £100,513 | £105,916 | £112,436 | £120,490 | £130,657 | £143,750 | |
| Direct Cost of Sales | £300 | £540 | £972 | £1,750 | £2,799 | £3,919 | £4,703 | £4,844 | £4,989 | £5,139 | £5,293 | £5,452 | |
| Security Guard Labor | £3,575 | £6,600 | £11,616 | £20,539 | £32,604 | £45,646 | £55,282 | £58,254 | £61,840 | £66,270 | £71,861 | £79,063 | |
| Total Cost of Sales | £3,875 | £7,140 | £12,588 | £22,289 | £35,403 | £49,565 | £59,985 | £63,098 | £66,829 | £71,409 | £77,155 | £84,515 | |
| Gross Margin | £2,625 | £4,860 | £8,532 | £15,055 | £23,877 | £33,427 | £40,528 | £42,818 | £45,607 | £49,082 | £53,503 | £59,236 | |
| Gross Margin % | 40.38% | 40.50% | 40.40% | 40.31% | 40.28% | 40.28% | 40.32% | 40.43% | 40.56% | 40.73% | 40.95% | 41.21% | |
| Expenses | |||||||||||||
| Payroll | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Marketing/Promotion | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £2,000 | £2,000 | £2,000 | |
| Depreciation | £28 | £34 | £39 | £45 | £50 | £56 | £61 | £67 | £72 | £78 | £84 | £89 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Surety Bond | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Payroll Taxes | 15% | £1,136 | £1,590 | £2,342 | £3,681 | £5,491 | £7,447 | £9,492 | £9,938 | £10,476 | £11,140 | £11,979 | £13,059 |
| Employee Benefits | 10% | £758 | £1,060 | £1,562 | £2,454 | £3,660 | £4,965 | £6,328 | £6,625 | £6,984 | £7,427 | £7,986 | £8,706 |
| Training | 15% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Licenses and Permits | £500 | £600 | £700 | £700 | £800 | £800 | £900 | £900 | £1,000 | £1,000 | £1,000 | £8,000 | |
| Total Operating Expenses | £10,422 | £11,284 | £12,643 | £14,879 | £18,001 | £21,267 | £28,782 | £29,530 | £30,532 | £30,645 | £32,049 | £40,855 | |
| Profit Before Interest and Taxes | (£7,797) | (£6,424) | (£4,111) | £176 | £5,875 | £12,160 | £11,746 | £13,288 | £15,075 | £18,436 | £21,454 | £18,381 | |
| EBITDA | (£7,769) | (£6,390) | (£4,072) | £220 | £5,926 | £12,216 | £11,807 | £13,355 | £15,147 | £18,514 | £21,537 | £18,470 | |
| Interest Expense | £60 | £58 | £55 | £53 | £50 | £48 | £45 | £43 | £40 | £38 | £35 | £33 | |
| Taxes Incurred | (£2,357) | (£1,944) | (£1,250) | £37 | £1,748 | £3,634 | £3,510 | £3,974 | £4,510 | £5,520 | £6,426 | £5,505 | |
| Net Profit | (£5,500) | (£4,537) | (£2,916) | £86 | £4,078 | £8,479 | £8,191 | £9,272 | £10,524 | £12,879 | £14,993 | £12,844 | |
| Net Profit/Sales | -84.61% | -37.81% | -13.81% | 0.23% | 6.88% | 10.22% | 8.15% | 8.75% | 9.36% | 10.69% | 11.48% | 8.93% | |
| 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 | £1,950 | £3,600 | £6,336 | £11,203 | £17,784 | £24,898 | £30,154 | £31,775 | £33,731 | £36,147 | £39,197 | £43,125 | |
| Cash from Receivables | £0 | £2,427 | £6,603 | £11,805 | £20,841 | £34,330 | £50,349 | £64,635 | £72,376 | £76,575 | £81,712 | £88,139 | |
| Subtotal Cash from Operations | £1,950 | £6,027 | £12,939 | £23,008 | £38,625 | £59,228 | £80,502 | £96,410 | £106,107 | £112,723 | £120,909 | £131,264 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 7.00% | £455 | £840 | £1,478 | £2,614 | £4,150 | £5,809 | £7,036 | £7,414 | £7,871 | £8,434 | £9,146 | £10,063 |
| 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 | £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 | £2,405 | £6,867 | £14,418 | £25,622 | £42,775 | £65,037 | £87,538 | £103,824 | £113,978 | £121,157 | £130,055 | £141,326 | |
| 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,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Bill Payments | £266 | £8,123 | £12,753 | £20,438 | £33,811 | £51,796 | £70,917 | £84,405 | £88,753 | £94,029 | £99,801 | £108,088 | |
| Subtotal Spent on Operations | £4,266 | £12,123 | £16,753 | £24,438 | £37,811 | £55,796 | £78,917 | £92,405 | £96,753 | £102,029 | £107,801 | £116,088 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £455 | £840 | £1,478 | £2,614 | £4,150 | £5,809 | £7,036 | £7,414 | £7,871 | £8,434 | £9,146 | £10,063 | |
| Principal Repayment of Current Borrowing | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| 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 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £5,121 | £13,363 | £18,631 | £27,452 | £42,361 | £62,005 | £86,353 | £100,219 | £105,023 | £110,864 | £117,347 | £126,551 | |
| Net Cash Flow | (£2,716) | (£6,496) | (£4,214) | (£1,830) | £414 | £3,032 | £1,185 | £3,606 | £8,954 | £10,293 | £12,708 | £14,775 | |
| Cash Balance | £37,284 | £30,788 | £26,575 | £24,745 | £25,159 | £28,191 | £29,376 | £32,982 | £41,936 | £52,229 | £64,937 | £79,712 | |
| 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 | £40,000 | £37,284 | £30,788 | £26,575 | £24,745 | £25,159 | £28,191 | £29,376 | £32,982 | £41,936 | £52,229 | £64,937 | £79,712 |
| Accounts Receivable | £0 | £4,550 | £10,523 | £18,704 | £33,040 | £53,695 | £77,459 | £97,470 | £106,975 | £113,305 | £121,072 | £130,820 | £143,307 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £40,000 | £41,834 | £41,312 | £45,279 | £57,785 | £78,854 | £105,650 | £126,845 | £139,957 | £155,240 | £173,301 | £195,757 | £223,019 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,000 | £1,200 | £1,400 | £1,600 | £1,800 | £2,000 | £2,200 | £2,400 | £2,600 | £2,800 | £3,000 | £3,200 | £3,400 |
| Accumulated Depreciation | £0 | £28 | £62 | £101 | £145 | £196 | £251 | £313 | £380 | £452 | £530 | £614 | £703 |
| Total Long-term Assets | £1,000 | £1,172 | £1,338 | £1,499 | £1,655 | £1,804 | £1,949 | £2,087 | £2,220 | £2,348 | £2,470 | £2,586 | £2,697 |
| Total Assets | £41,000 | £43,006 | £42,650 | £46,778 | £59,439 | £80,658 | £107,599 | £128,933 | £142,177 | £157,588 | £175,771 | £198,343 | £225,716 |
| 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,706 | £12,086 | £19,331 | £32,106 | £49,447 | £68,109 | £81,452 | £85,625 | £90,712 | £96,215 | £103,995 | £118,723 |
| Current Borrowing | £5,000 | £4,800 | £4,600 | £4,400 | £4,200 | £4,000 | £3,800 | £3,600 | £3,400 | £3,200 | £3,000 | £2,800 | £2,600 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £5,000 | £12,506 | £16,686 | £23,731 | £36,306 | £53,447 | £71,909 | £85,052 | £89,025 | £93,912 | £99,215 | £106,795 | £121,323 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £5,000 | £12,506 | £16,686 | £23,731 | £36,306 | £53,447 | £71,909 | £85,052 | £89,025 | £93,912 | £99,215 | £106,795 | £121,323 |
| Paid-in Capital | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 | £72,700 |
| Retained Earnings | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) | (£36,700) |
| Earnings | £0 | (£5,500) | (£10,036) | (£12,953) | (£12,866) | (£8,789) | (£310) | £7,881 | £17,153 | £27,677 | £40,556 | £55,549 | £68,393 |
| Total Capital | £36,000 | £30,500 | £25,964 | £23,047 | £23,134 | £27,211 | £35,690 | £43,881 | £53,153 | £63,677 | £76,556 | £91,549 | £104,393 |
| Total Liabilities and Capital | £41,000 | £43,006 | £42,650 | £46,778 | £59,439 | £80,658 | £107,599 | £128,933 | £142,177 | £157,588 | £175,771 | £198,343 | £225,716 |
| Net Worth | £36,000 | £30,500 | £25,964 | £23,047 | £23,134 | £27,211 | £35,690 | £43,881 | £53,153 | £63,677 | £76,556 | £91,549 | £104,393 |