Southwest Veterinary Clinic

Start your own business plan »

Veterinary Clinic 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
Services 0% $15,000 $20,000 $23,000 $26,000 $30,000 $34,000 $36,000 $40,000 $44,000 $46,000 $50,000 $53,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $15,000 $20,000 $23,000 $26,000 $30,000 $34,000 $36,000 $40,000 $44,000 $46,000 $50,000 $53,000
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
Services $4,000 $5,000 $5,300 $6,000 $7,000 $8,000 $8,400 $9,000 $10,000 $11,000 $12,000 $13,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $4,000 $5,000 $5,300 $6,000 $7,000 $8,000 $8,400 $9,000 $10,000 $11,000 $12,000 $13,000
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
Edward Anderson 0% $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800
Michelle Johnson 0% $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800
Receptionist/Clerical 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Veterinary Assistants (2) 0% $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400
Total People 5 5 5 5 5 5 5 5 5 5 5 5
Total Payroll $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000
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% 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 $15,000 $20,000 $23,000 $26,000 $30,000 $34,000 $36,000 $40,000 $44,000 $46,000 $50,000 $53,000
Direct Cost of Sales $4,000 $5,000 $5,300 $6,000 $7,000 $8,000 $8,400 $9,000 $10,000 $11,000 $12,000 $13,000
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $4,000 $5,000 $5,300 $6,000 $7,000 $8,000 $8,400 $9,000 $10,000 $11,000 $12,000 $13,000
Gross Margin $11,000 $15,000 $17,700 $20,000 $23,000 $26,000 $27,600 $31,000 $34,000 $35,000 $38,000 $40,000
Gross Margin % 73.33% 75.00% 76.96% 76.92% 76.67% 76.47% 76.67% 77.50% 77.27% 76.09% 76.00% 75.47%
Expenses
Payroll $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000
Sales and Marketing and Other Expenses $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Depreciation $952 $952 $952 $952 $952 $952 $952 $952 $952 $952 $952 $952
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Insurance $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Rent $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Payroll Taxes 15% $2,220 $2,295 $2,295 $2,295 $2,295 $2,295 $2,295 $2,295 $2,295 $2,295 $2,295 $2,295
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $21,572 $21,647 $21,647 $21,647 $21,647 $21,647 $21,647 $21,647 $21,647 $21,647 $21,647 $21,647
Profit Before Interest and Taxes ($10,572) ($6,647) ($3,947) ($1,647) $1,353 $4,353 $5,953 $9,353 $12,353 $13,353 $16,353 $18,353
EBITDA ($9,620) ($5,695) ($2,995) ($695) $2,305 $5,305 $6,905 $10,305 $13,305 $14,305 $17,305 $19,305
Interest Expense $1,240 $1,231 $1,221 $1,211 $1,201 $1,192 $1,182 $1,172 $1,163 $1,153 $1,143 $1,133
Taxes Incurred ($3,544) ($2,363) ($1,550) ($857) $45 $948 $1,431 $2,454 $3,357 $3,660 $4,563 $5,166
Net Profit ($8,269) ($5,514) ($3,617) ($2,001) $106 $2,213 $3,340 $5,727 $7,833 $8,540 $10,647 $12,054
Net Profit/Sales -55.12% -27.57% -15.73% -7.69% 0.35% 6.51% 9.28% 14.32% 17.80% 18.57% 21.29% 22.74%
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 $15,000 $20,000 $23,000 $26,000 $30,000 $34,000 $36,000 $40,000 $44,000 $46,000 $50,000 $53,000
Subtotal Cash from Operations $15,000 $20,000 $23,000 $26,000 $30,000 $34,000 $36,000 $40,000 $44,000 $46,000 $50,000 $53,000
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 $15,000 $20,000 $23,000 $26,000 $30,000 $34,000 $36,000 $40,000 $44,000 $46,000 $50,000 $53,000
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 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000 $14,000
Bill Payments $277 $8,391 $10,599 $11,712 $13,112 $15,005 $16,864 $17,762 $19,385 $21,258 $22,571 $24,454
Subtotal Spent on Operations $14,277 $22,391 $24,599 $25,712 $27,112 $29,005 $30,864 $31,762 $33,385 $35,258 $36,571 $38,454
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 $1,166 $1,166 $1,166 $1,166 $1,166 $1,166 $1,166 $1,166 $1,166 $1,166 $1,166 $1,166
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 $15,443 $23,557 $25,765 $26,878 $28,278 $30,171 $32,030 $32,928 $34,551 $36,424 $37,737 $39,620
Net Cash Flow ($443) ($3,557) ($2,765) ($878) $1,722 $3,829 $3,970 $7,072 $9,449 $9,576 $12,263 $13,380
Cash Balance $24,557 $20,999 $18,234 $17,357 $19,079 $22,908 $26,878 $33,950 $43,399 $52,975 $65,238 $78,618
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 $25,000 $24,557 $20,999 $18,234 $17,357 $19,079 $22,908 $26,878 $33,950 $43,399 $52,975 $65,238 $78,618
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $25,000 $24,557 $20,999 $18,234 $17,357 $19,079 $22,908 $26,878 $33,950 $43,399 $52,975 $65,238 $78,618
Long-term Assets
Long-term Assets $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000
Accumulated Depreciation $0 $952 $1,904 $2,856 $3,808 $4,760 $5,712 $6,664 $7,616 $8,568 $9,520 $10,472 $11,424
Total Long-term Assets $110,000 $109,048 $108,096 $107,144 $106,192 $105,240 $104,288 $103,336 $102,384 $101,432 $100,480 $99,528 $98,576
Total Assets $135,000 $133,605 $129,095 $125,378 $123,549 $124,319 $127,196 $130,214 $136,334 $144,831 $153,455 $164,766 $177,194
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 $8,039 $10,210 $11,277 $12,614 $14,444 $16,274 $17,118 $18,677 $20,508 $21,758 $23,588 $25,128
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 $8,039 $10,210 $11,277 $12,614 $14,444 $16,274 $17,118 $18,677 $20,508 $21,758 $23,588 $25,128
Long-term Liabilities $150,000 $148,834 $147,668 $146,502 $145,336 $144,170 $143,004 $141,838 $140,672 $139,506 $138,340 $137,174 $136,008
Total Liabilities $150,000 $156,873 $157,878 $157,779 $157,950 $158,614 $159,278 $158,956 $159,349 $160,014 $160,098 $160,762 $161,136
Paid-in Capital $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000
Retained Earnings ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000)
Earnings $0 ($8,269) ($13,783) ($17,400) ($19,401) ($19,295) ($17,082) ($13,742) ($8,016) ($183) $8,358 $19,005 $31,058
Total Capital ($15,000) ($23,269) ($28,783) ($32,400) ($34,401) ($34,295) ($32,082) ($28,742) ($23,016) ($15,183) ($6,642) $4,005 $16,058
Total Liabilities and Capital $135,000 $133,605 $129,095 $125,378 $123,549 $124,319 $127,196 $130,214 $136,334 $144,831 $153,455 $164,766 $177,194
Net Worth ($15,000) ($23,269) ($28,783) ($32,400) ($34,401) ($34,295) ($32,082) ($28,742) ($23,016) ($15,183) ($6,642) $4,005 $16,058