| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Sales | 0% | £54,000 | £28,500 | £44,500 | £45,000 | £57,000 | £65,000 | £67,000 | £65,000 | £70,000 | £80,000 | £55,000 | £46,600 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £54,000 | £28,500 | £44,500 | £45,000 | £57,000 | £65,000 | £67,000 | £65,000 | £70,000 | £80,000 | £55,000 | £46,600 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Name or Title or Group | 0% | £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 | £0 |
| Name or Title or Group | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £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 | £54,000 | £28,500 | £44,500 | £45,000 | £57,000 | £65,000 | £67,000 | £65,000 | £70,000 | £80,000 | £55,000 | £46,600 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £54,000 | £28,500 | £44,500 | £45,000 | £57,000 | £65,000 | £67,000 | £65,000 | £70,000 | £80,000 | £55,000 | £46,600 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Marketing/Promotion | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Profit Before Interest and Taxes | £54,000 | £28,500 | £44,500 | £45,000 | £57,000 | £65,000 | £67,000 | £65,000 | £70,000 | £80,000 | £55,000 | £46,600 | |
| EBITDA | £54,000 | £28,500 | £44,500 | £45,000 | £57,000 | £65,000 | £67,000 | £65,000 | £70,000 | £80,000 | £55,000 | £46,600 | |
| Interest Expense | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | |
| Taxes Incurred | £15,070 | £7,420 | £12,220 | £12,370 | £15,970 | £18,370 | £18,970 | £18,370 | £19,870 | £22,870 | £15,370 | £12,850 | |
| Net Profit | £35,163 | £17,313 | £28,513 | £28,863 | £37,263 | £42,863 | £44,263 | £42,863 | £46,363 | £53,363 | £35,863 | £29,983 | |
| Net Profit/Sales | 65.12% | 60.75% | 64.07% | 64.14% | 65.37% | 65.94% | 66.06% | 65.94% | 66.23% | 66.70% | 65.21% | 64.34% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £13,500 | £7,125 | £11,125 | £11,250 | £14,250 | £16,250 | £16,750 | £16,250 | £17,500 | £20,000 | £13,750 | £11,650 | |
| Cash from Receivables | £127,970 | £129,320 | £39,863 | £21,775 | £33,388 | £34,050 | £42,950 | £48,800 | £50,200 | £48,875 | £52,750 | £59,375 | |
| Subtotal Cash from Operations | £141,470 | £136,445 | £50,988 | £33,025 | £47,638 | £50,300 | £59,700 | £65,050 | £67,700 | £68,875 | £66,500 | £71,025 | |
| 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 | £141,470 | £136,445 | £50,988 | £33,025 | £47,638 | £50,300 | £59,700 | £65,050 | £67,700 | £68,875 | £66,500 | £71,025 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Bill Payments | £336,628 | £18,582 | £11,347 | £15,992 | £16,257 | £19,817 | £22,157 | £22,717 | £22,187 | £23,737 | £26,387 | £19,053 | |
| Subtotal Spent on Operations | £336,628 | £18,582 | £11,347 | £15,992 | £16,257 | £19,817 | £22,157 | £22,717 | £22,187 | £23,737 | £26,387 | £19,053 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £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 | £336,628 | £18,582 | £11,347 | £15,992 | £16,257 | £19,817 | £22,157 | £22,717 | £22,187 | £23,737 | £26,387 | £19,053 | |
| Net Cash Flow | (£195,158) | £117,863 | £39,641 | £17,033 | £31,381 | £30,483 | £37,543 | £42,333 | £45,513 | £45,138 | £40,113 | £51,972 | |
| Cash Balance | £207,482 | £325,345 | £364,986 | £382,019 | £413,400 | £443,883 | £481,426 | £523,759 | £569,272 | £614,410 | £654,523 | £706,495 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £402,640 | £207,482 | £325,345 | £364,986 | £382,019 | £413,400 | £443,883 | £481,426 | £523,759 | £569,272 | £614,410 | £654,523 | £706,495 |
| Accounts Receivable | £255,940 | £168,470 | £60,525 | £54,038 | £66,013 | £75,375 | £90,075 | £97,375 | £97,325 | £99,625 | £110,750 | £99,250 | £74,825 |
| Other Current Assets | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 |
| Total Current Assets | £967,717 | £685,089 | £695,007 | £728,160 | £757,168 | £797,912 | £843,095 | £887,938 | £930,221 | £978,034 | £1,034,297 | £1,062,910 | £1,090,457 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 |
| Accumulated Depreciation | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 |
| Total Long-term Assets | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 |
| Total Assets | £1,251,641 | £969,013 | £978,931 | £1,012,084 | £1,041,092 | £1,081,836 | £1,127,019 | £1,171,862 | £1,214,145 | £1,261,958 | £1,318,221 | £1,346,834 | £1,374,381 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £336,000 | £18,209 | £10,814 | £15,454 | £15,599 | £19,079 | £21,399 | £21,979 | £21,399 | £22,849 | £25,749 | £18,499 | £16,063 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 |
| Subtotal Current Liabilities | £436,362 | £118,571 | £111,176 | £115,816 | £115,961 | £119,441 | £121,761 | £122,341 | £121,761 | £123,211 | £126,111 | £118,861 | £116,425 |
| Long-term Liabilities | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 |
| Total Liabilities | £888,398 | £570,607 | £563,212 | £567,852 | £567,997 | £571,477 | £573,797 | £574,377 | £573,797 | £575,247 | £578,147 | £570,897 | £568,461 |
| Paid-in Capital | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Retained Earnings | £88,096 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 |
| Earnings | £275,047 | £35,163 | £52,476 | £80,989 | £109,852 | £147,116 | £189,979 | £234,242 | £277,105 | £323,468 | £376,831 | £412,694 | £442,677 |
| Total Capital | £363,243 | £398,406 | £415,719 | £444,232 | £473,095 | £510,359 | £553,222 | £597,485 | £640,348 | £686,711 | £740,074 | £775,937 | £805,920 |
| Total Liabilities and Capital | £1,251,641 | £969,013 | £978,931 | £1,012,084 | £1,041,092 | £1,081,836 | £1,127,019 | £1,171,862 | £1,214,145 | £1,261,958 | £1,318,221 | £1,346,834 | £1,374,381 |
| Net Worth | £363,243 | £398,406 | £415,719 | £444,232 | £473,095 | £510,359 | £553,222 | £597,485 | £640,348 | £686,711 | £740,074 | £775,937 | £805,920 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Sales | 0% | £54,000 | £28,500 | £44,500 | £45,000 | £57,000 | £65,000 | £67,000 | £65,000 | £70,000 | £80,000 | £55,000 | £46,600 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £54,000 | £28,500 | £44,500 | £45,000 | £57,000 | £65,000 | £67,000 | £65,000 | £70,000 | £80,000 | £55,000 | £46,600 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Name or Title or Group | 0% | £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 | £0 |
| Name or Title or Group | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £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 | £54,000 | £28,500 | £44,500 | £45,000 | £57,000 | £65,000 | £67,000 | £65,000 | £70,000 | £80,000 | £55,000 | £46,600 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Gross Margin | £54,000 | £28,500 | £44,500 | £45,000 | £57,000 | £65,000 | £67,000 | £65,000 | £70,000 | £80,000 | £55,000 | £46,600 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Marketing/Promotion | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Profit Before Interest and Taxes | £54,000 | £28,500 | £44,500 | £45,000 | £57,000 | £65,000 | £67,000 | £65,000 | £70,000 | £80,000 | £55,000 | £46,600 | |
| EBITDA | £54,000 | £28,500 | £44,500 | £45,000 | £57,000 | £65,000 | £67,000 | £65,000 | £70,000 | £80,000 | £55,000 | £46,600 | |
| Interest Expense | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | £3,767 | |
| Taxes Incurred | £15,070 | £7,420 | £12,220 | £12,370 | £15,970 | £18,370 | £18,970 | £18,370 | £19,870 | £22,870 | £15,370 | £12,850 | |
| Net Profit | £35,163 | £17,313 | £28,513 | £28,863 | £37,263 | £42,863 | £44,263 | £42,863 | £46,363 | £53,363 | £35,863 | £29,983 | |
| Net Profit/Sales | 65.12% | 60.75% | 64.07% | 64.14% | 65.37% | 65.94% | 66.06% | 65.94% | 66.23% | 66.70% | 65.21% | 64.34% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £13,500 | £7,125 | £11,125 | £11,250 | £14,250 | £16,250 | £16,750 | £16,250 | £17,500 | £20,000 | £13,750 | £11,650 | |
| Cash from Receivables | £127,970 | £129,320 | £39,863 | £21,775 | £33,388 | £34,050 | £42,950 | £48,800 | £50,200 | £48,875 | £52,750 | £59,375 | |
| Subtotal Cash from Operations | £141,470 | £136,445 | £50,988 | £33,025 | £47,638 | £50,300 | £59,700 | £65,050 | £67,700 | £68,875 | £66,500 | £71,025 | |
| 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 | £141,470 | £136,445 | £50,988 | £33,025 | £47,638 | £50,300 | £59,700 | £65,050 | £67,700 | £68,875 | £66,500 | £71,025 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Bill Payments | £336,628 | £18,582 | £11,347 | £15,992 | £16,257 | £19,817 | £22,157 | £22,717 | £22,187 | £23,737 | £26,387 | £19,053 | |
| Subtotal Spent on Operations | £336,628 | £18,582 | £11,347 | £15,992 | £16,257 | £19,817 | £22,157 | £22,717 | £22,187 | £23,737 | £26,387 | £19,053 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Principal Repayment of Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £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 | £336,628 | £18,582 | £11,347 | £15,992 | £16,257 | £19,817 | £22,157 | £22,717 | £22,187 | £23,737 | £26,387 | £19,053 | |
| Net Cash Flow | (£195,158) | £117,863 | £39,641 | £17,033 | £31,381 | £30,483 | £37,543 | £42,333 | £45,513 | £45,138 | £40,113 | £51,972 | |
| Cash Balance | £207,482 | £325,345 | £364,986 | £382,019 | £413,400 | £443,883 | £481,426 | £523,759 | £569,272 | £614,410 | £654,523 | £706,495 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £402,640 | £207,482 | £325,345 | £364,986 | £382,019 | £413,400 | £443,883 | £481,426 | £523,759 | £569,272 | £614,410 | £654,523 | £706,495 |
| Accounts Receivable | £255,940 | £168,470 | £60,525 | £54,038 | £66,013 | £75,375 | £90,075 | £97,375 | £97,325 | £99,625 | £110,750 | £99,250 | £74,825 |
| Other Current Assets | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 | £309,137 |
| Total Current Assets | £967,717 | £685,089 | £695,007 | £728,160 | £757,168 | £797,912 | £843,095 | £887,938 | £930,221 | £978,034 | £1,034,297 | £1,062,910 | £1,090,457 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 | £465,575 |
| Accumulated Depreciation | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 | £181,651 |
| Total Long-term Assets | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 | £283,924 |
| Total Assets | £1,251,641 | £969,013 | £978,931 | £1,012,084 | £1,041,092 | £1,081,836 | £1,127,019 | £1,171,862 | £1,214,145 | £1,261,958 | £1,318,221 | £1,346,834 | £1,374,381 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £336,000 | £18,209 | £10,814 | £15,454 | £15,599 | £19,079 | £21,399 | £21,979 | £21,399 | £22,849 | £25,749 | £18,499 | £16,063 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 | £100,362 |
| Subtotal Current Liabilities | £436,362 | £118,571 | £111,176 | £115,816 | £115,961 | £119,441 | £121,761 | £122,341 | £121,761 | £123,211 | £126,111 | £118,861 | £116,425 |
| Long-term Liabilities | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 | £452,036 |
| Total Liabilities | £888,398 | £570,607 | £563,212 | £567,852 | £567,997 | £571,477 | £573,797 | £574,377 | £573,797 | £575,247 | £578,147 | £570,897 | £568,461 |
| Paid-in Capital | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 |
| Retained Earnings | £88,096 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 | £363,143 |
| Earnings | £275,047 | £35,163 | £52,476 | £80,989 | £109,852 | £147,116 | £189,979 | £234,242 | £277,105 | £323,468 | £376,831 | £412,694 | £442,677 |
| Total Capital | £363,243 | £398,406 | £415,719 | £444,232 | £473,095 | £510,359 | £553,222 | £597,485 | £640,348 | £686,711 | £740,074 | £775,937 | £805,920 |
| Total Liabilities and Capital | £1,251,641 | £969,013 | £978,931 | £1,012,084 | £1,041,092 | £1,081,836 | £1,127,019 | £1,171,862 | £1,214,145 | £1,261,958 | £1,318,221 | £1,346,834 | £1,374,381 |
| Net Worth | £363,243 | £398,406 | £415,719 | £444,232 | £473,095 | £510,359 | £553,222 | £597,485 | £640,348 | £686,711 | £740,074 | £775,937 | £805,920 |