| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| New Construction | 0% | £12,170 | £13,170 | £17,909 | £19,539 | £21,777 | £21,410 | £27,615 | £28,966 | £28,366 | £23,163 | £18,842 | £14,635 |
| Repair work | 0% | £12,777 | £14,555 | £16,909 | £19,539 | £20,285 | £21,410 | £25,615 | £33,111 | £28,366 | £23,163 | £18,842 | £15,842 |
| Alteration work | 0% | £14,222 | £12,170 | £16,909 | £19,539 | £20,285 | £21,410 | £25,615 | £30,861 | £28,366 | £23,163 | £18,842 | £14,378 |
| Total Sales | £39,169 | £39,895 | £51,727 | £58,617 | £62,347 | £64,230 | £78,845 | £92,938 | £85,098 | £69,489 | £56,526 | £44,855 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| New Construction | £8,580 | £9,285 | £12,626 | £13,775 | £15,353 | £15,094 | £19,469 | £20,421 | £19,998 | £17,372 | £13,849 | £10,976 | |
| Repair work | £9,008 | £10,261 | £11,921 | £15,338 | £15,924 | £15,094 | £18,059 | £23,343 | £21,275 | £16,330 | £13,284 | £11,169 | |
| Alteration work | £10,027 | £8,580 | £11,921 | £15,338 | £15,924 | £15,094 | £18,059 | £21,757 | £21,275 | £16,330 | £13,284 | £10,136 | |
| Subtotal Direct Cost of Sales | £27,614 | £28,126 | £36,468 | £44,451 | £47,200 | £45,282 | £55,586 | £65,521 | £62,547 | £50,032 | £40,416 | £32,281 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Mr. Robert Fosse, CEO | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Mr. David West, General Project Manager | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Mrs. Janet Fosse, 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 |
| Job Supervisor | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Temporary employees | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Total People | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
| Total Payroll | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | |
| 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 | £39,169 | £39,895 | £51,727 | £58,617 | £62,347 | £64,230 | £78,845 | £92,938 | £85,098 | £69,489 | £56,526 | £44,855 | |
| Direct Cost of Sales | £27,614 | £28,126 | £36,468 | £44,451 | £47,200 | £45,282 | £55,586 | £65,521 | £62,547 | £50,032 | £40,416 | £32,281 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £27,614 | £28,126 | £36,468 | £44,451 | £47,200 | £45,282 | £55,586 | £65,521 | £62,547 | £50,032 | £40,416 | £32,281 | |
| Gross Margin | £11,555 | £11,769 | £15,259 | £14,166 | £15,147 | £18,948 | £23,259 | £27,417 | £22,551 | £19,457 | £16,110 | £12,574 | |
| Gross Margin % | 29.50% | 29.50% | 29.50% | 24.17% | 24.29% | 29.50% | 29.50% | 29.50% | 26.50% | 28.00% | 28.50% | 28.03% | |
| Expenses | |||||||||||||
| Payroll | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | |
| Sales and Marketing and Other Expenses | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Payroll Taxes | 15% | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 |
| Other | £0 | £200 | £500 | £0 | £500 | £0 | £0 | £500 | £500 | £0 | £0 | £0 | |
| Total Operating Expenses | £17,860 | £18,060 | £18,360 | £17,860 | £18,360 | £17,860 | £17,860 | £18,360 | £18,360 | £17,860 | £17,860 | £17,860 | |
| Profit Before Interest and Taxes | (£6,305) | (£6,291) | (£3,101) | (£3,694) | (£3,213) | £1,088 | £5,399 | £9,057 | £4,191 | £1,597 | (£1,750) | (£5,286) | |
| EBITDA | (£6,305) | (£6,291) | (£3,101) | (£3,694) | (£3,213) | £1,088 | £5,399 | £9,057 | £4,191 | £1,597 | (£1,750) | (£5,286) | |
| Interest Expense | £320 | £314 | £309 | £304 | £299 | £294 | £289 | £284 | £279 | £274 | £269 | £264 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£6,625) | (£6,605) | (£3,410) | (£3,999) | (£3,512) | £794 | £5,111 | £8,773 | £3,912 | £1,323 | (£2,019) | (£5,550) | |
| Net Profit/Sales | -16.92% | -16.56% | -6.59% | -6.82% | -5.63% | 1.24% | 6.48% | 9.44% | 4.60% | 1.90% | -3.57% | -12.37% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £25,460 | £25,932 | £33,623 | £38,101 | £40,526 | £41,750 | £51,249 | £60,410 | £55,314 | £45,168 | £36,742 | £29,156 | |
| Cash from Receivables | £11,579 | £12,035 | £13,718 | £14,101 | £18,185 | £20,559 | £21,843 | £22,651 | £27,760 | £32,437 | £29,602 | £24,170 | |
| Subtotal Cash from Operations | £37,038 | £37,967 | £47,340 | £52,202 | £58,710 | £62,309 | £73,093 | £83,061 | £83,074 | £77,605 | £66,344 | £53,326 | |
| 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 | £37,038 | £37,967 | £47,340 | £52,202 | £58,710 | £62,309 | £73,093 | £83,061 | £83,074 | £77,605 | £66,344 | £53,326 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | |
| Bill Payments | £25,998 | £18,420 | £32,638 | £49,549 | £56,314 | £53,631 | £47,117 | £70,403 | £79,521 | £62,130 | £39,185 | £32,750 | |
| Subtotal Spent on Operations | £40,998 | £33,420 | £47,638 | £64,549 | £71,314 | £68,631 | £62,117 | £85,403 | £94,521 | £77,130 | £54,185 | £47,750 | |
| 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 | £400 | £500 | £400 | £400 | £500 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| 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 | £41,598 | £34,120 | £48,238 | £65,149 | £72,014 | £69,231 | £62,717 | £86,003 | £95,121 | £77,730 | £54,785 | £48,350 | |
| Net Cash Flow | (£4,560) | £3,847 | (£898) | (£12,947) | (£13,304) | (£6,922) | £10,375 | (£2,942) | (£12,048) | (£125) | £11,559 | £4,976 | |
| Cash Balance | £35,868 | £39,715 | £38,816 | £25,870 | £12,566 | £5,644 | £16,020 | £13,078 | £1,030 | £905 | £12,464 | £17,440 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £40,428 | £35,868 | £39,715 | £38,816 | £25,870 | £12,566 | £5,644 | £16,020 | £13,078 | £1,030 | £905 | £12,464 | £17,440 |
| Accounts Receivable | £23,157 | £25,288 | £27,215 | £31,602 | £38,017 | £41,654 | £43,575 | £49,327 | £59,204 | £61,228 | £53,113 | £43,295 | £34,824 |
| Inventory | £43,220 | £30,376 | £30,939 | £40,114 | £48,896 | £51,920 | £49,810 | £61,144 | £72,073 | £68,802 | £55,035 | £44,458 | £35,509 |
| Other Current Assets | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 |
| Total Current Assets | £144,796 | £129,522 | £135,860 | £148,524 | £150,774 | £144,131 | £137,020 | £164,482 | £182,347 | £169,051 | £147,044 | £138,207 | £125,764 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 |
| Accumulated Depreciation | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Total Long-term Assets | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 |
| Total Assets | £157,217 | £141,943 | £148,281 | £160,945 | £163,195 | £156,552 | £149,441 | £176,903 | £194,768 | £181,472 | £159,465 | £150,628 | £138,185 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £25,400 | £17,352 | £30,995 | £47,669 | £54,518 | £52,087 | £44,782 | £67,733 | £77,424 | £60,817 | £38,086 | £31,868 | £25,575 |
| Current Borrowing | £20,000 | £19,600 | £19,100 | £18,700 | £18,300 | £17,800 | £17,400 | £17,000 | £16,600 | £16,200 | £15,800 | £15,400 | £15,000 |
| Other Current Liabilities | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 |
| Subtotal Current Liabilities | £67,077 | £58,629 | £71,772 | £88,046 | £94,495 | £91,564 | £83,859 | £106,410 | £115,701 | £98,694 | £75,563 | £68,945 | £62,252 |
| Long-term Liabilities | £19,039 | £18,839 | £18,639 | £18,439 | £18,239 | £18,039 | £17,839 | £17,639 | £17,439 | £17,239 | £17,039 | £16,839 | £16,639 |
| Total Liabilities | £86,116 | £77,468 | £90,411 | £106,485 | £112,734 | £109,603 | £101,698 | £124,049 | £133,140 | £115,933 | £92,602 | £85,784 | £78,891 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 |
| Earnings | £0 | (£6,625) | (£13,231) | (£16,641) | (£20,640) | (£24,152) | (£23,357) | (£18,247) | (£9,474) | (£5,561) | (£4,238) | (£6,257) | (£11,807) |
| Total Capital | £71,101 | £64,476 | £57,870 | £54,460 | £50,461 | £46,949 | £47,744 | £52,854 | £61,627 | £65,540 | £66,863 | £64,844 | £59,294 |
| Total Liabilities and Capital | £157,217 | £141,943 | £148,281 | £160,945 | £163,195 | £156,552 | £149,441 | £176,903 | £194,768 | £181,472 | £159,465 | £150,628 | £138,185 |
| Net Worth | £71,101 | £64,476 | £57,870 | £54,460 | £50,461 | £46,949 | £47,744 | £52,854 | £61,627 | £65,540 | £66,863 | £64,844 | £59,294 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| New Construction | 0% | £12,170 | £13,170 | £17,909 | £19,539 | £21,777 | £21,410 | £27,615 | £28,966 | £28,366 | £23,163 | £18,842 | £14,635 |
| Repair work | 0% | £12,777 | £14,555 | £16,909 | £19,539 | £20,285 | £21,410 | £25,615 | £33,111 | £28,366 | £23,163 | £18,842 | £15,842 |
| Alteration work | 0% | £14,222 | £12,170 | £16,909 | £19,539 | £20,285 | £21,410 | £25,615 | £30,861 | £28,366 | £23,163 | £18,842 | £14,378 |
| Total Sales | £39,169 | £39,895 | £51,727 | £58,617 | £62,347 | £64,230 | £78,845 | £92,938 | £85,098 | £69,489 | £56,526 | £44,855 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| New Construction | £8,580 | £9,285 | £12,626 | £13,775 | £15,353 | £15,094 | £19,469 | £20,421 | £19,998 | £17,372 | £13,849 | £10,976 | |
| Repair work | £9,008 | £10,261 | £11,921 | £15,338 | £15,924 | £15,094 | £18,059 | £23,343 | £21,275 | £16,330 | £13,284 | £11,169 | |
| Alteration work | £10,027 | £8,580 | £11,921 | £15,338 | £15,924 | £15,094 | £18,059 | £21,757 | £21,275 | £16,330 | £13,284 | £10,136 | |
| Subtotal Direct Cost of Sales | £27,614 | £28,126 | £36,468 | £44,451 | £47,200 | £45,282 | £55,586 | £65,521 | £62,547 | £50,032 | £40,416 | £32,281 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Mr. Robert Fosse, CEO | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Mr. David West, General Project Manager | 0% | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Mrs. Janet Fosse, 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 |
| Job Supervisor | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Temporary employees | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Total People | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
| Total Payroll | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | |
| 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 | £39,169 | £39,895 | £51,727 | £58,617 | £62,347 | £64,230 | £78,845 | £92,938 | £85,098 | £69,489 | £56,526 | £44,855 | |
| Direct Cost of Sales | £27,614 | £28,126 | £36,468 | £44,451 | £47,200 | £45,282 | £55,586 | £65,521 | £62,547 | £50,032 | £40,416 | £32,281 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £27,614 | £28,126 | £36,468 | £44,451 | £47,200 | £45,282 | £55,586 | £65,521 | £62,547 | £50,032 | £40,416 | £32,281 | |
| Gross Margin | £11,555 | £11,769 | £15,259 | £14,166 | £15,147 | £18,948 | £23,259 | £27,417 | £22,551 | £19,457 | £16,110 | £12,574 | |
| Gross Margin % | 29.50% | 29.50% | 29.50% | 24.17% | 24.29% | 29.50% | 29.50% | 29.50% | 26.50% | 28.00% | 28.50% | 28.03% | |
| Expenses | |||||||||||||
| Payroll | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | |
| Sales and Marketing and Other Expenses | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Payroll Taxes | 15% | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 |
| Other | £0 | £200 | £500 | £0 | £500 | £0 | £0 | £500 | £500 | £0 | £0 | £0 | |
| Total Operating Expenses | £17,860 | £18,060 | £18,360 | £17,860 | £18,360 | £17,860 | £17,860 | £18,360 | £18,360 | £17,860 | £17,860 | £17,860 | |
| Profit Before Interest and Taxes | (£6,305) | (£6,291) | (£3,101) | (£3,694) | (£3,213) | £1,088 | £5,399 | £9,057 | £4,191 | £1,597 | (£1,750) | (£5,286) | |
| EBITDA | (£6,305) | (£6,291) | (£3,101) | (£3,694) | (£3,213) | £1,088 | £5,399 | £9,057 | £4,191 | £1,597 | (£1,750) | (£5,286) | |
| Interest Expense | £320 | £314 | £309 | £304 | £299 | £294 | £289 | £284 | £279 | £274 | £269 | £264 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£6,625) | (£6,605) | (£3,410) | (£3,999) | (£3,512) | £794 | £5,111 | £8,773 | £3,912 | £1,323 | (£2,019) | (£5,550) | |
| Net Profit/Sales | -16.92% | -16.56% | -6.59% | -6.82% | -5.63% | 1.24% | 6.48% | 9.44% | 4.60% | 1.90% | -3.57% | -12.37% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £25,460 | £25,932 | £33,623 | £38,101 | £40,526 | £41,750 | £51,249 | £60,410 | £55,314 | £45,168 | £36,742 | £29,156 | |
| Cash from Receivables | £11,579 | £12,035 | £13,718 | £14,101 | £18,185 | £20,559 | £21,843 | £22,651 | £27,760 | £32,437 | £29,602 | £24,170 | |
| Subtotal Cash from Operations | £37,038 | £37,967 | £47,340 | £52,202 | £58,710 | £62,309 | £73,093 | £83,061 | £83,074 | £77,605 | £66,344 | £53,326 | |
| 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 | £37,038 | £37,967 | £47,340 | £52,202 | £58,710 | £62,309 | £73,093 | £83,061 | £83,074 | £77,605 | £66,344 | £53,326 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | |
| Bill Payments | £25,998 | £18,420 | £32,638 | £49,549 | £56,314 | £53,631 | £47,117 | £70,403 | £79,521 | £62,130 | £39,185 | £32,750 | |
| Subtotal Spent on Operations | £40,998 | £33,420 | £47,638 | £64,549 | £71,314 | £68,631 | £62,117 | £85,403 | £94,521 | £77,130 | £54,185 | £47,750 | |
| 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 | £400 | £500 | £400 | £400 | £500 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| 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 | £41,598 | £34,120 | £48,238 | £65,149 | £72,014 | £69,231 | £62,717 | £86,003 | £95,121 | £77,730 | £54,785 | £48,350 | |
| Net Cash Flow | (£4,560) | £3,847 | (£898) | (£12,947) | (£13,304) | (£6,922) | £10,375 | (£2,942) | (£12,048) | (£125) | £11,559 | £4,976 | |
| Cash Balance | £35,868 | £39,715 | £38,816 | £25,870 | £12,566 | £5,644 | £16,020 | £13,078 | £1,030 | £905 | £12,464 | £17,440 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £40,428 | £35,868 | £39,715 | £38,816 | £25,870 | £12,566 | £5,644 | £16,020 | £13,078 | £1,030 | £905 | £12,464 | £17,440 |
| Accounts Receivable | £23,157 | £25,288 | £27,215 | £31,602 | £38,017 | £41,654 | £43,575 | £49,327 | £59,204 | £61,228 | £53,113 | £43,295 | £34,824 |
| Inventory | £43,220 | £30,376 | £30,939 | £40,114 | £48,896 | £51,920 | £49,810 | £61,144 | £72,073 | £68,802 | £55,035 | £44,458 | £35,509 |
| Other Current Assets | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 | £37,991 |
| Total Current Assets | £144,796 | £129,522 | £135,860 | £148,524 | £150,774 | £144,131 | £137,020 | £164,482 | £182,347 | £169,051 | £147,044 | £138,207 | £125,764 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 | £20,421 |
| Accumulated Depreciation | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Total Long-term Assets | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 | £12,421 |
| Total Assets | £157,217 | £141,943 | £148,281 | £160,945 | £163,195 | £156,552 | £149,441 | £176,903 | £194,768 | £181,472 | £159,465 | £150,628 | £138,185 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £25,400 | £17,352 | £30,995 | £47,669 | £54,518 | £52,087 | £44,782 | £67,733 | £77,424 | £60,817 | £38,086 | £31,868 | £25,575 |
| Current Borrowing | £20,000 | £19,600 | £19,100 | £18,700 | £18,300 | £17,800 | £17,400 | £17,000 | £16,600 | £16,200 | £15,800 | £15,400 | £15,000 |
| Other Current Liabilities | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 | £21,677 |
| Subtotal Current Liabilities | £67,077 | £58,629 | £71,772 | £88,046 | £94,495 | £91,564 | £83,859 | £106,410 | £115,701 | £98,694 | £75,563 | £68,945 | £62,252 |
| Long-term Liabilities | £19,039 | £18,839 | £18,639 | £18,439 | £18,239 | £18,039 | £17,839 | £17,639 | £17,439 | £17,239 | £17,039 | £16,839 | £16,639 |
| Total Liabilities | £86,116 | £77,468 | £90,411 | £106,485 | £112,734 | £109,603 | £101,698 | £124,049 | £133,140 | £115,933 | £92,602 | £85,784 | £78,891 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 | £71,101 |
| Earnings | £0 | (£6,625) | (£13,231) | (£16,641) | (£20,640) | (£24,152) | (£23,357) | (£18,247) | (£9,474) | (£5,561) | (£4,238) | (£6,257) | (£11,807) |
| Total Capital | £71,101 | £64,476 | £57,870 | £54,460 | £50,461 | £46,949 | £47,744 | £52,854 | £61,627 | £65,540 | £66,863 | £64,844 | £59,294 |
| Total Liabilities and Capital | £157,217 | £141,943 | £148,281 | £160,945 | £163,195 | £156,552 | £149,441 | £176,903 | £194,768 | £181,472 | £159,465 | £150,628 | £138,185 |
| Net Worth | £71,101 | £64,476 | £57,870 | £54,460 | £50,461 | £46,949 | £47,744 | £52,854 | £61,627 | £65,540 | £66,863 | £64,844 | £59,294 |