FireRescue Depot

Start your own business plan »

Fire Rescue E-commerce 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
Urban departments 0% $0 $0 $2,000 $2,500 $3,656 $6,987 $7,987 $9,695 $11,254 $13,655 $16,545 $17,474
Rural departments 0% $0 $0 $1,080 $1,350 $1,974 $3,773 $4,313 $5,235 $6,077 $7,374 $8,934 $9,436
Total Sales $0 $0 $3,080 $3,850 $5,630 $10,760 $12,300 $14,930 $17,331 $21,029 $25,479 $26,910
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
Urban departments $0 $0 $780 $975 $1,426 $2,725 $3,115 $3,781 $4,389 $5,325 $6,453 $6,815
Rural departments $0 $0 $421 $527 $770 $1,471 $1,682 $2,042 $2,370 $2,876 $3,484 $3,680
Subtotal Direct Cost of Sales $0 $0 $1,201 $1,502 $2,196 $4,196 $4,797 $5,823 $6,759 $8,201 $9,937 $10,495
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% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Sales/Procurement 0% $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Customer service 0% $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Customer service 0% $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Customer service 0% $0 $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Administrative 0% $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Accounting 0% $0 $0 $0 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Total People 1 1 4 5 6 6 7 7 7 7 7 7
Total Payroll $2,000 $2,000 $7,500 $8,700 $10,700 $10,700 $12,700 $12,700 $12,700 $12,700 $12,700 $12,700
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 $3,080 $3,850 $5,630 $10,760 $12,300 $14,930 $17,331 $21,029 $25,479 $26,910
Direct Cost of Sales $0 $0 $1,201 $1,502 $2,196 $4,196 $4,797 $5,823 $6,759 $8,201 $9,937 $10,495
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $1,201 $1,502 $2,196 $4,196 $4,797 $5,823 $6,759 $8,201 $9,937 $10,495
Gross Margin $0 $0 $1,879 $2,349 $3,434 $6,564 $7,503 $9,107 $10,572 $12,828 $15,542 $16,415
Gross Margin % 0.00% 0.00% 61.00% 61.00% 61.00% 61.00% 61.00% 61.00% 61.00% 61.00% 61.00% 61.00%
Expenses
Payroll $2,000 $2,000 $7,500 $8,700 $10,700 $10,700 $12,700 $12,700 $12,700 $12,700 $12,700 $12,700
Sales and Marketing and Other Expenses $300 $300 $300 $2,000 $300 $300 $300 $300 $300 $300 $300 $300
Depreciation $583 $583 $583 $583 $583 $583 $583 $583 $583 $583 $583 $583
Rent $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Utilities $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Insurance $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Payroll Taxes 15% $300 $300 $1,125 $1,305 $1,605 $1,605 $1,905 $1,905 $1,905 $1,905 $1,905 $1,905
Other $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Total Operating Expenses $4,808 $4,808 $11,133 $14,213 $14,813 $14,813 $17,113 $17,113 $17,113 $17,113 $17,113 $17,113
Profit Before Interest and Taxes ($4,808) ($4,808) ($9,254) ($11,865) ($11,379) ($8,249) ($9,610) ($8,006) ($6,541) ($4,285) ($1,571) ($698)
EBITDA ($4,225) ($4,225) ($8,671) ($11,282) ($10,796) ($7,666) ($9,027) ($7,423) ($5,958) ($3,702) ($988) ($115)
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 ($4,808) ($4,808) ($9,254) ($11,865) ($11,379) ($8,249) ($9,610) ($8,006) ($6,541) ($4,285) ($1,571) ($698)
Net Profit/Sales 0.00% 0.00% -300.46% -308.17% -202.10% -76.67% -78.13% -53.62% -37.74% -20.38% -6.16% -2.59%
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 $3,080 $3,850 $5,630 $10,760 $12,300 $14,930 $17,331 $21,029 $25,479 $26,910
Subtotal Cash from Operations $0 $0 $3,080 $3,850 $5,630 $10,760 $12,300 $14,930 $17,331 $21,029 $25,479 $26,910
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 $3,080 $3,850 $5,630 $10,760 $12,300 $14,930 $17,331 $21,029 $25,479 $26,910
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 $7,500 $8,700 $10,700 $10,700 $12,700 $12,700 $12,700 $12,700 $12,700 $12,700
Bill Payments $74 $2,225 $2,293 $4,324 $6,408 $5,792 $7,756 $8,661 $9,684 $10,637 $12,089 $13,786
Subtotal Spent on Operations $2,074 $4,225 $9,793 $13,024 $17,108 $16,492 $20,456 $21,361 $22,384 $23,337 $24,789 $26,486
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,074 $4,225 $9,793 $13,024 $17,108 $16,492 $20,456 $21,361 $22,384 $23,337 $24,789 $26,486
Net Cash Flow ($2,074) ($4,225) ($6,713) ($9,174) ($11,478) ($5,733) ($8,156) ($6,431) ($5,053) ($2,309) $690 $424
Cash Balance $69,926 $65,701 $58,988 $49,814 $38,337 $32,604 $24,448 $18,017 $12,964 $10,655 $11,346 $11,770
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 $72,000 $69,926 $65,701 $58,988 $49,814 $38,337 $32,604 $24,448 $18,017 $12,964 $10,655 $11,346 $11,770
Other Current Assets $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500
Total Current Assets $78,500 $76,426 $72,201 $65,488 $56,314 $44,837 $39,104 $30,948 $24,517 $19,464 $17,155 $17,846 $18,270
Long-term Assets
Long-term Assets $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000
Accumulated Depreciation $0 $583 $1,166 $1,749 $2,332 $2,915 $3,498 $4,081 $4,664 $5,247 $5,830 $6,413 $6,996
Total Long-term Assets $35,000 $34,417 $33,834 $33,251 $32,668 $32,085 $31,502 $30,919 $30,336 $29,753 $29,170 $28,587 $28,004
Total Assets $113,500 $110,843 $106,035 $98,739 $88,982 $76,922 $70,606 $61,867 $54,853 $49,217 $46,325 $46,433 $46,274
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 $2,151 $2,151 $4,109 $6,217 $5,535 $7,469 $8,339 $9,331 $10,236 $11,630 $13,308 $13,847
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 $2,151 $2,151 $4,109 $6,217 $5,535 $7,469 $8,339 $9,331 $10,236 $11,630 $13,308 $13,847
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $2,151 $2,151 $4,109 $6,217 $5,535 $7,469 $8,339 $9,331 $10,236 $11,630 $13,308 $13,847
Paid-in Capital $135,000 $135,000 $135,000 $135,000 $135,000 $135,000 $135,000 $135,000 $135,000 $135,000 $135,000 $135,000 $135,000
Retained Earnings ($21,500) ($21,500) ($21,500) ($21,500) ($21,500) ($21,500) ($21,500) ($21,500) ($21,500) ($21,500) ($21,500) ($21,500) ($21,500)
Earnings $0 ($4,808) ($9,616) ($18,870) ($30,735) ($42,113) ($50,363) ($59,973) ($67,978) ($74,519) ($78,805) ($80,375) ($81,073)
Total Capital $113,500 $108,692 $103,884 $94,630 $82,765 $71,387 $63,137 $53,527 $45,522 $38,981 $34,695 $33,125 $32,427
Total Liabilities and Capital $113,500 $110,843 $106,035 $98,739 $88,982 $76,922 $70,606 $61,867 $54,853 $49,217 $46,325 $46,433 $46,274
Net Worth $113,500 $108,692 $103,884 $94,630 $82,765 $71,387 $63,137 $53,527 $45,522 $38,981 $34,695 $33,125 $32,427