Independent Choice Flicks

Start your own business plan »

Independent Video Store 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
Under 30 0% $0 $0 $3,500 $3,954 $4,315 $4,998 $5,621 $6,174 $6,825 $8,154 $9,198 $10,554
Over 30 0% $0 $0 $3,200 $3,552 $3,845 $4,085 $4,310 $4,887 $5,287 $6,845 $7,425 $7,754
Total Sales $0 $0 $6,700 $7,506 $8,160 $9,083 $9,931 $11,061 $12,112 $14,999 $16,623 $18,308
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
Under 30 $0 $0 $1,225 $1,384 $1,510 $1,749 $1,967 $2,161 $2,389 $2,854 $3,219 $3,694
Over 30 $0 $0 $1,120 $1,243 $1,346 $1,430 $1,509 $1,710 $1,850 $2,396 $2,599 $2,714
Subtotal Direct Cost of Sales $0 $0 $2,345 $2,627 $2,856 $3,179 $3,476 $3,871 $4,239 $5,250 $5,818 $6,408
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
Janet 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
Part-time employee 0% $0 $0 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Part-time employee 0% $0 $0 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Part-time employee 0% $0 $0 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Full-time employee 0% $0 $0 $0 $0 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Total People 1 1 4 4 5 5 5 5 5 5 5 5
Total Payroll $2,000 $2,000 $4,700 $4,700 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500
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 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.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
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 $0 $0 $6,700 $7,506 $8,160 $9,083 $9,931 $11,061 $12,112 $14,999 $16,623 $18,308
Direct Cost of Sales $0 $0 $2,345 $2,627 $2,856 $3,179 $3,476 $3,871 $4,239 $5,250 $5,818 $6,408
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $2,345 $2,627 $2,856 $3,179 $3,476 $3,871 $4,239 $5,250 $5,818 $6,408
Gross Margin $0 $0 $4,355 $4,879 $5,304 $5,904 $6,455 $7,190 $7,873 $9,749 $10,805 $11,900
Gross Margin % 0.00% 0.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00%
Expenses
Payroll $2,000 $2,000 $4,700 $4,700 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500
Sales and Marketing and Other Expenses $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $256 $256 $256 $256 $256 $256 $256 $256 $256 $256 $256 $256
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Insurance $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Rent $850 $850 $850 $850 $850 $850 $850 $850 $850 $850 $850 $850
Payroll Taxes 15% $300 $300 $705 $705 $975 $975 $975 $975 $975 $975 $975 $975
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $3,906 $3,906 $7,011 $7,011 $9,081 $9,081 $9,081 $9,081 $9,081 $9,081 $9,081 $9,081
Profit Before Interest and Taxes ($3,906) ($3,906) ($2,656) ($2,132) ($3,777) ($3,177) ($2,626) ($1,891) ($1,208) $668 $1,724 $2,819
EBITDA ($3,650) ($3,650) ($2,400) ($1,876) ($3,521) ($2,921) ($2,370) ($1,635) ($952) $924 $1,980 $3,075
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($3,906) ($3,906) ($2,656) ($2,132) ($3,777) ($3,177) ($2,626) ($1,891) ($1,208) $668 $1,724 $2,819
Net Profit/Sales 0.00% 0.00% -39.64% -28.41% -46.29% -34.98% -26.44% -17.10% -9.98% 4.46% 10.37% 15.40%
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 $0 $0 $6,700 $7,506 $8,160 $9,083 $9,931 $11,061 $12,112 $14,999 $16,623 $18,308
Subtotal Cash from Operations $0 $0 $6,700 $7,506 $8,160 $9,083 $9,931 $11,061 $12,112 $14,999 $16,623 $18,308
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 $0 $0 $6,700 $7,506 $8,160 $9,083 $9,931 $11,061 $12,112 $14,999 $16,623 $18,308
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 $2,000 $2,000 $4,700 $4,700 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500
Bill Payments $55 $1,650 $1,828 $6,913 $5,007 $5,447 $5,868 $6,144 $6,643 $7,026 $8,689 $8,789
Subtotal Spent on Operations $2,055 $3,650 $6,528 $11,613 $11,507 $11,947 $12,368 $12,644 $13,143 $13,526 $15,189 $15,289
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 $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 $2,055 $3,650 $6,528 $11,613 $11,507 $11,947 $12,368 $12,644 $13,143 $13,526 $15,189 $15,289
Net Cash Flow ($2,055) ($3,650) $172 ($4,107) ($3,347) ($2,864) ($2,437) ($1,583) ($1,031) $1,473 $1,434 $3,019
Cash Balance $26,745 $23,095 $23,267 $19,160 $15,813 $12,949 $10,512 $8,929 $7,898 $9,371 $10,805 $13,824
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 $28,800 $26,745 $23,095 $23,267 $19,160 $15,813 $12,949 $10,512 $8,929 $7,898 $9,371 $10,805 $13,824
Inventory $0 $0 $0 $2,580 $2,890 $3,142 $3,497 $3,823 $4,258 $4,663 $5,775 $6,400 $7,049
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $28,800 $26,745 $23,095 $25,847 $22,050 $18,955 $16,446 $14,335 $13,187 $12,561 $15,145 $17,205 $20,873
Long-term Assets
Long-term Assets $15,700 $15,700 $15,700 $15,700 $15,700 $15,700 $15,700 $15,700 $15,700 $15,700 $15,700 $15,700 $15,700
Accumulated Depreciation $0 $256 $512 $768 $1,024 $1,280 $1,536 $1,792 $2,048 $2,304 $2,560 $2,816 $3,072
Total Long-term Assets $15,700 $15,444 $15,188 $14,932 $14,676 $14,420 $14,164 $13,908 $13,652 $13,396 $13,140 $12,884 $12,628
Total Assets $44,500 $42,189 $38,283 $40,779 $36,726 $33,375 $30,610 $28,243 $26,839 $25,957 $28,285 $30,089 $33,501
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 $1,595 $1,595 $6,747 $4,826 $5,252 $5,664 $5,923 $6,410 $6,737 $8,397 $8,476 $9,069
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 $1,595 $1,595 $6,747 $4,826 $5,252 $5,664 $5,923 $6,410 $6,737 $8,397 $8,476 $9,069
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,595 $1,595 $6,747 $4,826 $5,252 $5,664 $5,923 $6,410 $6,737 $8,397 $8,476 $9,069
Paid-in Capital $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000
Retained Earnings ($500) ($500) ($500) ($500) ($500) ($500) ($500) ($500) ($500) ($500) ($500) ($500) ($500)
Earnings $0 ($3,906) ($7,812) ($10,468) ($12,600) ($16,377) ($19,554) ($22,180) ($24,071) ($25,280) ($24,611) ($22,887) ($20,068)
Total Capital $44,500 $40,594 $36,688 $34,032 $31,900 $28,123 $24,946 $22,320 $20,429 $19,220 $19,889 $21,613 $24,432
Total Liabilities and Capital $44,500 $42,189 $38,283 $40,779 $36,726 $33,375 $30,610 $28,243 $26,839 $25,957 $28,285 $30,089 $33,501
Net Worth $44,500 $40,594 $36,688 $34,032 $31,900 $28,123 $24,946 $22,320 $20,429 $19,220 $19,889 $21,613 $24,432