| Funding 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 | ||
| Funding | |||||||||||||
| Additional Fees | 0% | £270 | £310 | £357 | £410 | £472 | £543 | £624 | £718 | £825 | £949 | £1,091 | £1,255 |
| Retainer | 0% | £995 | £1,243 | £1,554 | £1,943 | £2,428 | £3,035 | £3,794 | £4,743 | £5,928 | £7,410 | £9,263 | £11,579 |
| SBA Loan Gaurantees | 0% | £108 | £135 | £168 | £211 | £263 | £329 | £411 | £514 | £643 | £803 | £1,004 | £1,255 |
| SBA Grant 1% | 0% | £162 | £170 | £179 | £188 | £197 | £207 | £217 | £228 | £240 | £252 | £264 | £278 |
| Other Loan and Grant 1% | 0% | £477 | £548 | £631 | £725 | £834 | £959 | £1,103 | £1,268 | £1,459 | £1,677 | £1,929 | £2,218 |
| Books and Resources | 0% | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 |
| Grants and Donations | 0% | £3,978 | £4,773 | £5,728 | £6,873 | £8,248 | £9,898 | £11,877 | £14,252 | £17,103 | £20,524 | £24,628 | £29,554 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Funding | £6,239 | £7,430 | £8,867 | £10,600 | £12,692 | £15,221 | £18,277 | £21,973 | £26,447 | £31,865 | £38,430 | £46,389 | |
| Direct Cost of Funding | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| COGS | £135 | £142 | £149 | £156 | £164 | £172 | £181 | £190 | £199 | £209 | £220 | £231 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cost of Funding | £135 | £142 | £149 | £156 | £164 | £172 | £181 | £190 | £199 | £209 | £220 | £231 | |
| 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 | ||
| Intern | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Bill Franklin | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Second Consultant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £4,000 | £4,000 | £4,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £9,500 | £9,500 | £9,500 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Surplus and Deficit | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Funding | £6,239 | £7,430 | £8,867 | £10,600 | £12,692 | £15,221 | £18,277 | £21,973 | £26,447 | £31,865 | £38,430 | £46,389 | |
| Direct Cost | £135 | £142 | £149 | £156 | £164 | £172 | £181 | £190 | £199 | £209 | £220 | £231 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Direct Cost | £135 | £142 | £149 | £156 | £164 | £172 | £181 | £190 | £199 | £209 | £220 | £231 | |
| Gross Surplus | £6,104 | £7,289 | £8,718 | £10,444 | £12,529 | £15,049 | £18,096 | £21,784 | £26,248 | £31,656 | £38,210 | £46,158 | |
| Gross Surplus % | 97.84% | 98.10% | 98.32% | 98.53% | 98.71% | 98.87% | 99.01% | 99.14% | 99.25% | 99.34% | 99.43% | 99.50% | |
| Expenses | |||||||||||||
| Payroll | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £9,500 | £9,500 | £9,500 | |
| Sales and Marketing and Other Expenses | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Depreciation | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Rent | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | |
| Auto Lease/ Fuel | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 10% | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £950 | £950 | £950 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £8,170 | £8,170 | £8,170 | £8,170 | £8,170 | £8,170 | £8,170 | £8,170 | £8,170 | £12,570 | £12,570 | £12,570 | |
| Surplus Before Interest and Taxes | (£2,066) | (£881) | £548 | £2,274 | £4,359 | £6,879 | £9,926 | £13,614 | £18,078 | £19,086 | £25,640 | £33,588 | |
| EBITDA | (£1,766) | (£581) | £848 | £2,574 | £4,659 | £7,179 | £10,226 | £13,914 | £18,378 | £19,386 | £25,940 | £33,888 | |
| Interest Expense | £63 | £83 | £104 | £104 | £104 | £104 | £104 | £83 | £63 | £42 | £21 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Surplus | (£2,128) | (£965) | £444 | £2,170 | £4,254 | £6,774 | £9,822 | £13,530 | £18,016 | £19,044 | £25,619 | £33,588 | |
| Net Surplus/Funding | -34.12% | -12.98% | 5.00% | 20.47% | 33.52% | 44.51% | 53.74% | 61.58% | 68.12% | 59.77% | 66.67% | 72.41% | |
| 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 Funding | £3,431 | £4,087 | £4,877 | £5,830 | £6,981 | £8,371 | £10,052 | £12,085 | £14,546 | £17,526 | £21,136 | £25,514 | |
| Cash from Receivables | £0 | £94 | £2,825 | £3,365 | £4,016 | £4,801 | £5,750 | £6,895 | £8,280 | £9,955 | £11,983 | £14,438 | |
| Subtotal Cash from Operations | £3,431 | £4,180 | £7,702 | £9,195 | £10,997 | £13,173 | £15,802 | £18,980 | £22,826 | £27,481 | £33,119 | £39,952 | |
| 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 | £5,000 | £5,000 | £5,000 | £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 | £8,431 | £9,180 | £12,702 | £9,195 | £10,997 | £13,173 | £15,802 | £18,980 | £22,826 | £27,481 | £33,119 | £39,952 | |
| 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 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £9,500 | £9,500 | £9,500 | |
| Bill Payments | £114 | £3,400 | £2,454 | £2,474 | £2,474 | £2,508 | £3,441 | £2,473 | £2,453 | £2,445 | £2,844 | £3,757 | |
| Subtotal Spent on Operations | £5,614 | £8,900 | £7,954 | £7,974 | £7,974 | £8,008 | £8,941 | £7,973 | £7,953 | £11,945 | £12,344 | £13,257 | |
| 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 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| 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 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £5,614 | £8,900 | £7,954 | £7,974 | £17,974 | £8,008 | £8,941 | £12,973 | £12,953 | £16,945 | £17,344 | £28,257 | |
| Net Cash Flow | £2,817 | £280 | £4,748 | £1,221 | (£6,977) | £5,165 | £6,861 | £6,007 | £9,873 | £10,536 | £15,775 | £11,695 | |
| Cash Balance | £18,767 | £19,047 | £23,795 | £25,016 | £18,039 | £23,204 | £30,065 | £36,072 | £45,945 | £56,481 | £72,256 | £83,950 | |
| 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 | £15,950 | £18,767 | £19,047 | £23,795 | £25,016 | £18,039 | £23,204 | £30,065 | £36,072 | £45,945 | £56,481 | £72,256 | £83,950 |
| Accounts Receivable | £0 | £2,807 | £6,057 | £7,222 | £8,627 | £10,322 | £12,370 | £14,845 | £17,838 | £21,460 | £25,844 | £31,155 | £37,592 |
| Inventory | £0 | £865 | £724 | £575 | £419 | £255 | £1,083 | £902 | £713 | £514 | £305 | £1,085 | £854 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £15,950 | £22,440 | £25,828 | £31,592 | £34,062 | £28,616 | £36,657 | £45,812 | £54,623 | £67,918 | £82,629 | £104,495 | £122,396 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £30,000 |
| Accumulated Depreciation | £0 | £300 | £600 | £900 | £1,200 | £1,500 | £1,800 | £2,100 | £2,400 | £2,700 | £3,000 | £3,300 | £3,600 |
| Total Long-term Assets | £10,000 | £9,700 | £9,400 | £9,100 | £8,800 | £18,500 | £18,200 | £17,900 | £17,600 | £17,300 | £17,000 | £16,700 | £26,400 |
| Total Assets | £25,950 | £32,140 | £35,228 | £40,692 | £42,862 | £47,116 | £54,857 | £63,712 | £72,223 | £85,218 | £99,629 | £121,195 | £148,796 |
| 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 | £3,318 | £2,372 | £2,392 | £2,392 | £2,392 | £3,358 | £2,392 | £2,372 | £2,351 | £2,718 | £3,664 | £2,678 |
| Current Borrowing | £10,000 | £15,000 | £20,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £20,000 | £15,000 | £10,000 | £5,000 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £10,000 | £18,318 | £22,372 | £27,392 | £27,392 | £27,392 | £28,358 | £27,392 | £22,372 | £17,351 | £12,718 | £8,664 | £2,678 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £10,000 | £18,318 | £22,372 | £27,392 | £27,392 | £27,392 | £28,358 | £27,392 | £22,372 | £17,351 | £12,718 | £8,664 | £2,678 |
| Paid-in Capital | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 |
| Accumulated Surplus/Deficit | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) |
| Surplus/Deficit | £0 | (£2,128) | (£3,093) | (£2,649) | (£480) | £3,774 | £10,549 | £20,371 | £33,901 | £51,917 | £70,961 | £96,581 | £130,169 |
| Total Capital | £15,950 | £13,822 | £12,857 | £13,301 | £15,470 | £19,724 | £26,499 | £36,321 | £49,851 | £67,867 | £86,911 | £112,531 | £146,119 |
| Total Liabilities and Capital | £25,950 | £32,140 | £35,228 | £40,692 | £42,862 | £47,116 | £54,857 | £63,712 | £72,223 | £85,218 | £99,629 | £121,195 | £148,796 |
| Net Worth | £15,950 | £13,822 | £12,857 | £13,301 | £15,470 | £19,724 | £26,499 | £36,321 | £49,851 | £67,867 | £86,911 | £112,531 | £146,119 |
| Funding 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 | ||
| Funding | |||||||||||||
| Additional Fees | 0% | £270 | £310 | £357 | £410 | £472 | £543 | £624 | £718 | £825 | £949 | £1,091 | £1,255 |
| Retainer | 0% | £995 | £1,243 | £1,554 | £1,943 | £2,428 | £3,035 | £3,794 | £4,743 | £5,928 | £7,410 | £9,263 | £11,579 |
| SBA Loan Gaurantees | 0% | £108 | £135 | £168 | £211 | £263 | £329 | £411 | £514 | £643 | £803 | £1,004 | £1,255 |
| SBA Grant 1% | 0% | £162 | £170 | £179 | £188 | £197 | £207 | £217 | £228 | £240 | £252 | £264 | £278 |
| Other Loan and Grant 1% | 0% | £477 | £548 | £631 | £725 | £834 | £959 | £1,103 | £1,268 | £1,459 | £1,677 | £1,929 | £2,218 |
| Books and Resources | 0% | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 |
| Grants and Donations | 0% | £3,978 | £4,773 | £5,728 | £6,873 | £8,248 | £9,898 | £11,877 | £14,252 | £17,103 | £20,524 | £24,628 | £29,554 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Funding | £6,239 | £7,430 | £8,867 | £10,600 | £12,692 | £15,221 | £18,277 | £21,973 | £26,447 | £31,865 | £38,430 | £46,389 | |
| Direct Cost of Funding | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| COGS | £135 | £142 | £149 | £156 | £164 | £172 | £181 | £190 | £199 | £209 | £220 | £231 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cost of Funding | £135 | £142 | £149 | £156 | £164 | £172 | £181 | £190 | £199 | £209 | £220 | £231 | |
| 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 | ||
| Intern | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Bill Franklin | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Second Consultant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £4,000 | £4,000 | £4,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £9,500 | £9,500 | £9,500 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Surplus and Deficit | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Funding | £6,239 | £7,430 | £8,867 | £10,600 | £12,692 | £15,221 | £18,277 | £21,973 | £26,447 | £31,865 | £38,430 | £46,389 | |
| Direct Cost | £135 | £142 | £149 | £156 | £164 | £172 | £181 | £190 | £199 | £209 | £220 | £231 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Direct Cost | £135 | £142 | £149 | £156 | £164 | £172 | £181 | £190 | £199 | £209 | £220 | £231 | |
| Gross Surplus | £6,104 | £7,289 | £8,718 | £10,444 | £12,529 | £15,049 | £18,096 | £21,784 | £26,248 | £31,656 | £38,210 | £46,158 | |
| Gross Surplus % | 97.84% | 98.10% | 98.32% | 98.53% | 98.71% | 98.87% | 99.01% | 99.14% | 99.25% | 99.34% | 99.43% | 99.50% | |
| Expenses | |||||||||||||
| Payroll | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £9,500 | £9,500 | £9,500 | |
| Sales and Marketing and Other Expenses | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Depreciation | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Rent | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | |
| Auto Lease/ Fuel | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 10% | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £550 | £950 | £950 | £950 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £8,170 | £8,170 | £8,170 | £8,170 | £8,170 | £8,170 | £8,170 | £8,170 | £8,170 | £12,570 | £12,570 | £12,570 | |
| Surplus Before Interest and Taxes | (£2,066) | (£881) | £548 | £2,274 | £4,359 | £6,879 | £9,926 | £13,614 | £18,078 | £19,086 | £25,640 | £33,588 | |
| EBITDA | (£1,766) | (£581) | £848 | £2,574 | £4,659 | £7,179 | £10,226 | £13,914 | £18,378 | £19,386 | £25,940 | £33,888 | |
| Interest Expense | £63 | £83 | £104 | £104 | £104 | £104 | £104 | £83 | £63 | £42 | £21 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Surplus | (£2,128) | (£965) | £444 | £2,170 | £4,254 | £6,774 | £9,822 | £13,530 | £18,016 | £19,044 | £25,619 | £33,588 | |
| Net Surplus/Funding | -34.12% | -12.98% | 5.00% | 20.47% | 33.52% | 44.51% | 53.74% | 61.58% | 68.12% | 59.77% | 66.67% | 72.41% | |
| 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 Funding | £3,431 | £4,087 | £4,877 | £5,830 | £6,981 | £8,371 | £10,052 | £12,085 | £14,546 | £17,526 | £21,136 | £25,514 | |
| Cash from Receivables | £0 | £94 | £2,825 | £3,365 | £4,016 | £4,801 | £5,750 | £6,895 | £8,280 | £9,955 | £11,983 | £14,438 | |
| Subtotal Cash from Operations | £3,431 | £4,180 | £7,702 | £9,195 | £10,997 | £13,173 | £15,802 | £18,980 | £22,826 | £27,481 | £33,119 | £39,952 | |
| 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 | £5,000 | £5,000 | £5,000 | £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 | £8,431 | £9,180 | £12,702 | £9,195 | £10,997 | £13,173 | £15,802 | £18,980 | £22,826 | £27,481 | £33,119 | £39,952 | |
| 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 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £9,500 | £9,500 | £9,500 | |
| Bill Payments | £114 | £3,400 | £2,454 | £2,474 | £2,474 | £2,508 | £3,441 | £2,473 | £2,453 | £2,445 | £2,844 | £3,757 | |
| Subtotal Spent on Operations | £5,614 | £8,900 | £7,954 | £7,974 | £7,974 | £8,008 | £8,941 | £7,973 | £7,953 | £11,945 | £12,344 | £13,257 | |
| 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 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| 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 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £5,614 | £8,900 | £7,954 | £7,974 | £17,974 | £8,008 | £8,941 | £12,973 | £12,953 | £16,945 | £17,344 | £28,257 | |
| Net Cash Flow | £2,817 | £280 | £4,748 | £1,221 | (£6,977) | £5,165 | £6,861 | £6,007 | £9,873 | £10,536 | £15,775 | £11,695 | |
| Cash Balance | £18,767 | £19,047 | £23,795 | £25,016 | £18,039 | £23,204 | £30,065 | £36,072 | £45,945 | £56,481 | £72,256 | £83,950 | |
| 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 | £15,950 | £18,767 | £19,047 | £23,795 | £25,016 | £18,039 | £23,204 | £30,065 | £36,072 | £45,945 | £56,481 | £72,256 | £83,950 |
| Accounts Receivable | £0 | £2,807 | £6,057 | £7,222 | £8,627 | £10,322 | £12,370 | £14,845 | £17,838 | £21,460 | £25,844 | £31,155 | £37,592 |
| Inventory | £0 | £865 | £724 | £575 | £419 | £255 | £1,083 | £902 | £713 | £514 | £305 | £1,085 | £854 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £15,950 | £22,440 | £25,828 | £31,592 | £34,062 | £28,616 | £36,657 | £45,812 | £54,623 | £67,918 | £82,629 | £104,495 | £122,396 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £30,000 |
| Accumulated Depreciation | £0 | £300 | £600 | £900 | £1,200 | £1,500 | £1,800 | £2,100 | £2,400 | £2,700 | £3,000 | £3,300 | £3,600 |
| Total Long-term Assets | £10,000 | £9,700 | £9,400 | £9,100 | £8,800 | £18,500 | £18,200 | £17,900 | £17,600 | £17,300 | £17,000 | £16,700 | £26,400 |
| Total Assets | £25,950 | £32,140 | £35,228 | £40,692 | £42,862 | £47,116 | £54,857 | £63,712 | £72,223 | £85,218 | £99,629 | £121,195 | £148,796 |
| 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 | £3,318 | £2,372 | £2,392 | £2,392 | £2,392 | £3,358 | £2,392 | £2,372 | £2,351 | £2,718 | £3,664 | £2,678 |
| Current Borrowing | £10,000 | £15,000 | £20,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £20,000 | £15,000 | £10,000 | £5,000 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £10,000 | £18,318 | £22,372 | £27,392 | £27,392 | £27,392 | £28,358 | £27,392 | £22,372 | £17,351 | £12,718 | £8,664 | £2,678 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £10,000 | £18,318 | £22,372 | £27,392 | £27,392 | £27,392 | £28,358 | £27,392 | £22,372 | £17,351 | £12,718 | £8,664 | £2,678 |
| Paid-in Capital | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 |
| Accumulated Surplus/Deficit | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) | (£19,050) |
| Surplus/Deficit | £0 | (£2,128) | (£3,093) | (£2,649) | (£480) | £3,774 | £10,549 | £20,371 | £33,901 | £51,917 | £70,961 | £96,581 | £130,169 |
| Total Capital | £15,950 | £13,822 | £12,857 | £13,301 | £15,470 | £19,724 | £26,499 | £36,321 | £49,851 | £67,867 | £86,911 | £112,531 | £146,119 |
| Total Liabilities and Capital | £25,950 | £32,140 | £35,228 | £40,692 | £42,862 | £47,116 | £54,857 | £63,712 | £72,223 | £85,218 | £99,629 | £121,195 | £148,796 |
| Net Worth | £15,950 | £13,822 | £12,857 | £13,301 | £15,470 | £19,724 | £26,499 | £36,321 | £49,851 | £67,867 | £86,911 | £112,531 | £146,119 |