| 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 | |||||||||||||
| Amusement | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Bumper Boats | 0% | £18,605 | £24,806 | £37,209 | £37,209 | £37,209 | £37,209 | £24,806 | £18,605 | £6,202 | £6,202 | £6,202 | £6,202 |
| Mini-Golf | 0% | £33,351 | £44,467 | £66,701 | £66,701 | £66,701 | £66,701 | £44,467 | £33,351 | £11,117 | £11,117 | £11,117 | £11,117 |
| Go-Carts | 0% | £85,272 | £113,695 | £170,543 | £170,543 | £170,543 | £170,543 | £113,695 | £85,272 | £28,424 | £28,424 | £28,424 | £28,424 |
| Gaming Center | 0% | £2,756 | £3,675 | £5,512 | £5,512 | £5,512 | £5,512 | £3,675 | £2,756 | £919 | £919 | £919 | £919 |
| Sky Coaster | 0% | £11,025 | £14,700 | £22,050 | £22,050 | £22,050 | £22,050 | £14,700 | £11,025 | £3,675 | £3,675 | £3,675 | £3,675 |
| Batting Cages | 0% | £10,336 | £13,781 | £20,671 | £20,671 | £20,671 | £20,671 | £13,781 | £10,336 | £3,445 | £3,445 | £3,445 | £3,445 |
| Climbing Walls | 0% | £3,652 | £4,869 | £7,304 | £7,304 | £7,304 | £7,304 | £4,869 | £3,652 | £2,435 | £2,435 | £2,435 | £2,435 |
| Air/Foosball | 0% | £1,194 | £1,592 | £2,388 | £2,388 | £2,388 | £2,388 | £1,592 | £1,194 | £796 | £796 | £796 | £796 |
| Souvenirs | 0% | £1,838 | £2,450 | £3,675 | £3,675 | £3,675 | £3,675 | £2,450 | £1,838 | £1,225 | £1,225 | £1,225 | £1,225 |
| Party Rooms | 0% | £30,016 | £40,021 | £60,031 | £60,031 | £60,031 | £60,031 | £40,021 | £30,016 | £20,010 | £20,010 | £20,010 | £20,010 |
| Food & Drinks | 0% | £48,234 | £64,312 | £96,468 | £96,468 | £96,468 | £96,468 | £64,312 | £48,234 | £32,156 | £32,156 | £32,156 | £32,156 |
| Total Sales | £246,276 | £328,368 | £492,552 | £492,552 | £492,552 | £492,552 | £328,368 | £246,276 | £110,403 | £110,403 | £110,403 | £110,403 | |
| 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 | |
| Amusement | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Bumper Boats | £4,651 | £6,202 | £9,302 | £9,302 | £9,302 | £9,302 | £6,202 | £4,651 | £1,550 | £1,550 | £1,550 | £1,550 | |
| Mini-Golf | £5,003 | £6,670 | £10,005 | £10,005 | £10,005 | £10,005 | £6,670 | £5,003 | £1,668 | £1,668 | £1,668 | £1,668 | |
| Go-Carts | £21,318 | £28,424 | £42,636 | £42,636 | £42,636 | £42,636 | £28,424 | £21,318 | £7,106 | £7,106 | £7,106 | £7,106 | |
| Gaming Center | £1,378 | £1,837 | £2,756 | £2,756 | £2,756 | £2,756 | £1,837 | £1,378 | £459 | £459 | £459 | £459 | |
| Sky Coaster | £2,756 | £3,675 | £5,513 | £5,513 | £5,513 | £5,513 | £3,675 | £2,756 | £919 | £919 | £919 | £919 | |
| Batting Cages | £1,550 | £2,067 | £3,101 | £3,101 | £3,101 | £3,101 | £2,067 | £1,550 | £517 | £517 | £517 | £517 | |
| Climbing Walls | £913 | £1,217 | £1,826 | £1,826 | £1,826 | £1,826 | £1,217 | £913 | £609 | £609 | £609 | £609 | |
| Air/Foosball | £179 | £239 | £358 | £358 | £358 | £358 | £239 | £179 | £119 | £119 | £119 | £119 | |
| Souvenirs | £459 | £613 | £919 | £919 | £919 | £919 | £613 | £459 | £306 | £306 | £306 | £306 | |
| Party Rooms | £15,008 | £20,010 | £30,016 | £30,016 | £30,016 | £30,016 | £20,010 | £15,008 | £10,005 | £10,005 | £10,005 | £10,005 | |
| Food & Drinks | £24,117 | £32,156 | £48,234 | £48,234 | £48,234 | £48,234 | £32,156 | £24,117 | £16,078 | £16,078 | £16,078 | £16,078 | |
| Subtotal Direct Cost of Sales | £77,332 | £103,110 | £154,665 | £154,665 | £154,665 | £154,665 | £103,110 | £77,332 | £39,336 | £39,336 | £39,336 | £39,336 | |
| 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 | ||
| Operations Personnel | |||||||||||||
| John A | 100% | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 |
| John B | 100% | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 |
| John C | 100% | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 |
| John D | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John E | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John F | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John G | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John H | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John I | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John J | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John K | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John L | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John M | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John N | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John O | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John P | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| John Q | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| John R | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| John S | 100% | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 |
| John T | 100% | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 |
| John U | 100% | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 |
| Subtotal | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | |
| Sales and Marketing Personnel | |||||||||||||
| Darren Strebel | 100% | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 |
| Other | 100% | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 |
| Subtotal | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | |
| General and Administrative Personnel | |||||||||||||
| Joe Hull | 100% | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 |
| Rod Schaffer | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| Restaurant Manager | 100% | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 |
| Laura Strebel | 100% | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 |
| Mark Bergman | 100% | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 |
| Subtotal | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | |
| Other Personnel | |||||||||||||
| Jack A | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| Jack B | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| Jack C | 100% | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 |
| Sara A | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| Subtotal | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | |
| Total People | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | |
| Total Payroll | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | |
| 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 | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.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% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 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 | £246,276 | £328,368 | £492,552 | £492,552 | £492,552 | £492,552 | £328,368 | £246,276 | £110,403 | £110,403 | £110,403 | £110,403 | |
| Direct Cost of Sales | £77,332 | £103,110 | £154,665 | £154,665 | £154,665 | £154,665 | £103,110 | £77,332 | £39,336 | £39,336 | £39,336 | £39,336 | |
| Operations Payroll | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | |
| Known expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £109,720 | £135,498 | £187,053 | £187,053 | £187,053 | £187,053 | £135,498 | £109,720 | £71,724 | £71,724 | £71,724 | £71,724 | |
| Gross Margin | £136,556 | £192,870 | £305,499 | £305,499 | £305,499 | £305,499 | £192,870 | £136,556 | £38,679 | £38,679 | £38,679 | £38,679 | |
| Gross Margin % | 55.45% | 58.74% | 62.02% | 62.02% | 62.02% | 62.02% | 58.74% | 55.45% | 35.03% | 35.03% | 35.03% | 35.03% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | |
| Advertising/Promotion | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Travel | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Miscellaneous | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Total Sales and Marketing Expenses | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | |
| Sales and Marketing % | 2.74% | 2.06% | 1.37% | 1.37% | 1.37% | 1.37% | 2.06% | 2.74% | 6.11% | 6.11% | 6.11% | 6.11% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | |
| Sales and Marketing and Other Expenses | £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 | |
| Utilities | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Insurance | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | |
| Telephone | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Payroll Taxes | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | |
| General and Administrative % | 7.10% | 5.33% | 3.55% | 3.55% | 3.55% | 3.55% | 5.33% | 7.10% | 15.84% | 15.84% | 15.84% | 15.84% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Office Supplies | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Postal Fees | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Professional Fees | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Housekeeping Supplies | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | |
| Unknown | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Bad Checks | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Bank Card Fees | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Business License | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | |
| Facility Maintenance | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Contract/Consultants | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | |
| Total Other Expenses | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | |
| Other % | 4.26% | 3.19% | 2.13% | 2.13% | 2.13% | 2.13% | 3.19% | 4.26% | 9.50% | 9.50% | 9.50% | 9.50% | |
| Total Operating Expenses | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | |
| Profit Before Interest and Taxes | £101,831 | £158,145 | £270,774 | £270,774 | £270,774 | £270,774 | £158,145 | £101,831 | £3,954 | £3,954 | £3,954 | £3,954 | |
| EBITDA | £101,831 | £158,145 | £270,774 | £270,774 | £270,774 | £270,774 | £158,145 | £101,831 | £3,954 | £3,954 | £3,954 | £3,954 | |
| Interest Expense | £44,347 | £44,162 | £43,974 | £43,783 | £43,590 | £43,395 | £43,196 | £42,994 | £42,790 | £42,583 | £42,373 | £42,160 | |
| Taxes Incurred | £17,245 | £37,615 | £74,844 | £74,907 | £74,971 | £75,035 | £37,933 | £19,416 | (£12,816) | (£12,748) | (£12,678) | (£12,608) | |
| Net Profit | £40,239 | £76,369 | £151,956 | £152,084 | £152,213 | £152,344 | £77,016 | £39,420 | (£26,020) | (£25,882) | (£25,741) | (£25,598) | |
| Net Profit/Sales | 16.34% | 23.26% | 30.85% | 30.88% | 30.90% | 30.93% | 23.45% | 16.01% | -23.57% | -23.44% | -23.32% | -23.19% | |
| 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 | £246,276 | £328,368 | £492,552 | £492,552 | £492,552 | £492,552 | £328,368 | £246,276 | £110,403 | £110,403 | £110,403 | £110,403 | |
| Subtotal Cash from Operations | £246,276 | £328,368 | £492,552 | £492,552 | £492,552 | £492,552 | £328,368 | £246,276 | £110,403 | £110,403 | £110,403 | £110,403 | |
| 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 | £246,276 | £328,368 | £492,552 | £492,552 | £492,552 | £492,552 | £328,368 | £246,276 | £110,403 | £110,403 | £110,403 | £110,403 | |
| 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 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | |
| Bill Payments | £4,945 | £149,881 | £197,264 | £282,903 | £282,776 | £282,646 | £279,558 | £192,181 | £146,820 | £78,731 | £78,592 | £78,451 | |
| Subtotal Spent on Operations | £62,633 | £207,569 | £254,952 | £340,591 | £340,464 | £340,334 | £337,246 | £249,869 | £204,508 | £136,419 | £136,280 | £136,139 | |
| 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 | £8,995 | £9,137 | £9,282 | £9,429 | £9,578 | £9,730 | £9,884 | £10,041 | £10,200 | £10,361 | £10,525 | £10,692 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £4,809 | £4,850 | £4,890 | £4,931 | £4,972 | £5,013 | £5,055 | £5,097 | £5,140 | £5,182 | £5,226 | £5,269 | |
| 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 | £76,437 | £221,556 | £269,124 | £354,951 | £355,014 | £355,077 | £352,185 | £265,007 | £219,848 | £151,962 | £152,031 | £152,100 | |
| Net Cash Flow | £169,839 | £106,812 | £223,428 | £137,601 | £137,538 | £137,475 | (£23,817) | (£18,731) | (£109,445) | (£41,559) | (£41,628) | (£41,697) | |
| Cash Balance | £369,839 | £476,651 | £700,079 | £837,679 | £975,217 | £1,112,692 | £1,088,875 | £1,070,144 | £960,699 | £919,140 | £877,513 | £835,816 | |
| 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 | £200,000 | £369,839 | £476,651 | £700,079 | £837,679 | £975,217 | £1,112,692 | £1,088,875 | £1,070,144 | £960,699 | £919,140 | £877,513 | £835,816 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £200,000 | £369,839 | £476,651 | £700,079 | £837,679 | £975,217 | £1,112,692 | £1,088,875 | £1,070,144 | £960,699 | £919,140 | £877,513 | £835,816 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 |
| Total Assets | £5,277,925 | £5,447,764 | £5,554,576 | £5,778,004 | £5,915,604 | £6,053,142 | £6,190,617 | £6,166,800 | £6,148,069 | £6,038,624 | £5,997,065 | £5,955,438 | £5,913,741 |
| 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 | £143,404 | £187,834 | £273,477 | £273,354 | £273,229 | £273,102 | £187,209 | £144,196 | £76,111 | £75,977 | £75,840 | £75,702 |
| Current Borrowing | £890,000 | £881,005 | £871,868 | £862,586 | £853,157 | £843,579 | £833,849 | £823,965 | £813,924 | £803,724 | £793,363 | £782,838 | £772,146 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £890,000 | £1,024,409 | £1,059,702 | £1,136,063 | £1,126,511 | £1,116,808 | £1,106,951 | £1,011,174 | £958,120 | £879,835 | £869,340 | £858,678 | £847,848 |
| Long-term Liabilities | £3,652,500 | £3,647,691 | £3,642,841 | £3,637,951 | £3,633,020 | £3,628,048 | £3,623,035 | £3,617,980 | £3,612,883 | £3,607,743 | £3,602,561 | £3,597,335 | £3,592,066 |
| Total Liabilities | £4,542,500 | £4,672,100 | £4,702,543 | £4,774,014 | £4,759,531 | £4,744,856 | £4,729,986 | £4,629,154 | £4,571,003 | £4,487,578 | £4,471,901 | £4,456,013 | £4,439,914 |
| Paid-in Capital | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 |
| Retained Earnings | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) |
| Earnings | £0 | £40,239 | £116,608 | £268,564 | £420,648 | £572,861 | £725,205 | £802,221 | £841,642 | £815,621 | £789,740 | £763,999 | £738,401 |
| Total Capital | £735,425 | £775,664 | £852,033 | £1,003,989 | £1,156,073 | £1,308,286 | £1,460,630 | £1,537,646 | £1,577,067 | £1,551,046 | £1,525,165 | £1,499,424 | £1,473,826 |
| Total Liabilities and Capital | £5,277,925 | £5,447,764 | £5,554,576 | £5,778,004 | £5,915,604 | £6,053,142 | £6,190,617 | £6,166,800 | £6,148,069 | £6,038,624 | £5,997,065 | £5,955,438 | £5,913,741 |
| Net Worth | £735,425 | £775,664 | £852,033 | £1,003,989 | £1,156,073 | £1,308,286 | £1,460,630 | £1,537,646 | £1,577,067 | £1,551,046 | £1,525,165 | £1,499,424 | £1,473,826 |
| 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 | |||||||||||||
| Amusement | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Bumper Boats | 0% | £18,605 | £24,806 | £37,209 | £37,209 | £37,209 | £37,209 | £24,806 | £18,605 | £6,202 | £6,202 | £6,202 | £6,202 |
| Mini-Golf | 0% | £33,351 | £44,467 | £66,701 | £66,701 | £66,701 | £66,701 | £44,467 | £33,351 | £11,117 | £11,117 | £11,117 | £11,117 |
| Go-Carts | 0% | £85,272 | £113,695 | £170,543 | £170,543 | £170,543 | £170,543 | £113,695 | £85,272 | £28,424 | £28,424 | £28,424 | £28,424 |
| Gaming Center | 0% | £2,756 | £3,675 | £5,512 | £5,512 | £5,512 | £5,512 | £3,675 | £2,756 | £919 | £919 | £919 | £919 |
| Sky Coaster | 0% | £11,025 | £14,700 | £22,050 | £22,050 | £22,050 | £22,050 | £14,700 | £11,025 | £3,675 | £3,675 | £3,675 | £3,675 |
| Batting Cages | 0% | £10,336 | £13,781 | £20,671 | £20,671 | £20,671 | £20,671 | £13,781 | £10,336 | £3,445 | £3,445 | £3,445 | £3,445 |
| Climbing Walls | 0% | £3,652 | £4,869 | £7,304 | £7,304 | £7,304 | £7,304 | £4,869 | £3,652 | £2,435 | £2,435 | £2,435 | £2,435 |
| Air/Foosball | 0% | £1,194 | £1,592 | £2,388 | £2,388 | £2,388 | £2,388 | £1,592 | £1,194 | £796 | £796 | £796 | £796 |
| Souvenirs | 0% | £1,838 | £2,450 | £3,675 | £3,675 | £3,675 | £3,675 | £2,450 | £1,838 | £1,225 | £1,225 | £1,225 | £1,225 |
| Party Rooms | 0% | £30,016 | £40,021 | £60,031 | £60,031 | £60,031 | £60,031 | £40,021 | £30,016 | £20,010 | £20,010 | £20,010 | £20,010 |
| Food & Drinks | 0% | £48,234 | £64,312 | £96,468 | £96,468 | £96,468 | £96,468 | £64,312 | £48,234 | £32,156 | £32,156 | £32,156 | £32,156 |
| Total Sales | £246,276 | £328,368 | £492,552 | £492,552 | £492,552 | £492,552 | £328,368 | £246,276 | £110,403 | £110,403 | £110,403 | £110,403 | |
| 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 | |
| Amusement | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Bumper Boats | £4,651 | £6,202 | £9,302 | £9,302 | £9,302 | £9,302 | £6,202 | £4,651 | £1,550 | £1,550 | £1,550 | £1,550 | |
| Mini-Golf | £5,003 | £6,670 | £10,005 | £10,005 | £10,005 | £10,005 | £6,670 | £5,003 | £1,668 | £1,668 | £1,668 | £1,668 | |
| Go-Carts | £21,318 | £28,424 | £42,636 | £42,636 | £42,636 | £42,636 | £28,424 | £21,318 | £7,106 | £7,106 | £7,106 | £7,106 | |
| Gaming Center | £1,378 | £1,837 | £2,756 | £2,756 | £2,756 | £2,756 | £1,837 | £1,378 | £459 | £459 | £459 | £459 | |
| Sky Coaster | £2,756 | £3,675 | £5,513 | £5,513 | £5,513 | £5,513 | £3,675 | £2,756 | £919 | £919 | £919 | £919 | |
| Batting Cages | £1,550 | £2,067 | £3,101 | £3,101 | £3,101 | £3,101 | £2,067 | £1,550 | £517 | £517 | £517 | £517 | |
| Climbing Walls | £913 | £1,217 | £1,826 | £1,826 | £1,826 | £1,826 | £1,217 | £913 | £609 | £609 | £609 | £609 | |
| Air/Foosball | £179 | £239 | £358 | £358 | £358 | £358 | £239 | £179 | £119 | £119 | £119 | £119 | |
| Souvenirs | £459 | £613 | £919 | £919 | £919 | £919 | £613 | £459 | £306 | £306 | £306 | £306 | |
| Party Rooms | £15,008 | £20,010 | £30,016 | £30,016 | £30,016 | £30,016 | £20,010 | £15,008 | £10,005 | £10,005 | £10,005 | £10,005 | |
| Food & Drinks | £24,117 | £32,156 | £48,234 | £48,234 | £48,234 | £48,234 | £32,156 | £24,117 | £16,078 | £16,078 | £16,078 | £16,078 | |
| Subtotal Direct Cost of Sales | £77,332 | £103,110 | £154,665 | £154,665 | £154,665 | £154,665 | £103,110 | £77,332 | £39,336 | £39,336 | £39,336 | £39,336 | |
| 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 | ||
| Operations Personnel | |||||||||||||
| John A | 100% | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 |
| John B | 100% | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 |
| John C | 100% | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 | £1,932 |
| John D | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John E | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John F | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John G | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John H | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John I | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John J | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John K | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John L | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John M | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John N | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John O | 100% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| John P | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| John Q | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| John R | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| John S | 100% | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 |
| John T | 100% | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 |
| John U | 100% | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 |
| Subtotal | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | |
| Sales and Marketing Personnel | |||||||||||||
| Darren Strebel | 100% | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 |
| Other | 100% | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 |
| Subtotal | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | |
| General and Administrative Personnel | |||||||||||||
| Joe Hull | 100% | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 |
| Rod Schaffer | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| Restaurant Manager | 100% | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 | £3,404 |
| Laura Strebel | 100% | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 |
| Mark Bergman | 100% | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 | £4,140 |
| Subtotal | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | |
| Other Personnel | |||||||||||||
| Jack A | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| Jack B | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| Jack C | 100% | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 | £1,748 |
| Sara A | 100% | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 | £1,564 |
| Subtotal | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | |
| Total People | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | |
| Total Payroll | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | |
| 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 | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.00% | 19.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% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | 33.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 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 | £246,276 | £328,368 | £492,552 | £492,552 | £492,552 | £492,552 | £328,368 | £246,276 | £110,403 | £110,403 | £110,403 | £110,403 | |
| Direct Cost of Sales | £77,332 | £103,110 | £154,665 | £154,665 | £154,665 | £154,665 | £103,110 | £77,332 | £39,336 | £39,336 | £39,336 | £39,336 | |
| Operations Payroll | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | £32,388 | |
| Known expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £109,720 | £135,498 | £187,053 | £187,053 | £187,053 | £187,053 | £135,498 | £109,720 | £71,724 | £71,724 | £71,724 | £71,724 | |
| Gross Margin | £136,556 | £192,870 | £305,499 | £305,499 | £305,499 | £305,499 | £192,870 | £136,556 | £38,679 | £38,679 | £38,679 | £38,679 | |
| Gross Margin % | 55.45% | 58.74% | 62.02% | 62.02% | 62.02% | 62.02% | 58.74% | 55.45% | 35.03% | 35.03% | 35.03% | 35.03% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | £4,600 | |
| Advertising/Promotion | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Travel | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Miscellaneous | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Total Sales and Marketing Expenses | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | |
| Sales and Marketing % | 2.74% | 2.06% | 1.37% | 1.37% | 1.37% | 1.37% | 2.06% | 2.74% | 6.11% | 6.11% | 6.11% | 6.11% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | £14,260 | |
| Sales and Marketing and Other Expenses | £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 | |
| Utilities | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Insurance | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | |
| Telephone | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Payroll Taxes | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | £17,490 | |
| General and Administrative % | 7.10% | 5.33% | 3.55% | 3.55% | 3.55% | 3.55% | 5.33% | 7.10% | 15.84% | 15.84% | 15.84% | 15.84% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | £6,440 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Office Supplies | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Postal Fees | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Professional Fees | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Housekeeping Supplies | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | £1,060 | |
| Unknown | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Bad Checks | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Bank Card Fees | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Business License | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | £35 | |
| Facility Maintenance | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Contract/Consultants | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | £450 | |
| Total Other Expenses | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | |
| Other % | 4.26% | 3.19% | 2.13% | 2.13% | 2.13% | 2.13% | 3.19% | 4.26% | 9.50% | 9.50% | 9.50% | 9.50% | |
| Total Operating Expenses | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | £34,725 | |
| Profit Before Interest and Taxes | £101,831 | £158,145 | £270,774 | £270,774 | £270,774 | £270,774 | £158,145 | £101,831 | £3,954 | £3,954 | £3,954 | £3,954 | |
| EBITDA | £101,831 | £158,145 | £270,774 | £270,774 | £270,774 | £270,774 | £158,145 | £101,831 | £3,954 | £3,954 | £3,954 | £3,954 | |
| Interest Expense | £44,347 | £44,162 | £43,974 | £43,783 | £43,590 | £43,395 | £43,196 | £42,994 | £42,790 | £42,583 | £42,373 | £42,160 | |
| Taxes Incurred | £17,245 | £37,615 | £74,844 | £74,907 | £74,971 | £75,035 | £37,933 | £19,416 | (£12,816) | (£12,748) | (£12,678) | (£12,608) | |
| Net Profit | £40,239 | £76,369 | £151,956 | £152,084 | £152,213 | £152,344 | £77,016 | £39,420 | (£26,020) | (£25,882) | (£25,741) | (£25,598) | |
| Net Profit/Sales | 16.34% | 23.26% | 30.85% | 30.88% | 30.90% | 30.93% | 23.45% | 16.01% | -23.57% | -23.44% | -23.32% | -23.19% | |
| 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 | £246,276 | £328,368 | £492,552 | £492,552 | £492,552 | £492,552 | £328,368 | £246,276 | £110,403 | £110,403 | £110,403 | £110,403 | |
| Subtotal Cash from Operations | £246,276 | £328,368 | £492,552 | £492,552 | £492,552 | £492,552 | £328,368 | £246,276 | £110,403 | £110,403 | £110,403 | £110,403 | |
| 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 | £246,276 | £328,368 | £492,552 | £492,552 | £492,552 | £492,552 | £328,368 | £246,276 | £110,403 | £110,403 | £110,403 | £110,403 | |
| 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 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | £57,688 | |
| Bill Payments | £4,945 | £149,881 | £197,264 | £282,903 | £282,776 | £282,646 | £279,558 | £192,181 | £146,820 | £78,731 | £78,592 | £78,451 | |
| Subtotal Spent on Operations | £62,633 | £207,569 | £254,952 | £340,591 | £340,464 | £340,334 | £337,246 | £249,869 | £204,508 | £136,419 | £136,280 | £136,139 | |
| 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 | £8,995 | £9,137 | £9,282 | £9,429 | £9,578 | £9,730 | £9,884 | £10,041 | £10,200 | £10,361 | £10,525 | £10,692 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £4,809 | £4,850 | £4,890 | £4,931 | £4,972 | £5,013 | £5,055 | £5,097 | £5,140 | £5,182 | £5,226 | £5,269 | |
| 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 | £76,437 | £221,556 | £269,124 | £354,951 | £355,014 | £355,077 | £352,185 | £265,007 | £219,848 | £151,962 | £152,031 | £152,100 | |
| Net Cash Flow | £169,839 | £106,812 | £223,428 | £137,601 | £137,538 | £137,475 | (£23,817) | (£18,731) | (£109,445) | (£41,559) | (£41,628) | (£41,697) | |
| Cash Balance | £369,839 | £476,651 | £700,079 | £837,679 | £975,217 | £1,112,692 | £1,088,875 | £1,070,144 | £960,699 | £919,140 | £877,513 | £835,816 | |
| 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 | £200,000 | £369,839 | £476,651 | £700,079 | £837,679 | £975,217 | £1,112,692 | £1,088,875 | £1,070,144 | £960,699 | £919,140 | £877,513 | £835,816 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £200,000 | £369,839 | £476,651 | £700,079 | £837,679 | £975,217 | £1,112,692 | £1,088,875 | £1,070,144 | £960,699 | £919,140 | £877,513 | £835,816 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 | £5,077,925 |
| Total Assets | £5,277,925 | £5,447,764 | £5,554,576 | £5,778,004 | £5,915,604 | £6,053,142 | £6,190,617 | £6,166,800 | £6,148,069 | £6,038,624 | £5,997,065 | £5,955,438 | £5,913,741 |
| 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 | £143,404 | £187,834 | £273,477 | £273,354 | £273,229 | £273,102 | £187,209 | £144,196 | £76,111 | £75,977 | £75,840 | £75,702 |
| Current Borrowing | £890,000 | £881,005 | £871,868 | £862,586 | £853,157 | £843,579 | £833,849 | £823,965 | £813,924 | £803,724 | £793,363 | £782,838 | £772,146 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £890,000 | £1,024,409 | £1,059,702 | £1,136,063 | £1,126,511 | £1,116,808 | £1,106,951 | £1,011,174 | £958,120 | £879,835 | £869,340 | £858,678 | £847,848 |
| Long-term Liabilities | £3,652,500 | £3,647,691 | £3,642,841 | £3,637,951 | £3,633,020 | £3,628,048 | £3,623,035 | £3,617,980 | £3,612,883 | £3,607,743 | £3,602,561 | £3,597,335 | £3,592,066 |
| Total Liabilities | £4,542,500 | £4,672,100 | £4,702,543 | £4,774,014 | £4,759,531 | £4,744,856 | £4,729,986 | £4,629,154 | £4,571,003 | £4,487,578 | £4,471,901 | £4,456,013 | £4,439,914 |
| Paid-in Capital | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 | £965,000 |
| Retained Earnings | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) | (£229,575) |
| Earnings | £0 | £40,239 | £116,608 | £268,564 | £420,648 | £572,861 | £725,205 | £802,221 | £841,642 | £815,621 | £789,740 | £763,999 | £738,401 |
| Total Capital | £735,425 | £775,664 | £852,033 | £1,003,989 | £1,156,073 | £1,308,286 | £1,460,630 | £1,537,646 | £1,577,067 | £1,551,046 | £1,525,165 | £1,499,424 | £1,473,826 |
| Total Liabilities and Capital | £5,277,925 | £5,447,764 | £5,554,576 | £5,778,004 | £5,915,604 | £6,053,142 | £6,190,617 | £6,166,800 | £6,148,069 | £6,038,624 | £5,997,065 | £5,955,438 | £5,913,741 |
| Net Worth | £735,425 | £775,664 | £852,033 | £1,003,989 | £1,156,073 | £1,308,286 | £1,460,630 | £1,537,646 | £1,577,067 | £1,551,046 | £1,525,165 | £1,499,424 | £1,473,826 |