Country Crockery
Appendix
Sales Forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | |||||||||||||
Web Sales | $990 | $449 | $1,782 | $3,003 | $3,340 | $5,980 | $7,300 | $7,300 | $7,300 | $7,300 | $7,300 | $7,300 | |
Road Shows | $0 | $1,375 | $2,200 | $3,300 | $4,675 | $4,675 | $4,675 | $4,675 | $6,875 | $8,250 | $8,250 | $8,250 | |
Web Design | $1,375 | $1,375 | $825 | $825 | $825 | $825 | $825 | $825 | $825 | $825 | $825 | $825 | |
Total Sales | $2,365 | $3,199 | $4,807 | $7,128 | $8,840 | $11,480 | $12,800 | $12,800 | $15,000 | $16,375 | $16,375 | $16,375 | |
Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Web Sales | $445 | $202 | $800 | $1,348 | $1,499 | $2,685 | $3,278 | $3,278 | $3,278 | $3,278 | $3,278 | $3,278 | |
Road Shows | $0 | $825 | $1,320 | $1,980 | $2,805 | $2,805 | $2,805 | $2,805 | $4,125 | $4,950 | $4,950 | $4,950 | |
Web Design | $94 | $94 | $56 | $56 | $56 | $56 | $56 | $56 | $56 | $56 | $56 | $56 | |
Subtotal Direct Cost of Sales | $538 | $1,120 | $2,176 | $3,384 | $4,361 | $5,546 | $6,139 | $6,139 | $7,459 | $8,284 | $8,284 | $8,284 |
Personnel Plan | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
E. Jane Prenuer, Owner/Manager | 0% | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
John A. Prenuer, Co-Owner | 0% | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
General Labor | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,806 | $1,806 | $1,806 | $1,806 |
Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 4 | 4 | 4 | |
Total Payroll | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $3,806 | $3,806 | $3,806 | $3,806 |
Pro Forma Profit and Loss | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | $2,365 | $3,199 | $4,807 | $7,128 | $8,840 | $11,480 | $12,800 | $12,800 | $15,000 | $16,375 | $16,375 | $16,375 | |
Direct Cost of Sales | $538 | $1,120 | $2,176 | $3,384 | $4,361 | $5,546 | $6,139 | $6,139 | $7,459 | $8,284 | $8,284 | $8,284 | |
Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $538 | $1,120 | $2,176 | $3,384 | $4,361 | $5,546 | $6,139 | $6,139 | $7,459 | $8,284 | $8,284 | $8,284 | |
Gross Margin | $1,827 | $2,079 | $2,631 | $3,744 | $4,479 | $5,934 | $6,661 | $6,661 | $7,541 | $8,091 | $8,091 | $8,091 | |
Gross Margin % | 77.25% | 64.99% | 54.73% | 52.52% | 50.67% | 51.69% | 52.04% | 52.04% | 50.27% | 49.41% | 49.41% | 49.41% | |
Expenses | |||||||||||||
Payroll | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $3,806 | $3,806 | $3,806 | $3,806 | |
Sales and Marketing and Other Expenses | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Depreciation | $35 | $35 | $35 | $35 | $139 | $139 | $139 | $139 | $139 | $139 | $139 | $139 | |
Mortgage % for Business-only Areas | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
Telephone & Utilities | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Insurance | $71 | $0 | $0 | $0 | $0 | $72 | $72 | $72 | $72 | $72 | $72 | $72 | |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Web Store & Internet | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | |
Maintenance & Repair | $63 | $63 | $63 | $63 | $63 | $63 | $63 | $63 | $63 | $63 | $63 | $63 | |
Business Supplies | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | |
Professional Services | 15% | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 |
Expensed Barn Renovations | 15% | $0 | $2,500 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Miscellaneous | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | |
Total Operating Expenses | $2,989 | $5,418 | $2,918 | $2,918 | $3,022 | $3,094 | $3,094 | $3,094 | $4,900 | $4,900 | $4,900 | $4,900 | |
Profit Before Interest and Taxes | ($1,162) | ($3,339) | ($287) | $826 | $1,457 | $2,840 | $3,567 | $3,567 | $2,641 | $3,191 | $3,191 | $3,191 | |
EBITDA | ($1,127) | ($3,304) | ($252) | $861 | $1,596 | $2,979 | $3,706 | $3,706 | $2,780 | $3,330 | $3,330 | $3,330 | |
Interest Expense | $231 | $228 | $226 | $224 | $221 | $219 | $216 | $214 | $211 | $209 | $207 | $204 | |
Taxes Incurred | ($418) | ($1,070) | ($154) | $181 | $371 | $786 | $1,005 | $1,006 | $729 | $895 | $895 | $896 | |
Net Profit | ($975) | ($2,497) | ($359) | $421 | $865 | $1,835 | $2,345 | $2,347 | $1,701 | $2,087 | $2,089 | $2,091 | |
Net Profit/Sales | -41.23% | -78.07% | -7.47% | 5.91% | 9.79% | 15.98% | 18.32% | 18.34% | 11.34% | 12.75% | 12.76% | 12.77% |
Pro Forma Cash Flow | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $2,365 | $3,199 | $4,807 | $7,128 | $8,840 | $11,480 | $12,800 | $12,800 | $15,000 | $16,375 | $16,375 | $16,375 | |
Subtotal Cash from Operations | $2,365 | $3,199 | $4,807 | $7,128 | $8,840 | $11,480 | $12,800 | $12,800 | $15,000 | $16,375 | $16,375 | $16,375 | |
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 | $40,000 | $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 | $42,365 | $3,199 | $4,807 | $7,128 | $8,840 | $11,480 | $12,800 | $12,800 | $15,000 | $16,375 | $16,375 | $16,375 | |
Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Expenditures from Operations | |||||||||||||
Cash Spending | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $3,806 | $3,806 | $3,806 | $3,806 | |
Bill Payments | $1,227 | $826 | $2,588 | $3,966 | $4,339 | $5,949 | $8,815 | $8,945 | $8,396 | $10,821 | $11,219 | $10,340 | |
Subtotal Spent on Operations | $3,227 | $2,826 | $4,588 | $5,966 | $6,339 | $7,949 | $10,815 | $10,945 | $12,202 | $14,627 | $15,025 | $14,146 | |
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 | $3,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $3,670 | |
Long-term Liabilities Principal Repayment | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | $417 | |
Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Long-term Assets | $0 | $1,500 | $25,000 | $11,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 | $3,644 | $4,743 | $30,005 | $20,383 | $6,756 | $8,366 | $11,232 | $11,362 | $12,619 | $15,044 | $15,442 | $18,233 | |
Net Cash Flow | $38,721 | ($1,545) | ($25,198) | ($13,255) | $2,083 | $3,113 | $1,568 | $1,437 | $2,380 | $1,331 | $932 | ($1,859) | |
Cash Balance | $52,374 | $50,830 | $25,632 | $12,376 | $14,460 | $17,573 | $19,140 | $20,578 | $22,958 | $24,289 | $25,221 | $23,362 |
Pro Forma Balance Sheet | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $13,653 | $52,374 | $50,830 | $25,632 | $12,376 | $14,460 | $17,573 | $19,140 | $20,578 | $22,958 | $24,289 | $25,221 | $23,362 |
Inventory | $6,000 | $5,462 | $4,342 | $5,166 | $4,781 | $4,797 | $6,101 | $6,752 | $6,752 | $8,204 | $9,112 | $9,112 | $9,112 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $19,653 | $57,836 | $55,172 | $30,797 | $17,158 | $19,256 | $23,673 | $25,893 | $27,330 | $31,162 | $33,401 | $34,333 | $32,474 |
Long-term Assets | |||||||||||||
Long-term Assets | $12,555 | $12,555 | $14,055 | $39,055 | $50,055 | $50,055 | $50,055 | $50,055 | $50,055 | $50,055 | $50,055 | $50,055 | $50,055 |
Accumulated Depreciation | $1,200 | $1,235 | $1,270 | $1,305 | $1,340 | $1,479 | $1,618 | $1,757 | $1,896 | $2,035 | $2,174 | $2,313 | $2,452 |
Total Long-term Assets | $11,355 | $11,320 | $12,785 | $37,750 | $48,715 | $48,576 | $48,437 | $48,298 | $48,159 | $48,020 | $47,881 | $47,742 | $47,603 |
Total Assets | $31,008 | $69,157 | $67,957 | $68,548 | $65,873 | $67,833 | $72,111 | $74,191 | $75,489 | $79,182 | $81,282 | $82,075 | $80,077 |
Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Current Liabilities | |||||||||||||
Accounts Payable | $1,201 | $742 | $2,456 | $3,823 | $4,144 | $5,656 | $8,516 | $8,668 | $8,036 | $10,446 | $10,875 | $9,996 | $9,994 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $20,000 | $20,000 | $20,000 | $20,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $13,330 |
Subtotal Current Liabilities | $21,201 | $20,742 | $22,456 | $23,823 | $21,144 | $22,656 | $25,516 | $25,668 | $25,036 | $27,446 | $27,875 | $26,996 | $23,324 |
Long-term Liabilities | $0 | $39,583 | $39,166 | $38,749 | $38,332 | $37,915 | $37,498 | $37,081 | $36,664 | $36,247 | $35,830 | $35,413 | $34,996 |
Total Liabilities | $21,201 | $60,325 | $61,622 | $62,572 | $59,476 | $60,571 | $63,014 | $62,749 | $61,700 | $63,693 | $63,705 | $62,409 | $58,320 |
Paid-in Capital | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Retained Earnings | ($19,350) | $8,807 | $8,807 | $8,807 | $8,807 | $8,807 | $8,807 | $8,807 | $8,807 | $8,807 | $8,807 | $8,807 | $8,807 |
Earnings | $28,157 | ($975) | ($3,472) | ($3,832) | ($3,410) | ($2,545) | ($710) | $1,635 | $3,982 | $5,683 | $7,770 | $9,859 | $11,950 |
Total Capital | $9,807 | $8,832 | $6,335 | $5,975 | $6,397 | $7,262 | $9,097 | $11,442 | $13,789 | $15,490 | $17,577 | $19,666 | $21,757 |
Total Liabilities and Capital | $31,008 | $69,157 | $67,957 | $68,548 | $65,873 | $67,833 | $72,111 | $74,191 | $75,489 | $79,182 | $81,282 | $82,075 | $80,077 |
Net Worth | $9,807 | $8,832 | $6,335 | $5,975 | $6,397 | $7,262 | $9,097 | $11,442 | $13,789 | $15,490 | $17,577 | $19,666 | $21,757 |