Doggie Pause

Start your own business plan »

Animal Day Care Business Plan

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)