| 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 | |||||||||||||
| Pizza | 0% | £7,200 | £12,600 | £11,160 | £12,000 | £11,460 | £11,340 | £11,820 | £11,160 | £11,320 | £11,640 | £10,560 | £11,640 |
| Breadsticks | 0% | £1,000 | £1,750 | £1,550 | £1,667 | £1,592 | £1,575 | £1,642 | £1,550 | £1,642 | £1,617 | £1,467 | £1,617 |
| Beer | 0% | £2,000 | £3,500 | £3,100 | £3,333 | £3,183 | £3,150 | £3,283 | £3,100 | £3,283 | £3,233 | £2,933 | £3,233 |
| Drinks | 0% | £2,720 | £4,760 | £4,216 | £4,533 | £4,329 | £4,284 | £4,465 | £4,216 | £4,465 | £4,397 | £3,989 | £4,397 |
| Total Sales | £12,920 | £22,610 | £20,026 | £21,533 | £20,564 | £20,349 | £21,210 | £20,026 | £20,710 | £20,887 | £18,949 | £20,887 | |
| 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 | |
| Pizza | 32% | £2,304 | £4,032 | £3,571 | £3,840 | £3,667 | £3,629 | £3,782 | £3,571 | £3,622 | £3,725 | £3,379 | £3,725 |
| Breadsticks | 20% | £200 | £350 | £310 | £333 | £318 | £315 | £328 | £310 | £328 | £323 | £293 | £323 |
| Beer | 20% | £400 | £700 | £620 | £667 | £637 | £630 | £657 | £620 | £657 | £647 | £587 | £647 |
| Drinks | 5% | £136 | £238 | £211 | £227 | £216 | £214 | £223 | £211 | £223 | £220 | £199 | £220 |
| Subtotal Direct Cost of Sales | £3,040 | £5,320 | £4,712 | £5,067 | £4,839 | £4,788 | £4,991 | £4,712 | £4,831 | £4,915 | £4,459 | £4,915 | |
| 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 | ||
| Kitchen Leads | 0% | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 |
| Kitchen/Wait | 0% | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 |
| Dishwasher | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Owner | 0% | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Delivery | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Total People | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | |
| Total Payroll | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | |
| 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 | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Long-term Interest Rate | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.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 | £12,920 | £22,610 | £20,026 | £21,533 | £20,564 | £20,349 | £21,210 | £20,026 | £20,710 | £20,887 | £18,949 | £20,887 | |
| Direct Cost of Sales | £3,040 | £5,320 | £4,712 | £5,067 | £4,839 | £4,788 | £4,991 | £4,712 | £4,831 | £4,915 | £4,459 | £4,915 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,040 | £5,320 | £4,712 | £5,067 | £4,839 | £4,788 | £4,991 | £4,712 | £4,831 | £4,915 | £4,459 | £4,915 | |
| Gross Margin | £9,880 | £17,290 | £15,314 | £16,467 | £15,726 | £15,561 | £16,220 | £15,314 | £15,880 | £15,973 | £14,491 | £15,973 | |
| Gross Margin % | 76.47% | 76.47% | 76.47% | 76.47% | 76.47% | 76.47% | 76.47% | 76.47% | 76.68% | 76.47% | 76.47% | 76.47% | |
| Expenses | |||||||||||||
| Payroll | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | |
| Sales and Marketing and Other Expenses | £500 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £250 | £250 | £500 | £500 | |
| Depreciation | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | |
| Rent | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Utilities | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Insurance | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Payroll Taxes | 15% | £670 | £670 | £670 | £670 | £670 | £670 | £670 | £670 | £670 | £670 | £670 | £670 |
| Website Hosting and Maintenance | 15% | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £12,350 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,100 | £12,100 | £12,350 | £12,350 | |
| Profit Before Interest and Taxes | (£2,470) | £4,690 | £2,714 | £3,866 | £3,125 | £2,961 | £3,619 | £2,714 | £3,779 | £3,872 | £2,140 | £3,622 | |
| EBITDA | (£2,300) | £4,860 | £2,884 | £4,036 | £3,295 | £3,131 | £3,789 | £2,884 | £3,949 | £4,042 | £2,310 | £3,792 | |
| Interest Expense | £102 | £100 | £98 | £96 | £94 | £92 | £90 | £88 | £85 | £83 | £81 | £79 | |
| Taxes Incurred | (£772) | £1,377 | £785 | £1,131 | £910 | £861 | £1,059 | £788 | £1,108 | £1,137 | £618 | £1,063 | |
| Net Profit | (£1,801) | £3,213 | £1,831 | £2,639 | £2,122 | £2,008 | £2,471 | £1,838 | £2,586 | £2,652 | £1,441 | £2,480 | |
| Net Profit/Sales | -13.94% | 14.21% | 9.14% | 12.26% | 10.32% | 9.87% | 11.65% | 9.18% | 12.49% | 12.70% | 7.61% | 11.87% | |
| 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,920 | £22,610 | £20,026 | £21,533 | £20,564 | £20,349 | £21,210 | £20,026 | £20,710 | £20,887 | £18,949 | £20,887 | |
| Subtotal Cash from Operations | £12,920 | £22,610 | £20,026 | £21,533 | £20,564 | £20,349 | £21,210 | £20,026 | £20,710 | £20,887 | £18,949 | £20,887 | |
| 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 | £12,920 | £22,610 | £20,026 | £21,533 | £20,564 | £20,349 | £21,210 | £20,026 | £20,710 | £20,887 | £18,949 | £20,887 | |
| 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,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | |
| Bill Payments | £9,590 | £2,921 | £9,309 | £9,037 | £10,016 | £9,381 | £9,359 | £9,806 | £9,113 | £9,189 | £9,254 | £8,409 | |
| Subtotal Spent on Operations | £18,400 | £11,731 | £18,119 | £17,847 | £18,826 | £18,191 | £18,169 | £18,616 | £17,923 | £17,999 | £18,064 | £17,219 | |
| 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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| 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 | £18,900 | £12,231 | £18,619 | £18,347 | £19,326 | £18,691 | £18,669 | £19,116 | £18,423 | £18,499 | £18,564 | £17,719 | |
| Net Cash Flow | (£5,980) | £10,379 | £1,407 | £3,187 | £1,238 | £1,658 | £2,541 | £910 | £2,288 | £2,388 | £386 | £3,168 | |
| Cash Balance | £17,120 | £27,499 | £28,906 | £32,093 | £33,331 | £34,989 | £37,530 | £38,440 | £40,728 | £43,116 | £43,501 | £46,670 | |
| 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 | £23,100 | £17,120 | £27,499 | £28,906 | £32,093 | £33,331 | £34,989 | £37,530 | £38,440 | £40,728 | £43,116 | £43,501 | £46,670 |
| Inventory | £6,000 | £2,960 | £1,862 | £1,649 | £1,773 | £1,694 | £1,676 | £1,747 | £1,649 | £1,691 | £1,720 | £1,561 | £1,720 |
| Other Current Assets | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 |
| Total Current Assets | £34,350 | £25,330 | £34,611 | £35,805 | £39,116 | £40,275 | £41,915 | £44,527 | £45,339 | £47,669 | £50,086 | £50,312 | £53,640 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 |
| Accumulated Depreciation | £0 | £170 | £340 | £510 | £680 | £850 | £1,020 | £1,190 | £1,360 | £1,530 | £1,700 | £1,870 | £2,040 |
| Total Long-term Assets | £20,300 | £20,130 | £19,960 | £19,790 | £19,620 | £19,450 | £19,280 | £19,110 | £18,940 | £18,770 | £18,600 | £18,430 | £18,260 |
| Total Assets | £54,650 | £45,460 | £54,571 | £55,595 | £58,736 | £59,725 | £61,195 | £63,637 | £64,279 | £66,439 | £68,686 | £68,742 | £71,900 |
| 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 | £9,500 | £2,611 | £9,008 | £8,702 | £9,703 | £9,070 | £9,031 | £9,503 | £8,806 | £8,880 | £8,975 | £8,089 | £9,267 |
| 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 | £9,500 | £2,611 | £9,008 | £8,702 | £9,703 | £9,070 | £9,031 | £9,503 | £8,806 | £8,880 | £8,975 | £8,089 | £9,267 |
| Long-term Liabilities | £25,000 | £24,500 | £24,000 | £23,500 | £23,000 | £22,500 | £22,000 | £21,500 | £21,000 | £20,500 | £20,000 | £19,500 | £19,000 |
| Total Liabilities | £34,500 | £27,111 | £33,008 | £32,202 | £32,703 | £31,570 | £31,031 | £31,003 | £29,806 | £29,380 | £28,975 | £27,589 | £28,267 |
| Paid-in Capital | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 |
| Retained Earnings | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) |
| Earnings | £0 | (£1,801) | £1,412 | £3,243 | £5,883 | £8,005 | £10,014 | £12,484 | £14,323 | £16,909 | £19,561 | £21,003 | £23,483 |
| Total Capital | £20,150 | £18,349 | £21,562 | £23,393 | £26,033 | £28,155 | £30,164 | £32,634 | £34,473 | £37,059 | £39,711 | £41,153 | £43,633 |
| Total Liabilities and Capital | £54,650 | £45,460 | £54,571 | £55,595 | £58,736 | £59,725 | £61,195 | £63,637 | £64,279 | £66,439 | £68,686 | £68,742 | £71,900 |
| Net Worth | £20,150 | £18,349 | £21,562 | £23,393 | £26,033 | £28,155 | £30,164 | £32,634 | £34,473 | £37,059 | £39,711 | £41,153 | £43,633 |
| 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 | |||||||||||||
| Pizza | 0% | £7,200 | £12,600 | £11,160 | £12,000 | £11,460 | £11,340 | £11,820 | £11,160 | £11,320 | £11,640 | £10,560 | £11,640 |
| Breadsticks | 0% | £1,000 | £1,750 | £1,550 | £1,667 | £1,592 | £1,575 | £1,642 | £1,550 | £1,642 | £1,617 | £1,467 | £1,617 |
| Beer | 0% | £2,000 | £3,500 | £3,100 | £3,333 | £3,183 | £3,150 | £3,283 | £3,100 | £3,283 | £3,233 | £2,933 | £3,233 |
| Drinks | 0% | £2,720 | £4,760 | £4,216 | £4,533 | £4,329 | £4,284 | £4,465 | £4,216 | £4,465 | £4,397 | £3,989 | £4,397 |
| Total Sales | £12,920 | £22,610 | £20,026 | £21,533 | £20,564 | £20,349 | £21,210 | £20,026 | £20,710 | £20,887 | £18,949 | £20,887 | |
| 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 | |
| Pizza | 32% | £2,304 | £4,032 | £3,571 | £3,840 | £3,667 | £3,629 | £3,782 | £3,571 | £3,622 | £3,725 | £3,379 | £3,725 |
| Breadsticks | 20% | £200 | £350 | £310 | £333 | £318 | £315 | £328 | £310 | £328 | £323 | £293 | £323 |
| Beer | 20% | £400 | £700 | £620 | £667 | £637 | £630 | £657 | £620 | £657 | £647 | £587 | £647 |
| Drinks | 5% | £136 | £238 | £211 | £227 | £216 | £214 | £223 | £211 | £223 | £220 | £199 | £220 |
| Subtotal Direct Cost of Sales | £3,040 | £5,320 | £4,712 | £5,067 | £4,839 | £4,788 | £4,991 | £4,712 | £4,831 | £4,915 | £4,459 | £4,915 | |
| 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 | ||
| Kitchen Leads | 0% | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 | £2,340 |
| Kitchen/Wait | 0% | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 | £3,120 |
| Dishwasher | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Owner | 0% | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Delivery | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 |
| Total People | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | |
| Total Payroll | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | |
| 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 | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Long-term Interest Rate | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.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 | £12,920 | £22,610 | £20,026 | £21,533 | £20,564 | £20,349 | £21,210 | £20,026 | £20,710 | £20,887 | £18,949 | £20,887 | |
| Direct Cost of Sales | £3,040 | £5,320 | £4,712 | £5,067 | £4,839 | £4,788 | £4,991 | £4,712 | £4,831 | £4,915 | £4,459 | £4,915 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,040 | £5,320 | £4,712 | £5,067 | £4,839 | £4,788 | £4,991 | £4,712 | £4,831 | £4,915 | £4,459 | £4,915 | |
| Gross Margin | £9,880 | £17,290 | £15,314 | £16,467 | £15,726 | £15,561 | £16,220 | £15,314 | £15,880 | £15,973 | £14,491 | £15,973 | |
| Gross Margin % | 76.47% | 76.47% | 76.47% | 76.47% | 76.47% | 76.47% | 76.47% | 76.47% | 76.68% | 76.47% | 76.47% | 76.47% | |
| Expenses | |||||||||||||
| Payroll | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | |
| Sales and Marketing and Other Expenses | £500 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £250 | £250 | £500 | £500 | |
| Depreciation | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | |
| Rent | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Utilities | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Insurance | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Payroll Taxes | 15% | £670 | £670 | £670 | £670 | £670 | £670 | £670 | £670 | £670 | £670 | £670 | £670 |
| Website Hosting and Maintenance | 15% | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £12,350 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,100 | £12,100 | £12,350 | £12,350 | |
| Profit Before Interest and Taxes | (£2,470) | £4,690 | £2,714 | £3,866 | £3,125 | £2,961 | £3,619 | £2,714 | £3,779 | £3,872 | £2,140 | £3,622 | |
| EBITDA | (£2,300) | £4,860 | £2,884 | £4,036 | £3,295 | £3,131 | £3,789 | £2,884 | £3,949 | £4,042 | £2,310 | £3,792 | |
| Interest Expense | £102 | £100 | £98 | £96 | £94 | £92 | £90 | £88 | £85 | £83 | £81 | £79 | |
| Taxes Incurred | (£772) | £1,377 | £785 | £1,131 | £910 | £861 | £1,059 | £788 | £1,108 | £1,137 | £618 | £1,063 | |
| Net Profit | (£1,801) | £3,213 | £1,831 | £2,639 | £2,122 | £2,008 | £2,471 | £1,838 | £2,586 | £2,652 | £1,441 | £2,480 | |
| Net Profit/Sales | -13.94% | 14.21% | 9.14% | 12.26% | 10.32% | 9.87% | 11.65% | 9.18% | 12.49% | 12.70% | 7.61% | 11.87% | |
| 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,920 | £22,610 | £20,026 | £21,533 | £20,564 | £20,349 | £21,210 | £20,026 | £20,710 | £20,887 | £18,949 | £20,887 | |
| Subtotal Cash from Operations | £12,920 | £22,610 | £20,026 | £21,533 | £20,564 | £20,349 | £21,210 | £20,026 | £20,710 | £20,887 | £18,949 | £20,887 | |
| 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 | £12,920 | £22,610 | £20,026 | £21,533 | £20,564 | £20,349 | £21,210 | £20,026 | £20,710 | £20,887 | £18,949 | £20,887 | |
| 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,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | £8,810 | |
| Bill Payments | £9,590 | £2,921 | £9,309 | £9,037 | £10,016 | £9,381 | £9,359 | £9,806 | £9,113 | £9,189 | £9,254 | £8,409 | |
| Subtotal Spent on Operations | £18,400 | £11,731 | £18,119 | £17,847 | £18,826 | £18,191 | £18,169 | £18,616 | £17,923 | £17,999 | £18,064 | £17,219 | |
| 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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| 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 | £18,900 | £12,231 | £18,619 | £18,347 | £19,326 | £18,691 | £18,669 | £19,116 | £18,423 | £18,499 | £18,564 | £17,719 | |
| Net Cash Flow | (£5,980) | £10,379 | £1,407 | £3,187 | £1,238 | £1,658 | £2,541 | £910 | £2,288 | £2,388 | £386 | £3,168 | |
| Cash Balance | £17,120 | £27,499 | £28,906 | £32,093 | £33,331 | £34,989 | £37,530 | £38,440 | £40,728 | £43,116 | £43,501 | £46,670 | |
| 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 | £23,100 | £17,120 | £27,499 | £28,906 | £32,093 | £33,331 | £34,989 | £37,530 | £38,440 | £40,728 | £43,116 | £43,501 | £46,670 |
| Inventory | £6,000 | £2,960 | £1,862 | £1,649 | £1,773 | £1,694 | £1,676 | £1,747 | £1,649 | £1,691 | £1,720 | £1,561 | £1,720 |
| Other Current Assets | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 |
| Total Current Assets | £34,350 | £25,330 | £34,611 | £35,805 | £39,116 | £40,275 | £41,915 | £44,527 | £45,339 | £47,669 | £50,086 | £50,312 | £53,640 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 | £20,300 |
| Accumulated Depreciation | £0 | £170 | £340 | £510 | £680 | £850 | £1,020 | £1,190 | £1,360 | £1,530 | £1,700 | £1,870 | £2,040 |
| Total Long-term Assets | £20,300 | £20,130 | £19,960 | £19,790 | £19,620 | £19,450 | £19,280 | £19,110 | £18,940 | £18,770 | £18,600 | £18,430 | £18,260 |
| Total Assets | £54,650 | £45,460 | £54,571 | £55,595 | £58,736 | £59,725 | £61,195 | £63,637 | £64,279 | £66,439 | £68,686 | £68,742 | £71,900 |
| 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 | £9,500 | £2,611 | £9,008 | £8,702 | £9,703 | £9,070 | £9,031 | £9,503 | £8,806 | £8,880 | £8,975 | £8,089 | £9,267 |
| 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 | £9,500 | £2,611 | £9,008 | £8,702 | £9,703 | £9,070 | £9,031 | £9,503 | £8,806 | £8,880 | £8,975 | £8,089 | £9,267 |
| Long-term Liabilities | £25,000 | £24,500 | £24,000 | £23,500 | £23,000 | £22,500 | £22,000 | £21,500 | £21,000 | £20,500 | £20,000 | £19,500 | £19,000 |
| Total Liabilities | £34,500 | £27,111 | £33,008 | £32,202 | £32,703 | £31,570 | £31,031 | £31,003 | £29,806 | £29,380 | £28,975 | £27,589 | £28,267 |
| Paid-in Capital | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 | £46,000 |
| Retained Earnings | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) | (£25,850) |
| Earnings | £0 | (£1,801) | £1,412 | £3,243 | £5,883 | £8,005 | £10,014 | £12,484 | £14,323 | £16,909 | £19,561 | £21,003 | £23,483 |
| Total Capital | £20,150 | £18,349 | £21,562 | £23,393 | £26,033 | £28,155 | £30,164 | £32,634 | £34,473 | £37,059 | £39,711 | £41,153 | £43,633 |
| Total Liabilities and Capital | £54,650 | £45,460 | £54,571 | £55,595 | £58,736 | £59,725 | £61,195 | £63,637 | £64,279 | £66,439 | £68,686 | £68,742 | £71,900 |
| Net Worth | £20,150 | £18,349 | £21,562 | £23,393 | £26,033 | £28,155 | £30,164 | £32,634 | £34,473 | £37,059 | £39,711 | £41,153 | £43,633 |