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 | |
By 
