Edgar Risk Ventures, Ltd.

Start your own business plan »

Theatrical Music Producers 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
Regional Releases 0% $0 $0 $22,545 $0 $22,545 $0 $0 $0 $0 $45,090 $0 $0
Community Dances 0% $5,450 $16,350 $5,450 $5,450 $5,450 $5,450 $10,900 $10,900 $10,900 $16,350 $0 $16,350
Miscellaneous Projects 0% $5,478 $5,478 $5,478 $5,478 $5,478 $5,478 $5,478 $5,478 $5,478 $5,478 $5,478 $5,478
Total Sales $10,928 $21,828 $33,473 $10,928 $33,473 $10,928 $16,378 $16,378 $16,378 $66,918 $5,478 $21,828
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
Regional Releases $0 $0 $8,775 $0 $8,775 $0 $0 $0 $0 $14,624 $0 $0
Community Dances $2,820 $8,460 $2,820 $2,820 $2,820 $2,820 $5,640 $5,640 $5,640 $8,460 $0 $8,460
Miscellaneous Projects $1,978 $1,978 $1,978 $1,978 $1,978 $1,978 $1,978 $1,978 $1,978 $1,978 $1,978 $1,978
Subtotal Direct Cost of Sales $4,798 $10,438 $13,573 $4,798 $13,573 $4,798 $7,618 $7,618 $7,618 $25,061 $1,978 $10,438
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
President 0% $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917
Vice president- Admin 0% $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917
Controller 0% $0 $0 $0 $0 $0 $0 $0 $0 $1,750 $1,750 $1,750 $1,750
Ambassador of Goodwill 0% $0 $0 $0 $0 $0 $0 $0 $0 $1,750 $1,750 $1,750 $1,750
Total People 4 4 4 4 4 4 4 4 4 4 4 4
Total Payroll $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $9,333 $9,333 $9,333 $9,333
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% 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 $10,928 $21,828 $33,473 $10,928 $33,473 $10,928 $16,378 $16,378 $16,378 $66,918 $5,478 $21,828
Direct Cost of Sales $4,798 $10,438 $13,573 $4,798 $13,573 $4,798 $7,618 $7,618 $7,618 $25,061 $1,978 $10,438
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $4,798 $10,438 $13,573 $4,798 $13,573 $4,798 $7,618 $7,618 $7,618 $25,061 $1,978 $10,438
Gross Margin $6,130 $11,390 $19,900 $6,130 $19,900 $6,130 $8,760 $8,760 $8,760 $41,857 $3,500 $11,390
Gross Margin % 56.10% 52.18% 59.45% 56.10% 59.45% 56.10% 53.49% 53.49% 53.49% 62.55% 63.90% 52.18%
Expenses
Payroll $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $9,333 $9,333 $9,333 $9,333
Sales and Marketing and Other Expenses $2,562 $2,562 $2,562 $2,562 $2,562 $2,562 $2,562 $2,562 $2,562 $2,562 $2,562 $2,562
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
Publications/memberships $135 $135 $135 $135 $135 $135 $135 $135 $135 $135 $135 $135
Insurance $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Rent $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Payroll Taxes 15% $875 $875 $875 $875 $875 $875 $875 $875 $1,400 $1,400 $1,400 $1,400
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $10,456 $10,456 $10,456 $10,456 $10,456 $10,456 $10,456 $10,456 $14,481 $14,481 $14,481 $14,481
Profit Before Interest and Taxes ($4,326) $934 $9,444 ($4,326) $9,444 ($4,326) ($1,696) ($1,696) ($5,721) $27,376 ($10,981) ($3,091)
EBITDA ($4,326) $934 $9,444 ($4,326) $9,444 ($4,326) ($1,696) ($1,696) ($5,721) $27,376 ($10,981) ($3,091)
Interest Expense $116 $115 $115 $114 $113 $113 $112 $111 $110 $110 $109 $75
Taxes Incurred ($1,333) $246 $2,799 ($1,332) $2,799 ($1,331) ($542) ($542) ($1,749) $8,180 ($3,327) ($950)
Net Profit ($3,109) $573 $6,531 ($3,108) $6,532 ($3,107) ($1,265) ($1,265) ($4,082) $19,086 ($7,763) ($2,216)
Net Profit/Sales -28.45% 2.63% 19.51% -28.44% 19.51% -28.43% -7.73% -7.72% -24.92% 28.52% -141.72% -10.15%
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 $9,835 $19,645 $30,125 $9,835 $30,125 $9,835 $14,740 $14,740 $14,740 $60,226 $4,930 $19,645
Cash from Receivables $0 $36 $1,129 $2,222 $3,272 $1,168 $3,272 $1,111 $1,638 $1,638 $1,806 $6,487
Subtotal Cash from Operations $9,835 $19,681 $31,254 $12,056 $33,397 $11,003 $18,012 $15,851 $16,378 $61,864 $6,736 $26,132
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 $9,835 $19,681 $31,254 $12,056 $33,397 $11,003 $18,012 $15,851 $16,378 $61,864 $6,736 $26,132
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 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $9,333 $9,333 $9,333 $9,333
Bill Payments $1,273 $8,444 $15,611 $20,678 $8,632 $20,677 $8,321 $11,809 $11,786 $12,038 $37,345 $4,267
Subtotal Spent on Operations $7,107 $14,277 $21,444 $26,512 $14,465 $26,511 $14,155 $17,643 $21,120 $21,372 $46,678 $13,601
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 $4,000
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $83 $83 $83 $83 $83 $83 $83 $83 $83 $83 $83 $83
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $20,000 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $7,190 $14,361 $21,527 $26,595 $34,549 $26,594 $14,238 $17,726 $21,203 $21,455 $46,762 $17,684
Net Cash Flow $2,645 $5,321 $9,727 ($14,539) ($1,151) ($15,591) $3,774 ($1,875) ($4,825) $40,408 ($40,026) $8,448
Cash Balance $40,645 $45,965 $55,692 $41,154 $40,002 $24,411 $28,185 $26,309 $21,484 $61,892 $21,867 $30,315
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 $38,000 $40,645 $45,965 $55,692 $41,154 $40,002 $24,411 $28,185 $26,309 $21,484 $61,892 $21,867 $30,315
Accounts Receivable $0 $1,093 $3,239 $5,457 $4,328 $4,404 $4,328 $2,694 $3,221 $3,221 $8,275 $7,016 $2,712
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $38,000 $41,737 $49,204 $61,150 $45,482 $44,406 $28,739 $30,879 $29,530 $24,705 $70,167 $28,883 $33,027
Long-term Assets
Long-term Assets $4,500 $4,500 $4,500 $4,500 $4,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $4,500 $4,500 $4,500 $4,500 $4,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500 $24,500
Total Assets $42,500 $46,237 $53,704 $65,650 $49,982 $68,906 $53,239 $55,379 $54,030 $49,205 $94,667 $53,383 $57,527
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 $1,000 $7,930 $14,907 $20,405 $7,929 $20,404 $7,928 $11,416 $11,415 $10,755 $37,215 $3,777 $14,220
Current Borrowing $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $0
Other Current Liabilities $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Subtotal Current Liabilities $7,000 $13,930 $20,907 $26,405 $13,929 $26,404 $13,928 $17,416 $17,415 $16,755 $43,215 $9,777 $16,220
Long-term Liabilities $10,000 $9,917 $9,833 $9,750 $9,667 $9,583 $9,500 $9,417 $9,333 $9,250 $9,167 $9,083 $9,000
Total Liabilities $17,000 $23,847 $30,740 $36,155 $23,595 $35,987 $23,428 $26,833 $26,749 $26,005 $52,381 $18,860 $25,220
Paid-in Capital $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000
Retained Earnings ($18,500) ($18,500) ($18,500) ($18,500) ($18,500) ($18,500) ($18,500) ($18,500) ($18,500) ($18,500) ($18,500) ($18,500) ($18,500)
Earnings $0 ($3,109) ($2,536) $3,995 $887 $7,419 $4,312 $3,046 $1,782 ($2,300) $16,786 $9,023 $6,807
Total Capital $25,500 $22,391 $22,964 $29,495 $26,387 $32,919 $29,812 $28,546 $27,282 $23,200 $42,286 $34,523 $32,307
Total Liabilities and Capital $42,500 $46,237 $53,704 $65,650 $49,982 $68,906 $53,239 $55,379 $54,030 $49,205 $94,667 $53,383 $57,527
Net Worth $25,500 $22,391 $22,964 $29,495 $26,387 $32,919 $29,812 $28,546 $27,282 $23,200 $42,286 $34,523 $32,307