| 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 | ||
| Unit Sales | |||||||||||||
| Beverage Sales | 0% | 125,500 | 128,800 | 136,802 | 138,800 | 140,000 | 140,000 | 137,802 | 135,600 | 132,200 | 132,200 | 130,200 | 130,200 |
| Food Sales | 0% | 15,200 | 17,200 | 19,200 | 20,200 | 22,500 | 22,500 | 20,300 | 18,550 | 17,400 | 17,400 | 16,200 | 16,200 |
| Cover Charges | 0% | 90,984 | 94,284 | 96,284 | 98,284 | 99,800 | 99,800 | 98,000 | 96,800 | 93,400 | 93,400 | 90,400 | 90,400 |
| Total Unit Sales | 231,684 | 240,284 | 252,286 | 257,284 | 262,300 | 262,300 | 256,102 | 250,950 | 243,000 | 243,000 | 236,800 | 236,800 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Beverage Sales | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | |
| Food Sales | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | |
| Cover Charges | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | |
| Sales | |||||||||||||
| Beverage Sales | £753,000 | £772,800 | £820,812 | £832,800 | £840,000 | £840,000 | £826,812 | £813,600 | £793,200 | £793,200 | £781,200 | £781,200 | |
| Food Sales | £182,400 | £206,400 | £230,400 | £242,400 | £270,000 | £270,000 | £243,600 | £222,600 | £208,800 | £208,800 | £194,400 | £194,400 | |
| Cover Charges | £1,819,680 | £1,885,680 | £1,925,680 | £1,965,680 | £1,996,000 | £1,996,000 | £1,960,000 | £1,936,000 | £1,868,000 | £1,868,000 | £1,808,000 | £1,808,000 | |
| Total Sales | £2,755,080 | £2,864,880 | £2,976,892 | £3,040,880 | £3,106,000 | £3,106,000 | £3,030,412 | £2,972,200 | £2,870,000 | £2,870,000 | £2,783,600 | £2,783,600 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Beverage Sales | 35.00% | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 |
| Food Sales | 33.00% | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 |
| Cover Charges | 3.00% | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 |
| Direct Cost of Sales | |||||||||||||
| Beverage Sales | £263,550 | £270,480 | £287,284 | £291,480 | £294,000 | £294,000 | £289,384 | £284,760 | £277,620 | £277,620 | £273,420 | £273,420 | |
| Food Sales | £60,192 | £68,112 | £76,032 | £79,992 | £89,100 | £89,100 | £80,388 | £73,458 | £68,904 | £68,904 | £64,152 | £64,152 | |
| Cover Charges | £54,590 | £56,570 | £57,770 | £58,970 | £59,880 | £59,880 | £58,800 | £58,080 | £56,040 | £56,040 | £54,240 | £54,240 | |
| Subtotal Direct Cost of Sales | £378,332 | £395,162 | £421,087 | £430,442 | £442,980 | £442,980 | £428,572 | £416,298 | £402,564 | £402,564 | £391,812 | £391,812 | |
| 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 | ||
| Security Guards | 0% | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 |
| Bar Personnel | 0% | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 |
| Waitress | 0% | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 |
| Kitchen Staff | 0% | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 |
| Back Office Staff | 0% | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 |
| Host & Hostess | 0% | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 |
| Cleaning Staff | 0% | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 |
| DJ's | 0% | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 |
| General Manager | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Marketing & Advertising Manager | 0% | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| HR & Administrations Manager | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Financial Operations Manager | 0% | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 |
| Security Manager | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Computer Staff | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Total People | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | |
| Total Payroll | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | |
| 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 | £2,755,080 | £2,864,880 | £2,976,892 | £3,040,880 | £3,106,000 | £3,106,000 | £3,030,412 | £2,972,200 | £2,870,000 | £2,870,000 | £2,783,600 | £2,783,600 | |
| Direct Cost of Sales | £378,332 | £395,162 | £421,087 | £430,442 | £442,980 | £442,980 | £428,572 | £416,298 | £402,564 | £402,564 | £391,812 | £391,812 | |
| Other Costs of Sales | £10,000 | £12,000 | £12,500 | £12,560 | £12,600 | £12,600 | £12,200 | £11,800 | £10,200 | £10,200 | £10,200 | £10,200 | |
| Total Cost of Sales | £388,332 | £407,162 | £433,587 | £443,002 | £455,580 | £455,580 | £440,772 | £428,098 | £412,764 | £412,764 | £402,012 | £402,012 | |
| Gross Margin | £2,366,748 | £2,457,718 | £2,543,305 | £2,597,878 | £2,650,420 | £2,650,420 | £2,589,640 | £2,544,102 | £2,457,236 | £2,457,236 | £2,381,588 | £2,381,588 | |
| Gross Margin % | 85.90% | 85.79% | 85.43% | 85.43% | 85.33% | 85.33% | 85.46% | 85.60% | 85.62% | 85.62% | 85.56% | 85.56% | |
| Expenses | |||||||||||||
| Payroll | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | |
| Sales and Marketing | £80,000 | £90,000 | £100,000 | £100,000 | £100,000 | £95,000 | £90,000 | £90,000 | £85,000 | £70,000 | £70,000 | £70,000 | |
| Depreciation | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Advertising | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £700,000 | £600,000 | £500,000 | £600,000 | |
| Professional-Fees | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | |
| Office Supplies | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | |
| Excise Taxes paid out | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | |
| Utilities | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | |
| Telephone | £70,000 | £75,000 | £80,000 | £85,000 | £85,000 | £85,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | |
| Insurance | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | |
| Property Taxes | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Web Development | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| House Keeping Supplies | 15% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,500 |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Operating Expenses | £2,551,708 | £2,566,708 | £2,581,708 | £2,586,708 | £2,586,708 | £2,581,708 | £2,571,708 | £2,571,708 | £2,466,708 | £2,351,708 | £2,251,708 | £2,352,208 | |
| Profit Before Interest and Taxes | (£184,960) | (£108,990) | (£38,403) | £11,170 | £63,712 | £68,712 | £17,932 | (£27,606) | (£9,472) | £105,528 | £129,880 | £29,380 | |
| EBITDA | (£179,960) | (£103,990) | (£33,403) | £16,170 | £68,712 | £73,712 | £22,932 | (£22,606) | (£4,472) | £110,528 | £134,880 | £34,380 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£55,488) | (£32,697) | (£11,521) | £3,351 | £19,114 | £20,614 | £5,380 | (£8,282) | (£2,842) | £31,658 | £38,964 | £8,814 | |
| Net Profit | (£129,472) | (£76,293) | (£26,882) | £7,819 | £44,598 | £48,098 | £12,552 | (£19,324) | (£6,630) | £73,870 | £90,916 | £20,566 | |
| Net Profit/Sales | -4.70% | -2.66% | -0.90% | 0.26% | 1.44% | 1.55% | 0.41% | -0.65% | -0.23% | 2.57% | 3.27% | 0.74% | |
| 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 | £2,755,080 | £2,864,880 | £2,976,892 | £3,040,880 | £3,106,000 | £3,106,000 | £3,030,412 | £2,972,200 | £2,870,000 | £2,870,000 | £2,783,600 | £2,783,600 | |
| Subtotal Cash from Operations | £2,755,080 | £2,864,880 | £2,976,892 | £3,040,880 | £3,106,000 | £3,106,000 | £3,030,412 | £2,972,200 | £2,870,000 | £2,870,000 | £2,783,600 | £2,783,600 | |
| 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 | £2,755,080 | £2,864,880 | £2,976,892 | £3,040,880 | £3,106,000 | £3,106,000 | £3,030,412 | £2,972,200 | £2,870,000 | £2,870,000 | £2,783,600 | £2,783,600 | |
| 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 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | |
| Bill Payments | £99,344 | £2,970,505 | £2,687,843 | £2,757,572 | £2,770,918 | £2,800,855 | £2,783,537 | £2,730,095 | £2,702,822 | £2,588,121 | £2,519,774 | £2,412,085 | |
| Subtotal Spent on Operations | £366,894 | £3,238,055 | £2,955,393 | £3,025,122 | £3,038,468 | £3,068,405 | £3,051,087 | £2,997,645 | £2,970,372 | £2,855,671 | £2,787,324 | £2,679,635 | |
| 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 | £366,894 | £3,238,055 | £2,955,393 | £3,025,122 | £3,038,468 | £3,068,405 | £3,051,087 | £2,997,645 | £2,970,372 | £2,855,671 | £2,787,324 | £2,679,635 | |
| Net Cash Flow | £2,388,186 | (£373,175) | £21,499 | £15,758 | £67,532 | £37,595 | (£20,675) | (£25,445) | (£100,372) | £14,329 | (£3,724) | £103,965 | |
| Cash Balance | £2,888,186 | £2,515,010 | £2,536,509 | £2,552,267 | £2,619,799 | £2,657,395 | £2,636,720 | £2,611,275 | £2,510,903 | £2,525,232 | £2,521,509 | £2,625,473 | |
| 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 | £500,000 | £2,888,186 | £2,515,010 | £2,536,509 | £2,552,267 | £2,619,799 | £2,657,395 | £2,636,720 | £2,611,275 | £2,510,903 | £2,525,232 | £2,521,509 | £2,625,473 |
| Inventory | £10,000 | £378,332 | £395,162 | £421,087 | £430,442 | £442,980 | £442,980 | £428,572 | £416,298 | £402,564 | £402,564 | £391,812 | £391,812 |
| Other Current Assets | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 |
| Total Current Assets | £710,000 | £3,466,518 | £3,110,173 | £3,157,596 | £3,182,710 | £3,262,779 | £3,300,375 | £3,265,292 | £3,227,573 | £3,113,467 | £3,127,796 | £3,113,321 | £3,217,285 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 |
| Accumulated Depreciation | £0 | £5,000 | £10,000 | £15,000 | £20,000 | £25,000 | £30,000 | £35,000 | £40,000 | £45,000 | £50,000 | £55,000 | £60,000 |
| Total Long-term Assets | £2,000,000 | £1,995,000 | £1,990,000 | £1,985,000 | £1,980,000 | £1,975,000 | £1,970,000 | £1,965,000 | £1,960,000 | £1,955,000 | £1,950,000 | £1,945,000 | £1,940,000 |
| Total Assets | £2,710,000 | £5,461,518 | £5,100,173 | £5,142,596 | £5,162,710 | £5,237,779 | £5,270,375 | £5,230,292 | £5,187,573 | £5,068,467 | £5,077,796 | £5,058,321 | £5,157,285 |
| 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 | £0 | £2,880,990 | £2,595,938 | £2,665,243 | £2,677,538 | £2,708,010 | £2,692,507 | £2,639,872 | £2,616,477 | £2,504,002 | £2,439,461 | £2,329,069 | £2,407,468 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £2,880,990 | £2,595,938 | £2,665,243 | £2,677,538 | £2,708,010 | £2,692,507 | £2,639,872 | £2,616,477 | £2,504,002 | £2,439,461 | £2,329,069 | £2,407,468 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £2,880,990 | £2,595,938 | £2,665,243 | £2,677,538 | £2,708,010 | £2,692,507 | £2,639,872 | £2,616,477 | £2,504,002 | £2,439,461 | £2,329,069 | £2,407,468 |
| Paid-in Capital | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 |
| Retained Earnings | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) |
| Earnings | £0 | (£129,472) | (£205,766) | (£232,647) | (£224,829) | (£180,230) | (£132,132) | (£119,580) | (£138,904) | (£145,534) | (£71,665) | £19,251 | £39,817 |
| Total Capital | £2,710,000 | £2,580,528 | £2,504,234 | £2,477,353 | £2,485,171 | £2,529,770 | £2,577,868 | £2,590,420 | £2,571,096 | £2,564,466 | £2,638,335 | £2,729,251 | £2,749,817 |
| Total Liabilities and Capital | £2,710,000 | £5,461,518 | £5,100,173 | £5,142,596 | £5,162,710 | £5,237,779 | £5,270,375 | £5,230,292 | £5,187,573 | £5,068,467 | £5,077,796 | £5,058,321 | £5,157,285 |
| Net Worth | £2,710,000 | £2,580,528 | £2,504,234 | £2,477,353 | £2,485,171 | £2,529,770 | £2,577,868 | £2,590,420 | £2,571,096 | £2,564,466 | £2,638,335 | £2,729,251 | £2,749,817 |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 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 | ||
| Unit Sales | |||||||||||||
| Beverage Sales | 0% | 125,500 | 128,800 | 136,802 | 138,800 | 140,000 | 140,000 | 137,802 | 135,600 | 132,200 | 132,200 | 130,200 | 130,200 |
| Food Sales | 0% | 15,200 | 17,200 | 19,200 | 20,200 | 22,500 | 22,500 | 20,300 | 18,550 | 17,400 | 17,400 | 16,200 | 16,200 |
| Cover Charges | 0% | 90,984 | 94,284 | 96,284 | 98,284 | 99,800 | 99,800 | 98,000 | 96,800 | 93,400 | 93,400 | 90,400 | 90,400 |
| Total Unit Sales | 231,684 | 240,284 | 252,286 | 257,284 | 262,300 | 262,300 | 256,102 | 250,950 | 243,000 | 243,000 | 236,800 | 236,800 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Beverage Sales | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | |
| Food Sales | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | |
| Cover Charges | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | |
| Sales | |||||||||||||
| Beverage Sales | £753,000 | £772,800 | £820,812 | £832,800 | £840,000 | £840,000 | £826,812 | £813,600 | £793,200 | £793,200 | £781,200 | £781,200 | |
| Food Sales | £182,400 | £206,400 | £230,400 | £242,400 | £270,000 | £270,000 | £243,600 | £222,600 | £208,800 | £208,800 | £194,400 | £194,400 | |
| Cover Charges | £1,819,680 | £1,885,680 | £1,925,680 | £1,965,680 | £1,996,000 | £1,996,000 | £1,960,000 | £1,936,000 | £1,868,000 | £1,868,000 | £1,808,000 | £1,808,000 | |
| Total Sales | £2,755,080 | £2,864,880 | £2,976,892 | £3,040,880 | £3,106,000 | £3,106,000 | £3,030,412 | £2,972,200 | £2,870,000 | £2,870,000 | £2,783,600 | £2,783,600 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Beverage Sales | 35.00% | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 | £2.10 |
| Food Sales | 33.00% | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 | £3.96 |
| Cover Charges | 3.00% | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 | £0.60 |
| Direct Cost of Sales | |||||||||||||
| Beverage Sales | £263,550 | £270,480 | £287,284 | £291,480 | £294,000 | £294,000 | £289,384 | £284,760 | £277,620 | £277,620 | £273,420 | £273,420 | |
| Food Sales | £60,192 | £68,112 | £76,032 | £79,992 | £89,100 | £89,100 | £80,388 | £73,458 | £68,904 | £68,904 | £64,152 | £64,152 | |
| Cover Charges | £54,590 | £56,570 | £57,770 | £58,970 | £59,880 | £59,880 | £58,800 | £58,080 | £56,040 | £56,040 | £54,240 | £54,240 | |
| Subtotal Direct Cost of Sales | £378,332 | £395,162 | £421,087 | £430,442 | £442,980 | £442,980 | £428,572 | £416,298 | £402,564 | £402,564 | £391,812 | £391,812 | |
| 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 | ||
| Security Guards | 0% | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 | £43,200 |
| Bar Personnel | 0% | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 | £33,300 |
| Waitress | 0% | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 | £42,000 |
| Kitchen Staff | 0% | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 | £19,350 |
| Back Office Staff | 0% | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 | £10,500 |
| Host & Hostess | 0% | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 | £14,400 |
| Cleaning Staff | 0% | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 | £10,800 |
| DJ's | 0% | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 |
| General Manager | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Marketing & Advertising Manager | 0% | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| HR & Administrations Manager | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Financial Operations Manager | 0% | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 | £9,000 |
| Security Manager | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Computer Staff | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Total People | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | |
| Total Payroll | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | |
| 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 | £2,755,080 | £2,864,880 | £2,976,892 | £3,040,880 | £3,106,000 | £3,106,000 | £3,030,412 | £2,972,200 | £2,870,000 | £2,870,000 | £2,783,600 | £2,783,600 | |
| Direct Cost of Sales | £378,332 | £395,162 | £421,087 | £430,442 | £442,980 | £442,980 | £428,572 | £416,298 | £402,564 | £402,564 | £391,812 | £391,812 | |
| Other Costs of Sales | £10,000 | £12,000 | £12,500 | £12,560 | £12,600 | £12,600 | £12,200 | £11,800 | £10,200 | £10,200 | £10,200 | £10,200 | |
| Total Cost of Sales | £388,332 | £407,162 | £433,587 | £443,002 | £455,580 | £455,580 | £440,772 | £428,098 | £412,764 | £412,764 | £402,012 | £402,012 | |
| Gross Margin | £2,366,748 | £2,457,718 | £2,543,305 | £2,597,878 | £2,650,420 | £2,650,420 | £2,589,640 | £2,544,102 | £2,457,236 | £2,457,236 | £2,381,588 | £2,381,588 | |
| Gross Margin % | 85.90% | 85.79% | 85.43% | 85.43% | 85.33% | 85.33% | 85.46% | 85.60% | 85.62% | 85.62% | 85.56% | 85.56% | |
| Expenses | |||||||||||||
| Payroll | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | |
| Sales and Marketing | £80,000 | £90,000 | £100,000 | £100,000 | £100,000 | £95,000 | £90,000 | £90,000 | £85,000 | £70,000 | £70,000 | £70,000 | |
| Depreciation | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Advertising | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £700,000 | £600,000 | £500,000 | £600,000 | |
| Professional-Fees | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | |
| Office Supplies | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | |
| Excise Taxes paid out | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | £803,608 | |
| Utilities | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | |
| Telephone | £70,000 | £75,000 | £80,000 | £85,000 | £85,000 | £85,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | £80,000 | |
| Insurance | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | |
| Property Taxes | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Web Development | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| House Keeping Supplies | 15% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,500 |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Operating Expenses | £2,551,708 | £2,566,708 | £2,581,708 | £2,586,708 | £2,586,708 | £2,581,708 | £2,571,708 | £2,571,708 | £2,466,708 | £2,351,708 | £2,251,708 | £2,352,208 | |
| Profit Before Interest and Taxes | (£184,960) | (£108,990) | (£38,403) | £11,170 | £63,712 | £68,712 | £17,932 | (£27,606) | (£9,472) | £105,528 | £129,880 | £29,380 | |
| EBITDA | (£179,960) | (£103,990) | (£33,403) | £16,170 | £68,712 | £73,712 | £22,932 | (£22,606) | (£4,472) | £110,528 | £134,880 | £34,380 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£55,488) | (£32,697) | (£11,521) | £3,351 | £19,114 | £20,614 | £5,380 | (£8,282) | (£2,842) | £31,658 | £38,964 | £8,814 | |
| Net Profit | (£129,472) | (£76,293) | (£26,882) | £7,819 | £44,598 | £48,098 | £12,552 | (£19,324) | (£6,630) | £73,870 | £90,916 | £20,566 | |
| Net Profit/Sales | -4.70% | -2.66% | -0.90% | 0.26% | 1.44% | 1.55% | 0.41% | -0.65% | -0.23% | 2.57% | 3.27% | 0.74% | |
| 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 | £2,755,080 | £2,864,880 | £2,976,892 | £3,040,880 | £3,106,000 | £3,106,000 | £3,030,412 | £2,972,200 | £2,870,000 | £2,870,000 | £2,783,600 | £2,783,600 | |
| Subtotal Cash from Operations | £2,755,080 | £2,864,880 | £2,976,892 | £3,040,880 | £3,106,000 | £3,106,000 | £3,030,412 | £2,972,200 | £2,870,000 | £2,870,000 | £2,783,600 | £2,783,600 | |
| 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 | £2,755,080 | £2,864,880 | £2,976,892 | £3,040,880 | £3,106,000 | £3,106,000 | £3,030,412 | £2,972,200 | £2,870,000 | £2,870,000 | £2,783,600 | £2,783,600 | |
| 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 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | £267,550 | |
| Bill Payments | £99,344 | £2,970,505 | £2,687,843 | £2,757,572 | £2,770,918 | £2,800,855 | £2,783,537 | £2,730,095 | £2,702,822 | £2,588,121 | £2,519,774 | £2,412,085 | |
| Subtotal Spent on Operations | £366,894 | £3,238,055 | £2,955,393 | £3,025,122 | £3,038,468 | £3,068,405 | £3,051,087 | £2,997,645 | £2,970,372 | £2,855,671 | £2,787,324 | £2,679,635 | |
| 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 | £366,894 | £3,238,055 | £2,955,393 | £3,025,122 | £3,038,468 | £3,068,405 | £3,051,087 | £2,997,645 | £2,970,372 | £2,855,671 | £2,787,324 | £2,679,635 | |
| Net Cash Flow | £2,388,186 | (£373,175) | £21,499 | £15,758 | £67,532 | £37,595 | (£20,675) | (£25,445) | (£100,372) | £14,329 | (£3,724) | £103,965 | |
| Cash Balance | £2,888,186 | £2,515,010 | £2,536,509 | £2,552,267 | £2,619,799 | £2,657,395 | £2,636,720 | £2,611,275 | £2,510,903 | £2,525,232 | £2,521,509 | £2,625,473 | |
| 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 | £500,000 | £2,888,186 | £2,515,010 | £2,536,509 | £2,552,267 | £2,619,799 | £2,657,395 | £2,636,720 | £2,611,275 | £2,510,903 | £2,525,232 | £2,521,509 | £2,625,473 |
| Inventory | £10,000 | £378,332 | £395,162 | £421,087 | £430,442 | £442,980 | £442,980 | £428,572 | £416,298 | £402,564 | £402,564 | £391,812 | £391,812 |
| Other Current Assets | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 |
| Total Current Assets | £710,000 | £3,466,518 | £3,110,173 | £3,157,596 | £3,182,710 | £3,262,779 | £3,300,375 | £3,265,292 | £3,227,573 | £3,113,467 | £3,127,796 | £3,113,321 | £3,217,285 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 | £2,000,000 |
| Accumulated Depreciation | £0 | £5,000 | £10,000 | £15,000 | £20,000 | £25,000 | £30,000 | £35,000 | £40,000 | £45,000 | £50,000 | £55,000 | £60,000 |
| Total Long-term Assets | £2,000,000 | £1,995,000 | £1,990,000 | £1,985,000 | £1,980,000 | £1,975,000 | £1,970,000 | £1,965,000 | £1,960,000 | £1,955,000 | £1,950,000 | £1,945,000 | £1,940,000 |
| Total Assets | £2,710,000 | £5,461,518 | £5,100,173 | £5,142,596 | £5,162,710 | £5,237,779 | £5,270,375 | £5,230,292 | £5,187,573 | £5,068,467 | £5,077,796 | £5,058,321 | £5,157,285 |
| 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 | £0 | £2,880,990 | £2,595,938 | £2,665,243 | £2,677,538 | £2,708,010 | £2,692,507 | £2,639,872 | £2,616,477 | £2,504,002 | £2,439,461 | £2,329,069 | £2,407,468 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £2,880,990 | £2,595,938 | £2,665,243 | £2,677,538 | £2,708,010 | £2,692,507 | £2,639,872 | £2,616,477 | £2,504,002 | £2,439,461 | £2,329,069 | £2,407,468 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £2,880,990 | £2,595,938 | £2,665,243 | £2,677,538 | £2,708,010 | £2,692,507 | £2,639,872 | £2,616,477 | £2,504,002 | £2,439,461 | £2,329,069 | £2,407,468 |
| Paid-in Capital | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 | £7,960,000 |
| Retained Earnings | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) | (£5,250,000) |
| Earnings | £0 | (£129,472) | (£205,766) | (£232,647) | (£224,829) | (£180,230) | (£132,132) | (£119,580) | (£138,904) | (£145,534) | (£71,665) | £19,251 | £39,817 |
| Total Capital | £2,710,000 | £2,580,528 | £2,504,234 | £2,477,353 | £2,485,171 | £2,529,770 | £2,577,868 | £2,590,420 | £2,571,096 | £2,564,466 | £2,638,335 | £2,729,251 | £2,749,817 |
| Total Liabilities and Capital | £2,710,000 | £5,461,518 | £5,100,173 | £5,142,596 | £5,162,710 | £5,237,779 | £5,270,375 | £5,230,292 | £5,187,573 | £5,068,467 | £5,077,796 | £5,058,321 | £5,157,285 |
| Net Worth | £2,710,000 | £2,580,528 | £2,504,234 | £2,477,353 | £2,485,171 | £2,529,770 | £2,577,868 | £2,590,420 | £2,571,096 | £2,564,466 | £2,638,335 | £2,729,251 | £2,749,817 |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |