Spanish Resources

Start your own business plan »

Tourism Website Services 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
Unit Sales
Large resorts 0% 0 1 1 2 2 2 5 5 5 6 6 6
Smaller resorts 0% 3 3 5 8 8 8 8 8 8 10 10 10
Other travel destinations 0% 3 3 5 6 6 6 6 6 6 8 8 8
Total Unit Sales 6 7 11 16 16 16 19 19 19 24 24 24
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Large resorts $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00
Smaller resorts $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00
Other travel destinations $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00
Sales
Large resorts $0 $8,350 $8,350 $16,700 $16,700 $16,700 $41,750 $41,750 $41,750 $50,100 $50,100 $50,100
Smaller resorts $9,000 $9,000 $15,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $30,000 $30,000 $30,000
Other travel destinations $6,000 $6,000 $10,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $16,000 $16,000 $16,000
Total Sales $15,000 $23,350 $33,350 $52,700 $52,700 $52,700 $77,750 $77,750 $77,750 $96,100 $96,100 $96,100
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Large resorts 0.00% $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00
Smaller resorts 0.00% $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00
Other travel destinations 0.00% $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
Direct Cost of Sales
Large resorts $0 $3,000 $3,000 $6,000 $6,000 $6,000 $15,000 $15,000 $15,000 $18,000 $18,000 $18,000
Smaller resorts $4,500 $4,500 $7,500 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $15,000 $15,000 $15,000
Other travel destinations $3,000 $3,000 $5,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $8,000 $8,000 $8,000
Subtotal Direct Cost of Sales $7,500 $10,500 $15,500 $24,000 $24,000 $24,000 $33,000 $33,000 $33,000 $41,000 $41,000 $41,000
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
Carolyn 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Jerry 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Office assistant 0% $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Bookkeeper 0% $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500 $3,000 $3,000 $3,000
Account manager 0% $0 $0 $0 $1,500 $1,500 $1,500 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Account manager 0% $1,500 $1,500 $1,500 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Account manager 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500
Production manager 0% $0 $0 $0 $0 $0 $0 $1,250 $1,250 $1,250 $3,000 $3,000 $3,000
Production assistant 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500
Sales and marketing manager 0% $0 $0 $0 $0 $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Sales and marketing assistant 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500
Total People 4 4 4 5 5 5 8 8 8 11 11 11
Total Payroll $6,000 $6,000 $6,000 $8,000 $8,000 $8,000 $14,250 $14,250 $14,250 $22,000 $22,000 $22,000
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 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.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 $15,000 $23,350 $33,350 $52,700 $52,700 $52,700 $77,750 $77,750 $77,750 $96,100 $96,100 $96,100
Direct Cost of Sales $7,500 $10,500 $15,500 $24,000 $24,000 $24,000 $33,000 $33,000 $33,000 $41,000 $41,000 $41,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $7,500 $10,500 $15,500 $24,000 $24,000 $24,000 $33,000 $33,000 $33,000 $41,000 $41,000 $41,000
Gross Margin $7,500 $12,850 $17,850 $28,700 $28,700 $28,700 $44,750 $44,750 $44,750 $55,100 $55,100 $55,100
Gross Margin % 50.00% 55.03% 53.52% 54.46% 54.46% 54.46% 57.56% 57.56% 57.56% 57.34% 57.34% 57.34%
Expenses
Payroll $6,000 $6,000 $6,000 $8,000 $8,000 $8,000 $14,250 $14,250 $14,250 $22,000 $22,000 $22,000
Sales and Marketing and Other Expenses $14,000 $14,000 $14,000 $21,000 $21,000 $21,000 $15,200 $26,000 $26,000 $26,000 $26,000 $26,000
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Insurance $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Rent $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Payroll Taxes 15% $900 $900 $900 $1,200 $1,200 $1,200 $2,138 $2,138 $2,138 $3,300 $3,300 $3,300
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $23,550 $23,550 $23,550 $32,850 $32,850 $32,850 $34,738 $45,538 $45,538 $54,450 $54,450 $54,450
Profit Before Interest and Taxes ($16,050) ($10,700) ($5,700) ($4,150) ($4,150) ($4,150) $10,013 ($788) ($788) $650 $650 $650
EBITDA ($16,050) ($10,700) ($5,700) ($4,150) ($4,150) ($4,150) $10,013 ($788) ($788) $650 $650 $650
Interest Expense $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($17,050) ($11,700) ($6,700) ($5,150) ($5,150) ($5,150) $9,013 ($1,788) ($1,788) ($350) ($350) ($350)
Net Profit/Sales -113.67% -50.11% -20.09% -9.77% -9.77% -9.77% 11.59% -2.30% -2.30% -0.36% -0.36% -0.36%
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 $6,000 $9,340 $13,340 $21,080 $21,080 $21,080 $31,100 $31,100 $31,100 $38,440 $38,440 $38,440
Cash from Receivables $0 $300 $9,167 $14,210 $20,397 $31,620 $31,620 $32,121 $46,650 $46,650 $47,017 $57,660
Subtotal Cash from Operations $6,000 $9,640 $22,507 $35,290 $41,477 $52,700 $62,720 $63,221 $77,750 $85,090 $85,457 $96,100
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 $6,000 $9,640 $22,507 $35,290 $41,477 $52,700 $62,720 $63,221 $77,750 $85,090 $85,457 $96,100
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 $6,000 $6,000 $6,000 $8,000 $8,000 $8,000 $14,250 $14,250 $14,250 $22,000 $22,000 $22,000
Bill Payments $50,868 $26,150 $29,217 $34,577 $49,850 $49,850 $50,005 $54,848 $65,288 $65,593 $74,450 $74,450
Subtotal Spent on Operations $56,868 $32,150 $35,217 $42,577 $57,850 $57,850 $64,255 $69,098 $79,538 $87,593 $96,450 $96,450
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 $56,868 $32,150 $35,217 $42,577 $57,850 $57,850 $64,255 $69,098 $79,538 $87,593 $96,450 $96,450
Net Cash Flow ($50,868) ($22,510) ($12,710) ($7,287) ($16,373) ($5,150) ($1,535) ($5,877) ($1,788) ($2,503) ($10,993) ($350)
Cash Balance $316,632 $294,122 $281,412 $274,125 $257,752 $252,602 $251,068 $245,191 $243,404 $240,901 $229,908 $229,558
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 $367,500 $316,632 $294,122 $281,412 $274,125 $257,752 $252,602 $251,068 $245,191 $243,404 $240,901 $229,908 $229,558
Accounts Receivable $0 $9,000 $22,710 $33,553 $50,963 $62,186 $62,186 $77,216 $91,745 $91,745 $102,755 $113,398 $113,398
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $367,500 $325,632 $316,832 $314,965 $325,088 $319,938 $314,788 $328,284 $336,936 $335,149 $343,656 $343,306 $342,956
Long-term Assets
Long-term Assets $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Total Assets $387,500 $345,632 $336,832 $334,965 $345,088 $339,938 $334,788 $348,284 $356,936 $355,149 $363,656 $363,306 $362,956
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 $50,000 $25,182 $28,082 $32,915 $48,188 $48,188 $48,188 $52,671 $63,111 $63,111 $71,968 $71,968 $71,968
Current Borrowing $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $150,000 $125,182 $128,082 $132,915 $148,188 $148,188 $148,188 $152,671 $163,111 $163,111 $171,968 $171,968 $171,968
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $150,000 $125,182 $128,082 $132,915 $148,188 $148,188 $148,188 $152,671 $163,111 $163,111 $171,968 $171,968 $171,968
Paid-in Capital $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000
Retained Earnings ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500)
Earnings $0 ($17,050) ($28,750) ($35,450) ($40,600) ($45,750) ($50,900) ($41,888) ($43,675) ($45,463) ($45,813) ($46,163) ($46,513)
Total Capital $237,500 $220,450 $208,750 $202,050 $196,900 $191,750 $186,600 $195,613 $193,825 $192,038 $191,688 $191,338 $190,988
Total Liabilities and Capital $387,500 $345,632 $336,832 $334,965 $345,088 $339,938 $334,788 $348,284 $356,936 $355,149 $363,656 $363,306 $362,956
Net Worth $237,500 $220,450 $208,750 $202,050 $196,900 $191,750 $186,600 $195,613 $193,825 $192,038 $191,688 $191,338 $190,988