Green Office

Start your own business plan »

Office Supplies Retail 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
Corporations 0% $0 $0 $7,645 $8,212 $8,455 $8,747 $9,212 $9,454 $9,987 $10,112 $10,414 $10,654
Government Agencies 0% $0 $0 $8,774 $9,454 $9,746 $10,096 $10,654 $10,945 $11,584 $11,734 $12,097 $12,385
Other 0% $0 $0 $5,048 $5,354 $5,486 $5,643 $5,894 $6,025 $6,313 $6,380 $6,544 $6,673
Total Sales $0 $0 $21,467 $23,021 $23,687 $24,487 $25,761 $26,424 $27,884 $28,227 $29,054 $29,712
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
Corporations $0 $0 $3,669 $4,038 $4,196 $4,386 $4,688 $4,845 $5,192 $5,273 $5,469 $5,625
Government Agencies $0 $0 $4,403 $4,845 $5,035 $5,263 $5,625 $5,814 $6,230 $6,327 $6,563 $6,750
Other $0 $0 $1,981 $2,180 $2,266 $2,368 $2,531 $2,616 $2,803 $2,847 $2,953 $3,038
Subtotal Direct Cost of Sales $0 $0 $10,054 $11,064 $11,496 $12,016 $12,845 $13,276 $14,225 $14,447 $14,985 $15,413
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
Stan 0% $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Willma 0% $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Sales 0% $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Sales 0% $0 $0 $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Sales 0% $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Accounting 0% $0 $0 $0 $0 $800 $800 $800 $800 $800 $800 $800 $800
Shipping 0% $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Shipping 0% $0 $0 $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Shipping 0% $0 $0 $0 $0 $0 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Admin/customer support 0% $0 $0 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Admin/customer support 0% $0 $0 $0 $0 $0 $0 $800 $800 $800 $800 $800 $800
Total People 0 0 5 5 8 9 11 11 11 11 11 11
Total Payroll $0 $0 $8,000 $8,000 $11,800 $12,800 $15,100 $15,100 $15,100 $15,100 $15,100 $15,100
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 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00%
Long-term Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.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 $21,467 $23,021 $23,687 $24,487 $25,761 $26,424 $27,884 $28,227 $29,054 $29,712
Direct Cost of Sales $0 $0 $10,054 $11,064 $11,496 $12,016 $12,845 $13,276 $14,225 $14,447 $14,985 $15,413
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $10,054 $11,064 $11,496 $12,016 $12,845 $13,276 $14,225 $14,447 $14,985 $15,413
Gross Margin $0 $0 $11,414 $11,957 $12,190 $12,470 $12,916 $13,148 $13,660 $13,779 $14,069 $14,299
Gross Margin % 0.00% 0.00% 53.17% 51.94% 51.46% 50.93% 50.14% 49.76% 48.99% 48.82% 48.42% 48.13%
Expenses
Payroll $0 $0 $8,000 $8,000 $11,800 $12,800 $15,100 $15,100 $15,100 $15,100 $15,100 $15,100
Sales and Marketing and Other Expenses $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $725 $725 $725 $725 $725 $725 $725 $725 $725 $725 $725 $725
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 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Payroll Taxes 15% $0 $0 $1,200 $1,200 $1,770 $1,920 $2,265 $2,265 $2,265 $2,265 $2,265 $2,265
Website Maintenance $0 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Total Operating Expenses $2,625 $3,125 $12,325 $12,325 $16,695 $17,845 $20,490 $20,490 $20,490 $20,490 $20,490 $20,490
Profit Before Interest and Taxes ($2,625) ($3,125) ($911) ($368) ($4,505) ($5,375) ($7,574) ($7,342) ($6,830) ($6,711) ($6,421) ($6,191)
EBITDA ($1,900) ($2,400) ($186) $357 ($3,780) ($4,650) ($6,849) ($6,617) ($6,105) ($5,986) ($5,696) ($5,466)
Interest Expense $332 $330 $328 $326 $324 $322 $320 $318 $316 $315 $313 $311
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($2,957) ($3,455) ($1,239) ($694) ($4,829) ($5,697) ($7,894) ($7,660) ($7,147) ($7,025) ($6,734) ($6,501)
Net Profit/Sales 0.00% 0.00% -5.77% -3.01% -20.39% -23.26% -30.64% -28.99% -25.63% -24.89% -23.18% -21.88%
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 $5,367 $5,755 $5,922 $6,122 $6,440 $6,606 $6,971 $7,057 $7,264 $7,428
Cash from Receivables $0 $0 $0 $537 $16,139 $17,282 $17,785 $18,397 $19,337 $19,854 $20,922 $21,191
Subtotal Cash from Operations $0 $0 $5,367 $6,292 $22,061 $23,404 $24,225 $25,003 $26,308 $26,911 $28,185 $28,619
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 $5,367 $6,292 $22,061 $23,404 $24,225 $25,003 $26,308 $26,911 $28,185 $28,619
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 $0 $8,000 $8,000 $11,800 $12,800 $15,100 $15,100 $15,100 $15,100 $15,100 $15,100
Bill Payments $74 $2,248 $2,770 $3,928 $3,945 $4,854 $15,401 $18,659 $18,739 $20,139 $19,678 $20,511
Subtotal Spent on Operations $74 $2,248 $10,770 $11,928 $15,745 $17,654 $30,501 $33,759 $33,839 $35,239 $34,778 $35,611
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 $273 $275 $277 $279 $281 $283 $284 $286 $288 $290 $292 $294
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 $348 $2,523 $11,047 $12,207 $16,026 $17,936 $30,785 $34,045 $34,127 $35,529 $35,070 $35,905
Net Cash Flow ($348) ($2,523) ($5,680) ($5,915) $6,035 $5,468 ($6,560) ($9,043) ($7,819) ($8,618) ($6,885) ($7,286)
Cash Balance $128,352 $125,829 $120,149 $114,235 $120,270 $125,738 $119,177 $110,135 $102,316 $93,698 $86,814 $79,527
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 $128,700 $128,352 $125,829 $120,149 $114,235 $120,270 $125,738 $119,177 $110,135 $102,316 $93,698 $86,814 $79,527
Other Current Assets $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Total Current Assets $178,200 $177,852 $175,329 $175,696 $175,447 $171,612 $176,792 $172,596 $165,405 $160,112 $153,032 $147,554 $141,788
Long-term Assets
Long-term Assets $43,500 $43,500 $43,500 $43,500 $43,500 $43,500 $43,500 $43,500 $43,500 $43,500 $43,500 $43,500 $43,500
Accumulated Depreciation $0 $725 $1,450 $2,175 $2,900 $3,625 $4,350 $5,075 $5,800 $6,525 $7,250 $7,975 $8,700
Total Long-term Assets $43,500 $42,775 $42,050 $41,325 $40,600 $39,875 $39,150 $38,425 $37,700 $36,975 $36,250 $35,525 $34,800
Total Assets $221,700 $220,627 $217,379 $217,021 $216,047 $211,487 $215,942 $211,021 $203,105 $197,087 $189,282 $183,079 $176,588
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,157 $2,639 $3,797 $3,795 $4,344 $14,779 $18,036 $18,067 $19,484 $18,995 $19,817 $20,122
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,157 $2,639 $3,797 $3,795 $4,344 $14,779 $18,036 $18,067 $19,484 $18,995 $19,817 $20,122
Long-term Liabilities $50,000 $49,727 $49,452 $49,175 $48,896 $48,615 $48,333 $48,048 $47,762 $47,474 $47,183 $46,891 $46,597
Total Liabilities $50,000 $51,884 $52,090 $52,972 $52,691 $52,959 $63,112 $66,084 $65,829 $66,957 $66,178 $66,709 $66,719
Paid-in Capital $213,000 $213,000 $213,000 $213,000 $213,000 $213,000 $213,000 $213,000 $213,000 $213,000 $213,000 $213,000 $213,000
Retained Earnings ($41,300) ($41,300) ($41,300) ($41,300) ($41,300) ($41,300) ($41,300) ($41,300) ($41,300) ($41,300) ($41,300) ($41,300) ($41,300)
Earnings $0 ($2,957) ($6,411) ($7,650) ($8,344) ($13,173) ($18,870) ($26,764) ($34,424) ($41,571) ($48,596) ($55,329) ($61,831)
Total Capital $171,700 $168,743 $165,289 $164,050 $163,356 $158,527 $152,830 $144,936 $137,276 $130,129 $123,104 $116,371 $109,869
Total Liabilities and Capital $221,700 $220,627 $217,379 $217,021 $216,047 $211,487 $215,942 $211,021 $203,105 $197,087 $189,282 $183,079 $176,588
Net Worth $171,700 $168,743 $165,289 $164,050 $163,356 $158,527 $152,830 $144,936 $137,276 $130,129 $123,104 $116,371 $109,869