|
|
| Sales Forecast |
| Gasoline |
0% |
£40,000 |
£40,000 |
£48,000 |
£55,000 |
£55,000 |
£55,000 |
£55,000 |
£55,000 |
£55,000 |
£55,000 |
£55,000 |
£55,000 |
| Food, Drinks, and Produce |
0% |
£10,000 |
£12,000 |
£14,000 |
£15,000 |
£16,000 |
£16,000 |
£17,000 |
£17,000 |
£17,000 |
£17,000 |
£17,000 |
£17,000 |
| Total Sales |
|
£50,000 |
£52,000 |
£62,000 |
£70,000 |
£71,000 |
£71,000 |
£72,000 |
£72,000 |
£72,000 |
£72,000 |
£72,000 |
£72,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gasoline |
|
£35,000 |
£35,000 |
£42,000 |
£48,000 |
£48,000 |
£48,000 |
£48,000 |
£48,000 |
£48,000 |
£48,000 |
£48,000 |
£48,000 |
| Food, Drinks, and Produce |
|
£2,000 |
£2,500 |
£2,900 |
£3,000 |
£3,200 |
£3,200 |
£3,400 |
£3,400 |
£3,400 |
£3,400 |
£3,400 |
£3,400 |
| Subtotal Direct Cost of Sales |
|
£37,000 |
£37,500 |
£44,900 |
£51,000 |
£51,200 |
£51,200 |
£51,400 |
£51,400 |
£51,400 |
£51,400 |
£51,400 |
£51,400 |
| Personnel Plan |
| Robert Cole |
0% |
£2,800 |
£2,800 |
£2,800 |
£2,800 |
£2,800 |
£2,800 |
£2,800 |
£2,800 |
£2,800 |
£2,800 |
£2,800 |
£2,800 |
| Store/Deli Staff |
0% |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
| Gas Attendants |
0% |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
£3,500 |
| Total People |
|
5 |
5 |
5 |
5 |
5 |
5 |
5 |
5 |
5 |
5 |
5 |
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
| General Assumptions |
| 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% |
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 |

| Pro Forma Profit and Loss |
| Direct Cost of Sales |
|
£37,000 |
£37,500 |
£44,900 |
£51,000 |
£51,200 |
£51,200 |
£51,400 |
£51,400 |
£51,400 |
£51,400 |
£51,400 |
£51,400 |
| Other Production Expenses |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Cost of Sales |
|
£37,000 |
£37,500 |
£44,900 |
£51,000 |
£51,200 |
£51,200 |
£51,400 |
£51,400 |
£51,400 |
£51,400 |
£51,400 |
£51,400 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£13,000 |
£14,500 |
£17,100 |
£19,000 |
£19,800 |
£19,800 |
£20,600 |
£20,600 |
£20,600 |
£20,600 |
£20,600 |
£20,600 |
| Gross Margin % |
|
26.00% |
27.88% |
27.58% |
27.14% |
27.89% |
27.89% |
28.61% |
28.61% |
28.61% |
28.61% |
28.61% |
28.61% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
| Sales and Marketing and Other Expenses |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Depreciation |
|
£952 |
£952 |
£952 |
£952 |
£952 |
£952 |
£952 |
£952 |
£952 |
£952 |
£952 |
£952 |
| Leased Equipment |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Utilities |
|
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
| Insurance |
|
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
| Rent |
|
£0 |
£0 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
£1,300 |
| Payroll Taxes |
15% |
£1,470 |
£1,470 |
£1,470 |
£1,470 |
£1,470 |
£1,470 |
£1,470 |
£1,470 |
£1,470 |
£1,470 |
£1,470 |
£1,470 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
|
£178 |
£1,678 |
£2,978 |
£4,878 |
£5,678 |
£5,678 |
£6,478 |
£6,478 |
£6,478 |
£6,478 |
£6,478 |
£6,478 |
| EBITDA |
|
£1,130 |
£2,630 |
£3,930 |
£5,830 |
£6,630 |
£6,630 |
£7,430 |
£7,430 |
£7,430 |
£7,430 |
£7,430 |
£7,430 |
| Interest Expense |
|
£1,229 |
£1,208 |
£1,188 |
£1,167 |
£1,146 |
£1,125 |
£1,104 |
£1,083 |
£1,063 |
£1,042 |
£1,021 |
£1,000 |
| Taxes Incurred |
|
(£315) |
£141 |
£537 |
£1,113 |
£1,360 |
£1,366 |
£1,612 |
£1,618 |
£1,625 |
£1,631 |
£1,637 |
£1,643 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
-1.47% |
0.63% |
2.02% |
3.71% |
4.47% |
4.49% |
5.22% |
5.24% |
5.27% |
5.29% |
5.31% |
5.33% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£50,000 |
£52,000 |
£62,000 |
£70,000 |
£71,000 |
£71,000 |
£72,000 |
£72,000 |
£72,000 |
£72,000 |
£72,000 |
£72,000 |
| Subtotal Cash from Operations |
|
£50,000 |
£52,000 |
£62,000 |
£70,000 |
£71,000 |
£71,000 |
£72,000 |
£72,000 |
£72,000 |
£72,000 |
£72,000 |
£72,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£50,000 |
£52,000 |
£62,000 |
£70,000 |
£71,000 |
£71,000 |
£72,000 |
£72,000 |
£72,000 |
£72,000 |
£72,000 |
£72,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
£9,800 |
| Bill Payments |
|
£2,356 |
£69,710 |
£42,025 |
£58,309 |
£63,158 |
£57,288 |
£57,082 |
£57,698 |
£57,471 |
£57,457 |
£57,442 |
£57,427 |
| Subtotal Spent on Operations |
|
£12,156 |
£79,510 |
£51,825 |
£68,109 |
£72,958 |
£67,088 |
£66,882 |
£67,498 |
£67,271 |
£67,257 |
£67,242 |
£67,227 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| 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 |
|
£14,656 |
£82,010 |
£54,325 |
£70,609 |
£75,458 |
£69,588 |
£69,382 |
£69,998 |
£69,771 |
£69,757 |
£69,742 |
£69,727 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£53,844 |
£23,834 |
£31,509 |
£30,900 |
£26,442 |
£27,855 |
£30,472 |
£32,474 |
£34,703 |
£36,946 |
£39,204 |
£41,476 |

| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£18,500 |
£53,844 |
£23,834 |
£31,509 |
£30,900 |
£26,442 |
£27,855 |
£30,472 |
£32,474 |
£34,703 |
£36,946 |
£39,204 |
£41,476 |
| Inventory |
£10,000 |
£40,700 |
£41,250 |
£49,390 |
£56,100 |
£56,320 |
£56,320 |
£56,540 |
£56,540 |
£56,540 |
£56,540 |
£56,540 |
£56,540 |
| Other Current Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Current Assets |
£28,500 |
£94,544 |
£65,084 |
£80,899 |
£87,000 |
£82,762 |
£84,175 |
£87,012 |
£89,014 |
£91,243 |
£93,486 |
£95,744 |
£98,016 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
£80,000 |
£80,000 |
£80,000 |
£80,000 |
£80,000 |
£80,000 |
£80,000 |
£80,000 |
£80,000 |
£80,000 |
£80,000 |
£80,000 |
£80,000 |
| Accumulated Depreciation |
£0 |
£952 |
£1,904 |
£2,856 |
£3,808 |
£4,760 |
£5,712 |
£6,664 |
£7,616 |
£8,568 |
£9,520 |
£10,472 |
£11,424 |
| Total Long-term Assets |
£80,000 |
£79,048 |
£78,096 |
£77,144 |
£76,192 |
£75,240 |
£74,288 |
£73,336 |
£72,384 |
£71,432 |
£70,480 |
£69,528 |
£68,576 |
| Total Assets |
£108,500 |
£173,592 |
£143,180 |
£158,043 |
£163,192 |
£158,002 |
£158,463 |
£160,348 |
£161,398 |
£162,675 |
£163,966 |
£165,272 |
£166,592 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts Payable |
£0 |
£68,328 |
£40,087 |
£56,197 |
£61,248 |
£55,386 |
£55,159 |
£55,783 |
£55,556 |
£55,542 |
£55,528 |
£55,514 |
£55,500 |
| 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 |
£68,328 |
£40,087 |
£56,197 |
£61,248 |
£55,386 |
£55,159 |
£55,783 |
£55,556 |
£55,542 |
£55,528 |
£55,514 |
£55,500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Liabilities |
£150,000 |
£147,500 |
£145,000 |
£142,500 |
£140,000 |
£137,500 |
£135,000 |
£132,500 |
£130,000 |
£127,500 |
£125,000 |
£122,500 |
£120,000 |
| Total Liabilities |
£150,000 |
£215,828 |
£185,087 |
£198,697 |
£201,248 |
£192,886 |
£190,159 |
£188,283 |
£185,556 |
£183,042 |
£180,528 |
£178,014 |
£175,500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Paid-in Capital |
£60,000 |
£60,000 |
£60,000 |
£60,000 |
£60,000 |
£60,000 |
£60,000 |
£60,000 |
£60,000 |
£60,000 |
£60,000 |
£60,000 |
£60,000 |
| Retained Earnings |
(£101,500) |
(£101,500) |
(£101,500) |
(£101,500) |
(£101,500) |
(£101,500) |
(£101,500) |
(£101,500) |
(£101,500) |
(£101,500) |
(£101,500) |
(£101,500) |
(£101,500) |
| Earnings |
£0 |
(£736) |
(£407) |
£846 |
£3,444 |
£6,617 |
£9,804 |
£13,566 |
£17,342 |
£21,133 |
£24,938 |
£28,758 |
£32,593 |
| Total Capital |
(£41,500) |
(£42,236) |
(£41,907) |
(£40,654) |
(£38,056) |
(£34,883) |
(£31,696) |
(£27,934) |
(£24,158) |
(£20,367) |
(£16,562) |
(£12,742) |
(£8,907) |
| Total Liabilities and Capital |
£108,500 |
£173,592 |
£143,180 |
£158,043 |
£163,192 |
£158,002 |
£158,463 |
£160,348 |
£161,398 |
£162,675 |
£163,966 |
£165,272 |
£166,592 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Worth |
(£41,500) |
(£42,236) |
(£41,907) |
(£40,654) |
(£38,056) |
(£34,883) |
(£31,696) |
(£27,934) |
(£24,158) |
(£20,367) |
(£16,562) |
(£12,742) |
(£8,907) |
|