Inspection Connection
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 | |||||||||||||
Buyer Home Inspection | 0% | 2 | 3 | 4 | 5 | 5 | 6 | 8 | 10 | 10 | 10 | 10 | 10 |
Pre-Listing Home Inspection | 0% | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Maintenance Inspection | 0% | 1 | 1 | 3 | 5 | 7 | 9 | 14 | 16 | 16 | 18 | 20 | 20 |
Total Unit Sales | 4 | 5 | 8 | 11 | 13 | 16 | 23 | 27 | 27 | 29 | 31 | 31 | |
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 | |
Buyer Home Inspection | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | |
Pre-Listing Home Inspection | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | |
Maintenance Inspection | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | |
Sales | |||||||||||||
Buyer Home Inspection | $900 | $1,350 | $1,800 | $2,250 | $2,250 | $2,700 | $3,600 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | |
Pre-Listing Home Inspection | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | |
Maintenance Inspection | $450 | $450 | $1,350 | $2,250 | $3,150 | $4,050 | $6,300 | $7,200 | $7,200 | $8,100 | $9,000 | $9,000 | |
Total Sales | $1,800 | $2,250 | $3,600 | $4,950 | $5,850 | $7,200 | $10,350 | $12,150 | $12,150 | $13,050 | $13,950 | $13,950 | |
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 | |
Buyer Home Inspection | 10.00% | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 |
Pre-Listing Home Inspection | 10.00% | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 |
Maintenance Inspection | 10.00% | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 |
Direct Cost of Sales | |||||||||||||
Buyer Home Inspection | $90 | $135 | $180 | $225 | $225 | $270 | $360 | $450 | $450 | $450 | $450 | $450 | |
Pre-Listing Home Inspection | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | |
Maintenance Inspection | $45 | $45 | $135 | $225 | $315 | $405 | $630 | $720 | $720 | $810 | $900 | $900 | |
Subtotal Direct Cost of Sales | $180 | $225 | $360 | $495 | $585 | $720 | $1,035 | $1,215 | $1,215 | $1,305 | $1,395 | $1,395 |
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 | ||
Jacques Clouseau – Owner / Operator | 0% | $1,000 | $1,000 | $1,500 | $2,000 | $2,000 | $2,500 | $2,500 | $2,500 | $2,500 | $3,000 | $3,000 | $5,100 |
Name or Title or Group | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
Total Payroll | $1,000 | $1,000 | $1,500 | $2,000 | $2,000 | $2,500 | $2,500 | $2,500 | $2,500 | $3,000 | $3,000 | $5,100 |
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 | $1,800 | $2,250 | $3,600 | $4,950 | $5,850 | $7,200 | $10,350 | $12,150 | $12,150 | $13,050 | $13,950 | $13,950 | |
Direct Cost of Sales | $180 | $225 | $360 | $495 | $585 | $720 | $1,035 | $1,215 | $1,215 | $1,305 | $1,395 | $1,395 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $180 | $225 | $360 | $495 | $585 | $720 | $1,035 | $1,215 | $1,215 | $1,305 | $1,395 | $1,395 | |
Gross Margin | $1,620 | $2,025 | $3,240 | $4,455 | $5,265 | $6,480 | $9,315 | $10,935 | $10,935 | $11,745 | $12,555 | $12,555 | |
Gross Margin % | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | 90.00% | |
Expenses | |||||||||||||
Payroll | $1,000 | $1,000 | $1,500 | $2,000 | $2,000 | $2,500 | $2,500 | $2,500 | $2,500 | $3,000 | $3,000 | $5,100 | |
Marketing/Promotion | $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 | |
Answering Service | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Liability / E&O Insurance | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
HealthCare | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
Auto Insurance | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | |
Auto Fuel | $50 | $75 | $100 | $150 | $175 | $200 | $250 | $300 | $300 | $300 | $300 | $300 | |
Accounting/Legal Fees | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Membership/Licensing Fees | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Vehicle Maintenance | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | |
Local/Toll Free Phone Numbers | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | |
Training/internship | $0 | $0 | $14,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Supplies | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | |
Payroll taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Total Operating Expenses | $4,460 | $4,485 | $19,010 | $5,560 | $5,585 | $6,110 | $6,160 | $6,210 | $6,210 | $6,710 | $6,710 | $8,810 | |
Profit Before Interest and Taxes | ($2,840) | ($2,460) | ($15,770) | ($1,105) | ($320) | $370 | $3,155 | $4,725 | $4,725 | $5,035 | $5,845 | $3,745 | |
EBITDA | ($2,840) | ($2,460) | ($15,770) | ($1,105) | ($320) | $370 | $3,155 | $4,725 | $4,725 | $5,035 | $5,845 | $3,745 | |
Interest Expense | $0 | $0 | $82 | $79 | $76 | $73 | $70 | $67 | $64 | $61 | $58 | $54 | |
Taxes Incurred | ($852) | ($738) | ($4,756) | ($355) | ($119) | $89 | $926 | $1,397 | $1,398 | $1,492 | $1,736 | $1,107 | |
Net Profit | ($1,988) | ($1,722) | ($11,096) | ($829) | ($277) | $208 | $2,160 | $3,261 | $3,263 | $3,482 | $4,051 | $2,583 | |
Net Profit/Sales | -110.44% | -76.53% | -308.23% | -16.74% | -4.74% | 2.89% | 20.86% | 26.84% | 26.85% | 26.68% | 29.04% | 18.52% |
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 | $1,800 | $2,250 | $3,600 | $4,950 | $5,850 | $7,200 | $10,350 | $12,150 | $12,150 | $13,050 | $13,950 | $13,950 | |
Subtotal Cash from Operations | $1,800 | $2,250 | $3,600 | $4,950 | $5,850 | $7,200 | $10,350 | $12,150 | $12,150 | $13,050 | $13,950 | $13,950 | |
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 | $14,000 | $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 | $1,800 | $2,250 | $17,600 | $4,950 | $5,850 | $7,200 | $10,350 | $12,150 | $12,150 | $13,050 | $13,950 | $13,950 | |
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 | $1,000 | $1,000 | $15,500 | $2,000 | $2,000 | $2,500 | $2,500 | $2,500 | $2,500 | $3,000 | $3,000 | $5,100 | |
Bill Payments | $93 | $2,794 | $2,069 | ($651) | $3,790 | $4,139 | $4,532 | $5,714 | $6,389 | $6,393 | $6,579 | $6,878 | |
Subtotal Spent on Operations | $1,093 | $3,794 | $17,569 | $1,349 | $5,790 | $6,639 | $7,032 | $8,214 | $8,889 | $9,393 | $9,579 | $11,978 | |
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 | $500 | $500 | $500 | $500 | $500 | $500 | $560 | $560 | $560 | |
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 | $1,093 | $3,794 | $17,569 | $1,849 | $6,290 | $7,139 | $7,532 | $8,714 | $9,389 | $9,953 | $10,139 | $12,538 | |
Net Cash Flow | $707 | ($1,544) | $31 | $3,101 | ($440) | $61 | $2,818 | $3,436 | $2,761 | $3,097 | $3,811 | $1,412 | |
Cash Balance | $2,288 | $744 | $775 | $3,876 | $3,436 | $3,496 | $6,314 | $9,751 | $12,511 | $15,608 | $19,419 | $20,831 |
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 | $1,581 | $2,288 | $744 | $775 | $3,876 | $3,436 | $3,496 | $6,314 | $9,751 | $12,511 | $15,608 | $19,419 | $20,831 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $1,581 | $2,288 | $744 | $775 | $3,876 | $3,436 | $3,496 | $6,314 | $9,751 | $12,511 | $15,608 | $19,419 | $20,831 |
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 | $1,581 | $2,288 | $744 | $775 | $3,876 | $3,436 | $3,496 | $6,314 | $9,751 | $12,511 | $15,608 | $19,419 | $20,831 |
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 | $2,695 | $2,873 | $0 | $4,430 | $4,767 | $5,119 | $6,278 | $6,954 | $6,952 | $7,126 | $7,446 | $6,835 |
Current Borrowing | $0 | $0 | $0 | $14,000 | $13,500 | $13,000 | $12,500 | $12,000 | $11,500 | $11,000 | $10,440 | $9,880 | $9,320 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $0 | $2,695 | $2,873 | $14,000 | $17,930 | $17,767 | $17,619 | $18,278 | $18,454 | $17,952 | $17,566 | $17,326 | $16,155 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $2,695 | $2,873 | $14,000 | $17,930 | $17,767 | $17,619 | $18,278 | $18,454 | $17,952 | $17,566 | $17,326 | $16,155 |
Paid-in Capital | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
Retained Earnings | ($4,419) | ($4,419) | ($4,419) | ($4,419) | ($4,419) | ($4,419) | ($4,419) | ($4,419) | ($4,419) | ($4,419) | ($4,419) | ($4,419) | ($4,419) |
Earnings | $0 | ($1,988) | ($3,710) | ($14,806) | ($15,635) | ($15,912) | ($15,704) | ($13,544) | ($10,284) | ($7,021) | ($3,539) | $512 | $3,095 |
Total Capital | $1,581 | ($407) | ($2,129) | ($13,225) | ($14,054) | ($14,331) | ($14,123) | ($11,963) | ($8,703) | ($5,440) | ($1,958) | $2,093 | $4,676 |
Total Liabilities and Capital | $1,581 | $2,288 | $744 | $775 | $3,876 | $3,436 | $3,496 | $6,314 | $9,751 | $12,511 | $15,608 | $19,419 | $20,831 |
Net Worth | $1,581 | ($407) | ($2,129) | ($13,225) | ($14,054) | ($14,331) | ($14,123) | ($11,963) | ($8,703) | ($5,440) | ($1,958) | $2,093 | $4,676 |