| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Unit Sales | |||||||||||||
| Import and Export | 0% | 8,700 | 8,200 | 8,800 | 8,300 | 8,450 | 8,050 | 8,000 | 8,200 | 8,050 | 8,000 | 9,050 | 8,400 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 8,700 | 8,200 | 8,800 | 8,300 | 8,450 | 8,050 | 8,000 | 8,200 | 8,050 | 8,000 | 9,050 | 8,400 | |
| Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Import and Export | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Sales | |||||||||||||
| Import and Export | £2,280,096 | £2,149,056 | £2,306,304 | £2,175,264 | £2,214,576 | £2,109,744 | £2,096,640 | £2,149,056 | £2,109,744 | £2,096,640 | £2,371,824 | £2,201,472 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £2,280,096 | £2,149,056 | £2,306,304 | £2,175,264 | £2,214,576 | £2,109,744 | £2,096,640 | £2,149,056 | £2,109,744 | £2,096,640 | £2,371,824 | £2,201,472 | |
| Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Import and Export | 0.00% | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Import and Export | £1,844,400 | £1,738,400 | £1,865,600 | £1,759,600 | £1,791,400 | £1,706,600 | £1,696,000 | £1,738,400 | £1,706,600 | £1,696,000 | £1,918,600 | £1,780,800 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £1,844,400 | £1,738,400 | £1,865,600 | £1,759,600 | £1,791,400 | £1,706,600 | £1,696,000 | £1,738,400 | £1,706,600 | £1,696,000 | £1,918,600 | £1,780,800 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Production Personnel | |||||||||||||
| Antonio Silvera, VP Production | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | |
| Plant Employees | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | |
| Other | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Subtotal | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | |
| Sales and Marketing Personnel | |||||||||||||
| Marco Silvera Jr, VP Sales/Mktg. | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | |
| Other | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | |
| Subtotal | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | |
| General and Administrative Personnel | |||||||||||||
| Marco Slivera Sr, CEO | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | |
| Ralph Henzo, CFO | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Admin/Acctg. Staff | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Other | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Subtotal | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | |
| Other Personnel | |||||||||||||
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | |
| Total Payroll | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | |
| Pro Forma Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £2,280,096 | £2,149,056 | £2,306,304 | £2,175,264 | £2,214,576 | £2,109,744 | £2,096,640 | £2,149,056 | £2,109,744 | £2,096,640 | £2,371,824 | £2,201,472 | |
| Direct Cost of Sales | £1,844,400 | £1,738,400 | £1,865,600 | £1,759,600 | £1,791,400 | £1,706,600 | £1,696,000 | £1,738,400 | £1,706,600 | £1,696,000 | £1,918,600 | £1,780,800 | |
| Production Payroll | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | |
| Other Costs of Sales | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | |
| Total Cost of Sales | £1,894,433 | £1,788,433 | £1,915,633 | £1,809,633 | £1,841,433 | £1,756,633 | £1,746,033 | £1,788,433 | £1,756,633 | £1,746,033 | £1,968,633 | £1,830,833 | |
| Gross Margin | £385,663 | £360,623 | £390,671 | £365,631 | £373,143 | £353,111 | £350,607 | £360,623 | £353,111 | £350,607 | £403,191 | £370,639 | |
| Gross Margin % | 16.91% | 16.78% | 16.94% | 16.81% | 16.85% | 16.74% | 16.72% | 16.78% | 16.74% | 16.72% | 17.00% | 16.84% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | |
| Advertising/Promotion | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | |
| Travel | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | |
| Other Sales and Marketing Expenses | £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 Sales and Marketing Expenses | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | |
| Sales and Marketing % | 1.51% | 1.61% | 1.50% | 1.59% | 1.56% | 1.64% | 1.65% | 1.61% | 1.64% | 1.65% | 1.46% | 1.57% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | |
| Marketing/Promotion | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | |
| Leased Equipment | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | |
| Utilities | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Insurance | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Rent | £0 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | |
| Payroll Taxes | 9% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £41,150 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | |
| General and Administrative % | 1.80% | 3.21% | 2.99% | 3.17% | 3.11% | 3.27% | 3.29% | 3.21% | 3.27% | 3.29% | 2.90% | 3.13% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Consultants | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Other % | 0.07% | 0.07% | 0.07% | 0.07% | 0.07% | 0.07% | 0.07% | 0.07% | 0.07% | 0.07% | 0.06% | 0.07% | |
| Total Operating Expenses | £77,191 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | |
| Profit Before Interest and Taxes | £308,472 | £255,682 | £285,730 | £260,690 | £268,202 | £248,170 | £245,666 | £255,682 | £248,170 | £245,666 | £298,250 | £265,698 | |
| EBITDA | £326,472 | £273,682 | £303,730 | £278,690 | £286,202 | £266,170 | £263,666 | £273,682 | £266,170 | £263,666 | £316,250 | £283,698 | |
| Interest Expense | £23,885 | £23,621 | £23,356 | £23,092 | £22,827 | £22,563 | £22,298 | £22,034 | £21,769 | £21,505 | £21,240 | £20,976 | |
| Taxes Incurred | £133,756 | £109,069 | £123,316 | £111,671 | £115,326 | £106,035 | £104,983 | £109,815 | £106,408 | £105,356 | £130,195 | £115,019 | |
| Net Profit | £150,831 | £122,992 | £139,058 | £125,927 | £130,049 | £119,572 | £118,385 | £123,834 | £119,992 | £118,805 | £146,815 | £129,703 | |
| Net Profit/Sales | 6.62% | 5.72% | 6.03% | 5.79% | 5.87% | 5.67% | 5.65% | 5.76% | 5.69% | 5.67% | 6.19% | 5.89% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £2,280,096 | £2,149,056 | £2,306,304 | £2,175,264 | £2,214,576 | £2,109,744 | £2,096,640 | £2,149,056 | £2,109,744 | £2,096,640 | £2,371,824 | £2,201,472 | |
| Subtotal Cash from Operations | £2,280,096 | £2,149,056 | £2,306,304 | £2,175,264 | £2,214,576 | £2,109,744 | £2,096,640 | £2,149,056 | £2,109,744 | £2,096,640 | £2,371,824 | £2,201,472 | |
| 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 | £2,700,000 | £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 | £4,980,096 | £2,149,056 | £2,306,304 | £2,175,264 | £2,214,576 | £2,109,744 | £2,096,640 | £2,149,056 | £2,109,744 | £2,096,640 | £2,371,824 | £2,201,472 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | |
| Bill Payments | £132,806 | £3,668,016 | £1,850,946 | £2,222,911 | £1,867,189 | £2,040,313 | £1,827,442 | £1,898,330 | £1,996,185 | £1,883,378 | £1,911,190 | £2,379,772 | |
| Subtotal Spent on Operations | £186,580 | £3,721,790 | £1,904,720 | £2,276,685 | £1,920,963 | £2,094,087 | £1,881,216 | £1,952,104 | £2,049,959 | £1,937,152 | £1,964,964 | £2,433,546 | |
| 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 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | |
| Purchase Other Current 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 | |
| Purchase Long-term Assets | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £421,413 | £3,984,373 | £2,167,303 | £2,539,268 | £2,183,546 | £2,356,670 | £2,143,799 | £2,214,687 | £2,312,542 | £2,199,735 | £2,227,547 | £2,696,129 | |
| Net Cash Flow | £4,558,683 | (£1,835,317) | £139,001 | (£364,004) | £31,030 | (£246,926) | (£47,159) | (£65,631) | (£202,798) | (£103,095) | £144,277 | (£494,657) | |
| Cash Balance | £5,552,943 | £3,717,626 | £3,856,626 | £3,492,622 | £3,523,653 | £3,276,727 | £3,229,568 | £3,163,937 | £2,961,139 | £2,858,044 | £3,002,321 | £2,507,664 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £994,260 | £5,552,943 | £3,717,626 | £3,856,626 | £3,492,622 | £3,523,653 | £3,276,727 | £3,229,568 | £3,163,937 | £2,961,139 | £2,858,044 | £3,002,321 | £2,507,664 |
| Inventory | £355,200 | £2,028,840 | £1,912,240 | £2,052,160 | £1,935,560 | £1,970,540 | £1,877,260 | £1,865,600 | £1,912,240 | £1,877,260 | £1,865,600 | £2,110,460 | £1,958,880 |
| Other Current Assets | £243,936 | £248,936 | £253,936 | £258,936 | £263,936 | £268,936 | £273,936 | £278,936 | £283,936 | £288,936 | £293,936 | £298,936 | £303,936 |
| Total Current Assets | £1,593,396 | £7,830,719 | £5,883,802 | £6,167,722 | £5,692,118 | £5,763,129 | £5,427,923 | £5,374,104 | £5,360,113 | £5,127,335 | £5,017,580 | £5,411,717 | £4,770,480 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £521,650 | £746,650 | £971,650 | £1,196,650 | £1,421,650 | £1,646,650 | £1,871,650 | £2,096,650 | £2,321,650 | £2,546,650 | £2,771,650 | £2,996,650 | £3,221,650 |
| Accumulated Depreciation | £100,000 | £118,000 | £136,000 | £154,000 | £172,000 | £190,000 | £208,000 | £226,000 | £244,000 | £262,000 | £280,000 | £298,000 | £316,000 |
| Total Long-term Assets | £421,650 | £628,650 | £835,650 | £1,042,650 | £1,249,650 | £1,456,650 | £1,663,650 | £1,870,650 | £2,077,650 | £2,284,650 | £2,491,650 | £2,698,650 | £2,905,650 |
| Total Assets | £2,015,046 | £8,459,369 | £6,719,452 | £7,210,372 | £6,941,768 | £7,219,779 | £7,091,573 | £7,244,754 | £7,437,763 | £7,411,985 | £7,509,230 | £8,110,367 | £7,676,130 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £8,435 | £3,606,760 | £1,776,433 | £2,160,879 | £1,798,931 | £1,979,476 | £1,764,281 | £1,831,660 | £1,933,419 | £1,820,231 | £1,831,254 | £2,318,158 | £1,786,801 |
| Current Borrowing | £58,000 | £53,167 | £48,334 | £43,501 | £38,668 | £33,835 | £29,002 | £24,169 | £19,336 | £14,503 | £9,670 | £4,837 | £4 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £66,435 | £3,659,927 | £1,824,767 | £2,204,380 | £1,837,599 | £2,013,311 | £1,793,283 | £1,855,829 | £1,952,755 | £1,834,734 | £1,840,924 | £2,322,995 | £1,786,805 |
| Long-term Liabilities | £402,000 | £3,102,000 | £3,074,250 | £3,046,500 | £3,018,750 | £2,991,000 | £2,963,250 | £2,935,500 | £2,907,750 | £2,880,000 | £2,852,250 | £2,824,500 | £2,796,750 |
| Total Liabilities | £468,435 | £6,761,927 | £4,899,017 | £5,250,880 | £4,856,349 | £5,004,311 | £4,756,533 | £4,791,329 | £4,860,505 | £4,714,734 | £4,693,174 | £5,147,495 | £4,583,555 |
| Paid-in Capital | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 |
| Retained Earnings | £85,985 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 |
| Earnings | £935,626 | £150,831 | £273,823 | £412,881 | £538,809 | £668,857 | £788,429 | £906,814 | £1,030,648 | £1,150,640 | £1,269,445 | £1,416,261 | £1,545,964 |
| Total Capital | £1,546,611 | £1,697,442 | £1,820,434 | £1,959,492 | £2,085,420 | £2,215,468 | £2,335,040 | £2,453,425 | £2,577,259 | £2,697,251 | £2,816,056 | £2,962,872 | £3,092,575 |
| Total Liabilities and Capital | £2,015,046 | £8,459,369 | £6,719,452 | £7,210,372 | £6,941,768 | £7,219,779 | £7,091,573 | £7,244,754 | £7,437,763 | £7,411,985 | £7,509,230 | £8,110,367 | £7,676,130 |
| Net Worth | £1,546,611 | £1,697,442 | £1,820,434 | £1,959,492 | £2,085,420 | £2,215,468 | £2,335,040 | £2,453,425 | £2,577,259 | £2,697,251 | £2,816,056 | £2,962,872 | £3,092,575 |
| 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 | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | |
| Long-term Interest Rate | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Tax Rate | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Unit Sales | |||||||||||||
| Import and Export | 0% | 8,700 | 8,200 | 8,800 | 8,300 | 8,450 | 8,050 | 8,000 | 8,200 | 8,050 | 8,000 | 9,050 | 8,400 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 8,700 | 8,200 | 8,800 | 8,300 | 8,450 | 8,050 | 8,000 | 8,200 | 8,050 | 8,000 | 9,050 | 8,400 | |
| Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Import and Export | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | £262.08 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Sales | |||||||||||||
| Import and Export | £2,280,096 | £2,149,056 | £2,306,304 | £2,175,264 | £2,214,576 | £2,109,744 | £2,096,640 | £2,149,056 | £2,109,744 | £2,096,640 | £2,371,824 | £2,201,472 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £2,280,096 | £2,149,056 | £2,306,304 | £2,175,264 | £2,214,576 | £2,109,744 | £2,096,640 | £2,149,056 | £2,109,744 | £2,096,640 | £2,371,824 | £2,201,472 | |
| Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Import and Export | 0.00% | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 | £212.00 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Import and Export | £1,844,400 | £1,738,400 | £1,865,600 | £1,759,600 | £1,791,400 | £1,706,600 | £1,696,000 | £1,738,400 | £1,706,600 | £1,696,000 | £1,918,600 | £1,780,800 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £1,844,400 | £1,738,400 | £1,865,600 | £1,759,600 | £1,791,400 | £1,706,600 | £1,696,000 | £1,738,400 | £1,706,600 | £1,696,000 | £1,918,600 | £1,780,800 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Production Personnel | |||||||||||||
| Antonio Silvera, VP Production | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | |
| Plant Employees | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | £18,333 | |
| Other | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Subtotal | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | |
| Sales and Marketing Personnel | |||||||||||||
| Marco Silvera Jr, VP Sales/Mktg. | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | |
| Other | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | £15,041 | |
| Subtotal | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | |
| General and Administrative Personnel | |||||||||||||
| Marco Slivera Sr, CEO | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | |
| Ralph Henzo, CFO | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Admin/Acctg. Staff | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Other | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Subtotal | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | |
| Other Personnel | |||||||||||||
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or Title or Group | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | |
| Total Payroll | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | |
| Pro Forma Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £2,280,096 | £2,149,056 | £2,306,304 | £2,175,264 | £2,214,576 | £2,109,744 | £2,096,640 | £2,149,056 | £2,109,744 | £2,096,640 | £2,371,824 | £2,201,472 | |
| Direct Cost of Sales | £1,844,400 | £1,738,400 | £1,865,600 | £1,759,600 | £1,791,400 | £1,706,600 | £1,696,000 | £1,738,400 | £1,706,600 | £1,696,000 | £1,918,600 | £1,780,800 | |
| Production Payroll | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | £25,033 | |
| Other Costs of Sales | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | |
| Total Cost of Sales | £1,894,433 | £1,788,433 | £1,915,633 | £1,809,633 | £1,841,433 | £1,756,633 | £1,746,033 | £1,788,433 | £1,756,633 | £1,746,033 | £1,968,633 | £1,830,833 | |
| Gross Margin | £385,663 | £360,623 | £390,671 | £365,631 | £373,143 | £353,111 | £350,607 | £360,623 | £353,111 | £350,607 | £403,191 | £370,639 | |
| Gross Margin % | 16.91% | 16.78% | 16.94% | 16.81% | 16.85% | 16.74% | 16.72% | 16.78% | 16.74% | 16.72% | 17.00% | 16.84% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | £18,791 | |
| Advertising/Promotion | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | |
| Travel | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | |
| Other Sales and Marketing Expenses | £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 Sales and Marketing Expenses | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | £34,541 | |
| Sales and Marketing % | 1.51% | 1.61% | 1.50% | 1.59% | 1.56% | 1.64% | 1.65% | 1.61% | 1.64% | 1.65% | 1.46% | 1.57% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | £9,950 | |
| Marketing/Promotion | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | |
| Leased Equipment | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | £4,200 | |
| Utilities | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Insurance | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Rent | £0 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | |
| Payroll Taxes | 9% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £41,150 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | £68,900 | |
| General and Administrative % | 1.80% | 3.21% | 2.99% | 3.17% | 3.11% | 3.27% | 3.29% | 3.21% | 3.27% | 3.29% | 2.90% | 3.13% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Consultants | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Other % | 0.07% | 0.07% | 0.07% | 0.07% | 0.07% | 0.07% | 0.07% | 0.07% | 0.07% | 0.07% | 0.06% | 0.07% | |
| Total Operating Expenses | £77,191 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | £104,941 | |
| Profit Before Interest and Taxes | £308,472 | £255,682 | £285,730 | £260,690 | £268,202 | £248,170 | £245,666 | £255,682 | £248,170 | £245,666 | £298,250 | £265,698 | |
| EBITDA | £326,472 | £273,682 | £303,730 | £278,690 | £286,202 | £266,170 | £263,666 | £273,682 | £266,170 | £263,666 | £316,250 | £283,698 | |
| Interest Expense | £23,885 | £23,621 | £23,356 | £23,092 | £22,827 | £22,563 | £22,298 | £22,034 | £21,769 | £21,505 | £21,240 | £20,976 | |
| Taxes Incurred | £133,756 | £109,069 | £123,316 | £111,671 | £115,326 | £106,035 | £104,983 | £109,815 | £106,408 | £105,356 | £130,195 | £115,019 | |
| Net Profit | £150,831 | £122,992 | £139,058 | £125,927 | £130,049 | £119,572 | £118,385 | £123,834 | £119,992 | £118,805 | £146,815 | £129,703 | |
| Net Profit/Sales | 6.62% | 5.72% | 6.03% | 5.79% | 5.87% | 5.67% | 5.65% | 5.76% | 5.69% | 5.67% | 6.19% | 5.89% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £2,280,096 | £2,149,056 | £2,306,304 | £2,175,264 | £2,214,576 | £2,109,744 | £2,096,640 | £2,149,056 | £2,109,744 | £2,096,640 | £2,371,824 | £2,201,472 | |
| Subtotal Cash from Operations | £2,280,096 | £2,149,056 | £2,306,304 | £2,175,264 | £2,214,576 | £2,109,744 | £2,096,640 | £2,149,056 | £2,109,744 | £2,096,640 | £2,371,824 | £2,201,472 | |
| 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 | £2,700,000 | £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 | £4,980,096 | £2,149,056 | £2,306,304 | £2,175,264 | £2,214,576 | £2,109,744 | £2,096,640 | £2,149,056 | £2,109,744 | £2,096,640 | £2,371,824 | £2,201,472 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | £53,774 | |
| Bill Payments | £132,806 | £3,668,016 | £1,850,946 | £2,222,911 | £1,867,189 | £2,040,313 | £1,827,442 | £1,898,330 | £1,996,185 | £1,883,378 | £1,911,190 | £2,379,772 | |
| Subtotal Spent on Operations | £186,580 | £3,721,790 | £1,904,720 | £2,276,685 | £1,920,963 | £2,094,087 | £1,881,216 | £1,952,104 | £2,049,959 | £1,937,152 | £1,964,964 | £2,433,546 | |
| 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 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | £4,833 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | £27,750 | |
| Purchase Other Current 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 | |
| Purchase Long-term Assets | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | £225,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £421,413 | £3,984,373 | £2,167,303 | £2,539,268 | £2,183,546 | £2,356,670 | £2,143,799 | £2,214,687 | £2,312,542 | £2,199,735 | £2,227,547 | £2,696,129 | |
| Net Cash Flow | £4,558,683 | (£1,835,317) | £139,001 | (£364,004) | £31,030 | (£246,926) | (£47,159) | (£65,631) | (£202,798) | (£103,095) | £144,277 | (£494,657) | |
| Cash Balance | £5,552,943 | £3,717,626 | £3,856,626 | £3,492,622 | £3,523,653 | £3,276,727 | £3,229,568 | £3,163,937 | £2,961,139 | £2,858,044 | £3,002,321 | £2,507,664 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £994,260 | £5,552,943 | £3,717,626 | £3,856,626 | £3,492,622 | £3,523,653 | £3,276,727 | £3,229,568 | £3,163,937 | £2,961,139 | £2,858,044 | £3,002,321 | £2,507,664 |
| Inventory | £355,200 | £2,028,840 | £1,912,240 | £2,052,160 | £1,935,560 | £1,970,540 | £1,877,260 | £1,865,600 | £1,912,240 | £1,877,260 | £1,865,600 | £2,110,460 | £1,958,880 |
| Other Current Assets | £243,936 | £248,936 | £253,936 | £258,936 | £263,936 | £268,936 | £273,936 | £278,936 | £283,936 | £288,936 | £293,936 | £298,936 | £303,936 |
| Total Current Assets | £1,593,396 | £7,830,719 | £5,883,802 | £6,167,722 | £5,692,118 | £5,763,129 | £5,427,923 | £5,374,104 | £5,360,113 | £5,127,335 | £5,017,580 | £5,411,717 | £4,770,480 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £521,650 | £746,650 | £971,650 | £1,196,650 | £1,421,650 | £1,646,650 | £1,871,650 | £2,096,650 | £2,321,650 | £2,546,650 | £2,771,650 | £2,996,650 | £3,221,650 |
| Accumulated Depreciation | £100,000 | £118,000 | £136,000 | £154,000 | £172,000 | £190,000 | £208,000 | £226,000 | £244,000 | £262,000 | £280,000 | £298,000 | £316,000 |
| Total Long-term Assets | £421,650 | £628,650 | £835,650 | £1,042,650 | £1,249,650 | £1,456,650 | £1,663,650 | £1,870,650 | £2,077,650 | £2,284,650 | £2,491,650 | £2,698,650 | £2,905,650 |
| Total Assets | £2,015,046 | £8,459,369 | £6,719,452 | £7,210,372 | £6,941,768 | £7,219,779 | £7,091,573 | £7,244,754 | £7,437,763 | £7,411,985 | £7,509,230 | £8,110,367 | £7,676,130 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £8,435 | £3,606,760 | £1,776,433 | £2,160,879 | £1,798,931 | £1,979,476 | £1,764,281 | £1,831,660 | £1,933,419 | £1,820,231 | £1,831,254 | £2,318,158 | £1,786,801 |
| Current Borrowing | £58,000 | £53,167 | £48,334 | £43,501 | £38,668 | £33,835 | £29,002 | £24,169 | £19,336 | £14,503 | £9,670 | £4,837 | £4 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £66,435 | £3,659,927 | £1,824,767 | £2,204,380 | £1,837,599 | £2,013,311 | £1,793,283 | £1,855,829 | £1,952,755 | £1,834,734 | £1,840,924 | £2,322,995 | £1,786,805 |
| Long-term Liabilities | £402,000 | £3,102,000 | £3,074,250 | £3,046,500 | £3,018,750 | £2,991,000 | £2,963,250 | £2,935,500 | £2,907,750 | £2,880,000 | £2,852,250 | £2,824,500 | £2,796,750 |
| Total Liabilities | £468,435 | £6,761,927 | £4,899,017 | £5,250,880 | £4,856,349 | £5,004,311 | £4,756,533 | £4,791,329 | £4,860,505 | £4,714,734 | £4,693,174 | £5,147,495 | £4,583,555 |
| Paid-in Capital | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 |
| Retained Earnings | £85,985 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 | £1,021,611 |
| Earnings | £935,626 | £150,831 | £273,823 | £412,881 | £538,809 | £668,857 | £788,429 | £906,814 | £1,030,648 | £1,150,640 | £1,269,445 | £1,416,261 | £1,545,964 |
| Total Capital | £1,546,611 | £1,697,442 | £1,820,434 | £1,959,492 | £2,085,420 | £2,215,468 | £2,335,040 | £2,453,425 | £2,577,259 | £2,697,251 | £2,816,056 | £2,962,872 | £3,092,575 |
| Total Liabilities and Capital | £2,015,046 | £8,459,369 | £6,719,452 | £7,210,372 | £6,941,768 | £7,219,779 | £7,091,573 | £7,244,754 | £7,437,763 | £7,411,985 | £7,509,230 | £8,110,367 | £7,676,130 |
| Net Worth | £1,546,611 | £1,697,442 | £1,820,434 | £1,959,492 | £2,085,420 | £2,215,468 | £2,335,040 | £2,453,425 | £2,577,259 | £2,697,251 | £2,816,056 | £2,962,872 | £3,092,575 |
| 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 | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | 14.00% | |
| Long-term Interest Rate | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Tax Rate | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | 47.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |