| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Inmarsat Hardware | 0% | £29,150 | £29,150 | £53,000 | £29,150 | £39,750 | £29,150 | £29,150 | £73,900 | £136,550 | £29,150 | £29,150 | £29,150 |
| VSAT hardware | 0% | £0 | £3,250,000 | £812,500 | £4,062,500 | £812,500 | £6,500,000 | £1,625,000 | £0 | £812,500 | £812,500 | £0 | £812,500 |
| New Iridium Hardware | 0% | £0 | £36,000 | £60,000 | £60,000 | £60,000 | £36,000 | £36,000 | £60,000 | £36,000 | £36,000 | £36,000 | £36,000 |
| Airtime:Vsat,Inmarsat,Iridium | 0% | £81,000 | £81,000 | £150,000 | £150,000 | £180,000 | £180,000 | £185,000 | £195,000 | £81,000 | £81,000 | £81,000 | £81,000 |
| Value-added services | 0% | £15,000 | £30,000 | £45,000 | £20,000 | £15,000 | £50,000 | £40,000 | £15,000 | £20,000 | £15,000 | £15,000 | £15,000 |
| Total Sales | £125,150 | £3,426,150 | £1,120,500 | £4,321,650 | £1,107,250 | £6,795,150 | £1,915,150 | £343,900 | £1,086,050 | £973,650 | £161,150 | £973,650 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Inmarsat Hardware | £20,900 | £20,900 | £38,000 | £20,900 | £28,500 | £20,900 | £20,900 | £51,825 | £95,120 | £20,900 | £20,900 | £20,900 | |
| VSAT hardware | £0 | £2,825,875 | £545,000 | £3,258,000 | £706,522 | £3,600,000 | £1,413,044 | £0 | £706,522 | £706,522 | £0 | £706,522 | |
| New Iridium Hardware | £0 | £25,500 | £42,500 | £38,000 | £38,000 | £25,500 | £25,500 | £38,000 | £25,500 | £0 | £0 | £0 | |
| Airtime:Vsat,Inmarsat,Iridium | £67,500 | £67,500 | £115,000 | £67,500 | £125,500 | £125,000 | £71,500 | £81,000 | £67,500 | £67,500 | £67,500 | £67,500 | |
| Value-added services | £5,000 | £13,000 | £7,500 | £7,500 | £7,500 | £30,000 | £31,000 | £5,000 | £7,500 | £7,500 | £7,500 | £7,500 | |
| Subtotal Direct Cost of Sales | £93,400 | £2,952,775 | £748,000 | £3,391,900 | £906,022 | £3,801,400 | £1,561,944 | £175,825 | £902,142 | £802,422 | £95,900 | £802,422 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Pedro Camacho | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Staff | 0% | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 |
| Total People | 0 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | |
| Total Payroll | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | |
| 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 | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | |
| Long-term Interest Rate | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | |
| Tax Rate | 30.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.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 | £125,150 | £3,426,150 | £1,120,500 | £4,321,650 | £1,107,250 | £6,795,150 | £1,915,150 | £343,900 | £1,086,050 | £973,650 | £161,150 | £973,650 | |
| Direct Cost of Sales | £93,400 | £2,952,775 | £748,000 | £3,391,900 | £906,022 | £3,801,400 | £1,561,944 | £175,825 | £902,142 | £802,422 | £95,900 | £802,422 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £93,400 | £2,952,775 | £748,000 | £3,391,900 | £906,022 | £3,801,400 | £1,561,944 | £175,825 | £902,142 | £802,422 | £95,900 | £802,422 | |
| Gross Margin | £31,750 | £473,375 | £372,500 | £929,750 | £201,228 | £2,993,750 | £353,206 | £168,075 | £183,908 | £171,228 | £65,250 | £171,228 | |
| Gross Margin % | 25.37% | 13.82% | 33.24% | 21.51% | 18.17% | 44.06% | 18.44% | 48.87% | 16.93% | 17.59% | 40.49% | 17.59% | |
| Expenses | |||||||||||||
| Payroll | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | |
| Sales and Marketing and Other Expenses | £6,900 | £5,500 | £6,900 | £5,500 | £6,700 | £5,500 | £6,700 | £6,700 | £5,500 | £7,100 | £5,500 | £5,500 | |
| Depreciation | £363 | £363 | £363 | £363 | £363 | £363 | £363 | £363 | £363 | £363 | £363 | £363 | |
| Leased Equipment | £0 | £0 | £2,000 | £0 | £3,000 | £0 | £500 | £0 | £1,000 | £0 | £2,000 | £0 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | |
| Rent | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | |
| Payroll Taxes | 2% | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £18,966 | £17,566 | £20,966 | £17,566 | £21,766 | £17,566 | £19,266 | £18,766 | £18,566 | £19,166 | £19,566 | £17,566 | |
| Profit Before Interest and Taxes | £12,784 | £455,809 | £351,534 | £912,184 | £179,462 | £2,976,184 | £333,940 | £149,309 | £165,342 | £152,062 | £45,684 | £153,662 | |
| EBITDA | £13,147 | £456,172 | £351,897 | £912,547 | £179,825 | £2,976,547 | £334,303 | £149,672 | £165,705 | £152,425 | £46,047 | £154,025 | |
| Interest Expense | £24,917 | £39,396 | £39,292 | £39,188 | £39,917 | £39,813 | £39,708 | £39,604 | £39,500 | £39,396 | £39,292 | £26,667 | |
| Taxes Incurred | (£3,640) | £137,416 | £103,040 | £288,089 | £46,050 | £969,003 | £97,096 | £36,203 | £41,528 | £37,180 | £2,110 | £41,909 | |
| Net Profit | (£8,493) | £278,997 | £209,202 | £584,908 | £93,496 | £1,967,369 | £197,135 | £73,502 | £84,314 | £75,487 | £4,283 | £85,087 | |
| Net Profit/Sales | -6.79% | 8.14% | 18.67% | 13.53% | 8.44% | 28.95% | 10.29% | 21.37% | 7.76% | 7.75% | 2.66% | 8.74% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £12,515 | £342,615 | £112,050 | £432,165 | £110,725 | £679,515 | £191,515 | £34,390 | £108,605 | £97,365 | £16,115 | £97,365 | |
| Cash from Receivables | £54,296 | £58,050 | £211,665 | £3,014,366 | £1,104,485 | £3,793,053 | £1,167,162 | £5,969,235 | £1,676,498 | £331,775 | £974,073 | £851,910 | |
| Subtotal Cash from Operations | £66,811 | £400,665 | £323,715 | £3,446,531 | £1,215,210 | £4,472,568 | £1,358,677 | £6,003,625 | £1,785,103 | £429,140 | £990,188 | £949,275 | |
| 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 | £3,500,000 | £0 | £0 | £200,000 | £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 | £3,500,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £3,566,811 | £3,900,665 | £323,715 | £3,446,531 | £1,415,210 | £4,472,568 | £1,358,677 | £6,003,625 | £1,785,103 | £429,140 | £990,188 | £949,275 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | |
| Bill Payments | £39,034 | £335,750 | £6,078,628 | £313,914 | £4,796,246 | £300,751 | £5,973,781 | £144,488 | £85,208 | £94,715 | £223,725 | £82,218 | |
| Subtotal Spent on Operations | £48,204 | £344,920 | £6,087,798 | £323,084 | £4,805,416 | £309,921 | £5,982,951 | £153,658 | £94,378 | £103,885 | £232,895 | £91,388 | |
| 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 | £3,005,000 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £500,000 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,000,000 | £3,000,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £73,204 | £369,920 | £6,112,798 | £348,084 | £4,830,416 | £334,921 | £6,007,951 | £178,658 | £119,378 | £128,885 | £3,757,895 | £6,121,388 | |
| Net Cash Flow | £3,493,607 | £3,530,746 | (£5,789,083) | £3,098,446 | (£3,415,206) | £4,137,647 | (£4,649,274) | £5,824,967 | £1,665,725 | £300,255 | (£2,767,707) | (£5,172,113) | |
| Cash Balance | £3,524,383 | £7,055,129 | £1,266,046 | £4,364,492 | £949,286 | £5,086,933 | £437,659 | £6,262,626 | £7,928,351 | £8,228,606 | £5,460,899 | £288,786 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £30,776 | £3,524,383 | £7,055,129 | £1,266,046 | £4,364,492 | £949,286 | £5,086,933 | £437,659 | £6,262,626 | £7,928,351 | £8,228,606 | £5,460,899 | £288,786 |
| Accounts Receivable | £108,591 | £166,931 | £3,192,416 | £3,989,201 | £4,864,320 | £4,756,361 | £7,078,943 | £7,635,416 | £1,975,691 | £1,276,638 | £1,821,149 | £992,111 | £1,016,486 |
| Inventory | £96,176 | £102,740 | £3,248,053 | £2,500,053 | £3,731,090 | £2,825,068 | £4,181,540 | £2,619,596 | £2,443,771 | £1,541,629 | £882,664 | £786,764 | £882,664 |
| Other Current Assets | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £532,800 | £532,800 |
| Total Current Assets | £268,344 | £3,826,854 | £13,528,397 | £7,788,099 | £12,992,702 | £8,563,515 | £16,380,216 | £10,725,471 | £10,714,888 | £10,779,418 | £10,965,218 | £7,772,574 | £2,720,736 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £3,043,586 | £6,043,586 |
| Accumulated Depreciation | £7,250 | £7,613 | £7,975 | £8,338 | £8,700 | £9,063 | £9,425 | £9,788 | £10,150 | £10,513 | £10,875 | £11,238 | £11,600 |
| Total Long-term Assets | £36,336 | £35,974 | £35,611 | £35,249 | £34,886 | £34,524 | £34,161 | £33,799 | £33,436 | £33,074 | £32,711 | £3,032,349 | £6,031,986 |
| Total Assets | £304,680 | £3,862,827 | £13,564,008 | £7,823,348 | £13,027,588 | £8,598,038 | £16,414,377 | £10,759,269 | £10,748,324 | £10,812,492 | £10,997,929 | £10,804,922 | £8,752,722 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £34,678 | £126,319 | £6,073,502 | £148,640 | £4,792,972 | £94,927 | £5,968,896 | £141,654 | £82,206 | £87,059 | £222,010 | £49,720 | £942,433 |
| Current Borrowing | £5,000 | £5,000 | £3,505,000 | £3,505,000 | £3,505,000 | £3,705,000 | £3,705,000 | £3,705,000 | £3,705,000 | £3,705,000 | £3,705,000 | £3,705,000 | £700,000 |
| Other Current Liabilities | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Subtotal Current Liabilities | £49,678 | £141,319 | £9,588,502 | £3,663,640 | £8,307,972 | £3,809,927 | £9,683,896 | £3,856,654 | £3,797,206 | £3,802,059 | £3,937,010 | £3,764,720 | £1,652,433 |
| Long-term Liabilities | £6,000,000 | £5,975,000 | £5,950,000 | £5,925,000 | £5,900,000 | £5,875,000 | £5,850,000 | £5,825,000 | £5,800,000 | £5,775,000 | £5,750,000 | £5,725,000 | £5,700,000 |
| Total Liabilities | £6,049,678 | £6,116,319 | £15,538,502 | £9,588,640 | £14,207,972 | £9,684,927 | £15,533,896 | £9,681,654 | £9,597,206 | £9,577,059 | £9,687,010 | £9,489,720 | £7,352,433 |
| Paid-in Capital | £140,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 |
| Retained Earnings | (£5,889,869) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) |
| Earnings | £4,871 | (£8,493) | £270,504 | £479,707 | £1,064,614 | £1,158,110 | £3,125,479 | £3,322,614 | £3,396,116 | £3,480,431 | £3,555,917 | £3,560,200 | £3,645,287 |
| Total Capital | (£5,744,998) | (£2,253,491) | (£1,974,494) | (£1,765,292) | (£1,180,384) | (£1,086,888) | £880,481 | £1,077,616 | £1,151,118 | £1,235,432 | £1,310,919 | £1,315,202 | £1,400,289 |
| Total Liabilities and Capital | £304,680 | £3,862,827 | £13,564,008 | £7,823,348 | £13,027,588 | £8,598,038 | £16,414,377 | £10,759,269 | £10,748,324 | £10,812,492 | £10,997,929 | £10,804,922 | £8,752,722 |
| Net Worth | (£5,744,998) | (£2,253,491) | (£1,974,494) | (£1,765,292) | (£1,180,384) | (£1,086,888) | £880,481 | £1,077,616 | £1,151,118 | £1,235,432 | £1,310,919 | £1,315,202 | £1,400,289 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Inmarsat Hardware | 0% | £29,150 | £29,150 | £53,000 | £29,150 | £39,750 | £29,150 | £29,150 | £73,900 | £136,550 | £29,150 | £29,150 | £29,150 |
| VSAT hardware | 0% | £0 | £3,250,000 | £812,500 | £4,062,500 | £812,500 | £6,500,000 | £1,625,000 | £0 | £812,500 | £812,500 | £0 | £812,500 |
| New Iridium Hardware | 0% | £0 | £36,000 | £60,000 | £60,000 | £60,000 | £36,000 | £36,000 | £60,000 | £36,000 | £36,000 | £36,000 | £36,000 |
| Airtime:Vsat,Inmarsat,Iridium | 0% | £81,000 | £81,000 | £150,000 | £150,000 | £180,000 | £180,000 | £185,000 | £195,000 | £81,000 | £81,000 | £81,000 | £81,000 |
| Value-added services | 0% | £15,000 | £30,000 | £45,000 | £20,000 | £15,000 | £50,000 | £40,000 | £15,000 | £20,000 | £15,000 | £15,000 | £15,000 |
| Total Sales | £125,150 | £3,426,150 | £1,120,500 | £4,321,650 | £1,107,250 | £6,795,150 | £1,915,150 | £343,900 | £1,086,050 | £973,650 | £161,150 | £973,650 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Inmarsat Hardware | £20,900 | £20,900 | £38,000 | £20,900 | £28,500 | £20,900 | £20,900 | £51,825 | £95,120 | £20,900 | £20,900 | £20,900 | |
| VSAT hardware | £0 | £2,825,875 | £545,000 | £3,258,000 | £706,522 | £3,600,000 | £1,413,044 | £0 | £706,522 | £706,522 | £0 | £706,522 | |
| New Iridium Hardware | £0 | £25,500 | £42,500 | £38,000 | £38,000 | £25,500 | £25,500 | £38,000 | £25,500 | £0 | £0 | £0 | |
| Airtime:Vsat,Inmarsat,Iridium | £67,500 | £67,500 | £115,000 | £67,500 | £125,500 | £125,000 | £71,500 | £81,000 | £67,500 | £67,500 | £67,500 | £67,500 | |
| Value-added services | £5,000 | £13,000 | £7,500 | £7,500 | £7,500 | £30,000 | £31,000 | £5,000 | £7,500 | £7,500 | £7,500 | £7,500 | |
| Subtotal Direct Cost of Sales | £93,400 | £2,952,775 | £748,000 | £3,391,900 | £906,022 | £3,801,400 | £1,561,944 | £175,825 | £902,142 | £802,422 | £95,900 | £802,422 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Pedro Camacho | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Staff | 0% | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 | £6,670 |
| Total People | 0 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | |
| Total Payroll | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | |
| 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 | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | |
| Long-term Interest Rate | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | |
| Tax Rate | 30.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.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 | £125,150 | £3,426,150 | £1,120,500 | £4,321,650 | £1,107,250 | £6,795,150 | £1,915,150 | £343,900 | £1,086,050 | £973,650 | £161,150 | £973,650 | |
| Direct Cost of Sales | £93,400 | £2,952,775 | £748,000 | £3,391,900 | £906,022 | £3,801,400 | £1,561,944 | £175,825 | £902,142 | £802,422 | £95,900 | £802,422 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £93,400 | £2,952,775 | £748,000 | £3,391,900 | £906,022 | £3,801,400 | £1,561,944 | £175,825 | £902,142 | £802,422 | £95,900 | £802,422 | |
| Gross Margin | £31,750 | £473,375 | £372,500 | £929,750 | £201,228 | £2,993,750 | £353,206 | £168,075 | £183,908 | £171,228 | £65,250 | £171,228 | |
| Gross Margin % | 25.37% | 13.82% | 33.24% | 21.51% | 18.17% | 44.06% | 18.44% | 48.87% | 16.93% | 17.59% | 40.49% | 17.59% | |
| Expenses | |||||||||||||
| Payroll | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | |
| Sales and Marketing and Other Expenses | £6,900 | £5,500 | £6,900 | £5,500 | £6,700 | £5,500 | £6,700 | £6,700 | £5,500 | £7,100 | £5,500 | £5,500 | |
| Depreciation | £363 | £363 | £363 | £363 | £363 | £363 | £363 | £363 | £363 | £363 | £363 | £363 | |
| Leased Equipment | £0 | £0 | £2,000 | £0 | £3,000 | £0 | £500 | £0 | £1,000 | £0 | £2,000 | £0 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | |
| Rent | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | £1,350 | |
| Payroll Taxes | 2% | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 | £183 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £18,966 | £17,566 | £20,966 | £17,566 | £21,766 | £17,566 | £19,266 | £18,766 | £18,566 | £19,166 | £19,566 | £17,566 | |
| Profit Before Interest and Taxes | £12,784 | £455,809 | £351,534 | £912,184 | £179,462 | £2,976,184 | £333,940 | £149,309 | £165,342 | £152,062 | £45,684 | £153,662 | |
| EBITDA | £13,147 | £456,172 | £351,897 | £912,547 | £179,825 | £2,976,547 | £334,303 | £149,672 | £165,705 | £152,425 | £46,047 | £154,025 | |
| Interest Expense | £24,917 | £39,396 | £39,292 | £39,188 | £39,917 | £39,813 | £39,708 | £39,604 | £39,500 | £39,396 | £39,292 | £26,667 | |
| Taxes Incurred | (£3,640) | £137,416 | £103,040 | £288,089 | £46,050 | £969,003 | £97,096 | £36,203 | £41,528 | £37,180 | £2,110 | £41,909 | |
| Net Profit | (£8,493) | £278,997 | £209,202 | £584,908 | £93,496 | £1,967,369 | £197,135 | £73,502 | £84,314 | £75,487 | £4,283 | £85,087 | |
| Net Profit/Sales | -6.79% | 8.14% | 18.67% | 13.53% | 8.44% | 28.95% | 10.29% | 21.37% | 7.76% | 7.75% | 2.66% | 8.74% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £12,515 | £342,615 | £112,050 | £432,165 | £110,725 | £679,515 | £191,515 | £34,390 | £108,605 | £97,365 | £16,115 | £97,365 | |
| Cash from Receivables | £54,296 | £58,050 | £211,665 | £3,014,366 | £1,104,485 | £3,793,053 | £1,167,162 | £5,969,235 | £1,676,498 | £331,775 | £974,073 | £851,910 | |
| Subtotal Cash from Operations | £66,811 | £400,665 | £323,715 | £3,446,531 | £1,215,210 | £4,472,568 | £1,358,677 | £6,003,625 | £1,785,103 | £429,140 | £990,188 | £949,275 | |
| 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 | £3,500,000 | £0 | £0 | £200,000 | £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 | £3,500,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £3,566,811 | £3,900,665 | £323,715 | £3,446,531 | £1,415,210 | £4,472,568 | £1,358,677 | £6,003,625 | £1,785,103 | £429,140 | £990,188 | £949,275 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | £9,170 | |
| Bill Payments | £39,034 | £335,750 | £6,078,628 | £313,914 | £4,796,246 | £300,751 | £5,973,781 | £144,488 | £85,208 | £94,715 | £223,725 | £82,218 | |
| Subtotal Spent on Operations | £48,204 | £344,920 | £6,087,798 | £323,084 | £4,805,416 | £309,921 | £5,982,951 | £153,658 | £94,378 | £103,885 | £232,895 | £91,388 | |
| 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 | £3,005,000 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | £25,000 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £500,000 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,000,000 | £3,000,000 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £73,204 | £369,920 | £6,112,798 | £348,084 | £4,830,416 | £334,921 | £6,007,951 | £178,658 | £119,378 | £128,885 | £3,757,895 | £6,121,388 | |
| Net Cash Flow | £3,493,607 | £3,530,746 | (£5,789,083) | £3,098,446 | (£3,415,206) | £4,137,647 | (£4,649,274) | £5,824,967 | £1,665,725 | £300,255 | (£2,767,707) | (£5,172,113) | |
| Cash Balance | £3,524,383 | £7,055,129 | £1,266,046 | £4,364,492 | £949,286 | £5,086,933 | £437,659 | £6,262,626 | £7,928,351 | £8,228,606 | £5,460,899 | £288,786 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £30,776 | £3,524,383 | £7,055,129 | £1,266,046 | £4,364,492 | £949,286 | £5,086,933 | £437,659 | £6,262,626 | £7,928,351 | £8,228,606 | £5,460,899 | £288,786 |
| Accounts Receivable | £108,591 | £166,931 | £3,192,416 | £3,989,201 | £4,864,320 | £4,756,361 | £7,078,943 | £7,635,416 | £1,975,691 | £1,276,638 | £1,821,149 | £992,111 | £1,016,486 |
| Inventory | £96,176 | £102,740 | £3,248,053 | £2,500,053 | £3,731,090 | £2,825,068 | £4,181,540 | £2,619,596 | £2,443,771 | £1,541,629 | £882,664 | £786,764 | £882,664 |
| Other Current Assets | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £32,800 | £532,800 | £532,800 |
| Total Current Assets | £268,344 | £3,826,854 | £13,528,397 | £7,788,099 | £12,992,702 | £8,563,515 | £16,380,216 | £10,725,471 | £10,714,888 | £10,779,418 | £10,965,218 | £7,772,574 | £2,720,736 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £43,586 | £3,043,586 | £6,043,586 |
| Accumulated Depreciation | £7,250 | £7,613 | £7,975 | £8,338 | £8,700 | £9,063 | £9,425 | £9,788 | £10,150 | £10,513 | £10,875 | £11,238 | £11,600 |
| Total Long-term Assets | £36,336 | £35,974 | £35,611 | £35,249 | £34,886 | £34,524 | £34,161 | £33,799 | £33,436 | £33,074 | £32,711 | £3,032,349 | £6,031,986 |
| Total Assets | £304,680 | £3,862,827 | £13,564,008 | £7,823,348 | £13,027,588 | £8,598,038 | £16,414,377 | £10,759,269 | £10,748,324 | £10,812,492 | £10,997,929 | £10,804,922 | £8,752,722 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £34,678 | £126,319 | £6,073,502 | £148,640 | £4,792,972 | £94,927 | £5,968,896 | £141,654 | £82,206 | £87,059 | £222,010 | £49,720 | £942,433 |
| Current Borrowing | £5,000 | £5,000 | £3,505,000 | £3,505,000 | £3,505,000 | £3,705,000 | £3,705,000 | £3,705,000 | £3,705,000 | £3,705,000 | £3,705,000 | £3,705,000 | £700,000 |
| Other Current Liabilities | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Subtotal Current Liabilities | £49,678 | £141,319 | £9,588,502 | £3,663,640 | £8,307,972 | £3,809,927 | £9,683,896 | £3,856,654 | £3,797,206 | £3,802,059 | £3,937,010 | £3,764,720 | £1,652,433 |
| Long-term Liabilities | £6,000,000 | £5,975,000 | £5,950,000 | £5,925,000 | £5,900,000 | £5,875,000 | £5,850,000 | £5,825,000 | £5,800,000 | £5,775,000 | £5,750,000 | £5,725,000 | £5,700,000 |
| Total Liabilities | £6,049,678 | £6,116,319 | £15,538,502 | £9,588,640 | £14,207,972 | £9,684,927 | £15,533,896 | £9,681,654 | £9,597,206 | £9,577,059 | £9,687,010 | £9,489,720 | £7,352,433 |
| Paid-in Capital | £140,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 | £3,640,000 |
| Retained Earnings | (£5,889,869) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) | (£5,884,998) |
| Earnings | £4,871 | (£8,493) | £270,504 | £479,707 | £1,064,614 | £1,158,110 | £3,125,479 | £3,322,614 | £3,396,116 | £3,480,431 | £3,555,917 | £3,560,200 | £3,645,287 |
| Total Capital | (£5,744,998) | (£2,253,491) | (£1,974,494) | (£1,765,292) | (£1,180,384) | (£1,086,888) | £880,481 | £1,077,616 | £1,151,118 | £1,235,432 | £1,310,919 | £1,315,202 | £1,400,289 |
| Total Liabilities and Capital | £304,680 | £3,862,827 | £13,564,008 | £7,823,348 | £13,027,588 | £8,598,038 | £16,414,377 | £10,759,269 | £10,748,324 | £10,812,492 | £10,997,929 | £10,804,922 | £8,752,722 |
| Net Worth | (£5,744,998) | (£2,253,491) | (£1,974,494) | (£1,765,292) | (£1,180,384) | (£1,086,888) | £880,481 | £1,077,616 | £1,151,118 | £1,235,432 | £1,310,919 | £1,315,202 | £1,400,289 |