clair de lune

Start your own business plan »

Lingerie 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
Lingerie 0% $27,930 $36,400 $37,450 $54,964 $25,844 $36,960 $39,312 $38,220 $38,584 $34,944 $31,150 $37,800
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $27,930 $36,400 $37,450 $54,964 $25,844 $36,960 $39,312 $38,220 $38,584 $34,944 $31,150 $37,800
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
Lingerie cost $13,965 $18,200 $18,725 $27,482 $12,922 $18,480 $19,656 $19,110 $19,292 $17,472 $15,575 $18,900
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $13,965 $18,200 $18,725 $27,482 $12,922 $18,480 $19,656 $19,110 $19,292 $17,472 $15,575 $18,900
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
Terry Levine--CEO 0% $2,292 $4,583 $4,583 $4,583 $4,583 $4,583 $4,583 $4,583 $4,583 $4,583 $4,583 $4,583
Manager 0% $3,010 $2,520 $2,520 $3,010 $2,520 $2,520 $2,520 $2,520 $2,520 $2,520 $2,520 $2,520
Salespeople 0% $720 $1,440 $1,440 $1,600 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440
Total People 3 4 4 4 4 4 4 4 4 4 4 4
Total Payroll $6,022 $8,543 $8,543 $9,193 $8,543 $8,543 $8,543 $8,543 $8,543 $8,543 $8,543 $8,543
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 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00%
Long-term Interest Rate 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.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 $27,930 $36,400 $37,450 $54,964 $25,844 $36,960 $39,312 $38,220 $38,584 $34,944 $31,150 $37,800
Direct Cost of Sales $13,965 $18,200 $18,725 $27,482 $12,922 $18,480 $19,656 $19,110 $19,292 $17,472 $15,575 $18,900
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $13,965 $18,200 $18,725 $27,482 $12,922 $18,480 $19,656 $19,110 $19,292 $17,472 $15,575 $18,900
Gross Margin $13,965 $18,200 $18,725 $27,482 $12,922 $18,480 $19,656 $19,110 $19,292 $17,472 $15,575 $18,900
Gross Margin % 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00%
Expenses
Payroll $6,022 $8,543 $8,543 $9,193 $8,543 $8,543 $8,543 $8,543 $8,543 $8,543 $8,543 $8,543
Marketing and Advertising $3,025 $2,025 $2,025 $5,000 $2,315 $2,600 $1,735 $580 $1,735 $2,850 $290 $2,315
Depreciation $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Start-up inventory amortization $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Packaging $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Cell Phone $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Travel $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Utilities $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Merchandiser $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Buying Consultant $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Web Design $0 $0 $0 $0 $1,000 $60 $60 $60 $60 $60 $60 $60
Insurance $208 $208 $208 $208 $208 $208 $208 $208 $208 $208 $208 $208
Credit Card Fees 15% $642 $837 $861 $1,264 $594 $850 $904 $879 $887 $804 $716 $869
Accountant $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Total Operating Expenses $15,397 $17,113 $17,137 $21,165 $18,160 $17,761 $16,950 $15,770 $16,933 $17,965 $15,317 $17,495
Profit Before Interest and Taxes ($1,432) $1,087 $1,588 $6,317 ($5,238) $719 $2,706 $3,340 $2,359 ($493) $258 $1,405
EBITDA ($1,182) $1,337 $1,838 $6,567 ($4,988) $969 $2,956 $3,590 $2,609 ($243) $508 $1,655
Interest Expense $1,119 $1,113 $1,107 $1,101 $1,095 $1,089 $1,082 $1,076 $1,070 $1,064 $1,057 $1,051
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($2,551) ($26) $481 $5,216 ($6,333) ($370) $1,623 $2,264 $1,289 ($1,556) ($800) $354
Net Profit/Sales -9.14% -0.07% 1.28% 9.49% -24.51% -1.00% 4.13% 5.92% 3.34% -4.45% -2.57% 0.94%
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 $27,930 $36,400 $37,450 $54,964 $25,844 $36,960 $39,312 $38,220 $38,584 $34,944 $31,150 $37,800
Subtotal Cash from Operations $27,930 $36,400 $37,450 $54,964 $25,844 $36,960 $39,312 $38,220 $38,584 $34,944 $31,150 $37,800
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 $27,930 $36,400 $37,450 $54,964 $25,844 $36,960 $39,312 $38,220 $38,584 $34,944 $31,150 $37,800
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 $6,022 $8,543 $8,543 $9,193 $8,543 $8,543 $8,543 $8,543 $8,543 $8,543 $8,543 $8,543
Bill Payments $341 $10,217 $9,434 $9,851 $21,060 $11,165 $31,511 $30,068 $26,634 $28,603 $25,551 $21,445
Subtotal Spent on Operations $6,363 $18,760 $17,977 $19,044 $29,603 $19,708 $40,054 $38,611 $35,177 $37,146 $34,094 $29,988
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 $792 $798 $804 $810 $816 $822 $829 $835 $841 $847 $854 $860
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 $7,155 $19,558 $18,781 $19,854 $30,419 $20,530 $40,883 $39,446 $36,018 $37,993 $34,948 $30,848
Net Cash Flow $20,775 $16,842 $18,669 $35,110 ($4,575) $16,430 ($1,571) ($1,226) $2,566 ($3,049) ($3,798) $6,952
Cash Balance $38,975 $55,816 $74,485 $109,596 $105,021 $121,450 $119,879 $118,653 $121,219 $118,170 $114,373 $121,325
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 $18,200 $38,975 $55,816 $74,485 $109,596 $105,021 $121,450 $119,879 $118,653 $121,219 $118,170 $114,373 $121,325
Inventory $100,000 $86,035 $67,835 $49,110 $30,230 $17,308 $20,328 $21,622 $21,021 $21,221 $19,219 $17,133 $20,790
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $118,200 $125,010 $123,651 $123,595 $139,826 $122,329 $141,778 $141,501 $139,674 $142,440 $137,390 $131,505 $142,115
Long-term Assets
Long-term Assets $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
Accumulated Depreciation $0 $250 $500 $750 $1,000 $1,250 $1,500 $1,750 $2,000 $2,250 $2,500 $2,750 $3,000
Total Long-term Assets $15,000 $14,750 $14,500 $14,250 $14,000 $13,750 $13,500 $13,250 $13,000 $12,750 $12,500 $12,250 $12,000
Total Assets $133,200 $139,760 $138,151 $137,845 $153,826 $136,079 $155,278 $154,751 $152,674 $155,190 $149,890 $143,755 $154,115
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 $9,903 $9,119 $9,136 $20,711 $10,114 $30,505 $29,183 $25,677 $27,746 $24,848 $20,368 $31,234
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 $9,903 $9,119 $9,136 $20,711 $10,114 $30,505 $29,183 $25,677 $27,746 $24,848 $20,368 $31,234
Long-term Liabilities $150,000 $149,208 $148,410 $147,606 $146,796 $145,980 $145,158 $144,329 $143,494 $142,653 $141,806 $140,952 $140,092
Total Liabilities $150,000 $159,111 $157,529 $156,742 $167,507 $156,094 $175,663 $173,512 $169,171 $170,399 $166,654 $161,320 $171,326
Paid-in Capital $21,750 $21,750 $21,750 $21,750 $21,750 $21,750 $21,750 $21,750 $21,750 $21,750 $21,750 $21,750 $21,750
Retained Earnings ($38,550) ($38,550) ($38,550) ($38,550) ($38,550) ($38,550) ($38,550) ($38,550) ($38,550) ($38,550) ($38,550) ($38,550) ($38,550)
Earnings $0 ($2,551) ($2,578) ($2,097) $3,119 ($3,215) ($3,584) ($1,961) $303 $1,591 $35 ($764) ($410)
Total Capital ($16,800) ($19,351) ($19,378) ($18,897) ($13,681) ($20,015) ($20,384) ($18,761) ($16,497) ($15,209) ($16,765) ($17,564) ($17,210)
Total Liabilities and Capital $133,200 $139,760 $138,151 $137,845 $153,826 $136,079 $155,278 $154,751 $152,674 $155,190 $149,890 $143,755 $154,115
Net Worth ($16,800) ($19,351) ($19,378) ($18,897) ($13,681) ($20,015) ($20,384) ($18,761) ($16,497) ($15,209) ($16,765) ($17,564) ($17,210)