Trestle Creek Cabinets

Start your own business plan »

Furniture 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
Cabinets 0% $0 $0 $42,000 $12,500 $80,000 $30,000 $50,000 $55,000 $60,000 $45,000 $37,500 $30,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $0 $42,000 $12,500 $80,000 $30,000 $50,000 $55,000 $60,000 $45,000 $37,500 $30,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
Cabinets $0 $0 $0 $9,000 $57,600 $21,000 $36,000 $41,500 $48,000 $36,000 $30,000 $22,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $0 $9,000 $57,600 $21,000 $36,000 $41,500 $48,000 $36,000 $30,000 $22,500
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
Martin Kribs 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
Brent Palmer 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
Carpenters 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
Administration Assistant 0% $0 $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total People 3 3 3 3 3 3 4 4 4 4 4 4
Total Payroll $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,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% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.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 $42,000 $12,500 $80,000 $30,000 $50,000 $55,000 $60,000 $45,000 $37,500 $30,000
Direct Cost of Sales $0 $0 $0 $9,000 $57,600 $21,000 $36,000 $41,500 $48,000 $36,000 $30,000 $22,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $9,000 $57,600 $21,000 $36,000 $41,500 $48,000 $36,000 $30,000 $22,500
Gross Margin $0 $0 $42,000 $3,500 $22,400 $9,000 $14,000 $13,500 $12,000 $9,000 $7,500 $7,500
Gross Margin % 0.00% 0.00% 100.00% 28.00% 28.00% 30.00% 28.00% 24.55% 20.00% 20.00% 20.00% 25.00%
Expenses
Payroll $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500
Sales and Marketing and Other Expenses $1,150 $1,150 $21,646 $1,800 $5,184 $1,550 $5,150 $2,150 $1,550 $1,400 $1,400 $1,550
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Insurance $95 $95 $95 $95 $95 $95 $95 $95 $95 $95 $95 $95
Rent $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
Payroll Taxes 15% $825 $825 $825 $825 $825 $825 $1,125 $1,125 $1,125 $1,125 $1,125 $1,125
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $8,520 $8,520 $29,016 $9,170 $12,554 $8,920 $14,820 $11,820 $11,220 $11,070 $11,070 $11,220
Profit Before Interest and Taxes ($8,520) ($8,520) $12,984 ($5,670) $9,846 $80 ($820) $1,680 $780 ($2,070) ($3,570) ($3,720)
EBITDA ($8,520) ($8,520) $12,984 ($5,670) $9,846 $80 ($820) $1,680 $780 ($2,070) ($3,570) ($3,720)
Interest Expense $333 $333 $333 $333 $333 $333 $333 $333 $333 $333 $333 $333
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($8,853) ($8,853) $12,651 ($6,003) $9,513 ($253) ($1,153) $1,347 $447 ($2,403) ($3,903) ($4,053)
Net Profit/Sales 0.00% 0.00% 30.12% -48.03% 11.89% -0.84% -2.31% 2.45% 0.74% -5.34% -10.41% -13.51%
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 $10,500 $3,125 $20,000 $7,500 $12,500 $13,750 $15,000 $11,250 $9,375 $7,500
Cash from Receivables $0 $0 $0 $1,050 $30,763 $11,063 $58,750 $23,000 $37,625 $41,375 $44,625 $33,563
Subtotal Cash from Operations $0 $0 $10,500 $4,175 $50,763 $18,563 $71,250 $36,750 $52,625 $52,625 $54,000 $41,063
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 $10,500 $4,175 $50,763 $18,563 $71,250 $36,750 $52,625 $52,625 $54,000 $41,063
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 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500
Bill Payments $112 $3,353 $4,037 $23,488 $14,736 $63,646 $25,383 $43,737 $46,350 $51,648 $39,703 $33,658
Subtotal Spent on Operations $5,612 $8,853 $9,537 $28,988 $20,236 $69,146 $32,883 $51,237 $53,850 $59,148 $47,203 $41,158
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 $5,612 $8,853 $9,537 $28,988 $20,236 $69,146 $32,883 $51,237 $53,850 $59,148 $47,203 $41,158
Net Cash Flow ($5,612) ($8,853) $963 ($24,813) $30,526 ($50,584) $38,367 ($14,487) ($1,225) ($6,523) $6,797 ($96)
Cash Balance $83,687 $74,834 $75,797 $50,984 $81,511 $30,927 $69,294 $54,807 $53,582 $47,059 $53,855 $53,759
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 $89,299 $83,687 $74,834 $75,797 $50,984 $81,511 $30,927 $69,294 $54,807 $53,582 $47,059 $53,855 $53,759
Accounts Receivable $0 $0 $0 $31,500 $39,825 $69,063 $80,500 $59,250 $77,500 $84,875 $77,250 $60,750 $49,688
Other Current Assets $14,478 $14,478 $14,478 $14,478 $14,478 $14,478 $14,478 $14,478 $14,478 $14,478 $14,478 $14,478 $14,478
Total Current Assets $103,777 $98,165 $89,312 $121,775 $105,287 $165,051 $125,905 $143,022 $146,785 $152,935 $138,787 $129,083 $117,925
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 $103,777 $98,165 $89,312 $121,775 $105,287 $165,051 $125,905 $143,022 $146,785 $152,935 $138,787 $129,083 $117,925
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 $3,242 $3,242 $23,054 $12,570 $62,821 $23,928 $42,198 $44,615 $50,318 $38,573 $32,773 $25,668
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 $3,242 $3,242 $23,054 $12,570 $62,821 $23,928 $42,198 $44,615 $50,318 $38,573 $32,773 $25,668
Long-term Liabilities $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
Total Liabilities $40,000 $43,242 $43,242 $63,054 $52,570 $102,821 $63,928 $82,198 $84,615 $90,318 $78,573 $72,773 $65,668
Paid-in Capital $88,419 $88,419 $88,419 $88,419 $88,419 $88,419 $88,419 $88,419 $88,419 $88,419 $88,419 $88,419 $88,419
Retained Earnings ($24,642) ($24,642) ($24,642) ($24,642) ($24,642) ($24,642) ($24,642) ($24,642) ($24,642) ($24,642) ($24,642) ($24,642) ($24,642)
Earnings $0 ($8,853) ($17,707) ($5,056) ($11,059) ($1,547) ($1,800) ($2,953) ($1,607) ($1,160) ($3,563) ($7,467) ($11,520)
Total Capital $63,777 $54,923 $46,070 $58,721 $52,717 $62,230 $61,977 $60,823 $62,170 $62,617 $60,213 $56,310 $52,257
Total Liabilities and Capital $103,777 $98,165 $89,312 $121,775 $105,287 $165,051 $125,905 $143,022 $146,785 $152,935 $138,787 $129,083 $117,925
Net Worth $63,777 $54,923 $46,070 $58,721 $52,717 $62,230 $61,977 $60,823 $62,170 $62,617 $60,213 $56,310 $52,257