The Tooth Fairy
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) |