The Shipping Centre

Start your own business plan »

Direct Mail and Shipping 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
Shipping Customers 0% $0 $9,856 $10,255 $11,254 $13,565 $14,875 $15,989 $18,987 $20,145 $23,658 $26,987 $29,854
P.O. Box Customers 0% $0 $1,200 $1,500 $1,800 $2,014 $2,214 $2,455 $2,656 $2,658 $2,698 $2,612 $2,625
Fax Customers 0% $0 $800 $1,101 $1,300 $1,454 $1,547 $1,989 $2,212 $2,312 $2,356 $2,401 $2,525
Total Sales $0 $11,856 $12,856 $14,354 $17,033 $18,636 $20,433 $23,855 $25,115 $28,712 $32,000 $35,004
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
Shipping Customers $0 $4,435 $4,615 $5,064 $6,104 $6,694 $7,195 $8,544 $9,065 $10,646 $12,144 $13,434
P.O. Box Customers $0 $120 $150 $180 $201 $221 $246 $266 $266 $270 $261 $263
Fax Customers $0 $440 $606 $715 $800 $851 $1,094 $1,217 $1,272 $1,296 $1,321 $1,389
Subtotal Direct Cost of Sales $0 $4,995 $5,370 $5,959 $7,105 $7,766 $8,535 $10,026 $10,603 $12,212 $13,726 $15,086
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,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Employee 1 0% $0 $720 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440
Employee 2 0% $0 $0 $0 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440
Employee 3 0% $0 $0 $0 $0 $0 $0 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440
Total People 1 2 2 3 3 3 4 4 4 4 4 4
Total Payroll $2,500 $3,220 $3,940 $5,380 $5,380 $5,380 $6,820 $6,820 $6,820 $6,820 $6,820 $6,820
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 $11,856 $12,856 $14,354 $17,033 $18,636 $20,433 $23,855 $25,115 $28,712 $32,000 $35,004
Direct Cost of Sales $0 $4,995 $5,370 $5,959 $7,105 $7,766 $8,535 $10,026 $10,603 $12,212 $13,726 $15,086
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $4,995 $5,370 $5,959 $7,105 $7,766 $8,535 $10,026 $10,603 $12,212 $13,726 $15,086
Gross Margin $0 $6,861 $7,486 $8,395 $9,928 $10,870 $11,899 $13,829 $14,512 $16,500 $18,274 $19,918
Gross Margin % 0.00% 57.87% 58.23% 58.48% 58.28% 58.33% 58.23% 57.97% 57.78% 57.47% 57.11% 56.90%
Expenses
Payroll $2,500 $3,220 $3,940 $5,380 $5,380 $5,380 $6,820 $6,820 $6,820 $6,820 $6,820 $6,820
Sales and Marketing and Other Expenses $325 $325 $325 $325 $325 $325 $325 $325 $325 $325 $325 $325
Depreciation $350 $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
Utilities $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
DSL $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $45
Rent $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Payroll Taxes 15% $375 $483 $591 $807 $807 $807 $1,023 $1,023 $1,023 $1,023 $1,023 $1,023
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $6,220 $6,698 $7,526 $9,182 $9,182 $9,182 $10,838 $10,838 $10,838 $10,838 $10,838 $10,838
Profit Before Interest and Taxes ($6,220) $163 ($40) ($787) $746 $1,688 $1,061 $2,991 $3,674 $5,662 $7,436 $9,080
EBITDA ($5,870) $163 ($40) ($787) $746 $1,688 $1,061 $2,991 $3,674 $5,662 $7,436 $9,080
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($1,866) $41 ($10) ($197) $186 $422 $265 $748 $919 $1,416 $1,859 $2,270
Net Profit ($4,354) $122 ($30) ($590) $559 $1,266 $795 $2,243 $2,756 $4,247 $5,577 $6,810
Net Profit/Sales 0.00% 1.03% -0.24% -4.11% 3.28% 6.79% 3.89% 9.40% 10.97% 14.79% 17.43% 19.46%
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 $11,856 $12,856 $14,354 $17,033 $18,636 $20,433 $23,855 $25,115 $28,712 $32,000 $35,004
Subtotal Cash from Operations $0 $11,856 $12,856 $14,354 $17,033 $18,636 $20,433 $23,855 $25,115 $28,712 $32,000 $35,004
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 $11,856 $12,856 $14,354 $17,033 $18,636 $20,433 $23,855 $25,115 $28,712 $32,000 $35,004
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,500 $3,220 $3,940 $5,380 $5,380 $5,380 $6,820 $6,820 $6,820 $6,820 $6,820 $6,820
Bill Payments $50 $1,738 $8,528 $8,967 $9,615 $11,124 $12,018 $12,883 $14,817 $15,609 $17,711 $19,662
Subtotal Spent on Operations $2,550 $4,958 $12,468 $14,347 $14,995 $16,504 $18,838 $19,703 $21,637 $22,429 $24,531 $26,482
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,550 $4,958 $12,468 $14,347 $14,995 $16,504 $18,838 $19,703 $21,637 $22,429 $24,531 $26,482
Net Cash Flow ($2,550) $6,898 $388 $7 $2,038 $2,132 $1,595 $4,152 $3,478 $6,283 $7,469 $8,522
Cash Balance $11,450 $18,348 $18,736 $18,743 $20,781 $22,913 $24,508 $28,660 $32,138 $38,421 $45,890 $54,412
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 $14,000 $11,450 $18,348 $18,736 $18,743 $20,781 $22,913 $24,508 $28,660 $32,138 $38,421 $45,890 $54,412
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $14,000 $11,450 $18,348 $18,736 $18,743 $20,781 $22,913 $24,508 $28,660 $32,138 $38,421 $45,890 $54,412
Long-term Assets
Long-term Assets $14,200 $14,200 $14,200 $14,200 $14,200 $14,200 $14,200 $14,200 $14,200 $14,200 $14,200 $14,200 $14,200
Accumulated Depreciation $0 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350
Total Long-term Assets $14,200 $13,850 $13,850 $13,850 $13,850 $13,850 $13,850 $13,850 $13,850 $13,850 $13,850 $13,850 $13,850
Total Assets $28,200 $25,300 $32,198 $32,586 $32,593 $34,631 $36,763 $38,358 $42,510 $45,988 $52,271 $59,740 $68,262
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,454 $8,230 $8,648 $9,246 $10,724 $11,590 $12,390 $14,299 $15,021 $17,057 $18,949 $20,661
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,454 $8,230 $8,648 $9,246 $10,724 $11,590 $12,390 $14,299 $15,021 $17,057 $18,949 $20,661
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,454 $8,230 $8,648 $9,246 $10,724 $11,590 $12,390 $14,299 $15,021 $17,057 $18,949 $20,661
Paid-in Capital $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000
Retained Earnings ($1,800) ($1,800) ($1,800) ($1,800) ($1,800) ($1,800) ($1,800) ($1,800) ($1,800) ($1,800) ($1,800) ($1,800) ($1,800)
Earnings $0 ($4,354) ($4,232) ($4,262) ($4,853) ($4,293) ($3,027) ($2,232) $11 $2,767 $7,013 $12,591 $19,401
Total Capital $28,200 $23,846 $23,968 $23,938 $23,347 $23,907 $25,173 $25,968 $28,211 $30,967 $35,213 $40,791 $47,601
Total Liabilities and Capital $28,200 $25,300 $32,198 $32,586 $32,593 $34,631 $36,763 $38,358 $42,510 $45,988 $52,271 $59,740 $68,262
Net Worth $28,200 $23,846 $23,968 $23,938 $23,347 $23,907 $25,173 $25,968 $28,211 $30,967 $35,213 $40,791 $47,601