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 |