The Sorcerer's Accountant
Appendix
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Unit Sales | |||||||||||||
| Tax Preparations | 8 | 10 | 11 | 16 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | |
| Cost Accounting Analysis | 5 | 4 | 2 | 2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| QuickBooks Services | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Bookkeeping Hours | 0 | 50 | 70 | 90 | 100 | 120 | 140 | 160 | 180 | 200 | 220 | 240 | |
| Total Unit Sales | 17 | 67 | 88 | 113 | 121 | 141 | 161 | 181 | 201 | 221 | 241 | 261 | |
| Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Tax Preparations | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | |
| Cost Accounting Analysis | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | |
| QuickBooks Services | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | |
| Bookkeeping Hours | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | |
| Sales | |||||||||||||
| Tax Preparations | $6,000 | $7,200 | $8,400 | $12,000 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | |
| Cost Accounting Analysis | $4,800 | $3,600 | $2,400 | $1,500 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | |
| QuickBooks Services | $1,200 | $1,200 | $1,200 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Bookkeeping Hours | $0 | $1,500 | $2,100 | $2,700 | $3,000 | $3,600 | $4,200 | $4,800 | $5,400 | $6,000 | $6,600 | $7,200 | |
| Total Sales | $12,000 | $13,500 | $14,100 | $17,700 | $18,000 | $18,600 | $19,200 | $19,800 | $20,400 | $21,000 | $21,600 | $22,200 | |
| Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Tax Preparations | 5.00% | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 | $37.50 |
| Cost Accounting Analysis | 3.00% | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 | $30.00 |
| QuickBooks Services | 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 |
| Bookkeeping Hours | 50.00% | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 |
| Direct Cost of Sales | |||||||||||||
| Tax Preparations | $300 | $360 | $420 | $600 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | |
| Cost Accounting Analysis | $144 | $108 | $72 | $45 | $180 | $180 | $180 | $180 | $180 | $180 | $180 | $180 | |
| QuickBooks Services | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Bookkeeping Hours | $0 | $750 | $1,050 | $1,350 | $1,500 | $1,800 | $2,100 | $2,400 | $2,700 | $3,000 | $3,300 | $3,600 | |
| Subtotal Direct Cost of Sales | $444 | $1,218 | $1,542 | $1,995 | $2,055 | $2,355 | $2,655 | $2,955 | $3,255 | $3,555 | $3,855 | $4,155 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Bookkeeper training-period wages | $800 | $0 | $0 | $0 | $0 | $0 | $400 | $0 | $0 | $0 | $0 | $0 | |
| Max Greenwood | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
| Bookkeeper Manager | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Benefits | 10% | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | $8,500 | $7,700 | $7,700 | $7,700 | $7,700 | $7,700 | $8,100 | $7,700 | $7,700 | $7,700 | $7,700 | $7,700 | |
| Pro Forma Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | $12,000 | $13,500 | $14,100 | $17,700 | $18,000 | $18,600 | $19,200 | $19,800 | $20,400 | $21,000 | $21,600 | $22,200 | |
| Direct Cost of Sales | $444 | $1,218 | $1,542 | $1,995 | $2,055 | $2,355 | $2,655 | $2,955 | $3,255 | $3,555 | $3,855 | $4,155 | |
| Other Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $444 | $1,218 | $1,542 | $1,995 | $2,055 | $2,355 | $2,655 | $2,955 | $3,255 | $3,555 | $3,855 | $4,155 | |
| Gross Margin | $11,556 | $12,282 | $12,558 | $15,705 | $15,945 | $16,245 | $16,545 | $16,845 | $17,145 | $17,445 | $17,745 | $18,045 | |
| Gross Margin % | 96.30% | 90.98% | 89.06% | 88.73% | 88.58% | 87.34% | 86.17% | 85.08% | 84.04% | 83.07% | 82.15% | 81.28% | |
| Expenses | |||||||||||||
| Payroll | $8,500 | $7,700 | $7,700 | $7,700 | $7,700 | $7,700 | $8,100 | $7,700 | $7,700 | $7,700 | $7,700 | $7,700 | |
| Marketing/Promotion | $10,000 | $3,000 | $3,000 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| 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 | |
| Utilities | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Insurance | $5,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Payroll Taxes | 15% | $1,275 | $1,155 | $1,155 | $1,155 | $1,155 | $1,155 | $1,215 | $1,155 | $1,155 | $1,155 | $1,155 | $1,155 |
| Software and Computer Expenses | $2,500 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Total Operating Expenses | $28,975 | $13,655 | $13,655 | $13,155 | $13,155 | $13,155 | $13,615 | $13,155 | $13,155 | $13,155 | $13,155 | $13,155 | |
| Profit Before Interest and Taxes | ($17,419) | ($1,373) | ($1,097) | $2,550 | $2,790 | $3,090 | $2,930 | $3,690 | $3,990 | $4,290 | $4,590 | $4,890 | |
| EBITDA | ($17,419) | ($1,373) | ($1,097) | $2,550 | $2,790 | $3,090 | $2,930 | $3,690 | $3,990 | $4,290 | $4,590 | $4,890 | |
| Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Taxes Incurred | ($5,226) | ($412) | ($329) | $765 | $837 | $927 | $879 | $1,107 | $1,197 | $1,287 | $1,377 | $1,467 | |
| Net Profit | ($12,193) | ($961) | ($768) | $1,785 | $1,953 | $2,163 | $2,051 | $2,583 | $2,793 | $3,003 | $3,213 | $3,423 | |
| Net Profit/Sales | -101.61% | -7.12% | -5.45% | 10.08% | 10.85% | 11.63% | 10.68% | 13.05% | 13.69% | 14.30% | 14.88% | 15.42% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | $6,000 | $6,750 | $7,050 | $8,850 | $9,000 | $9,300 | $9,600 | $9,900 | $10,200 | $10,500 | $10,800 | $11,100 | |
| Cash from Receivables | $7,492 | $6,025 | $6,760 | $7,110 | $8,855 | $9,010 | $9,310 | $9,610 | $9,910 | $10,210 | $10,510 | $10,810 | |
| Subtotal Cash from Operations | $13,492 | $12,775 | $13,810 | $15,960 | $17,855 | $18,310 | $18,910 | $19,510 | $20,110 | $20,710 | $21,310 | $21,910 | |
| 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 | $13,492 | $12,775 | $13,810 | $15,960 | $17,855 | $18,310 | $18,910 | $19,510 | $20,110 | $20,710 | $21,310 | $21,910 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | $8,500 | $7,700 | $7,700 | $7,700 | $7,700 | $7,700 | $8,100 | $7,700 | $7,700 | $7,700 | $7,700 | $7,700 | |
| Bill Payments | $7,419 | $15,396 | $6,775 | $7,203 | $8,219 | $8,360 | $8,747 | $9,065 | $9,530 | $9,920 | $10,310 | $10,700 | |
| Subtotal Spent on Operations | $15,919 | $23,096 | $14,475 | $14,903 | $15,919 | $16,060 | $16,847 | $16,765 | $17,230 | $17,620 | $18,010 | $18,400 | |
| 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 | $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 | $15,919 | $23,096 | $14,475 | $14,903 | $15,919 | $16,060 | $16,847 | $16,765 | $17,230 | $17,620 | $18,010 | $18,400 | |
| Net Cash Flow | ($2,427) | ($10,321) | ($665) | $1,057 | $1,936 | $2,250 | $2,063 | $2,745 | $2,880 | $3,090 | $3,300 | $3,510 | |
| Cash Balance | $17,573 | $7,252 | $6,588 | $7,645 | $9,580 | $11,830 | $13,893 | $16,638 | $19,518 | $22,608 | $25,908 | $29,418 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | $20,000 | $17,573 | $7,252 | $6,588 | $7,645 | $9,580 | $11,830 | $13,893 | $16,638 | $19,518 | $22,608 | $25,908 | $29,418 |
| Accounts Receivable | $7,292 | $5,800 | $6,525 | $6,815 | $8,555 | $8,700 | $8,990 | $9,280 | $9,570 | $9,860 | $10,150 | $10,440 | $10,730 |
| Other Current Assets | $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 |
| Total Current Assets | $32,292 | $28,373 | $18,777 | $18,403 | $21,200 | $23,280 | $25,820 | $28,173 | $31,208 | $34,378 | $37,758 | $41,348 | $45,148 |
| 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 | $32,292 | $28,373 | $18,777 | $18,403 | $21,200 | $23,280 | $25,820 | $28,173 | $31,208 | $34,378 | $37,758 | $41,348 | $45,148 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | $6,896 | $15,170 | $6,536 | $6,929 | $7,941 | $8,069 | $8,446 | $8,747 | $9,200 | $9,577 | $9,954 | $10,331 | $10,708 |
| 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 | $6,896 | $15,170 | $6,536 | $6,929 | $7,941 | $8,069 | $8,446 | $8,747 | $9,200 | $9,577 | $9,954 | $10,331 | $10,708 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $6,896 | $15,170 | $6,536 | $6,929 | $7,941 | $8,069 | $8,446 | $8,747 | $9,200 | $9,577 | $9,954 | $10,331 | $10,708 |
| Paid-in Capital | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
| Retained Earnings | ($83,554) | $15,396 | $15,396 | $15,396 | $15,396 | $15,396 | $15,396 | $15,396 | $15,396 | $15,396 | $15,396 | $15,396 | $15,396 |
| Earnings | $98,950 | ($12,193) | ($13,154) | ($13,922) | ($12,137) | ($10,184) | ($8,021) | ($5,970) | ($3,387) | ($594) | $2,409 | $5,622 | $9,045 |
| Total Capital | $25,396 | $13,203 | $12,241 | $11,474 | $13,259 | $15,212 | $17,375 | $19,426 | $22,009 | $24,802 | $27,805 | $31,018 | $34,441 |
| Total Liabilities and Capital | $32,292 | $28,373 | $18,777 | $18,403 | $21,200 | $23,280 | $25,820 | $28,173 | $31,208 | $34,378 | $37,758 | $41,348 | $45,148 |
| Net Worth | $25,396 | $13,203 | $12,241 | $11,474 | $13,259 | $15,212 | $17,375 | $19,426 | $22,009 | $24,802 | $27,805 | $31,018 | $34,441 |
By 
