Write Bike

Start your own business plan »

Magazine Journalist 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
Print 0% $500 $750 $850 $1,600 $2,000 $2,400 $2,600 $2,800 $3,100 $2,300 $1,900 $1,500
Web based 0% $335 $503 $570 $1,072 $1,340 $1,608 $1,742 $1,876 $2,077 $1,541 $1,273 $1,005
Total Sales $835 $1,253 $1,420 $2,672 $3,340 $4,008 $4,342 $4,676 $5,177 $3,841 $3,173 $2,505
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
Print $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Web based $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Steve 0% $1,500 $1,500 $2,000 $2,000 $3,000 $3,000 $3,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 1 1 1 1 1 1 1 1 1 1 1 1
Total Payroll $1,500 $1,500 $2,000 $2,000 $3,000 $3,000 $3,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 $835 $1,253 $1,420 $2,672 $3,340 $4,008 $4,342 $4,676 $5,177 $3,841 $3,173 $2,505
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Margin $835 $1,253 $1,420 $2,672 $3,340 $4,008 $4,342 $4,676 $5,177 $3,841 $3,173 $2,505
Gross Margin % 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Expenses
Payroll $1,500 $1,500 $2,000 $2,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Account Name $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $83 $83 $83 $83 $83 $83 $83 $83 $83 $83 $83 $83
Rent $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Utilities $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Insurance $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Travel, trade shows. other expenses $150 $800 $150 $150 $250 $150 $150 $150 $600 $150 $100 $100
Total Operating Expenses $2,158 $2,808 $2,658 $2,658 $3,758 $3,658 $3,658 $3,658 $4,108 $3,658 $3,608 $3,608
Profit Before Interest and Taxes ($1,323) ($1,556) ($1,239) $14 ($418) $350 $684 $1,018 $1,069 $183 ($435) ($1,103)
EBITDA ($1,240) ($1,473) ($1,156) $97 ($335) $433 $767 $1,101 $1,152 $266 ($352) ($1,020)
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 ($1,323) ($1,556) ($1,239) $14 ($418) $350 $684 $1,018 $1,069 $183 ($435) ($1,103)
Net Profit/Sales -158.44% -124.19% -87.25% 0.52% -12.51% 8.73% 15.75% 21.77% 20.65% 4.76% -13.71% -44.03%
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 $835 $1,253 $1,420 $2,672 $3,340 $4,008 $4,342 $4,676 $5,177 $3,841 $3,173 $2,505
Subtotal Cash from Operations $835 $1,253 $1,420 $2,672 $3,340 $4,008 $4,342 $4,676 $5,177 $3,841 $3,173 $2,505
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 $835 $1,253 $1,420 $2,672 $3,340 $4,008 $4,342 $4,676 $5,177 $3,841 $3,173 $2,505
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,500 $1,500 $2,000 $2,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Bill Payments $19 $597 $1,203 $575 $578 $672 $575 $575 $590 $1,010 $573 $525
Subtotal Spent on Operations $1,519 $2,097 $3,203 $2,575 $3,578 $3,672 $3,575 $3,575 $3,590 $4,010 $3,573 $3,525
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 $1,519 $2,097 $3,203 $2,575 $3,578 $3,672 $3,575 $3,575 $3,590 $4,010 $3,573 $3,525
Net Cash Flow ($684) ($844) ($1,784) $97 ($238) $336 $767 $1,101 $1,587 ($169) ($400) ($1,020)
Cash Balance $8,516 $7,672 $5,888 $5,985 $5,747 $6,083 $6,850 $7,951 $9,538 $9,369 $8,969 $7,949
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 $9,200 $8,516 $7,672 $5,888 $5,985 $5,747 $6,083 $6,850 $7,951 $9,538 $9,369 $8,969 $7,949
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $9,200 $8,516 $7,672 $5,888 $5,985 $5,747 $6,083 $6,850 $7,951 $9,538 $9,369 $8,969 $7,949
Long-term Assets
Long-term Assets $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Accumulated Depreciation $0 $83 $166 $249 $332 $415 $498 $581 $664 $747 $830 $913 $996
Total Long-term Assets $5,000 $4,917 $4,834 $4,751 $4,668 $4,585 $4,502 $4,419 $4,336 $4,253 $4,170 $4,087 $4,004
Total Assets $14,200 $13,433 $12,506 $10,639 $10,653 $10,332 $10,585 $11,269 $12,287 $13,791 $13,539 $13,056 $11,953
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 $556 $1,184 $556 $556 $653 $556 $556 $556 $991 $556 $508 $508
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 $556 $1,184 $556 $556 $653 $556 $556 $556 $991 $556 $508 $508
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $556 $1,184 $556 $556 $653 $556 $556 $556 $991 $556 $508 $508
Paid-in Capital $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
Retained Earnings ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800)
Earnings $0 ($1,323) ($2,879) ($4,117) ($4,103) ($4,521) ($4,171) ($3,487) ($2,469) ($1,400) ($1,217) ($1,652) ($2,755)
Total Capital $14,200 $12,877 $11,322 $10,083 $10,097 $9,679 $10,029 $10,713 $11,731 $12,800 $12,983 $12,548 $11,445
Total Liabilities and Capital $14,200 $13,433 $12,506 $10,639 $10,653 $10,332 $10,585 $11,269 $12,287 $13,791 $13,539 $13,056 $11,953
Net Worth $14,200 $12,877 $11,322 $10,083 $10,097 $9,679 $10,029 $10,713 $11,731 $12,800 $12,983 $12,548 $11,445