| Sales Forecast | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | |||||||||||||
| Residential Inspection Services | 0% | £8,000 | £12,000 | £16,000 | £18,000 | £14,000 | £13,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Commercial Inspection Services | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Field Services | 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 |
| Property Preservation Services | 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 |
| Total Sales | £17,500 | £21,500 | £25,500 | £27,500 | £23,500 | £22,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | |
| Direct Cost of Sales | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Mileage | £2,538 | £3,118 | £3,697 | £3,987 | £3,407 | £3,263 | £2,538 | £2,538 | £2,538 | £2,538 | £2,538 | £2,538 | |
| Report Materials | £1,050 | £1,290 | £1,530 | £1,650 | £1,410 | £1,350 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | |
| Subtotal Direct Cost of Sales | £3,588 | £4,408 | £5,228 | £5,638 | £4,818 | £4,613 | £3,588 | £3,588 | £3,588 | £3,588 | £3,588 | £3,588 | |
| Personnel Plan | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Owner\Founders | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Employees | 0% | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Pro Forma Profit and Loss | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | £17,500 | £21,500 | £25,500 | £27,500 | £23,500 | £22,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | |
| Direct Cost of Sales | £3,588 | £4,408 | £5,228 | £5,638 | £4,818 | £4,613 | £3,588 | £3,588 | £3,588 | £3,588 | £3,588 | £3,588 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,588 | £4,408 | £5,228 | £5,638 | £4,818 | £4,613 | £3,588 | £3,588 | £3,588 | £3,588 | £3,588 | £3,588 | |
| Gross Margin | £13,913 | £17,093 | £20,273 | £21,863 | £18,683 | £17,888 | £13,913 | £13,913 | £13,913 | £13,913 | £13,913 | £13,913 | |
| Gross Margin % | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Marketing/Promotion | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £0 | £0 | £0 | £0 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Utilities | £0 | £0 | £0 | £0 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Website Hosting and Maintenance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Bookkeeping Service | 15% | £250 | £250 | £250 | £250 | £250 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Operating Expenses | £1,450 | £1,450 | £1,450 | £1,450 | £2,350 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | |
| Profit Before Interest and Taxes | £12,463 | £15,643 | £18,823 | £20,413 | £16,333 | £12,288 | £8,313 | £8,313 | £8,313 | £8,313 | £8,313 | £8,313 | |
| EBITDA | £12,463 | £15,643 | £18,823 | £20,413 | £16,333 | £12,288 | £8,313 | £8,313 | £8,313 | £8,313 | £8,313 | £8,313 | |
| Interest Expense | £48 | £48 | £47 | £46 | £46 | £45 | £44 | £43 | £43 | £42 | £41 | £40 | |
| Taxes Incurred | £3,724 | £4,678 | £5,633 | £6,110 | £4,886 | £3,673 | £2,481 | £2,481 | £2,481 | £2,481 | £2,481 | £2,482 | |
| Net Profit | £8,690 | £10,916 | £13,143 | £14,256 | £11,401 | £8,570 | £5,788 | £5,788 | £5,789 | £5,789 | £5,790 | £5,790 | |
| Net Profit/Sales | 49.66% | 50.77% | 51.54% | 51.84% | 48.51% | 38.09% | 33.07% | 33.08% | 33.08% | 33.08% | 33.09% | 33.09% | |
| Pro Forma Cash Flow | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £5,250 | £6,450 | £7,650 | £8,250 | £7,050 | £6,750 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | |
| Cash from Receivables | £10,820 | £11,228 | £12,343 | £15,143 | £17,897 | £19,157 | £16,427 | £15,633 | £12,250 | £12,250 | £12,250 | £12,250 | |
| Subtotal Cash from Operations | £16,070 | £17,678 | £19,993 | £23,393 | £24,947 | £25,907 | £21,677 | £20,883 | £17,500 | £17,500 | £17,500 | £17,500 | |
| 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 | £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 | £16,070 | £17,678 | £19,993 | £23,393 | £24,947 | £25,907 | £21,677 | £20,883 | £17,500 | £17,500 | £17,500 | £17,500 | |
| Expenditures | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Bill Payments | £2,294 | £8,869 | £10,643 | £12,387 | £13,205 | £12,060 | £10,856 | £8,712 | £8,712 | £8,711 | £8,711 | £8,710 | |
| Subtotal Spent on Operations | £2,294 | £8,869 | £10,643 | £12,387 | £13,205 | £15,060 | £13,856 | £11,712 | £11,712 | £11,711 | £11,711 | £11,710 | |
| 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 | £145 | £145 | £145 | £145 | £145 | £145 | £145 | £145 | £145 | £145 | £145 | £145 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £2,439 | £9,014 | £10,788 | £12,532 | £13,350 | £15,205 | £14,001 | £11,857 | £11,857 | £11,856 | £11,856 | £11,855 | |
| Net Cash Flow | £13,631 | £8,664 | £9,206 | £10,862 | £11,596 | £10,702 | £7,676 | £9,026 | £5,643 | £5,644 | £5,644 | £5,645 | |
| Cash Balance | £16,631 | £25,294 | £34,500 | £45,362 | £56,958 | £67,659 | £75,335 | £84,361 | £90,005 | £95,649 | £101,293 | £106,938 | |
| Pro Forma Balance Sheet | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £3,000 | £16,631 | £25,294 | £34,500 | £45,362 | £56,958 | £67,659 | £75,335 | £84,361 | £90,005 | £95,649 | £101,293 | £106,938 |
| Accounts Receivable | £21,639 | £23,070 | £26,892 | £32,398 | £36,505 | £35,058 | £31,652 | £27,475 | £24,092 | £24,092 | £24,092 | £24,092 | £24,092 |
| Other Current Assets | £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 |
| Total Current Assets | £49,639 | £64,700 | £77,186 | £91,898 | £106,867 | £117,016 | £124,311 | £127,810 | £133,453 | £139,096 | £144,740 | £150,385 | £156,030 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Total Assets | £64,639 | £79,700 | £92,186 | £106,898 | £121,867 | £132,016 | £139,311 | £142,810 | £148,453 | £154,096 | £159,740 | £165,385 | £171,030 |
| Liabilities and Capital | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £2,000 | £8,516 | £10,231 | £11,945 | £12,802 | £11,696 | £10,566 | £8,422 | £8,421 | £8,421 | £8,420 | £8,420 | £8,419 |
| Current Borrowing | £9,827 | £9,682 | £9,537 | £9,392 | £9,247 | £9,102 | £8,957 | £8,812 | £8,667 | £8,522 | £8,377 | £8,232 | £8,087 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £11,827 | £18,198 | £19,768 | £21,337 | £22,049 | £20,798 | £19,523 | £17,234 | £17,088 | £16,943 | £16,797 | £16,652 | £16,506 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £11,827 | £18,198 | £19,768 | £21,337 | £22,049 | £20,798 | £19,523 | £17,234 | £17,088 | £16,943 | £16,797 | £16,652 | £16,506 |
| Paid-in Capital | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Retained Earnings | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 |
| Earnings | £0 | £8,690 | £19,606 | £32,749 | £47,005 | £58,406 | £66,976 | £72,764 | £78,553 | £84,342 | £90,131 | £95,921 | £101,711 |
| Total Capital | £52,812 | £61,502 | £72,418 | £85,561 | £99,817 | £111,218 | £119,788 | £125,576 | £131,365 | £137,154 | £142,943 | £148,733 | £154,523 |
| Total Liabilities and Capital | £64,639 | £79,700 | £92,186 | £106,898 | £121,867 | £132,016 | £139,311 | £142,810 | £148,453 | £154,096 | £159,740 | £165,385 | £171,030 |
| Net Worth | £52,812 | £61,502 | £72,418 | £85,561 | £99,817 | £111,218 | £119,788 | £125,576 | £131,365 | £137,154 | £142,943 | £148,733 | £154,523 |
| Sales Forecast | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | |||||||||||||
| Residential Inspection Services | 0% | £8,000 | £12,000 | £16,000 | £18,000 | £14,000 | £13,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Commercial Inspection Services | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Field Services | 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 |
| Property Preservation Services | 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 |
| Total Sales | £17,500 | £21,500 | £25,500 | £27,500 | £23,500 | £22,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | |
| Direct Cost of Sales | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Mileage | £2,538 | £3,118 | £3,697 | £3,987 | £3,407 | £3,263 | £2,538 | £2,538 | £2,538 | £2,538 | £2,538 | £2,538 | |
| Report Materials | £1,050 | £1,290 | £1,530 | £1,650 | £1,410 | £1,350 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | |
| Subtotal Direct Cost of Sales | £3,588 | £4,408 | £5,228 | £5,638 | £4,818 | £4,613 | £3,588 | £3,588 | £3,588 | £3,588 | £3,588 | £3,588 | |
| Personnel Plan | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Owner\Founders | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Employees | 0% | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Pro Forma Profit and Loss | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | £17,500 | £21,500 | £25,500 | £27,500 | £23,500 | £22,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | |
| Direct Cost of Sales | £3,588 | £4,408 | £5,228 | £5,638 | £4,818 | £4,613 | £3,588 | £3,588 | £3,588 | £3,588 | £3,588 | £3,588 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,588 | £4,408 | £5,228 | £5,638 | £4,818 | £4,613 | £3,588 | £3,588 | £3,588 | £3,588 | £3,588 | £3,588 | |
| Gross Margin | £13,913 | £17,093 | £20,273 | £21,863 | £18,683 | £17,888 | £13,913 | £13,913 | £13,913 | £13,913 | £13,913 | £13,913 | |
| Gross Margin % | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | 79.50% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Marketing/Promotion | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £0 | £0 | £0 | £0 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Utilities | £0 | £0 | £0 | £0 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Website Hosting and Maintenance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Bookkeeping Service | 15% | £250 | £250 | £250 | £250 | £250 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Operating Expenses | £1,450 | £1,450 | £1,450 | £1,450 | £2,350 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | |
| Profit Before Interest and Taxes | £12,463 | £15,643 | £18,823 | £20,413 | £16,333 | £12,288 | £8,313 | £8,313 | £8,313 | £8,313 | £8,313 | £8,313 | |
| EBITDA | £12,463 | £15,643 | £18,823 | £20,413 | £16,333 | £12,288 | £8,313 | £8,313 | £8,313 | £8,313 | £8,313 | £8,313 | |
| Interest Expense | £48 | £48 | £47 | £46 | £46 | £45 | £44 | £43 | £43 | £42 | £41 | £40 | |
| Taxes Incurred | £3,724 | £4,678 | £5,633 | £6,110 | £4,886 | £3,673 | £2,481 | £2,481 | £2,481 | £2,481 | £2,481 | £2,482 | |
| Net Profit | £8,690 | £10,916 | £13,143 | £14,256 | £11,401 | £8,570 | £5,788 | £5,788 | £5,789 | £5,789 | £5,790 | £5,790 | |
| Net Profit/Sales | 49.66% | 50.77% | 51.54% | 51.84% | 48.51% | 38.09% | 33.07% | 33.08% | 33.08% | 33.08% | 33.09% | 33.09% | |
| Pro Forma Cash Flow | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £5,250 | £6,450 | £7,650 | £8,250 | £7,050 | £6,750 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | £5,250 | |
| Cash from Receivables | £10,820 | £11,228 | £12,343 | £15,143 | £17,897 | £19,157 | £16,427 | £15,633 | £12,250 | £12,250 | £12,250 | £12,250 | |
| Subtotal Cash from Operations | £16,070 | £17,678 | £19,993 | £23,393 | £24,947 | £25,907 | £21,677 | £20,883 | £17,500 | £17,500 | £17,500 | £17,500 | |
| 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 | £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 | £16,070 | £17,678 | £19,993 | £23,393 | £24,947 | £25,907 | £21,677 | £20,883 | £17,500 | £17,500 | £17,500 | £17,500 | |
| Expenditures | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Bill Payments | £2,294 | £8,869 | £10,643 | £12,387 | £13,205 | £12,060 | £10,856 | £8,712 | £8,712 | £8,711 | £8,711 | £8,710 | |
| Subtotal Spent on Operations | £2,294 | £8,869 | £10,643 | £12,387 | £13,205 | £15,060 | £13,856 | £11,712 | £11,712 | £11,711 | £11,711 | £11,710 | |
| 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 | £145 | £145 | £145 | £145 | £145 | £145 | £145 | £145 | £145 | £145 | £145 | £145 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £2,439 | £9,014 | £10,788 | £12,532 | £13,350 | £15,205 | £14,001 | £11,857 | £11,857 | £11,856 | £11,856 | £11,855 | |
| Net Cash Flow | £13,631 | £8,664 | £9,206 | £10,862 | £11,596 | £10,702 | £7,676 | £9,026 | £5,643 | £5,644 | £5,644 | £5,645 | |
| Cash Balance | £16,631 | £25,294 | £34,500 | £45,362 | £56,958 | £67,659 | £75,335 | £84,361 | £90,005 | £95,649 | £101,293 | £106,938 | |
| Pro Forma Balance Sheet | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £3,000 | £16,631 | £25,294 | £34,500 | £45,362 | £56,958 | £67,659 | £75,335 | £84,361 | £90,005 | £95,649 | £101,293 | £106,938 |
| Accounts Receivable | £21,639 | £23,070 | £26,892 | £32,398 | £36,505 | £35,058 | £31,652 | £27,475 | £24,092 | £24,092 | £24,092 | £24,092 | £24,092 |
| Other Current Assets | £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 |
| Total Current Assets | £49,639 | £64,700 | £77,186 | £91,898 | £106,867 | £117,016 | £124,311 | £127,810 | £133,453 | £139,096 | £144,740 | £150,385 | £156,030 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Total Assets | £64,639 | £79,700 | £92,186 | £106,898 | £121,867 | £132,016 | £139,311 | £142,810 | £148,453 | £154,096 | £159,740 | £165,385 | £171,030 |
| Liabilities and Capital | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £2,000 | £8,516 | £10,231 | £11,945 | £12,802 | £11,696 | £10,566 | £8,422 | £8,421 | £8,421 | £8,420 | £8,420 | £8,419 |
| Current Borrowing | £9,827 | £9,682 | £9,537 | £9,392 | £9,247 | £9,102 | £8,957 | £8,812 | £8,667 | £8,522 | £8,377 | £8,232 | £8,087 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £11,827 | £18,198 | £19,768 | £21,337 | £22,049 | £20,798 | £19,523 | £17,234 | £17,088 | £16,943 | £16,797 | £16,652 | £16,506 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £11,827 | £18,198 | £19,768 | £21,337 | £22,049 | £20,798 | £19,523 | £17,234 | £17,088 | £16,943 | £16,797 | £16,652 | £16,506 |
| Paid-in Capital | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Retained Earnings | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 | £22,812 |
| Earnings | £0 | £8,690 | £19,606 | £32,749 | £47,005 | £58,406 | £66,976 | £72,764 | £78,553 | £84,342 | £90,131 | £95,921 | £101,711 |
| Total Capital | £52,812 | £61,502 | £72,418 | £85,561 | £99,817 | £111,218 | £119,788 | £125,576 | £131,365 | £137,154 | £142,943 | £148,733 | £154,523 |
| Total Liabilities and Capital | £64,639 | £79,700 | £92,186 | £106,898 | £121,867 | £132,016 | £139,311 | £142,810 | £148,453 | £154,096 | £159,740 | £165,385 | £171,030 |
| Net Worth | £52,812 | £61,502 | £72,418 | £85,561 | £99,817 | £111,218 | £119,788 | £125,576 | £131,365 | £137,154 | £142,943 | £148,733 | £154,523 |