Visigoth Imports, Inc.

Start your own business plan »

Import Export 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
Leavenworth imports 0% $11,000 $13,000 $13,000 $12,000 $10,000 $8,000 $12,000 $9,000 $8,000 $9,000 $10,000 $12,000
PCC farm exports 0% $0 $0 $0 $0 $0 $2,000 $4,000 $4,000 $5,000 $5,000 $6,000 $7,000
Total Sales $11,000 $13,000 $13,000 $12,000 $10,000 $10,000 $16,000 $13,000 $13,000 $14,000 $16,000 $19,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
Leavenworth imports $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
PCC farm exports $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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
Mr. Frank Curtiss - President 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Mrs. Hannah Mills 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Mr. Steve Iltheus 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
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0% 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,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 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% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 $11,000 $13,000 $13,000 $12,000 $10,000 $10,000 $16,000 $13,000 $13,000 $14,000 $16,000 $19,000
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Margin $11,000 $13,000 $13,000 $12,000 $10,000 $10,000 $16,000 $13,000 $13,000 $14,000 $16,000 $19,000
Gross Margin % 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Expenses
Payroll $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Sales and Marketing and Other Expenses $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $500 $500 $500 $300 $300 $300
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Insurance $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Payroll Taxes 15% $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 15% $1,200 $3,000 $1,000 $2,000 $2,000 $3,000 $2,000 $1,000 $2,000 $3,000 $1,000 $3,000
Other $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Total Operating Expenses $13,550 $15,350 $13,350 $14,350 $14,350 $15,350 $13,850 $12,850 $13,850 $14,650 $12,650 $14,650
Profit Before Interest and Taxes ($2,550) ($2,350) ($350) ($2,350) ($4,350) ($5,350) $2,150 $150 ($850) ($650) $3,350 $4,350
EBITDA ($2,550) ($2,350) ($350) ($2,350) ($4,350) ($5,350) $2,150 $150 ($850) ($650) $3,350 $4,350
Interest Expense $174 $173 $173 $172 $171 $170 $169 $168 $168 $167 $166 $165
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($2,724) ($2,523) ($523) ($2,522) ($4,521) ($5,520) $1,981 ($18) ($1,018) ($817) $3,184 $4,185
Net Profit/Sales -24.77% -19.41% -4.02% -21.01% -45.21% -55.20% 12.38% -0.14% -7.83% -5.83% 19.90% 22.03%
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 $5,500 $6,500 $6,500 $6,000 $5,000 $5,000 $8,000 $6,500 $6,500 $7,000 $8,000 $9,500
Cash from Receivables $0 $183 $5,533 $6,500 $6,483 $5,967 $5,000 $5,100 $7,950 $6,500 $6,517 $7,033
Subtotal Cash from Operations $5,500 $6,683 $12,033 $12,500 $11,483 $10,967 $13,000 $11,600 $14,450 $13,500 $14,517 $16,533
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 $5,500 $6,683 $12,033 $12,500 $11,483 $10,967 $13,000 $11,600 $14,450 $13,500 $14,517 $16,533
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 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Bill Payments $2,191 $5,784 $7,457 $5,556 $6,522 $6,554 $7,470 $5,986 $5,052 $6,044 $6,750 $4,882
Subtotal Spent on Operations $10,191 $13,784 $15,457 $13,556 $14,522 $14,554 $15,470 $13,986 $13,052 $14,044 $14,750 $12,882
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 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
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 $4,000 $0 $0 $0 $0
Subtotal Cash Spent $10,291 $13,884 $15,557 $13,656 $14,622 $14,654 $15,570 $18,086 $13,152 $14,144 $14,850 $12,982
Net Cash Flow ($4,791) ($7,201) ($3,523) ($1,156) ($3,138) ($3,687) ($2,570) ($6,486) $1,298 ($644) ($333) $3,551
Cash Balance $33,759 $26,558 $23,035 $21,879 $18,741 $15,053 $12,484 $5,998 $7,296 $6,652 $6,319 $9,869
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 $38,550 $33,759 $26,558 $23,035 $21,879 $18,741 $15,053 $12,484 $5,998 $7,296 $6,652 $6,319 $9,869
Accounts Receivable $0 $5,500 $11,817 $12,783 $12,283 $10,800 $9,833 $12,833 $14,233 $12,783 $13,283 $14,767 $17,233
Other Current Assets $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Total Current Assets $53,550 $54,259 $53,375 $50,818 $49,163 $44,541 $39,887 $40,317 $35,231 $35,079 $34,935 $36,085 $42,103
Long-term Assets
Long-term Assets $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Total Assets $63,550 $64,259 $63,375 $60,818 $59,163 $54,541 $49,887 $50,317 $45,231 $45,079 $44,935 $46,085 $52,103
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 $2,000 $5,533 $7,273 $5,338 $6,304 $6,303 $7,269 $5,819 $4,851 $5,817 $6,589 $4,655 $6,588
Current Borrowing $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000
Other Current Liabilities $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Subtotal Current Liabilities $19,000 $22,533 $24,273 $22,338 $23,304 $23,303 $24,269 $22,819 $21,851 $22,817 $23,589 $21,655 $23,588
Long-term Liabilities $12,000 $11,900 $11,800 $11,700 $11,600 $11,500 $11,400 $11,300 $11,200 $11,100 $11,000 $10,900 $10,800
Total Liabilities $31,000 $34,433 $36,073 $34,038 $34,904 $34,803 $35,669 $34,119 $33,051 $33,917 $34,589 $32,555 $34,388
Paid-in Capital $53,750 $53,750 $53,750 $53,750 $53,750 $53,750 $53,750 $53,750 $53,750 $53,750 $53,750 $53,750 $53,750
Retained Earnings ($21,200) ($21,200) ($21,200) ($21,200) ($21,200) ($21,200) ($21,200) ($21,200) ($25,200) ($25,200) ($25,200) ($25,200) ($25,200)
Earnings $0 ($2,724) ($5,248) ($5,770) ($8,292) ($12,813) ($18,333) ($16,352) ($16,370) ($17,388) ($18,204) ($15,020) ($10,835)
Total Capital $32,550 $29,826 $27,303 $26,780 $24,258 $19,738 $14,218 $16,198 $12,180 $11,163 $10,346 $13,530 $17,715
Total Liabilities and Capital $63,550 $64,259 $63,375 $60,818 $59,163 $54,541 $49,887 $50,317 $45,231 $45,079 $44,935 $46,085 $52,103
Net Worth $32,550 $29,826 $27,303 $26,780 $24,258 $19,737 $14,217 $16,198 $12,180 $11,162 $10,346 $13,530 $17,715