Bed and Breakfast - Caribbean - Business Plan

START YOUR OWN BUSINESS PLAN

Rate this plan
(5/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
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