The Tooth Fairy

Start your own business plan »

Dental Office 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
Sales
General dentistry 0% $0 $3,500 $3,800 $4,454 $5,142 $5,334 $5,565 $5,645 $6,001 $6,224 $6,343 $6,543
Cosmetics 0% $0 $0 $0 $4,500 $5,232 $8,876 $9,876 $11,746 $14,545 $17,656 $21,345 $24,545
Total Sales $0 $3,500 $3,800 $8,954 $10,374 $14,210 $15,441 $17,391 $20,546 $23,880 $27,688 $31,088
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
General dentistry $0 $2,100 $2,280 $2,672 $3,085 $3,200 $3,339 $3,387 $3,601 $3,734 $3,806 $3,926
Cosmetics $0 $0 $0 $855 $994 $1,686 $1,876 $2,232 $2,764 $3,355 $4,056 $4,664
Subtotal Direct Cost of Sales $0 $2,100 $2,280 $3,527 $4,079 $4,887 $5,215 $5,619 $6,364 $7,089 $7,861 $8,589
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
Steve 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Hygienist 0% $0 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Assistant 0% $0 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Front desk person 0% $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total People 1 4 4 4 4 4 4 4 4 4 4 4
Total Payroll $4,000 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700
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% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 $3,500 $3,800 $8,954 $10,374 $14,210 $15,441 $17,391 $20,546 $23,880 $27,688 $31,088
Direct Cost of Sales $0 $2,100 $2,280 $3,527 $4,079 $4,887 $5,215 $5,619 $6,364 $7,089 $7,861 $8,589
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $2,100 $2,280 $3,527 $4,079 $4,887 $5,215 $5,619 $6,364 $7,089 $7,861 $8,589
Gross Margin $0 $1,400 $1,520 $5,427 $6,295 $9,323 $10,226 $11,772 $14,182 $16,791 $19,827 $22,499
Gross Margin % 0.00% 40.00% 40.00% 60.61% 60.68% 65.61% 66.22% 67.69% 69.02% 70.31% 71.61% 72.37%
Expenses
Payroll $4,000 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700
Sales and Marketing and Other Expenses $225 $225 $225 $225 $225 $225 $225 $225 $225 $225 $225 $225
Depreciation $863 $863 $863 $863 $863 $863 $863 $863 $863 $863 $863 $863
ADA dues $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Utilities $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Insurance- office and malpractice $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Rent $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Payroll Taxes 15% $600 $1,605 $1,605 $1,605 $1,605 $1,605 $1,605 $1,605 $1,605 $1,605 $1,605 $1,605
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $7,788 $15,493 $15,493 $15,493 $15,493 $15,493 $15,493 $15,493 $15,493 $15,493 $15,493 $15,493
Profit Before Interest and Taxes ($7,788) ($14,093) ($13,973) ($10,066) ($9,198) ($6,170) ($5,267) ($3,721) ($1,311) $1,298 $4,334 $7,006
EBITDA ($6,925) ($13,230) ($13,110) ($9,203) ($8,335) ($5,307) ($4,404) ($2,858) ($448) $2,161 $5,197 $7,869
Interest Expense $829 $825 $821 $817 $812 $808 $804 $800 $795 $791 $786 $782
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($8,617) ($14,918) ($14,794) ($10,883) ($10,011) ($6,978) ($6,071) ($4,520) ($2,106) $507 $3,547 $6,224
Net Profit/Sales 0.00% -426.23% -389.31% -121.54% -96.50% -49.11% -39.32% -25.99% -10.25% 2.12% 12.81% 20.02%
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 $3,500 $3,800 $8,954 $10,374 $14,210 $15,441 $17,391 $20,546 $23,880 $27,688 $31,088
Subtotal Cash from Operations $0 $3,500 $3,800 $8,954 $10,374 $14,210 $15,441 $17,391 $20,546 $23,880 $27,688 $31,088
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 $3,500 $3,800 $8,954 $10,374 $14,210 $15,441 $17,391 $20,546 $23,880 $27,688 $31,088
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 $4,000 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700 $10,700
Bill Payments $125 $3,858 $6,861 $7,072 $8,292 $8,849 $9,636 $9,963 $10,373 $11,113 $11,835 $12,602
Subtotal Spent on Operations $4,125 $14,558 $17,561 $17,772 $18,992 $19,549 $20,336 $20,663 $21,073 $21,813 $22,535 $23,302
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 $492 $496 $500 $505 $509 $513 $517 $522 $526 $530 $535 $539
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 $4,617 $15,054 $18,061 $18,277 $19,501 $20,062 $20,853 $21,184 $21,599 $22,344 $23,070 $23,841
Net Cash Flow ($4,617) ($11,554) ($14,261) ($9,323) ($9,127) ($5,852) ($5,412) ($3,793) ($1,053) $1,536 $4,618 $7,247
Cash Balance $63,483 $51,929 $37,667 $28,344 $19,217 $13,365 $7,953 $4,160 $3,107 $4,643 $9,261 $16,508
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 $68,100 $63,483 $51,929 $37,667 $28,344 $19,217 $13,365 $7,953 $4,160 $3,107 $4,643 $9,261 $16,508
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $68,100 $63,483 $51,929 $37,667 $28,344 $19,217 $13,365 $7,953 $4,160 $3,107 $4,643 $9,261 $16,508
Long-term Assets
Long-term Assets $51,800 $51,800 $51,800 $51,800 $51,800 $51,800 $51,800 $51,800 $51,800 $51,800 $51,800 $51,800 $51,800
Accumulated Depreciation $0 $863 $1,726 $2,589 $3,452 $4,315 $5,178 $6,041 $6,904 $7,767 $8,630 $9,493 $10,356
Total Long-term Assets $51,800 $50,937 $50,074 $49,211 $48,348 $47,485 $46,622 $45,759 $44,896 $44,033 $43,170 $42,307 $41,444
Total Assets $119,900 $114,420 $102,003 $86,878 $76,692 $66,702 $59,987 $53,712 $49,056 $47,140 $47,813 $51,568 $57,952
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 $3,629 $6,627 $6,797 $7,998 $8,528 $9,304 $9,618 $10,003 $10,720 $11,416 $12,158 $12,858
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 $3,629 $6,627 $6,797 $7,998 $8,528 $9,304 $9,618 $10,003 $10,720 $11,416 $12,158 $12,858
Long-term Liabilities $100,000 $99,508 $99,011 $98,511 $98,006 $97,497 $96,984 $96,467 $95,945 $95,419 $94,889 $94,354 $93,815
Total Liabilities $100,000 $103,137 $105,638 $105,307 $106,005 $106,025 $106,289 $106,085 $105,949 $106,139 $106,305 $106,512 $106,672
Paid-in Capital $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000 $51,000
Retained Earnings ($31,100) ($31,100) ($31,100) ($31,100) ($31,100) ($31,100) ($31,100) ($31,100) ($31,100) ($31,100) ($31,100) ($31,100) ($31,100)
Earnings $0 ($8,617) ($23,535) ($38,329) ($49,212) ($59,223) ($66,201) ($72,273) ($76,793) ($78,899) ($78,392) ($74,845) ($68,621)
Total Capital $19,900 $11,283 ($3,635) ($18,429) ($29,312) ($39,323) ($46,301) ($52,373) ($56,893) ($58,999) ($58,492) ($54,945) ($48,721)
Total Liabilities and Capital $119,900 $114,420 $102,003 $86,878 $76,692 $66,702 $59,987 $53,712 $49,056 $47,140 $47,813 $51,568 $57,952
Net Worth $19,900 $11,283 ($3,635) ($18,429) ($29,312) ($39,323) ($46,301) ($52,373) ($56,893) ($58,999) ($58,492) ($54,945) ($48,721)