Vineyard Bed & Breakfast Business Plan

Enchanted Vineyard B & B

Start your own business plan

Rate this plan ►
(4.7/5, 3 votes)

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
Page

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

Click here to get started.