Classique Gifts Etc.

Start your own business plan »

Gifts and Collectibles Retail Shop 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
Dolls & Accessories 0% $7,400 $7,900 $5,350 $5,230 $5,600 $5,850 $6,475 $5,500 $5,400 $5,450 $5,700 $6,250
Gifts 0% $7,400 $7,900 $5,250 $5,230 $5,500 $5,750 $6,375 $5,400 $5,300 $5,450 $5,600 $6,250
Total Sales $14,800 $15,800 $10,600 $10,460 $11,100 $11,600 $12,850 $10,900 $10,700 $10,900 $11,300 $12,500
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
Dolls & Accessories $3,900 $4,243 $2,690 $2,759 $3,425 $3,550 $3,988 $2,988 $3,150 $3,125 $3,150 $3,903
Gifts $3,900 $4,250 $2,690 $2,759 $3,425 $3,550 $3,998 $2,988 $3,150 $3,125 $3,150 $3,900
Subtotal Direct Cost of Sales $7,800 $8,493 $5,380 $5,518 $6,850 $7,100 $7,986 $5,976 $6,300 $6,250 $6,300 $7,803
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
Brenda Owner/Manager-Sales & Merchandising 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,300 $1,300
Charles Owner/Manager-Operations & Finance 0% $0 $0 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Part-Time as Needed ($7 per hour) 0% $280 $560 $0 $0 $0 $300 $300 $320 $320 $320 $320 $400
Total People 3 3 2 2 2 3 3 3 3 3 3 3
Total Payroll $1,480 $1,760 $2,100 $2,100 $2,100 $2,400 $2,400 $2,420 $2,420 $2,420 $2,520 $2,600
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 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Long-term Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 $14,800 $15,800 $10,600 $10,460 $11,100 $11,600 $12,850 $10,900 $10,700 $10,900 $11,300 $12,500
Direct Cost of Sales $7,800 $8,493 $5,380 $5,518 $6,850 $7,100 $7,986 $5,976 $6,300 $6,250 $6,300 $7,803
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $7,800 $8,493 $5,380 $5,518 $6,850 $7,100 $7,986 $5,976 $6,300 $6,250 $6,300 $7,803
Gross Margin $7,000 $7,307 $5,220 $4,942 $4,250 $4,500 $4,864 $4,924 $4,400 $4,650 $5,000 $4,697
Gross Margin % 47.30% 46.25% 49.25% 47.25% 38.29% 38.79% 37.85% 45.17% 41.12% 42.66% 44.25% 37.58%
Expenses
Payroll $1,480 $1,760 $2,100 $2,100 $2,100 $2,400 $2,400 $2,420 $2,420 $2,420 $2,520 $2,600
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $300 $300
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent and CAM Expense $0 $1,650 $1,650 $1,650 $1,650 $1,650 $1,650 $1,650 $1,650 $1,650 $1,650 $1,650
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Liability Insurance:Store $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance (medical Brenda & Charles) $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650 $650
Payroll Taxes 15% $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 $2,430 $4,360 $4,700 $4,700 $4,700 $5,000 $5,000 $5,020 $5,020 $5,020 $5,420 $5,500
Profit Before Interest and Taxes $4,570 $2,947 $520 $242 ($450) ($500) ($136) ($96) ($620) ($370) ($420) ($803)
EBITDA $4,570 $2,947 $520 $242 ($450) ($500) ($136) ($96) ($620) ($370) ($420) ($803)
Interest Expense $287 $283 $278 $274 $270 $265 $261 $256 $252 $248 $243 $239
Taxes Incurred $1,285 $799 $72 ($10) ($216) ($230) ($119) ($106) ($262) ($185) ($199) ($313)
Net Profit $2,998 $1,865 $169 ($22) ($504) ($536) ($278) ($247) ($610) ($432) ($464) ($729)
Net Profit/Sales 20.26% 11.80% 1.60% -0.21% -4.54% -4.62% -2.16% -2.26% -5.70% -3.97% -4.11% -5.83%
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 $14,800 $15,800 $10,600 $10,460 $11,100 $11,600 $12,850 $10,900 $10,700 $10,900 $11,300 $12,500
Subtotal Cash from Operations $14,800 $15,800 $10,600 $10,460 $11,100 $11,600 $12,850 $10,900 $10,700 $10,900 $11,300 $12,500
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 $14,800 $15,800 $10,600 $10,460 $11,100 $11,600 $12,850 $10,900 $10,700 $10,900 $11,300 $12,500
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 $1,480 $1,760 $2,100 $2,100 $2,100 $2,400 $2,400 $2,420 $2,420 $2,420 $2,520 $2,600
Bill Payments $84 $2,561 $3,658 $2,948 $2,857 $2,785 $6,757 $11,529 $6,607 $9,234 $8,872 $9,399
Subtotal Spent on Operations $1,564 $4,321 $5,758 $5,048 $4,957 $5,185 $9,157 $13,949 $9,027 $11,654 $11,392 $11,999
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 $755 $755 $755 $755 $755 $755 $755 $755 $755 $755 $755 $755
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 $2,319 $5,076 $6,513 $5,803 $5,712 $5,940 $9,912 $14,704 $9,782 $12,409 $12,147 $12,754
Net Cash Flow $12,481 $10,724 $4,087 $4,657 $5,388 $5,660 $2,938 ($3,804) $918 ($1,509) ($847) ($254)
Cash Balance $24,666 $35,390 $39,477 $44,134 $49,522 $55,182 $58,120 $54,315 $55,234 $53,725 $52,878 $52,624
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 $12,185 $24,666 $35,390 $39,477 $44,134 $49,522 $55,182 $58,120 $54,315 $55,234 $53,725 $52,878 $52,624
Inventory $45,000 $37,200 $28,707 $23,327 $17,809 $10,959 $7,810 $8,785 $6,574 $6,930 $6,875 $6,930 $8,583
Other Current Assets $12,757 $12,757 $12,757 $12,757 $12,757 $12,757 $12,757 $12,757 $12,757 $12,757 $12,757 $12,757 $12,757
Total Current Assets $69,942 $74,623 $76,854 $75,561 $74,700 $73,238 $75,749 $79,662 $73,646 $74,921 $73,357 $72,565 $73,964
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 $69,942 $74,623 $76,854 $75,561 $74,700 $73,238 $75,749 $79,662 $73,646 $74,921 $73,357 $72,565 $73,964
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 $2,438 $3,559 $2,853 $2,769 $2,565 $6,367 $11,312 $6,299 $8,939 $8,562 $8,989 $11,873
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 $2,438 $3,559 $2,853 $2,769 $2,565 $6,367 $11,312 $6,299 $8,939 $8,562 $8,989 $11,873
Long-term Liabilities $50,000 $49,245 $48,490 $47,735 $46,980 $46,225 $45,470 $44,715 $43,960 $43,205 $42,450 $41,695 $40,940
Total Liabilities $50,000 $51,683 $52,049 $50,588 $49,749 $48,790 $51,837 $56,027 $50,259 $52,144 $51,012 $50,684 $52,813
Paid-in Capital $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
Retained Earnings ($20,058) ($20,058) ($20,058) ($20,058) ($20,058) ($20,058) ($20,058) ($20,058) ($20,058) ($20,058) ($20,058) ($20,058) ($20,058)
Earnings $0 $2,998 $4,863 $5,032 $5,009 $4,506 $3,970 $3,692 $3,446 $2,835 $2,403 $1,939 $1,209
Total Capital $19,942 $22,940 $24,805 $24,974 $24,951 $24,448 $23,912 $23,634 $23,388 $22,777 $22,345 $21,881 $21,151
Total Liabilities and Capital $69,942 $74,623 $76,854 $75,561 $74,700 $73,238 $75,749 $79,662 $73,646 $74,921 $73,357 $72,565 $73,964
Net Worth $19,942 $22,940 $24,805 $24,974 $24,951 $24,448 $23,912 $23,634 $23,388 $22,777 $22,345 $21,881 $21,151