Twin Brothers Construction
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 | |||||||||||||
Direct Construction Projects | 0% | $0 | $0 | $0 | $10,000 | $10,000 | $10,000 | $15,000 | $15,000 | $15,000 | $20,000 | $20,000 | $20,000 |
Building Renovations | 0% | $7,500 | $7,500 | $8,000 | $8,000 | $9,000 | $9,000 | $10,000 | $10,000 | $12,000 | $12,000 | $15,000 | $15,000 |
Building Rentals | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Sale of Components and Goods | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other | 0% | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Total Sales | $7,500 | $7,500 | $8,000 | $19,000 | $20,000 | $20,000 | $26,000 | $26,000 | $28,000 | $33,000 | $36,000 | $36,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 | |
All construction work | 40% | $0 | $0 | $0 | $4,000 | $4,000 | $4,000 | $6,000 | $6,000 | $6,000 | $8,000 | $8,000 | $8,000 |
Renovations | 40% | $3,000 | $3,000 | $3,200 | $3,200 | $3,600 | $3,600 | $4,000 | $4,000 | $4,800 | $4,800 | $6,000 | $6,000 |
Rentals | 20% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Sale of Components and Goods | 20% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other | 10% | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Subtotal Direct Cost of Sales | $3,000 | $3,000 | $3,200 | $8,200 | $8,600 | $8,600 | $11,000 | $11,000 | $11,800 | $13,800 | $15,000 | $15,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 | ||
Chairman (Principal Owner) | 0% | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
CEO (Secondary Owner) | 0% | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
Office Clerk (Temporary Hire) | 0% | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,500 | $1,500 | $1,500 | $1,750 | $1,750 | $1,750 |
Foreman (Temporary Hire) | 0% | $0 | $0 | $0 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 |
Technical Employee (Part-time) | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
Total People | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | |
Total Payroll | $4,250 | $4,250 | $4,250 | $6,650 | $6,650 | $6,650 | $8,400 | $8,400 | $8,400 | $8,650 | $8,650 | $8,650 |
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% | |
Sales on Credit | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
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 | $7,500 | $7,500 | $8,000 | $19,000 | $20,000 | $20,000 | $26,000 | $26,000 | $28,000 | $33,000 | $36,000 | $36,000 | |
Direct Cost of Sales | $3,000 | $3,000 | $3,200 | $8,200 | $8,600 | $8,600 | $11,000 | $11,000 | $11,800 | $13,800 | $15,000 | $15,000 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $3,000 | $3,000 | $3,200 | $8,200 | $8,600 | $8,600 | $11,000 | $11,000 | $11,800 | $13,800 | $15,000 | $15,000 | |
Gross Margin | $4,500 | $4,500 | $4,800 | $10,800 | $11,400 | $11,400 | $15,000 | $15,000 | $16,200 | $19,200 | $21,000 | $21,000 | |
Gross Margin % | 60.00% | 60.00% | 60.00% | 56.84% | 57.00% | 57.00% | 57.69% | 57.69% | 57.86% | 58.18% | 58.33% | 58.33% | |
Expenses | |||||||||||||
Payroll | $4,250 | $4,250 | $4,250 | $6,650 | $6,650 | $6,650 | $8,400 | $8,400 | $8,400 | $8,650 | $8,650 | $8,650 | |
Sales and Marketing and Other Expenses | $500 | $500 | $500 | $500 | $500 | $500 | $750 | $750 | $750 | $750 | $750 | $750 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Gasoline and oil | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Telephone | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | |
Utilities | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Insurance | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
Rent | $1,500 | $543 | $543 | $543 | $543 | $543 | $543 | $543 | $543 | $543 | $543 | $543 | |
Payroll Taxes | 15% | $543 | $543 | $543 | $543 | $543 | $543 | $543 | $543 | $543 | $543 | $543 | $544 |
Website Maintenance & Support | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
Consultants | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Advertising | 15% | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
Misc. Other Expenses | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Total Operating Expenses | $9,868 | $8,912 | $8,912 | $11,312 | $11,312 | $11,312 | $13,312 | $13,312 | $13,312 | $13,562 | $13,562 | $13,562 | |
Profit Before Interest and Taxes | ($5,368) | ($4,412) | ($4,112) | ($512) | $88 | $88 | $1,688 | $1,688 | $2,888 | $5,638 | $7,438 | $7,438 | |
EBITDA | ($5,368) | ($4,412) | ($4,112) | ($512) | $88 | $88 | $1,688 | $1,688 | $2,888 | $5,638 | $7,438 | $7,438 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $625 | |
Taxes Incurred | ($1,611) | ($1,324) | ($1,234) | ($154) | $26 | $26 | $506 | $506 | $866 | $1,691 | $2,231 | $2,044 | |
Net Profit | ($3,758) | ($3,088) | ($2,878) | ($358) | $62 | $62 | $1,182 | $1,182 | $2,022 | $3,947 | $5,207 | $4,769 | |
Net Profit/Sales | -50.11% | -41.18% | -35.98% | -1.89% | 0.31% | 0.31% | 4.54% | 4.54% | 7.22% | 11.96% | 14.46% | 13.25% |
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 | $7,500 | $7,500 | $8,000 | $19,000 | $20,000 | $20,000 | $26,000 | $26,000 | $28,000 | $33,000 | $36,000 | $36,000 | |
Subtotal Cash from Operations | $7,500 | $7,500 | $8,000 | $19,000 | $20,000 | $20,000 | $26,000 | $26,000 | $28,000 | $33,000 | $36,000 | $36,000 | |
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 | $75,000 | |
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 | $7,500 | $7,500 | $8,000 | $19,000 | $20,000 | $20,000 | $26,000 | $26,000 | $28,000 | $33,000 | $36,000 | $111,000 | |
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,250 | $4,250 | $4,250 | $6,650 | $6,650 | $6,650 | $8,400 | $8,400 | $8,400 | $8,650 | $8,650 | $8,650 | |
Bill Payments | $234 | $6,986 | $6,348 | $6,831 | $12,728 | $13,288 | $13,393 | $16,418 | $16,457 | $17,672 | $20,461 | $22,158 | |
Subtotal Spent on Operations | $4,484 | $11,236 | $10,598 | $13,481 | $19,378 | $19,938 | $21,793 | $24,818 | $24,857 | $26,322 | $29,111 | $30,808 | |
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 | $100,000 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $4,484 | $11,236 | $10,598 | $13,481 | $19,378 | $19,938 | $21,793 | $24,818 | $24,857 | $26,322 | $29,111 | $130,808 | |
Net Cash Flow | $3,016 | ($3,736) | ($2,598) | $5,519 | $622 | $62 | $4,207 | $1,182 | $3,143 | $6,678 | $6,889 | ($19,808) | |
Cash Balance | $53,016 | $49,281 | $46,683 | $52,202 | $52,824 | $52,886 | $57,093 | $58,275 | $61,418 | $68,095 | $74,984 | $55,176 |
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 | $50,000 | $53,016 | $49,281 | $46,683 | $52,202 | $52,824 | $52,886 | $57,093 | $58,275 | $61,418 | $68,095 | $74,984 | $55,176 |
Other Current Assets | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Total Current Assets | $55,000 | $58,016 | $54,281 | $51,683 | $57,202 | $57,824 | $57,886 | $62,093 | $63,275 | $66,418 | $73,095 | $79,984 | $60,176 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $100,000 |
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 | $100,000 |
Total Assets | $55,000 | $58,016 | $54,281 | $51,683 | $57,202 | $57,824 | $57,886 | $62,093 | $63,275 | $66,418 | $73,095 | $79,984 | $160,176 |
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 | $6,774 | $6,127 | $6,407 | $12,285 | $12,845 | $12,845 | $15,871 | $15,871 | $16,992 | $19,723 | $21,405 | $21,828 |
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 | $6,774 | $6,127 | $6,407 | $12,285 | $12,845 | $12,845 | $15,871 | $15,871 | $16,992 | $19,723 | $21,405 | $21,828 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $75,000 |
Total Liabilities | $0 | $6,774 | $6,127 | $6,407 | $12,285 | $12,845 | $12,845 | $15,871 | $15,871 | $16,992 | $19,723 | $21,405 | $96,828 |
Paid-in Capital | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 |
Retained Earnings | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) |
Earnings | $0 | ($3,758) | ($6,846) | ($9,725) | ($10,083) | ($10,021) | ($9,960) | ($8,778) | ($7,596) | ($5,575) | ($1,628) | $3,579 | $8,348 |
Total Capital | $55,000 | $51,242 | $48,154 | $45,275 | $44,917 | $44,979 | $45,040 | $46,222 | $47,404 | $49,425 | $53,372 | $58,579 | $63,348 |
Total Liabilities and Capital | $55,000 | $58,016 | $54,281 | $51,683 | $57,202 | $57,824 | $57,886 | $62,093 | $63,275 | $66,418 | $73,095 | $79,984 | $160,176 |
Net Worth | $55,000 | $51,242 | $48,154 | $45,275 | $44,917 | $44,979 | $45,040 | $46,222 | $47,404 | $49,425 | $53,372 | $58,579 | $63,348 |