| 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 | |||||||||||||
| Diesel (gallons) | 0% | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 |
| Gasoline (gallons) | 41% | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 |
| Travel Store | 9% | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 |
| Interstate Travel Restaurant | 3% | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 |
| Rebates, allowances, etc. | 10% | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 |
| Total Unit Sales | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | |
| 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 | |
| Diesel (gallons) | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | |
| Gasoline (gallons) | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | |
| Travel Store | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | |
| Interstate Travel Restaurant | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | |
| Rebates, allowances, etc. | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | |
| Sales | |||||||||||||
| Diesel (gallons) | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | |
| Gasoline (gallons) | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | |
| Travel Store | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | |
| Interstate Travel Restaurant | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | |
| Rebates, allowances, etc. | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | |
| Total Sales | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,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 | |
| Diesel (gallons) | 8.00% | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 |
| Gasoline (gallons) | 0.00% | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 |
| Travel Store | 0.00% | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 |
| Interstate Travel Restaurant | 0.00% | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 |
| Rebates, allowances, etc. | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Diesel (gallons) | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | |
| Gasoline (gallons) | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | |
| Travel Store | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | |
| Interstate Travel Restaurant | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | |
| Rebates, allowances, etc. | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | |
| 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 | ||
| Steve Smith | 0% | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 |
| Janet Smith | 0% | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 |
| Convenience store/Gas station Manager | 0% | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 |
| Restaurant Manager | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Assist Manager - Cook | 0% | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Cook 2 | 0% | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Cook 3 | 0% | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Cook 4 | 0% | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Cook 5 | 0% | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Cook 6 | 0% | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Waitress/Waiter | 0% | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 |
| Waitress/Waiter | 0% | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 |
| Waitress/Waiter | 0% | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 |
| Waitress/Waiter | 0% | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Assist. Manager - Cashier | 0% | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Cashier | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Cashier | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Cashier | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Cashier | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Maintenance | 0% | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | |
| 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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | |
| Direct Cost of Sales | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | |
| Gross Margin | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | |
| Gross Margin % | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | |
| Expenses | |||||||||||||
| Payroll | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | |
| Sales and Marketing and Other Expenses | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | |
| Depreciation | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Leased Equipment | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | |
| Utilities | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | |
| Insurance | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Payroll Taxes | 15% | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | |
| Profit Before Interest and Taxes | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | |
| EBITDA | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | |
| Interest Expense | £20,642 | £20,451 | £20,260 | £20,069 | £19,878 | £19,688 | £19,497 | £19,306 | £19,115 | £18,924 | £18,733 | £18,542 | |
| Taxes Incurred | £21,810 | £18,223 | £18,271 | £18,319 | £18,366 | £18,414 | £18,462 | £18,510 | £18,557 | £18,605 | £18,653 | £18,701 | |
| Net Profit | £50,891 | £54,669 | £54,813 | £54,956 | £55,099 | £55,242 | £55,385 | £55,529 | £55,672 | £55,815 | £55,958 | £56,102 | |
| Net Profit/Sales | 7.44% | 8.00% | 8.02% | 8.04% | 8.06% | 8.08% | 8.10% | 8.12% | 8.14% | 8.16% | 8.19% | 8.21% | |
| 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 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | |
| Subtotal Cash from Operations | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,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 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,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 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | |
| Bill Payments | £36,030 | £1,064,409 | £586,287 | £586,144 | £586,000 | £585,857 | £585,714 | £585,571 | £585,427 | £585,284 | £585,141 | £584,998 | |
| Subtotal Spent on Operations | £76,169 | £1,104,548 | £626,426 | £626,283 | £626,140 | £625,996 | £625,853 | £625,710 | £625,567 | £625,424 | £625,280 | £625,137 | |
| 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 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | |
| 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 | £99,086 | £1,127,465 | £649,343 | £649,200 | £649,056 | £648,913 | £648,770 | £648,627 | £648,483 | £648,340 | £648,197 | £648,054 | |
| Net Cash Flow | £584,514 | (£443,865) | £34,257 | £34,401 | £34,544 | £34,687 | £34,830 | £34,974 | £35,117 | £35,260 | £35,403 | £35,546 | |
| Cash Balance | £834,514 | £390,650 | £424,907 | £459,308 | £493,852 | £528,539 | £563,369 | £598,343 | £633,459 | £668,719 | £704,123 | £739,669 | |
| 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 | £250,000 | £834,514 | £390,650 | £424,907 | £459,308 | £493,852 | £528,539 | £563,369 | £598,343 | £633,459 | £668,719 | £704,123 | £739,669 |
| Inventory | £65,000 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 |
| Other Current Assets | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Total Current Assets | £365,000 | £1,440,340 | £996,476 | £1,030,733 | £1,065,134 | £1,099,677 | £1,134,365 | £1,169,195 | £1,204,168 | £1,239,285 | £1,274,545 | £1,309,948 | £1,345,495 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 |
| Accumulated Depreciation | £0 | £2,500 | £5,000 | £7,500 | £10,000 | £12,500 | £15,000 | £17,500 | £20,000 | £22,500 | £25,000 | £27,500 | £30,000 |
| Total Long-term Assets | £1,600,000 | £1,597,500 | £1,595,000 | £1,592,500 | £1,590,000 | £1,587,500 | £1,585,000 | £1,582,500 | £1,580,000 | £1,577,500 | £1,575,000 | £1,572,500 | £1,570,000 |
| Total Assets | £1,965,000 | £3,037,840 | £2,591,476 | £2,623,233 | £2,655,134 | £2,687,177 | £2,719,365 | £2,751,695 | £2,784,168 | £2,816,785 | £2,849,545 | £2,882,448 | £2,915,495 |
| 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 | £1,044,866 | £566,749 | £566,610 | £566,472 | £566,333 | £566,195 | £566,056 | £565,918 | £565,779 | £565,641 | £565,502 | £565,364 |
| 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 | £1,044,866 | £566,749 | £566,610 | £566,472 | £566,333 | £566,195 | £566,056 | £565,918 | £565,779 | £565,641 | £565,502 | £565,364 |
| Long-term Liabilities | £2,500,000 | £2,477,083 | £2,454,167 | £2,431,250 | £2,408,333 | £2,385,417 | £2,362,500 | £2,339,583 | £2,316,667 | £2,293,750 | £2,270,833 | £2,247,917 | £2,225,000 |
| Total Liabilities | £2,500,000 | £3,521,949 | £3,020,915 | £2,997,860 | £2,974,805 | £2,951,750 | £2,928,695 | £2,905,640 | £2,882,585 | £2,859,529 | £2,836,474 | £2,813,419 | £2,790,364 |
| Paid-in Capital | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 |
| Retained Earnings | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) |
| Earnings | £0 | £50,891 | £105,560 | £160,373 | £215,329 | £270,428 | £325,670 | £381,055 | £436,584 | £492,256 | £548,071 | £604,029 | £660,131 |
| Total Capital | (£535,000) | (£484,109) | (£429,440) | (£374,627) | (£319,671) | (£264,572) | (£209,330) | (£153,945) | (£98,416) | (£42,744) | £13,071 | £69,029 | £125,131 |
| Total Liabilities and Capital | £1,965,000 | £3,037,840 | £2,591,476 | £2,623,233 | £2,655,134 | £2,687,177 | £2,719,365 | £2,751,695 | £2,784,168 | £2,816,785 | £2,849,545 | £2,882,448 | £2,915,495 |
| Net Worth | (£535,000) | (£484,109) | (£429,440) | (£374,627) | (£319,671) | (£264,572) | (£209,330) | (£153,945) | (£98,416) | (£42,744) | £13,071 | £69,029 | £125,131 |
| 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 | |||||||||||||
| Diesel (gallons) | 0% | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 | 212,500 |
| Gasoline (gallons) | 41% | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 | 87,500 |
| Travel Store | 9% | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 | 19,167 |
| Interstate Travel Restaurant | 3% | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 | 6,773 |
| Rebates, allowances, etc. | 10% | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 | 20,550 |
| Total Unit Sales | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | 346,490 | |
| 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 | |
| Diesel (gallons) | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | £1.75 | |
| Gasoline (gallons) | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | |
| Travel Store | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | £3.75 | |
| Interstate Travel Restaurant | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | |
| Rebates, allowances, etc. | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | |
| Sales | |||||||||||||
| Diesel (gallons) | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | £371,875 | |
| Gasoline (gallons) | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | £131,250 | |
| Travel Store | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | £71,876 | |
| Interstate Travel Restaurant | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | £88,049 | |
| Rebates, allowances, etc. | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | £20,550 | |
| Total Sales | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,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 | |
| Diesel (gallons) | 8.00% | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 | £1.67 |
| Gasoline (gallons) | 0.00% | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 | £1.40 |
| Travel Store | 0.00% | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 |
| Interstate Travel Restaurant | 0.00% | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 |
| Rebates, allowances, etc. | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Diesel (gallons) | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | £354,875 | |
| Gasoline (gallons) | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | £122,500 | |
| Travel Store | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | £14,375 | |
| Interstate Travel Restaurant | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | £13,546 | |
| Rebates, allowances, etc. | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | |
| 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 | ||
| Steve Smith | 0% | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 |
| Janet Smith | 0% | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 | £4,167 |
| Convenience store/Gas station Manager | 0% | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 |
| Restaurant Manager | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Assist Manager - Cook | 0% | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Cook 2 | 0% | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Cook 3 | 0% | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Cook 4 | 0% | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Cook 5 | 0% | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Cook 6 | 0% | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Waitress/Waiter | 0% | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 |
| Waitress/Waiter | 0% | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 |
| Waitress/Waiter | 0% | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 |
| Waitress/Waiter | 0% | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 | £984 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Waitress/Waiter | 0% | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 | £640 |
| Assist. Manager - Cashier | 0% | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Cashier | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Cashier | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Cashier | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Cashier | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Maintenance | 0% | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | |
| 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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | |
| Direct Cost of Sales | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | £505,296 | |
| Gross Margin | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | £178,304 | |
| Gross Margin % | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | 26.08% | |
| Expenses | |||||||||||||
| Payroll | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | |
| Sales and Marketing and Other Expenses | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | £18,400 | |
| Depreciation | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Leased Equipment | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | £4,150 | |
| Utilities | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | £4,100 | |
| Insurance | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | £7,650 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Payroll Taxes | 15% | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 | £6,021 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | £84,960 | |
| Profit Before Interest and Taxes | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | £93,344 | |
| EBITDA | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | £95,844 | |
| Interest Expense | £20,642 | £20,451 | £20,260 | £20,069 | £19,878 | £19,688 | £19,497 | £19,306 | £19,115 | £18,924 | £18,733 | £18,542 | |
| Taxes Incurred | £21,810 | £18,223 | £18,271 | £18,319 | £18,366 | £18,414 | £18,462 | £18,510 | £18,557 | £18,605 | £18,653 | £18,701 | |
| Net Profit | £50,891 | £54,669 | £54,813 | £54,956 | £55,099 | £55,242 | £55,385 | £55,529 | £55,672 | £55,815 | £55,958 | £56,102 | |
| Net Profit/Sales | 7.44% | 8.00% | 8.02% | 8.04% | 8.06% | 8.08% | 8.10% | 8.12% | 8.14% | 8.16% | 8.19% | 8.21% | |
| 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 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | |
| Subtotal Cash from Operations | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,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 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,600 | £683,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 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | £40,139 | |
| Bill Payments | £36,030 | £1,064,409 | £586,287 | £586,144 | £586,000 | £585,857 | £585,714 | £585,571 | £585,427 | £585,284 | £585,141 | £584,998 | |
| Subtotal Spent on Operations | £76,169 | £1,104,548 | £626,426 | £626,283 | £626,140 | £625,996 | £625,853 | £625,710 | £625,567 | £625,424 | £625,280 | £625,137 | |
| 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 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | £22,917 | |
| 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 | £99,086 | £1,127,465 | £649,343 | £649,200 | £649,056 | £648,913 | £648,770 | £648,627 | £648,483 | £648,340 | £648,197 | £648,054 | |
| Net Cash Flow | £584,514 | (£443,865) | £34,257 | £34,401 | £34,544 | £34,687 | £34,830 | £34,974 | £35,117 | £35,260 | £35,403 | £35,546 | |
| Cash Balance | £834,514 | £390,650 | £424,907 | £459,308 | £493,852 | £528,539 | £563,369 | £598,343 | £633,459 | £668,719 | £704,123 | £739,669 | |
| 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 | £250,000 | £834,514 | £390,650 | £424,907 | £459,308 | £493,852 | £528,539 | £563,369 | £598,343 | £633,459 | £668,719 | £704,123 | £739,669 |
| Inventory | £65,000 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 | £555,826 |
| Other Current Assets | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Total Current Assets | £365,000 | £1,440,340 | £996,476 | £1,030,733 | £1,065,134 | £1,099,677 | £1,134,365 | £1,169,195 | £1,204,168 | £1,239,285 | £1,274,545 | £1,309,948 | £1,345,495 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 | £1,600,000 |
| Accumulated Depreciation | £0 | £2,500 | £5,000 | £7,500 | £10,000 | £12,500 | £15,000 | £17,500 | £20,000 | £22,500 | £25,000 | £27,500 | £30,000 |
| Total Long-term Assets | £1,600,000 | £1,597,500 | £1,595,000 | £1,592,500 | £1,590,000 | £1,587,500 | £1,585,000 | £1,582,500 | £1,580,000 | £1,577,500 | £1,575,000 | £1,572,500 | £1,570,000 |
| Total Assets | £1,965,000 | £3,037,840 | £2,591,476 | £2,623,233 | £2,655,134 | £2,687,177 | £2,719,365 | £2,751,695 | £2,784,168 | £2,816,785 | £2,849,545 | £2,882,448 | £2,915,495 |
| 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 | £1,044,866 | £566,749 | £566,610 | £566,472 | £566,333 | £566,195 | £566,056 | £565,918 | £565,779 | £565,641 | £565,502 | £565,364 |
| 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 | £1,044,866 | £566,749 | £566,610 | £566,472 | £566,333 | £566,195 | £566,056 | £565,918 | £565,779 | £565,641 | £565,502 | £565,364 |
| Long-term Liabilities | £2,500,000 | £2,477,083 | £2,454,167 | £2,431,250 | £2,408,333 | £2,385,417 | £2,362,500 | £2,339,583 | £2,316,667 | £2,293,750 | £2,270,833 | £2,247,917 | £2,225,000 |
| Total Liabilities | £2,500,000 | £3,521,949 | £3,020,915 | £2,997,860 | £2,974,805 | £2,951,750 | £2,928,695 | £2,905,640 | £2,882,585 | £2,859,529 | £2,836,474 | £2,813,419 | £2,790,364 |
| Paid-in Capital | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 |
| Retained Earnings | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) | (£785,000) |
| Earnings | £0 | £50,891 | £105,560 | £160,373 | £215,329 | £270,428 | £325,670 | £381,055 | £436,584 | £492,256 | £548,071 | £604,029 | £660,131 |
| Total Capital | (£535,000) | (£484,109) | (£429,440) | (£374,627) | (£319,671) | (£264,572) | (£209,330) | (£153,945) | (£98,416) | (£42,744) | £13,071 | £69,029 | £125,131 |
| Total Liabilities and Capital | £1,965,000 | £3,037,840 | £2,591,476 | £2,623,233 | £2,655,134 | £2,687,177 | £2,719,365 | £2,751,695 | £2,784,168 | £2,816,785 | £2,849,545 | £2,882,448 | £2,915,495 |
| Net Worth | (£535,000) | (£484,109) | (£429,440) | (£374,627) | (£319,671) | (£264,572) | (£209,330) | (£153,945) | (£98,416) | (£42,744) | £13,071 | £69,029 | £125,131 |