Tablature Tattoo

Start your own business plan »

Tattoo Parlor 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
Shop-Minimum Tattoos 35 37 39 41 43 45 47 49 51 54 57 60
Basic Tattoos (~1 hour) 30 32 34 36 38 40 42 44 46 48 50 52
Full Sessions (2-6 hours) 25 26 27 28 29 30 32 34 36 38 40 42
Resale Items (Posters, T-shirts, etc.) 2 3 5 10 12 16 19 21 21 23 25 27
Total Unit Sales 92 98 105 115 122 131 140 148 154 163 172 181
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
Shop-Minimum Tattoos $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00
Basic Tattoos (~1 hour) $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
Full Sessions (2-6 hours) $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00
Resale Items (Posters, T-shirts, etc.) $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00
Sales
Shop-Minimum Tattoos $2,100 $2,220 $2,340 $2,460 $2,580 $2,700 $2,820 $2,940 $3,060 $3,240 $3,420 $3,600
Basic Tattoos (~1 hour) $3,000 $3,200 $3,400 $3,600 $3,800 $4,000 $4,200 $4,400 $4,600 $4,800 $5,000 $5,200
Full Sessions (2-6 hours) $7,500 $7,800 $8,100 $8,400 $8,700 $9,000 $9,600 $10,200 $10,800 $11,400 $12,000 $12,600
Resale Items (Posters, T-shirts, etc.) $40 $60 $100 $200 $244 $310 $381 $412 $427 $463 $503 $539
Total Sales $12,640 $13,280 $13,940 $14,660 $15,324 $16,010 $17,001 $17,952 $18,887 $19,903 $20,923 $21,939
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
Shop-Minimum Tattoos 8.00% $4.80 $4.80 $4.80 $4.80 $4.80 $4.80 $4.80 $4.80 $4.80 $4.80 $4.80 $4.80
Basic Tattoos (~1 hour) 7.00% $7.00 $7.00 $7.00 $7.00 $7.00 $7.00 $7.00 $7.00 $7.00 $7.00 $7.00 $7.00
Full Sessions (2-6 hours) 6.00% $18.00 $18.00 $18.00 $18.00 $18.00 $18.00 $18.00 $18.00 $18.00 $18.00 $18.00 $18.00
Resale Items (Posters, T-shirts, etc.) 40.00% $8.00 $8.00 $8.00 $8.00 $8.00 $8.00 $8.00 $8.00 $8.00 $8.00 $8.00 $8.00
Direct Cost of Sales
Shop-Minimum Tattoos $168 $178 $187 $197 $206 $216 $226 $235 $245 $259 $274 $288
Basic Tattoos (~1 hour) $210 $224 $238 $252 $266 $280 $294 $308 $322 $336 $350 $364
Full Sessions (2-6 hours) $450 $468 $486 $504 $522 $540 $576 $612 $648 $684 $720 $756
Resale Items (Posters, T-shirts, etc.) $16 $24 $40 $80 $98 $124 $152 $165 $171 $185 $201 $216
Subtotal Direct Cost of Sales $844 $894 $951 $1,033 $1,092 $1,160 $1,248 $1,320 $1,386 $1,464 $1,545 $1,624
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
Jake Hunt $4,125 $4,125 $4,125 $4,125 $4,125 $4,125 $4,125 $4,125 $4,125 $4,125 $4,125 $4,125
Julie Hunt $3,850 $3,850 $3,850 $3,850 $3,850 $3,850 $3,850 $3,850 $3,850 $3,850 $3,850 $3,850
Second Artist 0% $2,528 $2,656 $2,788 $2,932 $3,065 $3,202 $3,400 $3,590 $3,777 $3,981 $4,185 $4,388
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $10,503 $10,631 $10,763 $10,907 $11,040 $11,177 $11,375 $11,565 $11,752 $11,956 $12,160 $12,363
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 $12,640 $13,280 $13,940 $14,660 $15,324 $16,010 $17,001 $17,952 $18,887 $19,903 $20,923 $21,939
Direct Cost of Sales $844 $894 $951 $1,033 $1,092 $1,160 $1,248 $1,320 $1,386 $1,464 $1,545 $1,624
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $844 $894 $951 $1,033 $1,092 $1,160 $1,248 $1,320 $1,386 $1,464 $1,545 $1,624
Gross Margin $11,796 $12,386 $12,989 $13,627 $14,232 $14,850 $15,753 $16,632 $17,502 $18,439 $19,378 $20,316
Gross Margin % 93.32% 93.27% 93.18% 92.95% 92.87% 92.75% 92.66% 92.65% 92.66% 92.64% 92.62% 92.60%
Expenses
Payroll $10,503 $10,631 $10,763 $10,907 $11,040 $11,177 $11,375 $11,565 $11,752 $11,956 $12,160 $12,363
Marketing/Promotion $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Depreciation $139 $139 $139 $139 $139 $139 $172 $172 $172 $172 $172 $172
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 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,200
Payroll Taxes 15% $1,575 $1,595 $1,614 $1,636 $1,656 $1,677 $1,706 $1,735 $1,763 $1,793 $1,824 $1,854
Tattoo Supplies $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Total Operating Expenses $14,117 $14,265 $14,416 $14,582 $14,735 $14,893 $15,153 $15,372 $15,587 $15,821 $16,056 $17,489
Profit Before Interest and Taxes ($2,321) ($1,878) ($1,428) ($955) ($503) ($43) $600 $1,260 $1,914 $2,618 $3,323 $2,826
EBITDA ($2,182) ($1,739) ($1,289) ($816) ($364) $96 $772 $1,432 $2,086 $2,790 $3,495 $2,998
Interest Expense $104 $99 $94 $89 $84 $79 $75 $70 $65 $60 $58 $56
Taxes Incurred ($727) ($593) ($456) ($313) ($176) ($37) $157 $357 $555 $767 $979 $831
Net Profit ($1,697) ($1,384) ($1,065) ($731) ($411) ($85) $367 $833 $1,295 $1,790 $2,285 $1,940
Net Profit/Sales -13.43% -10.42% -7.64% -4.98% -2.68% -0.53% 2.16% 4.64% 6.85% 8.99% 10.92% 8.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 $12,640 $13,280 $13,940 $14,660 $15,324 $16,010 $17,001 $17,952 $18,887 $19,903 $20,923 $21,939
Subtotal Cash from Operations $12,640 $13,280 $13,940 $14,660 $15,324 $16,010 $17,001 $17,952 $18,887 $19,903 $20,923 $21,939
Additional Cash Received
Sales Tax, VAT, HST/GST Received 8.00% $1,011 $1,062 $1,115 $1,173 $1,226 $1,281 $1,360 $1,436 $1,511 $1,592 $1,674 $1,755
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,651 $14,342 $15,055 $15,833 $16,550 $17,291 $18,361 $19,388 $20,398 $21,495 $22,597 $23,695
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 $10,503 $10,631 $10,763 $10,907 $11,040 $11,177 $11,375 $11,565 $11,752 $11,956 $12,160 $12,363
Bill Payments $95 $2,877 $3,649 $4,170 $4,433 $4,623 $4,858 $5,184 $5,463 $5,745 $6,075 $6,425
Subtotal Spent on Operations $10,598 $13,508 $14,412 $15,077 $15,473 $15,800 $16,233 $16,749 $17,216 $17,701 $18,234 $18,788
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $1,011 $1,062 $1,115 $1,173 $1,226 $1,281 $1,360 $1,436 $1,511 $1,592 $1,674 $1,755
Principal Repayment of Current Borrowing $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $278 $278 $278 $278 $278 $278 $278 $278 $278 $278 $278 $278
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 $100 $100 $100 $100 $100 $100
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $12,087 $15,049 $16,005 $16,727 $17,176 $17,559 $18,172 $18,763 $19,305 $19,871 $20,286 $20,921
Net Cash Flow $1,564 ($706) ($950) ($895) ($626) ($268) $190 $625 $1,094 $1,624 $2,311 $2,773
Cash Balance $11,364 $10,657 $9,707 $8,813 $8,187 $7,918 $8,108 $8,733 $9,827 $11,451 $13,762 $16,536
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 $9,800 $11,364 $10,657 $9,707 $8,813 $8,187 $7,918 $8,108 $8,733 $9,827 $11,451 $13,762 $16,536
Inventory $2,000 $1,156 $894 $951 $1,033 $1,092 $1,160 $1,248 $1,320 $1,386 $1,464 $1,545 $1,624
Other Current Assets $1,500 $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 Current Assets $13,300 $14,020 $13,051 $12,159 $11,346 $10,779 $10,578 $10,856 $11,553 $12,713 $14,416 $16,807 $19,659
Long-term Assets
Long-term Assets $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,100 $5,200 $5,300 $5,400 $5,500 $5,600
Accumulated Depreciation $0 $139 $278 $417 $556 $695 $834 $1,006 $1,178 $1,350 $1,522 $1,694 $1,866
Total Long-term Assets $5,000 $4,861 $4,722 $4,583 $4,444 $4,305 $4,166 $4,094 $4,022 $3,950 $3,878 $3,806 $3,734
Total Assets $18,300 $18,881 $17,773 $16,742 $15,790 $15,084 $14,744 $14,950 $15,575 $16,663 $18,294 $20,613 $23,393
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 $2,756 $3,510 $4,022 $4,279 $4,462 $4,686 $5,002 $5,272 $5,543 $5,862 $6,174 $7,292
Current Borrowing $2,000 $1,800 $1,600 $1,400 $1,200 $1,000 $800 $600 $400 $200 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $2,000 $4,556 $5,110 $5,422 $5,479 $5,462 $5,486 $5,602 $5,672 $5,743 $5,862 $6,174 $7,292
Long-term Liabilities $10,000 $9,722 $9,444 $9,166 $8,888 $8,610 $8,332 $8,054 $7,776 $7,498 $7,220 $6,942 $6,664
Total Liabilities $12,000 $14,278 $14,554 $14,588 $14,367 $14,072 $13,818 $13,656 $13,448 $13,241 $13,082 $13,116 $13,956
Paid-in Capital $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
Retained Earnings ($8,700) ($8,700) ($8,700) ($8,700) ($8,700) ($8,700) ($8,700) ($8,700) ($8,700) ($8,700) ($8,700) ($8,700) ($8,700)
Earnings $0 ($1,697) ($3,081) ($4,146) ($4,877) ($5,288) ($5,373) ($5,006) ($4,173) ($2,878) ($1,088) $1,197 $3,137
Total Capital $6,300 $4,603 $3,219 $2,154 $1,423 $1,012 $927 $1,294 $2,127 $3,422 $5,212 $7,497 $9,437
Total Liabilities and Capital $18,300 $18,881 $17,773 $16,742 $15,790 $15,084 $14,744 $14,950 $15,575 $16,663 $18,294 $20,613 $23,393
Net Worth $6,300 $4,603 $3,219 $2,154 $1,423 $1,012 $927 $1,294 $2,127 $3,422 $5,212 $7,497 $9,437