Poppi Designs furniture import business plan appendix. Poppi Designs' mission is to supply imported Spanish chairs and other furniture items to certain market niches which are not well served by the large domestic manufacturers.

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)
Poppi Designs furniture import business plan appendix. Poppi Designs' mission is to supply imported Spanish chairs and other furniture items to certain market niches which are not well served by the large domestic manufacturers.