Edit This Plan

Artificial Flowers Import Business Plan

Fantastic Florals

This sample business plan can be edited directly in Business Plan Pro software.

previous
next
Page 1   2   3   4   5   6   7   8  

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Unit Sales
Tulips and Roses 0% 2,000 3,000 2,500 1,500 3,000 2,500 3,000 2,200 1,600 1,700 1,800 3,500
Arranged Flowers 1 0% 350 500 500 400 350 500 350 500 350 300 300 600
Arranged Flowers 2 0% 350 500 500 400 350 500 350 500 350 300 300 600
Silk Scarf 0% 600 1,000 600 600 1,000 1,000 1,100 1,200 800 800 800 1,300
Other hair accessories 0% 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Other/seasonal bouquet 0% 500 800 700 500 800 850 600 850 500 500 600 1,000
Catalog Sales 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Unit Sales 4,800 6,800 5,800 4,400 6,500 6,350 6,400 6,250 4,600 4,600 4,800 8,000
Unit Prices Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Tulips and Roses $2.25 $2.25 $2.25 $2.25 $2.25 $2.25 $2.25 $2.25 $2.25 $2.25 $2.25 $2.25
Arranged Flowers 1 $18.99 $18.99 $18.99 $18.99 $18.99 $18.99 $18.99 $18.99 $18.99 $18.99 $18.99 $18.99
Arranged Flowers 2 $39.99 $39.99 $39.99 $39.99 $39.99 $39.99 $39.99 $39.99 $39.99 $39.99 $39.99 $39.99
Silk Scarf $15.99 $15.99 $15.99 $15.99 $15.99 $15.99 $15.99 $15.99 $15.99 $15.99 $15.99 $15.99
Other hair accessories $9.99 $9.99 $9.99 $9.99 $9.99 $9.99 $9.99 $9.99 $9.99 $9.99 $9.99 $9.99
Other/seasonal bouquet $59.99 $59.99 $59.99 $59.99 $59.99 $59.99 $59.99 $59.99 $59.99 $59.99 $59.99 $59.99
Catalog Sales $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Sales
Tulips and Roses $4,500 $6,750 $5,625 $3,375 $6,750 $5,625 $6,750 $4,950 $3,600 $3,825 $4,050 $7,875
Arranged Flowers 1 $6,646 $9,495 $9,495 $7,596 $6,646 $9,495 $6,646 $9,495 $6,646 $5,697 $5,697 $11,394
Arranged Flowers 2 $13,997 $19,995 $19,995 $15,996 $13,997 $19,995 $13,997 $19,995 $13,997 $11,997 $11,997 $23,994
Silk Scarf $9,594 $15,990 $9,594 $9,594 $15,990 $15,990 $17,589 $19,188 $12,792 $12,792 $12,792 $20,787
Other hair accessories $9,990 $9,990 $9,990 $9,990 $9,990 $9,990 $9,990 $9,990 $9,990 $9,990 $9,990 $9,990
Other/seasonal bouquet $29,995 $47,992 $41,993 $29,995 $47,992 $50,992 $35,994 $50,992 $29,995 $29,995 $35,994 $59,990
Catalog Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $74,722 $110,212 $96,692 $76,546 $101,365 $112,087 $90,966 $114,610 $77,020 $74,296 $80,520 $134,030
Direct Unit Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Tulips and Roses 66.66% $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50
Arranged Flowers 1 63.14% $11.99 $11.99 $11.99 $11.99 $11.99 $11.99 $11.99 $11.99 $11.99 $11.99 $11.99 $11.99
Arranged Flowers 2 70.00% $27.99 $27.99 $27.99 $27.99 $27.99 $27.99 $27.99 $27.99 $27.99 $27.99 $27.99 $27.99
Silk Scarf 53.16% $8.50 $8.50 $8.50 $8.50 $8.50 $8.50 $8.50 $8.50 $8.50 $8.50 $8.50 $8.50
Other hair accessories 65.07% $6.50 $6.50 $6.50 $6.50 $6.50 $6.50 $6.50 $6.50 $6.50 $6.50 $6.50 $6.50
Other/seasonal bouquet 70.00% $41.99 $41.99 $41.99 $41.99 $41.99 $41.99 $41.99 $41.99 $41.99 $41.99 $41.99 $41.99
Catalog Sales 66.66% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Sales
Tulips and Roses $3,000 $4,500 $3,750 $2,250 $4,500 $3,750 $4,500 $3,300 $2,400 $2,550 $2,700 $5,249
Arranged Flowers 1 $4,197 $5,995 $5,995 $4,796 $4,197 $5,995 $4,197 $5,995 $4,197 $3,597 $3,597 $7,194
Arranged Flowers 2 $9,797 $13,996 $13,996 $11,197 $9,797 $13,996 $9,797 $13,996 $9,797 $8,398 $8,398 $16,796
Silk Scarf $5,100 $8,500 $5,100 $5,100 $8,500 $8,500 $9,350 $10,200 $6,800 $6,800 $6,800 $11,050
Other hair accessories $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500
Other/seasonal bouquet $20,997 $33,594 $29,395 $20,997 $33,594 $35,694 $25,196 $35,694 $20,997 $20,997 $25,196 $41,993
Catalog Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $49,591 $73,086 $64,737 $50,840 $67,089 $74,436 $59,540 $75,686 $50,691 $48,842 $53,191 $88,783
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Production/Fulfillment 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Sales and Marketing 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Administration 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $74,722 $110,212 $96,692 $76,546 $101,365 $112,087 $90,966 $114,610 $77,020 $74,296 $80,520 $134,030
Direct Cost of Sales $49,591 $73,086 $64,737 $50,840 $67,089 $74,436 $59,540 $75,686 $50,691 $48,842 $53,191 $88,783
Shipping, etc. $3,000 $3,060 $3,121 $3,184 $3,247 $3,312 $3,378 $3,446 $3,515 $3,585 $3,657 $3,730
Total Cost of Sales $52,591 $76,146 $67,858 $54,024 $70,336 $77,748 $62,918 $79,132 $54,206 $52,427 $56,848 $92,513
Gross Margin $22,131 $34,066 $28,834 $22,522 $31,029 $34,339 $28,048 $35,478 $22,814 $21,869 $23,672 $41,517
Gross Margin % 29.62% 30.91% 29.82% 29.42% 30.61% 30.64% 30.83% 30.96% 29.62% 29.44% 29.40% 30.98%
Expenses
Payroll $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600
Marketing/Promotion $6,355 $7,788 $7,160 $6,257 $7,279 $7,676 $6,720 $7,815 $6,290 $6,180 $6,395 $8,540
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Payroll Taxes 18% $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 $12,055 $13,488 $12,860 $11,957 $12,979 $13,376 $12,420 $13,515 $11,990 $11,880 $12,095 $14,240
Profit Before Interest and Taxes $10,076 $20,578 $15,974 $10,565 $18,050 $20,963 $15,628 $21,963 $10,824 $9,989 $11,577 $27,277
EBITDA $10,076 $20,578 $15,974 $10,565 $18,050 $20,963 $15,628 $21,963 $10,824 $9,989 $11,577 $27,277
Interest Expense $282 $273 $264 $255 $245 $236 $227 $218 $208 $199 $190 $181
Taxes Incurred $2,938 $6,091 $4,713 $3,093 $5,341 $6,218 $4,620 $6,523 $3,185 $2,937 $3,416 $8,129
Net Profit $6,856 $14,213 $10,997 $7,217 $12,463 $14,509 $10,781 $15,221 $7,431 $6,853 $7,971 $18,967
Net Profit/Sales 9.17% 12.90% 11.37% 9.43% 12.30% 12.94% 11.85% 13.28% 9.65% 9.22% 9.90% 14.15%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $56,042 $82,659 $72,519 $57,410 $76,024 $84,065 $68,225 $85,957 $57,765 $55,722 $60,390 $100,523
Cash from Receivables $0 $623 $18,976 $27,440 $24,005 $19,343 $25,431 $27,846 $22,939 $28,339 $19,232 $18,626
Subtotal Cash from Operations $56,042 $83,282 $91,495 $84,850 $100,029 $103,408 $93,655 $113,803 $80,704 $84,061 $79,622 $119,148
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 $56,042 $83,282 $91,495 $84,850 $100,029 $103,408 $93,655 $113,803 $80,704 $84,061 $79,622 $119,148
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600
Bill Payments $6,895 $113,925 $114,489 $73,015 $53,489 $101,543 $100,004 $63,364 $109,569 $41,694 $62,371 $75,757
Subtotal Spent on Operations $10,495 $117,525 $118,089 $76,615 $57,089 $105,143 $103,604 $66,964 $113,169 $45,294 $65,971 $79,357
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 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111 $1,111
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 $11,606 $118,636 $119,200 $77,726 $58,200 $106,254 $104,715 $68,075 $114,280 $46,405 $67,082 $80,468
Net Cash Flow $44,435 ($35,354) ($27,705) $7,124 $41,829 ($2,846) ($11,060) $45,727 ($33,577) $37,656 $12,541 $38,680
Cash Balance $114,435 $79,081 $51,376 $58,500 $100,328 $97,483 $86,423 $132,150 $98,574 $136,230 $148,770 $187,451
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $70,000 $114,435 $79,081 $51,376 $58,500 $100,328 $97,483 $86,423 $132,150 $98,574 $136,230 $148,770 $187,451
Accounts Receivable $0 $18,681 $45,611 $50,808 $42,504 $43,840 $52,518 $49,829 $50,636 $46,952 $37,187 $38,085 $52,967
Inventory $0 $49,591 $73,086 $64,737 $50,840 $67,089 $74,436 $59,540 $75,686 $50,691 $48,842 $53,191 $88,783
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $70,000 $182,707 $197,778 $166,920 $151,844 $211,257 $224,437 $195,792 $258,472 $196,217 $222,259 $240,046 $329,200
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