StructureAll Ltd.
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 | ||
Unit Sales | |||||||||||||
Project Consulting | 0% | 50 | 50 | 50 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 |
Project Management | 0% | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 |
Home Inspections | 0% | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |
Computer Aided Drafting Services | 0% | 40 | 60 | 70 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 |
Total Unit Sales | 118 | 138 | 148 | 168 | 168 | 168 | 168 | 168 | 168 | 168 | 168 | 168 | |
Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Project Consulting | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | |
Project Management | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | |
Home Inspections | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | |
Computer Aided Drafting Services | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | |
Sales | |||||||||||||
Project Consulting | $4,000 | $4,000 | $4,000 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | |
Project Management | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | |
Home Inspections | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | $640 | |
Computer Aided Drafting Services | $1,600 | $2,400 | $2,800 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | |
Total Sales | $7,840 | $8,640 | $9,040 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | |
Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Project Consulting | 0.00% | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 |
Project Management | 0.00% | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 |
Home Inspections | 0.00% | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 | $24.00 |
Computer Aided Drafting Services | 0.00% | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 |
Direct Cost of Sales | |||||||||||||
Project Consulting | $1,200 | $1,200 | $1,200 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | |
Project Management | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | $480 | |
Home Inspections | $192 | $192 | $192 | $192 | $192 | $192 | $192 | $192 | $192 | $192 | $192 | $192 | |
Computer Aided Drafting Services | $480 | $720 | $840 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | |
Subtotal Direct Cost of Sales | $2,352 | $2,592 | $2,712 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 |
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 | ||
Owner | 0% | $2,500 | $2,500 | $3,000 | $4,000 | $4,000 | $4,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Name or Title or Group | 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 | $2,500 | $2,500 | $3,000 | $4,000 | $4,000 | $4,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
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,840 | $8,640 | $9,040 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | |
Direct Cost of Sales | $2,352 | $2,592 | $2,712 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $2,352 | $2,592 | $2,712 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | $3,072 | |
Gross Margin | $5,488 | $6,048 | $6,328 | $7,168 | $7,168 | $7,168 | $7,168 | $7,168 | $7,168 | $7,168 | $7,168 | $7,168 | |
Gross Margin % | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | |
Expenses | |||||||||||||
Payroll | $2,500 | $2,500 | $3,000 | $4,000 | $4,000 | $4,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Marketing/Promotion | $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 | |
Website Hosting Fees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Engineering Assoc Annual Fees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Continuing Education | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Yellow Pages/White Pages | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Telephone/Fax | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Software Purchases (Staad-Pro Core) | $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 | |
Errors and Omissions Insurance | $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 | |
Payroll Taxes | 0% | $375 | $375 | $450 | $600 | $600 | $600 | $750 | $750 | $750 | $750 | $750 | $750 |
Contract/Consultants | 15% | $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 | |
Total Operating Expenses | $2,875 | $2,875 | $3,450 | $4,600 | $4,600 | $4,600 | $5,750 | $5,750 | $5,750 | $5,750 | $5,750 | $5,750 | |
Profit Before Interest and Taxes | $2,613 | $3,173 | $2,878 | $2,568 | $2,568 | $2,568 | $1,418 | $1,418 | $1,418 | $1,418 | $1,418 | $1,418 | |
EBITDA | $2,613 | $3,173 | $2,878 | $2,568 | $2,568 | $2,568 | $1,418 | $1,418 | $1,418 | $1,418 | $1,418 | $1,418 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | $784 | $952 | $863 | $770 | $770 | $770 | $425 | $425 | $425 | $425 | $425 | $425 | |
Net Profit | $1,829 | $2,221 | $2,015 | $1,798 | $1,798 | $1,798 | $993 | $993 | $993 | $993 | $993 | $993 | |
Net Profit/Sales | 23.33% | 25.71% | 22.29% | 17.55% | 17.55% | 17.55% | 9.69% | 9.69% | 9.69% | 9.69% | 9.69% | 9.69% |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash from Operations | $0 | $261 | $7,867 | $8,653 | $9,080 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | |
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 | $261 | $7,867 | $8,653 | $9,080 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | $10,240 | |
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 | $2,500 | $2,500 | $3,000 | $4,000 | $4,000 | $4,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Bill Payments | $117 | $3,525 | $3,922 | $4,039 | $4,442 | $4,442 | $4,436 | $4,247 | $4,247 | $4,247 | $4,247 | $4,247 | |
Subtotal Spent on Operations | $2,617 | $6,025 | $6,922 | $8,039 | $8,442 | $8,442 | $9,436 | $9,247 | $9,247 | $9,247 | $9,247 | $9,247 | |
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 | $2,617 | $6,025 | $6,922 | $8,039 | $8,442 | $8,442 | $9,436 | $9,247 | $9,247 | $9,247 | $9,247 | $9,247 | |
Net Cash Flow | ($2,617) | ($5,763) | $944 | $614 | $638 | $1,798 | $804 | $993 | $993 | $993 | $993 | $993 | |
Cash Balance | $9,383 | $3,620 | $4,564 | $5,178 | $5,816 | $7,613 | $8,417 | $9,410 | $10,403 | $11,395 | $12,388 | $13,380 |
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 | $12,000 | $9,383 | $3,620 | $4,564 | $5,178 | $5,816 | $7,613 | $8,417 | $9,410 | $10,403 | $11,395 | $12,388 | $13,380 |
Accounts Receivable | $0 | $7,840 | $16,219 | $17,392 | $18,979 | $20,139 | $20,139 | $20,139 | $20,139 | $20,139 | $20,139 | $20,139 | $20,139 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $12,000 | $17,223 | $19,838 | $21,956 | $24,157 | $25,954 | $27,752 | $28,556 | $29,549 | $30,541 | $31,534 | $32,526 | $33,519 |
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 | $12,000 | $17,223 | $19,838 | $21,956 | $24,157 | $25,954 | $27,752 | $28,556 | $29,549 | $30,541 | $31,534 | $32,526 | $33,519 |
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 | $3,394 | $3,788 | $3,891 | $4,294 | $4,294 | $4,294 | $4,106 | $4,106 | $4,106 | $4,106 | $4,106 | $4,106 |
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 | $3,394 | $3,788 | $3,891 | $4,294 | $4,294 | $4,294 | $4,106 | $4,106 | $4,106 | $4,106 | $4,106 | $4,106 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $3,394 | $3,788 | $3,891 | $4,294 | $4,294 | $4,294 | $4,106 | $4,106 | $4,106 | $4,106 | $4,106 | $4,106 |
Paid-in Capital | $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 |
Retained Earnings | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) | ($13,000) |
Earnings | $0 | $1,829 | $4,050 | $6,065 | $7,862 | $9,660 | $11,458 | $12,450 | $13,443 | $14,435 | $15,428 | $16,421 | $17,413 |
Total Capital | $12,000 | $13,829 | $16,050 | $18,065 | $19,862 | $21,660 | $23,458 | $24,450 | $25,443 | $26,435 | $27,428 | $28,421 | $29,413 |
Total Liabilities and Capital | $12,000 | $17,223 | $19,838 | $21,956 | $24,157 | $25,954 | $27,752 | $28,556 | $29,549 | $30,541 | $31,534 | $32,526 | $33,519 |
Net Worth | $12,000 | $13,829 | $16,050 | $18,065 | $19,862 | $21,660 | $23,458 | $24,450 | $25,443 | $26,435 | $27,428 | $28,421 | $29,413 |