| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Unit Sales | |||||||||||||
| Asphalt | 0% | 0 | 0 | 0 | 4,000 | 6,000 | 9,000 | 9,000 | 9,000 | 4,500 | 4,000 | 0 | 0 |
| Crusher Fines - for Asphalt | 0% | 0 | 0 | 0 | 1,600 | 2,400 | 3,600 | 3,600 | 3,600 | 1,800 | 1,600 | 0 | 0 |
| 3/4 in. ABC - for Asphalt | 0% | 0 | 0 | 0 | 1,600 | 2,400 | 3,600 | 3,600 | 3,600 | 1,800 | 1,600 | 0 | 0 |
| 1/2 in. Screened Rock - for Asphalt | 0% | 0 | 0 | 0 | 800 | 1,200 | 1,800 | 1,800 | 1,800 | 900 | 800 | 0 | 0 |
| 3 in. ABC | 0% | 1,000 | 1,300 | 1,500 | 2,000 | 2,000 | 2,500 | 3,500 | 3,000 | 2,500 | 2,000 | 1,500 | 1,000 |
| 3/4 in. ABC | 0% | 1,200 | 1,600 | 2,000 | 2,600 | 2,800 | 3,500 | 4,500 | 3,800 | 3,000 | 2,700 | 2,000 | 1,500 |
| Other Screened Rock | 0% | 300 | 500 | 700 | 800 | 800 | 1,000 | 1,000 | 1,500 | 1,300 | 1,100 | 500 | 500 |
| Sand | 0% | 100 | 300 | 500 | 1,000 | 1,000 | 1,500 | 1,500 | 2,000 | 1,500 | 500 | 300 | 300 |
| Cobble | 0% | 100 | 100 | 500 | 1,000 | 1,500 | 1,000 | 500 | 500 | 300 | 200 | 200 | 200 |
| Boulders | 0% | 50 | 100 | 150 | 200 | 250 | 250 | 250 | 250 | 250 | 200 | 100 | 50 |
| Topsoil | 0% | 0 | 0 | 200 | 700 | 1,000 | 1,500 | 1,500 | 500 | 500 | 300 | 200 | 100 |
| Other Dirt Products | 0% | 300 | 500 | 700 | 800 | 800 | 1,000 | 1,000 | 1,500 | 1,300 | 1,100 | 500 | 500 |
| Total Unit Sales | 3,050 | 4,400 | 6,250 | 17,100 | 22,150 | 30,250 | 31,750 | 31,050 | 19,650 | 16,100 | 5,300 | 4,150 | |
| Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Asphalt | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | |
| Crusher Fines - for Asphalt | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | |
| 3/4 in. ABC - for Asphalt | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | |
| 1/2 in. Screened Rock - for Asphalt | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | |
| 3 in. ABC | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | |
| 3/4 in. ABC | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | |
| Other Screened Rock | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | |
| Sand | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | |
| Cobble | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | |
| Boulders | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | |
| Topsoil | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | |
| Other Dirt Products | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | |
| Sales | |||||||||||||
| Asphalt | £0 | £0 | £0 | £144,000 | £216,000 | £324,000 | £324,000 | £324,000 | £162,000 | £144,000 | £0 | £0 | |
| Crusher Fines - for Asphalt | £0 | £0 | £0 | £16,800 | £25,200 | £37,800 | £37,800 | £37,800 | £18,900 | £16,800 | £0 | £0 | |
| 3/4 in. ABC - for Asphalt | £0 | £0 | £0 | £8,800 | £13,200 | £19,800 | £19,800 | £19,800 | £9,900 | £8,800 | £0 | £0 | |
| 1/2 in. Screened Rock - for Asphalt | £0 | £0 | £0 | £6,400 | £9,600 | £14,400 | £14,400 | £14,400 | £7,200 | £6,400 | £0 | £0 | |
| 3 in. ABC | £4,500 | £5,850 | £6,750 | £9,000 | £9,000 | £11,250 | £15,750 | £13,500 | £11,250 | £9,000 | £6,750 | £4,500 | |
| 3/4 in. ABC | £6,600 | £8,800 | £11,000 | £14,300 | £15,400 | £19,250 | £24,750 | £20,900 | £16,500 | £14,850 | £11,000 | £8,250 | |
| Other Screened Rock | £2,700 | £4,500 | £6,300 | £7,200 | £7,200 | £9,000 | £9,000 | £13,500 | £11,700 | £9,900 | £4,500 | £4,500 | |
| Sand | £1,000 | £3,000 | £5,000 | £10,000 | £10,000 | £15,000 | £15,000 | £20,000 | £15,000 | £5,000 | £3,000 | £3,000 | |
| Cobble | £1,300 | £1,300 | £6,500 | £13,000 | £19,500 | £13,000 | £6,500 | £6,500 | £3,900 | £2,600 | £2,600 | £2,600 | |
| Boulders | £450 | £900 | £1,350 | £1,800 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £1,800 | £900 | £450 | |
| Topsoil | £0 | £0 | £3,000 | £10,500 | £15,000 | £22,500 | £22,500 | £7,500 | £7,500 | £4,500 | £3,000 | £1,500 | |
| Other Dirt Products | £750 | £1,250 | £1,750 | £2,000 | £2,000 | £2,500 | £2,500 | £3,750 | £3,250 | £2,750 | £1,250 | £1,250 | |
| Total Sales | £17,300 | £25,600 | £41,650 | £243,800 | £344,350 | £490,750 | £494,250 | £483,900 | £269,350 | £226,400 | £33,000 | £26,050 | |
| Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Asphalt | 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 |
| Crusher Fines - for Asphalt | 0.00% | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 |
| 3/4 in. ABC - for Asphalt | 0.00% | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 |
| 1/2 in. Screened Rock - for Asphalt | 0.00% | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 |
| 3 in. ABC | 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 |
| 3/4 in. ABC | 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 |
| Other Screened Rock | 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 |
| Sand | 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 |
| Cobble | 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 |
| Boulders | 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 |
| Topsoil | 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 |
| Other Dirt Products | 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 | |||||||||||||
| Asphalt | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Crusher Fines - for Asphalt | £0 | £0 | £0 | £8,800 | £13,200 | £19,800 | £19,800 | £19,800 | £9,900 | £8,800 | £0 | £0 | |
| 3/4 in. ABC - for Asphalt | £0 | £0 | £0 | £16,800 | £25,200 | £37,800 | £37,800 | £37,800 | £18,900 | £16,800 | £0 | £0 | |
| 1/2 in. Screened Rock - for Asphalt | £0 | £0 | £0 | £6,400 | £9,600 | £14,400 | £14,400 | £14,400 | £7,200 | £6,400 | £0 | £0 | |
| 3 in. ABC | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 3/4 in. ABC | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Screened Rock | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sand | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cobble | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Boulders | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Topsoil | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Dirt Products | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £32,000 | £48,000 | £72,000 | £72,000 | £72,000 | £36,000 | £32,000 | £0 | £0 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Production Personnel | |||||||||||||
| Production Manager | £1,800 | £2,000 | £2,000 | £2,100 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | |
| Crusher 1 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Crusher 2 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Crusher 3 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Asphalt 1 | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £0 | £0 | |
| Asphalt 2 | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £0 | £0 | |
| Asphalt 3 | £0 | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £0 | £0 | £0 | |
| Asphalt Loader | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £0 | £0 | |
| Loader | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Subtotal | £9,200 | £9,400 | £9,400 | £14,900 | £16,900 | £16,900 | £16,900 | £16,900 | £16,900 | £15,100 | £9,700 | £9,700 | |
| Sales and Marketing Personnel | |||||||||||||
| Sales/Marketing 1 | £0 | £0 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £0 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | |
| General and Administrative Personnel | |||||||||||||
| Administrator | £2,000 | £2,000 | £2,500 | £2,000 | £2,000 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £2,000 | £2,000 | £2,500 | £2,000 | £2,000 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Other Personnel | |||||||||||||
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 6 | 6 | 7 | 10 | 11 | 11 | 11 | 11 | 11 | 10 | 9 | 9 | |
| Total Payroll | £11,200 | £11,400 | £14,000 | £19,000 | £21,000 | £21,500 | £21,500 | £21,500 | £21,500 | £19,700 | £14,300 | £14,300 | |
| General Assumptions | ||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Current Interest Rate | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.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 | 25.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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £17,300 | £25,600 | £41,650 | £243,800 | £344,350 | £490,750 | £494,250 | £483,900 | £269,350 | £226,400 | £33,000 | £26,050 | |
| Direct Cost of Sales | £0 | £0 | £0 | £32,000 | £48,000 | £72,000 | £72,000 | £72,000 | £36,000 | £32,000 | £0 | £0 | |
| Production Payroll | £9,200 | £9,400 | £9,400 | £14,900 | £16,900 | £16,900 | £16,900 | £16,900 | £16,900 | £15,100 | £9,700 | £9,700 | |
| Asphalt Plant Maintenance | £0 | £0 | £0 | £19,920 | £29,880 | £44,820 | £44,820 | £44,820 | £22,410 | £19,920 | £0 | £0 | |
| Asphalt By-Product Additives | £0 | £0 | £0 | £24,000 | £36,000 | £54,000 | £54,000 | £54,000 | £27,000 | £24,000 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £9,200 | £9,400 | £9,400 | £90,820 | £130,780 | £187,720 | £187,720 | £187,720 | £102,310 | £91,020 | £9,700 | £9,700 | |
| Gross Margin | £8,100 | £16,200 | £32,250 | £152,980 | £213,570 | £303,030 | £306,530 | £296,180 | £167,040 | £135,380 | £23,300 | £16,350 | |
| Gross Margin % | 46.82% | 63.28% | 77.43% | 62.75% | 62.02% | 61.75% | 62.02% | 61.21% | 62.02% | 59.80% | 70.61% | 62.76% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £0 | £0 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | |
| Advertising/Promotion | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Travel | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Miscellaneous | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Sales and Marketing Expenses | £800 | £800 | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | |
| Sales and Marketing % | 4.62% | 3.13% | 6.96% | 1.19% | 0.84% | 0.59% | 0.59% | 0.60% | 1.08% | 1.28% | 8.79% | 11.13% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £2,000 | £2,000 | £2,500 | £2,000 | £2,000 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Leased Equipment | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | |
| Equipment Expense | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Equipment Fuel | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Utilities | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Insurance | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Office Expense | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Miscellaneous | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Pit Lease | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Payroll Taxes | 15% | £1,680 | £1,710 | £2,100 | £2,850 | £3,150 | £3,225 | £3,225 | £3,225 | £3,225 | £2,955 | £2,145 | £2,145 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £34,830 | £34,860 | £35,750 | £36,000 | £36,300 | £36,875 | £36,875 | £36,875 | £36,875 | £36,605 | £35,795 | £35,795 | |
| General and Administrative % | 201.33% | 136.17% | 85.83% | 14.77% | 10.54% | 7.51% | 7.46% | 7.62% | 13.69% | 16.17% | 108.47% | 137.41% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Contract/Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Total Operating Expenses | £35,630 | £35,660 | £38,650 | £38,900 | £39,200 | £39,775 | £39,775 | £39,775 | £39,775 | £39,505 | £38,695 | £38,695 | |
| Profit Before Interest and Taxes | (£27,530) | (£19,460) | (£6,400) | £114,080 | £174,370 | £263,255 | £266,755 | £256,405 | £127,265 | £95,875 | (£15,395) | (£22,345) | |
| EBITDA | (£26,030) | (£17,960) | (£4,900) | £115,580 | £175,870 | £264,755 | £268,255 | £257,905 | £128,765 | £97,375 | (£13,895) | (£20,845) | |
| Interest Expense | £5,616 | £5,616 | £6,191 | £6,191 | £6,191 | £5,791 | £5,791 | £5,791 | £5,391 | £5,391 | £5,391 | £5,316 | |
| Taxes Incurred | (£8,287) | (£6,269) | (£3,148) | £26,972 | £42,045 | £64,366 | £65,241 | £62,653 | £30,468 | £22,621 | (£5,197) | (£6,915) | |
| Net Profit | (£24,860) | (£18,807) | (£9,443) | £80,917 | £126,134 | £193,098 | £195,723 | £187,960 | £91,405 | £67,863 | (£15,590) | (£20,746) | |
| Net Profit/Sales | -143.70% | -73.47% | -22.67% | 33.19% | 36.63% | 39.35% | 39.60% | 38.84% | 33.94% | 29.97% | -47.24% | -79.64% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £865 | £1,280 | £2,083 | £12,190 | £17,218 | £24,538 | £24,713 | £24,195 | £13,468 | £11,320 | £1,650 | £1,303 | |
| Cash from Receivables | £41,677 | £42,225 | £16,698 | £24,828 | £45,969 | £234,794 | £331,769 | £466,323 | £469,210 | £452,911 | £254,522 | £208,956 | |
| Subtotal Cash from Operations | £42,542 | £43,505 | £18,780 | £37,018 | £63,186 | £259,332 | £356,481 | £490,518 | £482,677 | £464,231 | £256,172 | £210,258 | |
| 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 | £60,000 | £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 | £50,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £42,542 | £43,505 | £78,780 | £37,018 | £113,186 | £259,332 | £356,481 | £490,518 | £482,677 | £464,231 | £256,172 | £210,258 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £11,200 | £11,400 | £14,000 | £19,000 | £21,000 | £21,500 | £21,500 | £21,500 | £21,500 | £19,700 | £14,300 | £14,300 | |
| Bill Payments | £19,870 | £29,528 | £31,643 | £38,086 | £111,628 | £149,547 | £202,681 | £203,441 | £198,206 | £118,491 | £102,919 | £32,730 | |
| Subtotal Spent on Operations | £31,070 | £40,928 | £45,643 | £57,086 | £132,628 | £171,047 | £224,181 | £224,941 | £219,706 | £138,191 | £117,219 | £47,030 | |
| 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 | £30,000 | £0 | £0 | £30,000 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £9,000 | £0 | £0 | £9,000 | £0 | £0 | £9,000 | £0 | £0 | £9,000 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £31,070 | £40,928 | £54,643 | £57,086 | £132,628 | £210,047 | £224,181 | £224,941 | £258,706 | £138,191 | £117,219 | £56,030 | |
| Net Cash Flow | £11,472 | £2,577 | £24,137 | (£20,068) | (£19,441) | £49,285 | £132,300 | £265,577 | £223,971 | £326,040 | £138,954 | £154,228 | |
| Cash Balance | £12,851 | £15,428 | £39,565 | £19,497 | £56 | £49,340 | £181,640 | £447,217 | £671,188 | £997,228 | £1,136,182 | £1,290,410 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £1,379 | £12,851 | £15,428 | £39,565 | £19,497 | £56 | £49,340 | £181,640 | £447,217 | £671,188 | £997,228 | £1,136,182 | £1,290,410 |
| Accounts Receivable | £83,354 | £58,112 | £40,207 | £63,077 | £269,859 | £551,022 | £782,441 | £920,210 | £913,591 | £700,264 | £462,433 | £239,261 | £55,052 |
| Inventory | £657,640 | £657,640 | £657,640 | £657,640 | £625,640 | £577,640 | £505,640 | £433,640 | £361,640 | £325,640 | £293,640 | £293,640 | £293,640 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £742,373 | £728,603 | £713,275 | £760,282 | £914,996 | £1,128,718 | £1,337,421 | £1,535,489 | £1,722,449 | £1,697,092 | £1,753,301 | £1,669,082 | £1,639,102 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 |
| Accumulated Depreciation | £0 | £1,500 | £3,000 | £4,500 | £6,000 | £7,500 | £9,000 | £10,500 | £12,000 | £13,500 | £15,000 | £16,500 | £18,000 |
| Total Long-term Assets | £1,056,350 | £1,054,850 | £1,053,350 | £1,051,850 | £1,050,350 | £1,048,850 | £1,047,350 | £1,045,850 | £1,044,350 | £1,042,850 | £1,041,350 | £1,039,850 | £1,038,350 |
| Total Assets | £1,798,723 | £1,783,453 | £1,766,625 | £1,812,132 | £1,965,346 | £2,177,568 | £2,384,771 | £2,581,339 | £2,766,799 | £2,739,942 | £2,794,651 | £2,708,932 | £2,677,452 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £18,888 | £28,478 | £30,457 | £34,407 | £106,704 | £142,792 | £195,897 | £196,743 | £194,242 | £114,980 | £101,826 | £31,697 | £29,963 |
| Current Borrowing | £0 | £0 | £0 | £60,000 | £60,000 | £60,000 | £30,000 | £30,000 | £30,000 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 |
| Subtotal Current Liabilities | £29,723 | £39,313 | £41,292 | £105,242 | £177,539 | £213,627 | £236,732 | £237,578 | £235,077 | £125,815 | £112,661 | £42,532 | £40,798 |
| Long-term Liabilities | £673,936 | £673,936 | £673,936 | £664,936 | £664,936 | £664,936 | £655,936 | £655,936 | £655,936 | £646,936 | £646,936 | £646,936 | £637,936 |
| Total Liabilities | £703,659 | £713,249 | £715,228 | £770,178 | £842,475 | £878,563 | £892,668 | £893,514 | £891,013 | £772,751 | £759,597 | £689,468 | £678,734 |
| Paid-in Capital | £1,084,896 | £1,084,896 | £1,084,896 | £1,084,896 | £1,084,896 | £1,134,896 | £1,134,896 | £1,134,896 | £1,134,896 | £1,134,896 | £1,134,896 | £1,134,896 | £1,134,896 |
| Retained Earnings | £5,084 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 |
| Earnings | £5,084 | (£24,860) | (£43,667) | (£53,110) | £27,807 | £153,941 | £347,039 | £542,762 | £730,722 | £822,127 | £889,990 | £874,401 | £853,655 |
| Total Capital | £1,095,064 | £1,070,204 | £1,051,397 | £1,041,954 | £1,122,871 | £1,299,005 | £1,492,103 | £1,687,826 | £1,875,786 | £1,967,191 | £2,035,054 | £2,019,465 | £1,998,719 |
| Total Liabilities and Capital | £1,798,723 | £1,783,453 | £1,766,625 | £1,812,132 | £1,965,346 | £2,177,568 | £2,384,771 | £2,581,339 | £2,766,799 | £2,739,942 | £2,794,651 | £2,708,932 | £2,677,452 |
| Net Worth | £1,095,064 | £1,070,204 | £1,051,397 | £1,041,954 | £1,122,871 | £1,299,005 | £1,492,103 | £1,687,826 | £1,875,786 | £1,967,191 | £2,035,054 | £2,019,465 | £1,998,719 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Unit Sales | |||||||||||||
| Asphalt | 0% | 0 | 0 | 0 | 4,000 | 6,000 | 9,000 | 9,000 | 9,000 | 4,500 | 4,000 | 0 | 0 |
| Crusher Fines - for Asphalt | 0% | 0 | 0 | 0 | 1,600 | 2,400 | 3,600 | 3,600 | 3,600 | 1,800 | 1,600 | 0 | 0 |
| 3/4 in. ABC - for Asphalt | 0% | 0 | 0 | 0 | 1,600 | 2,400 | 3,600 | 3,600 | 3,600 | 1,800 | 1,600 | 0 | 0 |
| 1/2 in. Screened Rock - for Asphalt | 0% | 0 | 0 | 0 | 800 | 1,200 | 1,800 | 1,800 | 1,800 | 900 | 800 | 0 | 0 |
| 3 in. ABC | 0% | 1,000 | 1,300 | 1,500 | 2,000 | 2,000 | 2,500 | 3,500 | 3,000 | 2,500 | 2,000 | 1,500 | 1,000 |
| 3/4 in. ABC | 0% | 1,200 | 1,600 | 2,000 | 2,600 | 2,800 | 3,500 | 4,500 | 3,800 | 3,000 | 2,700 | 2,000 | 1,500 |
| Other Screened Rock | 0% | 300 | 500 | 700 | 800 | 800 | 1,000 | 1,000 | 1,500 | 1,300 | 1,100 | 500 | 500 |
| Sand | 0% | 100 | 300 | 500 | 1,000 | 1,000 | 1,500 | 1,500 | 2,000 | 1,500 | 500 | 300 | 300 |
| Cobble | 0% | 100 | 100 | 500 | 1,000 | 1,500 | 1,000 | 500 | 500 | 300 | 200 | 200 | 200 |
| Boulders | 0% | 50 | 100 | 150 | 200 | 250 | 250 | 250 | 250 | 250 | 200 | 100 | 50 |
| Topsoil | 0% | 0 | 0 | 200 | 700 | 1,000 | 1,500 | 1,500 | 500 | 500 | 300 | 200 | 100 |
| Other Dirt Products | 0% | 300 | 500 | 700 | 800 | 800 | 1,000 | 1,000 | 1,500 | 1,300 | 1,100 | 500 | 500 |
| Total Unit Sales | 3,050 | 4,400 | 6,250 | 17,100 | 22,150 | 30,250 | 31,750 | 31,050 | 19,650 | 16,100 | 5,300 | 4,150 | |
| Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Asphalt | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | £36.00 | |
| Crusher Fines - for Asphalt | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | |
| 3/4 in. ABC - for Asphalt | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | |
| 1/2 in. Screened Rock - for Asphalt | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | |
| 3 in. ABC | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | |
| 3/4 in. ABC | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | |
| Other Screened Rock | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | |
| Sand | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | £10.00 | |
| Cobble | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | £13.00 | |
| Boulders | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | £9.00 | |
| Topsoil | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | |
| Other Dirt Products | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | £2.50 | |
| Sales | |||||||||||||
| Asphalt | £0 | £0 | £0 | £144,000 | £216,000 | £324,000 | £324,000 | £324,000 | £162,000 | £144,000 | £0 | £0 | |
| Crusher Fines - for Asphalt | £0 | £0 | £0 | £16,800 | £25,200 | £37,800 | £37,800 | £37,800 | £18,900 | £16,800 | £0 | £0 | |
| 3/4 in. ABC - for Asphalt | £0 | £0 | £0 | £8,800 | £13,200 | £19,800 | £19,800 | £19,800 | £9,900 | £8,800 | £0 | £0 | |
| 1/2 in. Screened Rock - for Asphalt | £0 | £0 | £0 | £6,400 | £9,600 | £14,400 | £14,400 | £14,400 | £7,200 | £6,400 | £0 | £0 | |
| 3 in. ABC | £4,500 | £5,850 | £6,750 | £9,000 | £9,000 | £11,250 | £15,750 | £13,500 | £11,250 | £9,000 | £6,750 | £4,500 | |
| 3/4 in. ABC | £6,600 | £8,800 | £11,000 | £14,300 | £15,400 | £19,250 | £24,750 | £20,900 | £16,500 | £14,850 | £11,000 | £8,250 | |
| Other Screened Rock | £2,700 | £4,500 | £6,300 | £7,200 | £7,200 | £9,000 | £9,000 | £13,500 | £11,700 | £9,900 | £4,500 | £4,500 | |
| Sand | £1,000 | £3,000 | £5,000 | £10,000 | £10,000 | £15,000 | £15,000 | £20,000 | £15,000 | £5,000 | £3,000 | £3,000 | |
| Cobble | £1,300 | £1,300 | £6,500 | £13,000 | £19,500 | £13,000 | £6,500 | £6,500 | £3,900 | £2,600 | £2,600 | £2,600 | |
| Boulders | £450 | £900 | £1,350 | £1,800 | £2,250 | £2,250 | £2,250 | £2,250 | £2,250 | £1,800 | £900 | £450 | |
| Topsoil | £0 | £0 | £3,000 | £10,500 | £15,000 | £22,500 | £22,500 | £7,500 | £7,500 | £4,500 | £3,000 | £1,500 | |
| Other Dirt Products | £750 | £1,250 | £1,750 | £2,000 | £2,000 | £2,500 | £2,500 | £3,750 | £3,250 | £2,750 | £1,250 | £1,250 | |
| Total Sales | £17,300 | £25,600 | £41,650 | £243,800 | £344,350 | £490,750 | £494,250 | £483,900 | £269,350 | £226,400 | £33,000 | £26,050 | |
| Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Asphalt | 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 |
| Crusher Fines - for Asphalt | 0.00% | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 | £5.50 |
| 3/4 in. ABC - for Asphalt | 0.00% | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 |
| 1/2 in. Screened Rock - for Asphalt | 0.00% | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 |
| 3 in. ABC | 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 |
| 3/4 in. ABC | 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 |
| Other Screened Rock | 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 |
| Sand | 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 |
| Cobble | 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 |
| Boulders | 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 |
| Topsoil | 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 |
| Other Dirt Products | 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 | |||||||||||||
| Asphalt | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Crusher Fines - for Asphalt | £0 | £0 | £0 | £8,800 | £13,200 | £19,800 | £19,800 | £19,800 | £9,900 | £8,800 | £0 | £0 | |
| 3/4 in. ABC - for Asphalt | £0 | £0 | £0 | £16,800 | £25,200 | £37,800 | £37,800 | £37,800 | £18,900 | £16,800 | £0 | £0 | |
| 1/2 in. Screened Rock - for Asphalt | £0 | £0 | £0 | £6,400 | £9,600 | £14,400 | £14,400 | £14,400 | £7,200 | £6,400 | £0 | £0 | |
| 3 in. ABC | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 3/4 in. ABC | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Screened Rock | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sand | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cobble | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Boulders | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Topsoil | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Dirt Products | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £32,000 | £48,000 | £72,000 | £72,000 | £72,000 | £36,000 | £32,000 | £0 | £0 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Production Personnel | |||||||||||||
| Production Manager | £1,800 | £2,000 | £2,000 | £2,100 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | £2,300 | |
| Crusher 1 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Crusher 2 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Crusher 3 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Asphalt 1 | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £0 | £0 | |
| Asphalt 2 | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £0 | £0 | |
| Asphalt 3 | £0 | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £0 | £0 | £0 | |
| Asphalt Loader | £0 | £0 | £0 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £0 | £0 | |
| Loader | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Subtotal | £9,200 | £9,400 | £9,400 | £14,900 | £16,900 | £16,900 | £16,900 | £16,900 | £16,900 | £15,100 | £9,700 | £9,700 | |
| Sales and Marketing Personnel | |||||||||||||
| Sales/Marketing 1 | £0 | £0 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £0 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | |
| General and Administrative Personnel | |||||||||||||
| Administrator | £2,000 | £2,000 | £2,500 | £2,000 | £2,000 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £2,000 | £2,000 | £2,500 | £2,000 | £2,000 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Other Personnel | |||||||||||||
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 6 | 6 | 7 | 10 | 11 | 11 | 11 | 11 | 11 | 10 | 9 | 9 | |
| Total Payroll | £11,200 | £11,400 | £14,000 | £19,000 | £21,000 | £21,500 | £21,500 | £21,500 | £21,500 | £19,700 | £14,300 | £14,300 | |
| General Assumptions | ||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Current Interest Rate | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.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 | 25.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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £17,300 | £25,600 | £41,650 | £243,800 | £344,350 | £490,750 | £494,250 | £483,900 | £269,350 | £226,400 | £33,000 | £26,050 | |
| Direct Cost of Sales | £0 | £0 | £0 | £32,000 | £48,000 | £72,000 | £72,000 | £72,000 | £36,000 | £32,000 | £0 | £0 | |
| Production Payroll | £9,200 | £9,400 | £9,400 | £14,900 | £16,900 | £16,900 | £16,900 | £16,900 | £16,900 | £15,100 | £9,700 | £9,700 | |
| Asphalt Plant Maintenance | £0 | £0 | £0 | £19,920 | £29,880 | £44,820 | £44,820 | £44,820 | £22,410 | £19,920 | £0 | £0 | |
| Asphalt By-Product Additives | £0 | £0 | £0 | £24,000 | £36,000 | £54,000 | £54,000 | £54,000 | £27,000 | £24,000 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £9,200 | £9,400 | £9,400 | £90,820 | £130,780 | £187,720 | £187,720 | £187,720 | £102,310 | £91,020 | £9,700 | £9,700 | |
| Gross Margin | £8,100 | £16,200 | £32,250 | £152,980 | £213,570 | £303,030 | £306,530 | £296,180 | £167,040 | £135,380 | £23,300 | £16,350 | |
| Gross Margin % | 46.82% | 63.28% | 77.43% | 62.75% | 62.02% | 61.75% | 62.02% | 61.21% | 62.02% | 59.80% | 70.61% | 62.76% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £0 | £0 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | £2,100 | |
| Advertising/Promotion | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Travel | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Miscellaneous | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Total Sales and Marketing Expenses | £800 | £800 | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | £2,900 | |
| Sales and Marketing % | 4.62% | 3.13% | 6.96% | 1.19% | 0.84% | 0.59% | 0.59% | 0.60% | 1.08% | 1.28% | 8.79% | 11.13% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £2,000 | £2,000 | £2,500 | £2,000 | £2,000 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Leased Equipment | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | |
| Equipment Expense | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Equipment Fuel | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Utilities | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Insurance | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Office Expense | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Miscellaneous | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Pit Lease | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | |
| Payroll Taxes | 15% | £1,680 | £1,710 | £2,100 | £2,850 | £3,150 | £3,225 | £3,225 | £3,225 | £3,225 | £2,955 | £2,145 | £2,145 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £34,830 | £34,860 | £35,750 | £36,000 | £36,300 | £36,875 | £36,875 | £36,875 | £36,875 | £36,605 | £35,795 | £35,795 | |
| General and Administrative % | 201.33% | 136.17% | 85.83% | 14.77% | 10.54% | 7.51% | 7.46% | 7.62% | 13.69% | 16.17% | 108.47% | 137.41% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Contract/Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Total Operating Expenses | £35,630 | £35,660 | £38,650 | £38,900 | £39,200 | £39,775 | £39,775 | £39,775 | £39,775 | £39,505 | £38,695 | £38,695 | |
| Profit Before Interest and Taxes | (£27,530) | (£19,460) | (£6,400) | £114,080 | £174,370 | £263,255 | £266,755 | £256,405 | £127,265 | £95,875 | (£15,395) | (£22,345) | |
| EBITDA | (£26,030) | (£17,960) | (£4,900) | £115,580 | £175,870 | £264,755 | £268,255 | £257,905 | £128,765 | £97,375 | (£13,895) | (£20,845) | |
| Interest Expense | £5,616 | £5,616 | £6,191 | £6,191 | £6,191 | £5,791 | £5,791 | £5,791 | £5,391 | £5,391 | £5,391 | £5,316 | |
| Taxes Incurred | (£8,287) | (£6,269) | (£3,148) | £26,972 | £42,045 | £64,366 | £65,241 | £62,653 | £30,468 | £22,621 | (£5,197) | (£6,915) | |
| Net Profit | (£24,860) | (£18,807) | (£9,443) | £80,917 | £126,134 | £193,098 | £195,723 | £187,960 | £91,405 | £67,863 | (£15,590) | (£20,746) | |
| Net Profit/Sales | -143.70% | -73.47% | -22.67% | 33.19% | 36.63% | 39.35% | 39.60% | 38.84% | 33.94% | 29.97% | -47.24% | -79.64% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £865 | £1,280 | £2,083 | £12,190 | £17,218 | £24,538 | £24,713 | £24,195 | £13,468 | £11,320 | £1,650 | £1,303 | |
| Cash from Receivables | £41,677 | £42,225 | £16,698 | £24,828 | £45,969 | £234,794 | £331,769 | £466,323 | £469,210 | £452,911 | £254,522 | £208,956 | |
| Subtotal Cash from Operations | £42,542 | £43,505 | £18,780 | £37,018 | £63,186 | £259,332 | £356,481 | £490,518 | £482,677 | £464,231 | £256,172 | £210,258 | |
| 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 | £60,000 | £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 | £50,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £42,542 | £43,505 | £78,780 | £37,018 | £113,186 | £259,332 | £356,481 | £490,518 | £482,677 | £464,231 | £256,172 | £210,258 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £11,200 | £11,400 | £14,000 | £19,000 | £21,000 | £21,500 | £21,500 | £21,500 | £21,500 | £19,700 | £14,300 | £14,300 | |
| Bill Payments | £19,870 | £29,528 | £31,643 | £38,086 | £111,628 | £149,547 | £202,681 | £203,441 | £198,206 | £118,491 | £102,919 | £32,730 | |
| Subtotal Spent on Operations | £31,070 | £40,928 | £45,643 | £57,086 | £132,628 | £171,047 | £224,181 | £224,941 | £219,706 | £138,191 | £117,219 | £47,030 | |
| 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 | £30,000 | £0 | £0 | £30,000 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £9,000 | £0 | £0 | £9,000 | £0 | £0 | £9,000 | £0 | £0 | £9,000 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £31,070 | £40,928 | £54,643 | £57,086 | £132,628 | £210,047 | £224,181 | £224,941 | £258,706 | £138,191 | £117,219 | £56,030 | |
| Net Cash Flow | £11,472 | £2,577 | £24,137 | (£20,068) | (£19,441) | £49,285 | £132,300 | £265,577 | £223,971 | £326,040 | £138,954 | £154,228 | |
| Cash Balance | £12,851 | £15,428 | £39,565 | £19,497 | £56 | £49,340 | £181,640 | £447,217 | £671,188 | £997,228 | £1,136,182 | £1,290,410 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £1,379 | £12,851 | £15,428 | £39,565 | £19,497 | £56 | £49,340 | £181,640 | £447,217 | £671,188 | £997,228 | £1,136,182 | £1,290,410 |
| Accounts Receivable | £83,354 | £58,112 | £40,207 | £63,077 | £269,859 | £551,022 | £782,441 | £920,210 | £913,591 | £700,264 | £462,433 | £239,261 | £55,052 |
| Inventory | £657,640 | £657,640 | £657,640 | £657,640 | £625,640 | £577,640 | £505,640 | £433,640 | £361,640 | £325,640 | £293,640 | £293,640 | £293,640 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £742,373 | £728,603 | £713,275 | £760,282 | £914,996 | £1,128,718 | £1,337,421 | £1,535,489 | £1,722,449 | £1,697,092 | £1,753,301 | £1,669,082 | £1,639,102 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 | £1,056,350 |
| Accumulated Depreciation | £0 | £1,500 | £3,000 | £4,500 | £6,000 | £7,500 | £9,000 | £10,500 | £12,000 | £13,500 | £15,000 | £16,500 | £18,000 |
| Total Long-term Assets | £1,056,350 | £1,054,850 | £1,053,350 | £1,051,850 | £1,050,350 | £1,048,850 | £1,047,350 | £1,045,850 | £1,044,350 | £1,042,850 | £1,041,350 | £1,039,850 | £1,038,350 |
| Total Assets | £1,798,723 | £1,783,453 | £1,766,625 | £1,812,132 | £1,965,346 | £2,177,568 | £2,384,771 | £2,581,339 | £2,766,799 | £2,739,942 | £2,794,651 | £2,708,932 | £2,677,452 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £18,888 | £28,478 | £30,457 | £34,407 | £106,704 | £142,792 | £195,897 | £196,743 | £194,242 | £114,980 | £101,826 | £31,697 | £29,963 |
| Current Borrowing | £0 | £0 | £0 | £60,000 | £60,000 | £60,000 | £30,000 | £30,000 | £30,000 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 | £10,835 |
| Subtotal Current Liabilities | £29,723 | £39,313 | £41,292 | £105,242 | £177,539 | £213,627 | £236,732 | £237,578 | £235,077 | £125,815 | £112,661 | £42,532 | £40,798 |
| Long-term Liabilities | £673,936 | £673,936 | £673,936 | £664,936 | £664,936 | £664,936 | £655,936 | £655,936 | £655,936 | £646,936 | £646,936 | £646,936 | £637,936 |
| Total Liabilities | £703,659 | £713,249 | £715,228 | £770,178 | £842,475 | £878,563 | £892,668 | £893,514 | £891,013 | £772,751 | £759,597 | £689,468 | £678,734 |
| Paid-in Capital | £1,084,896 | £1,084,896 | £1,084,896 | £1,084,896 | £1,084,896 | £1,134,896 | £1,134,896 | £1,134,896 | £1,134,896 | £1,134,896 | £1,134,896 | £1,134,896 | £1,134,896 |
| Retained Earnings | £5,084 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 | £10,168 |
| Earnings | £5,084 | (£24,860) | (£43,667) | (£53,110) | £27,807 | £153,941 | £347,039 | £542,762 | £730,722 | £822,127 | £889,990 | £874,401 | £853,655 |
| Total Capital | £1,095,064 | £1,070,204 | £1,051,397 | £1,041,954 | £1,122,871 | £1,299,005 | £1,492,103 | £1,687,826 | £1,875,786 | £1,967,191 | £2,035,054 | £2,019,465 | £1,998,719 |
| Total Liabilities and Capital | £1,798,723 | £1,783,453 | £1,766,625 | £1,812,132 | £1,965,346 | £2,177,568 | £2,384,771 | £2,581,339 | £2,766,799 | £2,739,942 | £2,794,651 | £2,708,932 | £2,677,452 |
| Net Worth | £1,095,064 | £1,070,204 | £1,051,397 | £1,041,954 | £1,122,871 | £1,299,005 | £1,492,103 | £1,687,826 | £1,875,786 | £1,967,191 | £2,035,054 | £2,019,465 | £1,998,719 |