Vineyard Bed & Breakfast Business Plan

Start your plan
Start my business plan

Start your own vineyard bed & breakfast business plan

Enchanted Vineyard B & B

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

Download link edge graphic Download this plan

Start your own vineyard bed & breakfast business plan

Start your own business plan

LivePlan logo Start planning

Your business plan can look as polished and professional as this sample plan. It's fast and easy, with LivePlan.

Get the Bplans newsletter:

Expert business tips and advice delivered weekly.