| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Adult drivers | 0% | £14,000 | £14,000 | £14,000 | £14,000 | £14,000 | £20,000 | £20,000 | £20,000 | £24,000 | £25,000 | £21,000 | £23,000 |
| Beginner drivers | 0% | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £24,000 | £24,000 | £24,000 | £28,000 | £26,000 | £33,000 | £36,000 |
| Drivers under court order | 0% | £11,500 | £11,500 | £11,500 | £11,500 | £11,500 | £14,000 | £14,000 | £14,000 | £17,000 | £18,000 | £18,888 | £18,000 |
| High schools | 0% | £20,850 | £20,850 | £20,850 | £20,850 | £20,850 | £25,000 | £25,000 | £25,000 | £41,700 | £41,700 | £31,000 | £31,000 |
| Commercial drivers | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £64,350 | £64,350 | £64,350 | £64,350 | £64,350 | £83,000 | £83,000 | £83,000 | £110,700 | £110,700 | £103,888 | £108,000 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Adult drivers | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £8,000 | £8,000 | £8,000 | £9,600 | £10,000 | £8,400 | £9,200 | |
| Beginner drivers | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £9,600 | £9,600 | £9,600 | £11,200 | £10,400 | £13,200 | £14,400 | |
| Drivers under court order | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £5,600 | £5,600 | £5,600 | £6,800 | £7,200 | £7,555 | £7,200 | |
| High schools | £8,340 | £8,340 | £8,340 | £8,340 | £8,340 | £10,000 | £10,000 | £10,000 | £16,680 | £16,680 | £12,400 | £12,400 | |
| Commercial drivers | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £25,740 | £25,740 | £25,740 | £25,740 | £25,740 | £33,200 | £33,200 | £33,200 | £44,280 | £44,280 | £41,555 | £43,200 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| President and General Manager | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Controller | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Education Planner | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Education Coordinator | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Facilities Mangers | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Office Manager | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Marketing Executive (Contract work) | 0% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| Educators | 0% | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 |
| Total People | 11 | 11 | 11 | 11 | 11 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | |
| Total Payroll | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| 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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £64,350 | £64,350 | £64,350 | £64,350 | £64,350 | £83,000 | £83,000 | £83,000 | £110,700 | £110,700 | £103,888 | £108,000 | |
| Direct Cost of Sales | £25,740 | £25,740 | £25,740 | £25,740 | £25,740 | £33,200 | £33,200 | £33,200 | £44,280 | £44,280 | £41,555 | £43,200 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £25,740 | £25,740 | £25,740 | £25,740 | £25,740 | £33,200 | £33,200 | £33,200 | £44,280 | £44,280 | £41,555 | £43,200 | |
| Gross Margin | £38,610 | £38,610 | £38,610 | £38,610 | £38,610 | £49,800 | £49,800 | £49,800 | £66,420 | £66,420 | £62,333 | £64,800 | |
| Gross Margin % | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
| Expenses | |||||||||||||
| Payroll | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | |
| Sales and Marketing and Other Expenses | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | £4,500 | £4,500 | £4,500 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Depreciation | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £400 | £400 | £400 | £400 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £400 | £400 | £400 | £600 | £600 | £600 | £600 | |
| Insurance | £600 | £600 | £600 | £600 | £600 | £1,200 | £1,200 | £1,200 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Rent | £2,000 | £2,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Payroll Taxes | 15% | £3,713 | £3,713 | £3,713 | £3,713 | £3,713 | £4,538 | £4,538 | £4,538 | £4,538 | £4,538 | £4,538 | £4,538 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £34,363 | £34,363 | £36,363 | £36,363 | £36,363 | £47,088 | £47,088 | £47,088 | £53,588 | £53,588 | £53,588 | £53,588 | |
| Profit Before Interest and Taxes | £4,248 | £4,248 | £2,248 | £2,248 | £2,248 | £2,713 | £2,713 | £2,713 | £12,833 | £12,833 | £8,745 | £11,213 | |
| EBITDA | £4,448 | £4,448 | £2,448 | £2,448 | £2,448 | £2,913 | £2,913 | £2,913 | £13,233 | £13,233 | £9,145 | £11,613 | |
| Interest Expense | £188 | £183 | £179 | £175 | £171 | £167 | £163 | £158 | £154 | £150 | £146 | £142 | |
| Taxes Incurred | £1,218 | £1,219 | £621 | £622 | £623 | £764 | £765 | £766 | £3,804 | £3,805 | £2,580 | £3,321 | |
| Net Profit | £2,842 | £2,845 | £1,448 | £1,451 | £1,454 | £1,782 | £1,785 | £1,788 | £8,875 | £8,878 | £6,020 | £7,750 | |
| Net Profit/Sales | 4.42% | 4.42% | 2.25% | 2.25% | 2.26% | 2.15% | 2.15% | 2.15% | 8.02% | 8.02% | 5.79% | 7.18% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £64,350 | £64,350 | £64,350 | £64,350 | £64,350 | £83,000 | £83,000 | £83,000 | £110,700 | £110,700 | £103,888 | £108,000 | |
| Subtotal Cash from Operations | £64,350 | £64,350 | £64,350 | £64,350 | £64,350 | £83,000 | £83,000 | £83,000 | £110,700 | £110,700 | £103,888 | £108,000 | |
| 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 | £64,350 | £64,350 | £64,350 | £64,350 | £64,350 | £83,000 | £83,000 | £83,000 | £110,700 | £110,700 | £103,888 | £108,000 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | |
| Bill Payments | £4,935 | £36,558 | £36,602 | £37,952 | £37,949 | £38,374 | £50,768 | £50,765 | £51,443 | £71,175 | £71,040 | £67,298 | |
| Subtotal Spent on Operations | £29,685 | £61,308 | £61,352 | £62,702 | £62,699 | £68,624 | £81,018 | £81,015 | £81,693 | £101,425 | £101,290 | £97,548 | |
| 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 | £30,185 | £61,808 | £61,852 | £63,202 | £63,199 | £69,124 | £81,518 | £81,515 | £82,193 | £101,925 | £101,790 | £98,048 | |
| Net Cash Flow | £34,165 | £2,542 | £2,498 | £1,148 | £1,151 | £13,876 | £1,482 | £1,485 | £28,507 | £8,775 | £2,098 | £9,952 | |
| Cash Balance | £47,103 | £49,645 | £52,144 | £53,292 | £54,443 | £68,319 | £69,801 | £71,286 | £99,794 | £108,569 | £110,666 | £120,618 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £12,938 | £47,103 | £49,645 | £52,144 | £53,292 | £54,443 | £68,319 | £69,801 | £71,286 | £99,794 | £108,569 | £110,666 | £120,618 |
| Other Current Assets | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Total Current Assets | £14,938 | £49,103 | £51,645 | £54,144 | £55,292 | £56,443 | £70,319 | £71,801 | £73,286 | £101,794 | £110,569 | £112,666 | £122,618 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 |
| Accumulated Depreciation | £12,000 | £12,200 | £12,400 | £12,600 | £12,800 | £13,000 | £13,200 | £13,400 | £13,600 | £14,000 | £14,400 | £14,800 | £15,200 |
| Total Long-term Assets | £62,000 | £61,800 | £61,600 | £61,400 | £61,200 | £61,000 | £60,800 | £60,600 | £60,400 | £60,000 | £59,600 | £59,200 | £58,800 |
| Total Assets | £76,938 | £110,903 | £113,245 | £115,544 | £116,492 | £117,443 | £131,119 | £132,401 | £133,686 | £161,794 | £170,169 | £171,866 | £181,418 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £3,716 | £35,339 | £35,337 | £36,687 | £36,684 | £36,681 | £49,076 | £49,073 | £49,070 | £68,803 | £68,800 | £64,978 | £67,280 |
| 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 | £3,716 | £35,339 | £35,337 | £36,687 | £36,684 | £36,681 | £49,076 | £49,073 | £49,070 | £68,803 | £68,800 | £64,978 | £67,280 |
| Long-term Liabilities | £23,000 | £22,500 | £22,000 | £21,500 | £21,000 | £20,500 | £20,000 | £19,500 | £19,000 | £18,500 | £18,000 | £17,500 | £17,000 |
| Total Liabilities | £26,716 | £57,839 | £57,337 | £58,187 | £57,684 | £57,181 | £69,076 | £68,573 | £68,070 | £87,303 | £86,800 | £82,478 | £84,280 |
| Paid-in Capital | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Retained Earnings | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 |
| Earnings | £0 | £2,842 | £5,687 | £7,135 | £8,586 | £10,039 | £11,821 | £13,606 | £15,394 | £24,269 | £33,147 | £39,166 | £46,916 |
| Total Capital | £50,222 | £53,064 | £55,909 | £57,357 | £58,808 | £60,261 | £62,043 | £63,828 | £65,616 | £74,491 | £83,369 | £89,388 | £97,138 |
| Total Liabilities and Capital | £76,938 | £110,903 | £113,245 | £115,544 | £116,492 | £117,443 | £131,119 | £132,401 | £133,686 | £161,794 | £170,169 | £171,866 | £181,418 |
| Net Worth | £50,222 | £53,064 | £55,909 | £57,357 | £58,808 | £60,261 | £62,043 | £63,828 | £65,616 | £74,491 | £83,369 | £89,388 | £97,138 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Adult drivers | 0% | £14,000 | £14,000 | £14,000 | £14,000 | £14,000 | £20,000 | £20,000 | £20,000 | £24,000 | £25,000 | £21,000 | £23,000 |
| Beginner drivers | 0% | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £24,000 | £24,000 | £24,000 | £28,000 | £26,000 | £33,000 | £36,000 |
| Drivers under court order | 0% | £11,500 | £11,500 | £11,500 | £11,500 | £11,500 | £14,000 | £14,000 | £14,000 | £17,000 | £18,000 | £18,888 | £18,000 |
| High schools | 0% | £20,850 | £20,850 | £20,850 | £20,850 | £20,850 | £25,000 | £25,000 | £25,000 | £41,700 | £41,700 | £31,000 | £31,000 |
| Commercial drivers | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £64,350 | £64,350 | £64,350 | £64,350 | £64,350 | £83,000 | £83,000 | £83,000 | £110,700 | £110,700 | £103,888 | £108,000 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Adult drivers | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £8,000 | £8,000 | £8,000 | £9,600 | £10,000 | £8,400 | £9,200 | |
| Beginner drivers | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £9,600 | £9,600 | £9,600 | £11,200 | £10,400 | £13,200 | £14,400 | |
| Drivers under court order | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £5,600 | £5,600 | £5,600 | £6,800 | £7,200 | £7,555 | £7,200 | |
| High schools | £8,340 | £8,340 | £8,340 | £8,340 | £8,340 | £10,000 | £10,000 | £10,000 | £16,680 | £16,680 | £12,400 | £12,400 | |
| Commercial drivers | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £25,740 | £25,740 | £25,740 | £25,740 | £25,740 | £33,200 | £33,200 | £33,200 | £44,280 | £44,280 | £41,555 | £43,200 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| President and General Manager | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Controller | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Education Planner | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Education Coordinator | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Facilities Mangers | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Office Manager | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Marketing Executive (Contract work) | 0% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| Educators | 0% | £7,500 | £7,500 | £7,500 | £7,500 | £7,500 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 |
| Total People | 11 | 11 | 11 | 11 | 11 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | |
| Total Payroll | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| 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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £64,350 | £64,350 | £64,350 | £64,350 | £64,350 | £83,000 | £83,000 | £83,000 | £110,700 | £110,700 | £103,888 | £108,000 | |
| Direct Cost of Sales | £25,740 | £25,740 | £25,740 | £25,740 | £25,740 | £33,200 | £33,200 | £33,200 | £44,280 | £44,280 | £41,555 | £43,200 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £25,740 | £25,740 | £25,740 | £25,740 | £25,740 | £33,200 | £33,200 | £33,200 | £44,280 | £44,280 | £41,555 | £43,200 | |
| Gross Margin | £38,610 | £38,610 | £38,610 | £38,610 | £38,610 | £49,800 | £49,800 | £49,800 | £66,420 | £66,420 | £62,333 | £64,800 | |
| Gross Margin % | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
| Expenses | |||||||||||||
| Payroll | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | |
| Sales and Marketing and Other Expenses | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | £4,500 | £4,500 | £4,500 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Depreciation | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £400 | £400 | £400 | £400 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £400 | £400 | £400 | £600 | £600 | £600 | £600 | |
| Insurance | £600 | £600 | £600 | £600 | £600 | £1,200 | £1,200 | £1,200 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Rent | £2,000 | £2,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Payroll Taxes | 15% | £3,713 | £3,713 | £3,713 | £3,713 | £3,713 | £4,538 | £4,538 | £4,538 | £4,538 | £4,538 | £4,538 | £4,538 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £34,363 | £34,363 | £36,363 | £36,363 | £36,363 | £47,088 | £47,088 | £47,088 | £53,588 | £53,588 | £53,588 | £53,588 | |
| Profit Before Interest and Taxes | £4,248 | £4,248 | £2,248 | £2,248 | £2,248 | £2,713 | £2,713 | £2,713 | £12,833 | £12,833 | £8,745 | £11,213 | |
| EBITDA | £4,448 | £4,448 | £2,448 | £2,448 | £2,448 | £2,913 | £2,913 | £2,913 | £13,233 | £13,233 | £9,145 | £11,613 | |
| Interest Expense | £188 | £183 | £179 | £175 | £171 | £167 | £163 | £158 | £154 | £150 | £146 | £142 | |
| Taxes Incurred | £1,218 | £1,219 | £621 | £622 | £623 | £764 | £765 | £766 | £3,804 | £3,805 | £2,580 | £3,321 | |
| Net Profit | £2,842 | £2,845 | £1,448 | £1,451 | £1,454 | £1,782 | £1,785 | £1,788 | £8,875 | £8,878 | £6,020 | £7,750 | |
| Net Profit/Sales | 4.42% | 4.42% | 2.25% | 2.25% | 2.26% | 2.15% | 2.15% | 2.15% | 8.02% | 8.02% | 5.79% | 7.18% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £64,350 | £64,350 | £64,350 | £64,350 | £64,350 | £83,000 | £83,000 | £83,000 | £110,700 | £110,700 | £103,888 | £108,000 | |
| Subtotal Cash from Operations | £64,350 | £64,350 | £64,350 | £64,350 | £64,350 | £83,000 | £83,000 | £83,000 | £110,700 | £110,700 | £103,888 | £108,000 | |
| 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 | £64,350 | £64,350 | £64,350 | £64,350 | £64,350 | £83,000 | £83,000 | £83,000 | £110,700 | £110,700 | £103,888 | £108,000 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | £30,250 | |
| Bill Payments | £4,935 | £36,558 | £36,602 | £37,952 | £37,949 | £38,374 | £50,768 | £50,765 | £51,443 | £71,175 | £71,040 | £67,298 | |
| Subtotal Spent on Operations | £29,685 | £61,308 | £61,352 | £62,702 | £62,699 | £68,624 | £81,018 | £81,015 | £81,693 | £101,425 | £101,290 | £97,548 | |
| 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 | £30,185 | £61,808 | £61,852 | £63,202 | £63,199 | £69,124 | £81,518 | £81,515 | £82,193 | £101,925 | £101,790 | £98,048 | |
| Net Cash Flow | £34,165 | £2,542 | £2,498 | £1,148 | £1,151 | £13,876 | £1,482 | £1,485 | £28,507 | £8,775 | £2,098 | £9,952 | |
| Cash Balance | £47,103 | £49,645 | £52,144 | £53,292 | £54,443 | £68,319 | £69,801 | £71,286 | £99,794 | £108,569 | £110,666 | £120,618 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £12,938 | £47,103 | £49,645 | £52,144 | £53,292 | £54,443 | £68,319 | £69,801 | £71,286 | £99,794 | £108,569 | £110,666 | £120,618 |
| Other Current Assets | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Total Current Assets | £14,938 | £49,103 | £51,645 | £54,144 | £55,292 | £56,443 | £70,319 | £71,801 | £73,286 | £101,794 | £110,569 | £112,666 | £122,618 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 | £74,000 |
| Accumulated Depreciation | £12,000 | £12,200 | £12,400 | £12,600 | £12,800 | £13,000 | £13,200 | £13,400 | £13,600 | £14,000 | £14,400 | £14,800 | £15,200 |
| Total Long-term Assets | £62,000 | £61,800 | £61,600 | £61,400 | £61,200 | £61,000 | £60,800 | £60,600 | £60,400 | £60,000 | £59,600 | £59,200 | £58,800 |
| Total Assets | £76,938 | £110,903 | £113,245 | £115,544 | £116,492 | £117,443 | £131,119 | £132,401 | £133,686 | £161,794 | £170,169 | £171,866 | £181,418 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £3,716 | £35,339 | £35,337 | £36,687 | £36,684 | £36,681 | £49,076 | £49,073 | £49,070 | £68,803 | £68,800 | £64,978 | £67,280 |
| 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 | £3,716 | £35,339 | £35,337 | £36,687 | £36,684 | £36,681 | £49,076 | £49,073 | £49,070 | £68,803 | £68,800 | £64,978 | £67,280 |
| Long-term Liabilities | £23,000 | £22,500 | £22,000 | £21,500 | £21,000 | £20,500 | £20,000 | £19,500 | £19,000 | £18,500 | £18,000 | £17,500 | £17,000 |
| Total Liabilities | £26,716 | £57,839 | £57,337 | £58,187 | £57,684 | £57,181 | £69,076 | £68,573 | £68,070 | £87,303 | £86,800 | £82,478 | £84,280 |
| Paid-in Capital | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Retained Earnings | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 | £20,222 |
| Earnings | £0 | £2,842 | £5,687 | £7,135 | £8,586 | £10,039 | £11,821 | £13,606 | £15,394 | £24,269 | £33,147 | £39,166 | £46,916 |
| Total Capital | £50,222 | £53,064 | £55,909 | £57,357 | £58,808 | £60,261 | £62,043 | £63,828 | £65,616 | £74,491 | £83,369 | £89,388 | £97,138 |
| Total Liabilities and Capital | £76,938 | £110,903 | £113,245 | £115,544 | £116,492 | £117,443 | £131,119 | £132,401 | £133,686 | £161,794 | £170,169 | £171,866 | £181,418 |
| Net Worth | £50,222 | £53,064 | £55,909 | £57,357 | £58,808 | £60,261 | £62,043 | £63,828 | £65,616 | £74,491 | £83,369 | £89,388 | £97,138 |