| 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 | |||||||||||||
| Hardcore athletes | 40% | £0 | £0 | £3,433 | £4,412 | £4,645 | £5,323 | £6,112 | £6,687 | £7,112 | £7,454 | £7,878 | £10,101 |
| Newbies | 40% | £0 | £0 | £3,845 | £4,941 | £5,202 | £5,962 | £6,845 | £7,489 | £7,965 | £8,348 | £8,823 | £11,313 |
| Total Sales | £0 | £0 | £7,278 | £9,353 | £9,847 | £11,285 | £12,957 | £14,176 | £15,077 | £15,802 | £16,701 | £21,414 | |
| 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 | |
| Hardcore athletes | £0 | £0 | £1,373 | £1,765 | £1,858 | £2,129 | £2,445 | £2,675 | £2,845 | £2,982 | £3,151 | £4,040 | |
| Newbies | £0 | £0 | £1,538 | £1,977 | £2,081 | £2,385 | £2,738 | £2,996 | £3,186 | £3,339 | £3,529 | £4,525 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £2,911 | £3,741 | £3,939 | £4,514 | £5,183 | £5,671 | £6,031 | £6,321 | £6,681 | £8,566 | |
| 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 | ||
| Stan | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Sales staff | 0% | £0 | £0 | £1,500 | £2,000 | £2,500 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Support Staff | 0% | £0 | £0 | £1,500 | £2,000 | £2,200 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Bookkeeper | 0% | £0 | £1,000 | £1,200 | £1,500 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Total People | 1 | 2 | 4 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £2,000 | £3,000 | £6,200 | £7,500 | £8,700 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | |
| 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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | £0 | £7,278 | £9,353 | £9,847 | £11,285 | £12,957 | £14,176 | £15,077 | £15,802 | £16,701 | £21,414 | |
| Direct Cost of Sales | £0 | £0 | £2,911 | £3,741 | £3,939 | £4,514 | £5,183 | £5,671 | £6,031 | £6,321 | £6,681 | £8,566 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £2,911 | £3,741 | £3,939 | £4,514 | £5,183 | £5,671 | £6,031 | £6,321 | £6,681 | £8,566 | |
| Gross Margin | £0 | £0 | £4,367 | £5,612 | £5,908 | £6,771 | £7,774 | £8,506 | £9,046 | £9,481 | £10,021 | £12,848 | |
| Gross Margin % | 0.00% | 0.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £3,000 | £6,200 | £7,500 | £8,700 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | |
| Sales and Marketing and Other Expenses | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | |
| Payroll Taxes | 15% | £300 | £450 | £930 | £1,125 | £1,305 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £4,675 | £5,825 | £9,505 | £11,000 | £12,380 | £13,185 | £13,185 | £13,185 | £13,185 | £13,185 | £13,185 | £13,185 | |
| Profit Before Interest and Taxes | (£4,675) | (£5,825) | (£5,138) | (£5,388) | (£6,472) | (£6,414) | (£5,411) | (£4,679) | (£4,139) | (£3,704) | (£3,164) | (£337) | |
| EBITDA | (£4,525) | (£5,675) | (£4,988) | (£5,238) | (£6,322) | (£6,264) | (£5,261) | (£4,529) | (£3,989) | (£3,554) | (£3,014) | (£187) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,675) | (£5,825) | (£5,138) | (£5,388) | (£6,472) | (£6,414) | (£5,411) | (£4,679) | (£4,139) | (£3,704) | (£3,164) | (£337) | |
| Net Profit/Sales | 0.00% | 0.00% | -70.60% | -57.60% | -65.72% | -56.84% | -41.76% | -33.01% | -27.45% | -23.44% | -18.95% | -1.57% | |
| 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 | £0 | £7,278 | £9,353 | £9,847 | £11,285 | £12,957 | £14,176 | £15,077 | £15,802 | £16,701 | £21,414 | |
| Subtotal Cash from Operations | £0 | £0 | £7,278 | £9,353 | £9,847 | £11,285 | £12,957 | £14,176 | £15,077 | £15,802 | £16,701 | £21,414 | |
| 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 | £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 | £0 | £0 | £7,278 | £9,353 | £9,847 | £11,285 | £12,957 | £14,176 | £15,077 | £15,802 | £16,701 | £21,414 | |
| 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 | £3,000 | £6,200 | £7,500 | £8,700 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | |
| Bill Payments | £84 | £2,530 | £2,895 | £9,226 | £7,994 | £7,723 | £8,807 | £9,564 | £9,849 | £10,070 | £10,290 | £10,830 | |
| Subtotal Spent on Operations | £2,084 | £5,530 | £9,095 | £16,726 | £16,694 | £17,123 | £18,207 | £18,964 | £19,249 | £19,470 | £19,690 | £20,230 | |
| 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 | £2,084 | £5,530 | £9,095 | £16,726 | £16,694 | £17,123 | £18,207 | £18,964 | £19,249 | £19,470 | £19,690 | £20,230 | |
| Net Cash Flow | (£2,084) | (£5,530) | (£1,817) | (£7,373) | (£6,847) | (£5,838) | (£5,250) | (£4,787) | (£4,172) | (£3,667) | (£2,988) | £1,184 | |
| Cash Balance | £86,016 | £80,486 | £78,669 | £71,296 | £64,450 | £58,611 | £53,362 | £48,575 | £44,403 | £40,736 | £37,748 | £38,932 | |
| 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 | £88,100 | £86,016 | £80,486 | £78,669 | £71,296 | £64,450 | £58,611 | £53,362 | £48,575 | £44,403 | £40,736 | £37,748 | £38,932 |
| Inventory | £0 | £0 | £0 | £3,202 | £4,116 | £4,333 | £4,965 | £5,701 | £6,238 | £6,634 | £6,953 | £7,349 | £9,422 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £88,100 | £86,016 | £80,486 | £81,871 | £75,412 | £68,782 | £63,577 | £59,063 | £54,812 | £51,037 | £47,689 | £45,096 | £48,354 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 |
| Accumulated Depreciation | £0 | £150 | £300 | £450 | £600 | £750 | £900 | £1,050 | £1,200 | £1,350 | £1,500 | £1,650 | £1,800 |
| Total Long-term Assets | £9,000 | £8,850 | £8,700 | £8,550 | £8,400 | £8,250 | £8,100 | £7,950 | £7,800 | £7,650 | £7,500 | £7,350 | £7,200 |
| Total Assets | £97,100 | £94,866 | £89,186 | £90,421 | £83,812 | £77,032 | £71,677 | £67,013 | £62,612 | £58,687 | £55,189 | £52,446 | £55,554 |
| 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 | £2,441 | £2,586 | £8,960 | £7,738 | £7,430 | £8,489 | £9,235 | £9,514 | £9,727 | £9,933 | £10,354 | £13,798 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £2,441 | £2,586 | £8,960 | £7,738 | £7,430 | £8,489 | £9,235 | £9,514 | £9,727 | £9,933 | £10,354 | £13,798 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £2,441 | £2,586 | £8,960 | £7,738 | £7,430 | £8,489 | £9,235 | £9,514 | £9,727 | £9,933 | £10,354 | £13,798 |
| Paid-in Capital | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 |
| Retained Earnings | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) |
| Earnings | £0 | (£4,675) | (£10,500) | (£15,638) | (£21,026) | (£27,498) | (£33,912) | (£39,322) | (£44,002) | (£48,140) | (£51,844) | (£55,008) | (£55,344) |
| Total Capital | £97,100 | £92,425 | £86,600 | £81,462 | £76,074 | £69,602 | £63,188 | £57,778 | £53,098 | £48,960 | £45,256 | £42,092 | £41,756 |
| Total Liabilities and Capital | £97,100 | £94,866 | £89,186 | £90,421 | £83,812 | £77,032 | £71,677 | £67,013 | £62,612 | £58,687 | £55,189 | £52,446 | £55,554 |
| Net Worth | £97,100 | £92,425 | £86,600 | £81,462 | £76,074 | £69,602 | £63,188 | £57,778 | £53,098 | £48,960 | £45,256 | £42,092 | £41,756 |
| 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 | |||||||||||||
| Hardcore athletes | 40% | £0 | £0 | £3,433 | £4,412 | £4,645 | £5,323 | £6,112 | £6,687 | £7,112 | £7,454 | £7,878 | £10,101 |
| Newbies | 40% | £0 | £0 | £3,845 | £4,941 | £5,202 | £5,962 | £6,845 | £7,489 | £7,965 | £8,348 | £8,823 | £11,313 |
| Total Sales | £0 | £0 | £7,278 | £9,353 | £9,847 | £11,285 | £12,957 | £14,176 | £15,077 | £15,802 | £16,701 | £21,414 | |
| 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 | |
| Hardcore athletes | £0 | £0 | £1,373 | £1,765 | £1,858 | £2,129 | £2,445 | £2,675 | £2,845 | £2,982 | £3,151 | £4,040 | |
| Newbies | £0 | £0 | £1,538 | £1,977 | £2,081 | £2,385 | £2,738 | £2,996 | £3,186 | £3,339 | £3,529 | £4,525 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £2,911 | £3,741 | £3,939 | £4,514 | £5,183 | £5,671 | £6,031 | £6,321 | £6,681 | £8,566 | |
| 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 | ||
| Stan | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Sales staff | 0% | £0 | £0 | £1,500 | £2,000 | £2,500 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Support Staff | 0% | £0 | £0 | £1,500 | £2,000 | £2,200 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Bookkeeper | 0% | £0 | £1,000 | £1,200 | £1,500 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Total People | 1 | 2 | 4 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £2,000 | £3,000 | £6,200 | £7,500 | £8,700 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | |
| 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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | £0 | £7,278 | £9,353 | £9,847 | £11,285 | £12,957 | £14,176 | £15,077 | £15,802 | £16,701 | £21,414 | |
| Direct Cost of Sales | £0 | £0 | £2,911 | £3,741 | £3,939 | £4,514 | £5,183 | £5,671 | £6,031 | £6,321 | £6,681 | £8,566 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £2,911 | £3,741 | £3,939 | £4,514 | £5,183 | £5,671 | £6,031 | £6,321 | £6,681 | £8,566 | |
| Gross Margin | £0 | £0 | £4,367 | £5,612 | £5,908 | £6,771 | £7,774 | £8,506 | £9,046 | £9,481 | £10,021 | £12,848 | |
| Gross Margin % | 0.00% | 0.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £3,000 | £6,200 | £7,500 | £8,700 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | |
| Sales and Marketing and Other Expenses | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Rent | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | £325 | |
| Payroll Taxes | 15% | £300 | £450 | £930 | £1,125 | £1,305 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £4,675 | £5,825 | £9,505 | £11,000 | £12,380 | £13,185 | £13,185 | £13,185 | £13,185 | £13,185 | £13,185 | £13,185 | |
| Profit Before Interest and Taxes | (£4,675) | (£5,825) | (£5,138) | (£5,388) | (£6,472) | (£6,414) | (£5,411) | (£4,679) | (£4,139) | (£3,704) | (£3,164) | (£337) | |
| EBITDA | (£4,525) | (£5,675) | (£4,988) | (£5,238) | (£6,322) | (£6,264) | (£5,261) | (£4,529) | (£3,989) | (£3,554) | (£3,014) | (£187) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,675) | (£5,825) | (£5,138) | (£5,388) | (£6,472) | (£6,414) | (£5,411) | (£4,679) | (£4,139) | (£3,704) | (£3,164) | (£337) | |
| Net Profit/Sales | 0.00% | 0.00% | -70.60% | -57.60% | -65.72% | -56.84% | -41.76% | -33.01% | -27.45% | -23.44% | -18.95% | -1.57% | |
| 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 | £0 | £7,278 | £9,353 | £9,847 | £11,285 | £12,957 | £14,176 | £15,077 | £15,802 | £16,701 | £21,414 | |
| Subtotal Cash from Operations | £0 | £0 | £7,278 | £9,353 | £9,847 | £11,285 | £12,957 | £14,176 | £15,077 | £15,802 | £16,701 | £21,414 | |
| 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 | £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 | £0 | £0 | £7,278 | £9,353 | £9,847 | £11,285 | £12,957 | £14,176 | £15,077 | £15,802 | £16,701 | £21,414 | |
| 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 | £3,000 | £6,200 | £7,500 | £8,700 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | |
| Bill Payments | £84 | £2,530 | £2,895 | £9,226 | £7,994 | £7,723 | £8,807 | £9,564 | £9,849 | £10,070 | £10,290 | £10,830 | |
| Subtotal Spent on Operations | £2,084 | £5,530 | £9,095 | £16,726 | £16,694 | £17,123 | £18,207 | £18,964 | £19,249 | £19,470 | £19,690 | £20,230 | |
| 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 | £2,084 | £5,530 | £9,095 | £16,726 | £16,694 | £17,123 | £18,207 | £18,964 | £19,249 | £19,470 | £19,690 | £20,230 | |
| Net Cash Flow | (£2,084) | (£5,530) | (£1,817) | (£7,373) | (£6,847) | (£5,838) | (£5,250) | (£4,787) | (£4,172) | (£3,667) | (£2,988) | £1,184 | |
| Cash Balance | £86,016 | £80,486 | £78,669 | £71,296 | £64,450 | £58,611 | £53,362 | £48,575 | £44,403 | £40,736 | £37,748 | £38,932 | |
| 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 | £88,100 | £86,016 | £80,486 | £78,669 | £71,296 | £64,450 | £58,611 | £53,362 | £48,575 | £44,403 | £40,736 | £37,748 | £38,932 |
| Inventory | £0 | £0 | £0 | £3,202 | £4,116 | £4,333 | £4,965 | £5,701 | £6,238 | £6,634 | £6,953 | £7,349 | £9,422 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £88,100 | £86,016 | £80,486 | £81,871 | £75,412 | £68,782 | £63,577 | £59,063 | £54,812 | £51,037 | £47,689 | £45,096 | £48,354 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 |
| Accumulated Depreciation | £0 | £150 | £300 | £450 | £600 | £750 | £900 | £1,050 | £1,200 | £1,350 | £1,500 | £1,650 | £1,800 |
| Total Long-term Assets | £9,000 | £8,850 | £8,700 | £8,550 | £8,400 | £8,250 | £8,100 | £7,950 | £7,800 | £7,650 | £7,500 | £7,350 | £7,200 |
| Total Assets | £97,100 | £94,866 | £89,186 | £90,421 | £83,812 | £77,032 | £71,677 | £67,013 | £62,612 | £58,687 | £55,189 | £52,446 | £55,554 |
| 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 | £2,441 | £2,586 | £8,960 | £7,738 | £7,430 | £8,489 | £9,235 | £9,514 | £9,727 | £9,933 | £10,354 | £13,798 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £2,441 | £2,586 | £8,960 | £7,738 | £7,430 | £8,489 | £9,235 | £9,514 | £9,727 | £9,933 | £10,354 | £13,798 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £2,441 | £2,586 | £8,960 | £7,738 | £7,430 | £8,489 | £9,235 | £9,514 | £9,727 | £9,933 | £10,354 | £13,798 |
| Paid-in Capital | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 |
| Retained Earnings | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) | (£17,900) |
| Earnings | £0 | (£4,675) | (£10,500) | (£15,638) | (£21,026) | (£27,498) | (£33,912) | (£39,322) | (£44,002) | (£48,140) | (£51,844) | (£55,008) | (£55,344) |
| Total Capital | £97,100 | £92,425 | £86,600 | £81,462 | £76,074 | £69,602 | £63,188 | £57,778 | £53,098 | £48,960 | £45,256 | £42,092 | £41,756 |
| Total Liabilities and Capital | £97,100 | £94,866 | £89,186 | £90,421 | £83,812 | £77,032 | £71,677 | £67,013 | £62,612 | £58,687 | £55,189 | £52,446 | £55,554 |
| Net Worth | £97,100 | £92,425 | £86,600 | £81,462 | £76,074 | £69,602 | £63,188 | £57,778 | £53,098 | £48,960 | £45,256 | £42,092 | £41,756 |