HeavyMetal Praise Records
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 | |||||||||||||
Online | 0% | $0 | $0 | $0 | $0 | $0 | $3,000 | $4,000 | $6,000 | $10,000 | $13,000 | $18,000 | $30,000 |
In Store | 0% | $0 | $0 | $0 | $0 | $0 | $3,000 | $10,000 | $12,000 | $18,000 | $25,000 | $36,000 | $50,000 |
Total Sales | $0 | $0 | $0 | $0 | $0 | $6,000 | $14,000 | $18,000 | $28,000 | $38,000 | $54,000 | $80,000 | |
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 | |
Online | $0 | $0 | $0 | $0 | $0 | $150 | $200 | $300 | $500 | $650 | $900 | $1,500 | |
In Store | $0 | $0 | $0 | $0 | $0 | $150 | $500 | $600 | $900 | $1,250 | $1,800 | $2,500 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $300 | $700 | $900 | $1,400 | $1,900 | $2,700 | $4,000 |
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 | ||
Owner | 0% | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
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 | $0 | $0 | $0 | $0 | $0 | $6,000 | $14,000 | $18,000 | $28,000 | $38,000 | $54,000 | $80,000 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $300 | $700 | $900 | $1,400 | $1,900 | $2,700 | $4,000 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $300 | $700 | $900 | $1,400 | $1,900 | $2,700 | $4,000 | |
Gross Margin | $0 | $0 | $0 | $0 | $0 | $5,700 | $13,300 | $17,100 | $26,600 | $36,100 | $51,300 | $76,000 | |
Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | |
Expenses | |||||||||||||
Payroll | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Sales and Marketing and Other Expenses | $5,000 | $5,000 | $5,000 | $5,000 | $45,000 | $22,000 | $7,000 | $7,000 | $4,000 | $3,000 | $2,000 | $32,000 | |
Depreciation | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Insurance | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Rent | $0 | $0 | $0 | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Payroll Taxes | 15% | $0 | $300 | $300 | $300 | $300 | $300 | $300 | $450 | $450 | $450 | $450 | $450 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $5,750 | $8,050 | $8,050 | $8,050 | $49,550 | $26,550 | $11,550 | $12,700 | $9,700 | $8,700 | $7,700 | $37,700 | |
Profit Before Interest and Taxes | ($5,750) | ($8,050) | ($8,050) | ($8,050) | ($49,550) | ($20,850) | $1,750 | $4,400 | $16,900 | $27,400 | $43,600 | $38,300 | |
EBITDA | ($5,500) | ($7,800) | ($7,800) | ($7,800) | ($49,300) | ($20,600) | $2,000 | $4,650 | $17,150 | $27,650 | $43,850 | $38,550 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | ($1,725) | ($2,415) | ($2,415) | ($2,415) | ($14,865) | ($6,255) | $525 | $1,320 | $5,070 | $8,220 | $13,080 | $11,490 | |
Net Profit | ($4,025) | ($5,635) | ($5,635) | ($5,635) | ($34,685) | ($14,595) | $1,225 | $3,080 | $11,830 | $19,180 | $30,520 | $26,810 | |
Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | -243.25% | 8.75% | 17.11% | 42.25% | 50.47% | 56.52% | 33.51% |
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 | $0 | $0 | $0 | $4,200 | $9,800 | $12,600 | $19,600 | $26,600 | $37,800 | $56,000 | |
Cash from Receivables | $0 | $0 | $0 | $0 | $0 | $0 | $60 | $1,880 | $4,240 | $5,500 | $8,500 | $11,560 | |
Subtotal Cash from Operations | $0 | $0 | $0 | $0 | $0 | $4,200 | $9,860 | $14,480 | $23,840 | $32,100 | $46,300 | $67,560 | |
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 | $0 | $0 | $0 | $4,200 | $9,860 | $14,480 | $23,840 | $32,100 | $46,300 | $67,560 | |
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 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Bill Payments | $126 | $3,762 | $3,385 | $3,385 | $4,353 | $31,989 | $18,771 | $10,857 | $11,823 | $13,452 | $16,286 | $22,119 | |
Subtotal Spent on Operations | $126 | $5,762 | $5,385 | $5,385 | $6,353 | $33,989 | $20,771 | $13,857 | $14,823 | $16,452 | $19,286 | $25,119 | |
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 | $126 | $5,762 | $5,385 | $5,385 | $6,353 | $33,989 | $20,771 | $13,857 | $14,823 | $16,452 | $19,286 | $25,119 | |
Net Cash Flow | ($126) | ($5,762) | ($5,385) | ($5,385) | ($6,353) | ($29,789) | ($10,911) | $624 | $9,017 | $15,648 | $27,014 | $42,441 | |
Cash Balance | $83,774 | $78,012 | $72,627 | $67,242 | $60,889 | $31,100 | $20,189 | $20,813 | $29,830 | $45,478 | $72,491 | $114,933 |
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 | $83,900 | $83,774 | $78,012 | $72,627 | $67,242 | $60,889 | $31,100 | $20,189 | $20,813 | $29,830 | $45,478 | $72,491 | $114,933 |
Accounts Receivable | $0 | $0 | $0 | $0 | $0 | $0 | $1,800 | $5,940 | $9,460 | $13,620 | $19,520 | $27,220 | $39,660 |
Inventory | $0 | $0 | $0 | $0 | $0 | $0 | $700 | $1,000 | $1,100 | $1,540 | $2,090 | $2,970 | $4,400 |
Other Current 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 |
Total Current Assets | $98,900 | $98,774 | $93,012 | $87,627 | $82,242 | $75,889 | $48,600 | $42,129 | $46,373 | $59,990 | $82,088 | $117,681 | $173,993 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
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 | $0 | ($250) | ($500) | ($750) | ($1,000) | ($1,250) | ($1,500) | ($1,750) | ($2,000) | ($2,250) | ($2,500) | ($2,750) | ($3,000) |
Total Assets | $98,900 | $98,524 | $92,512 | $86,877 | $81,242 | $74,639 | $47,100 | $40,379 | $44,373 | $57,740 | $79,588 | $114,931 | $170,993 |
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 | $3,649 | $3,272 | $3,272 | $3,272 | $31,354 | $18,410 | $10,464 | $11,378 | $12,915 | $15,583 | $20,406 | $49,658 |
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 | $3,649 | $3,272 | $3,272 | $3,272 | $31,354 | $18,410 | $10,464 | $11,378 | $12,915 | $15,583 | $20,406 | $49,658 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $3,649 | $3,272 | $3,272 | $3,272 | $31,354 | $18,410 | $10,464 | $11,378 | $12,915 | $15,583 | $20,406 | $49,658 |
Paid-in Capital | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 |
Retained Earnings | ($1,100) | ($1,100) | ($1,100) | ($1,100) | ($1,100) | ($1,100) | ($1,100) | ($1,100) | ($1,100) | ($1,100) | ($1,100) | ($1,100) | ($1,100) |
Earnings | $0 | ($4,025) | ($9,660) | ($15,295) | ($20,930) | ($55,615) | ($70,210) | ($68,985) | ($65,905) | ($54,075) | ($34,895) | ($4,375) | $22,435 |
Total Capital | $98,900 | $94,875 | $89,240 | $83,605 | $77,970 | $43,285 | $28,690 | $29,915 | $32,995 | $44,825 | $64,005 | $94,525 | $121,335 |
Total Liabilities and Capital | $98,900 | $98,524 | $92,512 | $86,877 | $81,242 | $74,639 | $47,100 | $40,379 | $44,373 | $57,740 | $79,588 | $114,931 | $170,993 |
Net Worth | $98,900 | $94,875 | $89,240 | $83,605 | $77,970 | $43,285 | $28,690 | $29,915 | $32,995 | $44,825 | $64,005 | $94,525 | $121,335 |