D.A.P. Exports

Start your own business plan »

Export Automobile Parts 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
Auto Parts 0% $0 $0 $20,000 $26,000 $30,000 $36,000 $40,000 $44,000 $48,000 $50,000 $56,000 $60,000
Auto Lubricants 0% $0 $0 $8,000 $12,000 $12,000 $16,000 $20,000 $20,000 $24,000 $24,000 $26,000 $24,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $0 $28,000 $38,000 $42,000 $52,000 $60,000 $64,000 $72,000 $74,000 $82,000 $84,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
Auto Parts $0 $0 $10,000 $13,000 $15,000 $18,000 $20,000 $22,000 $24,000 $25,000 $23,000 $30,000
Auto Lubricants $0 $0 $4,000 $6,000 $6,000 $8,000 $10,000 $10,000 $12,000 $12,000 $13,000 $12,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $14,000 $19,000 $21,000 $26,000 $30,000 $32,000 $36,000 $37,000 $36,000 $42,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
James Dunn 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
4 Facility Staff 0% $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200
2 Sales Staff 0% $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Total People 7 7 7 7 7 7 7 7 7 7 7 7
Total Payroll $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200
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 $0 $0 $28,000 $38,000 $42,000 $52,000 $60,000 $64,000 $72,000 $74,000 $82,000 $84,000
Direct Cost of Sales $0 $0 $14,000 $19,000 $21,000 $26,000 $30,000 $32,000 $36,000 $37,000 $36,000 $42,000
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $14,000 $19,000 $21,000 $26,000 $30,000 $32,000 $36,000 $37,000 $36,000 $42,000
Gross Margin $0 $0 $14,000 $19,000 $21,000 $26,000 $30,000 $32,000 $36,000 $37,000 $46,000 $42,000
Gross Margin % 0.00% 0.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 56.10% 50.00%
Expenses
Payroll $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200
Sales and Marketing and Other Expenses $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
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 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Payroll Taxes 15% $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,430 $2,430
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $21,730 $21,730 $21,730 $21,730 $21,730 $21,730 $21,730 $21,730 $21,730 $21,730 $21,730 $21,730
Profit Before Interest and Taxes ($21,730) ($21,730) ($7,730) ($2,730) ($730) $4,270 $8,270 $10,270 $14,270 $15,270 $24,270 $20,270
EBITDA ($21,730) ($21,730) ($7,730) ($2,730) ($730) $4,270 $8,270 $10,270 $14,270 $15,270 $24,270 $20,270
Interest Expense $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833
Taxes Incurred ($6,769) ($6,769) ($2,569) ($1,069) ($469) $1,031 $2,231 $2,831 $4,031 $4,331 $7,031 $5,831
Net Profit ($15,794) ($15,794) ($5,994) ($2,494) ($1,094) $2,406 $5,206 $6,606 $9,406 $10,106 $16,406 $13,606
Net Profit/Sales 0.00% 0.00% -21.41% -6.56% -2.61% 4.63% 8.68% 10.32% 13.06% 13.66% 20.01% 16.20%
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 $7,000 $9,500 $10,500 $13,000 $15,000 $16,000 $18,000 $18,500 $20,500 $21,000
Cash from Receivables $0 $0 $0 $700 $21,250 $28,600 $31,750 $39,200 $45,100 $48,200 $54,050 $55,700
Subtotal Cash from Operations $0 $0 $7,000 $10,200 $31,750 $41,600 $46,750 $55,200 $63,100 $66,700 $74,550 $76,700
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 $7,000 $10,200 $31,750 $41,600 $46,750 $55,200 $63,100 $66,700 $74,550 $76,700
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 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200 $16,200
Bill Payments ($406) ($798) ($266) $3,844 $5,314 $6,231 $16,894 $43,008 $43,641 $50,728 $48,778 $48,711
Subtotal Spent on Operations $15,794 $15,402 $15,934 $20,044 $21,514 $22,431 $33,094 $59,208 $59,841 $66,928 $64,978 $64,911
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 $15,794 $15,402 $15,934 $20,044 $21,514 $22,431 $33,094 $59,208 $59,841 $66,928 $64,978 $64,911
Net Cash Flow ($15,794) ($15,402) ($8,934) ($9,844) $10,236 $19,169 $13,656 ($4,008) $3,259 ($228) $9,572 $11,789
Cash Balance $67,206 $51,803 $42,869 $33,025 $43,260 $62,429 $76,085 $72,077 $75,336 $75,109 $84,681 $96,470
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 $83,000 $67,206 $51,803 $42,869 $33,025 $43,260 $62,429 $76,085 $72,077 $75,336 $75,109 $84,681 $96,470
Accounts Receivable $0 $0 $0 $21,000 $48,800 $59,050 $69,450 $82,700 $91,500 $100,400 $107,700 $115,150 $122,450
Inventory $100,000 $100,000 $100,000 $86,000 $67,000 $46,000 $28,600 $33,000 $35,200 $39,600 $40,700 $39,600 $46,200
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $183,000 $167,206 $151,803 $149,869 $148,825 $148,310 $160,479 $191,785 $198,777 $215,336 $223,509 $239,431 $265,120
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $183,000 $167,206 $151,803 $149,869 $148,825 $148,310 $160,479 $191,785 $198,777 $215,336 $223,509 $239,431 $265,120
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 $392 $4,452 $5,902 $6,482 $16,245 $42,345 $42,732 $49,885 $47,952 $47,469 $59,552
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 $392 $4,452 $5,902 $6,482 $16,245 $42,345 $42,732 $49,885 $47,952 $47,469 $59,552
Long-term Liabilities $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
Total Liabilities $100,000 $100,000 $100,392 $104,452 $105,902 $106,482 $116,245 $142,345 $142,732 $149,885 $147,952 $147,469 $159,552
Paid-in Capital $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000
Retained Earnings ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000) ($67,000)
Earnings $0 ($15,794) ($31,589) ($37,583) ($40,077) ($41,172) ($38,766) ($33,560) ($26,955) ($17,549) ($7,443) $8,962 $22,568
Total Capital $83,000 $67,206 $51,411 $45,417 $42,923 $41,828 $44,234 $49,440 $56,045 $65,451 $75,557 $91,962 $105,568
Total Liabilities and Capital $183,000 $167,206 $151,803 $149,869 $148,825 $148,310 $160,479 $191,785 $198,777 $215,336 $223,509 $239,431 $265,120
Net Worth $83,000 $67,206 $51,411 $45,417 $42,923 $41,828 $44,234 $49,440 $56,045 $65,451 $75,557 $91,962 $105,568