| 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 | |||||||||||||
| Sporting Goods Sales | 0% | £83,709 | £131,575 | £108,300 | £223,300 | £385,600 | £322,100 | £238,450 | £239,400 | £169,100 | £139,175 | £144,400 | £103,075 |
| Shipping Income | 0% | £4,406 | £6,925 | £5,700 | £11,700 | £20,320 | £16,900 | £12,550 | £12,600 | £8,900 | £7,325 | £7,600 | £5,425 |
| Total Sales | £88,115 | £138,500 | £114,000 | £235,000 | £405,920 | £339,000 | £251,000 | £252,000 | £178,000 | £146,500 | £152,000 | £108,500 | |
| 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 | |
| Cost of Goods Sold | £66,086 | £103,875 | £85,500 | £176,250 | £304,500 | £254,250 | £188,250 | £189,000 | £133,500 | £109,875 | £114,000 | £81,375 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £66,086 | £103,875 | £85,500 | £176,250 | £304,500 | £254,250 | £188,250 | £189,000 | £133,500 | £109,875 | £114,000 | £81,375 | |
| 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 | ||
| Warehouse/Shipping & Receiving Manager | 0% | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,924 |
| Warehouse/Shipping & Receiving Clerk | 0% | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,563 |
| Warehouse/Shipping & Receiving Clerk | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Warehouse/Shipping & Receiving Clerk | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accounting | 0% | £1,916 | £1,916 | £958 | £958 | £958 | £958 | £958 | £958 | £958 | £958 | £958 | £958 |
| Retail Phone / Accounting Assistant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Internet Phone Sales | 0% | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,413 |
| Internet Phone Sales | 0% | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,413 |
| Internet Phone Sales | 0% | £1,417 | £1,417 | £709 | £709 | £709 | £709 | £709 | £709 | £709 | £709 | £709 | £709 |
| Internet Phone Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Internet Phone Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Internet Phone Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retail Sales PT | 0% | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £212 |
| Retail Sales PT | 0% | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £212 |
| Retail Sales PT | 0% | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £212 | £208 |
| Retail Sales PT | 0% | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £212 | £208 | £208 | £208 |
| Retail Sales PT | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retail Sales PT | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retail Sales PT | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retail Sales PT | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Store Manager | 0% | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Store Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Team Sales Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Team Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Team Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| President & CEO | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total People | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | |
| Total Payroll | £15,482 | £15,482 | £16,316 | £16,316 | £16,316 | £16,316 | £16,316 | £16,316 | £16,320 | £16,316 | £16,320 | £16,320 | |
| 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 | £88,115 | £138,500 | £114,000 | £235,000 | £405,920 | £339,000 | £251,000 | £252,000 | £178,000 | £146,500 | £152,000 | £108,500 | |
| Direct Cost of Sales | £66,086 | £103,875 | £85,500 | £176,250 | £304,500 | £254,250 | £188,250 | £189,000 | £133,500 | £109,875 | £114,000 | £81,375 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £66,086 | £103,875 | £85,500 | £176,250 | £304,500 | £254,250 | £188,250 | £189,000 | £133,500 | £109,875 | £114,000 | £81,375 | |
| Gross Margin | £22,029 | £34,625 | £28,500 | £58,750 | £101,420 | £84,750 | £62,750 | £63,000 | £44,500 | £36,625 | £38,000 | £27,125 | |
| Gross Margin % | 25.00% | 25.00% | 25.00% | 25.00% | 24.99% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Expenses | |||||||||||||
| Payroll | £15,482 | £15,482 | £16,316 | £16,316 | £16,316 | £16,316 | £16,316 | £16,316 | £16,320 | £16,316 | £16,320 | £16,320 | |
| Marketing/Promotion | £1,500 | £2,000 | £500 | £2,500 | £2,500 | £2,500 | £1,500 | £1,500 | £5,000 | £2,500 | £1,500 | £1,500 | |
| Depreciation | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Rent | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Utilities | £720 | £740 | £820 | £840 | £930 | £840 | £750 | £720 | £800 | £1,600 | £1,600 | £1,600 | |
| Insurance | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | |
| Bad Checks | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Bank Card Debit & Service Fees | £1,789 | £2,812 | £2,314 | £4,770 | £8,242 | £6,882 | £5,095 | £5,116 | £3,613 | £2,974 | £3,086 | £2,203 | |
| Repairs and Maintenance | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | |
| Taxes and Licenses | £2,000 | £0 | £0 | £0 | £0 | £2,000 | £0 | £0 | £2,000 | £0 | £0 | £2,000 | |
| Freight In | £2,900 | £2,200 | £1,580 | £510 | £1,700 | £1,200 | £700 | £575 | £400 | £400 | £500 | £400 | |
| Interest Expense | £3,208 | £3,188 | £3,168 | £3,148 | £3,127 | £3,107 | £3,086 | £3,066 | £3,045 | £3,024 | £3,003 | £2,982 | |
| Janitorial Supplies | £33 | £33 | £33 | £33 | £33 | £33 | £33 | £33 | £33 | £33 | £33 | £33 | |
| Legal/Professional Fees | £500 | £170 | £170 | £170 | £1,000 | £170 | £170 | £170 | £170 | £1,000 | £170 | £170 | |
| Travel & Entertainment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £0 | £0 | £0 | £0 | |
| Membership Dues & Sub | £200 | £0 | £200 | £0 | £0 | £0 | £0 | £0 | £500 | £0 | £0 | £0 | |
| Office Supplies | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Personal Property Tax | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £0 | £0 | £0 | £0 | £0 | |
| Security | £500 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Internet Services | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| WEB Page Services | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £500 | £500 | £500 | £500 | |
| Postage | 15% | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 |
| Telephone | £800 | £1,500 | £1,200 | £2,000 | £2,500 | £3,000 | £2,500 | £1,800 | £1,700 | £1,200 | £1,000 | £800 | |
| Total Operating Expenses | £36,362 | £34,905 | £33,081 | £37,067 | £43,128 | £42,828 | £37,180 | £38,076 | £40,611 | £36,077 | £34,242 | £35,038 | |
| Profit Before Interest and Taxes | (£14,133) | (£80) | (£4,381) | £21,883 | £58,492 | £42,122 | £25,770 | £25,124 | £4,089 | £748 | £3,958 | (£7,713) | |
| EBITDA | (£13,883) | £170 | (£4,131) | £22,133 | £58,742 | £42,372 | £26,020 | £25,374 | £4,339 | £998 | £4,208 | (£7,463) | |
| Interest Expense | £6,133 | £6,096 | £6,059 | £6,022 | £5,985 | £5,947 | £5,910 | £5,872 | £5,834 | £5,796 | £5,758 | £5,719 | |
| Taxes Incurred | (£6,080) | (£1,853) | (£3,132) | £4,758 | £15,752 | £10,852 | £5,958 | £5,776 | (£523) | (£1,514) | (£540) | (£4,030) | |
| Other Income | |||||||||||||
| Interest Income | £160 | £160 | £160 | £160 | £160 | £160 | £160 | £160 | £160 | £160 | £160 | £160 | |
| Miscellaneous Income | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | |
| Purchase Discounts Taken | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Income | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Other Expense | |||||||||||||
| Other Expense Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Expense Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Other Income | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Net Profit | (£14,186) | (£4,323) | (£7,308) | £11,103 | £36,755 | £25,322 | £13,902 | £13,477 | (£1,221) | (£3,533) | (£1,260) | (£9,402) | |
| Net Profit/Sales | -16.10% | -3.12% | -6.41% | 4.72% | 9.05% | 7.47% | 5.54% | 5.35% | -0.69% | -2.41% | -0.83% | -8.67% | |
| 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 | £86,353 | £135,730 | £111,720 | £230,300 | £397,802 | £332,220 | £245,980 | £246,960 | £174,440 | £143,570 | £148,960 | £106,330 | |
| Subtotal Cash from Operations | £86,411 | £137,526 | £114,474 | £232,661 | £402,616 | £340,294 | £252,701 | £251,981 | £179,431 | £147,109 | £151,894 | £109,341 | |
| 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 | £86,611 | £137,726 | £114,674 | £232,861 | £402,816 | £340,494 | £252,901 | £252,181 | £179,631 | £147,309 | £152,094 | £109,541 | |
| 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 | £15,482 | £15,482 | £16,316 | £16,316 | £16,316 | £16,316 | £16,316 | £16,316 | £16,320 | £16,316 | £16,320 | £16,320 | |
| Bill Payments | £689 | £20,774 | £23,284 | £27,727 | £287,919 | £845,041 | £236,042 | £32,504 | £33,031 | £29,166 | £30,429 | £216,132 | |
| Subtotal Spent on Operations | £16,171 | £36,256 | £39,600 | £44,043 | £304,235 | £861,357 | £252,358 | £48,820 | £49,351 | £45,482 | £46,749 | £232,452 | |
| 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 | £4,389 | £4,409 | £4,429 | £4,449 | £4,470 | £4,490 | £4,511 | £4,531 | £4,552 | £4,573 | £4,594 | £4,615 | |
| 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 | £20,560 | £40,665 | £44,029 | £48,492 | £308,705 | £865,847 | £256,869 | £53,351 | £53,903 | £50,055 | £51,343 | £237,067 | |
| Net Cash Flow | £66,051 | £97,061 | £70,645 | £184,369 | £94,110 | (£525,353) | (£3,968) | £198,829 | £125,728 | £97,254 | £100,751 | (£127,526) | |
| Cash Balance | £116,051 | £213,112 | £283,757 | £468,126 | £562,236 | £36,883 | £32,915 | £231,744 | £357,472 | £454,726 | £555,477 | £427,951 | |
| 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 | £50,000 | £116,051 | £213,112 | £283,757 | £468,126 | £562,236 | £36,883 | £32,915 | £231,744 | £357,472 | £454,726 | £555,477 | £427,951 |
| Accounts Receivable | £0 | £1,704 | £2,678 | £2,204 | £4,543 | £7,848 | £6,554 | £4,853 | £4,872 | £3,441 | £2,832 | £2,939 | £2,098 |
| Inventory | £900,000 | £833,914 | £730,039 | £644,539 | £705,000 | £1,218,000 | £1,163,750 | £975,500 | £786,500 | £653,000 | £543,125 | £629,125 | £547,750 |
| Other Current Assets | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Total Current Assets | £975,000 | £976,669 | £970,829 | £955,500 | £1,202,669 | £1,813,084 | £1,232,187 | £1,038,268 | £1,048,116 | £1,038,914 | £1,025,684 | £1,212,541 | £1,002,799 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Accumulated Depreciation | £0 | £250 | £500 | £750 | £1,000 | £1,250 | £1,500 | £1,750 | £2,000 | £2,250 | £2,500 | £2,750 | £3,000 |
| Total Long-term Assets | £25,000 | £24,750 | £24,500 | £24,250 | £24,000 | £23,750 | £23,500 | £23,250 | £23,000 | £22,750 | £22,500 | £22,250 | £22,000 |
| Total Assets | £1,000,000 | £1,001,419 | £995,329 | £979,750 | £1,226,669 | £1,836,834 | £1,255,687 | £1,061,518 | £1,071,116 | £1,061,664 | £1,048,184 | £1,234,791 | £1,024,799 |
| 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 | £19,993 | £22,636 | £18,794 | £259,059 | £836,939 | £234,960 | £31,399 | £32,052 | £28,373 | £22,999 | £215,460 | £19,486 |
| 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 | £19,993 | £22,636 | £18,794 | £259,059 | £836,939 | £234,960 | £31,399 | £32,052 | £28,373 | £22,999 | £215,460 | £19,486 |
| Long-term Liabilities | £740,300 | £735,911 | £731,502 | £727,073 | £722,624 | £718,154 | £713,664 | £709,153 | £704,622 | £700,070 | £695,497 | £690,903 | £686,288 |
| Total Liabilities | £740,300 | £755,904 | £754,138 | £745,867 | £981,683 | £1,555,093 | £948,624 | £740,552 | £736,674 | £728,443 | £718,496 | £906,363 | £705,774 |
| Paid-in Capital | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 |
| Retained Earnings | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) |
| Earnings | £0 | (£14,186) | (£18,509) | (£25,817) | (£14,714) | £22,041 | £47,363 | £61,266 | £74,742 | £73,521 | £69,987 | £68,728 | £59,325 |
| Total Capital | £259,700 | £245,514 | £241,191 | £233,883 | £244,986 | £281,741 | £307,063 | £320,966 | £334,442 | £333,221 | £329,687 | £328,428 | £319,025 |
| Total Liabilities and Capital | £1,000,000 | £1,001,419 | £995,329 | £979,750 | £1,226,669 | £1,836,834 | £1,255,687 | £1,061,518 | £1,071,116 | £1,061,664 | £1,048,184 | £1,234,791 | £1,024,799 |
| Net Worth | £259,700 | £245,514 | £241,191 | £233,883 | £244,986 | £281,741 | £307,063 | £320,966 | £334,442 | £333,221 | £329,687 | £328,428 | £319,025 |
| 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 | |||||||||||||
| Sporting Goods Sales | 0% | £83,709 | £131,575 | £108,300 | £223,300 | £385,600 | £322,100 | £238,450 | £239,400 | £169,100 | £139,175 | £144,400 | £103,075 |
| Shipping Income | 0% | £4,406 | £6,925 | £5,700 | £11,700 | £20,320 | £16,900 | £12,550 | £12,600 | £8,900 | £7,325 | £7,600 | £5,425 |
| Total Sales | £88,115 | £138,500 | £114,000 | £235,000 | £405,920 | £339,000 | £251,000 | £252,000 | £178,000 | £146,500 | £152,000 | £108,500 | |
| 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 | |
| Cost of Goods Sold | £66,086 | £103,875 | £85,500 | £176,250 | £304,500 | £254,250 | £188,250 | £189,000 | £133,500 | £109,875 | £114,000 | £81,375 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £66,086 | £103,875 | £85,500 | £176,250 | £304,500 | £254,250 | £188,250 | £189,000 | £133,500 | £109,875 | £114,000 | £81,375 | |
| 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 | ||
| Warehouse/Shipping & Receiving Manager | 0% | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,916 | £1,924 |
| Warehouse/Shipping & Receiving Clerk | 0% | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,567 | £1,563 |
| Warehouse/Shipping & Receiving Clerk | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Warehouse/Shipping & Receiving Clerk | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accounting | 0% | £1,916 | £1,916 | £958 | £958 | £958 | £958 | £958 | £958 | £958 | £958 | £958 | £958 |
| Retail Phone / Accounting Assistant | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Internet Phone Sales | 0% | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,413 |
| Internet Phone Sales | 0% | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,413 |
| Internet Phone Sales | 0% | £1,417 | £1,417 | £709 | £709 | £709 | £709 | £709 | £709 | £709 | £709 | £709 | £709 |
| Internet Phone Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Internet Phone Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Internet Phone Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retail Sales PT | 0% | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £212 |
| Retail Sales PT | 0% | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £212 |
| Retail Sales PT | 0% | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £212 | £208 |
| Retail Sales PT | 0% | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £212 | £208 | £208 | £208 |
| Retail Sales PT | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retail Sales PT | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retail Sales PT | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retail Sales PT | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Store Manager | 0% | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Store Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Team Sales Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Team Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Team Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| President & CEO | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total People | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | |
| Total Payroll | £15,482 | £15,482 | £16,316 | £16,316 | £16,316 | £16,316 | £16,316 | £16,316 | £16,320 | £16,316 | £16,320 | £16,320 | |
| 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 | £88,115 | £138,500 | £114,000 | £235,000 | £405,920 | £339,000 | £251,000 | £252,000 | £178,000 | £146,500 | £152,000 | £108,500 | |
| Direct Cost of Sales | £66,086 | £103,875 | £85,500 | £176,250 | £304,500 | £254,250 | £188,250 | £189,000 | £133,500 | £109,875 | £114,000 | £81,375 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £66,086 | £103,875 | £85,500 | £176,250 | £304,500 | £254,250 | £188,250 | £189,000 | £133,500 | £109,875 | £114,000 | £81,375 | |
| Gross Margin | £22,029 | £34,625 | £28,500 | £58,750 | £101,420 | £84,750 | £62,750 | £63,000 | £44,500 | £36,625 | £38,000 | £27,125 | |
| Gross Margin % | 25.00% | 25.00% | 25.00% | 25.00% | 24.99% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Expenses | |||||||||||||
| Payroll | £15,482 | £15,482 | £16,316 | £16,316 | £16,316 | £16,316 | £16,316 | £16,316 | £16,320 | £16,316 | £16,320 | £16,320 | |
| Marketing/Promotion | £1,500 | £2,000 | £500 | £2,500 | £2,500 | £2,500 | £1,500 | £1,500 | £5,000 | £2,500 | £1,500 | £1,500 | |
| Depreciation | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Rent | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Utilities | £720 | £740 | £820 | £840 | £930 | £840 | £750 | £720 | £800 | £1,600 | £1,600 | £1,600 | |
| Insurance | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | |
| Bad Checks | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Bank Card Debit & Service Fees | £1,789 | £2,812 | £2,314 | £4,770 | £8,242 | £6,882 | £5,095 | £5,116 | £3,613 | £2,974 | £3,086 | £2,203 | |
| Repairs and Maintenance | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | £330 | |
| Taxes and Licenses | £2,000 | £0 | £0 | £0 | £0 | £2,000 | £0 | £0 | £2,000 | £0 | £0 | £2,000 | |
| Freight In | £2,900 | £2,200 | £1,580 | £510 | £1,700 | £1,200 | £700 | £575 | £400 | £400 | £500 | £400 | |
| Interest Expense | £3,208 | £3,188 | £3,168 | £3,148 | £3,127 | £3,107 | £3,086 | £3,066 | £3,045 | £3,024 | £3,003 | £2,982 | |
| Janitorial Supplies | £33 | £33 | £33 | £33 | £33 | £33 | £33 | £33 | £33 | £33 | £33 | £33 | |
| Legal/Professional Fees | £500 | £170 | £170 | £170 | £1,000 | £170 | £170 | £170 | £170 | £1,000 | £170 | £170 | |
| Travel & Entertainment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £0 | £0 | £0 | £0 | |
| Membership Dues & Sub | £200 | £0 | £200 | £0 | £0 | £0 | £0 | £0 | £500 | £0 | £0 | £0 | |
| Office Supplies | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Personal Property Tax | £0 | £0 | £0 | £0 | £0 | £0 | £250 | £0 | £0 | £0 | £0 | £0 | |
| Security | £500 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Internet Services | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| WEB Page Services | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £500 | £500 | £500 | £500 | |
| Postage | 15% | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 |
| Telephone | £800 | £1,500 | £1,200 | £2,000 | £2,500 | £3,000 | £2,500 | £1,800 | £1,700 | £1,200 | £1,000 | £800 | |
| Total Operating Expenses | £36,362 | £34,905 | £33,081 | £37,067 | £43,128 | £42,828 | £37,180 | £38,076 | £40,611 | £36,077 | £34,242 | £35,038 | |
| Profit Before Interest and Taxes | (£14,133) | (£80) | (£4,381) | £21,883 | £58,492 | £42,122 | £25,770 | £25,124 | £4,089 | £748 | £3,958 | (£7,713) | |
| EBITDA | (£13,883) | £170 | (£4,131) | £22,133 | £58,742 | £42,372 | £26,020 | £25,374 | £4,339 | £998 | £4,208 | (£7,463) | |
| Interest Expense | £6,133 | £6,096 | £6,059 | £6,022 | £5,985 | £5,947 | £5,910 | £5,872 | £5,834 | £5,796 | £5,758 | £5,719 | |
| Taxes Incurred | (£6,080) | (£1,853) | (£3,132) | £4,758 | £15,752 | £10,852 | £5,958 | £5,776 | (£523) | (£1,514) | (£540) | (£4,030) | |
| Other Income | |||||||||||||
| Interest Income | £160 | £160 | £160 | £160 | £160 | £160 | £160 | £160 | £160 | £160 | £160 | £160 | |
| Miscellaneous Income | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | |
| Purchase Discounts Taken | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Income | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Other Expense | |||||||||||||
| Other Expense Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Expense Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Other Income | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Net Profit | (£14,186) | (£4,323) | (£7,308) | £11,103 | £36,755 | £25,322 | £13,902 | £13,477 | (£1,221) | (£3,533) | (£1,260) | (£9,402) | |
| Net Profit/Sales | -16.10% | -3.12% | -6.41% | 4.72% | 9.05% | 7.47% | 5.54% | 5.35% | -0.69% | -2.41% | -0.83% | -8.67% | |
| 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 | £86,353 | £135,730 | £111,720 | £230,300 | £397,802 | £332,220 | £245,980 | £246,960 | £174,440 | £143,570 | £148,960 | £106,330 | |
| Subtotal Cash from Operations | £86,411 | £137,526 | £114,474 | £232,661 | £402,616 | £340,294 | £252,701 | £251,981 | £179,431 | £147,109 | £151,894 | £109,341 | |
| 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 | £86,611 | £137,726 | £114,674 | £232,861 | £402,816 | £340,494 | £252,901 | £252,181 | £179,631 | £147,309 | £152,094 | £109,541 | |
| 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 | £15,482 | £15,482 | £16,316 | £16,316 | £16,316 | £16,316 | £16,316 | £16,316 | £16,320 | £16,316 | £16,320 | £16,320 | |
| Bill Payments | £689 | £20,774 | £23,284 | £27,727 | £287,919 | £845,041 | £236,042 | £32,504 | £33,031 | £29,166 | £30,429 | £216,132 | |
| Subtotal Spent on Operations | £16,171 | £36,256 | £39,600 | £44,043 | £304,235 | £861,357 | £252,358 | £48,820 | £49,351 | £45,482 | £46,749 | £232,452 | |
| 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 | £4,389 | £4,409 | £4,429 | £4,449 | £4,470 | £4,490 | £4,511 | £4,531 | £4,552 | £4,573 | £4,594 | £4,615 | |
| 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 | £20,560 | £40,665 | £44,029 | £48,492 | £308,705 | £865,847 | £256,869 | £53,351 | £53,903 | £50,055 | £51,343 | £237,067 | |
| Net Cash Flow | £66,051 | £97,061 | £70,645 | £184,369 | £94,110 | (£525,353) | (£3,968) | £198,829 | £125,728 | £97,254 | £100,751 | (£127,526) | |
| Cash Balance | £116,051 | £213,112 | £283,757 | £468,126 | £562,236 | £36,883 | £32,915 | £231,744 | £357,472 | £454,726 | £555,477 | £427,951 | |
| 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 | £50,000 | £116,051 | £213,112 | £283,757 | £468,126 | £562,236 | £36,883 | £32,915 | £231,744 | £357,472 | £454,726 | £555,477 | £427,951 |
| Accounts Receivable | £0 | £1,704 | £2,678 | £2,204 | £4,543 | £7,848 | £6,554 | £4,853 | £4,872 | £3,441 | £2,832 | £2,939 | £2,098 |
| Inventory | £900,000 | £833,914 | £730,039 | £644,539 | £705,000 | £1,218,000 | £1,163,750 | £975,500 | £786,500 | £653,000 | £543,125 | £629,125 | £547,750 |
| Other Current Assets | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Total Current Assets | £975,000 | £976,669 | £970,829 | £955,500 | £1,202,669 | £1,813,084 | £1,232,187 | £1,038,268 | £1,048,116 | £1,038,914 | £1,025,684 | £1,212,541 | £1,002,799 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Accumulated Depreciation | £0 | £250 | £500 | £750 | £1,000 | £1,250 | £1,500 | £1,750 | £2,000 | £2,250 | £2,500 | £2,750 | £3,000 |
| Total Long-term Assets | £25,000 | £24,750 | £24,500 | £24,250 | £24,000 | £23,750 | £23,500 | £23,250 | £23,000 | £22,750 | £22,500 | £22,250 | £22,000 |
| Total Assets | £1,000,000 | £1,001,419 | £995,329 | £979,750 | £1,226,669 | £1,836,834 | £1,255,687 | £1,061,518 | £1,071,116 | £1,061,664 | £1,048,184 | £1,234,791 | £1,024,799 |
| 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 | £19,993 | £22,636 | £18,794 | £259,059 | £836,939 | £234,960 | £31,399 | £32,052 | £28,373 | £22,999 | £215,460 | £19,486 |
| 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 | £19,993 | £22,636 | £18,794 | £259,059 | £836,939 | £234,960 | £31,399 | £32,052 | £28,373 | £22,999 | £215,460 | £19,486 |
| Long-term Liabilities | £740,300 | £735,911 | £731,502 | £727,073 | £722,624 | £718,154 | £713,664 | £709,153 | £704,622 | £700,070 | £695,497 | £690,903 | £686,288 |
| Total Liabilities | £740,300 | £755,904 | £754,138 | £745,867 | £981,683 | £1,555,093 | £948,624 | £740,552 | £736,674 | £728,443 | £718,496 | £906,363 | £705,774 |
| Paid-in Capital | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 | £300,000 |
| Retained Earnings | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) | (£40,300) |
| Earnings | £0 | (£14,186) | (£18,509) | (£25,817) | (£14,714) | £22,041 | £47,363 | £61,266 | £74,742 | £73,521 | £69,987 | £68,728 | £59,325 |
| Total Capital | £259,700 | £245,514 | £241,191 | £233,883 | £244,986 | £281,741 | £307,063 | £320,966 | £334,442 | £333,221 | £329,687 | £328,428 | £319,025 |
| Total Liabilities and Capital | £1,000,000 | £1,001,419 | £995,329 | £979,750 | £1,226,669 | £1,836,834 | £1,255,687 | £1,061,518 | £1,071,116 | £1,061,664 | £1,048,184 | £1,234,791 | £1,024,799 |
| Net Worth | £259,700 | £245,514 | £241,191 | £233,883 | £244,986 | £281,741 | £307,063 | £320,966 | £334,442 | £333,221 | £329,687 | £328,428 | £319,025 |