| 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 | |||||||||||||
| Corporations | 0% | £0 | £2,577 | £3,216 | £3,677 | £4,032 | £4,706 | £5,700 | £7,847 | £7,984 | £7,998 | £8,001 | £8,978 |
| Individuals | 0% | £0 | £180 | £246 | £295 | £341 | £393 | £482 | £534 | £543 | £549 | £671 | £1,100 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £2,757 | £3,462 | £3,972 | £4,373 | £5,099 | £6,182 | £8,381 | £8,527 | £8,547 | £8,672 | £10,078 | |
| 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 | |
| Corporations | £0 | £0 | £0 | £0 | £0 | £0 | £1,325 | £1,325 | £1,490 | £1,656 | £1,822 | £1,987 | |
| Individuals | £0 | £0 | £0 | £0 | £0 | £0 | £147 | £147 | £165 | £184 | £202 | £221 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £1,472 | £1,472 | £1,655 | £1,840 | £2,024 | £2,208 | |
| 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 | ||
| Payroll | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £3,298 | £3,298 | £4,689 | £4,848 | £4,912 | £6,416 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| Total Payroll | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £3,298 | £3,298 | £4,689 | £4,848 | £4,912 | £6,416 | |
| 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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 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 | £0 | £2,757 | £3,462 | £3,972 | £4,373 | £5,099 | £6,182 | £8,381 | £8,527 | £8,547 | £8,672 | £10,078 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £1,472 | £1,472 | £1,655 | £1,840 | £2,024 | £2,208 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £1,472 | £1,472 | £1,655 | £1,840 | £2,024 | £2,208 | |
| Gross Margin | £0 | £2,757 | £3,462 | £3,972 | £4,373 | £5,099 | £4,710 | £6,909 | £6,872 | £6,707 | £6,648 | £7,870 | |
| Gross Margin % | 0.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 76.19% | 82.44% | 80.59% | 78.47% | 76.66% | 78.09% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £3,298 | £3,298 | £4,689 | £4,848 | £4,912 | £6,416 | |
| Sales and Marketing and Other Expenses | £0 | £150 | £150 | £150 | £125 | £375 | £150 | £150 | £150 | £200 | £200 | £200 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £41 | £41 | £41 | £41 | £41 | £41 | £41 | £41 | £41 | £41 | £41 | £41 | |
| Additional payroll burdens- 7.5% | £0 | £0 | £0 | £0 | £110 | £110 | £110 | £371 | £371 | £371 | £371 | £481 | |
| Comunication Equipment | £150 | £175 | £200 | £200 | £200 | £220 | £220 | £220 | £220 | £220 | £220 | £220 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £0 | £0 | £0 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Payroll Taxes | 15% | £300 | £300 | £300 | £300 | £300 | £300 | £495 | £495 | £703 | £727 | £737 | £962 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £2,491 | £2,666 | £2,691 | £2,791 | £2,876 | £3,146 | £4,414 | £4,675 | £6,274 | £6,507 | £6,581 | £8,420 | |
| Profit Before Interest and Taxes | (£2,491) | £91 | £771 | £1,181 | £1,497 | £1,953 | £296 | £2,234 | £598 | £200 | £67 | (£550) | |
| EBITDA | (£2,491) | £91 | £771 | £1,181 | £1,497 | £1,953 | £296 | £2,234 | £598 | £200 | £67 | (£550) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£747) | £23 | £193 | £295 | £374 | £488 | £74 | £559 | £149 | £50 | £17 | (£138) | |
| Net Profit | (£1,744) | £68 | £578 | £886 | £1,123 | £1,465 | £222 | £1,676 | £448 | £150 | £50 | (£413) | |
| Net Profit/Sales | 0.00% | 2.48% | 16.70% | 22.30% | 25.67% | 28.73% | 3.59% | 19.99% | 5.26% | 1.75% | 0.58% | -4.10% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £1,654 | £2,077 | £2,383 | £2,624 | £3,059 | £3,709 | £5,029 | £5,116 | £5,128 | £5,203 | £6,047 | |
| Cash from Receivables | £0 | £0 | £37 | £1,112 | £1,392 | £1,594 | £1,759 | £2,054 | £2,502 | £3,354 | £3,411 | £3,420 | |
| Subtotal Cash from Operations | £0 | £1,654 | £2,114 | £3,495 | £4,015 | £4,654 | £5,468 | £7,083 | £7,618 | £8,483 | £8,614 | £9,467 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £2,000 | £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 | £1,255 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £1,255 | £1,654 | £2,114 | £3,495 | £6,015 | £4,654 | £5,468 | £7,083 | £7,618 | £8,483 | £8,614 | £9,467 | |
| 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 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £3,298 | £3,298 | £4,689 | £4,848 | £4,912 | £6,416 | |
| Bill Payments | (£256) | (£225) | £695 | £891 | £1,092 | £1,263 | £1,669 | £2,687 | £3,407 | £3,395 | £3,554 | £3,722 | |
| Subtotal Spent on Operations | £1,744 | £1,775 | £2,695 | £2,891 | £3,092 | £3,263 | £4,967 | £5,985 | £8,096 | £8,243 | £8,466 | £10,138 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £1,744 | £1,775 | £2,695 | £2,891 | £3,092 | £3,263 | £4,967 | £5,985 | £8,096 | £8,243 | £8,466 | £10,138 | |
| Net Cash Flow | (£489) | (£121) | (£581) | £605 | £2,924 | £1,390 | £502 | £1,098 | (£477) | £239 | £148 | (£671) | |
| Cash Balance | £766 | £645 | £64 | £669 | £3,593 | £4,983 | £5,485 | £6,583 | £6,105 | £6,345 | £6,493 | £5,822 | |
| 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 | £1,255 | £766 | £645 | £64 | £669 | £3,593 | £4,983 | £5,485 | £6,583 | £6,105 | £6,345 | £6,493 | £5,822 |
| Accounts Receivable | £0 | £0 | £1,103 | £2,451 | £2,927 | £3,285 | £3,730 | £4,444 | £5,743 | £6,651 | £6,716 | £6,774 | £7,384 |
| Other Current Assets | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Total Current Assets | £3,755 | £3,266 | £4,248 | £5,015 | £6,096 | £9,378 | £11,214 | £12,429 | £14,825 | £15,257 | £15,561 | £15,766 | £15,706 |
| 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 | £3,755 | £3,266 | £4,248 | £5,015 | £6,096 | £9,378 | £11,214 | £12,429 | £14,825 | £15,257 | £15,561 | £15,766 | £15,706 |
| 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 | £0 | £914 | £1,102 | £1,298 | £1,456 | £1,828 | £2,821 | £3,541 | £3,525 | £3,679 | £3,834 | £4,187 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Subtotal Current Liabilities | £0 | £0 | £914 | £1,102 | £1,298 | £3,456 | £3,828 | £4,821 | £5,541 | £5,525 | £5,679 | £5,834 | £6,187 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £0 | £914 | £1,102 | £1,298 | £3,456 | £3,828 | £4,821 | £5,541 | £5,525 | £5,679 | £5,834 | £6,187 |
| Paid-in Capital | £7,500 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 |
| Retained Earnings | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) |
| Earnings | £0 | (£1,744) | (£1,675) | (£1,097) | (£211) | £911 | £2,376 | £2,598 | £4,274 | £4,722 | £4,872 | £4,922 | £4,510 |
| Total Capital | £3,755 | £3,266 | £3,335 | £3,913 | £4,799 | £5,921 | £7,386 | £7,608 | £9,284 | £9,732 | £9,882 | £9,932 | £9,520 |
| Total Liabilities and Capital | £3,755 | £3,266 | £4,248 | £5,015 | £6,096 | £9,378 | £11,214 | £12,429 | £14,825 | £15,257 | £15,561 | £15,766 | £15,706 |
| Net Worth | £3,755 | £3,266 | £3,335 | £3,913 | £4,799 | £5,921 | £7,386 | £7,608 | £9,284 | £9,732 | £9,882 | £9,932 | £9,520 |
| 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 | |||||||||||||
| Corporations | 0% | £0 | £2,577 | £3,216 | £3,677 | £4,032 | £4,706 | £5,700 | £7,847 | £7,984 | £7,998 | £8,001 | £8,978 |
| Individuals | 0% | £0 | £180 | £246 | £295 | £341 | £393 | £482 | £534 | £543 | £549 | £671 | £1,100 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £2,757 | £3,462 | £3,972 | £4,373 | £5,099 | £6,182 | £8,381 | £8,527 | £8,547 | £8,672 | £10,078 | |
| 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 | |
| Corporations | £0 | £0 | £0 | £0 | £0 | £0 | £1,325 | £1,325 | £1,490 | £1,656 | £1,822 | £1,987 | |
| Individuals | £0 | £0 | £0 | £0 | £0 | £0 | £147 | £147 | £165 | £184 | £202 | £221 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £1,472 | £1,472 | £1,655 | £1,840 | £2,024 | £2,208 | |
| 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 | ||
| Payroll | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £3,298 | £3,298 | £4,689 | £4,848 | £4,912 | £6,416 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| Total Payroll | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £3,298 | £3,298 | £4,689 | £4,848 | £4,912 | £6,416 | |
| 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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 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 | £0 | £2,757 | £3,462 | £3,972 | £4,373 | £5,099 | £6,182 | £8,381 | £8,527 | £8,547 | £8,672 | £10,078 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £1,472 | £1,472 | £1,655 | £1,840 | £2,024 | £2,208 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £1,472 | £1,472 | £1,655 | £1,840 | £2,024 | £2,208 | |
| Gross Margin | £0 | £2,757 | £3,462 | £3,972 | £4,373 | £5,099 | £4,710 | £6,909 | £6,872 | £6,707 | £6,648 | £7,870 | |
| Gross Margin % | 0.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 76.19% | 82.44% | 80.59% | 78.47% | 76.66% | 78.09% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £3,298 | £3,298 | £4,689 | £4,848 | £4,912 | £6,416 | |
| Sales and Marketing and Other Expenses | £0 | £150 | £150 | £150 | £125 | £375 | £150 | £150 | £150 | £200 | £200 | £200 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £41 | £41 | £41 | £41 | £41 | £41 | £41 | £41 | £41 | £41 | £41 | £41 | |
| Additional payroll burdens- 7.5% | £0 | £0 | £0 | £0 | £110 | £110 | £110 | £371 | £371 | £371 | £371 | £481 | |
| Comunication Equipment | £150 | £175 | £200 | £200 | £200 | £220 | £220 | £220 | £220 | £220 | £220 | £220 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £0 | £0 | £0 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Payroll Taxes | 15% | £300 | £300 | £300 | £300 | £300 | £300 | £495 | £495 | £703 | £727 | £737 | £962 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £2,491 | £2,666 | £2,691 | £2,791 | £2,876 | £3,146 | £4,414 | £4,675 | £6,274 | £6,507 | £6,581 | £8,420 | |
| Profit Before Interest and Taxes | (£2,491) | £91 | £771 | £1,181 | £1,497 | £1,953 | £296 | £2,234 | £598 | £200 | £67 | (£550) | |
| EBITDA | (£2,491) | £91 | £771 | £1,181 | £1,497 | £1,953 | £296 | £2,234 | £598 | £200 | £67 | (£550) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£747) | £23 | £193 | £295 | £374 | £488 | £74 | £559 | £149 | £50 | £17 | (£138) | |
| Net Profit | (£1,744) | £68 | £578 | £886 | £1,123 | £1,465 | £222 | £1,676 | £448 | £150 | £50 | (£413) | |
| Net Profit/Sales | 0.00% | 2.48% | 16.70% | 22.30% | 25.67% | 28.73% | 3.59% | 19.99% | 5.26% | 1.75% | 0.58% | -4.10% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £1,654 | £2,077 | £2,383 | £2,624 | £3,059 | £3,709 | £5,029 | £5,116 | £5,128 | £5,203 | £6,047 | |
| Cash from Receivables | £0 | £0 | £37 | £1,112 | £1,392 | £1,594 | £1,759 | £2,054 | £2,502 | £3,354 | £3,411 | £3,420 | |
| Subtotal Cash from Operations | £0 | £1,654 | £2,114 | £3,495 | £4,015 | £4,654 | £5,468 | £7,083 | £7,618 | £8,483 | £8,614 | £9,467 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 0.00% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| New Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £2,000 | £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 | £1,255 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £1,255 | £1,654 | £2,114 | £3,495 | £6,015 | £4,654 | £5,468 | £7,083 | £7,618 | £8,483 | £8,614 | £9,467 | |
| 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 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £3,298 | £3,298 | £4,689 | £4,848 | £4,912 | £6,416 | |
| Bill Payments | (£256) | (£225) | £695 | £891 | £1,092 | £1,263 | £1,669 | £2,687 | £3,407 | £3,395 | £3,554 | £3,722 | |
| Subtotal Spent on Operations | £1,744 | £1,775 | £2,695 | £2,891 | £3,092 | £3,263 | £4,967 | £5,985 | £8,096 | £8,243 | £8,466 | £10,138 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £1,744 | £1,775 | £2,695 | £2,891 | £3,092 | £3,263 | £4,967 | £5,985 | £8,096 | £8,243 | £8,466 | £10,138 | |
| Net Cash Flow | (£489) | (£121) | (£581) | £605 | £2,924 | £1,390 | £502 | £1,098 | (£477) | £239 | £148 | (£671) | |
| Cash Balance | £766 | £645 | £64 | £669 | £3,593 | £4,983 | £5,485 | £6,583 | £6,105 | £6,345 | £6,493 | £5,822 | |
| 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 | £1,255 | £766 | £645 | £64 | £669 | £3,593 | £4,983 | £5,485 | £6,583 | £6,105 | £6,345 | £6,493 | £5,822 |
| Accounts Receivable | £0 | £0 | £1,103 | £2,451 | £2,927 | £3,285 | £3,730 | £4,444 | £5,743 | £6,651 | £6,716 | £6,774 | £7,384 |
| Other Current Assets | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Total Current Assets | £3,755 | £3,266 | £4,248 | £5,015 | £6,096 | £9,378 | £11,214 | £12,429 | £14,825 | £15,257 | £15,561 | £15,766 | £15,706 |
| 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 | £3,755 | £3,266 | £4,248 | £5,015 | £6,096 | £9,378 | £11,214 | £12,429 | £14,825 | £15,257 | £15,561 | £15,766 | £15,706 |
| 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 | £0 | £914 | £1,102 | £1,298 | £1,456 | £1,828 | £2,821 | £3,541 | £3,525 | £3,679 | £3,834 | £4,187 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Subtotal Current Liabilities | £0 | £0 | £914 | £1,102 | £1,298 | £3,456 | £3,828 | £4,821 | £5,541 | £5,525 | £5,679 | £5,834 | £6,187 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £0 | £914 | £1,102 | £1,298 | £3,456 | £3,828 | £4,821 | £5,541 | £5,525 | £5,679 | £5,834 | £6,187 |
| Paid-in Capital | £7,500 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 | £8,755 |
| Retained Earnings | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) | (£3,745) |
| Earnings | £0 | (£1,744) | (£1,675) | (£1,097) | (£211) | £911 | £2,376 | £2,598 | £4,274 | £4,722 | £4,872 | £4,922 | £4,510 |
| Total Capital | £3,755 | £3,266 | £3,335 | £3,913 | £4,799 | £5,921 | £7,386 | £7,608 | £9,284 | £9,732 | £9,882 | £9,932 | £9,520 |
| Total Liabilities and Capital | £3,755 | £3,266 | £4,248 | £5,015 | £6,096 | £9,378 | £11,214 | £12,429 | £14,825 | £15,257 | £15,561 | £15,766 | £15,706 |
| Net Worth | £3,755 | £3,266 | £3,335 | £3,913 | £4,799 | £5,921 | £7,386 | £7,608 | £9,284 | £9,732 | £9,882 | £9,932 | £9,520 |