Compton Geotechnical Associates
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 | |||||||||||||
| Local and state governments | 0% | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $9,000 | $24,000 |
| Real estate companies | 0% | $0 | $0 | $0 | $0 | $0 | $2,000 | $4,000 | $4,000 | $5,000 | $5,000 | $6,000 | $7,000 |
| Construction companies | 0% | $0 | $0 | $0 | $0 | $7,000 | $5,000 | $3,000 | $26,000 | $4,000 | $7,000 | $10,000 | $7,000 |
| Utility companies | 0% | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $7,000 | $7,000 | $7,000 | $7,000 |
| Other projects | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $7,000 | $5,000 | $12,000 | $5,000 | $2,000 | $5,000 |
| Total Sales | $11,000 | $11,000 | $11,000 | $11,000 | $18,000 | $18,000 | $25,000 | $46,000 | $34,000 | $30,000 | $34,000 | $50,000 | |
| 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 | |
| Row 1 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Other | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Subtotal Direct Cost of Sales | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| 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 | ||
| Mr. Martin Compton – president | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Mrs. Elizabeth Bathory – office manager | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Mr. David Gillen – projects manager | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Mr. Jeremy Leither – staff engineer | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Geo-engineering consultant | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| CAD draftsperson P/T | 0% | $0 | $0 | $0 | $0 | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
| Total People | 0% | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
| Total Payroll | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $16,500 | $16,500 | $16,500 | $16,500 | $16,500 | $16,500 | $16,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 | $11,000 | $11,000 | $11,000 | $11,000 | $18,000 | $18,000 | $25,000 | $46,000 | $34,000 | $30,000 | $34,000 | $50,000 | |
| Direct Cost of Sales | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Other Costs of Sales | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $700 | $700 | $700 | $700 | $700 | |
| Total Cost of Sales | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $900 | $900 | $900 | $900 | $900 | |
| Gross Margin | $10,300 | $10,300 | $10,300 | $10,300 | $17,300 | $17,300 | $24,300 | $45,100 | $33,100 | $29,100 | $33,100 | $49,100 | |
| Gross Margin % | 93.64% | 93.64% | 93.64% | 93.64% | 96.11% | 96.11% | 97.20% | 98.04% | 97.35% | 97.00% | 97.35% | 98.20% | |
| Expenses | |||||||||||||
| Payroll | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $16,500 | $16,500 | $16,500 | $16,500 | $16,500 | $16,500 | $16,500 | |
| Sales and Marketing and Other Expenses | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Utilities | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
| Insurance | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | |
| Payroll Taxes | 15% | $2,250 | $2,250 | $2,250 | $2,250 | $2,250 | $2,475 | $2,475 | $2,475 | $2,475 | $2,475 | $2,475 | $2,475 |
| Travel | 15% | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
| Other | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | |
| Total Operating Expenses | $22,250 | $22,250 | $22,250 | $22,250 | $22,250 | $23,975 | $23,975 | $23,975 | $23,975 | $23,975 | $23,975 | $23,975 | |
| Profit Before Interest and Taxes | ($11,950) | ($11,950) | ($11,950) | ($11,950) | ($4,950) | ($6,675) | $325 | $21,125 | $9,125 | $5,125 | $9,125 | $25,125 | |
| EBITDA | ($11,950) | ($11,950) | ($11,950) | ($11,950) | ($4,950) | ($6,675) | $325 | $21,125 | $9,125 | $5,125 | $9,125 | $25,125 | |
| Interest Expense | $508 | $508 | $508 | $508 | $508 | $508 | $508 | $508 | $508 | $508 | $508 | $508 | |
| Taxes Incurred | ($3,738) | ($3,738) | ($3,738) | ($3,738) | ($1,637) | ($2,155) | ($55) | $6,185 | $2,585 | $1,385 | $2,585 | $7,385 | |
| Net Profit | ($8,721) | ($8,721) | ($8,721) | ($8,721) | ($3,821) | ($5,028) | ($128) | $14,432 | $6,032 | $3,232 | $6,032 | $17,232 | |
| Net Profit/Sales | -79.28% | -79.28% | -79.28% | -79.28% | -21.23% | -27.94% | -0.51% | 31.37% | 17.74% | 10.77% | 17.74% | 34.46% | |
| 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,750 | $2,750 | $2,750 | $2,750 | $4,500 | $4,500 | $6,250 | $11,500 | $8,500 | $7,500 | $8,500 | $12,500 | |
| Cash from Receivables | $0 | $275 | $8,250 | $8,250 | $8,250 | $8,425 | $13,500 | $13,675 | $19,275 | $34,200 | $25,400 | $22,600 | |
| Subtotal Cash from Operations | $2,750 | $3,025 | $11,000 | $11,000 | $12,750 | $12,925 | $19,750 | $25,175 | $27,775 | $41,700 | $33,900 | $35,100 | |
| 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 | $1,500 | $1,500 | $0 | $0 | $0 | $0 | |
| Subtotal Cash Received | $2,750 | $3,025 | $11,000 | $11,000 | $12,750 | $12,925 | $21,250 | $26,675 | $27,775 | $41,700 | $33,900 | $35,100 | |
| 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 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $16,500 | $16,500 | $16,500 | $16,500 | $16,500 | $16,500 | $16,500 | |
| Bill Payments | $3,157 | $4,721 | $4,721 | $4,721 | $4,791 | $6,811 | $6,598 | $8,843 | $14,948 | $11,428 | $10,308 | $11,628 | |
| Subtotal Spent on Operations | $18,157 | $19,721 | $19,721 | $19,721 | $19,791 | $23,311 | $23,098 | $25,343 | $31,448 | $27,928 | $26,808 | $28,128 | |
| 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 | $18,157 | $19,721 | $19,721 | $19,721 | $19,791 | $23,311 | $23,098 | $25,343 | $31,448 | $27,928 | $26,808 | $28,128 | |
| Net Cash Flow | ($15,407) | ($16,696) | ($8,721) | ($8,721) | ($7,041) | ($10,386) | ($1,848) | $1,332 | ($3,673) | $13,772 | $7,092 | $6,972 | |
| Cash Balance | $89,393 | $72,697 | $63,976 | $55,255 | $48,214 | $37,828 | $35,980 | $37,312 | $33,639 | $47,410 | $54,502 | $61,474 | |
| 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 | $104,800 | $89,393 | $72,697 | $63,976 | $55,255 | $48,214 | $37,828 | $35,980 | $37,312 | $33,639 | $47,410 | $54,502 | $61,474 |
| Accounts Receivable | $0 | $8,250 | $16,225 | $16,225 | $16,225 | $21,475 | $26,550 | $31,800 | $52,625 | $58,850 | $47,150 | $47,250 | $62,150 |
| 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 | $108,300 | $101,143 | $92,422 | $83,701 | $74,980 | $73,189 | $67,878 | $71,280 | $93,437 | $95,989 | $98,060 | $105,252 | $127,124 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
| Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Long-term Assets | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
| Total Assets | $133,300 | $126,143 | $117,422 | $108,701 | $99,980 | $98,189 | $92,878 | $96,280 | $118,437 | $120,989 | $123,060 | $130,252 | $152,124 |
| 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 | $3,000 | $4,563 | $4,563 | $4,563 | $4,563 | $6,593 | $6,311 | $8,341 | $14,566 | $11,086 | $9,926 | $11,086 | $15,726 |
| Current Borrowing | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 | $16,000 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $19,000 | $20,563 | $20,563 | $20,563 | $20,563 | $22,593 | $22,311 | $24,341 | $30,566 | $27,086 | $25,926 | $27,086 | $31,726 |
| Long-term Liabilities | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 |
| Total Liabilities | $64,000 | $65,563 | $65,563 | $65,563 | $65,563 | $67,593 | $67,311 | $69,341 | $75,566 | $72,086 | $70,926 | $72,086 | $76,726 |
| Paid-in Capital | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $101,500 | $103,000 | $103,000 | $103,000 | $103,000 | $103,000 |
| Retained Earnings | ($30,700) | ($30,700) | ($30,700) | ($30,700) | ($30,700) | ($30,700) | ($30,700) | ($30,700) | ($30,700) | ($30,700) | ($30,700) | ($30,700) | ($30,700) |
| Earnings | $0 | ($8,721) | ($17,442) | ($26,163) | ($34,883) | ($38,704) | ($43,733) | ($43,861) | ($29,429) | ($23,398) | ($20,166) | ($14,134) | $3,097 |
| Total Capital | $69,300 | $60,579 | $51,858 | $43,138 | $34,417 | $30,596 | $25,567 | $26,939 | $42,871 | $48,902 | $52,134 | $58,166 | $75,398 |
| Total Liabilities and Capital | $133,300 | $126,143 | $117,422 | $108,701 | $99,980 | $98,189 | $92,878 | $96,280 | $118,437 | $120,989 | $123,060 | $130,252 | $152,124 |
| Net Worth | $69,300 | $60,579 | $51,858 | $43,138 | $34,417 | $30,596 | $25,568 | $26,939 | $42,871 | $48,903 | $52,134 | $58,166 | $75,398 |