| 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 | |||||||||||||
| Fishing Equipment | 0% | £1,730 | £1,730 | £2,730 | £4,000 | £2,730 | £7,166 | £16,000 | £16,000 | £16,000 | £8,000 | £2,730 | £4,000 |
| Guide Services | 0% | £0 | £0 | £1,000 | £4,500 | £0 | £3,740 | £7,480 | £8,460 | £7,480 | £4,740 | £0 | £0 |
| Drift Boat Rentals | 0% | £0 | £0 | £0 | £1,440 | £0 | £2,000 | £4,320 | £4,320 | £4,320 | £2,440 | £0 | £0 |
| Licenses | 0% | £0 | £0 | £0 | £5,400 | £0 | £200 | £5,400 | £5,400 | £5,400 | £5,000 | £0 | £0 |
| Lodging | 0% | £0 | £0 | £0 | £0 | £0 | £4,500 | £13,500 | £13,500 | £13,500 | £9,000 | £9,000 | £0 |
| Hunting Equipment | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £500 | £600 | £0 |
| Hunting Apparel | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £500 | £600 | £0 |
| Flies | 0% | £0 | £0 | £635 | £2,000 | £500 | £1,567 | £15,000 | £12,000 | £8,000 | £1,567 | £0 | £0 |
| Misc. | 0% | £0 | £0 | £0 | £0 | £0 | £400 | £600 | £600 | £600 | £300 | £200 | £0 |
| Total Sales | £1,730 | £1,730 | £4,365 | £17,340 | £3,230 | £19,573 | £62,300 | £60,280 | £55,800 | £32,047 | £13,130 | £4,000 | |
| 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 | |
| Fishing Equipment | £952 | £952 | £1,501 | £2,200 | £1,501 | £3,941 | £8,800 | £8,800 | £8,800 | £4,400 | £1,501 | £2,200 | |
| Lodging | 1% | £0 | £0 | £0 | £0 | £0 | £23 | £68 | £68 | £68 | £45 | £45 | £0 |
| Hunting Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £138 | £275 | £330 | £0 | |
| Hunting Apparel | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £138 | £275 | £330 | £0 | |
| Flies | £0 | £0 | £273 | £860 | £215 | £673 | £6,450 | £5,160 | £3,440 | £672 | £0 | £0 | |
| Misc | £0 | £0 | £0 | £0 | £0 | £160 | £240 | £240 | £240 | £120 | £80 | £0 | |
| Subtotal Direct Cost of Sales | £952 | £952 | £1,774 | £3,060 | £1,716 | £4,797 | £15,558 | £14,268 | £12,824 | £5,787 | £2,286 | £2,200 | |
| 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 | ||
| Owner Operator | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Cabin Manager (Brassie) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Part Time Employee | 0% | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £0 | £0 |
| Name or Title or Group | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | |
| Total Payroll | £1,300 | £1,300 | £1,300 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £1,300 | £1,300 | |
| 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 | £1,730 | £1,730 | £4,365 | £17,340 | £3,230 | £19,573 | £62,300 | £60,280 | £55,800 | £32,047 | £13,130 | £4,000 | |
| Direct Cost of Sales | £952 | £952 | £1,774 | £3,060 | £1,716 | £4,797 | £15,558 | £14,268 | £12,824 | £5,787 | £2,286 | £2,200 | |
| Independant Guide Cost | 60% | £0 | £0 | £0 | £2,700 | £0 | £2,244 | £4,488 | £5,076 | £4,488 | £2,844 | £0 | £0 |
| License Funds going back to state | £0 | £0 | £0 | £5,400 | £0 | £0 | £5,400 | £5,400 | £5,400 | £5,000 | £0 | £0 | |
| Credit Card Fees | 1% | £9 | £9 | £23 | £92 | £17 | £104 | £330 | £319 | £296 | £170 | £70 | £21 |
| Lodging - cleaning and maintenance | 32% | £0 | £0 | £0 | £0 | £0 | £1,440 | £4,320 | £4,320 | £4,320 | £2,880 | £2,880 | £0 |
| Total Cost of Sales | £961 | £961 | £1,797 | £11,252 | £1,733 | £8,584 | £30,096 | £29,383 | £27,327 | £16,681 | £5,236 | £2,221 | |
| Gross Margin | £769 | £769 | £2,568 | £6,088 | £1,497 | £10,989 | £32,204 | £30,897 | £28,473 | £15,366 | £7,894 | £1,779 | |
| Gross Margin % | 44.47% | 44.44% | 58.83% | 35.11% | 46.34% | 56.14% | 51.69% | 51.26% | 51.03% | 47.95% | 60.12% | 44.47% | |
| Expenses | |||||||||||||
| Payroll | £1,300 | £1,300 | £1,300 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £1,300 | £1,300 | |
| Marketing/Promotion | £1,500 | £1,500 | £1,000 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £1,000 | |
| Depreciation | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | |
| Utilities | £300 | £300 | £300 | £300 | £275 | £275 | £200 | £200 | £200 | £250 | £300 | £300 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | |
| Total Operating Expenses | £4,630 | £4,630 | £4,130 | £5,630 | £5,605 | £5,605 | £5,530 | £5,530 | £5,530 | £5,580 | £3,830 | £4,130 | |
| Profit Before Interest and Taxes | (£3,861) | (£3,861) | (£1,562) | £458 | (£4,108) | £5,384 | £26,674 | £25,367 | £22,943 | £9,786 | £4,064 | (£2,351) | |
| EBITDA | (£2,606) | (£2,606) | (£307) | £1,713 | (£2,853) | £6,639 | £27,929 | £26,622 | £24,198 | £11,041 | £5,319 | (£1,096) | |
| Interest Expense | £3,420 | £3,420 | £3,420 | £3,392 | £3,363 | £3,335 | £3,306 | £3,278 | £3,249 | £3,221 | £3,192 | £3,164 | |
| Taxes Incurred | (£2,184) | (£2,184) | (£1,495) | (£880) | (£2,241) | £615 | £7,010 | £6,627 | £5,908 | £1,970 | £262 | (£1,654) | |
| Net Profit | (£5,096) | (£5,097) | (£3,487) | (£2,053) | (£5,230) | £1,434 | £16,358 | £15,463 | £13,786 | £4,596 | £611 | (£3,860) | |
| Net Profit/Sales | -294.59% | -294.61% | -79.90% | -11.84% | -161.91% | 7.33% | 26.26% | 25.65% | 24.71% | 14.34% | 4.65% | -96.51% | |
| 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 | £1,730 | £1,730 | £4,365 | £17,340 | £3,230 | £19,573 | £62,300 | £60,280 | £55,800 | £32,047 | £13,130 | £4,000 | |
| Subtotal Cash from Operations | £1,730 | £1,730 | £4,365 | £17,340 | £3,230 | £19,573 | £62,300 | £60,280 | £55,800 | £32,047 | £13,130 | £4,000 | |
| 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 | £1,730 | £1,730 | £4,365 | £17,340 | £3,230 | £19,573 | £62,300 | £60,280 | £55,800 | £32,047 | £13,130 | £4,000 | |
| 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 | £1,300 | £1,300 | £1,300 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £1,300 | £1,300 | |
| Bill Payments | £111 | £3,320 | £3,327 | £3,805 | £11,659 | £2,609 | £9,555 | £26,035 | £26,150 | £24,585 | £19,321 | £75,193 | |
| Subtotal Spent on Operations | £1,411 | £4,620 | £4,627 | £6,905 | £14,759 | £5,709 | £12,655 | £29,135 | £29,250 | £27,685 | £20,621 | £76,493 | |
| 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 | £4,275 | £4,275 | £4,275 | £4,275 | £4,275 | £4,275 | £4,275 | £4,275 | £4,275 | |
| 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,411 | £4,620 | £4,627 | £11,180 | £19,034 | £9,984 | £16,930 | £33,410 | £33,525 | £31,960 | £24,896 | £80,768 | |
| Net Cash Flow | £319 | (£2,890) | (£262) | £6,160 | (£15,804) | £9,589 | £45,370 | £26,870 | £22,275 | £87 | (£11,766) | (£76,768) | |
| Cash Balance | £15,319 | £12,429 | £12,168 | £18,327 | £2,524 | £12,113 | £57,483 | £84,353 | £106,628 | £106,715 | £94,949 | £18,181 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £15,000 | £15,319 | £12,429 | £12,168 | £18,327 | £2,524 | £12,113 | £57,483 | £84,353 | £106,628 | £106,715 | £94,949 | £18,181 |
| Inventory | £98,000 | £97,049 | £96,097 | £94,323 | £91,263 | £89,547 | £84,750 | £69,193 | £54,925 | £42,102 | £36,315 | £104,029 | £101,829 |
| Other Current Assets | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 |
| Total Current Assets | £119,400 | £118,768 | £114,926 | £112,890 | £115,990 | £98,470 | £103,263 | £133,075 | £145,678 | £155,130 | £149,430 | £205,377 | £126,410 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 |
| Accumulated Depreciation | £0 | £1,255 | £2,510 | £3,765 | £5,020 | £6,275 | £7,530 | £8,785 | £10,040 | £11,295 | £12,550 | £13,805 | £15,060 |
| Total Long-term Assets | £452,400 | £451,145 | £449,890 | £448,635 | £447,380 | £446,125 | £444,870 | £443,615 | £442,360 | £441,105 | £439,850 | £438,595 | £437,340 |
| Total Assets | £571,800 | £569,913 | £564,816 | £561,525 | £563,370 | £544,595 | £548,133 | £576,690 | £588,038 | £596,235 | £589,280 | £643,972 | £563,750 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £3,209 | £3,209 | £3,406 | £11,579 | £2,309 | £8,687 | £25,162 | £25,322 | £24,008 | £16,732 | £75,089 | £3,002 |
| 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 | £3,209 | £3,209 | £3,406 | £11,579 | £2,309 | £8,687 | £25,162 | £25,322 | £24,008 | £16,732 | £75,089 | £3,002 |
| Long-term Liabilities | £513,000 | £513,000 | £513,000 | £513,000 | £508,725 | £504,450 | £500,175 | £495,900 | £491,625 | £487,350 | £483,075 | £478,800 | £474,525 |
| Total Liabilities | £513,000 | £516,209 | £516,209 | £516,406 | £520,304 | £506,759 | £508,862 | £521,062 | £516,947 | £511,358 | £499,807 | £553,889 | £477,527 |
| Paid-in Capital | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 |
| Retained Earnings | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) |
| Earnings | £0 | (£5,096) | (£10,193) | (£13,681) | (£15,734) | (£20,964) | (£19,529) | (£3,172) | £12,291 | £26,077 | £30,673 | £31,283 | £27,423 |
| Total Capital | £58,800 | £53,704 | £48,607 | £45,119 | £43,066 | £37,836 | £39,271 | £55,628 | £71,091 | £84,877 | £89,473 | £90,083 | £86,223 |
| Total Liabilities and Capital | £571,800 | £569,913 | £564,816 | £561,525 | £563,370 | £544,595 | £548,133 | £576,690 | £588,038 | £596,235 | £589,280 | £643,972 | £563,750 |
| Net Worth | £58,800 | £53,704 | £48,607 | £45,119 | £43,066 | £37,836 | £39,271 | £55,628 | £71,091 | £84,877 | £89,473 | £90,083 | £86,223 |
| 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 | |||||||||||||
| Fishing Equipment | 0% | £1,730 | £1,730 | £2,730 | £4,000 | £2,730 | £7,166 | £16,000 | £16,000 | £16,000 | £8,000 | £2,730 | £4,000 |
| Guide Services | 0% | £0 | £0 | £1,000 | £4,500 | £0 | £3,740 | £7,480 | £8,460 | £7,480 | £4,740 | £0 | £0 |
| Drift Boat Rentals | 0% | £0 | £0 | £0 | £1,440 | £0 | £2,000 | £4,320 | £4,320 | £4,320 | £2,440 | £0 | £0 |
| Licenses | 0% | £0 | £0 | £0 | £5,400 | £0 | £200 | £5,400 | £5,400 | £5,400 | £5,000 | £0 | £0 |
| Lodging | 0% | £0 | £0 | £0 | £0 | £0 | £4,500 | £13,500 | £13,500 | £13,500 | £9,000 | £9,000 | £0 |
| Hunting Equipment | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £500 | £600 | £0 |
| Hunting Apparel | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £500 | £600 | £0 |
| Flies | 0% | £0 | £0 | £635 | £2,000 | £500 | £1,567 | £15,000 | £12,000 | £8,000 | £1,567 | £0 | £0 |
| Misc. | 0% | £0 | £0 | £0 | £0 | £0 | £400 | £600 | £600 | £600 | £300 | £200 | £0 |
| Total Sales | £1,730 | £1,730 | £4,365 | £17,340 | £3,230 | £19,573 | £62,300 | £60,280 | £55,800 | £32,047 | £13,130 | £4,000 | |
| 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 | |
| Fishing Equipment | £952 | £952 | £1,501 | £2,200 | £1,501 | £3,941 | £8,800 | £8,800 | £8,800 | £4,400 | £1,501 | £2,200 | |
| Lodging | 1% | £0 | £0 | £0 | £0 | £0 | £23 | £68 | £68 | £68 | £45 | £45 | £0 |
| Hunting Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £138 | £275 | £330 | £0 | |
| Hunting Apparel | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £138 | £275 | £330 | £0 | |
| Flies | £0 | £0 | £273 | £860 | £215 | £673 | £6,450 | £5,160 | £3,440 | £672 | £0 | £0 | |
| Misc | £0 | £0 | £0 | £0 | £0 | £160 | £240 | £240 | £240 | £120 | £80 | £0 | |
| Subtotal Direct Cost of Sales | £952 | £952 | £1,774 | £3,060 | £1,716 | £4,797 | £15,558 | £14,268 | £12,824 | £5,787 | £2,286 | £2,200 | |
| 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 | ||
| Owner Operator | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Cabin Manager (Brassie) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Part Time Employee | 0% | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £0 | £0 |
| Name or Title or Group | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | |
| Total Payroll | £1,300 | £1,300 | £1,300 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £1,300 | £1,300 | |
| 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 | £1,730 | £1,730 | £4,365 | £17,340 | £3,230 | £19,573 | £62,300 | £60,280 | £55,800 | £32,047 | £13,130 | £4,000 | |
| Direct Cost of Sales | £952 | £952 | £1,774 | £3,060 | £1,716 | £4,797 | £15,558 | £14,268 | £12,824 | £5,787 | £2,286 | £2,200 | |
| Independant Guide Cost | 60% | £0 | £0 | £0 | £2,700 | £0 | £2,244 | £4,488 | £5,076 | £4,488 | £2,844 | £0 | £0 |
| License Funds going back to state | £0 | £0 | £0 | £5,400 | £0 | £0 | £5,400 | £5,400 | £5,400 | £5,000 | £0 | £0 | |
| Credit Card Fees | 1% | £9 | £9 | £23 | £92 | £17 | £104 | £330 | £319 | £296 | £170 | £70 | £21 |
| Lodging - cleaning and maintenance | 32% | £0 | £0 | £0 | £0 | £0 | £1,440 | £4,320 | £4,320 | £4,320 | £2,880 | £2,880 | £0 |
| Total Cost of Sales | £961 | £961 | £1,797 | £11,252 | £1,733 | £8,584 | £30,096 | £29,383 | £27,327 | £16,681 | £5,236 | £2,221 | |
| Gross Margin | £769 | £769 | £2,568 | £6,088 | £1,497 | £10,989 | £32,204 | £30,897 | £28,473 | £15,366 | £7,894 | £1,779 | |
| Gross Margin % | 44.47% | 44.44% | 58.83% | 35.11% | 46.34% | 56.14% | 51.69% | 51.26% | 51.03% | 47.95% | 60.12% | 44.47% | |
| Expenses | |||||||||||||
| Payroll | £1,300 | £1,300 | £1,300 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £1,300 | £1,300 | |
| Marketing/Promotion | £1,500 | £1,500 | £1,000 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £1,000 | |
| Depreciation | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | £1,255 | |
| Utilities | £300 | £300 | £300 | £300 | £275 | £275 | £200 | £200 | £200 | £250 | £300 | £300 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | £75 | |
| Total Operating Expenses | £4,630 | £4,630 | £4,130 | £5,630 | £5,605 | £5,605 | £5,530 | £5,530 | £5,530 | £5,580 | £3,830 | £4,130 | |
| Profit Before Interest and Taxes | (£3,861) | (£3,861) | (£1,562) | £458 | (£4,108) | £5,384 | £26,674 | £25,367 | £22,943 | £9,786 | £4,064 | (£2,351) | |
| EBITDA | (£2,606) | (£2,606) | (£307) | £1,713 | (£2,853) | £6,639 | £27,929 | £26,622 | £24,198 | £11,041 | £5,319 | (£1,096) | |
| Interest Expense | £3,420 | £3,420 | £3,420 | £3,392 | £3,363 | £3,335 | £3,306 | £3,278 | £3,249 | £3,221 | £3,192 | £3,164 | |
| Taxes Incurred | (£2,184) | (£2,184) | (£1,495) | (£880) | (£2,241) | £615 | £7,010 | £6,627 | £5,908 | £1,970 | £262 | (£1,654) | |
| Net Profit | (£5,096) | (£5,097) | (£3,487) | (£2,053) | (£5,230) | £1,434 | £16,358 | £15,463 | £13,786 | £4,596 | £611 | (£3,860) | |
| Net Profit/Sales | -294.59% | -294.61% | -79.90% | -11.84% | -161.91% | 7.33% | 26.26% | 25.65% | 24.71% | 14.34% | 4.65% | -96.51% | |
| 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 | £1,730 | £1,730 | £4,365 | £17,340 | £3,230 | £19,573 | £62,300 | £60,280 | £55,800 | £32,047 | £13,130 | £4,000 | |
| Subtotal Cash from Operations | £1,730 | £1,730 | £4,365 | £17,340 | £3,230 | £19,573 | £62,300 | £60,280 | £55,800 | £32,047 | £13,130 | £4,000 | |
| 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 | £1,730 | £1,730 | £4,365 | £17,340 | £3,230 | £19,573 | £62,300 | £60,280 | £55,800 | £32,047 | £13,130 | £4,000 | |
| 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 | £1,300 | £1,300 | £1,300 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £3,100 | £1,300 | £1,300 | |
| Bill Payments | £111 | £3,320 | £3,327 | £3,805 | £11,659 | £2,609 | £9,555 | £26,035 | £26,150 | £24,585 | £19,321 | £75,193 | |
| Subtotal Spent on Operations | £1,411 | £4,620 | £4,627 | £6,905 | £14,759 | £5,709 | £12,655 | £29,135 | £29,250 | £27,685 | £20,621 | £76,493 | |
| 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 | £4,275 | £4,275 | £4,275 | £4,275 | £4,275 | £4,275 | £4,275 | £4,275 | £4,275 | |
| 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,411 | £4,620 | £4,627 | £11,180 | £19,034 | £9,984 | £16,930 | £33,410 | £33,525 | £31,960 | £24,896 | £80,768 | |
| Net Cash Flow | £319 | (£2,890) | (£262) | £6,160 | (£15,804) | £9,589 | £45,370 | £26,870 | £22,275 | £87 | (£11,766) | (£76,768) | |
| Cash Balance | £15,319 | £12,429 | £12,168 | £18,327 | £2,524 | £12,113 | £57,483 | £84,353 | £106,628 | £106,715 | £94,949 | £18,181 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £15,000 | £15,319 | £12,429 | £12,168 | £18,327 | £2,524 | £12,113 | £57,483 | £84,353 | £106,628 | £106,715 | £94,949 | £18,181 |
| Inventory | £98,000 | £97,049 | £96,097 | £94,323 | £91,263 | £89,547 | £84,750 | £69,193 | £54,925 | £42,102 | £36,315 | £104,029 | £101,829 |
| Other Current Assets | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 | £6,400 |
| Total Current Assets | £119,400 | £118,768 | £114,926 | £112,890 | £115,990 | £98,470 | £103,263 | £133,075 | £145,678 | £155,130 | £149,430 | £205,377 | £126,410 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 | £452,400 |
| Accumulated Depreciation | £0 | £1,255 | £2,510 | £3,765 | £5,020 | £6,275 | £7,530 | £8,785 | £10,040 | £11,295 | £12,550 | £13,805 | £15,060 |
| Total Long-term Assets | £452,400 | £451,145 | £449,890 | £448,635 | £447,380 | £446,125 | £444,870 | £443,615 | £442,360 | £441,105 | £439,850 | £438,595 | £437,340 |
| Total Assets | £571,800 | £569,913 | £564,816 | £561,525 | £563,370 | £544,595 | £548,133 | £576,690 | £588,038 | £596,235 | £589,280 | £643,972 | £563,750 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £3,209 | £3,209 | £3,406 | £11,579 | £2,309 | £8,687 | £25,162 | £25,322 | £24,008 | £16,732 | £75,089 | £3,002 |
| 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 | £3,209 | £3,209 | £3,406 | £11,579 | £2,309 | £8,687 | £25,162 | £25,322 | £24,008 | £16,732 | £75,089 | £3,002 |
| Long-term Liabilities | £513,000 | £513,000 | £513,000 | £513,000 | £508,725 | £504,450 | £500,175 | £495,900 | £491,625 | £487,350 | £483,075 | £478,800 | £474,525 |
| Total Liabilities | £513,000 | £516,209 | £516,209 | £516,406 | £520,304 | £506,759 | £508,862 | £521,062 | £516,947 | £511,358 | £499,807 | £553,889 | £477,527 |
| Paid-in Capital | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 | £64,000 |
| Retained Earnings | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) | (£5,200) |
| Earnings | £0 | (£5,096) | (£10,193) | (£13,681) | (£15,734) | (£20,964) | (£19,529) | (£3,172) | £12,291 | £26,077 | £30,673 | £31,283 | £27,423 |
| Total Capital | £58,800 | £53,704 | £48,607 | £45,119 | £43,066 | £37,836 | £39,271 | £55,628 | £71,091 | £84,877 | £89,473 | £90,083 | £86,223 |
| Total Liabilities and Capital | £571,800 | £569,913 | £564,816 | £561,525 | £563,370 | £544,595 | £548,133 | £576,690 | £588,038 | £596,235 | £589,280 | £643,972 | £563,750 |
| Net Worth | £58,800 | £53,704 | £48,607 | £45,119 | £43,066 | £37,836 | £39,271 | £55,628 | £71,091 | £84,877 | £89,473 | £90,083 | £86,223 |