Advanced Chiropractic Clinic

Start your own business plan »

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