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) |