Poppi Designs

Start your own business plan »

Furniture Import Business Plan

Appendix

Sales Forecast
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Sales
Retailer Sales 0% $8,164 $8,164 $8,164 $8,164 $8,792 $8,792 $8,792 $10,048 $10,048 $11,304 $11,304 $11,304
Designer Sales 0% $1,157 $1,157 $1,157 $1,157 $1,246 $1,246 $1,246 $1,424 $1,424 $1,602 $1,602 $1,602
Wholesale 0% $741 $741 $741 $741 $798 $798 $798 $912 $912 $1,026 $1,026 $1,026
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $10,062 $10,062 $10,062 $10,062 $10,836 $10,836 $10,836 $12,384 $12,384 $13,932 $13,932 $13,932
Direct Cost of Sales Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Retailer Sales 40% $3,266 $3,266 $3,266 $3,266 $3,517 $3,517 $3,517 $4,019 $4,019 $4,522 $4,522 $4,522
Designer Sales 40% $463 $463 $463 $463 $498 $498 $498 $570 $570 $641 $641 $641
Wholesale 40% $296 $296 $296 $296 $319 $319 $319 $365 $365 $410 $410 $410
Other 40% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $4,025 $4,025 $4,025 $4,025 $4,334 $4,334 $4,334 $4,954 $4,954 $5,573 $5,573 $5,573
Personnel Plan
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Admin. Assist. 0% $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666
Owner 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 2 2 2 2 2 2 2 2 2 2 2 2
Total Payroll $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666
General Assumptions
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Long-term Interest Rate 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.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
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Sales $10,062 $10,062 $10,062 $10,062 $10,836 $10,836 $10,836 $12,384 $12,384 $13,932 $13,932 $13,932
Direct Cost of Sales $4,025 $4,025 $4,025 $4,025 $4,334 $4,334 $4,334 $4,954 $4,954 $5,573 $5,573 $5,573
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $4,025 $4,025 $4,025 $4,025 $4,334 $4,334 $4,334 $4,954 $4,954 $5,573 $5,573 $5,573
Gross Margin $6,037 $6,037 $6,037 $6,037 $6,502 $6,502 $6,502 $7,430 $7,430 $8,359 $8,359 $8,359
Gross Margin % 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00% 60.00%
Expenses
Payroll $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666
Sales and Marketing and Other Expenses $4,610 $1,610 $610 $1,610 $610 $1,610 $610 $1,610 $610 $1,610 $610 $1,610
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 (Telephone) $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Insurance (Liability/Fire) $0 $0 $1,500 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent (Warehouse) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 13% $253 $253 $253 $253 $253 $253 $253 $253 $253 $253 $253 $253
Agent Commission 7% $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 $9,029 $6,029 $6,529 $6,029 $5,029 $6,029 $5,029 $6,029 $5,029 $6,029 $5,029 $6,029
Profit Before Interest and Taxes ($2,992) $8 ($492) $8 $1,473 $473 $1,473 $1,401 $2,401 $2,330 $3,330 $2,330
EBITDA ($2,992) $8 ($492) $8 $1,473 $473 $1,473 $1,401 $2,401 $2,330 $3,330 $2,330
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($898) $2 ($123) $2 $368 $118 $368 $350 $600 $583 $833 $583
Net Profit ($2,094) $6 ($369) $6 $1,104 $354 $1,104 $1,051 $1,801 $1,748 $2,498 $1,748
Net Profit/Sales -20.81% 0.06% -3.67% 0.06% 10.19% 3.27% 10.19% 8.49% 14.54% 12.54% 17.93% 12.54%
Pro Forma Cash Flow
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Cash Received
Cash from Operations
Cash Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash from Receivables $6,400 $8,566 $10,062 $10,062 $10,062 $10,475 $10,836 $10,836 $11,662 $12,384 $13,210 $13,932
Subtotal Cash from Operations $6,400 $8,566 $10,062 $10,062 $10,062 $10,475 $10,836 $10,836 $11,662 $12,384 $13,210 $13,932
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 $5,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $21,000 $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 $32,400 $8,566 $10,062 $10,062 $10,062 $10,475 $10,836 $10,836 $11,662 $12,384 $13,210 $13,932
Expenditures Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Expenditures from Operations
Cash Spending $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666 $3,666
Bill Payments $4,149 $4,429 $3,469 $6,475 $6,390 $6,420 $6,791 $6,142 $8,300 $6,993 $9,152 $7,793
Subtotal Spent on Operations $7,815 $8,095 $7,135 $10,141 $10,056 $10,086 $10,457 $9,808 $11,966 $10,659 $12,818 $11,459
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 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
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 $8,815 $9,095 $8,135 $11,141 $11,056 $11,086 $11,457 $10,808 $12,966 $11,659 $13,818 $12,459
Net Cash Flow $23,585 ($528) $1,927 ($1,079) ($994) ($611) ($621) $28 ($1,305) $725 ($608) $1,473
Cash Balance $36,585 $36,057 $37,984 $36,905 $35,911 $35,300 $34,679 $34,708 $33,403 $34,128 $33,520 $34,992
Pro Forma Balance Sheet
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Assets Starting Balances
Current Assets
Cash $13,000 $36,585 $36,057 $37,984 $36,905 $35,911 $35,300 $34,679 $34,708 $33,403 $34,128 $33,520 $34,992
Accounts Receivable $9,600 $13,262 $14,758 $14,758 $14,758 $15,532 $15,893 $15,893 $17,441 $18,163 $19,711 $20,434 $20,434
Inventory $11,764 $7,739 $4,714 $4,427 $4,427 $4,768 $4,768 $4,768 $5,449 $5,449 $6,130 $6,130 $6,130
Other Current Assets $21,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $55,364 $57,586 $55,529 $57,169 $56,090 $56,210 $55,960 $55,340 $57,597 $57,015 $59,969 $60,083 $61,556
Long-term Assets
Long-term Assets $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Accumulated Depreciation $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $55,364 $57,586 $55,529 $57,169 $56,090 $56,210 $55,960 $55,340 $57,597 $57,015 $59,969 $60,083 $61,556
Liabilities and Capital Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Current Liabilities
Accounts Payable $4,000 $4,317 $3,253 $6,262 $6,177 $6,193 $6,588 $5,863 $8,070 $6,686 $8,893 $7,509 $8,234
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $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
Subtotal Current Liabilities $19,000 $19,317 $18,253 $21,262 $21,177 $21,193 $21,588 $20,863 $23,070 $21,686 $23,893 $22,509 $23,234
Long-term Liabilities $180,000 $184,000 $183,000 $182,000 $181,000 $180,000 $179,000 $178,000 $177,000 $176,000 $175,000 $174,000 $173,000
Total Liabilities $199,000 $203,317 $201,253 $203,262 $202,177 $201,193 $200,588 $198,863 $200,070 $197,686 $198,893 $196,509 $196,234
Paid-in Capital $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
Retained Earnings ($153,636) ($153,636) ($153,636) ($153,636) ($153,636) ($153,636) ($153,636) ($153,636) ($153,636) ($153,636) ($153,636) ($153,636) ($153,636)
Earnings $0 ($2,094) ($2,088) ($2,457) ($2,451) ($1,346) ($992) $113 $1,164 $2,965 $4,712 $7,210 $8,958
Total Capital ($143,636) ($145,730) ($145,724) ($146,093) ($146,087) ($144,982) ($144,628) ($143,523) ($142,472) ($140,671) ($138,924) ($136,426) ($134,678)
Total Liabilities and Capital $55,364 $57,586 $55,529 $57,169 $56,090 $56,210 $55,960 $55,340 $57,597 $57,015 $59,969 $60,083 $61,556
Net Worth ($143,636) ($145,730) ($145,724) ($146,093) ($146,087) ($144,982) ($144,628) ($143,523) ($142,472) ($140,671) ($138,924) ($136,426) ($134,678)