Coach House Bed and Breakfast

Start your own business plan »

Bed and Breakfast Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Apartment 0% $2,093 $1,890 $2,093 $2,025 $5,270 $5,100 $5,270 $5,270 $5,100 $2,093 $2,025 $2,093
Large Jacuzzi 0% $1,395 $1,260 $1,395 $2,363 $4,611 $4,463 $4,611 $4,611 $4,463 $1,395 $2,363 $1,395
Adjoining Unit 0% $1,116 $1,008 $1,116 $1,080 $3,953 $3,825 $3,953 $3,953 $3,825 $1,116 $1,080 $1,116
Smaller Unit 0% $977 $882 $977 $945 $3,294 $3,188 $3,294 $3,294 $3,188 $977 $945 $977
Total Sales $5,580 $5,040 $5,580 $6,413 $17,128 $16,575 $17,128 $17,128 $16,575 $5,580 $6,413 $5,580
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Apartment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Large Jacuzzi $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Adjoining Unit $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Smaller Unit $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
John Maesch 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Frank Williams 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,000 $1,000 $1,000
Total People 1 1 1 1 1 1 1 1 1 2 2 2
Total Payroll $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $2,000 $2,000 $2,000
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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 30.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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $5,580 $5,040 $5,580 $6,413 $17,128 $16,575 $17,128 $17,128 $16,575 $5,580 $6,413 $5,580
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Margin $5,580 $5,040 $5,580 $6,413 $17,128 $16,575 $17,128 $17,128 $16,575 $5,580 $6,413 $5,580
Gross Margin % 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Expenses
Payroll $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $2,000 $2,000 $2,000
Sales and Marketing and Other Expenses $392 $217 $217 $217 $217 $217 $217 $217 $217 $217 $217 $217
Depreciation $370 $370 $370 $370 $370 $370 $370 $370 $370 $370 $370 $370
Insurance $215 $215 $215 $215 $215 $215 $215 $215 $215 $215 $215 $215
Telephone $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Security $35 $35 $35 $35 $35 $35 $35 $35 $35 $35 $35 $35
Duties & Subscriptions $175 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833
Room/Housecleaning $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25
Groceries $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Payroll Taxes 15% $150 $150 $150 $150 $150 $150 $150 $150 $150 $300 $300 $300
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $3,520 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $4,320 $4,320 $4,320
Profit Before Interest and Taxes $2,060 $1,870 $2,410 $3,243 $13,958 $13,405 $13,958 $13,958 $13,405 $1,260 $2,093 $1,260
EBITDA $2,430 $2,240 $2,780 $3,613 $14,328 $13,775 $14,328 $14,328 $13,775 $1,630 $2,463 $1,630
Interest Expense $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375
Taxes Incurred ($694) ($626) ($491) ($283) $2,396 $2,258 $2,396 $2,396 $2,258 ($779) ($571) ($779)
Net Profit ($1,620) ($1,879) ($1,474) ($849) $7,187 $6,773 $7,187 $7,187 $6,773 ($2,336) ($1,712) ($2,336)
Net Profit/Sales -29.04% -37.27% -26.41% -13.24% 41.96% 40.86% 41.96% 41.96% 40.86% -41.86% -26.69% -41.86%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $1,395 $1,260 $1,395 $1,603 $4,282 $4,144 $4,282 $4,282 $4,144 $1,395 $1,603 $1,395
Cash from Receivables $2,000 $2,140 $4,172 $3,794 $4,206 $5,077 $12,832 $12,445 $12,846 $12,832 $12,156 $4,206
Subtotal Cash from Operations $3,395 $3,400 $5,567 $5,397 $8,488 $9,221 $17,114 $16,727 $16,989 $14,227 $13,760 $5,601
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 $525,000 $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 $528,395 $3,400 $5,567 $5,397 $8,488 $9,221 $17,114 $16,727 $16,989 $14,227 $13,760 $5,601
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $2,000 $2,000 $2,000
Bill Payments $20,194 $5,821 $5,553 $5,690 $5,981 $8,566 $8,437 $8,570 $8,566 $8,336 $5,553 $5,747
Subtotal Spent on Operations $21,194 $6,821 $6,553 $6,690 $6,981 $9,566 $9,437 $9,570 $9,566 $10,336 $7,553 $7,747
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 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $500,000 $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 $21,194 $6,821 $506,553 $6,690 $6,981 $9,566 $9,437 $9,570 $9,566 $10,336 $7,553 $7,747
Net Cash Flow $507,201 ($3,421) ($500,987) ($1,294) $1,507 ($345) $7,677 $7,157 $7,424 $3,891 $6,207 ($2,146)
Cash Balance $519,201 $515,779 $14,793 $13,499 $15,006 $14,661 $22,338 $29,494 $36,918 $40,809 $47,015 $44,869
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $12,000 $519,201 $515,779 $14,793 $13,499 $15,006 $14,661 $22,338 $29,494 $36,918 $40,809 $47,015 $44,869
Accounts Receivable $4,000 $6,185 $7,826 $7,839 $8,855 $17,495 $24,849 $24,863 $25,263 $24,849 $16,202 $8,855 $8,834
Other Current Assets $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Total Current Assets $17,000 $526,386 $524,605 $23,632 $23,354 $33,500 $40,510 $48,200 $55,757 $62,767 $58,011 $56,870 $54,703
Long-term Assets
Long-term Assets $200,000 $200,000 $200,000 $700,000 $700,000 $700,000 $700,000 $700,000 $700,000 $700,000 $700,000 $700,000 $700,000
Accumulated Depreciation $30,000 $30,370 $30,740 $31,110 $31,480 $31,850 $32,220 $32,590 $32,960 $33,330 $33,700 $34,070 $34,440
Total Long-term Assets $170,000 $169,630 $169,260 $668,890 $668,520 $668,150 $667,780 $667,410 $667,040 $666,670 $666,300 $665,930 $665,560
Total Assets $187,000 $696,016 $693,865 $692,522 $691,874 $701,650 $708,290 $715,610 $722,797 $729,437 $724,311 $722,800 $720,263
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $20,000 $5,636 $5,364 $5,494 $5,695 $8,285 $8,151 $8,285 $8,285 $8,151 $5,361 $5,562 $5,361
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 $20,000 $5,636 $5,364 $5,494 $5,695 $8,285 $8,151 $8,285 $8,285 $8,151 $5,361 $5,562 $5,361
Long-term Liabilities $0 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000
Total Liabilities $20,000 $530,636 $530,364 $530,494 $530,695 $533,285 $533,151 $533,285 $533,285 $533,151 $530,361 $530,562 $530,361
Paid-in Capital $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Retained Earnings $117,000 $117,000 $117,000 $117,000 $117,000 $117,000 $117,000 $117,000 $117,000 $117,000 $117,000 $117,000 $117,000
Earnings $0 ($1,620) ($3,499) ($4,972) ($5,821) $1,366 $8,138 $15,326 $22,513 $29,285 $26,949 $25,238 $22,902
Total Capital $167,000 $165,380 $163,501 $162,028 $161,179 $168,366 $175,138 $182,326 $189,513 $196,285 $193,949 $192,238 $189,902
Total Liabilities and Capital $187,000 $696,016 $693,865 $692,522 $691,874 $701,650 $708,290 $715,610 $722,797 $729,437 $724,311 $722,800 $720,263
Net Worth $167,000 $165,380 $163,501 $162,028 $161,179 $168,366 $175,138 $182,326 $189,513 $196,285 $193,949 $192,238 $189,902