Clean Office Pros
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 | |||||||||||||
Office Cleaning (1000 Square Feet) | 235 | 258 | 284 | 312 | 343 | 377 | 415 | 457 | 503 | 553 | 608 | 669 | |
Window Cleaning (10 Windows) | 38 | 41 | 45 | 50 | 55 | 61 | 67 | 74 | 81 | 89 | 98 | 108 | |
Floor Treatments (100 Square Feet) | 47 | 51 | 56 | 62 | 68 | 75 | 82 | 90 | 99 | 109 | 120 | 132 | |
Carpet Cleaning (100 Square Feet) | 61 | 67 | 74 | 81 | 89 | 98 | 108 | 119 | 131 | 144 | 158 | 174 | |
Bathroom and Kitchen Cleaning (By Room) | 25 | 27 | 30 | 33 | 36 | 40 | 44 | 48 | 53 | 58 | 64 | 70 | |
Total Unit Sales | 405 | 444 | 489 | 538 | 591 | 651 | 716 | 788 | 867 | 953 | 1,048 | 1,153 | |
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 | |
Office Cleaning (1000 Square Feet) | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | |
Window Cleaning (10 Windows) | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | $90.00 | |
Floor Treatments (100 Square Feet) | $11.00 | $11.00 | $11.00 | $11.00 | $11.00 | $11.00 | $11.00 | $11.00 | $11.00 | $11.00 | $11.00 | $11.00 | |
Carpet Cleaning (100 Square Feet) | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | $80.00 | |
Bathroom and Kitchen Cleaning (By Room) | $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 | |||||||||||||
Office Cleaning (1000 Square Feet) | $23,496 | $25,800 | $28,400 | $31,200 | $34,300 | $37,700 | $41,500 | $45,700 | $50,300 | $55,300 | $60,800 | $66,900 | |
Window Cleaning (10 Windows) | $3,385 | $3,690 | $4,050 | $4,500 | $4,950 | $5,490 | $6,030 | $6,660 | $7,290 | $8,010 | $8,820 | $9,720 | |
Floor Treatments (100 Square Feet) | $515 | $561 | $616 | $682 | $748 | $825 | $902 | $990 | $1,089 | $1,199 | $1,320 | $1,452 | |
Carpet Cleaning (100 Square Feet) | $4,885 | $5,360 | $5,920 | $6,480 | $7,120 | $7,840 | $8,640 | $9,520 | $10,480 | $11,520 | $12,640 | $13,920 | |
Bathroom and Kitchen Cleaning (By Room) | $749 | $810 | $900 | $990 | $1,080 | $1,200 | $1,320 | $1,440 | $1,590 | $1,740 | $1,920 | $2,100 | |
Total Sales | $33,029 | $36,221 | $39,886 | $43,852 | $48,198 | $53,055 | $58,392 | $64,310 | $70,749 | $77,769 | $85,500 | $94,092 | |
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 | |
Office Cleaning (1000 Square Feet) | 35.00% | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 | $35.00 |
Window Cleaning (10 Windows) | 40.00% | $36.00 | $36.00 | $36.00 | $36.00 | $36.00 | $36.00 | $36.00 | $36.00 | $36.00 | $36.00 | $36.00 | $36.00 |
Floor Treatments (100 Square Feet) | 40.00% | $4.40 | $4.40 | $4.40 | $4.40 | $4.40 | $4.40 | $4.40 | $4.40 | $4.40 | $4.40 | $4.40 | $4.40 |
Carpet Cleaning (100 Square Feet) | 40.00% | $32.00 | $32.00 | $32.00 | $32.00 | $32.00 | $32.00 | $32.00 | $32.00 | $32.00 | $32.00 | $32.00 | $32.00 |
Bathroom and Kitchen Cleaning (By Room) | 40.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 | |||||||||||||
Office Cleaning (1000 Square Feet) | $8,223 | $9,030 | $9,940 | $10,920 | $12,005 | $13,195 | $14,525 | $15,995 | $17,605 | $19,355 | $21,280 | $23,415 | |
Window Cleaning (10 Windows) | $1,354 | $1,476 | $1,620 | $1,800 | $1,980 | $2,196 | $2,412 | $2,664 | $2,916 | $3,204 | $3,528 | $3,888 | |
Floor Treatments (100 Square Feet) | $206 | $224 | $246 | $273 | $299 | $330 | $361 | $396 | $436 | $480 | $528 | $581 | |
Carpet Cleaning (100 Square Feet) | $1,954 | $2,144 | $2,368 | $2,592 | $2,848 | $3,136 | $3,456 | $3,808 | $4,192 | $4,608 | $5,056 | $5,568 | |
Bathroom and Kitchen Cleaning (By Room) | $299 | $324 | $360 | $396 | $432 | $480 | $528 | $576 | $636 | $696 | $768 | $840 | |
Subtotal Direct Cost of Sales | $12,037 | $13,198 | $14,534 | $15,981 | $17,564 | $19,337 | $21,282 | $23,439 | $25,785 | $28,343 | $31,160 | $34,292 |
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 | ||
CEO | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Chief of Sales | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Accountant/CFO | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Operations Assistant | $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 People | 10 | 10 | 10 | 10 | 11 | 11 | 11 | 12 | 12 | 12 | 13 | 13 | |
Total Payroll | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,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 | $33,029 | $36,221 | $39,886 | $43,852 | $48,198 | $53,055 | $58,392 | $64,310 | $70,749 | $77,769 | $85,500 | $94,092 | |
Direct Cost of Sales | $12,037 | $13,198 | $14,534 | $15,981 | $17,564 | $19,337 | $21,282 | $23,439 | $25,785 | $28,343 | $31,160 | $34,292 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $12,037 | $13,198 | $14,534 | $15,981 | $17,564 | $19,337 | $21,282 | $23,439 | $25,785 | $28,343 | $31,160 | $34,292 | |
Gross Margin | $20,992 | $23,023 | $25,352 | $27,871 | $30,634 | $33,718 | $37,110 | $40,871 | $44,964 | $49,426 | $54,340 | $59,800 | |
Gross Margin % | 63.56% | 63.56% | 63.56% | 63.56% | 63.56% | 63.55% | 63.55% | 63.55% | 63.55% | 63.56% | 63.56% | 63.56% | |
Expenses | |||||||||||||
Payroll | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | |
Marketing/Promotion | $10,000 | $10,000 | $8,000 | $8,000 | $8,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Depreciation | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,600 | $1,600 | $1,600 | $1,600 | $2,000 | $2,000 | $2,000 | |
Rent | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Utilities | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Insurance | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Payroll Taxes | 15% | $3,154 | $3,270 | $3,403 | $3,548 | $3,706 | $3,884 | $4,078 | $4,294 | $4,528 | $4,784 | $5,066 | $5,379 |
Other | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Total Operating Expenses | $30,754 | $30,870 | $29,003 | $29,148 | $29,306 | $26,884 | $27,078 | $27,294 | $27,528 | $28,184 | $28,466 | $28,779 | |
Profit Before Interest and Taxes | ($9,761) | ($7,847) | ($3,652) | ($1,277) | $1,327 | $6,834 | $10,032 | $13,577 | $17,436 | $21,242 | $25,874 | $31,021 | |
EBITDA | ($8,561) | ($6,647) | ($2,452) | ($77) | $2,527 | $8,434 | $11,632 | $15,177 | $19,036 | $23,242 | $27,874 | $33,021 | |
Interest Expense | $194 | $179 | $165 | $150 | $146 | $180 | $172 | $165 | $365 | $358 | $350 | $342 | |
Taxes Incurred | ($2,987) | ($2,408) | ($1,145) | ($428) | $354 | $1,996 | $2,958 | $4,024 | $5,121 | $6,265 | $7,657 | $9,204 | |
Net Profit | ($6,969) | ($5,618) | ($2,672) | ($999) | $827 | $4,658 | $6,902 | $9,389 | $11,949 | $14,619 | $17,867 | $21,475 | |
Net Profit/Sales | -21.10% | -15.51% | -6.70% | -2.28% | 1.72% | 8.78% | 11.82% | 14.60% | 16.89% | 18.80% | 20.90% | 22.82% |
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 | |
Cash from Receivables | $0 | $17,616 | $34,731 | $38,176 | $42,001 | $46,170 | $50,788 | $55,901 | $61,548 | $67,744 | $74,493 | $81,892 | |
Subtotal Cash from Operations | $0 | $17,616 | $34,731 | $38,176 | $42,001 | $46,170 | $50,788 | $55,901 | $61,548 | $67,744 | $74,493 | $81,892 | |
Additional Cash Received | |||||||||||||
Sales Tax, VAT, HST/GST Received | 8.00% | $2,642 | $2,898 | $3,191 | $3,508 | $3,856 | $4,244 | $4,671 | $5,145 | $5,660 | $6,222 | $6,840 | $7,527 |
New Current Borrowing | $0 | $0 | $0 | $0 | $0 | $5,000 | $0 | $0 | $5,000 | $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 | $20,000 | $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 | $2,642 | $20,513 | $37,922 | $41,684 | $45,857 | $55,414 | $55,460 | $61,046 | $92,208 | $73,966 | $81,333 | $89,420 | |
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 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | |
Bill Payments | $2,860 | $25,859 | $27,663 | $28,434 | $30,735 | $33,192 | $33,900 | $37,005 | $40,451 | $44,331 | $48,299 | $52,799 | |
Subtotal Spent on Operations | $15,860 | $38,859 | $40,663 | $41,434 | $43,735 | $46,192 | $46,900 | $50,005 | $53,451 | $57,331 | $61,299 | $65,799 | |
Additional Cash Spent | |||||||||||||
Sales Tax, VAT, HST/GST Paid Out | $2,642 | $2,898 | $3,191 | $3,508 | $3,856 | $4,244 | $4,671 | $5,145 | $5,660 | $6,222 | $6,840 | $7,527 | |
Principal Repayment of Current Borrowing | $1,249 | $1,249 | $1,249 | $1,249 | $0 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $1,000 | $0 | $0 | $1,000 | $0 | $0 | $0 | |
Purchase Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $20,000 | $0 | $0 | $0 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $5,000 | $5,000 | $5,000 | $5,000 | |
Subtotal Cash Spent | $20,251 | $43,506 | $45,603 | $46,691 | $48,091 | $52,353 | $52,488 | $56,066 | $86,027 | $69,469 | $74,056 | $79,243 | |
Net Cash Flow | ($17,609) | ($22,993) | ($7,681) | ($5,007) | ($2,234) | $3,061 | $2,972 | $4,980 | $6,181 | $4,496 | $7,277 | $10,176 | |
Cash Balance | $42,391 | $19,398 | $11,717 | $6,710 | $4,477 | $7,538 | $10,510 | $15,490 | $21,671 | $26,167 | $33,444 | $43,620 |
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 | $60,000 | $42,391 | $19,398 | $11,717 | $6,710 | $4,477 | $7,538 | $10,510 | $15,490 | $21,671 | $26,167 | $33,444 | $43,620 |
Accounts Receivable | $0 | $33,029 | $51,635 | $56,789 | $62,465 | $68,662 | $75,547 | $83,151 | $91,560 | $100,760 | $110,785 | $121,792 | $133,992 |
Other Current Assets | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $6,000 | $6,000 | $6,000 | $7,000 | $7,000 | $7,000 | $7,000 |
Total Current Assets | $65,000 | $80,420 | $76,033 | $73,507 | $74,176 | $78,139 | $89,085 | $99,661 | $113,049 | $129,431 | $143,952 | $162,236 | $184,612 |
Long-term Assets | |||||||||||||
Long-term Assets | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $60,000 | $60,000 | $60,000 | $60,000 |
Accumulated Depreciation | $0 | $1,200 | $2,400 | $3,600 | $4,800 | $6,000 | $7,600 | $9,200 | $10,800 | $12,400 | $14,400 | $16,400 | $18,400 |
Total Long-term Assets | $40,000 | $38,800 | $37,600 | $36,400 | $35,200 | $34,000 | $32,400 | $30,800 | $29,200 | $47,600 | $45,600 | $43,600 | $41,600 |
Total Assets | $105,000 | $119,220 | $113,633 | $109,907 | $109,376 | $112,139 | $121,485 | $130,461 | $142,249 | $177,031 | $189,552 | $205,836 | $226,212 |
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 | $2,000 | $24,938 | $26,718 | $27,412 | $29,629 | $32,065 | $32,670 | $35,660 | $38,977 | $42,726 | $46,545 | $50,879 | $55,696 |
Current Borrowing | $5,000 | $3,751 | $2,502 | $1,253 | $4 | $4 | $4,587 | $4,171 | $3,754 | $8,337 | $7,921 | $7,504 | $7,087 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $7,000 | $28,689 | $29,220 | $28,665 | $29,633 | $32,069 | $37,258 | $39,831 | $42,731 | $51,064 | $54,466 | $58,383 | $62,784 |
Long-term Liabilities | $20,000 | $19,500 | $19,000 | $18,500 | $18,000 | $17,500 | $17,000 | $16,500 | $16,000 | $35,500 | $35,000 | $34,500 | $34,000 |
Total Liabilities | $27,000 | $48,189 | $48,220 | $47,165 | $47,633 | $49,569 | $54,258 | $56,331 | $58,731 | $86,564 | $89,466 | $92,883 | $96,784 |
Paid-in Capital | $111,500 | $111,500 | $111,500 | $111,500 | $111,500 | $111,500 | $111,500 | $111,500 | $111,500 | $111,500 | $111,500 | $111,500 | $111,500 |
Retained Earnings | ($33,500) | ($33,500) | ($33,500) | ($33,500) | ($33,500) | ($33,500) | ($33,500) | ($33,500) | ($33,500) | ($38,500) | ($43,500) | ($48,500) | ($53,500) |
Earnings | $0 | ($6,969) | ($12,587) | ($15,259) | ($16,257) | ($15,430) | ($10,772) | ($3,871) | $5,518 | $17,468 | $32,087 | $49,954 | $71,429 |
Total Capital | $78,000 | $71,031 | $65,413 | $62,741 | $61,743 | $62,570 | $67,228 | $74,129 | $83,518 | $90,468 | $100,087 | $112,954 | $129,429 |
Total Liabilities and Capital | $105,000 | $119,220 | $113,633 | $109,907 | $109,376 | $112,139 | $121,485 | $130,461 | $142,249 | $177,031 | $189,552 | $205,836 | $226,212 |
Net Worth | $78,000 | $71,031 | $65,413 | $62,741 | $61,743 | $62,570 | $67,228 | $74,129 | $83,518 | $90,468 | $100,087 | $112,954 | $129,429 |