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 |