Adventure Excursions Unlimited

Start your own business plan »

Travel 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
Heli-skiing 0% $0 $0 $0 $0 $0 $120,000 $0 $0 $120,000 $120,000 $0 $0
White-water Rafting 0% $0 $0 $0 $0 $0 $0 $0 $70,000 $0 $70,000 $0 $0
Mountain Biking 0% $0 $0 $0 $0 $0 $0 $50,000 $50,000 $0 $0 $0 $0
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $0 $0 $0 $0 $120,000 $50,000 $120,000 $120,000 $190,000 $0 $0
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
Heli-skiing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
White-water Rafting $0 $0 $0 $0 $0 $0 $0 $20,000 $0 $20,000 $0 $0
Mountain Biking $0 $0 $0 $0 $0 $0 $14,000 $14,000 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $0 $14,000 $34,000 $0 $20,000 $0 $0
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
Jordan Stephan 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
Jillyn Certo 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
Loren Harlo 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
Mountain Bike Trip Personnel 0% $0 $0 $0 $0 $0 $0 $35,000 $35,000 $0 $0 $0 $0
Heli-skiing Personnel 0% $0 $0 $0 $0 $0 $40,000 $0 $0 $40,000 $40,000 $0 $0
White-water Adventure Personnel 0% $0 $0 $0 $0 $0 $0 $0 $35,000 $0 $35,000 $0 $0
Secretary 0% $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total People 3 3 3 4 4 9 9 14 9 14 4 4
Total Payroll $7,500 $7,500 $7,500 $9,500 $9,500 $49,500 $44,500 $79,500 $49,500 $84,500 $9,500 $9,500
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% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.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 $0 $0 $0 $0 $0 $120,000 $50,000 $120,000 $120,000 $190,000 $0 $0
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $14,000 $34,000 $0 $20,000 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $0 $0 $14,000 $34,000 $0 $20,000 $0 $0
Gross Margin $0 $0 $0 $0 $0 $120,000 $36,000 $86,000 $120,000 $170,000 $0 $0
Gross Margin % 0.00% 0.00% 0.00% 0.00% 0.00% 100.00% 72.00% 71.67% 100.00% 89.47% 0.00% 0.00%
Expenses
Payroll $7,500 $7,500 $7,500 $9,500 $9,500 $49,500 $44,500 $79,500 $49,500 $84,500 $9,500 $9,500
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $5,000 $1,500 $3,000 $5,000 $6,500 $0 $0
Depreciation $361 $361 $361 $361 $361 $361 $361 $361 $361 $361 $361 $361
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Rent $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Payroll Taxes 15% $1,125 $1,125 $1,125 $1,425 $1,425 $7,425 $6,675 $11,925 $7,425 $12,675 $1,425 $1,425
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $9,836 $9,836 $9,836 $12,136 $12,136 $63,136 $53,886 $95,636 $63,136 $104,886 $12,136 $12,136
Profit Before Interest and Taxes ($9,836) ($9,836) ($9,836) ($12,136) ($12,136) $56,864 ($17,886) ($9,636) $56,864 $65,114 ($12,136) ($12,136)
EBITDA ($9,475) ($9,475) ($9,475) ($11,775) ($11,775) $57,225 ($17,525) ($9,275) $57,225 $65,475 ($11,775) ($11,775)
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($2,951) ($2,459) ($2,459) ($3,034) ($3,034) $14,216 ($4,472) ($2,409) $14,216 $16,279 ($3,034) ($3,034)
Net Profit ($6,885) ($7,377) ($7,377) ($9,102) ($9,102) $42,648 ($13,415) ($7,227) $42,648 $48,836 ($9,102) ($9,102)
Net Profit/Sales 0.00% 0.00% 0.00% 0.00% 0.00% 35.54% -26.83% -6.02% 35.54% 25.70% 0.00% 0.00%
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 $0 $0 $0 $0 $0 $120,000 $50,000 $120,000 $120,000 $190,000 $0 $0
Subtotal Cash from Operations $0 $0 $0 $0 $0 $120,000 $50,000 $120,000 $120,000 $190,000 $0 $0
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 $0 $0 $0 $0 $0 $120,000 $50,000 $120,000 $120,000 $190,000 $0 $0
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 $7,500 $7,500 $7,500 $9,500 $9,500 $49,500 $44,500 $79,500 $49,500 $84,500 $9,500 $9,500
Bill Payments ($976) ($1,427) ($952) ($1,227) ($1,493) $183 $27,193 $19,514 $46,704 $28,451 $53,668 ($1,493)
Subtotal Spent on Operations $6,524 $6,073 $6,548 $8,273 $8,007 $49,683 $71,693 $99,014 $96,204 $112,951 $63,168 $8,007
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 $6,524 $6,073 $6,548 $8,273 $8,007 $49,683 $71,693 $99,014 $96,204 $112,951 $63,168 $8,007
Net Cash Flow ($6,524) ($6,073) ($6,548) ($8,273) ($8,007) $70,317 ($21,693) $20,986 $23,797 $77,049 ($63,168) ($8,007)
Cash Balance $38,076 $32,003 $25,455 $17,182 $9,175 $79,492 $57,799 $78,785 $102,581 $179,630 $116,462 $108,455
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 $44,600 $38,076 $32,003 $25,455 $17,182 $9,175 $79,492 $57,799 $78,785 $102,581 $179,630 $116,462 $108,455
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $44,600 $38,076 $32,003 $25,455 $17,182 $9,175 $79,492 $57,799 $78,785 $102,581 $179,630 $116,462 $108,455
Long-term Assets
Long-term Assets $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000
Accumulated Depreciation $0 $361 $722 $1,083 $1,444 $1,805 $2,166 $2,527 $2,888 $3,249 $3,610 $3,971 $4,332
Total Long-term Assets $13,000 $12,639 $12,278 $11,917 $11,556 $11,195 $10,834 $10,473 $10,112 $9,751 $9,390 $9,029 $8,668
Total Assets $57,600 $50,715 $44,281 $37,372 $28,738 $20,370 $90,326 $68,272 $88,897 $112,332 $189,020 $125,491 $117,123
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 $0 $943 $1,411 $1,879 $2,613 $29,921 $21,281 $49,134 $29,921 $57,773 $3,346 $4,080
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 $0 $943 $1,411 $1,879 $2,613 $29,921 $21,281 $49,134 $29,921 $57,773 $3,346 $4,080
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $0 $943 $1,411 $1,879 $2,613 $29,921 $21,281 $49,134 $29,921 $57,773 $3,346 $4,080
Paid-in Capital $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000
Retained Earnings ($2,400) ($2,400) ($2,400) ($2,400) ($2,400) ($2,400) ($2,400) ($2,400) ($2,400) ($2,400) ($2,400) ($2,400) ($2,400)
Earnings $0 ($6,885) ($14,262) ($21,639) ($30,741) ($39,843) $2,805 ($10,610) ($17,837) $24,811 $73,647 $64,545 $55,443
Total Capital $57,600 $50,715 $43,338 $35,961 $26,859 $17,757 $60,405 $46,990 $39,763 $82,411 $131,247 $122,145 $113,043
Total Liabilities and Capital $57,600 $50,715 $44,281 $37,372 $28,738 $20,370 $90,326 $68,272 $88,897 $112,332 $189,020 $125,491 $117,123
Net Worth $57,600 $50,715 $43,338 $35,961 $26,859 $17,757 $60,405 $46,990 $39,763 $82,411 $131,247 $122,145 $113,043