CorbelArch Real Estate Inspectors
Appendix
| Sales Forecast | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | |||||||||||||
| Residential Inspection Services | 0% | $8,000 | $12,000 | $16,000 | $18,000 | $14,000 | $13,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 |
| Commercial Inspection Services | 0% | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
| Field Services | 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 |
| Property Preservation Services | 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 |
| Total Sales | $17,500 | $21,500 | $25,500 | $27,500 | $23,500 | $22,500 | $17,500 | $17,500 | $17,500 | $17,500 | $17,500 | $17,500 | |
| Direct Cost of Sales | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Mileage | $2,538 | $3,118 | $3,697 | $3,987 | $3,407 | $3,263 | $2,538 | $2,538 | $2,538 | $2,538 | $2,538 | $2,538 | |
| Report Materials | $1,050 | $1,290 | $1,530 | $1,650 | $1,410 | $1,350 | $1,050 | $1,050 | $1,050 | $1,050 | $1,050 | $1,050 | |
| Subtotal Direct Cost of Sales | $3,588 | $4,408 | $5,228 | $5,638 | $4,818 | $4,613 | $3,588 | $3,588 | $3,588 | $3,588 | $3,588 | $3,588 | |
| Personnel Plan | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Owner\Founders | 0% | $0 | $0 | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
| Employees | 0% | $0 | $0 | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | $0 | $0 | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| Pro Forma Profit and Loss | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | $17,500 | $21,500 | $25,500 | $27,500 | $23,500 | $22,500 | $17,500 | $17,500 | $17,500 | $17,500 | $17,500 | $17,500 | |
| Direct Cost of Sales | $3,588 | $4,408 | $5,228 | $5,638 | $4,818 | $4,613 | $3,588 | $3,588 | $3,588 | $3,588 | $3,588 | $3,588 | |
| Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $3,588 | $4,408 | $5,228 | $5,638 | $4,818 | $4,613 | $3,588 | $3,588 | $3,588 | $3,588 | $3,588 | $3,588 | |
| Gross Margin | $13,913 | $17,093 | $20,273 | $21,863 | $18,683 | $17,888 | $13,913 | $13,913 | $13,913 | $13,913 | $13,913 | $13,913 | |
| Gross Margin % | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | |
| Expenses | |||||||||||||
| Payroll | $0 | $0 | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| Marketing/Promotion | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $0 | $0 | $0 | $0 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
| Utilities | $0 | $0 | $0 | $0 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
| Insurance | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
| Website Hosting and Maintenance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Bookkeeping Service | 15% | $250 | $250 | $250 | $250 | $250 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Operating Expenses | $1,450 | $1,450 | $1,450 | $1,450 | $2,350 | $5,600 | $5,600 | $5,600 | $5,600 | $5,600 | $5,600 | $5,600 | |
| Profit Before Interest and Taxes | $12,463 | $15,643 | $18,823 | $20,413 | $16,333 | $12,288 | $8,313 | $8,313 | $8,313 | $8,313 | $8,313 | $8,313 | |
| EBITDA | $12,463 | $15,643 | $18,823 | $20,413 | $16,333 | $12,288 | $8,313 | $8,313 | $8,313 | $8,313 | $8,313 | $8,313 | |
| Interest Expense | $48 | $48 | $47 | $46 | $46 | $45 | $44 | $43 | $43 | $42 | $41 | $40 | |
| Taxes Incurred | $3,724 | $4,678 | $5,633 | $6,110 | $4,886 | $3,673 | $2,481 | $2,481 | $2,481 | $2,481 | $2,481 | $2,482 | |
| Net Profit | $8,690 | $10,916 | $13,143 | $14,256 | $11,401 | $8,570 | $5,788 | $5,788 | $5,789 | $5,789 | $5,790 | $5,790 | |
| Net Profit/Sales | 49.66% | 50.77% | 51.54% | 51.84% | 48.51% | 38.09% | 33.07% | 33.08% | 33.08% | 33.08% | 33.09% | 33.09% | |
| Pro Forma Cash Flow | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | $5,250 | $6,450 | $7,650 | $8,250 | $7,050 | $6,750 | $5,250 | $5,250 | $5,250 | $5,250 | $5,250 | $5,250 | |
| Cash from Receivables | $10,820 | $11,228 | $12,343 | $15,143 | $17,897 | $19,157 | $16,427 | $15,633 | $12,250 | $12,250 | $12,250 | $12,250 | |
| Subtotal Cash from Operations | $16,070 | $17,678 | $19,993 | $23,393 | $24,947 | $25,907 | $21,677 | $20,883 | $17,500 | $17,500 | $17,500 | $17,500 | |
| 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 | $16,070 | $17,678 | $19,993 | $23,393 | $24,947 | $25,907 | $21,677 | $20,883 | $17,500 | $17,500 | $17,500 | $17,500 | |
| Expenditures | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | $0 | $0 | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| Bill Payments | $2,294 | $8,869 | $10,643 | $12,387 | $13,205 | $12,060 | $10,856 | $8,712 | $8,712 | $8,711 | $8,711 | $8,710 | |
| Subtotal Spent on Operations | $2,294 | $8,869 | $10,643 | $12,387 | $13,205 | $15,060 | $13,856 | $11,712 | $11,712 | $11,711 | $11,711 | $11,710 | |
| 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 | $145 | $145 | $145 | $145 | $145 | $145 | $145 | $145 | $145 | $145 | $145 | $145 | |
| 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,439 | $9,014 | $10,788 | $12,532 | $13,350 | $15,205 | $14,001 | $11,857 | $11,857 | $11,856 | $11,856 | $11,855 | |
| Net Cash Flow | $13,631 | $8,664 | $9,206 | $10,862 | $11,596 | $10,702 | $7,676 | $9,026 | $5,643 | $5,644 | $5,644 | $5,645 | |
| Cash Balance | $16,631 | $25,294 | $34,500 | $45,362 | $56,958 | $67,659 | $75,335 | $84,361 | $90,005 | $95,649 | $101,293 | $106,938 | |
| Pro Forma Balance Sheet | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | $3,000 | $16,631 | $25,294 | $34,500 | $45,362 | $56,958 | $67,659 | $75,335 | $84,361 | $90,005 | $95,649 | $101,293 | $106,938 |
| Accounts Receivable | $21,639 | $23,070 | $26,892 | $32,398 | $36,505 | $35,058 | $31,652 | $27,475 | $24,092 | $24,092 | $24,092 | $24,092 | $24,092 |
| Other Current 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 Current Assets | $49,639 | $64,700 | $77,186 | $91,898 | $106,867 | $117,016 | $124,311 | $127,810 | $133,453 | $139,096 | $144,740 | $150,385 | $156,030 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 |
| Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Long-term Assets | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 |
| Total Assets | $64,639 | $79,700 | $92,186 | $106,898 | $121,867 | $132,016 | $139,311 | $142,810 | $148,453 | $154,096 | $159,740 | $165,385 | $171,030 |
| Liabilities and Capital | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Current Liabilities | |||||||||||||
| Accounts Payable | $2,000 | $8,516 | $10,231 | $11,945 | $12,802 | $11,696 | $10,566 | $8,422 | $8,421 | $8,421 | $8,420 | $8,420 | $8,419 |
| Current Borrowing | $9,827 | $9,682 | $9,537 | $9,392 | $9,247 | $9,102 | $8,957 | $8,812 | $8,667 | $8,522 | $8,377 | $8,232 | $8,087 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $11,827 | $18,198 | $19,768 | $21,337 | $22,049 | $20,798 | $19,523 | $17,234 | $17,088 | $16,943 | $16,797 | $16,652 | $16,506 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $11,827 | $18,198 | $19,768 | $21,337 | $22,049 | $20,798 | $19,523 | $17,234 | $17,088 | $16,943 | $16,797 | $16,652 | $16,506 |
| Paid-in Capital | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 |
| Retained Earnings | $22,812 | $22,812 | $22,812 | $22,812 | $22,812 | $22,812 | $22,812 | $22,812 | $22,812 | $22,812 | $22,812 | $22,812 | $22,812 |
| Earnings | $0 | $8,690 | $19,606 | $32,749 | $47,005 | $58,406 | $66,976 | $72,764 | $78,553 | $84,342 | $90,131 | $95,921 | $101,711 |
| Total Capital | $52,812 | $61,502 | $72,418 | $85,561 | $99,817 | $111,218 | $119,788 | $125,576 | $131,365 | $137,154 | $142,943 | $148,733 | $154,523 |
| Total Liabilities and Capital | $64,639 | $79,700 | $92,186 | $106,898 | $121,867 | $132,016 | $139,311 | $142,810 | $148,453 | $154,096 | $159,740 | $165,385 | $171,030 |
| Net Worth | $52,812 | $61,502 | $72,418 | $85,561 | $99,817 | $111,218 | $119,788 | $125,576 | $131,365 | $137,154 | $142,943 | $148,733 | $154,523 |
By 
