| Sales Forecast | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | |||||||||||||
| Retailer Sales | 0% | £8,164 | £8,164 | £8,164 | £8,164 | £8,792 | £8,792 | £8,792 | £10,048 | £10,048 | £11,304 | £11,304 | £11,304 |
| Designer Sales | 0% | £1,157 | £1,157 | £1,157 | £1,157 | £1,246 | £1,246 | £1,246 | £1,424 | £1,424 | £1,602 | £1,602 | £1,602 |
| Wholesale | 0% | £741 | £741 | £741 | £741 | £798 | £798 | £798 | £912 | £912 | £1,026 | £1,026 | £1,026 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £10,062 | £10,062 | £10,062 | £10,062 | £10,836 | £10,836 | £10,836 | £12,384 | £12,384 | £13,932 | £13,932 | £13,932 | |
| Direct Cost of Sales | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Retailer Sales | 40% | £3,266 | £3,266 | £3,266 | £3,266 | £3,517 | £3,517 | £3,517 | £4,019 | £4,019 | £4,522 | £4,522 | £4,522 |
| Designer Sales | 40% | £463 | £463 | £463 | £463 | £498 | £498 | £498 | £570 | £570 | £641 | £641 | £641 |
| Wholesale | 40% | £296 | £296 | £296 | £296 | £319 | £319 | £319 | £365 | £365 | £410 | £410 | £410 |
| Other | 40% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Direct Cost of Sales | £4,025 | £4,025 | £4,025 | £4,025 | £4,334 | £4,334 | £4,334 | £4,954 | £4,954 | £5,573 | £5,573 | £5,573 | |
| Personnel Plan | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Admin. Assist. | 0% | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 |
| Owner | 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 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | |
| General Assumptions | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest 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% | |
| Long-term Interest 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% | |
| 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 | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | £10,062 | £10,062 | £10,062 | £10,062 | £10,836 | £10,836 | £10,836 | £12,384 | £12,384 | £13,932 | £13,932 | £13,932 | |
| Direct Cost of Sales | £4,025 | £4,025 | £4,025 | £4,025 | £4,334 | £4,334 | £4,334 | £4,954 | £4,954 | £5,573 | £5,573 | £5,573 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £4,025 | £4,025 | £4,025 | £4,025 | £4,334 | £4,334 | £4,334 | £4,954 | £4,954 | £5,573 | £5,573 | £5,573 | |
| Gross Margin | £6,037 | £6,037 | £6,037 | £6,037 | £6,502 | £6,502 | £6,502 | £7,430 | £7,430 | £8,359 | £8,359 | £8,359 | |
| Gross Margin % | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
| Expenses | |||||||||||||
| Payroll | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | |
| Sales and Marketing and Other Expenses | £4,610 | £1,610 | £610 | £1,610 | £610 | £1,610 | £610 | £1,610 | £610 | £1,610 | £610 | £1,610 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities (Telephone) | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance (Liability/Fire) | £0 | £0 | £1,500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent (Warehouse) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 13% | £253 | £253 | £253 | £253 | £253 | £253 | £253 | £253 | £253 | £253 | £253 | £253 |
| Agent Commission | 7% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £9,029 | £6,029 | £6,529 | £6,029 | £5,029 | £6,029 | £5,029 | £6,029 | £5,029 | £6,029 | £5,029 | £6,029 | |
| Profit Before Interest and Taxes | (£2,992) | £8 | (£492) | £8 | £1,473 | £473 | £1,473 | £1,401 | £2,401 | £2,330 | £3,330 | £2,330 | |
| EBITDA | (£2,992) | £8 | (£492) | £8 | £1,473 | £473 | £1,473 | £1,401 | £2,401 | £2,330 | £3,330 | £2,330 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£898) | £2 | (£123) | £2 | £368 | £118 | £368 | £350 | £600 | £583 | £833 | £583 | |
| Net Profit | (£2,094) | £6 | (£369) | £6 | £1,104 | £354 | £1,104 | £1,051 | £1,801 | £1,748 | £2,498 | £1,748 | |
| Net Profit/Sales | -20.81% | 0.06% | -3.67% | 0.06% | 10.19% | 3.27% | 10.19% | 8.49% | 14.54% | 12.54% | 17.93% | 12.54% | |
| Pro Forma Cash Flow | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £6,400 | £8,566 | £10,062 | £10,062 | £10,062 | £10,475 | £10,836 | £10,836 | £11,662 | £12,384 | £13,210 | £13,932 | |
| Subtotal Cash from Operations | £6,400 | £8,566 | £10,062 | £10,062 | £10,062 | £10,475 | £10,836 | £10,836 | £11,662 | £12,384 | £13,210 | £13,932 | |
| 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 | £5,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £21,000 | £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 | £32,400 | £8,566 | £10,062 | £10,062 | £10,062 | £10,475 | £10,836 | £10,836 | £11,662 | £12,384 | £13,210 | £13,932 | |
| Expenditures | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | |
| Bill Payments | £4,149 | £4,429 | £3,469 | £6,475 | £6,390 | £6,420 | £6,791 | £6,142 | £8,300 | £6,993 | £9,152 | £7,793 | |
| Subtotal Spent on Operations | £7,815 | £8,095 | £7,135 | £10,141 | £10,056 | £10,086 | £10,457 | £9,808 | £11,966 | £10,659 | £12,818 | £11,459 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| 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 | £8,815 | £9,095 | £8,135 | £11,141 | £11,056 | £11,086 | £11,457 | £10,808 | £12,966 | £11,659 | £13,818 | £12,459 | |
| Net Cash Flow | £23,585 | (£528) | £1,927 | (£1,079) | (£994) | (£611) | (£621) | £28 | (£1,305) | £725 | (£608) | £1,473 | |
| Cash Balance | £36,585 | £36,057 | £37,984 | £36,905 | £35,911 | £35,300 | £34,679 | £34,708 | £33,403 | £34,128 | £33,520 | £34,992 | |
| Pro Forma Balance Sheet | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £13,000 | £36,585 | £36,057 | £37,984 | £36,905 | £35,911 | £35,300 | £34,679 | £34,708 | £33,403 | £34,128 | £33,520 | £34,992 |
| Accounts Receivable | £9,600 | £13,262 | £14,758 | £14,758 | £14,758 | £15,532 | £15,893 | £15,893 | £17,441 | £18,163 | £19,711 | £20,434 | £20,434 |
| Inventory | £11,764 | £7,739 | £4,714 | £4,427 | £4,427 | £4,768 | £4,768 | £4,768 | £5,449 | £5,449 | £6,130 | £6,130 | £6,130 |
| Other Current Assets | £21,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £55,364 | £57,586 | £55,529 | £57,169 | £56,090 | £56,210 | £55,960 | £55,340 | £57,597 | £57,015 | £59,969 | £60,083 | £61,556 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Accumulated Depreciation | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £55,364 | £57,586 | £55,529 | £57,169 | £56,090 | £56,210 | £55,960 | £55,340 | £57,597 | £57,015 | £59,969 | £60,083 | £61,556 |
| Liabilities and Capital | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £4,000 | £4,317 | £3,253 | £6,262 | £6,177 | £6,193 | £6,588 | £5,863 | £8,070 | £6,686 | £8,893 | £7,509 | £8,234 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Subtotal Current Liabilities | £19,000 | £19,317 | £18,253 | £21,262 | £21,177 | £21,193 | £21,588 | £20,863 | £23,070 | £21,686 | £23,893 | £22,509 | £23,234 |
| Long-term Liabilities | £180,000 | £184,000 | £183,000 | £182,000 | £181,000 | £180,000 | £179,000 | £178,000 | £177,000 | £176,000 | £175,000 | £174,000 | £173,000 |
| Total Liabilities | £199,000 | £203,317 | £201,253 | £203,262 | £202,177 | £201,193 | £200,588 | £198,863 | £200,070 | £197,686 | £198,893 | £196,509 | £196,234 |
| Paid-in Capital | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Retained Earnings | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) |
| Earnings | £0 | (£2,094) | (£2,088) | (£2,457) | (£2,451) | (£1,346) | (£992) | £113 | £1,164 | £2,965 | £4,712 | £7,210 | £8,958 |
| Total Capital | (£143,636) | (£145,730) | (£145,724) | (£146,093) | (£146,087) | (£144,982) | (£144,628) | (£143,523) | (£142,472) | (£140,671) | (£138,924) | (£136,426) | (£134,678) |
| Total Liabilities and Capital | £55,364 | £57,586 | £55,529 | £57,169 | £56,090 | £56,210 | £55,960 | £55,340 | £57,597 | £57,015 | £59,969 | £60,083 | £61,556 |
| Net Worth | (£143,636) | (£145,730) | (£145,724) | (£146,093) | (£146,087) | (£144,982) | (£144,628) | (£143,523) | (£142,472) | (£140,671) | (£138,924) | (£136,426) | (£134,678) |
| Sales Forecast | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | |||||||||||||
| Retailer Sales | 0% | £8,164 | £8,164 | £8,164 | £8,164 | £8,792 | £8,792 | £8,792 | £10,048 | £10,048 | £11,304 | £11,304 | £11,304 |
| Designer Sales | 0% | £1,157 | £1,157 | £1,157 | £1,157 | £1,246 | £1,246 | £1,246 | £1,424 | £1,424 | £1,602 | £1,602 | £1,602 |
| Wholesale | 0% | £741 | £741 | £741 | £741 | £798 | £798 | £798 | £912 | £912 | £1,026 | £1,026 | £1,026 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £10,062 | £10,062 | £10,062 | £10,062 | £10,836 | £10,836 | £10,836 | £12,384 | £12,384 | £13,932 | £13,932 | £13,932 | |
| Direct Cost of Sales | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Retailer Sales | 40% | £3,266 | £3,266 | £3,266 | £3,266 | £3,517 | £3,517 | £3,517 | £4,019 | £4,019 | £4,522 | £4,522 | £4,522 |
| Designer Sales | 40% | £463 | £463 | £463 | £463 | £498 | £498 | £498 | £570 | £570 | £641 | £641 | £641 |
| Wholesale | 40% | £296 | £296 | £296 | £296 | £319 | £319 | £319 | £365 | £365 | £410 | £410 | £410 |
| Other | 40% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Direct Cost of Sales | £4,025 | £4,025 | £4,025 | £4,025 | £4,334 | £4,334 | £4,334 | £4,954 | £4,954 | £5,573 | £5,573 | £5,573 | |
| Personnel Plan | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Admin. Assist. | 0% | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 | £1,666 |
| Owner | 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 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | |
| General Assumptions | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest 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% | |
| Long-term Interest 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% | |
| 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 | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | £10,062 | £10,062 | £10,062 | £10,062 | £10,836 | £10,836 | £10,836 | £12,384 | £12,384 | £13,932 | £13,932 | £13,932 | |
| Direct Cost of Sales | £4,025 | £4,025 | £4,025 | £4,025 | £4,334 | £4,334 | £4,334 | £4,954 | £4,954 | £5,573 | £5,573 | £5,573 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £4,025 | £4,025 | £4,025 | £4,025 | £4,334 | £4,334 | £4,334 | £4,954 | £4,954 | £5,573 | £5,573 | £5,573 | |
| Gross Margin | £6,037 | £6,037 | £6,037 | £6,037 | £6,502 | £6,502 | £6,502 | £7,430 | £7,430 | £8,359 | £8,359 | £8,359 | |
| Gross Margin % | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
| Expenses | |||||||||||||
| Payroll | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | |
| Sales and Marketing and Other Expenses | £4,610 | £1,610 | £610 | £1,610 | £610 | £1,610 | £610 | £1,610 | £610 | £1,610 | £610 | £1,610 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities (Telephone) | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance (Liability/Fire) | £0 | £0 | £1,500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent (Warehouse) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 13% | £253 | £253 | £253 | £253 | £253 | £253 | £253 | £253 | £253 | £253 | £253 | £253 |
| Agent Commission | 7% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £9,029 | £6,029 | £6,529 | £6,029 | £5,029 | £6,029 | £5,029 | £6,029 | £5,029 | £6,029 | £5,029 | £6,029 | |
| Profit Before Interest and Taxes | (£2,992) | £8 | (£492) | £8 | £1,473 | £473 | £1,473 | £1,401 | £2,401 | £2,330 | £3,330 | £2,330 | |
| EBITDA | (£2,992) | £8 | (£492) | £8 | £1,473 | £473 | £1,473 | £1,401 | £2,401 | £2,330 | £3,330 | £2,330 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£898) | £2 | (£123) | £2 | £368 | £118 | £368 | £350 | £600 | £583 | £833 | £583 | |
| Net Profit | (£2,094) | £6 | (£369) | £6 | £1,104 | £354 | £1,104 | £1,051 | £1,801 | £1,748 | £2,498 | £1,748 | |
| Net Profit/Sales | -20.81% | 0.06% | -3.67% | 0.06% | 10.19% | 3.27% | 10.19% | 8.49% | 14.54% | 12.54% | 17.93% | 12.54% | |
| Pro Forma Cash Flow | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £6,400 | £8,566 | £10,062 | £10,062 | £10,062 | £10,475 | £10,836 | £10,836 | £11,662 | £12,384 | £13,210 | £13,932 | |
| Subtotal Cash from Operations | £6,400 | £8,566 | £10,062 | £10,062 | £10,062 | £10,475 | £10,836 | £10,836 | £11,662 | £12,384 | £13,210 | £13,932 | |
| 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 | £5,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £21,000 | £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 | £32,400 | £8,566 | £10,062 | £10,062 | £10,062 | £10,475 | £10,836 | £10,836 | £11,662 | £12,384 | £13,210 | £13,932 | |
| Expenditures | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | £3,666 | |
| Bill Payments | £4,149 | £4,429 | £3,469 | £6,475 | £6,390 | £6,420 | £6,791 | £6,142 | £8,300 | £6,993 | £9,152 | £7,793 | |
| Subtotal Spent on Operations | £7,815 | £8,095 | £7,135 | £10,141 | £10,056 | £10,086 | £10,457 | £9,808 | £11,966 | £10,659 | £12,818 | £11,459 | |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| 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 | £8,815 | £9,095 | £8,135 | £11,141 | £11,056 | £11,086 | £11,457 | £10,808 | £12,966 | £11,659 | £13,818 | £12,459 | |
| Net Cash Flow | £23,585 | (£528) | £1,927 | (£1,079) | (£994) | (£611) | (£621) | £28 | (£1,305) | £725 | (£608) | £1,473 | |
| Cash Balance | £36,585 | £36,057 | £37,984 | £36,905 | £35,911 | £35,300 | £34,679 | £34,708 | £33,403 | £34,128 | £33,520 | £34,992 | |
| Pro Forma Balance Sheet | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £13,000 | £36,585 | £36,057 | £37,984 | £36,905 | £35,911 | £35,300 | £34,679 | £34,708 | £33,403 | £34,128 | £33,520 | £34,992 |
| Accounts Receivable | £9,600 | £13,262 | £14,758 | £14,758 | £14,758 | £15,532 | £15,893 | £15,893 | £17,441 | £18,163 | £19,711 | £20,434 | £20,434 |
| Inventory | £11,764 | £7,739 | £4,714 | £4,427 | £4,427 | £4,768 | £4,768 | £4,768 | £5,449 | £5,449 | £6,130 | £6,130 | £6,130 |
| Other Current Assets | £21,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £55,364 | £57,586 | £55,529 | £57,169 | £56,090 | £56,210 | £55,960 | £55,340 | £57,597 | £57,015 | £59,969 | £60,083 | £61,556 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Accumulated Depreciation | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £55,364 | £57,586 | £55,529 | £57,169 | £56,090 | £56,210 | £55,960 | £55,340 | £57,597 | £57,015 | £59,969 | £60,083 | £61,556 |
| Liabilities and Capital | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £4,000 | £4,317 | £3,253 | £6,262 | £6,177 | £6,193 | £6,588 | £5,863 | £8,070 | £6,686 | £8,893 | £7,509 | £8,234 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Subtotal Current Liabilities | £19,000 | £19,317 | £18,253 | £21,262 | £21,177 | £21,193 | £21,588 | £20,863 | £23,070 | £21,686 | £23,893 | £22,509 | £23,234 |
| Long-term Liabilities | £180,000 | £184,000 | £183,000 | £182,000 | £181,000 | £180,000 | £179,000 | £178,000 | £177,000 | £176,000 | £175,000 | £174,000 | £173,000 |
| Total Liabilities | £199,000 | £203,317 | £201,253 | £203,262 | £202,177 | £201,193 | £200,588 | £198,863 | £200,070 | £197,686 | £198,893 | £196,509 | £196,234 |
| Paid-in Capital | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Retained Earnings | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) | (£153,636) |
| Earnings | £0 | (£2,094) | (£2,088) | (£2,457) | (£2,451) | (£1,346) | (£992) | £113 | £1,164 | £2,965 | £4,712 | £7,210 | £8,958 |
| Total Capital | (£143,636) | (£145,730) | (£145,724) | (£146,093) | (£146,087) | (£144,982) | (£144,628) | (£143,523) | (£142,472) | (£140,671) | (£138,924) | (£136,426) | (£134,678) |
| Total Liabilities and Capital | £55,364 | £57,586 | £55,529 | £57,169 | £56,090 | £56,210 | £55,960 | £55,340 | £57,597 | £57,015 | £59,969 | £60,083 | £61,556 |
| Net Worth | (£143,636) | (£145,730) | (£145,724) | (£146,093) | (£146,087) | (£144,982) | (£144,628) | (£143,523) | (£142,472) | (£140,671) | (£138,924) | (£136,426) | (£134,678) |