| 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 | |||||||||||||
| Guns | 1% | £35,733 | £36,090 | £36,451 | £36,816 | £37,184 | £37,556 | £37,931 | £38,311 | £38,694 | £39,081 | £39,471 | £39,866 |
| Hoppers | 1% | £6,253 | £6,316 | £6,379 | £6,442 | £6,507 | £6,572 | £6,638 | £6,704 | £6,771 | £6,839 | £6,907 | £6,976 |
| Paintballs | 1% | £53,600 | £54,136 | £54,677 | £55,224 | £55,776 | £56,334 | £56,897 | £57,466 | £58,041 | £58,622 | £59,208 | £59,800 |
| Gun Upgrades | 1% | £17,867 | £18,046 | £18,226 | £18,408 | £18,592 | £18,778 | £18,966 | £19,156 | £19,347 | £19,541 | £19,736 | £19,934 |
| Apparel | 1% | £35,733 | £36,090 | £36,451 | £36,816 | £37,184 | £37,556 | £37,931 | £38,311 | £38,694 | £39,081 | £39,471 | £39,866 |
| Repairs | 1% | £1,787 | £1,805 | £1,823 | £1,841 | £1,860 | £1,878 | £1,897 | £1,916 | £1,935 | £1,954 | £1,974 | £1,994 |
| Magazines | 1% | £447 | £451 | £456 | £461 | £465 | £470 | £474 | £479 | £484 | £489 | £494 | £499 |
| Total Sales | £151,420 | £152,934 | £154,464 | £156,008 | £157,568 | £159,144 | £160,735 | £162,343 | £163,966 | £165,606 | £167,262 | £168,935 | |
| 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 | |
| Guns | 1% | £26,800 | £27,068 | £27,338 | £27,612 | £27,888 | £28,167 | £28,448 | £28,733 | £29,020 | £29,310 | £29,604 | £29,900 |
| Hoppers | 1% | £4,690 | £4,737 | £4,784 | £4,832 | £4,880 | £4,929 | £4,979 | £5,028 | £5,079 | £5,129 | £5,181 | £5,232 |
| Paintballs | 1% | £40,200 | £40,602 | £41,008 | £41,418 | £41,832 | £42,251 | £42,673 | £43,100 | £43,531 | £43,966 | £44,406 | £44,850 |
| Gun Upgrades | 1% | £13,400 | £13,534 | £13,669 | £13,806 | £13,944 | £14,084 | £14,224 | £14,367 | £14,510 | £14,655 | £14,802 | £14,950 |
| Apparel | 1% | £26,800 | £27,068 | £27,339 | £27,612 | £27,888 | £28,167 | £28,449 | £28,733 | £29,021 | £29,311 | £29,604 | £29,900 |
| Repairs | 1% | £772 | £798 | £772 | £798 | £798 | £772 | £798 | £772 | £798 | £798 | £721 | £798 |
| Magazines | 1% | £335 | £338 | £342 | £345 | £349 | £352 | £356 | £359 | £363 | £366 | £370 | £374 |
| Subtotal Direct Cost of Sales | £112,997 | £114,145 | £115,252 | £116,423 | £117,580 | £118,721 | £119,927 | £121,092 | £122,321 | £123,537 | £124,687 | £126,004 | |
| 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 | ||
| Store Manager | 0% | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 |
| Asst. Store Manager | 0% | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 |
| Inventory Manager | 0% | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 |
| Service Manager | 0% | £867 | £867 | £867 | £867 | £867 | £867 | £867 | £867 | £867 | £867 | £867 | £867 |
| Front Svc. Clerk | 0% | £803 | £830 | £803 | £830 | £830 | £803 | £830 | £803 | £830 | £830 | £750 | £830 |
| Front Svc. Clerk | 0% | £803 | £830 | £803 | £830 | £830 | £803 | £830 | £803 | £830 | £830 | £750 | £830 |
| Front Svc. Clerk | 0% | £803 | £830 | £803 | £830 | £830 | £803 | £830 | £803 | £830 | £830 | £750 | £830 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £8,376 | £8,457 | £8,376 | £8,457 | £8,457 | £8,376 | £8,457 | £8,376 | £8,457 | £8,457 | £8,217 | £8,457 | |
| 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 | 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 | Long-term Interest Rate | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% |
| Tax Rate | 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 | £151,420 | £152,934 | £154,464 | £156,008 | £157,568 | £159,144 | £160,735 | £162,343 | £163,966 | £165,606 | £167,262 | £168,935 | |
| Direct Cost of Sales | £112,997 | £114,145 | £115,252 | £116,423 | £117,580 | £118,721 | £119,927 | £121,092 | £122,321 | £123,537 | £124,687 | £126,004 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £112,997 | £114,145 | £115,252 | £116,423 | £117,580 | £118,721 | £119,927 | £121,092 | £122,321 | £123,537 | £124,687 | £126,004 | |
| Gross Margin | £38,423 | £38,789 | £39,211 | £39,585 | £39,989 | £40,423 | £40,809 | £41,251 | £41,645 | £42,069 | £42,575 | £42,931 | |
| Gross Margin % | 25.38% | 25.36% | 25.39% | 25.37% | 25.38% | 25.40% | 25.39% | 25.41% | 25.40% | 25.40% | 25.45% | 25.41% | |
| Expenses | |||||||||||||
| Payroll | £8,376 | £8,457 | £8,376 | £8,457 | £8,457 | £8,376 | £8,457 | £8,376 | £8,457 | £8,457 | £8,217 | £8,457 | |
| Sales and Marketing and Other Expenses | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | |
| Depreciation | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Rent | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | |
| Utilities | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Insurance | £94 | £94 | £94 | £94 | £94 | £94 | £94 | £94 | £94 | £94 | £94 | £94 | |
| Payroll Taxes | 20% | £562 | £581 | £568 | £581 | £581 | £562 | £581 | £562 | £581 | £581 | £525 | £581 |
| Website | 15% | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £18,799 | £18,899 | £18,805 | £18,899 | £18,899 | £18,799 | £18,899 | £18,799 | £18,899 | £18,899 | £18,603 | £18,899 | |
| Profit Before Interest and Taxes | £19,624 | £19,890 | £20,406 | £20,686 | £21,090 | £21,623 | £21,909 | £22,451 | £22,746 | £23,170 | £23,972 | £24,032 | |
| EBITDA | £19,674 | £19,940 | £20,456 | £20,736 | £21,140 | £21,673 | £21,959 | £22,501 | £22,796 | £23,220 | £24,022 | £24,082 | |
| Interest Expense | £700 | £689 | £678 | £666 | £655 | £644 | £633 | £621 | £610 | £599 | £588 | £576 | |
| Taxes Incurred | £5,677 | £5,760 | £5,918 | £6,006 | £6,130 | £6,294 | £6,383 | £6,549 | £6,641 | £6,771 | £7,015 | £7,037 | |
| Net Profit | £13,247 | £13,441 | £13,810 | £14,014 | £14,304 | £14,686 | £14,894 | £15,281 | £15,495 | £15,800 | £16,369 | £16,419 | |
| Net Profit/Sales | 8.75% | 8.79% | 8.94% | 8.98% | 9.08% | 9.23% | 9.27% | 9.41% | 9.45% | 9.54% | 9.79% | 9.72% | |
| 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 | £151,420 | £152,934 | £154,464 | £156,008 | £157,568 | £159,144 | £160,735 | £162,343 | £163,966 | £165,606 | £167,262 | £168,935 | |
| Subtotal Cash from Operations | £151,420 | £152,934 | £154,464 | £156,008 | £157,568 | £159,144 | £160,735 | £162,343 | £163,966 | £165,606 | £167,262 | £168,935 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 7.00% | £10,599 | £10,705 | £10,812 | £10,921 | £11,030 | £11,140 | £11,251 | £11,364 | £11,478 | £11,592 | £11,708 | £11,825 |
| 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 | £162,019 | £163,640 | £165,276 | £166,929 | £168,598 | £170,284 | £171,987 | £173,707 | £175,444 | £177,198 | £178,970 | £180,760 | |
| 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 | £8,376 | £8,457 | £8,376 | £8,457 | £8,457 | £8,376 | £8,457 | £8,376 | £8,457 | £8,457 | £8,217 | £8,457 | |
| Bill Payments | £5,801 | £172,651 | £132,289 | £133,490 | £134,817 | £136,071 | £137,334 | £138,702 | £139,964 | £141,360 | £142,677 | £143,943 | |
| Subtotal Spent on Operations | £14,177 | £181,108 | £140,665 | £141,947 | £143,274 | £144,447 | £145,791 | £147,078 | £148,421 | £149,817 | £150,894 | £152,400 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £10,599 | £10,705 | £10,812 | £10,921 | £11,030 | £11,140 | £11,251 | £11,364 | £11,478 | £11,592 | £11,708 | £11,825 | |
| 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 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | |
| 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 | £24,777 | £194,063 | £153,728 | £155,118 | £156,554 | £157,837 | £159,292 | £160,692 | £162,149 | £163,660 | £164,853 | £166,476 | |
| Net Cash Flow | £137,243 | (£30,423) | £11,548 | £11,811 | £12,044 | £12,447 | £12,694 | £13,014 | £13,295 | £13,539 | £14,117 | £14,284 | |
| Cash Balance | £164,807 | £134,383 | £145,932 | £157,743 | £169,787 | £182,234 | £194,928 | £207,942 | £221,237 | £234,776 | £248,894 | £263,178 | |
| 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 | £27,564 | £164,807 | £134,383 | £145,932 | £157,743 | £169,787 | £182,234 | £194,928 | £207,942 | £221,237 | £234,776 | £248,894 | £263,178 |
| Inventory | £80,000 | £124,296 | £125,559 | £126,778 | £128,066 | £129,337 | £130,593 | £131,920 | £133,201 | £134,553 | £135,890 | £137,155 | £138,604 |
| Other Current Assets | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 |
| Total Current Assets | £119,664 | £301,203 | £272,043 | £284,809 | £297,908 | £311,224 | £324,927 | £338,948 | £353,244 | £367,891 | £382,766 | £398,149 | £413,882 |
| Long-term Assets | |||||||||||||
| Long-term 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 |
| Accumulated Depreciation | £0 | £50 | £100 | £150 | £200 | £250 | £300 | £350 | £400 | £450 | £500 | £550 | £600 |
| Total Long-term Assets | £5,000 | £4,950 | £4,900 | £4,850 | £4,800 | £4,750 | £4,700 | £4,650 | £4,600 | £4,550 | £4,500 | £4,450 | £4,400 |
| Total Assets | £124,664 | £306,153 | £276,943 | £289,659 | £302,708 | £315,974 | £329,627 | £343,598 | £357,844 | £372,441 | £387,266 | £402,599 | £418,282 |
| 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 | £168,242 | £127,841 | £128,998 | £130,283 | £131,495 | £132,712 | £134,039 | £135,254 | £136,606 | £137,881 | £139,095 | £140,609 |
| 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 | £168,242 | £127,841 | £128,998 | £130,283 | £131,495 | £132,712 | £134,039 | £135,254 | £136,606 | £137,881 | £139,095 | £140,609 |
| Long-term Liabilities | £140,000 | £140,000 | £137,750 | £135,500 | £133,250 | £131,000 | £128,750 | £126,500 | £124,250 | £122,000 | £119,750 | £117,500 | £115,250 |
| Total Liabilities | £140,000 | £308,242 | £265,591 | £264,498 | £263,533 | £262,495 | £261,462 | £260,539 | £259,504 | £258,606 | £257,631 | £256,595 | £255,859 |
| Paid-in Capital | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 |
| Retained Earnings | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) |
| Earnings | £0 | £13,247 | £26,688 | £40,498 | £54,511 | £68,816 | £83,501 | £98,395 | £113,676 | £129,171 | £144,971 | £161,340 | £177,759 |
| Total Capital | (£15,336) | (£2,089) | £11,352 | £25,162 | £39,175 | £53,480 | £68,165 | £83,059 | £98,340 | £113,835 | £129,635 | £146,004 | £162,423 |
| Total Liabilities and Capital | £124,664 | £306,153 | £276,943 | £289,659 | £302,708 | £315,974 | £329,627 | £343,598 | £357,844 | £372,441 | £387,266 | £402,599 | £418,282 |
| Net Worth | (£15,336) | (£2,089) | £11,352 | £25,162 | £39,175 | £53,480 | £68,165 | £83,059 | £98,340 | £113,835 | £129,635 | £146,004 | £162,423 |
| 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 | |||||||||||||
| Guns | 1% | £35,733 | £36,090 | £36,451 | £36,816 | £37,184 | £37,556 | £37,931 | £38,311 | £38,694 | £39,081 | £39,471 | £39,866 |
| Hoppers | 1% | £6,253 | £6,316 | £6,379 | £6,442 | £6,507 | £6,572 | £6,638 | £6,704 | £6,771 | £6,839 | £6,907 | £6,976 |
| Paintballs | 1% | £53,600 | £54,136 | £54,677 | £55,224 | £55,776 | £56,334 | £56,897 | £57,466 | £58,041 | £58,622 | £59,208 | £59,800 |
| Gun Upgrades | 1% | £17,867 | £18,046 | £18,226 | £18,408 | £18,592 | £18,778 | £18,966 | £19,156 | £19,347 | £19,541 | £19,736 | £19,934 |
| Apparel | 1% | £35,733 | £36,090 | £36,451 | £36,816 | £37,184 | £37,556 | £37,931 | £38,311 | £38,694 | £39,081 | £39,471 | £39,866 |
| Repairs | 1% | £1,787 | £1,805 | £1,823 | £1,841 | £1,860 | £1,878 | £1,897 | £1,916 | £1,935 | £1,954 | £1,974 | £1,994 |
| Magazines | 1% | £447 | £451 | £456 | £461 | £465 | £470 | £474 | £479 | £484 | £489 | £494 | £499 |
| Total Sales | £151,420 | £152,934 | £154,464 | £156,008 | £157,568 | £159,144 | £160,735 | £162,343 | £163,966 | £165,606 | £167,262 | £168,935 | |
| 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 | |
| Guns | 1% | £26,800 | £27,068 | £27,338 | £27,612 | £27,888 | £28,167 | £28,448 | £28,733 | £29,020 | £29,310 | £29,604 | £29,900 |
| Hoppers | 1% | £4,690 | £4,737 | £4,784 | £4,832 | £4,880 | £4,929 | £4,979 | £5,028 | £5,079 | £5,129 | £5,181 | £5,232 |
| Paintballs | 1% | £40,200 | £40,602 | £41,008 | £41,418 | £41,832 | £42,251 | £42,673 | £43,100 | £43,531 | £43,966 | £44,406 | £44,850 |
| Gun Upgrades | 1% | £13,400 | £13,534 | £13,669 | £13,806 | £13,944 | £14,084 | £14,224 | £14,367 | £14,510 | £14,655 | £14,802 | £14,950 |
| Apparel | 1% | £26,800 | £27,068 | £27,339 | £27,612 | £27,888 | £28,167 | £28,449 | £28,733 | £29,021 | £29,311 | £29,604 | £29,900 |
| Repairs | 1% | £772 | £798 | £772 | £798 | £798 | £772 | £798 | £772 | £798 | £798 | £721 | £798 |
| Magazines | 1% | £335 | £338 | £342 | £345 | £349 | £352 | £356 | £359 | £363 | £366 | £370 | £374 |
| Subtotal Direct Cost of Sales | £112,997 | £114,145 | £115,252 | £116,423 | £117,580 | £118,721 | £119,927 | £121,092 | £122,321 | £123,537 | £124,687 | £126,004 | |
| 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 | ||
| Store Manager | 0% | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 |
| Asst. Store Manager | 0% | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 |
| Inventory Manager | 0% | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 |
| Service Manager | 0% | £867 | £867 | £867 | £867 | £867 | £867 | £867 | £867 | £867 | £867 | £867 | £867 |
| Front Svc. Clerk | 0% | £803 | £830 | £803 | £830 | £830 | £803 | £830 | £803 | £830 | £830 | £750 | £830 |
| Front Svc. Clerk | 0% | £803 | £830 | £803 | £830 | £830 | £803 | £830 | £803 | £830 | £830 | £750 | £830 |
| Front Svc. Clerk | 0% | £803 | £830 | £803 | £830 | £830 | £803 | £830 | £803 | £830 | £830 | £750 | £830 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £8,376 | £8,457 | £8,376 | £8,457 | £8,457 | £8,376 | £8,457 | £8,376 | £8,457 | £8,457 | £8,217 | £8,457 | |
| 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 | 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 | Long-term Interest Rate | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% |
| Tax Rate | 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 | £151,420 | £152,934 | £154,464 | £156,008 | £157,568 | £159,144 | £160,735 | £162,343 | £163,966 | £165,606 | £167,262 | £168,935 | |
| Direct Cost of Sales | £112,997 | £114,145 | £115,252 | £116,423 | £117,580 | £118,721 | £119,927 | £121,092 | £122,321 | £123,537 | £124,687 | £126,004 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £112,997 | £114,145 | £115,252 | £116,423 | £117,580 | £118,721 | £119,927 | £121,092 | £122,321 | £123,537 | £124,687 | £126,004 | |
| Gross Margin | £38,423 | £38,789 | £39,211 | £39,585 | £39,989 | £40,423 | £40,809 | £41,251 | £41,645 | £42,069 | £42,575 | £42,931 | |
| Gross Margin % | 25.38% | 25.36% | 25.39% | 25.37% | 25.38% | 25.40% | 25.39% | 25.41% | 25.40% | 25.40% | 25.45% | 25.41% | |
| Expenses | |||||||||||||
| Payroll | £8,376 | £8,457 | £8,376 | £8,457 | £8,457 | £8,376 | £8,457 | £8,376 | £8,457 | £8,457 | £8,217 | £8,457 | |
| Sales and Marketing and Other Expenses | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | |
| Depreciation | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Rent | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | £2,717 | |
| Utilities | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Insurance | £94 | £94 | £94 | £94 | £94 | £94 | £94 | £94 | £94 | £94 | £94 | £94 | |
| Payroll Taxes | 20% | £562 | £581 | £568 | £581 | £581 | £562 | £581 | £562 | £581 | £581 | £525 | £581 |
| Website | 15% | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £18,799 | £18,899 | £18,805 | £18,899 | £18,899 | £18,799 | £18,899 | £18,799 | £18,899 | £18,899 | £18,603 | £18,899 | |
| Profit Before Interest and Taxes | £19,624 | £19,890 | £20,406 | £20,686 | £21,090 | £21,623 | £21,909 | £22,451 | £22,746 | £23,170 | £23,972 | £24,032 | |
| EBITDA | £19,674 | £19,940 | £20,456 | £20,736 | £21,140 | £21,673 | £21,959 | £22,501 | £22,796 | £23,220 | £24,022 | £24,082 | |
| Interest Expense | £700 | £689 | £678 | £666 | £655 | £644 | £633 | £621 | £610 | £599 | £588 | £576 | |
| Taxes Incurred | £5,677 | £5,760 | £5,918 | £6,006 | £6,130 | £6,294 | £6,383 | £6,549 | £6,641 | £6,771 | £7,015 | £7,037 | |
| Net Profit | £13,247 | £13,441 | £13,810 | £14,014 | £14,304 | £14,686 | £14,894 | £15,281 | £15,495 | £15,800 | £16,369 | £16,419 | |
| Net Profit/Sales | 8.75% | 8.79% | 8.94% | 8.98% | 9.08% | 9.23% | 9.27% | 9.41% | 9.45% | 9.54% | 9.79% | 9.72% | |
| 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 | £151,420 | £152,934 | £154,464 | £156,008 | £157,568 | £159,144 | £160,735 | £162,343 | £163,966 | £165,606 | £167,262 | £168,935 | |
| Subtotal Cash from Operations | £151,420 | £152,934 | £154,464 | £156,008 | £157,568 | £159,144 | £160,735 | £162,343 | £163,966 | £165,606 | £167,262 | £168,935 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 7.00% | £10,599 | £10,705 | £10,812 | £10,921 | £11,030 | £11,140 | £11,251 | £11,364 | £11,478 | £11,592 | £11,708 | £11,825 |
| 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 | £162,019 | £163,640 | £165,276 | £166,929 | £168,598 | £170,284 | £171,987 | £173,707 | £175,444 | £177,198 | £178,970 | £180,760 | |
| 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 | £8,376 | £8,457 | £8,376 | £8,457 | £8,457 | £8,376 | £8,457 | £8,376 | £8,457 | £8,457 | £8,217 | £8,457 | |
| Bill Payments | £5,801 | £172,651 | £132,289 | £133,490 | £134,817 | £136,071 | £137,334 | £138,702 | £139,964 | £141,360 | £142,677 | £143,943 | |
| Subtotal Spent on Operations | £14,177 | £181,108 | £140,665 | £141,947 | £143,274 | £144,447 | £145,791 | £147,078 | £148,421 | £149,817 | £150,894 | £152,400 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £10,599 | £10,705 | £10,812 | £10,921 | £11,030 | £11,140 | £11,251 | £11,364 | £11,478 | £11,592 | £11,708 | £11,825 | |
| 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 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | |
| 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 | £24,777 | £194,063 | £153,728 | £155,118 | £156,554 | £157,837 | £159,292 | £160,692 | £162,149 | £163,660 | £164,853 | £166,476 | |
| Net Cash Flow | £137,243 | (£30,423) | £11,548 | £11,811 | £12,044 | £12,447 | £12,694 | £13,014 | £13,295 | £13,539 | £14,117 | £14,284 | |
| Cash Balance | £164,807 | £134,383 | £145,932 | £157,743 | £169,787 | £182,234 | £194,928 | £207,942 | £221,237 | £234,776 | £248,894 | £263,178 | |
| 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 | £27,564 | £164,807 | £134,383 | £145,932 | £157,743 | £169,787 | £182,234 | £194,928 | £207,942 | £221,237 | £234,776 | £248,894 | £263,178 |
| Inventory | £80,000 | £124,296 | £125,559 | £126,778 | £128,066 | £129,337 | £130,593 | £131,920 | £133,201 | £134,553 | £135,890 | £137,155 | £138,604 |
| Other Current Assets | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 | £12,100 |
| Total Current Assets | £119,664 | £301,203 | £272,043 | £284,809 | £297,908 | £311,224 | £324,927 | £338,948 | £353,244 | £367,891 | £382,766 | £398,149 | £413,882 |
| Long-term Assets | |||||||||||||
| Long-term 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 |
| Accumulated Depreciation | £0 | £50 | £100 | £150 | £200 | £250 | £300 | £350 | £400 | £450 | £500 | £550 | £600 |
| Total Long-term Assets | £5,000 | £4,950 | £4,900 | £4,850 | £4,800 | £4,750 | £4,700 | £4,650 | £4,600 | £4,550 | £4,500 | £4,450 | £4,400 |
| Total Assets | £124,664 | £306,153 | £276,943 | £289,659 | £302,708 | £315,974 | £329,627 | £343,598 | £357,844 | £372,441 | £387,266 | £402,599 | £418,282 |
| 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 | £168,242 | £127,841 | £128,998 | £130,283 | £131,495 | £132,712 | £134,039 | £135,254 | £136,606 | £137,881 | £139,095 | £140,609 |
| 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 | £168,242 | £127,841 | £128,998 | £130,283 | £131,495 | £132,712 | £134,039 | £135,254 | £136,606 | £137,881 | £139,095 | £140,609 |
| Long-term Liabilities | £140,000 | £140,000 | £137,750 | £135,500 | £133,250 | £131,000 | £128,750 | £126,500 | £124,250 | £122,000 | £119,750 | £117,500 | £115,250 |
| Total Liabilities | £140,000 | £308,242 | £265,591 | £264,498 | £263,533 | £262,495 | £261,462 | £260,539 | £259,504 | £258,606 | £257,631 | £256,595 | £255,859 |
| Paid-in Capital | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 |
| Retained Earnings | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) | (£95,336) |
| Earnings | £0 | £13,247 | £26,688 | £40,498 | £54,511 | £68,816 | £83,501 | £98,395 | £113,676 | £129,171 | £144,971 | £161,340 | £177,759 |
| Total Capital | (£15,336) | (£2,089) | £11,352 | £25,162 | £39,175 | £53,480 | £68,165 | £83,059 | £98,340 | £113,835 | £129,635 | £146,004 | £162,423 |
| Total Liabilities and Capital | £124,664 | £306,153 | £276,943 | £289,659 | £302,708 | £315,974 | £329,627 | £343,598 | £357,844 | £372,441 | £387,266 | £402,599 | £418,282 |
| Net Worth | (£15,336) | (£2,089) | £11,352 | £25,162 | £39,175 | £53,480 | £68,165 | £83,059 | £98,340 | £113,835 | £129,635 | £146,004 | £162,423 |