Green Office
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 |