| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| All Product Lines | 0% | £100,000 | £150,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £220,000 | £220,000 | £270,000 | £270,000 | £270,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £100,000 | £150,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £220,000 | £220,000 | £270,000 | £270,000 | £270,000 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| All Product Lines | £4,000 | £6,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,800 | £8,800 | £10,800 | £10,800 | £10,800 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £4,000 | £6,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,800 | £8,800 | £10,800 | £10,800 | £10,800 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| President | 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 |
| Vice president | 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 |
| Production manager | 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 |
| Workers | 0% | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | |
| Total Payroll | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,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% | 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 Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £25,000 | £37,500 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £55,000 | £55,000 | £67,500 | £67,500 | £67,500 | |
| Cash from Receivables | £25,000 | £27,500 | £76,250 | £113,750 | £150,000 | £150,000 | £150,000 | £150,000 | £150,500 | £165,000 | £166,250 | £202,500 | |
| Subtotal Cash from Operations | £50,000 | £65,000 | £126,250 | £163,750 | £200,000 | £200,000 | £200,000 | £205,000 | £205,500 | £232,500 | £233,750 | £270,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 | £150,000 | £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 | £200,000 | £65,000 | £126,250 | £163,750 | £200,000 | £200,000 | £200,000 | £205,000 | £205,500 | £232,500 | £233,750 | £270,000 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | |
| Bill Payments | £21,273 | £38,664 | £52,677 | £69,754 | £67,744 | £71,361 | £71,353 | £71,561 | £77,788 | £77,469 | £93,050 | £91,025 | |
| Subtotal Spent on Operations | £41,273 | £58,664 | £72,677 | £89,754 | £87,744 | £91,361 | £91,353 | £91,561 | £97,788 | £97,469 | £113,050 | £111,025 | |
| 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 | £0 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £46,273 | £64,955 | £78,968 | £96,045 | £94,035 | £97,652 | £97,644 | £97,852 | £104,079 | £103,760 | £119,341 | £117,316 | |
| Net Cash Flow | £153,727 | £45 | £47,282 | £67,705 | £105,965 | £102,348 | £102,356 | £107,148 | £101,421 | £128,740 | £114,409 | £152,684 | |
| Cash Balance | £193,727 | £193,772 | £241,054 | £308,759 | £414,724 | £517,071 | £619,427 | £726,575 | £827,997 | £956,737 | £1,071,146 | £1,223,829 | |
| Pro Forma Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £100,000 | £150,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £220,000 | £220,000 | £270,000 | £270,000 | £270,000 | |
| Direct Cost of Sales | £4,000 | £6,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,800 | £8,800 | £10,800 | £10,800 | £10,800 | |
| Other | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £500 | £500 | |
| Total Cost of Sales | £4,400 | £6,400 | £8,400 | £8,400 | £8,400 | £8,400 | £8,400 | £9,200 | £9,200 | £11,200 | £11,300 | £11,300 | |
| Gross Margin | £95,600 | £143,600 | £191,600 | £191,600 | £191,600 | £191,600 | £191,600 | £210,800 | £210,800 | £258,800 | £258,700 | £258,700 | |
| Gross Margin % | 95.60% | 95.73% | 95.80% | 95.80% | 95.80% | 95.80% | 95.80% | 95.82% | 95.82% | 95.85% | 95.81% | 95.81% | |
| Expenses | |||||||||||||
| Payroll | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | |
| Sales and Marketing and Other Expenses | £10,667 | £10,667 | £15,667 | £15,667 | £20,667 | £20,667 | £20,667 | £20,667 | £20,667 | £20,667 | £20,667 | £20,667 | |
| Depreciation | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Utilities | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
| Insurance | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Rent | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | |
| Payroll Taxes | 15% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £4,500 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £35,375 | £35,375 | £40,375 | £40,375 | £45,375 | £45,375 | £45,375 | £45,375 | £45,375 | £45,375 | £45,375 | £46,875 | |
| Profit Before Interest and Taxes | £60,225 | £108,225 | £151,225 | £151,225 | £146,225 | £146,225 | £146,225 | £165,425 | £165,425 | £213,425 | £213,325 | £211,825 | |
| EBITDA | £60,725 | £108,725 | £151,725 | £151,725 | £146,725 | £146,725 | £146,725 | £165,925 | £165,925 | £213,925 | £213,825 | £212,325 | |
| Interest Expense | £2,083 | £2,073 | £2,062 | £2,051 | £2,040 | £2,030 | £2,019 | £2,008 | £1,997 | £1,987 | £1,976 | £1,965 | |
| Taxes Incurred | £17,442 | £26,538 | £37,291 | £37,293 | £36,046 | £36,049 | £36,052 | £40,854 | £40,857 | £52,860 | £52,837 | £52,465 | |
| Net Profit | £40,699 | £79,614 | £111,872 | £111,880 | £108,139 | £108,147 | £108,155 | £122,563 | £122,571 | £158,579 | £158,512 | £157,395 | |
| Net Profit/Sales | 40.70% | 53.08% | 55.94% | 55.94% | 54.07% | 54.07% | 54.08% | 55.71% | 55.71% | 58.73% | 58.71% | 58.29% | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £40,000 | £193,727 | £193,772 | £241,054 | £308,759 | £414,724 | £517,071 | £619,427 | £726,575 | £827,997 | £956,737 | £1,071,146 | £1,223,829 |
| Accounts Receivable | £50,000 | £100,000 | £185,000 | £258,750 | £295,000 | £295,000 | £295,000 | £295,000 | £310,000 | £324,500 | £362,000 | £398,250 | £398,250 |
| Inventory | £5,000 | £4,400 | £6,600 | £8,800 | £8,800 | £8,800 | £8,800 | £8,800 | £9,680 | £9,680 | £11,880 | £11,880 | £11,880 |
| Other Current Assets | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 |
| Total Current Assets | £130,000 | £333,127 | £420,372 | £543,604 | £647,559 | £753,524 | £855,871 | £958,227 | £1,081,255 | £1,197,177 | £1,365,617 | £1,516,276 | £1,668,959 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £25,000 | £30,000 | £35,000 | £40,000 | £45,000 | £50,000 | £55,000 | £60,000 | £65,000 | £70,000 | £75,000 | £80,000 | £85,000 |
| Accumulated Depreciation | £5,000 | £5,500 | £6,000 | £6,500 | £7,000 | £7,500 | £8,000 | £8,500 | £9,000 | £9,500 | £10,000 | £10,500 | £11,000 |
| Total Long-term Assets | £20,000 | £24,500 | £29,000 | £33,500 | £38,000 | £42,500 | £47,000 | £51,500 | £56,000 | £60,500 | £65,000 | £69,500 | £74,000 |
| Total Assets | £150,000 | £357,627 | £449,372 | £577,104 | £685,559 | £796,024 | £902,871 | £1,009,727 | £1,137,255 | £1,257,677 | £1,430,617 | £1,585,776 | £1,742,959 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £20,000 | £36,927 | £50,349 | £67,500 | £65,366 | £68,983 | £68,975 | £68,967 | £75,223 | £74,365 | £90,017 | £87,955 | £89,035 |
| Current Borrowing | £0 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £20,000 | £186,927 | £200,349 | £217,500 | £215,366 | £218,983 | £218,975 | £218,967 | £225,223 | £224,365 | £240,017 | £237,955 | £239,035 |
| Long-term Liabilities | £100,000 | £100,000 | £98,709 | £97,418 | £96,127 | £94,836 | £93,545 | £92,254 | £90,963 | £89,672 | £88,381 | £87,090 | £85,799 |
| Total Liabilities | £120,000 | £286,927 | £299,058 | £314,918 | £311,493 | £313,819 | £312,520 | £311,221 | £316,186 | £314,037 | £328,398 | £325,045 | £324,834 |
| Paid-in Capital | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Retained Earnings | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Earnings | £0 | £40,699 | £120,313 | £232,186 | £344,066 | £452,205 | £560,351 | £668,506 | £791,069 | £913,640 | £1,072,219 | £1,230,730 | £1,388,125 |
| Total Capital | £30,000 | £70,699 | £150,313 | £262,186 | £374,066 | £482,205 | £590,351 | £698,506 | £821,069 | £943,640 | £1,102,219 | £1,260,730 | £1,418,125 |
| Total Liabilities and Capital | £150,000 | £357,627 | £449,372 | £577,104 | £685,559 | £796,024 | £902,871 | £1,009,727 | £1,137,255 | £1,257,677 | £1,430,617 | £1,585,776 | £1,742,959 |
| Net Worth | £30,000 | £70,699 | £150,313 | £262,186 | £374,066 | £482,205 | £590,351 | £698,506 | £821,069 | £943,640 | £1,102,219 | £1,260,730 | £1,418,125 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| All Product Lines | 0% | £100,000 | £150,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £220,000 | £220,000 | £270,000 | £270,000 | £270,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £100,000 | £150,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £220,000 | £220,000 | £270,000 | £270,000 | £270,000 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| All Product Lines | £4,000 | £6,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,800 | £8,800 | £10,800 | £10,800 | £10,800 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £4,000 | £6,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,800 | £8,800 | £10,800 | £10,800 | £10,800 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| President | 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 |
| Vice president | 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 |
| Production manager | 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 |
| Workers | 0% | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 | £11,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | |
| Total Payroll | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,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% | 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 Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £25,000 | £37,500 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £55,000 | £55,000 | £67,500 | £67,500 | £67,500 | |
| Cash from Receivables | £25,000 | £27,500 | £76,250 | £113,750 | £150,000 | £150,000 | £150,000 | £150,000 | £150,500 | £165,000 | £166,250 | £202,500 | |
| Subtotal Cash from Operations | £50,000 | £65,000 | £126,250 | £163,750 | £200,000 | £200,000 | £200,000 | £205,000 | £205,500 | £232,500 | £233,750 | £270,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 | £150,000 | £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 | £200,000 | £65,000 | £126,250 | £163,750 | £200,000 | £200,000 | £200,000 | £205,000 | £205,500 | £232,500 | £233,750 | £270,000 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | |
| Bill Payments | £21,273 | £38,664 | £52,677 | £69,754 | £67,744 | £71,361 | £71,353 | £71,561 | £77,788 | £77,469 | £93,050 | £91,025 | |
| Subtotal Spent on Operations | £41,273 | £58,664 | £72,677 | £89,754 | £87,744 | £91,361 | £91,353 | £91,561 | £97,788 | £97,469 | £113,050 | £111,025 | |
| 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 | £0 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | £1,291 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £46,273 | £64,955 | £78,968 | £96,045 | £94,035 | £97,652 | £97,644 | £97,852 | £104,079 | £103,760 | £119,341 | £117,316 | |
| Net Cash Flow | £153,727 | £45 | £47,282 | £67,705 | £105,965 | £102,348 | £102,356 | £107,148 | £101,421 | £128,740 | £114,409 | £152,684 | |
| Cash Balance | £193,727 | £193,772 | £241,054 | £308,759 | £414,724 | £517,071 | £619,427 | £726,575 | £827,997 | £956,737 | £1,071,146 | £1,223,829 | |
| Pro Forma Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £100,000 | £150,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £220,000 | £220,000 | £270,000 | £270,000 | £270,000 | |
| Direct Cost of Sales | £4,000 | £6,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,800 | £8,800 | £10,800 | £10,800 | £10,800 | |
| Other | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £500 | £500 | |
| Total Cost of Sales | £4,400 | £6,400 | £8,400 | £8,400 | £8,400 | £8,400 | £8,400 | £9,200 | £9,200 | £11,200 | £11,300 | £11,300 | |
| Gross Margin | £95,600 | £143,600 | £191,600 | £191,600 | £191,600 | £191,600 | £191,600 | £210,800 | £210,800 | £258,800 | £258,700 | £258,700 | |
| Gross Margin % | 95.60% | 95.73% | 95.80% | 95.80% | 95.80% | 95.80% | 95.80% | 95.82% | 95.82% | 95.85% | 95.81% | 95.81% | |
| Expenses | |||||||||||||
| Payroll | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | |
| Sales and Marketing and Other Expenses | £10,667 | £10,667 | £15,667 | £15,667 | £20,667 | £20,667 | £20,667 | £20,667 | £20,667 | £20,667 | £20,667 | £20,667 | |
| Depreciation | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Utilities | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
| Insurance | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Rent | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | |
| Payroll Taxes | 15% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £4,500 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £35,375 | £35,375 | £40,375 | £40,375 | £45,375 | £45,375 | £45,375 | £45,375 | £45,375 | £45,375 | £45,375 | £46,875 | |
| Profit Before Interest and Taxes | £60,225 | £108,225 | £151,225 | £151,225 | £146,225 | £146,225 | £146,225 | £165,425 | £165,425 | £213,425 | £213,325 | £211,825 | |
| EBITDA | £60,725 | £108,725 | £151,725 | £151,725 | £146,725 | £146,725 | £146,725 | £165,925 | £165,925 | £213,925 | £213,825 | £212,325 | |
| Interest Expense | £2,083 | £2,073 | £2,062 | £2,051 | £2,040 | £2,030 | £2,019 | £2,008 | £1,997 | £1,987 | £1,976 | £1,965 | |
| Taxes Incurred | £17,442 | £26,538 | £37,291 | £37,293 | £36,046 | £36,049 | £36,052 | £40,854 | £40,857 | £52,860 | £52,837 | £52,465 | |
| Net Profit | £40,699 | £79,614 | £111,872 | £111,880 | £108,139 | £108,147 | £108,155 | £122,563 | £122,571 | £158,579 | £158,512 | £157,395 | |
| Net Profit/Sales | 40.70% | 53.08% | 55.94% | 55.94% | 54.07% | 54.07% | 54.08% | 55.71% | 55.71% | 58.73% | 58.71% | 58.29% | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £40,000 | £193,727 | £193,772 | £241,054 | £308,759 | £414,724 | £517,071 | £619,427 | £726,575 | £827,997 | £956,737 | £1,071,146 | £1,223,829 |
| Accounts Receivable | £50,000 | £100,000 | £185,000 | £258,750 | £295,000 | £295,000 | £295,000 | £295,000 | £310,000 | £324,500 | £362,000 | £398,250 | £398,250 |
| Inventory | £5,000 | £4,400 | £6,600 | £8,800 | £8,800 | £8,800 | £8,800 | £8,800 | £9,680 | £9,680 | £11,880 | £11,880 | £11,880 |
| Other Current Assets | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 |
| Total Current Assets | £130,000 | £333,127 | £420,372 | £543,604 | £647,559 | £753,524 | £855,871 | £958,227 | £1,081,255 | £1,197,177 | £1,365,617 | £1,516,276 | £1,668,959 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £25,000 | £30,000 | £35,000 | £40,000 | £45,000 | £50,000 | £55,000 | £60,000 | £65,000 | £70,000 | £75,000 | £80,000 | £85,000 |
| Accumulated Depreciation | £5,000 | £5,500 | £6,000 | £6,500 | £7,000 | £7,500 | £8,000 | £8,500 | £9,000 | £9,500 | £10,000 | £10,500 | £11,000 |
| Total Long-term Assets | £20,000 | £24,500 | £29,000 | £33,500 | £38,000 | £42,500 | £47,000 | £51,500 | £56,000 | £60,500 | £65,000 | £69,500 | £74,000 |
| Total Assets | £150,000 | £357,627 | £449,372 | £577,104 | £685,559 | £796,024 | £902,871 | £1,009,727 | £1,137,255 | £1,257,677 | £1,430,617 | £1,585,776 | £1,742,959 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £20,000 | £36,927 | £50,349 | £67,500 | £65,366 | £68,983 | £68,975 | £68,967 | £75,223 | £74,365 | £90,017 | £87,955 | £89,035 |
| Current Borrowing | £0 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £20,000 | £186,927 | £200,349 | £217,500 | £215,366 | £218,983 | £218,975 | £218,967 | £225,223 | £224,365 | £240,017 | £237,955 | £239,035 |
| Long-term Liabilities | £100,000 | £100,000 | £98,709 | £97,418 | £96,127 | £94,836 | £93,545 | £92,254 | £90,963 | £89,672 | £88,381 | £87,090 | £85,799 |
| Total Liabilities | £120,000 | £286,927 | £299,058 | £314,918 | £311,493 | £313,819 | £312,520 | £311,221 | £316,186 | £314,037 | £328,398 | £325,045 | £324,834 |
| Paid-in Capital | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 |
| Retained Earnings | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Earnings | £0 | £40,699 | £120,313 | £232,186 | £344,066 | £452,205 | £560,351 | £668,506 | £791,069 | £913,640 | £1,072,219 | £1,230,730 | £1,388,125 |
| Total Capital | £30,000 | £70,699 | £150,313 | £262,186 | £374,066 | £482,205 | £590,351 | £698,506 | £821,069 | £943,640 | £1,102,219 | £1,260,730 | £1,418,125 |
| Total Liabilities and Capital | £150,000 | £357,627 | £449,372 | £577,104 | £685,559 | £796,024 | £902,871 | £1,009,727 | £1,137,255 | £1,257,677 | £1,430,617 | £1,585,776 | £1,742,959 |
| Net Worth | £30,000 | £70,699 | £150,313 | £262,186 | £374,066 | £482,205 | £590,351 | £698,506 | £821,069 | £943,640 | £1,102,219 | £1,260,730 | £1,418,125 |