Bed and Breakfast - Caribbean - Business Plan

Start your plan
Start my business plan

Start your own bed and breakfast - caribbean - business plan

Vette Kat Harbour Bed and Breakfast

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
Room night @ 110.00 per night 10% $2,509 $2,760 $3,036 $3,339 $3,673 $4,041 $4,445 $4,889 $5,378 $5,916 $6,508 $7,158
Suite night @ 175.00 per night 10% $1,597 $1,757 $1,932 $2,126 $2,338 $2,572 $2,829 $3,112 $3,423 $3,766 $4,142 $4,556
Museum & Tour of Mansion @ 3.00 pp 10% $300 $330 $363 $399 $439 $483 $531 $585 $643 $707 $778 $856
Total Sales $4,406 $4,847 $5,331 $5,864 $6,451 $7,096 $7,805 $8,586 $9,445 $10,389 $11,428 $12,571
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
Room night @ 20.00 cost $460 $460 $460 $460 $460 $460 $460 $460 $460 $460 $460 $460
Suite night @ 30.00 cost $270 $270 $270 $270 $270 $270 $270 $270 $270 $270 $270 $270
Museum and Tour of Mansion $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $40
Subtotal Direct Cost of Sales $770 $770 $770 $770 $770 $770 $770 $770 $770 $770 $770 $770
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 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Long-term Interest Rate 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Tax Rate 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.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 $4,406 $4,847 $5,331 $5,864 $6,451 $7,096 $7,805 $8,586 $9,445 $10,389 $11,428 $12,571
Direct Cost of Sales $770 $770 $770 $770 $770 $770 $770 $770 $770 $770 $770 $770
Other $860 $860 $860 $860 $860 $860 $860 $860 $860 $860 $860 $860
Total Cost of Sales $1,630 $1,630 $1,630 $1,630 $1,630 $1,630 $1,630 $1,630 $1,630 $1,630 $1,630 $1,630
Gross Margin $2,776 $3,217 $3,701 $4,234 $4,821 $5,466 $6,175 $6,956 $7,815 $8,759 $9,798 $10,941
Gross Margin % 63.00% 66.37% 69.43% 72.21% 74.73% 77.03% 79.12% 81.02% 82.74% 84.31% 85.74% 87.03%
Expenses
Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales & Marketing & Other Expenses $1,000 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Depreciation $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Annual web and Assoc fees $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Utilities $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Payroll Tax 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Total Operating Expenses $2,100 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Profit Before Interest and Taxes $676 $1,617 $2,101 $2,634 $3,221 $3,866 $4,575 $5,356 $6,215 $7,159 $8,198 $9,341
EBITDA $776 $1,717 $2,201 $2,734 $3,321 $3,966 $4,675 $5,456 $6,315 $7,259 $8,298 $9,441
Interest Expense $403 $400 $397 $394 $391 $388 $385 $382 $379 $376 $373 $370
Taxes Incurred $35 $158 $222 $291 $368 $452 $545 $647 $759 $882 $1,017 $1,166
Net Profit $237 $1,058 $1,483 $1,949 $2,462 $3,026 $3,646 $4,327 $5,077 $5,901 $6,808 $7,805
Net Profit/Sales 5.39% 21.84% 27.81% 33.24% 38.16% 42.64% 46.71% 50.40% 53.76% 56.80% 59.57% 62.08%

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 $4,406 $4,847 $5,331 $5,864 $6,451 $7,096 $7,805 $8,586 $9,445 $10,389 $11,428 $12,571
Subtotal Cash from Operations $4,406 $4,847 $5,331 $5,864 $6,451 $7,096 $7,805 $8,586 $9,445 $10,389 $11,428 $12,571
Additional Cash Received
Sales Tax, VAT, HST/GST Received 13.00% $573 $630 $693 $762 $839 $922 $1,015 $1,116 $1,228 $1,351 $1,486 $1,634
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 $4,979 $5,477 $6,024 $6,627 $7,289 $8,018 $8,820 $9,702 $10,672 $11,740 $12,914 $14,205
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Bill Payments $1,649 $3,108 $3,277 $3,725 $3,852 $3,930 $4,015 $4,109 $4,213 $4,328 $4,454 $4,593
Subtotal Spent on Operations $1,649 $3,108 $3,277 $3,725 $3,852 $3,930 $4,015 $4,109 $4,213 $4,328 $4,454 $4,593
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $573 $630 $693 $762 $839 $922 $1,015 $1,116 $1,228 $1,351 $1,486 $1,634
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 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
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 $2,822 $4,338 $4,570 $5,088 $5,291 $5,452 $5,630 $5,825 $6,041 $6,278 $6,540 $6,827
Net Cash Flow $2,157 $1,138 $1,454 $1,539 $1,999 $2,566 $3,191 $3,877 $4,631 $5,461 $6,374 $7,378
Cash Balance $26,157 $27,295 $28,749 $30,288 $32,287 $34,853 $38,044 $41,921 $46,552 $52,013 $58,387 $65,765

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 $24,000 $26,157 $27,295 $28,749 $30,288 $32,287 $34,853 $38,044 $41,921 $46,552 $52,013 $58,387 $65,765
Inventory $2,500 $1,730 $960 $847 $847 $847 $847 $847 $847 $847 $847 $847 $847
Other Current Assets $13,667 $13,667 $13,667 $13,667 $13,667 $13,667 $13,667 $13,667 $13,667 $13,667 $13,667 $13,667 $13,667
Total Current Assets $40,167 $41,554 $41,922 $43,263 $44,802 $46,801 $49,367 $52,558 $56,435 $61,066 $66,527 $72,901 $80,279
Long-term Assets
Long-term Assets $56,000 $56,000 $56,000 $56,000 $56,000 $56,000 $56,000 $56,000 $56,000 $56,000 $56,000 $56,000 $56,000
Accumulated Depreciation $0 $100 $200 $300 $400 $500 $600 $700 $800 $900 $1,000 $1,100 $1,200
Total Long-term Assets $56,000 $55,900 $55,800 $55,700 $55,600 $55,500 $55,400 $55,300 $55,200 $55,100 $55,000 $54,900 $54,800
Total Assets $96,167 $97,454 $97,722 $98,963 $100,402 $102,301 $104,767 $107,858 $111,635 $116,166 $121,527 $127,801 $135,079
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,649 $1,459 $1,818 $1,908 $1,944 $1,985 $2,030 $2,079 $2,134 $2,194 $2,260 $2,333
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 $1,649 $1,459 $1,818 $1,908 $1,944 $1,985 $2,030 $2,079 $2,134 $2,194 $2,260 $2,333
Long-term Liabilities $81,210 $80,610 $80,010 $79,410 $78,810 $78,210 $77,610 $77,010 $76,410 $75,810 $75,210 $74,610 $74,010
Total Liabilities $81,210 $82,259 $81,469 $81,228 $80,718 $80,154 $79,595 $79,040 $78,489 $77,944 $77,404 $76,870 $76,343
Paid-in Capital $24,840 $24,840 $24,840 $24,840 $24,840 $24,840 $24,840 $24,840 $24,840 $24,840 $24,840 $24,840 $24,840
Retained Earnings ($9,883) ($9,883) ($9,883) ($9,883) ($9,883) ($9,883) ($9,883) ($9,883) ($9,883) ($9,883) ($9,883) ($9,883) ($9,883)
Earnings $0 $237 $1,296 $2,779 $4,728 $7,190 $10,215 $13,861 $18,188 $23,265 $29,167 $35,974 $43,779
Total Capital $14,957 $15,194 $16,253 $17,736 $19,685 $22,147 $25,172 $28,818 $33,145 $38,222 $44,124 $50,931 $58,736
Total Liabilities and Capital $96,167 $97,454 $97,722 $98,963 $100,402 $102,301 $104,767 $107,858 $111,635 $116,166 $121,527 $127,801 $135,079
Net Worth $14,957 $15,194 $16,253 $17,736 $19,685 $22,147 $25,172 $28,818 $33,145 $38,222 $44,124 $50,931 $58,736
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
Kayman 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Jenne 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Housekeeping/Grounds Maintenance 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Download link edge graphic Download this plan

Start your own bed and breakfast - caribbean - 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.