| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Rooms | 0% | £2,042 | £3,354 | £4,682 | £16,500 | £8,250 | £3,245 | £2,565 | £2,650 | £2,650 | £3,850 | £4,200 | £4,850 |
| Food | 0% | £278 | £838 | £1,540 | £5,350 | £4,950 | £2,850 | £2,850 | £2,850 | £3,150 | £3,250 | £3,250 | £5,400 |
| RV Park | 0% | £163 | £142 | £492 | £3,250 | £2,250 | £1,675 | £850 | £500 | £300 | £175 | £100 | £250 |
| Bar | 0% | £3,501 | £2,849 | £2,808 | £6,250 | £5,245 | £3,450 | £3,400 | £3,400 | £3,400 | £3,400 | £3,400 | £4,750 |
| Total Sales | £5,984 | £7,183 | £9,522 | £31,350 | £20,695 | £11,220 | £9,665 | £9,400 | £9,500 | £10,675 | £10,950 | £15,250 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Rooms | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | |
| Food | £75 | £65 | £125 | £1,050 | £900 | £625 | £625 | £625 | £675 | £675 | £675 | £750 | |
| RV Park | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | |
| Bar | £1,250 | £150 | £175 | £476 | £375 | £200 | £200 | £200 | £200 | £200 | £200 | £300 | |
| Subtotal Direct Cost of Sales | £1,365 | £255 | £340 | £1,566 | £1,315 | £865 | £865 | £865 | £915 | £915 | £915 | £1,090 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Assistant Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Cook | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £300 | £300 | £300 | £300 |
| Maintenance Staff | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Cleaning Staff | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £300 | £300 | £300 | £300 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 5 | 5 | 50 | 5 | |
| Total Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £600 | £600 | £600 | £600 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £5,984 | £7,183 | £9,522 | £31,350 | £20,695 | £11,220 | £9,665 | £9,400 | £9,500 | £10,675 | £10,950 | £15,250 | |
| Direct Cost of Sales | £1,365 | £255 | £340 | £1,566 | £1,315 | £865 | £865 | £865 | £915 | £915 | £915 | £1,090 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,365 | £255 | £340 | £1,566 | £1,315 | £865 | £865 | £865 | £915 | £915 | £915 | £1,090 | |
| Gross Margin | £4,619 | £6,928 | £9,182 | £29,784 | £19,380 | £10,355 | £8,800 | £8,535 | £8,585 | £9,760 | £10,035 | £14,160 | |
| Gross Margin % | 77.19% | 96.45% | 96.43% | 95.00% | 93.65% | 92.29% | 91.05% | 90.80% | 90.37% | 91.43% | 91.64% | 92.85% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £600 | £600 | £600 | £600 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £210 | £85 | £100 | £100 | £100 | £125 | £145 | £145 | £150 | |
| Depreciation | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £187 | £168 | £410 | £260 | £250 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Insurance | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | |
| Lease | £1,300 | £1,500 | £1,500 | £1,500 | £1,500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Mortgage Payment | 15% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £2,902 | £3,083 | £3,325 | £3,385 | £3,250 | £3,865 | £3,865 | £3,865 | £4,490 | £4,510 | £4,510 | £4,515 | |
| Profit Before Interest and Taxes | £1,717 | £3,845 | £5,857 | £26,399 | £16,130 | £6,490 | £4,935 | £4,670 | £4,095 | £5,250 | £5,525 | £9,645 | |
| EBITDA | £2,907 | £5,035 | £7,047 | £27,589 | £17,320 | £7,680 | £6,125 | £5,860 | £5,285 | £6,440 | £6,715 | £10,835 | |
| Interest Expense | £1,933 | £1,933 | £1,933 | £1,933 | £1,933 | £1,933 | £1,917 | £1,900 | £1,883 | £1,867 | £1,850 | £1,833 | |
| Taxes Incurred | (£65) | £574 | £1,177 | £7,340 | £4,259 | £1,367 | £905 | £831 | £664 | £1,015 | £1,103 | £2,344 | |
| Net Profit | (£152) | £1,338 | £2,746 | £17,126 | £9,938 | £3,190 | £2,113 | £1,939 | £1,548 | £2,368 | £2,573 | £5,468 | |
| Net Profit/Sales | -2.53% | 18.63% | 28.84% | 54.63% | 48.02% | 28.43% | 21.86% | 20.63% | 16.30% | 22.19% | 23.49% | 35.86% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £5,984 | £7,183 | £9,522 | £31,350 | £20,695 | £11,220 | £9,665 | £9,400 | £9,500 | £10,675 | £10,950 | £15,250 | |
| Subtotal Cash from Operations | £5,984 | £7,183 | £9,522 | £31,350 | £20,695 | £11,220 | £9,665 | £9,400 | £9,500 | £10,675 | £10,950 | £15,250 | |
| 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 | £5,984 | £7,183 | £9,522 | £31,350 | £20,695 | £11,220 | £9,665 | £9,400 | £9,500 | £10,675 | £10,950 | £15,250 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £600 | £600 | £600 | £600 | |
| Bill Payments | £1,262 | £6,379 | £4,428 | £5,532 | £13,698 | £9,214 | £6,959 | £6,494 | £6,401 | £6,225 | £5,637 | £6,720 | |
| Subtotal Spent on Operations | £1,262 | £6,379 | £4,428 | £5,532 | £13,698 | £9,214 | £6,959 | £6,494 | £7,001 | £6,825 | £6,237 | £7,320 | |
| 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 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| 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 | £1,262 | £6,379 | £4,428 | £5,532 | £13,698 | £9,214 | £8,959 | £8,494 | £9,001 | £8,825 | £8,237 | £9,320 | |
| Net Cash Flow | £4,722 | £805 | £5,093 | £25,818 | £6,997 | £2,006 | £706 | £906 | £499 | £1,850 | £2,713 | £5,930 | |
| Cash Balance | £228,304 | £229,109 | £234,203 | £260,020 | £267,017 | £269,023 | £269,729 | £270,635 | £271,134 | £272,984 | £275,696 | £281,627 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £223,582 | £228,304 | £229,109 | £234,203 | £260,020 | £267,017 | £269,023 | £269,729 | £270,635 | £271,134 | £272,984 | £275,696 | £281,627 |
| Inventory | £0 | £1,502 | £1,247 | £907 | £1,723 | £1,447 | £1,582 | £1,717 | £1,852 | £1,937 | £1,022 | £1,107 | £1,199 |
| Other Current Assets | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 |
| Total Current Assets | £233,409 | £239,633 | £240,183 | £244,936 | £271,570 | £278,291 | £280,432 | £281,272 | £282,313 | £282,897 | £283,832 | £286,630 | £292,653 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 |
| Accumulated Depreciation | £0 | £1,190 | £2,380 | £3,570 | £4,760 | £5,950 | £7,140 | £8,330 | £9,520 | £10,710 | £11,900 | £13,090 | £14,280 |
| Total Long-term Assets | £15,206 | £14,016 | £12,826 | £11,636 | £10,446 | £9,256 | £8,066 | £6,876 | £5,686 | £4,496 | £3,306 | £2,116 | £926 |
| Total Assets | £248,616 | £253,649 | £253,009 | £256,572 | £282,016 | £287,547 | £288,498 | £288,149 | £288,000 | £287,394 | £287,139 | £288,746 | £293,579 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £1,047 | £6,232 | £4,253 | £5,070 | £13,388 | £8,982 | £6,743 | £6,281 | £6,192 | £6,039 | £5,415 | £6,450 | £7,815 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £744 | £744 | £744 | £744 | £744 | £744 | £744 | £744 | £744 | £744 | £744 | £744 | £744 |
| Subtotal Current Liabilities | £1,791 | £6,976 | £4,997 | £5,814 | £14,132 | £9,725 | £7,487 | £7,024 | £6,936 | £6,782 | £6,159 | £7,194 | £8,559 |
| Long-term Liabilities | £232,000 | £232,000 | £232,000 | £232,000 | £232,000 | £232,000 | £232,000 | £230,000 | £228,000 | £226,000 | £224,000 | £222,000 | £220,000 |
| Total Liabilities | £233,791 | £238,976 | £236,997 | £237,814 | £246,132 | £241,725 | £239,487 | £237,024 | £234,936 | £232,782 | £230,159 | £229,194 | £228,559 |
| Paid-in Capital | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 |
| Retained Earnings | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) |
| Earnings | £0 | (£152) | £1,187 | £3,933 | £21,059 | £30,997 | £34,186 | £36,299 | £38,238 | £39,786 | £42,155 | £44,727 | £50,195 |
| Total Capital | £14,825 | £14,673 | £16,012 | £18,758 | £35,884 | £45,822 | £49,011 | £51,124 | £53,063 | £54,611 | £56,980 | £59,552 | £65,020 |
| Total Liabilities and Capital | £248,616 | £253,649 | £253,009 | £256,572 | £282,016 | £287,547 | £288,498 | £288,149 | £288,000 | £287,394 | £287,139 | £288,746 | £293,579 |
| Net Worth | £14,825 | £14,673 | £16,012 | £18,758 | £35,884 | £45,822 | £49,011 | £51,124 | £53,063 | £54,611 | £56,980 | £59,552 | £65,020 |
| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Rooms | 0% | £2,042 | £3,354 | £4,682 | £16,500 | £8,250 | £3,245 | £2,565 | £2,650 | £2,650 | £3,850 | £4,200 | £4,850 |
| Food | 0% | £278 | £838 | £1,540 | £5,350 | £4,950 | £2,850 | £2,850 | £2,850 | £3,150 | £3,250 | £3,250 | £5,400 |
| RV Park | 0% | £163 | £142 | £492 | £3,250 | £2,250 | £1,675 | £850 | £500 | £300 | £175 | £100 | £250 |
| Bar | 0% | £3,501 | £2,849 | £2,808 | £6,250 | £5,245 | £3,450 | £3,400 | £3,400 | £3,400 | £3,400 | £3,400 | £4,750 |
| Total Sales | £5,984 | £7,183 | £9,522 | £31,350 | £20,695 | £11,220 | £9,665 | £9,400 | £9,500 | £10,675 | £10,950 | £15,250 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Rooms | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | |
| Food | £75 | £65 | £125 | £1,050 | £900 | £625 | £625 | £625 | £675 | £675 | £675 | £750 | |
| RV Park | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | £15 | |
| Bar | £1,250 | £150 | £175 | £476 | £375 | £200 | £200 | £200 | £200 | £200 | £200 | £300 | |
| Subtotal Direct Cost of Sales | £1,365 | £255 | £340 | £1,566 | £1,315 | £865 | £865 | £865 | £915 | £915 | £915 | £1,090 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Assistant Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Cook | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £300 | £300 | £300 | £300 |
| Maintenance Staff | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Cleaning Staff | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £300 | £300 | £300 | £300 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 5 | 5 | 50 | 5 | |
| Total Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £600 | £600 | £600 | £600 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £5,984 | £7,183 | £9,522 | £31,350 | £20,695 | £11,220 | £9,665 | £9,400 | £9,500 | £10,675 | £10,950 | £15,250 | |
| Direct Cost of Sales | £1,365 | £255 | £340 | £1,566 | £1,315 | £865 | £865 | £865 | £915 | £915 | £915 | £1,090 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,365 | £255 | £340 | £1,566 | £1,315 | £865 | £865 | £865 | £915 | £915 | £915 | £1,090 | |
| Gross Margin | £4,619 | £6,928 | £9,182 | £29,784 | £19,380 | £10,355 | £8,800 | £8,535 | £8,585 | £9,760 | £10,035 | £14,160 | |
| Gross Margin % | 77.19% | 96.45% | 96.43% | 95.00% | 93.65% | 92.29% | 91.05% | 90.80% | 90.37% | 91.43% | 91.64% | 92.85% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £600 | £600 | £600 | £600 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £210 | £85 | £100 | £100 | £100 | £125 | £145 | £145 | £150 | |
| Depreciation | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £187 | £168 | £410 | £260 | £250 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Insurance | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | £225 | |
| Lease | £1,300 | £1,500 | £1,500 | £1,500 | £1,500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Mortgage Payment | 15% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £2,902 | £3,083 | £3,325 | £3,385 | £3,250 | £3,865 | £3,865 | £3,865 | £4,490 | £4,510 | £4,510 | £4,515 | |
| Profit Before Interest and Taxes | £1,717 | £3,845 | £5,857 | £26,399 | £16,130 | £6,490 | £4,935 | £4,670 | £4,095 | £5,250 | £5,525 | £9,645 | |
| EBITDA | £2,907 | £5,035 | £7,047 | £27,589 | £17,320 | £7,680 | £6,125 | £5,860 | £5,285 | £6,440 | £6,715 | £10,835 | |
| Interest Expense | £1,933 | £1,933 | £1,933 | £1,933 | £1,933 | £1,933 | £1,917 | £1,900 | £1,883 | £1,867 | £1,850 | £1,833 | |
| Taxes Incurred | (£65) | £574 | £1,177 | £7,340 | £4,259 | £1,367 | £905 | £831 | £664 | £1,015 | £1,103 | £2,344 | |
| Net Profit | (£152) | £1,338 | £2,746 | £17,126 | £9,938 | £3,190 | £2,113 | £1,939 | £1,548 | £2,368 | £2,573 | £5,468 | |
| Net Profit/Sales | -2.53% | 18.63% | 28.84% | 54.63% | 48.02% | 28.43% | 21.86% | 20.63% | 16.30% | 22.19% | 23.49% | 35.86% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £5,984 | £7,183 | £9,522 | £31,350 | £20,695 | £11,220 | £9,665 | £9,400 | £9,500 | £10,675 | £10,950 | £15,250 | |
| Subtotal Cash from Operations | £5,984 | £7,183 | £9,522 | £31,350 | £20,695 | £11,220 | £9,665 | £9,400 | £9,500 | £10,675 | £10,950 | £15,250 | |
| 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 | £5,984 | £7,183 | £9,522 | £31,350 | £20,695 | £11,220 | £9,665 | £9,400 | £9,500 | £10,675 | £10,950 | £15,250 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £600 | £600 | £600 | £600 | |
| Bill Payments | £1,262 | £6,379 | £4,428 | £5,532 | £13,698 | £9,214 | £6,959 | £6,494 | £6,401 | £6,225 | £5,637 | £6,720 | |
| Subtotal Spent on Operations | £1,262 | £6,379 | £4,428 | £5,532 | £13,698 | £9,214 | £6,959 | £6,494 | £7,001 | £6,825 | £6,237 | £7,320 | |
| 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 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| 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 | £1,262 | £6,379 | £4,428 | £5,532 | £13,698 | £9,214 | £8,959 | £8,494 | £9,001 | £8,825 | £8,237 | £9,320 | |
| Net Cash Flow | £4,722 | £805 | £5,093 | £25,818 | £6,997 | £2,006 | £706 | £906 | £499 | £1,850 | £2,713 | £5,930 | |
| Cash Balance | £228,304 | £229,109 | £234,203 | £260,020 | £267,017 | £269,023 | £269,729 | £270,635 | £271,134 | £272,984 | £275,696 | £281,627 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £223,582 | £228,304 | £229,109 | £234,203 | £260,020 | £267,017 | £269,023 | £269,729 | £270,635 | £271,134 | £272,984 | £275,696 | £281,627 |
| Inventory | £0 | £1,502 | £1,247 | £907 | £1,723 | £1,447 | £1,582 | £1,717 | £1,852 | £1,937 | £1,022 | £1,107 | £1,199 |
| Other Current Assets | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 | £9,827 |
| Total Current Assets | £233,409 | £239,633 | £240,183 | £244,936 | £271,570 | £278,291 | £280,432 | £281,272 | £282,313 | £282,897 | £283,832 | £286,630 | £292,653 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 | £15,206 |
| Accumulated Depreciation | £0 | £1,190 | £2,380 | £3,570 | £4,760 | £5,950 | £7,140 | £8,330 | £9,520 | £10,710 | £11,900 | £13,090 | £14,280 |
| Total Long-term Assets | £15,206 | £14,016 | £12,826 | £11,636 | £10,446 | £9,256 | £8,066 | £6,876 | £5,686 | £4,496 | £3,306 | £2,116 | £926 |
| Total Assets | £248,616 | £253,649 | £253,009 | £256,572 | £282,016 | £287,547 | £288,498 | £288,149 | £288,000 | £287,394 | £287,139 | £288,746 | £293,579 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £1,047 | £6,232 | £4,253 | £5,070 | £13,388 | £8,982 | £6,743 | £6,281 | £6,192 | £6,039 | £5,415 | £6,450 | £7,815 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £744 | £744 | £744 | £744 | £744 | £744 | £744 | £744 | £744 | £744 | £744 | £744 | £744 |
| Subtotal Current Liabilities | £1,791 | £6,976 | £4,997 | £5,814 | £14,132 | £9,725 | £7,487 | £7,024 | £6,936 | £6,782 | £6,159 | £7,194 | £8,559 |
| Long-term Liabilities | £232,000 | £232,000 | £232,000 | £232,000 | £232,000 | £232,000 | £232,000 | £230,000 | £228,000 | £226,000 | £224,000 | £222,000 | £220,000 |
| Total Liabilities | £233,791 | £238,976 | £236,997 | £237,814 | £246,132 | £241,725 | £239,487 | £237,024 | £234,936 | £232,782 | £230,159 | £229,194 | £228,559 |
| Paid-in Capital | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 | £78,000 |
| Retained Earnings | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) | (£63,175) |
| Earnings | £0 | (£152) | £1,187 | £3,933 | £21,059 | £30,997 | £34,186 | £36,299 | £38,238 | £39,786 | £42,155 | £44,727 | £50,195 |
| Total Capital | £14,825 | £14,673 | £16,012 | £18,758 | £35,884 | £45,822 | £49,011 | £51,124 | £53,063 | £54,611 | £56,980 | £59,552 | £65,020 |
| Total Liabilities and Capital | £248,616 | £253,649 | £253,009 | £256,572 | £282,016 | £287,547 | £288,498 | £288,149 | £288,000 | £287,394 | £287,139 | £288,746 | £293,579 |
| Net Worth | £14,825 | £14,673 | £16,012 | £18,758 | £35,884 | £45,822 | £49,011 | £51,124 | £53,063 | £54,611 | £56,980 | £59,552 | £65,020 |