City Dojo
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 |
By 
