O'Connor & Partners
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 | |||||||||||||
Chemical manufacturing | 0% | $4,800 | $5,040 | $5,292 | $5,557 | $5,834 | $6,126 | $6,432 | $6,754 | $7,092 | $7,446 | $7,819 | $8,210 |
Biorefinery start-ups | 0% | $2,400 | $2,640 | $2,904 | $3,194 | $3,514 | $3,865 | $4,252 | $4,677 | $5,145 | $5,659 | $6,225 | $6,847 |
Agricultural | 0% | $1,200 | $1,260 | $1,323 | $1,389 | $1,459 | $1,532 | $1,608 | $1,689 | $1,773 | $1,862 | $1,955 | $2,052 |
Utilities | 0% | $2,400 | $2,520 | $2,646 | $2,778 | $2,917 | $3,063 | $3,216 | $3,377 | $3,546 | $3,723 | $3,909 | $4,105 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $10,800 | $11,460 | $12,165 | $12,918 | $13,724 | $14,586 | $15,509 | $16,497 | $17,555 | $18,690 | $19,908 | $21,214 | |
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 | |
Supplies | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Sales & Marketing | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Interest & Depreciation | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Overhead | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
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 | ||
Ryan O’Connor | 0% | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 |
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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
Long-term Interest Rate | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.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 | $10,800 | $11,460 | $12,165 | $12,918 | $13,724 | $14,586 | $15,509 | $16,497 | $17,555 | $18,690 | $19,908 | $21,214 | |
Direct Cost of Sales | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | |
Gross Margin | $4,800 | $5,460 | $6,165 | $6,918 | $7,724 | $8,586 | $9,509 | $10,497 | $11,555 | $12,690 | $13,908 | $15,214 | |
Gross Margin % | 44.44% | 47.64% | 50.68% | 53.55% | 56.28% | 58.86% | 61.31% | 63.63% | 65.82% | 67.90% | 69.86% | 71.72% | |
Expenses | |||||||||||||
Payroll | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | |
Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Payroll Taxes | 15% | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $9,200 | $9,200 | $9,200 | $9,200 | $9,200 | $9,200 | $9,200 | $9,200 | $9,200 | $9,200 | $9,200 | $9,200 | |
Profit Before Interest and Taxes | ($4,400) | ($3,740) | ($3,035) | ($2,282) | ($1,476) | ($614) | $309 | $1,297 | $2,355 | $3,490 | $4,708 | $6,014 | |
EBITDA | ($4,400) | ($3,740) | ($3,035) | ($2,282) | ($1,476) | ($614) | $309 | $1,297 | $2,355 | $3,490 | $4,708 | $6,014 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | ($1,320) | ($935) | ($759) | ($570) | ($369) | ($154) | $77 | $324 | $589 | $873 | $1,177 | $1,504 | |
Other Income | |||||||||||||
Interest Income | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Income Account Name | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Other Income | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Expense | |||||||||||||
Account Name | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Expense Account Name | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Other Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Other Income | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($3,080) | ($2,805) | ($2,276) | ($1,711) | ($1,107) | ($461) | $231 | $972 | $1,766 | $2,618 | $3,531 | $4,511 | |
Net Profit/Sales | -28.52% | -24.48% | -18.71% | -13.25% | -8.07% | -3.16% | 1.49% | 5.89% | 10.06% | 14.01% | 17.74% | 21.26% |
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 | $2,700 | $2,865 | $3,041 | $3,230 | $3,431 | $3,646 | $3,877 | $4,124 | $4,389 | $4,673 | $4,977 | $5,304 | |
Cash from Receivables | $0 | $270 | $8,117 | $8,613 | $9,143 | $9,709 | $10,315 | $10,963 | $11,656 | $12,399 | $13,195 | $14,048 | |
Subtotal Cash from Operations | $2,700 | $3,135 | $11,158 | $11,842 | $12,574 | $13,355 | $14,192 | $15,087 | $16,045 | $17,071 | $18,172 | $19,352 | |
Additional Cash Received | |||||||||||||
Non Operating (Other) Income | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
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 | $2,700 | $3,135 | $11,158 | $11,842 | $12,574 | $13,355 | $14,192 | $15,087 | $16,045 | $17,071 | $18,172 | $19,352 | |
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 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | |
Bill Payments | $196 | $5,893 | $6,271 | $6,448 | $6,636 | $6,838 | $7,054 | $7,285 | $7,533 | $7,798 | $8,083 | $8,388 | |
Subtotal Spent on Operations | $8,196 | $13,893 | $14,271 | $14,448 | $14,636 | $14,838 | $15,054 | $15,285 | $15,533 | $15,798 | $16,083 | $16,388 | |
Additional Cash Spent | |||||||||||||
Non Operating (Other) Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
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 | $8,196 | $13,893 | $14,271 | $14,448 | $14,636 | $14,838 | $15,054 | $15,285 | $15,533 | $15,798 | $16,083 | $16,388 | |
Net Cash Flow | ($5,496) | ($10,758) | ($3,113) | ($2,605) | ($2,063) | ($1,483) | ($862) | ($199) | $512 | $1,273 | $2,089 | $2,964 | |
Cash Balance | $34,504 | $23,746 | $20,633 | $18,028 | $15,965 | $14,482 | $13,620 | $13,421 | $13,933 | $15,206 | $17,295 | $20,259 |
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 | $40,000 | $34,504 | $23,746 | $20,633 | $18,028 | $15,965 | $14,482 | $13,620 | $13,421 | $13,933 | $15,206 | $17,295 | $20,259 |
Accounts Receivable | $0 | $8,100 | $16,425 | $17,432 | $18,508 | $19,659 | $20,889 | $22,206 | $23,616 | $25,126 | $26,745 | $28,481 | $30,344 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $40,000 | $42,604 | $40,171 | $38,065 | $36,536 | $35,624 | $35,372 | $35,826 | $37,037 | $39,060 | $41,952 | $45,777 | $50,603 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Assets | $40,000 | $42,604 | $40,171 | $38,065 | $36,536 | $35,624 | $35,372 | $35,826 | $37,037 | $39,060 | $41,952 | $45,777 | $50,603 |
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 | $5,684 | $6,056 | $6,227 | $6,409 | $6,603 | $6,812 | $7,035 | $7,273 | $7,529 | $7,803 | $8,098 | $8,413 |
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 | $5,684 | $6,056 | $6,227 | $6,409 | $6,603 | $6,812 | $7,035 | $7,273 | $7,529 | $7,803 | $8,098 | $8,413 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $5,684 | $6,056 | $6,227 | $6,409 | $6,603 | $6,812 | $7,035 | $7,273 | $7,529 | $7,803 | $8,098 | $8,413 |
Paid-in Capital | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 |
Retained Earnings | ($10,000) | ($10,000) | ($10,000) | ($10,000) | ($10,000) | ($10,000) | ($10,000) | ($10,000) | ($10,000) | ($10,000) | ($10,000) | ($10,000) | ($10,000) |
Earnings | $0 | ($3,080) | ($5,885) | ($8,161) | ($9,872) | ($10,979) | ($11,440) | ($11,208) | ($10,236) | ($8,470) | ($5,852) | ($2,321) | $2,190 |
Total Capital | $40,000 | $36,920 | $34,115 | $31,839 | $30,128 | $29,021 | $28,560 | $28,792 | $29,764 | $31,530 | $34,148 | $37,679 | $42,190 |
Total Liabilities and Capital | $40,000 | $42,604 | $40,171 | $38,065 | $36,536 | $35,624 | $35,372 | $35,826 | $37,037 | $39,060 | $41,952 | $45,777 | $50,603 |
Net Worth | $40,000 | $36,920 | $34,115 | $31,839 | $30,128 | $29,021 | $28,560 | $28,792 | $29,764 | $31,530 | $34,148 | $37,679 | $42,190 |