Our biggest savings of the year
Betcher Chiropractic
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 | ||
Sales | |||||||||||||
Routine treatment | 0% | $0 | $0 | $1,100 | $1,325 | $1,656 | $1,998 | $2,254 | $2,626 | $2,998 | $3,232 | $3,698 | $4,545 |
Initial examination and diagnosis | 0% | $0 | $0 | $484 | $583 | $729 | $879 | $992 | $1,155 | $1,319 | $1,422 | $1,627 | $2,000 |
Total Sales | $0 | $0 | $1,584 | $1,908 | $2,385 | $2,877 | $3,246 | $3,781 | $4,317 | $4,654 | $5,325 | $6,545 | |
Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Routine treatment | $0 | $0 | $22 | $27 | $33 | $40 | $45 | $53 | $60 | $65 | $74 | $91 | |
Initial examination and diagnosis | $0 | $0 | $22 | $27 | $33 | $40 | $45 | $53 | $60 | $65 | $74 | $91 | |
Subtotal Direct Cost of Sales | $0 | $0 | $44 | $53 | $66 | $80 | $90 | $105 | $120 | $129 | $148 | $182 |
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. Betcher | 0% | $0 | $2,000 | $2,000 | $2,000 | $2,300 | $2,300 | $2,400 | $2,500 | $2,500 | $2,700 | $2,800 | $3,000 |
Office Assistant | 0% | $0 | $0 | $0 | $0 | $800 | $800 | $900 | $900 | $1,000 | $1,200 | $1,200 | $1,200 |
Total People | 0 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
Total Payroll | $0 | $2,000 | $2,000 | $2,000 | $3,100 | $3,100 | $3,300 | $3,400 | $3,500 | $3,900 | $4,000 | $4,200 |
General Assumptions | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.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 | |||||||||||||
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 | $0 | $0 | $1,584 | $1,908 | $2,385 | $2,877 | $3,246 | $3,781 | $4,317 | $4,654 | $5,325 | $6,545 | |
Direct Cost of Sales | $0 | $0 | $44 | $53 | $66 | $80 | $90 | $105 | $120 | $129 | $148 | $182 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $44 | $53 | $66 | $80 | $90 | $105 | $120 | $129 | $148 | $182 | |
Gross Margin | $0 | $0 | $1,540 | $1,855 | $2,318 | $2,797 | $3,156 | $3,676 | $4,197 | $4,525 | $5,177 | $6,363 | |
Gross Margin % | 0.00% | 0.00% | 97.22% | 97.22% | 97.22% | 97.22% | 97.22% | 97.22% | 97.22% | 97.22% | 97.22% | 97.22% | |
Expenses | |||||||||||||
Payroll | $0 | $2,000 | $2,000 | $2,000 | $3,100 | $3,100 | $3,300 | $3,400 | $3,500 | $3,900 | $4,000 | $4,200 | |
Sales and Marketing and Other Expenses | $0 | $320 | $320 | $320 | $320 | $320 | $320 | $320 | $320 | $320 | $320 | $320 | |
Depreciation | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Utilities (all) | $0 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Insurance – malpractice | $0 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | |
Insurance – workers comp | $0 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | |
Insurance – liability | $0 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Rent | 15% | $0 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 |
Payroll Taxes | 15% | $0 | $300 | $300 | $300 | $465 | $465 | $495 | $510 | $525 | $585 | $600 | $630 |
Total Operating Expenses | $250 | $4,700 | $4,700 | $4,700 | $5,965 | $5,965 | $6,195 | $6,310 | $6,425 | $6,885 | $7,000 | $7,230 | |
Profit Before Interest and Taxes | ($250) | ($4,700) | ($3,160) | ($2,845) | ($3,647) | ($3,168) | ($3,039) | ($2,634) | ($2,228) | ($2,360) | ($1,823) | ($867) | |
EBITDA | $0 | ($4,450) | ($2,910) | ($2,595) | ($3,397) | ($2,918) | ($2,789) | ($2,384) | ($1,978) | ($2,110) | ($1,573) | ($617) | |
Interest Expense | $165 | $162 | $160 | $158 | $156 | $154 | $152 | $150 | $148 | $146 | $143 | $141 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($415) | ($4,862) | ($3,320) | ($3,003) | ($3,803) | ($3,322) | ($3,191) | ($2,783) | ($2,375) | ($2,506) | ($1,966) | ($1,008) | |
Net Profit/Sales | 0.00% | 0.00% | -209.62% | -157.40% | -159.47% | -115.46% | -98.32% | -73.61% | -55.02% | -53.84% | -36.92% | -15.41% |
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 | $0 | $0 | $396 | $477 | $596 | $719 | $811 | $945 | $1,079 | $1,164 | $1,331 | $1,636 | |
Cash from Receivables | $0 | $0 | $0 | $40 | $1,196 | $1,443 | $1,801 | $2,167 | $2,448 | $2,849 | $3,246 | $3,507 | |
Subtotal Cash from Operations | $0 | $0 | $396 | $517 | $1,792 | $2,162 | $2,612 | $3,112 | $3,527 | $4,013 | $4,578 | $5,144 | |
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 | $0 | $0 | $396 | $517 | $1,792 | $2,162 | $2,612 | $3,112 | $3,527 | $4,013 | $4,578 | $5,144 | |
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 | $0 | $2,000 | $2,000 | $2,000 | $3,100 | $3,100 | $3,300 | $3,400 | $3,500 | $3,900 | $4,000 | $4,200 | |
Bill Payments | $5 | $246 | $2,614 | $2,655 | $2,667 | $2,838 | $2,850 | $2,888 | $2,916 | $2,945 | $3,011 | $3,043 | |
Subtotal Spent on Operations | $5 | $2,246 | $4,614 | $4,655 | $5,767 | $5,938 | $6,150 | $6,288 | $6,416 | $6,845 | $7,011 | $7,243 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $253 | $253 | $253 | $253 | $253 | $253 | $253 | $253 | $253 | $253 | $253 | $253 | |
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 | $258 | $2,499 | $4,867 | $4,908 | $6,020 | $6,191 | $6,403 | $6,541 | $6,669 | $7,098 | $7,264 | $7,496 | |
Net Cash Flow | ($258) | ($2,499) | ($4,471) | ($4,391) | ($4,228) | ($4,029) | ($3,791) | ($3,429) | ($3,142) | ($3,085) | ($2,686) | ($2,353) | |
Cash Balance | $40,742 | $38,242 | $33,772 | $29,381 | $25,153 | $21,124 | $17,333 | $13,905 | $10,763 | $7,678 | $4,992 | $2,639 |
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 | $41,000 | $40,742 | $38,242 | $33,772 | $29,381 | $25,153 | $21,124 | $17,333 | $13,905 | $10,763 | $7,678 | $4,992 | $2,639 |
Accounts Receivable | $0 | $0 | $0 | $1,188 | $2,579 | $3,172 | $3,887 | $4,520 | $5,189 | $5,979 | $6,620 | $7,368 | $8,769 |
Other Current Assets | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Total Current Assets | $43,500 | $43,242 | $40,742 | $37,460 | $34,460 | $30,824 | $27,511 | $24,353 | $21,594 | $19,242 | $16,798 | $14,860 | $13,908 |
Long-term Assets | |||||||||||||
Long-term Assets | $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 |
Accumulated Depreciation | $0 | $250 | $500 | $750 | $1,000 | $1,250 | $1,500 | $1,750 | $2,000 | $2,250 | $2,500 | $2,750 | $3,000 |
Total Long-term Assets | $15,000 | $14,750 | $14,500 | $14,250 | $14,000 | $13,750 | $13,500 | $13,250 | $13,000 | $12,750 | $12,500 | $12,250 | $12,000 |
Total Assets | $58,500 | $57,992 | $55,242 | $51,710 | $48,460 | $44,574 | $41,011 | $37,603 | $34,594 | $31,992 | $29,298 | $27,110 | $25,908 |
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 | $159 | $2,525 | $2,566 | $2,573 | $2,743 | $2,754 | $2,791 | $2,818 | $2,845 | $2,910 | $2,940 | $3,000 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $0 | $159 | $2,525 | $2,566 | $2,573 | $2,743 | $2,754 | $2,791 | $2,818 | $2,845 | $2,910 | $2,940 | $3,000 |
Long-term Liabilities | $20,000 | $19,747 | $19,494 | $19,241 | $18,988 | $18,735 | $18,482 | $18,229 | $17,976 | $17,723 | $17,470 | $17,217 | $16,964 |
Total Liabilities | $20,000 | $19,906 | $22,019 | $21,807 | $21,561 | $21,478 | $21,236 | $21,020 | $20,794 | $20,568 | $20,380 | $20,157 | $19,964 |
Paid-in Capital | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 |
Retained Earnings | ($21,500) | ($21,500) | ($21,500) | ($21,500) | ($21,500) | ($21,500) | ($21,500) | ($21,500) | ($21,500) | ($21,500) | ($21,500) | ($21,500) | ($21,500) |
Earnings | $0 | ($415) | ($5,277) | ($8,597) | ($11,601) | ($15,403) | ($18,725) | ($21,916) | ($24,700) | ($27,075) | ($29,581) | ($31,547) | ($32,556) |
Total Capital | $38,500 | $38,085 | $33,223 | $29,903 | $26,899 | $23,097 | $19,775 | $16,584 | $13,800 | $11,425 | $8,919 | $6,953 | $5,944 |
Total Liabilities and Capital | $58,500 | $57,992 | $55,242 | $51,710 | $48,460 | $44,574 | $41,011 | $37,603 | $34,594 | $31,992 | $29,298 | $27,110 | $25,908 |
Net Worth | $38,500 | $38,085 | $33,223 | $29,903 | $26,899 | $23,097 | $19,775 | $16,584 | $13,800 | $11,425 | $8,919 | $6,953 | $5,944 |