Advanced Chiropractic Clinic
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 | ||
| Unit Sales | |||||||||||||
| Average Visits Per Month | 0% | 50 | 60 | 72 | 86 | 104 | 124 | 149 | 179 | 215 | 258 | 310 | 372 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 50 | 60 | 72 | 86 | 104 | 124 | 149 | 179 | 215 | 258 | 310 | 372 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Average Visits Per Month | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | |
| Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Sales | |||||||||||||
| Average Visits Per Month | $2,500 | $3,000 | $3,600 | $4,300 | $5,200 | $6,200 | $7,450 | $8,950 | $10,750 | $12,900 | $15,500 | $18,600 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Sales | $2,500 | $3,000 | $3,600 | $4,300 | $5,200 | $6,200 | $7,450 | $8,950 | $10,750 | $12,900 | $15,500 | $18,600 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Average Visits Per Month | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Other | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Direct Cost of Sales | |||||||||||||
| Average Visits Per Month | $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 | |
| Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| 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 | ||
| Dr. Azzato | 0% | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
| Receptionist/Clinician’s Assistant | 0% | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
| 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 | $2,500 | $3,000 | $3,600 | $4,300 | $5,200 | $6,200 | $7,450 | $8,950 | $10,750 | $12,900 | $15,500 | $18,600 | |
| Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Gross Margin | $2,500 | $3,000 | $3,600 | $4,300 | $5,200 | $6,200 | $7,450 | $8,950 | $10,750 | $12,900 | $15,500 | $18,600 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
| Sales and Marketing and Other Expenses | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
| Utilities & Phone | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Insurance | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
| Payroll Taxes | 15% | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 |
| Other (misc) | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | |
| Total Operating Expenses | $6,775 | $6,775 | $6,775 | $6,775 | $6,775 | $6,775 | $6,775 | $6,775 | $6,775 | $6,775 | $6,775 | $6,775 | |
| Profit Before Interest and Taxes | ($4,275) | ($3,775) | ($3,175) | ($2,475) | ($1,575) | ($575) | $675 | $2,175 | $3,975 | $6,125 | $8,725 | $11,825 | |
| EBITDA | ($4,275) | ($3,775) | ($3,175) | ($2,475) | ($1,575) | ($575) | $675 | $2,175 | $3,975 | $6,125 | $8,725 | $11,825 | |
| Interest Expense | $245 | $240 | $235 | $229 | $224 | $219 | $214 | $209 | $204 | $186 | $181 | $176 | |
| Taxes Incurred | ($1,356) | ($1,204) | ($1,023) | ($811) | ($540) | ($238) | $138 | $590 | $1,131 | $1,782 | $2,563 | $3,495 | |
| Net Profit | ($3,164) | ($2,810) | ($2,387) | ($1,893) | ($1,259) | ($556) | $323 | $1,376 | $2,640 | $4,157 | $5,981 | $8,155 | |
| Net Profit/Sales | -126.56% | -93.68% | -66.30% | -44.02% | -24.22% | -8.96% | 4.33% | 15.38% | 24.56% | 32.23% | 38.59% | 43.84% | |
| 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 | $2,500 | $3,000 | $3,600 | $4,300 | $5,200 | $6,200 | $7,450 | $8,950 | $10,750 | $12,900 | $15,500 | $18,600 | |
| Subtotal Cash from Operations | $2,500 | $3,000 | $3,600 | $4,300 | $5,200 | $6,200 | $7,450 | $8,950 | $10,750 | $12,900 | $15,500 | $18,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 | $2,500 | $3,000 | $3,600 | $4,300 | $5,200 | $6,200 | $7,450 | $8,950 | $10,750 | $12,900 | $15,500 | $18,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 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
| Bill Payments | $22 | $669 | $816 | $994 | $1,202 | $1,469 | $1,768 | $2,142 | $2,591 | $3,131 | $3,768 | $4,550 | |
| Subtotal Spent on Operations | $5,022 | $5,669 | $5,816 | $5,994 | $6,202 | $6,469 | $6,768 | $7,142 | $7,591 | $8,131 | $8,768 | $9,550 | |
| 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 | $620 | $620 | $620 | $620 | $620 | $620 | $620 | $620 | $620 | $2,120 | $620 | $620 | |
| 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 | $5,642 | $6,289 | $6,436 | $6,614 | $6,822 | $7,089 | $7,388 | $7,762 | $8,211 | $10,251 | $9,388 | $10,170 | |
| Net Cash Flow | ($3,142) | ($3,289) | ($2,836) | ($2,314) | ($1,622) | ($889) | $62 | $1,188 | $2,539 | $2,649 | $6,112 | $8,430 | |
| Cash Balance | $11,858 | $8,569 | $5,733 | $3,419 | $1,798 | $908 | $970 | $2,158 | $4,697 | $7,345 | $13,457 | $21,887 | |
| 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 | $15,000 | $11,858 | $8,569 | $5,733 | $3,419 | $1,798 | $908 | $970 | $2,158 | $4,697 | $7,345 | $13,457 | $21,887 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $15,000 | $11,858 | $8,569 | $5,733 | $3,419 | $1,798 | $908 | $970 | $2,158 | $4,697 | $7,345 | $13,457 | $21,887 |
| 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 | $15,000 | $11,858 | $8,569 | $5,733 | $3,419 | $1,798 | $908 | $970 | $2,158 | $4,697 | $7,345 | $13,457 | $21,887 |
| 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 | $642 | $783 | $954 | $1,153 | $1,411 | $1,697 | $2,056 | $2,488 | $3,006 | $3,618 | $4,368 | $5,264 |
| Current Borrowing | $30,000 | $29,380 | $28,760 | $28,140 | $27,520 | $26,900 | $26,280 | $25,660 | $25,040 | $24,420 | $22,300 | $21,680 | $21,060 |
| Other Current Liabilities | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 |
| Subtotal Current Liabilities | $45,000 | $45,022 | $44,543 | $44,094 | $43,673 | $43,311 | $42,977 | $42,716 | $42,528 | $42,426 | $40,918 | $41,048 | $41,324 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $45,000 | $45,022 | $44,543 | $44,094 | $43,673 | $43,311 | $42,977 | $42,716 | $42,528 | $42,426 | $40,918 | $41,048 | $41,324 |
| 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 | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) | ($35,000) |
| Earnings | $0 | ($3,164) | ($5,974) | ($8,361) | ($10,254) | ($11,513) | ($12,069) | ($11,746) | ($10,370) | ($7,730) | ($3,572) | $2,409 | $10,563 |
| Total Capital | ($30,000) | ($33,164) | ($35,974) | ($38,361) | ($40,254) | ($41,513) | ($42,069) | ($41,746) | ($40,370) | ($37,730) | ($33,572) | ($27,591) | ($19,437) |
| Total Liabilities and Capital | $15,000 | $11,858 | $8,569 | $5,733 | $3,419 | $1,798 | $908 | $970 | $2,158 | $4,697 | $7,345 | $13,457 | $21,887 |
| Net Worth | ($30,000) | ($33,164) | ($35,974) | ($38,361) | ($40,254) | ($41,513) | ($42,069) | ($41,746) | ($40,370) | ($37,730) | ($33,572) | ($27,591) | ($19,437) |
By 
