Guildford Dry Cleaning Service
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 | £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 | £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 Service | £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 | |
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 | £501 | £644 | £739 | £994 | £1,106 | £1,166 | £1,287 | £1,382 | £1,495 | £1,551 | £1,585 | £1,577 | |
Laundry | £529 | £679 | £780 | £1,049 | £1,167 | £1,231 | £1,359 | £1,459 | £1,578 | £1,637 | £1,674 | £1,664 | |
Alteration Service | £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% | £3,840 | £3,840 | £3,840 | £3,840 | £3,840 | £3,840 | £3,840 | £3,840 | £3,840 | £3,840 | £3,840 | £3,840 |
Laundry expert | 0% | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 |
Worker-1 | 0% | £672 | £672 | £672 | £896 | £896 | £896 | £896 | £896 | £896 | £896 | £896 | £896 |
Worker-2 | 0% | £672 | £672 | £672 | £896 | £896 | £896 | £896 | £896 | £896 | £896 | £896 | £896 |
Worker-3 | 0% | £0 | £0 | £0 | £896 | £896 | £896 | £896 | £896 | £896 | £896 | £896 | £896 |
Driver-1 | 0% | £160 | £160 | £160 | £320 | £320 | £320 | £320 | £320 | £320 | £320 | £320 | £320 |
Driver-2 | 0% | £160 | £160 | £160 | £320 | £320 | £320 | £320 | £320 | £320 | £320 | £320 | £320 |
Driver-3 | 0% | £0 | £0 | £0 | £320 | £320 | £320 | £320 | £320 | £320 | £320 | £320 | £320 |
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 | £7,424 | £7,424 | £7,424 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 |
General Assumptions | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Long-term Interest Rate | 6.48% | 6.48% | 6.48% | 6.48% | 6.48% | 6.48% | 6.48% | 6.48% | 6.48% | 6.48% | 6.48% | 6.48% | |
Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
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 | £7,424 | £7,424 | £7,424 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | |
Sales and Marketing and Other Expenses | £150 | £150 | £150 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
Depreciation | £275 | £275 | £275 | £275 | £392 | £392 | £392 | £392 | £392 | £392 | £392 | £392 | |
Rent | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
Utilities | £800 | £800 | £800 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
Inserted Row | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
Petrol | £150 | £150 | £150 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
Equipment Lease | £834 | £834 | £834 | £834 | £834 | £834 | £834 | £834 | £834 | £834 | £834 | £834 | |
Maintenance | £50 | £50 | £50 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
Office Cleaning | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
Insurance | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | |
Payroll Taxes (National Insurance, etc.) | 15% | £1,114 | £1,114 | £1,114 | £1,411 | £1,411 | £1,411 | £1,411 | £1,411 | £1,411 | £1,411 | £1,411 | £1,411 |
Other | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
Total Operating Expenses | £12,367 | £12,367 | £12,367 | £15,098 | £15,215 | £15,215 | £15,215 | £15,215 | £15,215 | £15,215 | £15,215 | £15,215 | |
Profit Before Interest and Taxes | (£2,040) | £897 | £2,856 | £5,376 | £7,574 | £8,820 | £11,313 | £13,271 | £15,586 | £16,743 | £17,455 | £17,277 | |
EBITDA | (£1,765) | £1,172 | £3,131 | £5,651 | £7,966 | £9,212 | £11,705 | £13,663 | £15,978 | £17,135 | £17,847 | £17,669 | |
Interest Expense | £104 | £102 | £101 | £137 | £135 | £133 | £131 | £129 | £127 | £125 | £123 | £121 | |
Taxes Incurred | (£643) | £239 | £827 | £1,572 | £2,232 | £2,606 | £3,354 | £3,943 | £4,638 | £4,985 | £5,200 | £5,147 | |
Net Profit | (£1,501) | £557 | £1,929 | £3,668 | £5,207 | £6,081 | £7,827 | £9,199 | £10,821 | £11,633 | £12,132 | £12,009 | |
Net Profit/Sales | -12.94% | 3.74% | 11.28% | 15.95% | 20.34% | 22.52% | 26.27% | 28.75% | 31.27% | 32.40% | 33.06% | 32.90% |
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 | £7,000 | £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 | £30,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 | £7,424 | £7,424 | £7,424 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | £9,408 | |
Bill Payments | £206 | £6,203 | £7,030 | £7,800 | £10,317 | £10,891 | £11,313 | £12,506 | £13,276 | £14,276 | £14,618 | £14,849 | |
Subtotal Spent on Operations | £7,630 | £13,627 | £14,454 | £17,208 | £19,725 | £20,299 | £20,721 | £21,914 | £22,684 | £23,684 | £24,026 | £24,257 | |
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 | £276 | £278 | £280 | £282 | £364 | £366 | £368 | £370 | £372 | £374 | £376 | £378 | |
Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
Purchase Long-term Assets | £0 | £0 | £0 | £7,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 | £7,906 | £13,905 | £14,734 | £24,490 | £20,089 | £20,665 | £21,089 | £22,284 | £23,056 | £24,058 | £24,402 | £24,635 | |
Net Cash Flow | £3,694 | £995 | £2,366 | £5,510 | £5,511 | £6,335 | £8,711 | £9,716 | £11,544 | £11,842 | £12,298 | £11,865 | |
Cash Balance | £26,400 | £27,395 | £29,761 | £35,270 | £40,782 | £47,116 | £55,827 | £65,544 | £77,087 | £88,929 | £101,227 | £113,092 |
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 | £22,706 | £26,400 | £27,395 | £29,761 | £35,270 | £40,782 | £47,116 | £55,827 | £65,544 | £77,087 | £88,929 | £101,227 | £113,092 |
Inventory | £500 | £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 Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Total Current Assets | £23,206 | £27,674 | £29,031 | £31,638 | £37,796 | £43,593 | £50,081 | £59,099 | £69,057 | £80,886 | £92,871 | £105,257 | £117,099 |
Long-term Assets | |||||||||||||
Long-term Assets | £14,000 | £14,000 | £14,000 | £14,000 | £21,000 | £21,000 | £21,000 | £21,000 | £21,000 | £21,000 | £21,000 | £21,000 | £21,000 |
Accumulated Depreciation | £0 | £275 | £550 | £825 | £1,100 | £1,492 | £1,884 | £2,276 | £2,668 | £3,060 | £3,452 | £3,844 | £4,236 |
Total Long-term Assets | £14,000 | £13,725 | £13,450 | £13,175 | £19,900 | £19,508 | £19,116 | £18,724 | £18,332 | £17,940 | £17,548 | £17,156 | £16,764 |
Total Assets | £37,206 | £41,399 | £42,481 | £44,813 | £57,696 | £63,101 | £69,197 | £77,823 | £87,389 | £98,826 | £110,419 | £122,413 | £133,863 |
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,970 | £6,773 | £7,457 | £9,954 | £10,516 | £10,897 | £12,064 | £12,801 | £13,789 | £14,123 | £14,360 | £14,180 |
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,970 | £6,773 | £7,457 | £9,954 | £10,516 | £10,897 | £12,064 | £12,801 | £13,789 | £14,123 | £14,360 | £14,180 |
Long-term Liabilities | £19,500 | £19,224 | £18,946 | £18,666 | £25,384 | £25,020 | £24,654 | £24,286 | £23,916 | £23,544 | £23,170 | £22,794 | £22,416 |
Total Liabilities | £19,500 | £25,194 | £25,719 | £26,123 | £35,338 | £35,536 | £35,551 | £36,350 | £36,717 | £37,333 | £37,293 | £37,154 | £36,596 |
Paid-in Capital | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 |
Retained Earnings | (£14,294) | (£14,294) | (£14,294) | (£14,294) | (£14,294) | (£14,294) | (£14,294) | (£14,294) | (£14,294) | (£14,294) | (£14,294) | (£14,294) | (£14,294) |
Earnings | £0 | (£1,501) | (£944) | £984 | £4,652 | £9,859 | £15,940 | £23,767 | £32,966 | £43,787 | £55,420 | £67,552 | £79,562 |
Total Capital | £17,706 | £16,205 | £16,762 | £18,690 | £22,358 | £27,565 | £33,646 | £41,473 | £50,672 | £61,493 | £73,126 | £85,258 | £97,268 |
Total Liabilities and Capital | £37,206 | £41,399 | £42,481 | £44,813 | £57,696 | £63,101 | £69,197 | £77,823 | £87,389 | £98,826 | £110,419 | £122,413 | £133,863 |
Net Worth | £17,706 | £16,205 | £16,762 | £18,690 | £22,358 | £27,565 | £33,646 | £41,473 | £50,672 | £61,493 | £73,126 | £85,258 | £97,268 |
Market Analysis | |||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
Potential Customers | Growth | CAGR | |||||
Full-time employees | 5% | 49,400 | 51,870 | 54,464 | 57,187 | 60,046 | 5.00% |
Part-time employees | 10% | 14,625 | 16,088 | 17,697 | 19,467 | 21,414 | 10.00% |
Other | 2% | 1,500 | 1,530 | 1,561 | 1,592 | 1,624 | 2.01% |
Total | 6.12% | 65,525 | 69,488 | 73,722 | 78,246 | 83,084 | 6.12% |