The Creature Nannie

Start your own business plan »

Dog Kennel 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
Dog owners 0% $0 $230 $450 $700 $1,200 $1,350 $1,400 $1,600 $1,550 $1,400 $1,400 $1,600
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $230 $450 $700 $1,200 $1,350 $1,400 $1,600 $1,550 $1,400 $1,400 $1,600
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
Dog owners $0 $5 $9 $14 $24 $27 $28 $32 $31 $28 $28 $32
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $5 $9 $14 $24 $27 $28 $32 $31 $28 $28 $32
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
Payroll 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
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 1 1 1 1 1 1 1 1 1 1 1 1
Total Payroll $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 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 $0 $230 $450 $700 $1,200 $1,350 $1,400 $1,600 $1,550 $1,400 $1,400 $1,600
Direct Cost of Sales $0 $5 $9 $14 $24 $27 $28 $32 $31 $28 $28 $32
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $5 $9 $14 $24 $27 $28 $32 $31 $28 $28 $32
Gross Margin $0 $225 $441 $686 $1,176 $1,323 $1,372 $1,568 $1,519 $1,372 $1,372 $1,568
Gross Margin % 0.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00% 98.00%
Expenses
Payroll $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Sales and Marketing and Other Expenses $100 $100 $100 $100 $100 $100 $100 $100 $50 $50 $50 $50
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 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Insurance/ license/ bonding $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Rent $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,200 $1,200 $1,200 $1,200
Profit Before Interest and Taxes ($1,250) ($1,025) ($809) ($564) ($74) $73 $122 $318 $319 $172 $172 $368
EBITDA ($1,250) ($1,025) ($809) ($564) ($74) $73 $122 $318 $319 $172 $172 $368
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($1,250) ($1,025) ($809) ($564) ($74) $73 $122 $318 $319 $172 $172 $368
Net Profit/Sales 0.00% -445.48% -179.78% -80.57% -6.17% 5.41% 8.71% 19.88% 20.58% 12.29% 12.29% 23.00%
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 $0 $230 $450 $700 $1,200 $1,350 $1,400 $1,600 $1,550 $1,400 $1,400 $1,600
Subtotal Cash from Operations $0 $230 $450 $700 $1,200 $1,350 $1,400 $1,600 $1,550 $1,400 $1,400 $1,600
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 $0 $230 $450 $700 $1,200 $1,350 $1,400 $1,600 $1,550 $1,400 $1,400 $1,600
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 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Bill Payments $8 $250 $255 $259 $264 $274 $277 $278 $280 $231 $228 $228
Subtotal Spent on Operations $1,008 $1,250 $1,255 $1,259 $1,264 $1,274 $1,277 $1,278 $1,280 $1,231 $1,228 $1,228
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 $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 $1,008 $1,250 $1,255 $1,259 $1,264 $1,274 $1,277 $1,278 $1,280 $1,231 $1,228 $1,228
Net Cash Flow ($1,008) ($1,020) ($805) ($559) ($64) $76 $123 $322 $270 $169 $172 $372
Cash Balance $3,192 $2,172 $1,367 $808 $743 $819 $942 $1,264 $1,534 $1,703 $1,875 $2,247
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 $4,200 $3,192 $2,172 $1,367 $808 $743 $819 $942 $1,264 $1,534 $1,703 $1,875 $2,247
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $4,200 $3,192 $2,172 $1,367 $808 $743 $819 $942 $1,264 $1,534 $1,703 $1,875 $2,247
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $4,200 $3,192 $2,172 $1,367 $808 $743 $819 $942 $1,264 $1,534 $1,703 $1,875 $2,247
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 $242 $246 $250 $255 $265 $268 $269 $273 $223 $220 $220 $224
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 $242 $246 $250 $255 $265 $268 $269 $273 $223 $220 $220 $224
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $242 $246 $250 $255 $265 $268 $269 $273 $223 $220 $220 $224
Paid-in Capital $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Retained Earnings ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800)
Earnings $0 ($1,250) ($2,275) ($3,084) ($3,648) ($3,722) ($3,649) ($3,527) ($3,209) ($2,890) ($2,718) ($2,546) ($2,178)
Total Capital $4,200 $2,950 $1,925 $1,116 $552 $478 $551 $673 $991 $1,310 $1,482 $1,654 $2,022
Total Liabilities and Capital $4,200 $3,192 $2,172 $1,367 $808 $743 $819 $942 $1,264 $1,534 $1,703 $1,875 $2,247
Net Worth $4,200 $2,950 $1,925 $1,116 $552 $478 $551 $673 $991 $1,310 $1,482 $1,654 $2,022