Doggie Pause
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 | |||||||||||||
Doggie care hours (all inclusive) | 20% | $5,125 | $5,395 | $6,835 | $12,595 | $9,265 | $7,825 | $8,095 | $8,635 | $11,245 | $15,714 | $20,395 | $24,355 |
Other | 20% | $765 | $585 | $705 | $1,215 | $585 | $705 | $1,215 | $1,095 | $1,305 | $1,785 | $2,055 | $2,235 |
Total Sales | $5,890 | $5,980 | $7,540 | $13,810 | $9,850 | $8,530 | $9,310 | $9,730 | $12,550 | $17,499 | $22,450 | $26,590 | |
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 | |
Doggie care hours (all inclusive) | 10% | $513 | $540 | $684 | $1,260 | $927 | $783 | $810 | $864 | $1,125 | $1,571 | $2,040 | $2,436 |
Other | 35% | $268 | $205 | $247 | $425 | $205 | $247 | $425 | $383 | $457 | $625 | $719 | $782 |
Subtotal Direct Cost of Sales | $780 | $744 | $930 | $1,685 | $1,131 | $1,029 | $1,235 | $1,247 | $1,581 | $2,196 | $2,759 | $3,218 |
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 | ||
Dog care assistants/groomers | 0% | $3,200 | $3,200 | $3,200 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $6,400 | $6,400 |
Admin/etc. | 0% | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $1,200 | $1,200 | $1,200 | $1,200 |
Total People | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 6 | 6 | |
Total Payroll | $3,700 | $3,700 | $3,700 | $5,300 | $5,300 | $5,300 | $5,300 | $5,300 | $6,000 | $6,000 | $7,600 | $7,600 |
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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | $5,890 | $5,980 | $7,540 | $13,810 | $9,850 | $8,530 | $9,310 | $9,730 | $12,550 | $17,499 | $22,450 | $26,590 | |
Direct Cost of Sales | $780 | $744 | $930 | $1,685 | $1,131 | $1,029 | $1,235 | $1,247 | $1,581 | $2,196 | $2,759 | $3,218 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $780 | $744 | $930 | $1,685 | $1,131 | $1,029 | $1,235 | $1,247 | $1,581 | $2,196 | $2,759 | $3,218 | |
Gross Margin | $5,110 | $5,236 | $6,610 | $12,125 | $8,719 | $7,501 | $8,075 | $8,483 | $10,969 | $15,303 | $19,691 | $23,372 | |
Gross Margin % | 86.75% | 87.55% | 87.66% | 87.80% | 88.52% | 87.93% | 86.74% | 87.19% | 87.40% | 87.45% | 87.71% | 87.90% | |
Expenses | |||||||||||||
Payroll | $3,700 | $3,700 | $3,700 | $5,300 | $5,300 | $5,300 | $5,300 | $5,300 | $6,000 | $6,000 | $7,600 | $7,600 | |
Sales and Marketing and Other Expenses | $3,000 | $2,000 | $2,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $750 | $750 | $750 | $750 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $200 | $200 | $200 | $225 | $225 | $225 | $225 | $225 | $250 | $250 | $250 | $250 | |
Insurance | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
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 | |
Payroll Taxes | 15% | $555 | $555 | $555 | $795 | $795 | $795 | $795 | $795 | $900 | $900 | $1,140 | $1,140 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $10,455 | $9,455 | $9,455 | $10,320 | $10,320 | $10,320 | $10,320 | $10,320 | $10,900 | $10,900 | $12,740 | $12,740 | |
Profit Before Interest and Taxes | ($5,345) | ($4,219) | ($2,845) | $1,805 | ($1,601) | ($2,819) | ($2,245) | ($1,837) | $69 | $4,403 | $6,951 | $10,632 | |
EBITDA | ($5,345) | ($4,219) | ($2,845) | $1,805 | ($1,601) | ($2,819) | ($2,245) | ($1,837) | $69 | $4,403 | $6,951 | $10,632 | |
Interest Expense | $325 | $316 | $308 | $299 | $291 | $282 | $273 | $264 | $255 | $246 | $237 | $228 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($5,670) | ($4,536) | ($3,153) | $1,506 | ($1,892) | ($3,101) | ($2,518) | ($2,101) | ($186) | $4,157 | $6,714 | $10,405 | |
Net Profit/Sales | -96.27% | -75.85% | -41.82% | 10.90% | -19.21% | -36.36% | -27.04% | -21.59% | -1.49% | 23.75% | 29.91% | 39.13% |
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 | $5,890 | $5,980 | $7,540 | $13,810 | $9,850 | $8,530 | $9,310 | $9,730 | $12,550 | $17,499 | $22,450 | $26,590 | |
Subtotal Cash from Operations | $5,890 | $5,980 | $7,540 | $13,810 | $9,850 | $8,530 | $9,310 | $9,730 | $12,550 | $17,499 | $22,450 | $26,590 | |
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 | $10,000 | $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 | $5,890 | $5,980 | $7,540 | $13,810 | $9,850 | $8,530 | $19,310 | $9,730 | $12,550 | $17,499 | $22,450 | $26,590 | |
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 | $3,700 | $3,700 | $3,700 | $5,300 | $5,300 | $5,300 | $5,300 | $5,300 | $6,000 | $6,000 | $7,600 | $7,600 | |
Bill Payments | $262 | $7,825 | $6,822 | $6,994 | $6,985 | $6,438 | $6,338 | $6,528 | $6,538 | $6,757 | $7,369 | $8,151 | |
Subtotal Spent on Operations | $3,962 | $11,525 | $10,522 | $12,294 | $12,285 | $11,738 | $11,638 | $11,828 | $12,538 | $12,757 | $14,969 | $15,751 | |
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 | $1,009 | $1,017 | $1,025 | $1,034 | $1,043 | $1,051 | $1,060 | $1,069 | $1,078 | $1,087 | $1,096 | $1,105 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $10,000 | |
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 | $4,971 | $12,542 | $11,547 | $13,328 | $13,328 | $12,789 | $12,698 | $12,897 | $13,616 | $13,843 | $16,065 | $26,856 | |
Net Cash Flow | $919 | ($6,562) | ($4,007) | $482 | ($3,478) | ($4,259) | $6,612 | ($3,167) | ($1,066) | $3,656 | $6,385 | ($266) | |
Cash Balance | $20,919 | $14,357 | $10,350 | $10,832 | $7,355 | $3,095 | $9,707 | $6,541 | $5,475 | $9,131 | $15,516 | $15,251 |
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 | $20,919 | $14,357 | $10,350 | $10,832 | $7,355 | $3,095 | $9,707 | $6,541 | $5,475 | $9,131 | $15,516 | $15,251 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $20,000 | $20,919 | $14,357 | $10,350 | $10,832 | $7,355 | $3,095 | $9,707 | $6,541 | $5,475 | $9,131 | $15,516 | $15,251 |
Long-term Assets | |||||||||||||
Long-term Assets | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 |
Total Assets | $27,500 | $28,419 | $21,857 | $17,850 | $18,332 | $14,855 | $10,595 | $17,207 | $14,041 | $12,975 | $16,631 | $23,016 | $22,751 |
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 | $7,598 | $6,589 | $6,760 | $6,771 | $6,227 | $6,120 | $6,310 | $6,313 | $6,512 | $7,097 | $7,864 | $8,299 |
Current Borrowing | $40,000 | $38,991 | $37,974 | $36,949 | $35,915 | $34,872 | $33,821 | $32,761 | $31,692 | $30,614 | $29,528 | $28,432 | $27,327 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $0 |
Subtotal Current Liabilities | $40,000 | $46,590 | $44,563 | $43,709 | $42,686 | $41,100 | $39,941 | $49,071 | $48,005 | $47,126 | $46,625 | $46,296 | $35,626 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $40,000 | $46,590 | $44,563 | $43,709 | $42,686 | $41,100 | $39,941 | $49,071 | $48,005 | $47,126 | $46,625 | $46,296 | $35,626 |
Paid-in Capital | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
Retained Earnings | ($32,500) | ($32,500) | ($32,500) | ($32,500) | ($32,500) | ($32,500) | ($32,500) | ($32,500) | ($32,500) | ($32,500) | ($32,500) | ($32,500) | ($32,500) |
Earnings | $0 | ($5,670) | ($10,206) | ($13,359) | ($11,853) | ($13,745) | ($16,846) | ($19,364) | ($21,465) | ($21,651) | ($17,494) | ($10,780) | ($375) |
Total Capital | ($12,500) | ($18,170) | ($22,706) | ($25,859) | ($24,353) | ($26,245) | ($29,346) | ($31,864) | ($33,965) | ($34,151) | ($29,994) | ($23,280) | ($12,875) |
Total Liabilities and Capital | $27,500 | $28,419 | $21,857 | $17,850 | $18,332 | $14,855 | $10,595 | $17,207 | $14,041 | $12,975 | $16,631 | $23,016 | $22,751 |
Net Worth | ($12,500) | ($18,170) | ($22,706) | ($25,859) | ($24,353) | ($26,245) | ($29,346) | ($31,864) | ($33,965) | ($34,151) | ($29,994) | ($23,280) | ($12,875) |