Click here to buy now or call 0845 351 9924
Plan Outline
Vineyard Bed & Breakfast Business Plan
Enchanted Vineyard B & B
This sample business plan can be edited directly in Business Plan Pro software.
Appendix
| 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 | |||||||||||||
| Weekend-Getaway Customers | 0% | £0 | £0 | £0 | £654 | £745 | £784 | £804 | £1,245 | £1,587 | £1,874 | £2,245 | £1,458 |
| Travelers | 0% | £0 | £0 | £0 | £654 | £702 | £754 | £815 | £1,345 | £1,698 | £1,985 | £2,458 | £2,678 |
| University of Oregon Travelers | 0% | £0 | £0 | £0 | £598 | £965 | £654 | £712 | £800 | £1,874 | £1,787 | £1,987 | £1,888 |
| Total Sales | £0 | £0 | £0 | £1,906 | £2,412 | £2,192 | £2,331 | £3,390 | £5,159 | £5,646 | £6,690 | £6,024 | |
| 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 | |
| Weekend-Getaway Customers | £0 | £0 | £0 | £340 | £387 | £423 | £434 | £671 | £856 | £1,010 | £1,211 | £786 | |
| Travelers | £0 | £0 | £0 | £340 | £365 | £407 | £439 | £725 | £916 | £1,070 | £1,325 | £1,444 | |
| University of Oregon Travelers | £0 | £0 | £0 | £311 | £502 | £353 | £384 | £431 | £1,010 | £964 | £1,071 | £1,018 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £991 | £1,254 | £1,182 | £1,257 | £1,828 | £2,782 | £3,044 | £3,607 | £3,248 | |
| 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 | ||
| Missy | 0% | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 |
| Housekeeping/Outdoor Maintenance | 0% | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Total People | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £250 | £250 | £250 | £250 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 25.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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £0 | £0 | £0 | £1,906 | £2,412 | £2,192 | £2,331 | £3,390 | £5,159 | £5,646 | £6,690 | £6,024 | |
| Direct Cost of Sales | £0 | £0 | £0 | £991 | £1,254 | £1,182 | £1,257 | £1,828 | £2,782 | £3,044 | £3,607 | £3,248 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £991 | £1,254 | £1,182 | £1,257 | £1,828 | £2,782 | £3,044 | £3,607 | £3,248 | |
| Gross Margin | £0 | £0 | £0 | £915 | £1,158 | £1,010 | £1,074 | £1,562 | £2,377 | £2,602 | £3,083 | £2,776 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 48.01% | 48.01% | 46.08% | 46.08% | 46.08% | 46.08% | 46.08% | 46.08% | 46.08% | |
| Expenses | |||||||||||||
| Payroll | £250 | £250 | £250 | £250 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | |
| Sales and Marketing and Other Expenses | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Depreciation | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £150 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | £120 | |
| mortgage | £440 | £440 | £440 | £440 | £440 | £440 | £440 | £440 | £440 | £440 | £440 | £440 | |
| Payroll Taxes | 15% | £38 | £38 | £38 | £38 | £263 | £263 | £263 | £263 | £263 | £263 | £263 | £263 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £2,895 | £2,865 | £2,865 | £2,865 | £4,590 | £4,590 | £4,590 | £4,590 | £4,590 | £4,590 | £4,590 | £4,590 | |
| Profit Before Interest and Taxes | (£2,895) | (£2,865) | (£2,865) | (£1,950) | (£3,432) | (£3,579) | (£3,515) | (£3,027) | (£2,212) | (£1,988) | (£1,507) | (£1,814) | |
| EBITDA | (£1,228) | (£1,198) | (£1,198) | (£283) | (£1,765) | (£1,912) | (£1,848) | (£1,360) | (£545) | (£321) | £160 | (£147) | |
| Interest Expense | £103 | £103 | £103 | £103 | £102 | £101 | £101 | £100 | £99 | £98 | £98 | £114 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£2,998) | (£2,968) | (£2,968) | (£2,052) | (£3,533) | (£3,681) | (£3,616) | (£3,127) | (£2,311) | (£2,086) | (£1,605) | (£1,927) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | -107.67% | -146.49% | -167.91% | -155.12% | -92.25% | -44.80% | -36.95% | -23.98% | -32.00% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £0 | £0 | £1,334 | £1,688 | £1,534 | £1,632 | £2,373 | £3,611 | £3,952 | £4,683 | £4,217 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £19 | £577 | £721 | £659 | £710 | £1,035 | £1,553 | £1,704 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £1,334 | £1,707 | £2,111 | £2,353 | £3,032 | £4,321 | £4,987 | £6,236 | £5,921 | |
| 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 | £2,000 | |
| New Other Liabilities (interest-free) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,800 | £0 | £0 | £0 | |
| New Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales of Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Investment Received | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £0 | £1,334 | £1,707 | £2,111 | £2,353 | £3,032 | £8,121 | £4,987 | £6,236 | £7,921 | |
| 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 | £250 | £250 | £250 | £250 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | |
| Bill Payments | £36 | £1,080 | £1,051 | £1,084 | £2,062 | £2,398 | £2,384 | £2,650 | £3,774 | £5,086 | £4,634 | £5,451 | |
| Subtotal Spent on Operations | £286 | £1,330 | £1,301 | £1,334 | £3,812 | £4,148 | £4,134 | £4,400 | £5,524 | £6,836 | £6,384 | £7,201 | |
| 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 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | |
| 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 | £286 | £1,330 | £1,301 | £1,417 | £3,895 | £4,231 | £4,218 | £4,483 | £5,608 | £6,919 | £6,467 | £7,285 | |
| Net Cash Flow | (£286) | (£1,330) | (£1,301) | (£83) | (£2,188) | (£2,120) | (£1,864) | (£1,451) | £2,514 | (£1,932) | (£232) | £636 | |
| Cash Balance | £10,914 | £9,584 | £8,283 | £8,200 | £6,012 | £3,892 | £2,028 | £577 | £3,091 | £1,158 | £926 | £1,563 | |
| 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 | £11,200 | £10,914 | £9,584 | £8,283 | £8,200 | £6,012 | £3,892 | £2,028 | £577 | £3,091 | £1,158 | £926 | £1,563 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £572 | £1,276 | £1,357 | £1,335 | £1,693 | £2,531 | £3,190 | £3,644 | £3,747 |
| Inventory | £1,500 | £1,500 | £1,500 | £1,500 | £1,509 | £1,379 | £1,300 | £1,383 | £2,011 | £3,060 | £3,349 | £3,968 | £3,573 |
| Other Current Assets | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Total Current Assets | £14,200 | £13,914 | £12,584 | £11,283 | £11,781 | £10,168 | £8,049 | £6,245 | £5,780 | £10,181 | £9,197 | £10,039 | £10,383 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 |
| Accumulated Depreciation | £0 | £1,667 | £3,334 | £5,001 | £6,668 | £8,335 | £10,002 | £11,669 | £13,336 | £15,003 | £16,670 | £18,337 | £20,004 |
| Total Long-term Assets | £200,000 | £198,333 | £196,666 | £194,999 | £193,332 | £191,665 | £189,998 | £188,331 | £186,664 | £184,997 | £183,330 | £181,663 | £179,996 |
| Total Assets | £214,200 | £212,247 | £209,250 | £206,282 | £205,113 | £201,833 | £198,047 | £194,576 | £192,444 | £195,178 | £192,527 | £191,702 | £190,379 |
| 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 | £1,045 | £1,016 | £1,016 | £1,982 | £2,319 | £2,297 | £2,525 | £3,604 | £4,933 | £4,451 | £5,314 | £4,001 |
| Current Borrowing | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £4,400 |
| Other Current Liabilities | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £5,800 | £5,800 | £5,800 | £5,800 |
| Subtotal Current Liabilities | £4,400 | £5,445 | £5,416 | £5,416 | £6,382 | £6,719 | £6,697 | £6,925 | £8,004 | £13,133 | £12,651 | £13,514 | £14,201 |
| Long-term Liabilities | £10,000 | £10,000 | £10,000 | £10,000 | £9,917 | £9,833 | £9,750 | £9,667 | £9,583 | £9,500 | £9,417 | £9,333 | £9,250 |
| Total Liabilities | £14,400 | £15,445 | £15,416 | £15,416 | £16,298 | £16,552 | £16,447 | £16,592 | £17,587 | £22,633 | £22,067 | £22,847 | £23,451 |
| Paid-in Capital | £201,600 | £201,600 | £201,600 | £201,600 | £201,600 | £201,600 | £201,600 | £201,600 | £201,600 | £201,600 | £201,600 | £201,600 | £201,600 |
| Retained Earnings | (£1,800) | (£1,800) | (£1,800) | (£1,800) | (£1,800) | (£1,800) | (£1,800) | (£1,800) | (£1,800) | (£1,800) | (£1,800) | (£1,800) | (£1,800) |
| Earnings | £0 | (£2,998) | (£5,966) | (£8,934) | (£10,986) | (£14,519) | (£18,200) | (£21,816) | (£24,943) | (£27,254) | (£29,341) | (£30,945) | (£32,873) |
| Total Capital | £199,800 | £196,802 | £193,834 | £190,867 | £188,814 | £185,281 | £181,600 | £177,984 | £174,857 | £172,546 | £170,459 | £168,855 | £166,927 |
| Total Liabilities and Capital | £214,200 | £212,247 | £209,250 | £206,282 | £205,113 | £201,833 | £198,047 | £194,576 | £192,444 | £195,178 | £192,527 | £191,702 | £190,379 |
| Net Worth | £199,800 | £196,802 | £193,834 | £190,867 | £188,814 | £185,281 | £181,600 | £177,984 | £174,857 | £172,546 | £170,459 | £168,855 | £166,927 |