| 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 |
| 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 |