Grutzen Watches

Start your own business plan »

Export Watch Manufacturer 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
Sales 0% $81,000 $81,000 $81,000 $175,000 $81,000 $81,000 $81,000 $81,000 $81,000 $81,000 $81,000 $81,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $81,000 $81,000 $81,000 $175,000 $81,000 $81,000 $81,000 $81,000 $81,000 $81,000 $81,000 $81,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
Sales $32,000 $32,000 $32,000 $58,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $32,000 $32,000 $32,000 $58,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,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
President 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
Head of American Division 0% $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500
Vice President American Division 0% $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Other 0% $8,700 $8,700 $8,700 $8,700 $8,700 $8,700 $8,700 $8,700 $8,700 $8,700 $8,700 $8,700
Total People 6 6 6 6 6 6 6 6 6 6 6 6
Total Payroll $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700
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 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.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 $81,000 $81,000 $81,000 $175,000 $81,000 $81,000 $81,000 $81,000 $81,000 $81,000 $81,000 $81,000
Direct Cost of Sales $32,000 $32,000 $32,000 $58,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000
Other $2,750 $2,750 $2,750 $2,750 $2,750 $2,750 $2,750 $2,750 $2,750 $2,750 $2,750 $2,750
Total Cost of Sales $34,750 $34,750 $34,750 $60,750 $34,750 $34,750 $34,750 $34,750 $34,750 $34,750 $34,750 $34,750
Gross Margin $46,250 $46,250 $46,250 $114,250 $46,250 $46,250 $46,250 $46,250 $46,250 $46,250 $46,250 $46,250
Gross Margin % 57.10% 57.10% 57.10% 65.29% 57.10% 57.10% 57.10% 57.10% 57.10% 57.10% 57.10% 57.10%
Expenses
Payroll $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700
Sales and Marketing and Other Expenses $8,350 $8,350 $8,350 $8,900 $8,275 $8,350 $8,350 $8,350 $8,350 $8,350 $8,350 $8,350
Depreciation $292 $292 $292 $292 $292 $292 $292 $292 $292 $292 $292 $292
Leased Equipment $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Utilities $500 $500 $550 $600 $575 $550 $500 $500 $500 $500 $550 $500
Insurance $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Rent $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Other $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Payroll Taxes 12% $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 $45,842 $45,842 $45,892 $46,492 $45,842 $45,892 $45,842 $45,842 $45,842 $45,842 $45,892 $45,842
Profit Before Interest and Taxes $408 $408 $358 $67,758 $408 $358 $408 $408 $408 $408 $358 $408
EBITDA $700 $700 $650 $68,050 $700 $650 $700 $700 $700 $700 $650 $700
Interest Expense $397 $395 $392 $732 $729 $727 $557 $555 $552 $383 $381 $378
Taxes Incurred $3 $3 ($9) $16,757 ($80) ($92) ($37) ($37) ($36) $6 ($6) $7
Net Profit $7 $10 ($26) $50,270 ($241) ($276) ($112) ($110) ($108) $19 ($17) $22
Net Profit/Sales 0.01% 0.01% -0.03% 28.73% -0.30% -0.34% -0.14% -0.14% -0.13% 0.02% -0.02% 0.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 $40,500 $40,500 $40,500 $87,500 $40,500 $40,500 $40,500 $40,500 $40,500 $40,500 $40,500 $40,500
Cash from Receivables $0 $1,350 $40,500 $40,500 $42,067 $85,933 $40,500 $40,500 $40,500 $40,500 $40,500 $40,500
Subtotal Cash from Operations $40,500 $41,850 $81,000 $128,000 $82,567 $126,433 $81,000 $81,000 $81,000 $81,000 $81,000 $81,000
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 $41,000 $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 $40,500 $41,850 $81,000 $169,000 $82,567 $126,433 $81,000 $81,000 $81,000 $81,000 $81,000 $81,000
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 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700 $24,700
Bill Payments $7,207 $65,861 $55,999 $58,444 $124,982 $28,603 $56,279 $56,120 $56,118 $56,112 $55,991 $56,024
Subtotal Spent on Operations $31,907 $90,561 $80,699 $83,144 $149,682 $53,303 $80,979 $80,820 $80,818 $80,812 $80,691 $80,724
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 $20,000 $0 $0 $20,000 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $334 $334 $334 $334 $333 $333 $333 $333 $333 $333 $333 $333
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 $32,241 $90,895 $81,033 $83,478 $150,015 $53,636 $101,312 $81,153 $81,151 $101,145 $81,024 $81,057
Net Cash Flow $8,259 ($49,045) ($33) $85,522 ($67,448) $72,797 ($20,312) ($153) ($151) ($20,145) ($24) ($57)
Cash Balance $78,259 $29,215 $29,181 $114,703 $47,255 $120,052 $99,740 $99,587 $99,436 $79,291 $79,267 $79,210
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 $70,000 $78,259 $29,215 $29,181 $114,703 $47,255 $120,052 $99,740 $99,587 $99,436 $79,291 $79,267 $79,210
Accounts Receivable $0 $40,500 $79,650 $79,650 $126,650 $125,083 $79,650 $79,650 $79,650 $79,650 $79,650 $79,650 $79,650
Inventory $25,000 $35,200 $35,200 $35,200 $63,800 $35,200 $35,200 $35,200 $35,200 $35,200 $35,200 $35,200 $35,200
Other Current Assets $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
Total Current Assets $100,000 $158,959 $149,065 $149,031 $310,153 $212,538 $239,902 $219,590 $219,437 $219,286 $199,141 $199,117 $199,060
Long-term Assets
Long-term Assets $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000
Accumulated Depreciation $0 $292 $584 $876 $1,168 $1,460 $1,752 $2,044 $2,336 $2,628 $2,920 $3,212 $3,504
Total Long-term Assets $35,000 $34,708 $34,416 $34,124 $33,832 $33,540 $33,248 $32,956 $32,664 $32,372 $32,080 $31,788 $31,496
Total Assets $135,000 $193,667 $183,481 $183,155 $343,985 $246,078 $273,150 $252,546 $252,101 $251,658 $231,221 $230,905 $230,556
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 $5,000 $63,994 $54,132 $54,166 $124,060 $26,727 $54,408 $54,249 $54,248 $54,246 $54,123 $54,158 $54,120
Current Borrowing $30,000 $30,000 $30,000 $30,000 $71,000 $71,000 $71,000 $51,000 $51,000 $51,000 $31,000 $31,000 $31,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $35,000 $93,994 $84,132 $84,166 $195,060 $97,727 $125,408 $105,249 $105,248 $105,246 $85,123 $85,158 $85,120
Long-term Liabilities $20,000 $19,666 $19,332 $18,998 $18,664 $18,331 $17,998 $17,665 $17,332 $16,999 $16,666 $16,333 $16,000
Total Liabilities $55,000 $113,660 $103,464 $103,164 $213,724 $116,058 $143,406 $122,914 $122,580 $122,245 $101,789 $101,491 $101,120
Paid-in Capital $171,000 $171,000 $171,000 $171,000 $171,000 $171,000 $171,000 $171,000 $171,000 $171,000 $171,000 $171,000 $171,000
Retained Earnings ($91,000) ($91,000) ($91,000) ($91,000) ($91,000) ($91,000) ($91,000) ($91,000) ($91,000) ($91,000) ($91,000) ($91,000) ($91,000)
Earnings $0 $7 $17 ($9) $50,261 $50,020 $49,744 $49,632 $49,521 $49,413 $49,431 $49,414 $49,437
Total Capital $80,000 $80,007 $80,017 $79,991 $130,261 $130,020 $129,744 $129,632 $129,521 $129,413 $129,431 $129,414 $129,437
Total Liabilities and Capital $135,000 $193,667 $183,481 $183,155 $343,985 $246,078 $273,150 $252,546 $252,101 $251,658 $231,221 $230,905 $230,556
Net Worth $80,000 $80,007 $80,017 $79,991 $130,261 $130,020 $129,744 $129,632 $129,521 $129,413 $129,431 $129,414 $129,437