| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Supplement Companies | 0% | £300 | £432 | £565 | £2,002 | £3,222 | £4,323 | £4,655 | £5,232 | £5,989 | £6,000 | £5,232 | £3,433 |
| Processors | 0% | £258 | £372 | £486 | £1,722 | £2,771 | £3,718 | £4,003 | £4,500 | £5,151 | £5,160 | £4,500 | £2,952 |
| Nurseries | 0% | £57 | £82 | £107 | £380 | £612 | £821 | £884 | £994 | £1,138 | £1,140 | £994 | £652 |
| Total Sales | £615 | £886 | £1,158 | £4,104 | £6,605 | £8,862 | £9,543 | £10,726 | £12,277 | £12,300 | £10,726 | £7,038 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Supplement companies | £23 | £32 | £42 | £150 | £242 | £324 | £349 | £392 | £449 | £450 | £392 | £257 | |
| Processors | £19 | £28 | £36 | £129 | £208 | £279 | £300 | £337 | £386 | £387 | £337 | £221 | |
| Nurseries | £4 | £6 | £8 | £29 | £46 | £62 | £66 | £75 | £85 | £86 | £75 | £49 | |
| Subtotal Direct Cost of Sales | £46 | £66 | £87 | £308 | £495 | £665 | £716 | £804 | £921 | £923 | £804 | £528 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| David | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Sue | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Grower | 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 |
| Laborers | 0% | £1,000 | £1,000 | £2,000 | £2,000 | £3,000 | £4,000 | £4,000 | £4,000 | £2,000 | £2,000 | £1,000 | £1,000 |
| Total People | 4 | 4 | 5 | 5 | 6 | 7 | 7 | 7 | 5 | 5 | 4 | 4 | |
| Total Payroll | £6,000 | £6,000 | £7,000 | £7,000 | £8,000 | £9,000 | £9,000 | £9,000 | £7,000 | £7,000 | £6,000 | £6,000 | |
| General Assumptions | ||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| 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 | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £615 | £886 | £1,158 | £4,104 | £6,605 | £8,862 | £9,543 | £10,726 | £12,277 | £12,300 | £10,726 | £7,038 | |
| Direct Cost of Sales | £46 | £66 | £87 | £308 | £495 | £665 | £716 | £804 | £921 | £923 | £804 | £528 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £46 | £66 | £87 | £308 | £495 | £665 | £716 | £804 | £921 | £923 | £804 | £528 | |
| Gross Margin | £569 | £819 | £1,071 | £3,796 | £6,110 | £8,197 | £8,827 | £9,921 | £11,357 | £11,378 | £9,921 | £6,510 | |
| Gross Margin % | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | |
| Expenses | |||||||||||||
| Payroll | £6,000 | £6,000 | £7,000 | £7,000 | £8,000 | £9,000 | £9,000 | £9,000 | £7,000 | £7,000 | £6,000 | £6,000 | |
| Sales and Marketing and Other Expenses | £400 | £3,000 | £400 | £400 | £400 | £400 | £400 | £3,000 | £400 | £400 | £400 | £400 | |
| Depreciation | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | |
| Mortgage | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Utilities | £500 | £500 | £500 | £600 | £700 | £700 | £700 | £700 | £600 | £500 | £500 | £500 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £900 | £900 | £1,050 | £1,050 | £1,200 | £1,350 | £1,350 | £1,350 | £1,050 | £1,050 | £900 | £900 |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £10,783 | £13,383 | £11,933 | £12,033 | £13,283 | £14,433 | £14,433 | £17,033 | £12,033 | £11,933 | £10,783 | £10,783 | |
| Profit Before Interest and Taxes | (£10,214) | (£12,564) | (£10,862) | (£8,237) | (£7,173) | (£6,236) | (£5,606) | (£7,112) | (£676) | (£556) | (£862) | (£4,273) | |
| EBITDA | (£9,631) | (£11,981) | (£10,279) | (£7,654) | (£6,590) | (£5,653) | (£5,023) | (£6,529) | (£93) | £28 | (£279) | (£3,690) | |
| Interest Expense | £333 | £333 | £332 | £330 | £328 | £327 | £325 | £323 | £322 | £320 | £318 | £317 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£10,547) | (£12,897) | (£11,193) | (£8,567) | (£7,502) | (£6,562) | (£5,931) | (£7,435) | (£998) | (£876) | (£1,180) | (£4,590) | |
| Net Profit/Sales | -1715.03% | -1456.32% | -966.40% | -208.74% | -113.57% | -74.05% | -62.15% | -69.32% | -8.13% | -7.12% | -11.00% | -65.22% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £154 | £221 | £290 | £1,026 | £1,651 | £2,216 | £2,386 | £2,681 | £3,069 | £3,075 | £2,681 | £1,759 | |
| Cash from Receivables | £4,000 | £4,015 | £468 | £671 | £942 | £3,141 | £5,010 | £6,664 | £7,187 | £8,083 | £9,209 | £9,186 | |
| Subtotal Cash from Operations | £4,154 | £4,237 | £758 | £1,697 | £2,594 | £5,356 | £7,396 | £9,345 | £10,256 | £11,158 | £11,890 | £10,945 | |
| 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 | £100,000 | £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 | £104,154 | £4,237 | £758 | £1,697 | £2,594 | £5,356 | £7,396 | £9,345 | £10,256 | £11,158 | £11,890 | £10,945 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £6,000 | £6,000 | £7,000 | £7,000 | £8,000 | £9,000 | £9,000 | £9,000 | £7,000 | £7,000 | £6,000 | £6,000 | |
| Bill Payments | £13,243 | £4,667 | £7,119 | £4,779 | £5,102 | £5,534 | £5,843 | £5,980 | £8,482 | £5,689 | £5,584 | £5,313 | |
| Subtotal Spent on Operations | £19,243 | £10,667 | £14,119 | £11,779 | £13,102 | £14,534 | £14,843 | £14,980 | £15,482 | £12,689 | £11,584 | £11,313 | |
| 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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £35,000 | £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 | £54,243 | £10,667 | £14,619 | £12,279 | £13,602 | £15,034 | £15,343 | £15,480 | £15,982 | £13,189 | £12,084 | £11,813 | |
| Net Cash Flow | £49,911 | (£6,430) | (£13,861) | (£10,582) | (£11,009) | (£9,678) | (£7,947) | (£6,135) | (£5,726) | (£2,031) | (£193) | (£868) | |
| Cash Balance | £84,911 | £78,481 | £64,620 | £54,038 | £43,029 | £33,351 | £25,404 | £19,269 | £13,543 | £11,512 | £11,318 | £10,450 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £35,000 | £84,911 | £78,481 | £64,620 | £54,038 | £43,029 | £33,351 | £25,404 | £19,269 | £13,543 | £11,512 | £11,318 | £10,450 |
| Accounts Receivable | £8,000 | £4,461 | £1,110 | £1,511 | £3,918 | £7,929 | £11,435 | £13,582 | £14,963 | £16,984 | £18,126 | £16,962 | £13,054 |
| Other Current Assets | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Total Current Assets | £47,000 | £93,372 | £83,591 | £70,131 | £61,956 | £54,958 | £48,786 | £42,986 | £38,231 | £34,527 | £33,638 | £32,280 | £27,504 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £35,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 |
| Accumulated Depreciation | £7,000 | £7,583 | £8,166 | £8,749 | £9,332 | £9,915 | £10,498 | £11,081 | £11,664 | £12,247 | £12,830 | £13,413 | £13,996 |
| Total Long-term Assets | £28,000 | £62,417 | £61,834 | £61,251 | £60,668 | £60,085 | £59,502 | £58,919 | £58,336 | £57,753 | £57,170 | £56,587 | £56,004 |
| Total Assets | £75,000 | £155,789 | £145,425 | £131,382 | £122,624 | £115,043 | £108,288 | £101,905 | £96,567 | £92,280 | £90,808 | £88,867 | £83,508 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £13,090 | £4,427 | £6,960 | £4,610 | £4,918 | £5,340 | £5,647 | £5,694 | £8,292 | £5,503 | £5,406 | £5,145 | £4,876 |
| 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 | £13,090 | £4,427 | £6,960 | £4,610 | £4,918 | £5,340 | £5,647 | £5,694 | £8,292 | £5,503 | £5,406 | £5,145 | £4,876 |
| Long-term Liabilities | £0 | £100,000 | £100,000 | £99,500 | £99,000 | £98,500 | £98,000 | £97,500 | £97,000 | £96,500 | £96,000 | £95,500 | £95,000 |
| Total Liabilities | £13,090 | £104,427 | £106,960 | £104,110 | £103,918 | £103,840 | £103,647 | £103,194 | £105,292 | £102,003 | £101,406 | £100,645 | £99,876 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 |
| Earnings | £0 | (£10,547) | (£23,445) | (£34,638) | (£43,205) | (£50,706) | (£57,268) | (£63,199) | (£70,635) | (£71,633) | (£72,508) | (£73,688) | (£78,278) |
| Total Capital | £61,910 | £51,363 | £38,465 | £27,272 | £18,705 | £11,204 | £4,642 | (£1,289) | (£8,725) | (£9,723) | (£10,598) | (£11,778) | (£16,368) |
| Total Liabilities and Capital | £75,000 | £155,789 | £145,425 | £131,382 | £122,624 | £115,043 | £108,288 | £101,905 | £96,567 | £92,280 | £90,808 | £88,867 | £83,508 |
| Net Worth | £61,910 | £51,363 | £38,465 | £27,272 | £18,705 | £11,204 | £4,642 | (£1,289) | (£8,725) | (£9,723) | (£10,598) | (£11,778) | (£16,368) |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Supplement Companies | 0% | £300 | £432 | £565 | £2,002 | £3,222 | £4,323 | £4,655 | £5,232 | £5,989 | £6,000 | £5,232 | £3,433 |
| Processors | 0% | £258 | £372 | £486 | £1,722 | £2,771 | £3,718 | £4,003 | £4,500 | £5,151 | £5,160 | £4,500 | £2,952 |
| Nurseries | 0% | £57 | £82 | £107 | £380 | £612 | £821 | £884 | £994 | £1,138 | £1,140 | £994 | £652 |
| Total Sales | £615 | £886 | £1,158 | £4,104 | £6,605 | £8,862 | £9,543 | £10,726 | £12,277 | £12,300 | £10,726 | £7,038 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Supplement companies | £23 | £32 | £42 | £150 | £242 | £324 | £349 | £392 | £449 | £450 | £392 | £257 | |
| Processors | £19 | £28 | £36 | £129 | £208 | £279 | £300 | £337 | £386 | £387 | £337 | £221 | |
| Nurseries | £4 | £6 | £8 | £29 | £46 | £62 | £66 | £75 | £85 | £86 | £75 | £49 | |
| Subtotal Direct Cost of Sales | £46 | £66 | £87 | £308 | £495 | £665 | £716 | £804 | £921 | £923 | £804 | £528 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| David | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Sue | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Grower | 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 |
| Laborers | 0% | £1,000 | £1,000 | £2,000 | £2,000 | £3,000 | £4,000 | £4,000 | £4,000 | £2,000 | £2,000 | £1,000 | £1,000 |
| Total People | 4 | 4 | 5 | 5 | 6 | 7 | 7 | 7 | 5 | 5 | 4 | 4 | |
| Total Payroll | £6,000 | £6,000 | £7,000 | £7,000 | £8,000 | £9,000 | £9,000 | £9,000 | £7,000 | £7,000 | £6,000 | £6,000 | |
| General Assumptions | ||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| 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 | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £615 | £886 | £1,158 | £4,104 | £6,605 | £8,862 | £9,543 | £10,726 | £12,277 | £12,300 | £10,726 | £7,038 | |
| Direct Cost of Sales | £46 | £66 | £87 | £308 | £495 | £665 | £716 | £804 | £921 | £923 | £804 | £528 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £46 | £66 | £87 | £308 | £495 | £665 | £716 | £804 | £921 | £923 | £804 | £528 | |
| Gross Margin | £569 | £819 | £1,071 | £3,796 | £6,110 | £8,197 | £8,827 | £9,921 | £11,357 | £11,378 | £9,921 | £6,510 | |
| Gross Margin % | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | 92.50% | |
| Expenses | |||||||||||||
| Payroll | £6,000 | £6,000 | £7,000 | £7,000 | £8,000 | £9,000 | £9,000 | £9,000 | £7,000 | £7,000 | £6,000 | £6,000 | |
| Sales and Marketing and Other Expenses | £400 | £3,000 | £400 | £400 | £400 | £400 | £400 | £3,000 | £400 | £400 | £400 | £400 | |
| Depreciation | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | £583 | |
| Mortgage | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Utilities | £500 | £500 | £500 | £600 | £700 | £700 | £700 | £700 | £600 | £500 | £500 | £500 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £900 | £900 | £1,050 | £1,050 | £1,200 | £1,350 | £1,350 | £1,350 | £1,050 | £1,050 | £900 | £900 |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Operating Expenses | £10,783 | £13,383 | £11,933 | £12,033 | £13,283 | £14,433 | £14,433 | £17,033 | £12,033 | £11,933 | £10,783 | £10,783 | |
| Profit Before Interest and Taxes | (£10,214) | (£12,564) | (£10,862) | (£8,237) | (£7,173) | (£6,236) | (£5,606) | (£7,112) | (£676) | (£556) | (£862) | (£4,273) | |
| EBITDA | (£9,631) | (£11,981) | (£10,279) | (£7,654) | (£6,590) | (£5,653) | (£5,023) | (£6,529) | (£93) | £28 | (£279) | (£3,690) | |
| Interest Expense | £333 | £333 | £332 | £330 | £328 | £327 | £325 | £323 | £322 | £320 | £318 | £317 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£10,547) | (£12,897) | (£11,193) | (£8,567) | (£7,502) | (£6,562) | (£5,931) | (£7,435) | (£998) | (£876) | (£1,180) | (£4,590) | |
| Net Profit/Sales | -1715.03% | -1456.32% | -966.40% | -208.74% | -113.57% | -74.05% | -62.15% | -69.32% | -8.13% | -7.12% | -11.00% | -65.22% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £154 | £221 | £290 | £1,026 | £1,651 | £2,216 | £2,386 | £2,681 | £3,069 | £3,075 | £2,681 | £1,759 | |
| Cash from Receivables | £4,000 | £4,015 | £468 | £671 | £942 | £3,141 | £5,010 | £6,664 | £7,187 | £8,083 | £9,209 | £9,186 | |
| Subtotal Cash from Operations | £4,154 | £4,237 | £758 | £1,697 | £2,594 | £5,356 | £7,396 | £9,345 | £10,256 | £11,158 | £11,890 | £10,945 | |
| 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 | £100,000 | £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 | £104,154 | £4,237 | £758 | £1,697 | £2,594 | £5,356 | £7,396 | £9,345 | £10,256 | £11,158 | £11,890 | £10,945 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £6,000 | £6,000 | £7,000 | £7,000 | £8,000 | £9,000 | £9,000 | £9,000 | £7,000 | £7,000 | £6,000 | £6,000 | |
| Bill Payments | £13,243 | £4,667 | £7,119 | £4,779 | £5,102 | £5,534 | £5,843 | £5,980 | £8,482 | £5,689 | £5,584 | £5,313 | |
| Subtotal Spent on Operations | £19,243 | £10,667 | £14,119 | £11,779 | £13,102 | £14,534 | £14,843 | £14,980 | £15,482 | £12,689 | £11,584 | £11,313 | |
| 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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £35,000 | £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 | £54,243 | £10,667 | £14,619 | £12,279 | £13,602 | £15,034 | £15,343 | £15,480 | £15,982 | £13,189 | £12,084 | £11,813 | |
| Net Cash Flow | £49,911 | (£6,430) | (£13,861) | (£10,582) | (£11,009) | (£9,678) | (£7,947) | (£6,135) | (£5,726) | (£2,031) | (£193) | (£868) | |
| Cash Balance | £84,911 | £78,481 | £64,620 | £54,038 | £43,029 | £33,351 | £25,404 | £19,269 | £13,543 | £11,512 | £11,318 | £10,450 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £35,000 | £84,911 | £78,481 | £64,620 | £54,038 | £43,029 | £33,351 | £25,404 | £19,269 | £13,543 | £11,512 | £11,318 | £10,450 |
| Accounts Receivable | £8,000 | £4,461 | £1,110 | £1,511 | £3,918 | £7,929 | £11,435 | £13,582 | £14,963 | £16,984 | £18,126 | £16,962 | £13,054 |
| Other Current Assets | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Total Current Assets | £47,000 | £93,372 | £83,591 | £70,131 | £61,956 | £54,958 | £48,786 | £42,986 | £38,231 | £34,527 | £33,638 | £32,280 | £27,504 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £35,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 |
| Accumulated Depreciation | £7,000 | £7,583 | £8,166 | £8,749 | £9,332 | £9,915 | £10,498 | £11,081 | £11,664 | £12,247 | £12,830 | £13,413 | £13,996 |
| Total Long-term Assets | £28,000 | £62,417 | £61,834 | £61,251 | £60,668 | £60,085 | £59,502 | £58,919 | £58,336 | £57,753 | £57,170 | £56,587 | £56,004 |
| Total Assets | £75,000 | £155,789 | £145,425 | £131,382 | £122,624 | £115,043 | £108,288 | £101,905 | £96,567 | £92,280 | £90,808 | £88,867 | £83,508 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £13,090 | £4,427 | £6,960 | £4,610 | £4,918 | £5,340 | £5,647 | £5,694 | £8,292 | £5,503 | £5,406 | £5,145 | £4,876 |
| 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 | £13,090 | £4,427 | £6,960 | £4,610 | £4,918 | £5,340 | £5,647 | £5,694 | £8,292 | £5,503 | £5,406 | £5,145 | £4,876 |
| Long-term Liabilities | £0 | £100,000 | £100,000 | £99,500 | £99,000 | £98,500 | £98,000 | £97,500 | £97,000 | £96,500 | £96,000 | £95,500 | £95,000 |
| Total Liabilities | £13,090 | £104,427 | £106,960 | £104,110 | £103,918 | £103,840 | £103,647 | £103,194 | £105,292 | £102,003 | £101,406 | £100,645 | £99,876 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 | £61,910 |
| Earnings | £0 | (£10,547) | (£23,445) | (£34,638) | (£43,205) | (£50,706) | (£57,268) | (£63,199) | (£70,635) | (£71,633) | (£72,508) | (£73,688) | (£78,278) |
| Total Capital | £61,910 | £51,363 | £38,465 | £27,272 | £18,705 | £11,204 | £4,642 | (£1,289) | (£8,725) | (£9,723) | (£10,598) | (£11,778) | (£16,368) |
| Total Liabilities and Capital | £75,000 | £155,789 | £145,425 | £131,382 | £122,624 | £115,043 | £108,288 | £101,905 | £96,567 | £92,280 | £90,808 | £88,867 | £83,508 |
| Net Worth | £61,910 | £51,363 | £38,465 | £27,272 | £18,705 | £11,204 | £4,642 | (£1,289) | (£8,725) | (£9,723) | (£10,598) | (£11,778) | (£16,368) |