AuctionShipper

Start your own business plan »

Packaging 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
New Users 0% $0 $1,208 $1,964 $2,305 $2,941 $3,512 $3,593 $3,756 $3,865 $4,113 $4,328 $4,910
Advanced 0% $0 $2,323 $3,776 $4,432 $5,656 $6,754 $6,909 $7,223 $7,432 $7,909 $8,323 $9,443
Others 0% $0 $465 $755 $886 $1,131 $1,351 $1,382 $1,445 $1,486 $1,582 $1,665 $1,889
Total Sales $0 $3,996 $6,495 $7,623 $9,728 $11,617 $11,883 $12,424 $12,783 $13,603 $14,316 $16,242
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
New Users $0 $604 $982 $1,152 $1,471 $1,756 $1,796 $1,878 $1,932 $2,056 $2,164 $2,455
Advanced $0 $1,998 $3,247 $3,812 $4,864 $5,808 $5,942 $6,212 $6,392 $6,802 $7,158 $8,121
Others $0 $232 $378 $443 $566 $675 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $2,834 $4,607 $5,407 $6,901 $8,239 $7,738 $8,090 $8,324 $8,858 $9,322 $10,576
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
John 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
Part time employees 0% $0 $0 $0 $1,500 $1,500 $1,500 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total People 1 1 1 2 2 2 3 3 3 3 3 3
Total Payroll $2,500 $2,500 $2,500 $4,000 $4,000 $4,000 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
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 $3,996 $6,495 $7,623 $9,728 $11,617 $11,883 $12,424 $12,783 $13,603 $14,316 $16,242
Direct Cost of Sales $0 $2,834 $4,607 $5,407 $6,901 $8,239 $7,738 $8,090 $8,324 $8,858 $9,322 $10,576
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $2,834 $4,607 $5,407 $6,901 $8,239 $7,738 $8,090 $8,324 $8,858 $9,322 $10,576
Gross Margin $0 $1,162 $1,888 $2,216 $2,828 $3,377 $4,145 $4,334 $4,459 $4,745 $4,994 $5,666
Gross Margin % 0.00% 29.08% 29.06% 29.07% 29.07% 29.07% 34.88% 34.88% 34.88% 34.88% 34.88% 34.88%
Expenses
Payroll $2,500 $2,500 $2,500 $4,000 $4,000 $4,000 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Sales and Marketing and Other Expenses $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $67 $67 $67 $67 $67 $67 $67 $67 $67 $67 $67 $67
Rent $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
Utilities $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Insurance $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Payroll Taxes 15% $375 $375 $375 $600 $600 $600 $675 $675 $675 $675 $675 $675
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $4,142 $4,142 $4,142 $5,867 $5,867 $5,867 $6,442 $6,442 $6,442 $6,442 $6,442 $6,442
Profit Before Interest and Taxes ($4,142) ($2,980) ($2,254) ($3,650) ($3,039) ($2,489) ($2,296) ($2,108) ($1,982) ($1,696) ($1,448) ($776)
EBITDA ($4,075) ($2,913) ($2,187) ($3,584) ($2,972) ($2,423) ($2,230) ($2,041) ($1,916) ($1,630) ($1,381) ($709)
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,142) ($2,980) ($2,254) ($3,650) ($3,039) ($2,489) ($2,296) ($2,108) ($1,982) ($1,696) ($1,448) ($776)
Net Profit/Sales 0.00% -74.58% -34.71% -47.89% -31.24% -21.43% -19.32% -16.97% -15.51% -12.47% -10.11% -4.78%
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 $3,996 $6,495 $7,623 $9,728 $11,617 $11,883 $12,424 $12,783 $13,603 $14,316 $16,242
Subtotal Cash from Operations $0 $3,996 $6,495 $7,623 $9,728 $11,617 $11,883 $12,424 $12,783 $13,603 $14,316 $16,242
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 $3,996 $6,495 $7,623 $9,728 $11,617 $11,883 $12,424 $12,783 $13,603 $14,316 $16,242
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 $2,500 $2,500 $4,000 $4,000 $4,000 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Bill Payments $53 $1,669 $4,468 $6,216 $7,257 $8,745 $10,025 $9,625 $9,973 $10,217 $10,749 $11,239
Subtotal Spent on Operations $2,553 $4,169 $6,968 $10,216 $11,257 $12,745 $14,525 $14,125 $14,473 $14,717 $15,249 $15,739
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,553 $4,169 $6,968 $10,216 $11,257 $12,745 $14,525 $14,125 $14,473 $14,717 $15,249 $15,739
Net Cash Flow ($2,553) ($174) ($473) ($2,593) ($1,528) ($1,128) ($2,642) ($1,701) ($1,690) ($1,113) ($933) $503
Cash Balance $57,173 $56,999 $56,525 $53,932 $52,404 $51,275 $48,634 $46,932 $45,243 $44,130 $43,197 $43,700
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 $59,725 $57,173 $56,999 $56,525 $53,932 $52,404 $51,275 $48,634 $46,932 $45,243 $44,130 $43,197 $43,700
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $59,725 $57,173 $56,999 $56,525 $53,932 $52,404 $51,275 $48,634 $46,932 $45,243 $44,130 $43,197 $43,700
Long-term Assets
Long-term Assets $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Accumulated Depreciation $0 $67 $133 $200 $266 $333 $400 $466 $533 $599 $666 $733 $799
Total Long-term Assets $4,000 $3,933 $3,867 $3,800 $3,734 $3,667 $3,600 $3,534 $3,467 $3,401 $3,334 $3,267 $3,201
Total Assets $63,725 $61,106 $60,865 $60,326 $57,666 $56,071 $54,876 $52,167 $50,400 $48,643 $47,464 $46,464 $46,901
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,523 $4,262 $5,976 $6,967 $8,411 $9,705 $9,293 $9,633 $9,859 $10,375 $10,824 $12,036
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,523 $4,262 $5,976 $6,967 $8,411 $9,705 $9,293 $9,633 $9,859 $10,375 $10,824 $12,036
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,523 $4,262 $5,976 $6,967 $8,411 $9,705 $9,293 $9,633 $9,859 $10,375 $10,824 $12,036
Paid-in Capital $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000
Retained Earnings ($6,275) ($6,275) ($6,275) ($6,275) ($6,275) ($6,275) ($6,275) ($6,275) ($6,275) ($6,275) ($6,275) ($6,275) ($6,275)
Earnings $0 ($4,142) ($7,121) ($9,375) ($13,026) ($16,065) ($18,554) ($20,850) ($22,958) ($24,940) ($26,637) ($28,084) ($28,860)
Total Capital $63,725 $59,583 $56,604 $54,350 $50,699 $47,660 $45,171 $42,875 $40,767 $38,785 $37,088 $35,641 $34,865
Total Liabilities and Capital $63,725 $61,106 $60,865 $60,326 $57,666 $56,071 $54,876 $52,167 $50,400 $48,643 $47,464 $46,464 $46,901
Net Worth $63,725 $59,583 $56,604 $54,350 $50,699 $47,660 $45,171 $42,875 $40,767 $38,785 $37,088 $35,641 $34,865