Green Power Consultancy
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 | |||||||||||||
Architects | 0% | $2,500 | $2,654 | $2,747 | $3,212 | $3,455 | $3,525 | $3,656 | $3,787 | $3,987 | $3,902 | $3,878 | $3,757 |
Individuals | 0% | $2,800 | $2,972 | $3,077 | $3,597 | $3,870 | $3,948 | $4,095 | $4,241 | $4,465 | $4,370 | $4,343 | $4,208 |
Total Sales | $5,300 | $5,626 | $5,824 | $6,809 | $7,325 | $7,473 | $7,751 | $8,028 | $8,452 | $8,272 | $8,221 | $7,965 | |
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 | |
Architects | $500 | $531 | $549 | $642 | $691 | $705 | $731 | $757 | $797 | $780 | $776 | $751 | |
Individuals | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $500 | $531 | $549 | $642 | $691 | $705 | $731 | $757 | $797 | $780 | $776 | $751 |
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 | ||
Dan | 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 |
Sue | 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 |
Associate consultant | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Administrative assistant | 0% | $0 | $0 | $0 | $400 | $400 | $400 | $500 | $500 | $600 | $600 | $600 | $600 |
Total People | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
Total Payroll | $4,000 | $4,000 | $4,000 | $4,400 | $4,400 | $4,400 | $4,500 | $4,500 | $4,600 | $4,600 | $4,600 | $4,600 |
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 | $5,300 | $5,626 | $5,824 | $6,809 | $7,325 | $7,473 | $7,751 | $8,028 | $8,452 | $8,272 | $8,221 | $7,965 | |
Direct Cost of Sales | $500 | $531 | $549 | $642 | $691 | $705 | $731 | $757 | $797 | $780 | $776 | $751 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $500 | $531 | $549 | $642 | $691 | $705 | $731 | $757 | $797 | $780 | $776 | $751 | |
Gross Margin | $4,800 | $5,096 | $5,274 | $6,167 | $6,634 | $6,768 | $7,020 | $7,271 | $7,655 | $7,492 | $7,446 | $7,213 | |
Gross Margin % | 90.57% | 90.57% | 90.57% | 90.57% | 90.57% | 90.57% | 90.57% | 90.57% | 90.57% | 90.57% | 90.57% | 90.57% | |
Expenses | |||||||||||||
Payroll | $4,000 | $4,000 | $4,000 | $4,400 | $4,400 | $4,400 | $4,500 | $4,500 | $4,600 | $4,600 | $4,600 | $4,600 | |
Sales and Marketing and Other Expenses | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Depreciation | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Rent | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Utilities | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Insurance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Payroll Taxes | 15% | $600 | $600 | $600 | $660 | $660 | $660 | $675 | $675 | $690 | $690 | $690 | $690 |
Other | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Total Operating Expenses | $6,200 | $6,200 | $6,200 | $6,660 | $6,660 | $6,660 | $6,775 | $6,775 | $6,890 | $6,890 | $6,890 | $6,890 | |
Profit Before Interest and Taxes | ($1,400) | ($1,104) | ($926) | ($493) | ($26) | $108 | $245 | $496 | $765 | $602 | $556 | $323 | |
EBITDA | ($1,250) | ($954) | ($776) | ($343) | $124 | $258 | $395 | $646 | $915 | $752 | $706 | $473 | |
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 | ($1,400) | ($1,104) | ($926) | ($493) | ($26) | $108 | $245 | $496 | $765 | $602 | $556 | $323 | |
Net Profit/Sales | -26.42% | -19.63% | -15.90% | -7.24% | -0.36% | 1.45% | 3.15% | 6.18% | 9.05% | 7.28% | 6.76% | 4.06% |
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 | $5,300 | $5,626 | $5,824 | $6,809 | $7,325 | $7,473 | $7,751 | $8,028 | $8,452 | $8,272 | $8,221 | $7,965 | |
Subtotal Cash from Operations | $5,300 | $5,626 | $5,824 | $6,809 | $7,325 | $7,473 | $7,751 | $8,028 | $8,452 | $8,272 | $8,221 | $7,965 | |
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 | $5,300 | $5,626 | $5,824 | $6,809 | $7,325 | $7,473 | $7,751 | $8,028 | $8,452 | $8,272 | $8,221 | $7,965 | |
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 | $4,000 | $4,000 | $4,000 | $4,400 | $4,400 | $4,400 | $4,500 | $4,500 | $4,600 | $4,600 | $4,600 | $4,600 | |
Bill Payments | $85 | $2,551 | $2,581 | $2,604 | $2,754 | $2,801 | $2,816 | $2,857 | $2,884 | $2,937 | $2,920 | $2,915 | |
Subtotal Spent on Operations | $4,085 | $6,551 | $6,581 | $7,005 | $7,154 | $7,201 | $7,316 | $7,357 | $7,484 | $7,537 | $7,520 | $7,515 | |
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 | $4,085 | $6,551 | $6,581 | $7,005 | $7,154 | $7,201 | $7,316 | $7,357 | $7,484 | $7,537 | $7,520 | $7,515 | |
Net Cash Flow | $1,215 | ($925) | ($758) | ($195) | $171 | $272 | $434 | $671 | $968 | $735 | $701 | $450 | |
Cash Balance | $25,065 | $24,140 | $23,383 | $23,188 | $23,358 | $23,630 | $24,064 | $24,735 | $25,704 | $26,439 | $27,140 | $27,590 |
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 | $23,850 | $25,065 | $24,140 | $23,383 | $23,188 | $23,358 | $23,630 | $24,064 | $24,735 | $25,704 | $26,439 | $27,140 | $27,590 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $23,850 | $25,065 | $24,140 | $23,383 | $23,188 | $23,358 | $23,630 | $24,064 | $24,735 | $25,704 | $26,439 | $27,140 | $27,590 |
Long-term Assets | |||||||||||||
Long-term Assets | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 |
Accumulated Depreciation | $0 | $150 | $300 | $450 | $600 | $750 | $900 | $1,050 | $1,200 | $1,350 | $1,500 | $1,650 | $1,800 |
Total Long-term Assets | $9,000 | $8,850 | $8,700 | $8,550 | $8,400 | $8,250 | $8,100 | $7,950 | $7,800 | $7,650 | $7,500 | $7,350 | $7,200 |
Total Assets | $32,850 | $33,915 | $32,840 | $31,933 | $31,588 | $31,608 | $31,730 | $32,014 | $32,535 | $33,354 | $33,939 | $34,490 | $34,790 |
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,465 | $2,495 | $2,513 | $2,661 | $2,708 | $2,721 | $2,761 | $2,786 | $2,839 | $2,823 | $2,818 | $2,795 |
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,465 | $2,495 | $2,513 | $2,661 | $2,708 | $2,721 | $2,761 | $2,786 | $2,839 | $2,823 | $2,818 | $2,795 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $2,465 | $2,495 | $2,513 | $2,661 | $2,708 | $2,721 | $2,761 | $2,786 | $2,839 | $2,823 | $2,818 | $2,795 |
Paid-in Capital | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 |
Retained Earnings | ($7,150) | ($7,150) | ($7,150) | ($7,150) | ($7,150) | ($7,150) | ($7,150) | ($7,150) | ($7,150) | ($7,150) | ($7,150) | ($7,150) | ($7,150) |
Earnings | $0 | ($1,400) | ($2,504) | ($3,430) | ($3,923) | ($3,949) | ($3,841) | ($3,597) | ($3,101) | ($2,336) | ($1,734) | ($1,178) | ($855) |
Total Capital | $32,850 | $31,450 | $30,346 | $29,420 | $28,927 | $28,901 | $29,009 | $29,253 | $29,749 | $30,514 | $31,116 | $31,672 | $31,995 |
Total Liabilities and Capital | $32,850 | $33,915 | $32,840 | $31,933 | $31,588 | $31,608 | $31,730 | $32,014 | $32,535 | $33,354 | $33,939 | $34,490 | $34,790 |
Net Worth | $32,850 | $31,450 | $30,346 | $29,420 | $28,927 | $28,901 | $29,009 | $29,253 | $29,749 | $30,514 | $31,116 | $31,672 | $31,995 |