| Sales Forecast | |||||||||||||
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | ||
| Sales | |||||||||||||
| Row 1 | 0% | £69,525 | £99,100 | £125,175 | £146,450 | £164,425 | £188,600 | £201,650 | £214,600 | £222,150 | £242,400 | £264,400 | £278,900 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £69,525 | £99,100 | £125,175 | £146,450 | £164,425 | £188,600 | £201,650 | £214,600 | £222,150 | £242,400 | £264,400 | £278,900 | |
| Direct Cost of Sales | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | |
| Row 1 | £29,200 | £44,595 | £52,573 | £65,902 | £75,635 | £90,528 | £96,792 | £92,278 | £95,524 | £104,232 | £111,048 | £117,138 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £29,200 | £44,595 | £52,573 | £65,902 | £75,635 | £90,528 | £96,792 | £92,278 | £95,524 | £104,232 | £111,048 | £117,138 | |
| Personnel Plan | |||||||||||||
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | ||
| Manufacturing | 0% | £13,282 | £13,282 | £13,282 | £15,760 | £18,920 | £18,920 | £18,920 | £19,500 | £19,500 | £19,500 | £21,580 | £21,580 |
| Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £15,000 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 9 | 9 | 9 | 9 | 11 | |
| Total Payroll | £13,282 | £13,282 | £13,282 | £15,760 | £18,920 | £18,920 | £18,920 | £19,500 | £19,500 | £19,500 | £21,580 | £36,580 | |
| General Assumptions | |||||||||||||
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | ||
| 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 | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | ||
| Sales | £69,525 | £99,100 | £125,175 | £146,450 | £164,425 | £188,600 | £201,650 | £214,600 | £222,150 | £242,400 | £264,400 | £278,900 | |
| Direct Cost of Sales | £29,200 | £44,595 | £52,573 | £65,902 | £75,635 | £90,528 | £96,792 | £92,278 | £95,524 | £104,232 | £111,048 | £117,138 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £29,200 | £44,595 | £52,573 | £65,902 | £75,635 | £90,528 | £96,792 | £92,278 | £95,524 | £104,232 | £111,048 | £117,138 | |
| Gross Margin | £40,325 | £54,505 | £72,602 | £80,548 | £88,790 | £98,072 | £104,858 | £122,322 | £126,626 | £138,168 | £153,352 | £161,762 | |
| Gross Margin % | 58.00% | 55.00% | 58.00% | 55.00% | 54.00% | 52.00% | 52.00% | 57.00% | 57.00% | 57.00% | 58.00% | 58.00% | |
| Expenses | |||||||||||||
| Payroll | £13,282 | £13,282 | £13,282 | £15,760 | £18,920 | £18,920 | £18,920 | £19,500 | £19,500 | £19,500 | £21,580 | £36,580 | |
| Sales and Marketing and Other Expenses | £1,400 | £1,400 | £2,000 | £2,500 | £4,000 | £1,500 | £2,000 | £1,500 | £27,000 | £27,500 | £27,000 | £7,000 | |
| Depreciation | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Leased Equipment | £931 | £931 | £931 | £931 | £931 | £931 | £931 | £931 | £931 | £931 | £931 | £931 | |
| Utilities | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Insurance | £285 | £285 | £285 | £285 | £285 | £285 | £285 | £310 | £310 | £310 | £310 | £310 | |
| Rent | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | |
| Payroll Taxes | 15% | £1,992 | £1,992 | £1,992 | £2,364 | £2,838 | £2,838 | £2,838 | £2,925 | £2,925 | £2,925 | £3,237 | £5,487 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £24,340 | £24,340 | £24,940 | £28,290 | £33,424 | £30,924 | £31,424 | £31,616 | £57,116 | £57,616 | £59,508 | £56,758 | |
| Profit Before Interest and Taxes | £15,985 | £30,165 | £47,662 | £52,258 | £55,366 | £67,148 | £73,434 | £90,706 | £69,510 | £80,552 | £93,844 | £105,004 | |
| EBITDA | £18,985 | £33,165 | £50,662 | £55,258 | £58,366 | £70,148 | £76,434 | £93,706 | £72,510 | £83,552 | £96,844 | £108,004 | |
| Interest Expense | £2,785 | £2,805 | £2,825 | £2,845 | £2,865 | £2,885 | £2,905 | £2,925 | £2,945 | £2,965 | £2,985 | £3,005 | |
| Taxes Incurred | £3,300 | £6,840 | £11,209 | £12,353 | £13,125 | £16,066 | £17,632 | £21,945 | £16,641 | £19,397 | £22,715 | £25,500 | |
| Net Profit | £9,900 | £20,520 | £33,627 | £37,060 | £39,376 | £48,197 | £52,897 | £65,836 | £49,924 | £58,190 | £68,144 | £76,500 | |
| Net Profit/Sales | 14.24% | 20.71% | 26.86% | 25.31% | 23.95% | 25.56% | 26.23% | 30.68% | 22.47% | 24.01% | 25.77% | 27.43% | |
| Pro Forma Cash Flow | |||||||||||||
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £6,953 | £9,910 | £12,518 | £14,645 | £16,443 | £18,860 | £20,165 | £21,460 | £22,215 | £24,240 | £26,440 | £27,890 | |
| Cash from Receivables | £7,750 | £9,836 | £63,460 | £89,972 | £113,296 | £132,344 | £148,708 | £170,132 | £181,874 | £193,367 | £200,543 | £218,820 | |
| Subtotal Cash from Operations | £14,703 | £19,746 | £75,977 | £104,617 | £129,738 | £151,204 | £168,873 | £191,592 | £204,089 | £217,607 | £226,983 | £246,710 | |
| 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) | £3,000 | £2,500 | £2,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| 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 | £75,000 | £0 | £0 | £300,000 | £0 | £0 | £0 | £500,000 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £97,703 | £27,246 | £82,977 | £409,617 | £134,738 | £156,204 | £173,873 | £696,592 | £209,089 | £222,607 | £231,983 | £251,710 | |
| Expenditures | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £13,282 | £13,282 | £13,282 | £15,760 | £18,920 | £18,920 | £18,920 | £19,500 | £19,500 | £19,500 | £21,580 | £36,580 | |
| Bill Payments | £28,399 | £57,345 | £79,393 | £84,750 | £105,577 | £114,537 | £134,827 | £133,309 | £122,365 | £153,896 | £171,551 | £178,851 | |
| Subtotal Spent on Operations | £41,681 | £70,627 | £92,675 | £100,510 | £124,497 | £133,457 | £153,747 | £152,809 | £141,865 | £173,396 | £193,131 | £215,431 | |
| 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 | £607 | £607 | £607 | £607 | £607 | £607 | £607 | £607 | £607 | £607 | £607 | £614 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Long-term Liabilities Principal Repayment | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Purchase Other Current Assets | £0 | £0 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £44,288 | £73,234 | £100,282 | £119,117 | £143,104 | £152,064 | £172,354 | £171,416 | £150,472 | £182,003 | £201,738 | £219,045 | |
| Net Cash Flow | £53,414 | (£45,988) | (£17,305) | £290,500 | (£8,366) | £4,141 | £1,519 | £525,175 | £58,616 | £40,603 | £30,244 | £32,665 | |
| Cash Balance | £65,414 | £19,426 | £2,121 | £292,621 | £284,256 | £288,396 | £289,915 | £815,090 | £873,706 | £914,309 | £944,554 | £977,218 | |
| Pro Forma Balance Sheet | |||||||||||||
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £12,000 | £65,414 | £19,426 | £2,121 | £292,621 | £284,256 | £288,396 | £289,915 | £815,090 | £873,706 | £914,309 | £944,554 | £977,218 |
| Accounts Receivable | £15,500 | £70,323 | £149,677 | £198,875 | £240,707 | £275,394 | £312,790 | £345,567 | £368,576 | £386,637 | £411,431 | £448,848 | £481,038 |
| Inventory | £18,873 | £32,120 | £49,055 | £57,830 | £72,492 | £83,199 | £99,581 | £106,471 | £101,506 | £105,076 | £114,655 | £122,153 | £128,852 |
| Other Current Assets | £0 | £0 | £0 | £5,000 | £10,000 | £15,000 | £20,000 | £25,000 | £30,000 | £35,000 | £40,000 | £45,000 | £45,000 |
| Total Current Assets | £46,373 | £167,857 | £218,157 | £263,826 | £615,821 | £657,848 | £720,767 | £766,953 | £1,315,171 | £1,400,420 | £1,480,395 | £1,560,554 | £1,632,108 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £149,118 | £149,118 | £149,118 | £149,118 | £159,118 | £169,118 | £179,118 | £189,118 | £199,118 | £199,118 | £199,118 | £199,118 | £199,118 |
| Accumulated Depreciation | £23,605 | £26,605 | £29,605 | £32,605 | £35,605 | £38,605 | £41,605 | £44,605 | £47,605 | £50,605 | £53,605 | £56,605 | £59,605 |
| Total Long-term Assets | £125,513 | £122,513 | £119,513 | £116,513 | £123,513 | £130,513 | £137,513 | £144,513 | £151,513 | £148,513 | £145,513 | £142,513 | £139,513 |
| Total Assets | £171,886 | £290,370 | £337,670 | £380,339 | £739,334 | £788,361 | £858,280 | £911,466 | £1,466,684 | £1,548,933 | £1,625,908 | £1,703,067 | £1,771,621 |
| Liabilities and Capital | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £26,513 | £54,704 | £76,592 | £81,240 | £101,782 | £110,041 | £130,370 | £129,266 | £117,255 | £148,187 | £165,579 | £173,201 | £163,869 |
| Current Borrowing | £7,291 | £6,684 | £6,077 | £5,470 | £4,863 | £4,256 | £3,649 | £3,042 | £2,435 | £1,828 | £1,221 | £614 | £0 |
| Other Current Liabilities | £43,503 | £46,503 | £49,003 | £51,003 | £50,003 | £49,003 | £48,003 | £47,003 | £46,003 | £45,003 | £44,003 | £43,003 | £42,003 |
| Subtotal Current Liabilities | £77,307 | £107,891 | £131,672 | £137,713 | £156,648 | £163,300 | £182,022 | £179,311 | £165,693 | £195,018 | £210,803 | £216,818 | £205,872 |
| Long-term Liabilities | £324,550 | £327,550 | £330,550 | £333,550 | £336,550 | £339,550 | £342,550 | £345,550 | £348,550 | £351,550 | £354,550 | £357,550 | £360,550 |
| Total Liabilities | £401,857 | £435,441 | £462,222 | £471,263 | £493,198 | £502,850 | £524,572 | £524,861 | £514,243 | £546,568 | £565,353 | £574,368 | £566,422 |
| Paid-in Capital | £814,820 | £889,820 | £889,820 | £889,820 | £1,189,820 | £1,189,820 | £1,189,820 | £1,189,820 | £1,689,820 | £1,689,820 | £1,689,820 | £1,689,820 | £1,689,820 |
| Retained Earnings | (£877,599) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) |
| Earnings | (£167,192) | £9,900 | £30,419 | £64,047 | £101,106 | £140,482 | £188,679 | £241,576 | £307,412 | £357,336 | £415,526 | £483,671 | £560,170 |
| Total Capital | (£229,971) | (£145,071) | (£124,552) | (£90,924) | £246,135 | £285,511 | £333,708 | £386,605 | £952,441 | £1,002,365 | £1,060,555 | £1,128,700 | £1,205,199 |
| Total Liabilities and Capital | £171,886 | £290,370 | £337,670 | £380,339 | £739,334 | £788,361 | £858,280 | £911,466 | £1,466,684 | £1,548,933 | £1,625,908 | £1,703,067 | £1,771,621 |
| Net Worth | (£229,971) | (£145,071) | (£124,552) | (£90,924) | £246,135 | £285,511 | £333,708 | £386,605 | £952,441 | £1,002,365 | £1,060,555 | £1,128,700 | £1,205,199 |
| Sales Forecast | |||||||||||||
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | ||
| Sales | |||||||||||||
| Row 1 | 0% | £69,525 | £99,100 | £125,175 | £146,450 | £164,425 | £188,600 | £201,650 | £214,600 | £222,150 | £242,400 | £264,400 | £278,900 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £69,525 | £99,100 | £125,175 | £146,450 | £164,425 | £188,600 | £201,650 | £214,600 | £222,150 | £242,400 | £264,400 | £278,900 | |
| Direct Cost of Sales | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | |
| Row 1 | £29,200 | £44,595 | £52,573 | £65,902 | £75,635 | £90,528 | £96,792 | £92,278 | £95,524 | £104,232 | £111,048 | £117,138 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £29,200 | £44,595 | £52,573 | £65,902 | £75,635 | £90,528 | £96,792 | £92,278 | £95,524 | £104,232 | £111,048 | £117,138 | |
| Personnel Plan | |||||||||||||
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | ||
| Manufacturing | 0% | £13,282 | £13,282 | £13,282 | £15,760 | £18,920 | £18,920 | £18,920 | £19,500 | £19,500 | £19,500 | £21,580 | £21,580 |
| Sales | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £15,000 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 9 | 9 | 9 | 9 | 11 | |
| Total Payroll | £13,282 | £13,282 | £13,282 | £15,760 | £18,920 | £18,920 | £18,920 | £19,500 | £19,500 | £19,500 | £21,580 | £36,580 | |
| General Assumptions | |||||||||||||
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | ||
| 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 | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | ||
| Sales | £69,525 | £99,100 | £125,175 | £146,450 | £164,425 | £188,600 | £201,650 | £214,600 | £222,150 | £242,400 | £264,400 | £278,900 | |
| Direct Cost of Sales | £29,200 | £44,595 | £52,573 | £65,902 | £75,635 | £90,528 | £96,792 | £92,278 | £95,524 | £104,232 | £111,048 | £117,138 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £29,200 | £44,595 | £52,573 | £65,902 | £75,635 | £90,528 | £96,792 | £92,278 | £95,524 | £104,232 | £111,048 | £117,138 | |
| Gross Margin | £40,325 | £54,505 | £72,602 | £80,548 | £88,790 | £98,072 | £104,858 | £122,322 | £126,626 | £138,168 | £153,352 | £161,762 | |
| Gross Margin % | 58.00% | 55.00% | 58.00% | 55.00% | 54.00% | 52.00% | 52.00% | 57.00% | 57.00% | 57.00% | 58.00% | 58.00% | |
| Expenses | |||||||||||||
| Payroll | £13,282 | £13,282 | £13,282 | £15,760 | £18,920 | £18,920 | £18,920 | £19,500 | £19,500 | £19,500 | £21,580 | £36,580 | |
| Sales and Marketing and Other Expenses | £1,400 | £1,400 | £2,000 | £2,500 | £4,000 | £1,500 | £2,000 | £1,500 | £27,000 | £27,500 | £27,000 | £7,000 | |
| Depreciation | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Leased Equipment | £931 | £931 | £931 | £931 | £931 | £931 | £931 | £931 | £931 | £931 | £931 | £931 | |
| Utilities | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Insurance | £285 | £285 | £285 | £285 | £285 | £285 | £285 | £310 | £310 | £310 | £310 | £310 | |
| Rent | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | £2,450 | |
| Payroll Taxes | 15% | £1,992 | £1,992 | £1,992 | £2,364 | £2,838 | £2,838 | £2,838 | £2,925 | £2,925 | £2,925 | £3,237 | £5,487 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £24,340 | £24,340 | £24,940 | £28,290 | £33,424 | £30,924 | £31,424 | £31,616 | £57,116 | £57,616 | £59,508 | £56,758 | |
| Profit Before Interest and Taxes | £15,985 | £30,165 | £47,662 | £52,258 | £55,366 | £67,148 | £73,434 | £90,706 | £69,510 | £80,552 | £93,844 | £105,004 | |
| EBITDA | £18,985 | £33,165 | £50,662 | £55,258 | £58,366 | £70,148 | £76,434 | £93,706 | £72,510 | £83,552 | £96,844 | £108,004 | |
| Interest Expense | £2,785 | £2,805 | £2,825 | £2,845 | £2,865 | £2,885 | £2,905 | £2,925 | £2,945 | £2,965 | £2,985 | £3,005 | |
| Taxes Incurred | £3,300 | £6,840 | £11,209 | £12,353 | £13,125 | £16,066 | £17,632 | £21,945 | £16,641 | £19,397 | £22,715 | £25,500 | |
| Net Profit | £9,900 | £20,520 | £33,627 | £37,060 | £39,376 | £48,197 | £52,897 | £65,836 | £49,924 | £58,190 | £68,144 | £76,500 | |
| Net Profit/Sales | 14.24% | 20.71% | 26.86% | 25.31% | 23.95% | 25.56% | 26.23% | 30.68% | 22.47% | 24.01% | 25.77% | 27.43% | |
| Pro Forma Cash Flow | |||||||||||||
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £6,953 | £9,910 | £12,518 | £14,645 | £16,443 | £18,860 | £20,165 | £21,460 | £22,215 | £24,240 | £26,440 | £27,890 | |
| Cash from Receivables | £7,750 | £9,836 | £63,460 | £89,972 | £113,296 | £132,344 | £148,708 | £170,132 | £181,874 | £193,367 | £200,543 | £218,820 | |
| Subtotal Cash from Operations | £14,703 | £19,746 | £75,977 | £104,617 | £129,738 | £151,204 | £168,873 | £191,592 | £204,089 | £217,607 | £226,983 | £246,710 | |
| 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) | £3,000 | £2,500 | £2,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| New Long-term Liabilities | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| 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 | £75,000 | £0 | £0 | £300,000 | £0 | £0 | £0 | £500,000 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £97,703 | £27,246 | £82,977 | £409,617 | £134,738 | £156,204 | £173,873 | £696,592 | £209,089 | £222,607 | £231,983 | £251,710 | |
| Expenditures | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £13,282 | £13,282 | £13,282 | £15,760 | £18,920 | £18,920 | £18,920 | £19,500 | £19,500 | £19,500 | £21,580 | £36,580 | |
| Bill Payments | £28,399 | £57,345 | £79,393 | £84,750 | £105,577 | £114,537 | £134,827 | £133,309 | £122,365 | £153,896 | £171,551 | £178,851 | |
| Subtotal Spent on Operations | £41,681 | £70,627 | £92,675 | £100,510 | £124,497 | £133,457 | £153,747 | £152,809 | £141,865 | £173,396 | £193,131 | £215,431 | |
| 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 | £607 | £607 | £607 | £607 | £607 | £607 | £607 | £607 | £607 | £607 | £607 | £614 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Long-term Liabilities Principal Repayment | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Purchase Other Current Assets | £0 | £0 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £44,288 | £73,234 | £100,282 | £119,117 | £143,104 | £152,064 | £172,354 | £171,416 | £150,472 | £182,003 | £201,738 | £219,045 | |
| Net Cash Flow | £53,414 | (£45,988) | (£17,305) | £290,500 | (£8,366) | £4,141 | £1,519 | £525,175 | £58,616 | £40,603 | £30,244 | £32,665 | |
| Cash Balance | £65,414 | £19,426 | £2,121 | £292,621 | £284,256 | £288,396 | £289,915 | £815,090 | £873,706 | £914,309 | £944,554 | £977,218 | |
| Pro Forma Balance Sheet | |||||||||||||
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £12,000 | £65,414 | £19,426 | £2,121 | £292,621 | £284,256 | £288,396 | £289,915 | £815,090 | £873,706 | £914,309 | £944,554 | £977,218 |
| Accounts Receivable | £15,500 | £70,323 | £149,677 | £198,875 | £240,707 | £275,394 | £312,790 | £345,567 | £368,576 | £386,637 | £411,431 | £448,848 | £481,038 |
| Inventory | £18,873 | £32,120 | £49,055 | £57,830 | £72,492 | £83,199 | £99,581 | £106,471 | £101,506 | £105,076 | £114,655 | £122,153 | £128,852 |
| Other Current Assets | £0 | £0 | £0 | £5,000 | £10,000 | £15,000 | £20,000 | £25,000 | £30,000 | £35,000 | £40,000 | £45,000 | £45,000 |
| Total Current Assets | £46,373 | £167,857 | £218,157 | £263,826 | £615,821 | £657,848 | £720,767 | £766,953 | £1,315,171 | £1,400,420 | £1,480,395 | £1,560,554 | £1,632,108 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £149,118 | £149,118 | £149,118 | £149,118 | £159,118 | £169,118 | £179,118 | £189,118 | £199,118 | £199,118 | £199,118 | £199,118 | £199,118 |
| Accumulated Depreciation | £23,605 | £26,605 | £29,605 | £32,605 | £35,605 | £38,605 | £41,605 | £44,605 | £47,605 | £50,605 | £53,605 | £56,605 | £59,605 |
| Total Long-term Assets | £125,513 | £122,513 | £119,513 | £116,513 | £123,513 | £130,513 | £137,513 | £144,513 | £151,513 | £148,513 | £145,513 | £142,513 | £139,513 |
| Total Assets | £171,886 | £290,370 | £337,670 | £380,339 | £739,334 | £788,361 | £858,280 | £911,466 | £1,466,684 | £1,548,933 | £1,625,908 | £1,703,067 | £1,771,621 |
| Liabilities and Capital | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £26,513 | £54,704 | £76,592 | £81,240 | £101,782 | £110,041 | £130,370 | £129,266 | £117,255 | £148,187 | £165,579 | £173,201 | £163,869 |
| Current Borrowing | £7,291 | £6,684 | £6,077 | £5,470 | £4,863 | £4,256 | £3,649 | £3,042 | £2,435 | £1,828 | £1,221 | £614 | £0 |
| Other Current Liabilities | £43,503 | £46,503 | £49,003 | £51,003 | £50,003 | £49,003 | £48,003 | £47,003 | £46,003 | £45,003 | £44,003 | £43,003 | £42,003 |
| Subtotal Current Liabilities | £77,307 | £107,891 | £131,672 | £137,713 | £156,648 | £163,300 | £182,022 | £179,311 | £165,693 | £195,018 | £210,803 | £216,818 | £205,872 |
| Long-term Liabilities | £324,550 | £327,550 | £330,550 | £333,550 | £336,550 | £339,550 | £342,550 | £345,550 | £348,550 | £351,550 | £354,550 | £357,550 | £360,550 |
| Total Liabilities | £401,857 | £435,441 | £462,222 | £471,263 | £493,198 | £502,850 | £524,572 | £524,861 | £514,243 | £546,568 | £565,353 | £574,368 | £566,422 |
| Paid-in Capital | £814,820 | £889,820 | £889,820 | £889,820 | £1,189,820 | £1,189,820 | £1,189,820 | £1,189,820 | £1,689,820 | £1,689,820 | £1,689,820 | £1,689,820 | £1,689,820 |
| Retained Earnings | (£877,599) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) | (£1,044,791) |
| Earnings | (£167,192) | £9,900 | £30,419 | £64,047 | £101,106 | £140,482 | £188,679 | £241,576 | £307,412 | £357,336 | £415,526 | £483,671 | £560,170 |
| Total Capital | (£229,971) | (£145,071) | (£124,552) | (£90,924) | £246,135 | £285,511 | £333,708 | £386,605 | £952,441 | £1,002,365 | £1,060,555 | £1,128,700 | £1,205,199 |
| Total Liabilities and Capital | £171,886 | £290,370 | £337,670 | £380,339 | £739,334 | £788,361 | £858,280 | £911,466 | £1,466,684 | £1,548,933 | £1,625,908 | £1,703,067 | £1,771,621 |
| Net Worth | (£229,971) | (£145,071) | (£124,552) | (£90,924) | £246,135 | £285,511 | £333,708 | £386,605 | £952,441 | £1,002,365 | £1,060,555 | £1,128,700 | £1,205,199 |