Our biggest savings of the year
Columbia Cleaners
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 | ||
Sales | |||||||||||||
Dry Cleaning | 0% | $4,176 | $5,364 | $6,156 | $8,280 | $9,216 | $9,720 | $10,728 | $11,520 | $12,456 | $12,924 | $13,212 | $13,140 |
Laundry | 0% | $6,612 | $8,493 | $9,747 | $13,110 | $14,592 | $15,390 | $16,986 | $18,240 | $19,722 | $20,463 | $20,919 | $20,805 |
Alteration Services | 0% | $812 | $1,043 | $1,197 | $1,610 | $1,792 | $1,890 | $2,086 | $2,240 | $2,422 | $2,513 | $2,569 | $2,555 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $11,600 | $14,900 | $17,100 | $23,000 | $25,600 | $27,000 | $29,800 | $32,000 | $34,600 | $35,900 | $36,700 | $36,500 | |
Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Dry Cleaning | 12% | $501 | $644 | $739 | $994 | $1,106 | $1,166 | $1,287 | $1,382 | $1,495 | $1,551 | $1,585 | $1,577 |
Laundry | 8% | $529 | $679 | $780 | $1,049 | $1,167 | $1,231 | $1,359 | $1,459 | $1,578 | $1,637 | $1,674 | $1,664 |
Alteration Services | 30% | $244 | $313 | $359 | $483 | $538 | $567 | $626 | $672 | $727 | $754 | $771 | $767 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $1,274 | $1,636 | $1,878 | $2,525 | $2,811 | $2,965 | $3,272 | $3,514 | $3,799 | $3,942 | $4,030 | $4,008 |
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 | ||
Director/Accountant | 0% | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Laundry expert | 0% | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 |
Worker-1 | 0% | $936 | $936 | $936 | $936 | $936 | $936 | $936 | $936 | $936 | $936 | $936 | $936 |
Worker-2 | 0% | $936 | $936 | $936 | $936 | $936 | $936 | $936 | $936 | $936 | $936 | $936 | $936 |
Worker-3 | 0% | $0 | $0 | $0 | $936 | $936 | $936 | $936 | $936 | $936 | $936 | $936 | $936 |
Driver-1 | 0% | $364 | $364 | $364 | $364 | $364 | $364 | $364 | $364 | $364 | $364 | $364 | $364 |
Driver-2 | 0% | $364 | $364 | $364 | $364 | $364 | $364 | $364 | $364 | $364 | $364 | $364 | $364 |
Driver-3 | 0% | $0 | $0 | $0 | $364 | $364 | $364 | $364 | $364 | $364 | $364 | $364 | $364 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 6 | 6 | 6 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
Total Payroll | $8,680 | $8,680 | $8,680 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 |
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 | $11,600 | $14,900 | $17,100 | $23,000 | $25,600 | $27,000 | $29,800 | $32,000 | $34,600 | $35,900 | $36,700 | $36,500 | |
Direct Cost of Sales | $1,274 | $1,636 | $1,878 | $2,525 | $2,811 | $2,965 | $3,272 | $3,514 | $3,799 | $3,942 | $4,030 | $4,008 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $1,274 | $1,636 | $1,878 | $2,525 | $2,811 | $2,965 | $3,272 | $3,514 | $3,799 | $3,942 | $4,030 | $4,008 | |
Gross Margin | $10,326 | $13,264 | $15,222 | $20,475 | $22,789 | $24,035 | $26,528 | $28,486 | $30,801 | $31,958 | $32,670 | $32,492 | |
Gross Margin % | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | 89.02% | |
Expenses | |||||||||||||
Payroll | $8,680 | $8,680 | $8,680 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | |
Marketing/Promotion | $150 | $150 | $150 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Depreciation | $250 | $250 | $250 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | |
Rent | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | |
Utilities | $700 | $700 | $700 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Telecommunications | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Insurance | $700 | $700 | $700 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Maintenance | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Gas | $250 | $250 | $250 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Equipment lease | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | |
Office cleaning | 15% | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 |
Other | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Total Operating Expenses | $15,397 | $15,397 | $15,397 | $17,663 | $17,663 | $17,663 | $17,663 | $17,663 | $17,663 | $17,663 | $17,663 | $17,663 | |
Profit Before Interest and Taxes | ($5,070) | ($2,133) | ($174) | $2,811 | $5,126 | $6,372 | $8,865 | $10,823 | $13,138 | $14,295 | $15,007 | $14,829 | |
EBITDA | ($4,820) | ($1,883) | $76 | $3,228 | $5,542 | $6,789 | $9,281 | $11,240 | $13,554 | $14,712 | $15,424 | $15,246 | |
Interest Expense | $164 | $164 | $164 | $164 | $164 | $164 | $164 | $164 | $164 | $164 | $164 | $164 | |
Taxes Incurred | ($1,570) | ($689) | ($101) | $794 | $1,489 | $1,862 | $2,610 | $3,198 | $3,892 | $4,239 | $4,453 | $4,400 | |
Net Profit | ($3,664) | ($1,608) | ($237) | $1,853 | $3,473 | $4,346 | $6,091 | $7,461 | $9,082 | $9,892 | $10,390 | $10,266 | |
Net Profit/Sales | -31.59% | -10.79% | -1.38% | 8.06% | 13.57% | 16.10% | 20.44% | 23.32% | 26.25% | 27.55% | 28.31% | 28.12% |
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 | $11,600 | $14,900 | $17,100 | $23,000 | $25,600 | $27,000 | $29,800 | $32,000 | $34,600 | $35,900 | $36,700 | $36,500 | |
Subtotal Cash from Operations | $11,600 | $14,900 | $17,100 | $23,000 | $25,600 | $27,000 | $29,800 | $32,000 | $34,600 | $35,900 | $36,700 | $36,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 | $11,600 | $14,900 | $17,100 | $23,000 | $25,600 | $27,000 | $29,800 | $32,000 | $34,600 | $35,900 | $36,700 | $36,500 | |
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 | $8,680 | $8,680 | $8,680 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | $9,980 | |
Bill Payments | $202 | $6,108 | $7,526 | $8,740 | $11,419 | $12,029 | $12,452 | $13,646 | $14,418 | $15,419 | $15,763 | $15,995 | |
Subtotal Spent on Operations | $8,882 | $14,788 | $16,206 | $18,720 | $21,399 | $22,009 | $22,432 | $23,626 | $24,398 | $25,399 | $25,743 | $25,975 | |
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 | $334 | $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 | $10,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $9,216 | $14,788 | $16,206 | $28,720 | $21,399 | $22,009 | $22,432 | $23,626 | $24,398 | $25,399 | $25,743 | $25,975 | |
Net Cash Flow | $2,384 | $112 | $894 | ($5,720) | $4,201 | $4,991 | $7,368 | $8,374 | $10,202 | $10,501 | $10,957 | $10,525 | |
Cash Balance | $22,384 | $22,496 | $23,390 | $17,671 | $21,872 | $26,863 | $34,232 | $42,606 | $52,808 | $63,310 | $74,267 | $84,792 |
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 | $20,000 | $22,384 | $22,496 | $23,390 | $17,671 | $21,872 | $26,863 | $34,232 | $42,606 | $52,808 | $63,310 | $74,267 | $84,792 |
Inventory | $2,000 | $1,726 | $1,636 | $1,878 | $2,525 | $2,811 | $2,965 | $3,272 | $3,514 | $3,799 | $3,942 | $4,030 | $4,008 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $22,000 | $24,111 | $24,132 | $25,268 | $20,196 | $24,683 | $29,828 | $37,504 | $46,120 | $56,607 | $67,251 | $78,297 | $88,800 |
Long-term Assets | |||||||||||||
Long-term Assets | $15,000 | $15,000 | $15,000 | $15,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
Accumulated Depreciation | $0 | $250 | $500 | $750 | $1,167 | $1,583 | $2,000 | $2,417 | $2,833 | $3,250 | $3,667 | $4,083 | $4,500 |
Total Long-term Assets | $15,000 | $14,750 | $14,500 | $14,250 | $23,833 | $23,417 | $23,000 | $22,583 | $22,167 | $21,750 | $21,333 | $20,917 | $20,500 |
Total Assets | $37,000 | $38,861 | $38,632 | $39,518 | $44,029 | $48,100 | $52,828 | $60,087 | $68,286 | $78,357 | $88,585 | $99,213 | $109,300 |
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 | $5,858 | $7,238 | $8,360 | $11,018 | $11,615 | $11,998 | $13,166 | $13,904 | $14,894 | $15,229 | $15,468 | $15,289 |
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 | $5,858 | $7,238 | $8,360 | $11,018 | $11,615 | $11,998 | $13,166 | $13,904 | $14,894 | $15,229 | $15,468 | $15,289 |
Long-term Liabilities | $20,000 | $19,666 | $19,666 | $19,666 | $19,666 | $19,666 | $19,666 | $19,666 | $19,666 | $19,666 | $19,666 | $19,666 | $19,666 |
Total Liabilities | $20,000 | $25,524 | $26,904 | $28,026 | $30,684 | $31,281 | $31,664 | $32,832 | $33,570 | $34,560 | $34,895 | $35,134 | $34,955 |
Paid-in Capital | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 |
Retained Earnings | ($23,000) | ($23,000) | ($23,000) | ($23,000) | ($23,000) | ($23,000) | ($23,000) | ($23,000) | ($23,000) | ($23,000) | ($23,000) | ($23,000) | ($23,000) |
Earnings | $0 | ($3,664) | ($5,272) | ($5,508) | ($3,655) | ($182) | $4,164 | $10,254 | $17,716 | $26,798 | $36,689 | $47,079 | $57,345 |
Total Capital | $17,000 | $13,336 | $11,729 | $11,492 | $13,345 | $16,819 | $21,164 | $27,255 | $34,716 | $43,798 | $53,690 | $64,080 | $74,345 |
Total Liabilities and Capital | $37,000 | $38,861 | $38,632 | $39,518 | $44,029 | $48,100 | $52,828 | $60,087 | $68,286 | $78,357 | $88,585 | $99,213 | $109,300 |
Net Worth | $17,000 | $13,336 | $11,729 | $11,492 | $13,345 | $16,819 | $21,164 | $27,255 | $34,716 | $43,798 | $53,690 | $64,080 | $74,345 |