City Dojo

Start your own business plan »

Karate Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Membership Fees 0% $5,000 $5,000 $5,417 $5,833 $6,250 $6,667 $6,667 $6,667 $7,083 $7,500 $7,917 $7,917
Weekend Classes (Special) 0% $0 $0 $0 $0 $0 $0 $0 $0 $200 $200 $200 $200
Seminars/Private Lessions 0% $50 $35 $50 $750 $50 $50 $800 $50 $50 $800 $50 $50
Belt Testing Fees 0% $675 $0 $0 $788 $0 $0 $900 $0 $0 $1,069 $0 $0
Total Sales $5,725 $5,035 $5,467 $7,371 $6,300 $6,717 $8,367 $6,717 $7,333 $9,569 $8,167 $8,167
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Membership Fees $1,300 $1,300 $1,383 $1,467 $1,550 $1,633 $1,300 $1,300 $1,363 $1,425 $1,488 $1,488
Weekend Classes (Special) $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Seminars/Private Lessions $10 $10 $10 $50 $10 $10 $50 $10 $10 $50 $10 $10
Belt Testing Fees $110 $0 $0 $110 $0 $0 $120 $0 $0 $150 $0 $0
Subtotal Direct Cost of Sales $1,470 $1,360 $1,443 $1,677 $1,610 $1,693 $1,520 $1,360 $1,423 $1,675 $1,548 $1,548
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Owner (Shihan) 0% $500 $500 $500 $500 $500 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Sales Associate/Receptionist 0% $0 $0 $0 $0 $0 $0 $0 $500 $500 $500 $500 $500
Total People 1 1 1 1 1 1 1 2 2 2 2 2
Total Payroll $500 $500 $500 $500 $500 $1,000 $1,000 $1,500 $1,500 $1,500 $1,500 $1,500
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00%
Long-term Interest Rate 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $5,725 $5,035 $5,467 $7,371 $6,300 $6,717 $8,367 $6,717 $7,333 $9,569 $8,167 $8,167
Direct Cost of Sales $1,470 $1,360 $1,443 $1,677 $1,610 $1,693 $1,520 $1,360 $1,423 $1,675 $1,548 $1,548
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,470 $1,360 $1,443 $1,677 $1,610 $1,693 $1,520 $1,360 $1,423 $1,675 $1,548 $1,548
Gross Margin $4,255 $3,675 $4,024 $5,694 $4,690 $5,024 $6,847 $5,357 $5,910 $7,894 $6,619 $6,619
Gross Margin % 74.32% 72.99% 73.61% 77.25% 74.44% 74.80% 81.83% 79.75% 80.59% 82.50% 81.05% 81.05%
Expenses
Payroll $500 $500 $500 $500 $500 $1,000 $1,000 $1,500 $1,500 $1,500 $1,500 $1,500
Sales and Marketing and Other Expenses $1,747 $987 $1,387 $1,187 $1,087 $1,187 $4,087 $2,187 $1,187 $1,587 $1,387 $1,387
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment . $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Utilities $610 $510 $320 $320 $320 $380 $400 $480 $300 $300 $404 $500
Telephone $303 $303 $299 $300 $300 $300 $300 $300 $300 $300 $300 $300
Insurance $310 $310 $310 $310 $310 $310 $400 $400 $400 $400 $400 $400
Rent $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Payroll Taxes 15% $75 $75 $75 $75 $75 $150 $150 $225 $225 $225 $225 $225
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $4,695 $3,835 $4,041 $3,842 $3,742 $4,477 $7,487 $6,242 $5,062 $5,462 $5,366 $5,462
Profit Before Interest and Taxes ($440) ($160) ($17) $1,852 $948 $547 ($640) ($885) $848 $2,432 $1,253 $1,157
EBITDA ($440) ($160) ($17) $1,852 $948 $547 ($640) ($885) $848 $2,432 $1,253 $1,157
Interest Expense $260 $257 $254 $252 $249 $246 $244 $391 $388 $385 $381 $377
Taxes Incurred ($210) ($104) ($68) $400 $175 $75 ($221) ($319) $115 $512 $218 $195
Net Profit ($490) ($313) ($204) $1,200 $524 $226 ($663) ($957) $345 $1,535 $654 $585
Net Profit/Sales -8.56% -6.21% -3.72% 16.28% 8.32% 3.36% -7.92% -14.25% 4.70% 16.04% 8.01% 7.17%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $5,725 $5,035 $5,467 $7,371 $6,300 $6,717 $8,367 $6,717 $7,333 $9,569 $8,167 $8,167
Subtotal Cash from Operations $5,725 $5,035 $5,467 $7,371 $6,300 $6,717 $8,367 $6,717 $7,333 $9,569 $8,167 $8,167
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 $20,000 $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,725 $5,035 $5,467 $7,371 $6,300 $6,717 $8,367 $26,717 $7,333 $9,569 $8,167 $8,167
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $500 $500 $500 $500 $500 $1,000 $1,000 $1,500 $1,500 $1,500 $1,500 $1,500
Bill Payments $4,690 $5,686 $4,859 $5,187 $5,658 $5,283 $5,576 $7,968 $6,151 $5,523 $6,517 $6,015
Subtotal Spent on Operations $5,190 $6,186 $5,359 $5,687 $6,158 $6,283 $6,576 $9,468 $7,651 $7,023 $8,017 $7,515
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 $271 $271 $271 $271 $271 $271 $271 $271 $271 $271 $271 $271
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 $230 $230
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 $5,000 $5,000 $5,000 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $5,461 $6,457 $5,630 $5,958 $6,429 $6,554 $6,847 $14,739 $12,922 $12,294 $8,518 $8,016
Net Cash Flow $264 ($1,422) ($163) $1,413 ($129) $163 $1,520 $11,978 ($5,589) ($2,725) ($351) $151
Cash Balance $1,764 $342 $179 $1,592 $1,463 $1,626 $3,146 $15,124 $9,535 $6,811 $6,460 $6,611
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $1,500 $1,764 $342 $179 $1,592 $1,463 $1,626 $3,146 $15,124 $9,535 $6,811 $6,460 $6,611
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $1,500 $1,764 $342 $179 $1,592 $1,463 $1,626 $3,146 $15,124 $9,535 $6,811 $6,460 $6,611
Long-term Assets
Long-term Assets $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $45,000 $50,000 $55,000 $55,000 $55,000
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $45,000 $50,000 $55,000 $55,000 $55,000
Total Assets $41,500 $41,764 $40,342 $40,179 $41,592 $41,463 $41,626 $43,146 $60,124 $59,535 $61,811 $61,460 $61,611
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $4,500 $5,524 $4,686 $4,998 $5,482 $5,100 $5,308 $7,762 $5,968 $5,305 $6,316 $5,813 $5,879
Current Borrowing $15,000 $14,729 $14,458 $14,187 $13,916 $13,645 $13,374 $13,103 $12,832 $12,561 $12,290 $12,019 $11,748
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $19,500 $20,253 $19,144 $19,185 $19,398 $18,745 $18,682 $20,865 $18,800 $17,866 $18,606 $17,832 $17,627
Long-term Liabilities $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $35,000 $35,000 $35,000 $34,770 $34,540
Total Liabilities $34,500 $35,253 $34,144 $34,185 $34,398 $33,745 $33,682 $35,865 $53,800 $52,866 $53,606 $52,602 $52,167
Paid-in Capital $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retained Earnings $3,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000
Earnings $4,000 ($490) ($803) ($1,006) $194 $718 $944 $281 ($676) ($331) $1,204 $1,858 $2,444
Total Capital $7,000 $6,510 $6,197 $5,994 $7,194 $7,718 $7,944 $7,281 $6,324 $6,669 $8,204 $8,858 $9,444
Total Liabilities and Capital $41,500 $41,764 $40,342 $40,179 $41,592 $41,463 $41,626 $43,146 $60,124 $59,535 $61,811 $61,460 $61,611
Net Worth $7,000 $6,510 $6,197 $5,994 $7,194 $7,718 $7,944 $7,281 $6,324 $6,669 $8,204 $8,858 $9,444