| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Single Family Housing | 0% | £8,320 | £10,920 | £12,480 | £11,180 | £12,610 | £13,790 | £11,700 | £11,700 | £12,455 | £12,870 | £13,260 | £13,114 |
| Other Residential Housing | 0% | £3,200 | £4,200 | £4,800 | £4,300 | £4,850 | £5,304 | £4,500 | £4,500 | £4,790 | £4,950 | £5,100 | £5,044 |
| Commercial Construction | 0% | £4,480 | £5,880 | £6,720 | £6,020 | £6,790 | £7,426 | £6,300 | £6,300 | £6,707 | £6,930 | £7,140 | £7,062 |
| Total Sales | £16,000 | £21,000 | £24,000 | £21,500 | £24,250 | £26,520 | £22,500 | £22,500 | £23,952 | £24,750 | £25,500 | £25,220 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Single Family Housing | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | |
| Other Residential Housing | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
| Commercial Construction | £233 | £233 | £233 | £233 | £233 | £233 | £233 | £233 | £233 | £233 | £233 | £233 | |
| Subtotal Direct Cost of Sales | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Lloyd James | 0% | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Anne James | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Sam McDonald | 0% | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 |
| Cement Layer No. 1 | 0% | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 |
| Cement Layer No. 2 | 0% | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 |
| Cement Layer No. 3 | 0% | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 |
| Part time Cement Layer No.4 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Part time Cement Layer No. 5 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | |
| 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 Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £16,000 | £21,000 | £24,000 | £21,500 | £24,250 | £26,520 | £22,500 | £22,500 | £23,952 | £24,750 | £25,500 | £25,220 | |
| Direct Cost of Sales | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Other | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Total Cost of Sales | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | |
| Gross Margin | £14,917 | £19,917 | £22,917 | £20,417 | £23,167 | £25,437 | £21,417 | £21,417 | £22,869 | £23,667 | £24,417 | £24,137 | |
| Gross Margin % | 93.23% | 94.84% | 95.49% | 94.96% | 95.53% | 95.92% | 95.19% | 95.19% | 95.48% | 95.62% | 95.75% | 95.70% | |
| Expenses | |||||||||||||
| Payroll | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | |
| Sales and Marketing and Other Expenses | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | |
| Depreciation | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Rent/Mortgage | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | |
| Supplies and Equipment | £827 | £827 | £827 | £827 | £827 | £827 | £827 | £827 | £827 | £827 | £827 | £827 | |
| Insurance | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | |
| Services | £236 | £236 | £236 | £236 | £236 | £236 | £236 | £236 | £236 | £236 | £236 | £236 | |
| Payroll Taxes | 15% | £829 | £829 | £829 | £829 | £829 | £829 | £829 | £829 | £829 | £829 | £829 | £829 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | |
| Profit Before Interest and Taxes | (£7,703) | (£2,703) | £297 | (£2,203) | £547 | £2,817 | (£1,203) | (£1,203) | £249 | £1,047 | £1,797 | £1,517 | |
| EBITDA | (£3,703) | £1,297 | £4,297 | £1,797 | £4,547 | £6,817 | £2,797 | £2,797 | £4,249 | £5,047 | £5,797 | £5,517 | |
| Interest Expense | £161 | £156 | £151 | £146 | £141 | £136 | £131 | £126 | £121 | £116 | £111 | £106 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£7,864) | (£2,859) | £146 | (£2,349) | £406 | £2,681 | (£1,334) | (£1,329) | £128 | £931 | £1,686 | £1,411 | |
| Net Profit/Sales | -49.15% | -13.61% | 0.61% | -10.92% | 1.68% | 10.11% | -5.93% | -5.91% | 0.54% | 3.76% | 6.61% | 5.60% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £4,000 | £5,250 | £6,000 | £5,375 | £6,063 | £6,630 | £5,625 | £5,625 | £5,988 | £6,188 | £6,375 | £6,305 | |
| Cash from Receivables | £11,663 | £12,063 | £12,125 | £15,825 | £17,938 | £16,194 | £18,244 | £19,790 | £16,875 | £16,911 | £17,984 | £18,581 | |
| Subtotal Cash from Operations | £15,663 | £17,313 | £18,125 | £21,200 | £24,000 | £22,824 | £23,869 | £25,415 | £22,863 | £23,099 | £24,359 | £24,886 | |
| 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 | £2,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 | £3,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £20,663 | £17,313 | £18,125 | £21,200 | £24,000 | £22,824 | £23,869 | £25,415 | £22,863 | £23,099 | £24,359 | £24,886 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | |
| Bill Payments | £40,871 | £8,238 | £8,233 | £8,228 | £8,223 | £8,218 | £8,213 | £8,208 | £8,203 | £8,198 | £8,193 | £8,188 | |
| Subtotal Spent on Operations | £52,497 | £19,864 | £19,859 | £19,854 | £19,849 | £19,844 | £19,839 | £19,834 | £19,829 | £19,824 | £19,819 | £19,814 | |
| 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 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Other Liabilities Principal Repayment | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Long-term Liabilities Principal Repayment | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £53,497 | £20,964 | £20,959 | £20,954 | £20,949 | £20,944 | £20,939 | £20,934 | £20,929 | £20,924 | £20,919 | £20,914 | |
| Net Cash Flow | (£32,834) | (£3,651) | (£2,834) | £246 | £3,051 | £1,880 | £2,931 | £4,481 | £1,934 | £2,175 | £3,440 | £3,973 | |
| Cash Balance | £12,474 | £8,824 | £5,990 | £6,236 | £9,287 | £11,167 | £14,098 | £18,579 | £20,513 | £22,688 | £26,128 | £30,101 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £45,308 | £12,474 | £8,824 | £5,990 | £6,236 | £9,287 | £11,167 | £14,098 | £18,579 | £20,513 | £22,688 | £26,128 | £30,101 |
| Accounts Receivable | £23,326 | £23,663 | £27,350 | £33,225 | £33,525 | £33,775 | £37,471 | £36,102 | £33,188 | £34,277 | £35,928 | £37,069 | £37,403 |
| Other Current Assets | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 |
| Total Current Assets | £77,464 | £44,967 | £45,004 | £48,045 | £48,591 | £51,892 | £57,469 | £59,030 | £60,596 | £63,620 | £67,446 | £72,027 | £76,333 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 |
| Accumulated Depreciation | £45,691 | £49,691 | £53,691 | £57,690 | £61,690 | £65,690 | £69,690 | £73,689 | £77,689 | £81,689 | £85,689 | £89,688 | £93,688 |
| Total Long-term Assets | £461,996 | £457,996 | £453,997 | £449,997 | £445,997 | £441,997 | £437,998 | £433,998 | £429,998 | £425,998 | £421,999 | £417,999 | £413,999 |
| Total Assets | £539,460 | £502,964 | £499,000 | £498,042 | £494,588 | £493,890 | £495,466 | £493,028 | £490,594 | £489,618 | £489,444 | £490,026 | £490,332 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £40,596 | £7,963 | £7,958 | £7,954 | £7,949 | £7,944 | £7,939 | £7,934 | £7,929 | £7,925 | £7,920 | £7,915 | £7,910 |
| Current Borrowing | £0 | £2,000 | £1,900 | £1,800 | £1,700 | £1,600 | £1,500 | £1,400 | £1,300 | £1,200 | £1,100 | £1,000 | £900 |
| Other Current Liabilities | £22,785 | £22,285 | £21,785 | £21,285 | £20,785 | £20,285 | £19,785 | £19,285 | £18,785 | £18,285 | £17,785 | £17,285 | £16,785 |
| Subtotal Current Liabilities | £63,381 | £32,248 | £31,643 | £31,039 | £30,434 | £29,829 | £29,224 | £28,619 | £28,014 | £27,410 | £26,805 | £26,200 | £25,595 |
| Long-term Liabilities | £17,766 | £17,266 | £16,766 | £16,266 | £15,766 | £15,266 | £14,766 | £14,266 | £13,766 | £13,266 | £12,766 | £12,266 | £11,766 |
| Total Liabilities | £81,147 | £49,514 | £48,409 | £47,305 | £46,200 | £45,095 | £43,990 | £42,885 | £41,780 | £40,676 | £39,571 | £38,466 | £37,361 |
| Paid-in Capital | £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 |
| Retained Earnings | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 |
| Earnings | £0 | (£7,864) | (£10,722) | (£10,576) | (£12,925) | (£12,518) | (£9,837) | (£11,171) | (£12,499) | (£12,371) | (£11,440) | (£9,753) | (£8,342) |
| Total Capital | £458,313 | £453,449 | £450,591 | £450,737 | £448,388 | £448,795 | £451,476 | £450,142 | £448,814 | £448,942 | £449,873 | £451,560 | £452,971 |
| Total Liabilities and Capital | £539,460 | £502,964 | £499,000 | £498,042 | £494,588 | £493,890 | £495,466 | £493,028 | £490,594 | £489,618 | £489,444 | £490,026 | £490,332 |
| Net Worth | £458,313 | £453,449 | £450,591 | £450,737 | £448,388 | £448,795 | £451,476 | £450,142 | £448,814 | £448,942 | £449,874 | £451,560 | £452,971 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Single Family Housing | 0% | £8,320 | £10,920 | £12,480 | £11,180 | £12,610 | £13,790 | £11,700 | £11,700 | £12,455 | £12,870 | £13,260 | £13,114 |
| Other Residential Housing | 0% | £3,200 | £4,200 | £4,800 | £4,300 | £4,850 | £5,304 | £4,500 | £4,500 | £4,790 | £4,950 | £5,100 | £5,044 |
| Commercial Construction | 0% | £4,480 | £5,880 | £6,720 | £6,020 | £6,790 | £7,426 | £6,300 | £6,300 | £6,707 | £6,930 | £7,140 | £7,062 |
| Total Sales | £16,000 | £21,000 | £24,000 | £21,500 | £24,250 | £26,520 | £22,500 | £22,500 | £23,952 | £24,750 | £25,500 | £25,220 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Single Family Housing | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | £433 | |
| Other Residential Housing | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
| Commercial Construction | £233 | £233 | £233 | £233 | £233 | £233 | £233 | £233 | £233 | £233 | £233 | £233 | |
| Subtotal Direct Cost of Sales | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Lloyd James | 0% | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Anne James | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Sam McDonald | 0% | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 |
| Cement Layer No. 1 | 0% | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 |
| Cement Layer No. 2 | 0% | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 |
| Cement Layer No. 3 | 0% | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 | £1,842 |
| Part time Cement Layer No.4 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Part time Cement Layer No. 5 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | |
| 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 Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £16,000 | £21,000 | £24,000 | £21,500 | £24,250 | £26,520 | £22,500 | £22,500 | £23,952 | £24,750 | £25,500 | £25,220 | |
| Direct Cost of Sales | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Other | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Total Cost of Sales | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | £1,083 | |
| Gross Margin | £14,917 | £19,917 | £22,917 | £20,417 | £23,167 | £25,437 | £21,417 | £21,417 | £22,869 | £23,667 | £24,417 | £24,137 | |
| Gross Margin % | 93.23% | 94.84% | 95.49% | 94.96% | 95.53% | 95.92% | 95.19% | 95.19% | 95.48% | 95.62% | 95.75% | 95.70% | |
| Expenses | |||||||||||||
| Payroll | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | |
| Sales and Marketing and Other Expenses | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | £2,862 | |
| Depreciation | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Rent/Mortgage | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | £1,035 | |
| Supplies and Equipment | £827 | £827 | £827 | £827 | £827 | £827 | £827 | £827 | £827 | £827 | £827 | £827 | |
| Insurance | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | £1,205 | |
| Services | £236 | £236 | £236 | £236 | £236 | £236 | £236 | £236 | £236 | £236 | £236 | £236 | |
| Payroll Taxes | 15% | £829 | £829 | £829 | £829 | £829 | £829 | £829 | £829 | £829 | £829 | £829 | £829 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | £22,620 | |
| Profit Before Interest and Taxes | (£7,703) | (£2,703) | £297 | (£2,203) | £547 | £2,817 | (£1,203) | (£1,203) | £249 | £1,047 | £1,797 | £1,517 | |
| EBITDA | (£3,703) | £1,297 | £4,297 | £1,797 | £4,547 | £6,817 | £2,797 | £2,797 | £4,249 | £5,047 | £5,797 | £5,517 | |
| Interest Expense | £161 | £156 | £151 | £146 | £141 | £136 | £131 | £126 | £121 | £116 | £111 | £106 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£7,864) | (£2,859) | £146 | (£2,349) | £406 | £2,681 | (£1,334) | (£1,329) | £128 | £931 | £1,686 | £1,411 | |
| Net Profit/Sales | -49.15% | -13.61% | 0.61% | -10.92% | 1.68% | 10.11% | -5.93% | -5.91% | 0.54% | 3.76% | 6.61% | 5.60% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £4,000 | £5,250 | £6,000 | £5,375 | £6,063 | £6,630 | £5,625 | £5,625 | £5,988 | £6,188 | £6,375 | £6,305 | |
| Cash from Receivables | £11,663 | £12,063 | £12,125 | £15,825 | £17,938 | £16,194 | £18,244 | £19,790 | £16,875 | £16,911 | £17,984 | £18,581 | |
| Subtotal Cash from Operations | £15,663 | £17,313 | £18,125 | £21,200 | £24,000 | £22,824 | £23,869 | £25,415 | £22,863 | £23,099 | £24,359 | £24,886 | |
| 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 | £2,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 | £3,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £20,663 | £17,313 | £18,125 | £21,200 | £24,000 | £22,824 | £23,869 | £25,415 | £22,863 | £23,099 | £24,359 | £24,886 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | £11,626 | |
| Bill Payments | £40,871 | £8,238 | £8,233 | £8,228 | £8,223 | £8,218 | £8,213 | £8,208 | £8,203 | £8,198 | £8,193 | £8,188 | |
| Subtotal Spent on Operations | £52,497 | £19,864 | £19,859 | £19,854 | £19,849 | £19,844 | £19,839 | £19,834 | £19,829 | £19,824 | £19,819 | £19,814 | |
| 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 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Other Liabilities Principal Repayment | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Long-term Liabilities Principal Repayment | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £53,497 | £20,964 | £20,959 | £20,954 | £20,949 | £20,944 | £20,939 | £20,934 | £20,929 | £20,924 | £20,919 | £20,914 | |
| Net Cash Flow | (£32,834) | (£3,651) | (£2,834) | £246 | £3,051 | £1,880 | £2,931 | £4,481 | £1,934 | £2,175 | £3,440 | £3,973 | |
| Cash Balance | £12,474 | £8,824 | £5,990 | £6,236 | £9,287 | £11,167 | £14,098 | £18,579 | £20,513 | £22,688 | £26,128 | £30,101 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £45,308 | £12,474 | £8,824 | £5,990 | £6,236 | £9,287 | £11,167 | £14,098 | £18,579 | £20,513 | £22,688 | £26,128 | £30,101 |
| Accounts Receivable | £23,326 | £23,663 | £27,350 | £33,225 | £33,525 | £33,775 | £37,471 | £36,102 | £33,188 | £34,277 | £35,928 | £37,069 | £37,403 |
| Other Current Assets | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 | £8,830 |
| Total Current Assets | £77,464 | £44,967 | £45,004 | £48,045 | £48,591 | £51,892 | £57,469 | £59,030 | £60,596 | £63,620 | £67,446 | £72,027 | £76,333 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 | £507,687 |
| Accumulated Depreciation | £45,691 | £49,691 | £53,691 | £57,690 | £61,690 | £65,690 | £69,690 | £73,689 | £77,689 | £81,689 | £85,689 | £89,688 | £93,688 |
| Total Long-term Assets | £461,996 | £457,996 | £453,997 | £449,997 | £445,997 | £441,997 | £437,998 | £433,998 | £429,998 | £425,998 | £421,999 | £417,999 | £413,999 |
| Total Assets | £539,460 | £502,964 | £499,000 | £498,042 | £494,588 | £493,890 | £495,466 | £493,028 | £490,594 | £489,618 | £489,444 | £490,026 | £490,332 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £40,596 | £7,963 | £7,958 | £7,954 | £7,949 | £7,944 | £7,939 | £7,934 | £7,929 | £7,925 | £7,920 | £7,915 | £7,910 |
| Current Borrowing | £0 | £2,000 | £1,900 | £1,800 | £1,700 | £1,600 | £1,500 | £1,400 | £1,300 | £1,200 | £1,100 | £1,000 | £900 |
| Other Current Liabilities | £22,785 | £22,285 | £21,785 | £21,285 | £20,785 | £20,285 | £19,785 | £19,285 | £18,785 | £18,285 | £17,785 | £17,285 | £16,785 |
| Subtotal Current Liabilities | £63,381 | £32,248 | £31,643 | £31,039 | £30,434 | £29,829 | £29,224 | £28,619 | £28,014 | £27,410 | £26,805 | £26,200 | £25,595 |
| Long-term Liabilities | £17,766 | £17,266 | £16,766 | £16,266 | £15,766 | £15,266 | £14,766 | £14,266 | £13,766 | £13,266 | £12,766 | £12,266 | £11,766 |
| Total Liabilities | £81,147 | £49,514 | £48,409 | £47,305 | £46,200 | £45,095 | £43,990 | £42,885 | £41,780 | £40,676 | £39,571 | £38,466 | £37,361 |
| Paid-in Capital | £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 |
| Retained Earnings | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 | £458,313 |
| Earnings | £0 | (£7,864) | (£10,722) | (£10,576) | (£12,925) | (£12,518) | (£9,837) | (£11,171) | (£12,499) | (£12,371) | (£11,440) | (£9,753) | (£8,342) |
| Total Capital | £458,313 | £453,449 | £450,591 | £450,737 | £448,388 | £448,795 | £451,476 | £450,142 | £448,814 | £448,942 | £449,873 | £451,560 | £452,971 |
| Total Liabilities and Capital | £539,460 | £502,964 | £499,000 | £498,042 | £494,588 | £493,890 | £495,466 | £493,028 | £490,594 | £489,618 | £489,444 | £490,026 | £490,332 |
| Net Worth | £458,313 | £453,449 | £450,591 | £450,737 | £448,388 | £448,795 | £451,476 | £450,142 | £448,814 | £448,942 | £449,874 | £451,560 | £452,971 |