Sephats Tours

Start your own business plan »

Travel Tour Agency Business Plan

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
All tourist services 0% $14,000 $17,500 $17,500 $28,000 $28,000 $28,000 $28,000 $31,500 $35,000 $38,500 $42,000 $42,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $14,000 $17,500 $17,500 $28,000 $28,000 $28,000 $28,000 $31,500 $35,000 $38,500 $42,000 $42,000
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
All tourist services $2,800 $3,500 $3,500 $5,600 $5,600 $5,600 $5,600 $6,300 $7,000 $7,700 $8,400 $8,400
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $2,800 $3,500 $3,500 $5,600 $5,600 $5,600 $5,600 $6,300 $7,000 $7,700 $8,400 $8,400
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
Directors 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accountant 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Tour Guide 0% $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Sales & Marketing 0% $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Driver 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Personal Assistant 0% $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100
Cleaner 0% $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Nightwatchman 0% $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Mechanic 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 11 11 11 11 11 11 11 11 11 11 11 11
Total Payroll $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400
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 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% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.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 $14,000 $17,500 $17,500 $28,000 $28,000 $28,000 $28,000 $31,500 $35,000 $38,500 $42,000 $42,000
Direct Cost of Sales $2,800 $3,500 $3,500 $5,600 $5,600 $5,600 $5,600 $6,300 $7,000 $7,700 $8,400 $8,400
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $2,800 $3,500 $3,500 $5,600 $5,600 $5,600 $5,600 $6,300 $7,000 $7,700 $8,400 $8,400
Gross Margin $11,200 $14,000 $14,000 $22,400 $22,400 $22,400 $22,400 $25,200 $28,000 $30,800 $33,600 $33,600
Gross Margin % 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00% 80.00%
Expenses
Payroll $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400
Sales and Marketing and Other Expenses $1,975 $1,975 $1,975 $1,975 $1,975 $1,975 $1,975 $1,975 $1,975 $1,975 $1,975 $1,975
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Miscellaneous $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Travel $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Insurance $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Maintenance $0 $0 $3,000 $0 $0 $3,000 $0 $0 $3,000 $0 $0 $3,000
Payroll Taxes 0% $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 Operating Expenses $13,925 $13,925 $16,925 $13,925 $13,925 $16,925 $13,925 $13,925 $16,925 $13,925 $13,925 $16,925
Profit Before Interest and Taxes ($2,725) $75 ($2,925) $8,475 $8,475 $5,475 $8,475 $11,275 $11,075 $16,875 $19,675 $16,675
EBITDA ($2,725) $75 ($2,925) $8,475 $8,475 $5,475 $8,475 $11,275 $11,075 $16,875 $19,675 $16,675
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($818) $13 ($497) $1,441 $1,441 $931 $1,441 $1,917 $1,883 $2,869 $3,345 $2,835
Net Profit ($1,908) $62 ($2,428) $7,034 $7,034 $4,544 $7,034 $9,358 $9,192 $14,006 $16,330 $13,840
Net Profit/Sales -13.63% 0.36% -13.87% 25.12% 25.12% 16.23% 25.12% 29.71% 26.26% 36.38% 38.88% 32.95%
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 $7,000 $8,750 $8,750 $14,000 $14,000 $14,000 $14,000 $15,750 $17,500 $19,250 $21,000 $21,000
Cash from Receivables $0 $233 $7,058 $8,750 $8,925 $14,000 $14,000 $14,000 $14,058 $15,808 $17,558 $19,308
Subtotal Cash from Operations $7,000 $8,983 $15,808 $22,750 $22,925 $28,000 $28,000 $29,750 $31,558 $35,058 $38,558 $40,308
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 $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 $7,000 $8,983 $15,808 $22,750 $22,925 $28,000 $28,000 $29,750 $31,558 $35,058 $38,558 $40,308
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 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400
Bill Payments $320 $9,562 $8,865 $10,639 $13,799 $11,649 $13,973 $11,631 $13,634 $17,134 $15,903 $17,097
Subtotal Spent on Operations $9,720 $18,962 $18,265 $20,039 $23,199 $21,049 $23,373 $21,031 $23,034 $26,534 $25,303 $26,497
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 $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 $9,720 $18,962 $18,265 $20,039 $23,199 $21,049 $23,373 $21,031 $23,034 $26,534 $25,303 $26,497
Net Cash Flow ($2,720) ($9,978) ($2,457) $2,711 ($274) $6,951 $4,627 $8,719 $8,524 $8,524 $13,255 $13,811
Cash Balance $27,280 $17,302 $14,845 $17,556 $17,282 $24,234 $28,861 $37,580 $46,105 $54,629 $67,884 $81,696
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 $30,000 $27,280 $17,302 $14,845 $17,556 $17,282 $24,234 $28,861 $37,580 $46,105 $54,629 $67,884 $81,696
Accounts Receivable $0 $7,000 $15,517 $17,208 $22,458 $27,533 $27,533 $27,533 $29,283 $32,725 $36,167 $39,608 $41,300
Inventory $0 $3,080 $3,850 $3,850 $6,160 $6,160 $6,160 $6,160 $6,930 $7,700 $8,470 $9,240 $9,240
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $30,000 $37,360 $36,669 $35,904 $46,174 $50,976 $57,927 $62,554 $73,794 $86,530 $99,266 $116,733 $132,236
Long-term Assets
Long-term Assets $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000 $167,000
Total Assets $197,000 $204,360 $203,669 $202,904 $213,174 $217,976 $224,927 $229,554 $240,794 $253,530 $266,266 $283,733 $299,236
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 $9,268 $8,514 $10,177 $13,413 $11,180 $13,587 $11,180 $13,061 $16,605 $15,335 $16,472 $18,134
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 $9,268 $8,514 $10,177 $13,413 $11,180 $13,587 $11,180 $13,061 $16,605 $15,335 $16,472 $18,134
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $9,268 $8,514 $10,177 $13,413 $11,180 $13,587 $11,180 $13,061 $16,605 $15,335 $16,472 $18,134
Paid-in Capital $202,000 $202,000 $202,000 $202,000 $202,000 $202,000 $202,000 $202,000 $202,000 $202,000 $202,000 $202,000 $202,000
Retained Earnings ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000) ($5,000)
Earnings $0 ($1,908) ($1,845) ($4,273) $2,761 $9,796 $14,340 $21,374 $30,732 $39,925 $53,931 $70,261 $84,101
Total Capital $197,000 $195,093 $195,155 $192,727 $199,761 $206,796 $211,340 $218,374 $227,732 $236,925 $250,931 $267,261 $281,101
Total Liabilities and Capital $197,000 $204,360 $203,669 $202,904 $213,174 $217,976 $224,927 $229,554 $240,794 $253,530 $266,266 $283,733 $299,236
Net Worth $197,000 $195,093 $195,155 $192,727 $199,761 $206,796 $211,340 $218,374 $227,732 $236,925 $250,931 $267,261 $281,101