20% Discount on Business Plan Pro Premier Edition
Click here to buy now or call 0845 351 9924
 

Wi-Fi Kiosks Business Plan

Stroll Net

This sample business plan can be edited directly in Business Plan Pro software.

previous
next

Appendix

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
Walk-Up Internet Access 45% 900 1,125 1,406 1,758 2,197 2,747 3,433 4,292 5,364 6,706 8,382 10,477
Wireless WiFi Access 25% 426 533 666 832 1,040 1,300 1,625 2,031 2,539 3,174 3,967 4,959
Prepaid Products 18% 363 454 567 709 886 1,108 1,385 1,731 2,164 2,705 3,381 4,226
Multimedia Advertising 12% 108 135 169 211 264 330 412 515 644 805 1,006 1,257
Total Unit Sales 1,797 2,246 2,808 3,510 4,387 5,484 6,855 8,569 10,711 13,389 16,736 20,920
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
Walk-Up Internet Access £3.00 £3.00 £3.00 £3.00 £3.00 £3.00 £3.00 £3.00 £3.00 £3.00 £3.00 £3.00
Wireless WiFi Access £3.95 £3.95 £3.95 £3.95 £3.95 £3.95 £3.95 £3.95 £3.95 £3.95 £3.95 £3.95
Prepaid Products £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00
Multimedia Advertising £50.00 £50.00 £50.00 £50.00 £50.00 £50.00 £50.00 £50.00 £50.00 £50.00 £50.00 £50.00
Sales
Walk-Up Internet Access £2,700 £3,375 £4,219 £5,273 £6,592 £8,240 £10,300 £12,875 £16,093 £20,117 £25,146 £31,432
Wireless WiFi Access £1,683 £2,103 £2,629 £3,287 £4,108 £5,135 £6,419 £8,024 £10,030 £12,537 £15,671 £19,589
Prepaid Products £3,630 £4,538 £5,672 £7,090 £8,862 £11,078 £13,847 £17,309 £21,636 £27,046 £33,807 £42,259
Multimedia Advertising £5,400 £6,750 £8,438 £10,547 £13,184 £16,479 £20,599 £25,749 £32,187 £40,233 £50,291 £62,864
Total Sales £13,413 £16,766 £20,957 £26,197 £32,746 £40,932 £51,165 £63,957 £79,946 £99,932 £124,916 £156,144
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
Walk-Up Internet Access 20.00% £0.60 £0.60 £0.60 £0.60 £0.60 £0.60 £0.60 £0.60 £0.60 £0.60 £0.60 £0.60
Wireless WiFi Access 10.00% £0.40 £0.40 £0.40 £0.40 £0.40 £0.40 £0.40 £0.40 £0.40 £0.40 £0.40 £0.40
Prepaid Products 10.00% £1.00 £1.00 £1.00 £1.00 £1.00 £1.00 £1.00 £1.00 £1.00 £1.00 £1.00 £1.00
Multimedia Advertising 10.00% £5.00 £5.00 £5.00 £5.00 £5.00 £5.00 £5.00 £5.00 £5.00 £5.00 £5.00 £5.00
Direct Cost of Sales
Walk-Up Internet Access £540 £675 £844 £1,055 £1,318 £1,648 £2,060 £2,575 £3,219 £4,023 £5,029 £6,286
Wireless WiFi Access £168 £210 £263 £329 £411 £514 £642 £802 £1,003 £1,254 £1,567 £1,959
Prepaid Products £363 £454 £567 £709 £886 £1,108 £1,385 £1,731 £2,164 £2,705 £3,381 £4,226
Multimedia Advertising £540 £675 £844 £1,055 £1,318 £1,648 £2,060 £2,575 £3,219 £4,023 £5,029 £6,286
Subtotal Direct Cost of Sales £1,611 £2,014 £2,518 £3,147 £3,934 £4,917 £6,147 £7,683 £9,604 £12,005 £15,006 £18,758
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
Lorenzo Mitchell 0% £3,289 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600
Herman Albany 0% £3,289 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600
Technician 0% £2,160 £2,160 £2,160 £2,160 £2,160 £2,160 £2,160 £2,160 £2,160 £2,160 £2,160 £2,160
Route Drivers 0% £14,400 £14,400 £14,400 £14,400 £14,400 £14,400 £14,400 £14,400 £14,400 £14,400 £14,400 £14,400
Future Staff 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 11 11 11 11 11 11 11 11 11 11 11 11
Total Payroll £23,138 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760
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 11.50% 11.50% 11.50% 11.50% 11.50% 11.50% 11.50% 11.50% 11.50% 11.50% 11.50% 11.50%
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
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 £13,413 £16,766 £20,957 £26,197 £32,746 £40,932 £51,165 £63,957 £79,946 £99,932 £124,916 £156,144
Direct Cost of Sales £1,611 £2,014 £2,518 £3,147 £3,934 £4,917 £6,147 £7,683 £9,604 £12,005 £15,006 £18,758
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £1,611 £2,014 £2,518 £3,147 £3,934 £4,917 £6,147 £7,683 £9,604 £12,005 £15,006 £18,758
Gross Margin £11,801 £14,752 £18,440 £23,050 £28,812 £36,015 £45,019 £56,274 £70,342 £87,928 £109,909 £137,387
Gross Margin % 87.99% 87.99% 87.99% 87.99% 87.99% 87.99% 87.99% 87.99% 87.99% 87.99% 87.99% 87.99%
Expenses
Payroll £23,138 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760
Sales and Marketing and Other Expenses £4,467 £4,467 £4,467 £4,467 £4,467 £4,467 £4,467 £4,467 £4,467 £4,467 £4,467 £4,467
Depreciation £3,723 £3,723 £3,723 £3,723 £3,723 £3,723 £3,723 £3,723 £3,723 £3,723 £3,723 £3,723
Utilities £468 £468 £468 £468 £468 £468 £468 £468 £468 £468 £468 £468
Insurance £125 £125 £125 £125 £125 £125 £125 £125 £125 £125 £125 £125
Maintenence/Repairs £292 £292 £292 £292 £292 £292 £292 £292 £292 £292 £292 £292
Travel 15% £1,143 £1,143 £1,143 £1,143 £1,143 £1,143 £1,143 £1,143 £1,143 £1,143 £1,143 £1,143
Payroll Taxes 15% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £33,355 £33,977 £33,977 £33,977 £33,977 £33,977 £33,977 £33,977 £33,977 £33,977 £33,977 £33,977
Profit Before Interest and Taxes (£21,554) (£19,225) (£15,537) (£10,927) (£5,165) £2,038 £11,042 £22,297 £36,365 £53,951 £75,932 £103,410
EBITDA (£17,831) (£15,502) (£11,814) (£7,204) (£1,442) £5,761 £14,765 £26,020 £40,088 £57,674 £79,655 £107,133
Interest Expense £950 £942 £934 £926 £918 £910 £902 £894 £886 £879 £871 £863
Taxes Incurred (£5,626) (£5,042) (£4,118) (£2,963) (£1,521) £282 £2,535 £5,351 £8,870 £13,268 £18,765 £25,637
Net Profit (£16,878) (£15,126) (£12,354) (£8,890) (£4,563) £846 £7,605 £16,052 £26,609 £39,804 £56,296 £76,910
Net Profit/Sales -125.84% -90.22% -58.95% -33.94% -13.93% 2.07% 14.86% 25.10% 33.28% 39.83% 45.07% 49.26%
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 £13,413 £16,766 £20,957 £26,197 £32,746 £40,932 £51,165 £63,957 £79,946 £99,932 £124,916 £156,144
Subtotal Cash from Operations £13,413 £16,766 £20,957 £26,197 £32,746 £40,932 £51,165 £63,957 £79,946 £99,932 £124,916 £156,144
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 £13,413 £16,766 £20,957 £26,197 £32,746 £40,932 £51,165 £63,957 £79,946 £99,932 £124,916 £156,144
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 £23,138 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760
Bill Payments £2,614 £3,462 £4,456 £5,887 £7,678 £9,918 £12,719 £16,223 £20,603 £26,080 £32,928 £41,490
Subtotal Spent on Operations £25,752 £27,222 £28,216 £29,647 £31,438 £33,678 £36,479 £39,983 £44,363 £49,840 £56,688 £65,250
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 £833 £833 £833 £833 £833 £833 £833 £833 £833 £833 £833 £837
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 £26,585 £28,055 £29,049 £30,480 £32,271 £34,511 £37,312 £40,816 £45,196 £50,673 £57,521 £66,087
Net Cash Flow (£13,173) (£11,290) (£8,092) (£4,284) £475 £6,421 £13,853 £23,141 £34,750 £49,259 £67,394 £90,057
Cash Balance £46,827 £35,538 £27,446 £23,163 £23,637 £30,059 £43,912 £67,053 £101,803 £151,062 £218,456 £308,513
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 £60,000 £46,827 £35,538 £27,446 £23,163 £23,637 £30,059 £43,912 £67,053 £101,803 £151,062 £218,456 £308,513
Other Current Assets £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400
Total Current Assets £71,400 £58,227 £46,938 £38,846 £34,563 £35,037 £41,459 £55,312 £78,453 £113,203 £162,462 £229,856 £319,913
Long-term Assets
Long-term Assets £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810
Accumulated Depreciation £0 £3,723 £7,446 £11,169 £14,892 £18,615 £22,338 £26,061 £29,784 £33,507 £37,230 £40,953 £44,676
Total Long-term Assets £312,810 £309,087 £305,364 £301,641 £297,918 £294,195 £290,472 £286,749 £283,026 £279,303 £275,580 £271,857 £268,134
Total Assets £384,210 £367,314 £352,302 £340,487 £332,481 £329,232 £331,931 £342,061 £361,479 £392,506 £438,042 £501,713 £588,047
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 £2,500 £3,316 £4,262 £5,634 £7,351 £9,498 £12,183 £15,542 £19,741 £24,992 £31,557 £39,765 £50,026
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 £2,500 £3,316 £4,262 £5,634 £7,351 £9,498 £12,183 £15,542 £19,741 £24,992 £31,557 £39,765 £50,026
Long-term Liabilities £100,000 £99,167 £98,334 £97,501 £96,668 £95,835 £95,002 £94,169 £93,336 £92,503 £91,670 £90,837 £90,000
Total Liabilities £102,500 £102,483 £102,596 £103,135 £104,019 £105,333 £107,185 £109,711 £113,077 £117,495 £123,227 £130,602 £140,026
Paid-in Capital £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171
Retained Earnings (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461)
Earnings £0 (£16,878) (£32,004) (£44,358) (£53,248) (£57,810) (£56,965) (£49,360) (£33,308) (£6,700) £33,104 £89,401 £166,311
Total Capital £281,710 £264,832 £249,706 £237,352 £228,462 £223,900 £224,745 £232,350 £248,402 £275,010 £314,814 £371,111 £448,021
Total Liabilities and Capital £384,210 £367,314 £352,302 £340,487 £332,481 £329,232 £331,931 £342,061 £361,479 £392,506 £438,042 £501,713 £588,047
Net Worth £281,710 £264,832 £249,706 £237,352 £228,462 £223,900 £224,745 £232,350 £248,402 £275,010 £314,814 £371,111 £448,021
previous
next
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
Walk-Up Internet Access 45% 900 1,125 1,406 1,758 2,197 2,747 3,433 4,292 5,364 6,706 8,382 10,477
Wireless WiFi Access 25% 426 533 666 832 1,040 1,300 1,625 2,031 2,539 3,174 3,967 4,959
Prepaid Products 18% 363 454 567 709 886 1,108 1,385 1,731 2,164 2,705 3,381 4,226
Multimedia Advertising 12% 108 135 169 211 264 330 412 515 644 805 1,006 1,257
Total Unit Sales 1,797 2,246 2,808 3,510 4,387 5,484 6,855 8,569 10,711 13,389 16,736 20,920
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
Walk-Up Internet Access £3.00 £3.00 £3.00 £3.00 £3.00 £3.00 £3.00 £3.00 £3.00 £3.00 £3.00 £3.00
Wireless WiFi Access £3.95 £3.95 £3.95 £3.95 £3.95 £3.95 £3.95 £3.95 £3.95 £3.95 £3.95 £3.95
Prepaid Products £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00
Multimedia Advertising £50.00 £50.00 £50.00 £50.00 £50.00 £50.00 £50.00 £50.00 £50.00 £50.00 £50.00 £50.00
Sales
Walk-Up Internet Access £2,700 £3,375 £4,219 £5,273 £6,592 £8,240 £10,300 £12,875 £16,093 £20,117 £25,146 £31,432
Wireless WiFi Access £1,683 £2,103 £2,629 £3,287 £4,108 £5,135 £6,419 £8,024 £10,030 £12,537 £15,671 £19,589
Prepaid Products £3,630 £4,538 £5,672 £7,090 £8,862 £11,078 £13,847 £17,309 £21,636 £27,046 £33,807 £42,259
Multimedia Advertising £5,400 £6,750 £8,438 £10,547 £13,184 £16,479 £20,599 £25,749 £32,187 £40,233 £50,291 £62,864
Total Sales £13,413 £16,766 £20,957 £26,197 £32,746 £40,932 £51,165 £63,957 £79,946 £99,932 £124,916 £156,144
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
Walk-Up Internet Access 20.00% £0.60 £0.60 £0.60 £0.60 £0.60 £0.60 £0.60 £0.60 £0.60 £0.60 £0.60 £0.60
Wireless WiFi Access 10.00% £0.40 £0.40 £0.40 £0.40 £0.40 £0.40 £0.40 £0.40 £0.40 £0.40 £0.40 £0.40
Prepaid Products 10.00% £1.00 £1.00 £1.00 £1.00 £1.00 £1.00 £1.00 £1.00 £1.00 £1.00 £1.00 £1.00
Multimedia Advertising 10.00% £5.00 £5.00 £5.00 £5.00 £5.00 £5.00 £5.00 £5.00 £5.00 £5.00 £5.00 £5.00
Direct Cost of Sales
Walk-Up Internet Access £540 £675 £844 £1,055 £1,318 £1,648 £2,060 £2,575 £3,219 £4,023 £5,029 £6,286
Wireless WiFi Access £168 £210 £263 £329 £411 £514 £642 £802 £1,003 £1,254 £1,567 £1,959
Prepaid Products £363 £454 £567 £709 £886 £1,108 £1,385 £1,731 £2,164 £2,705 £3,381 £4,226
Multimedia Advertising £540 £675 £844 £1,055 £1,318 £1,648 £2,060 £2,575 £3,219 £4,023 £5,029 £6,286
Subtotal Direct Cost of Sales £1,611 £2,014 £2,518 £3,147 £3,934 £4,917 £6,147 £7,683 £9,604 £12,005 £15,006 £18,758
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
Lorenzo Mitchell 0% £3,289 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600
Herman Albany 0% £3,289 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600 £3,600
Technician 0% £2,160 £2,160 £2,160 £2,160 £2,160 £2,160 £2,160 £2,160 £2,160 £2,160 £2,160 £2,160
Route Drivers 0% £14,400 £14,400 £14,400 £14,400 £14,400 £14,400 £14,400 £14,400 £14,400 £14,400 £14,400 £14,400
Future Staff 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 11 11 11 11 11 11 11 11 11 11 11 11
Total Payroll £23,138 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760
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 11.50% 11.50% 11.50% 11.50% 11.50% 11.50% 11.50% 11.50% 11.50% 11.50% 11.50% 11.50%
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
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 £13,413 £16,766 £20,957 £26,197 £32,746 £40,932 £51,165 £63,957 £79,946 £99,932 £124,916 £156,144
Direct Cost of Sales £1,611 £2,014 £2,518 £3,147 £3,934 £4,917 £6,147 £7,683 £9,604 £12,005 £15,006 £18,758
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £1,611 £2,014 £2,518 £3,147 £3,934 £4,917 £6,147 £7,683 £9,604 £12,005 £15,006 £18,758
Gross Margin £11,801 £14,752 £18,440 £23,050 £28,812 £36,015 £45,019 £56,274 £70,342 £87,928 £109,909 £137,387
Gross Margin % 87.99% 87.99% 87.99% 87.99% 87.99% 87.99% 87.99% 87.99% 87.99% 87.99% 87.99% 87.99%
Expenses
Payroll £23,138 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760
Sales and Marketing and Other Expenses £4,467 £4,467 £4,467 £4,467 £4,467 £4,467 £4,467 £4,467 £4,467 £4,467 £4,467 £4,467
Depreciation £3,723 £3,723 £3,723 £3,723 £3,723 £3,723 £3,723 £3,723 £3,723 £3,723 £3,723 £3,723
Utilities £468 £468 £468 £468 £468 £468 £468 £468 £468 £468 £468 £468
Insurance £125 £125 £125 £125 £125 £125 £125 £125 £125 £125 £125 £125
Maintenence/Repairs £292 £292 £292 £292 £292 £292 £292 £292 £292 £292 £292 £292
Travel 15% £1,143 £1,143 £1,143 £1,143 £1,143 £1,143 £1,143 £1,143 £1,143 £1,143 £1,143 £1,143
Payroll Taxes 15% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Operating Expenses £33,355 £33,977 £33,977 £33,977 £33,977 £33,977 £33,977 £33,977 £33,977 £33,977 £33,977 £33,977
Profit Before Interest and Taxes (£21,554) (£19,225) (£15,537) (£10,927) (£5,165) £2,038 £11,042 £22,297 £36,365 £53,951 £75,932 £103,410
EBITDA (£17,831) (£15,502) (£11,814) (£7,204) (£1,442) £5,761 £14,765 £26,020 £40,088 £57,674 £79,655 £107,133
Interest Expense £950 £942 £934 £926 £918 £910 £902 £894 £886 £879 £871 £863
Taxes Incurred (£5,626) (£5,042) (£4,118) (£2,963) (£1,521) £282 £2,535 £5,351 £8,870 £13,268 £18,765 £25,637
Net Profit (£16,878) (£15,126) (£12,354) (£8,890) (£4,563) £846 £7,605 £16,052 £26,609 £39,804 £56,296 £76,910
Net Profit/Sales -125.84% -90.22% -58.95% -33.94% -13.93% 2.07% 14.86% 25.10% 33.28% 39.83% 45.07% 49.26%
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 £13,413 £16,766 £20,957 £26,197 £32,746 £40,932 £51,165 £63,957 £79,946 £99,932 £124,916 £156,144
Subtotal Cash from Operations £13,413 £16,766 £20,957 £26,197 £32,746 £40,932 £51,165 £63,957 £79,946 £99,932 £124,916 £156,144
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 £13,413 £16,766 £20,957 £26,197 £32,746 £40,932 £51,165 £63,957 £79,946 £99,932 £124,916 £156,144
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 £23,138 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760 £23,760
Bill Payments £2,614 £3,462 £4,456 £5,887 £7,678 £9,918 £12,719 £16,223 £20,603 £26,080 £32,928 £41,490
Subtotal Spent on Operations £25,752 £27,222 £28,216 £29,647 £31,438 £33,678 £36,479 £39,983 £44,363 £49,840 £56,688 £65,250
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 £833 £833 £833 £833 £833 £833 £833 £833 £833 £833 £833 £837
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 £26,585 £28,055 £29,049 £30,480 £32,271 £34,511 £37,312 £40,816 £45,196 £50,673 £57,521 £66,087
Net Cash Flow (£13,173) (£11,290) (£8,092) (£4,284) £475 £6,421 £13,853 £23,141 £34,750 £49,259 £67,394 £90,057
Cash Balance £46,827 £35,538 £27,446 £23,163 £23,637 £30,059 £43,912 £67,053 £101,803 £151,062 £218,456 £308,513
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 £60,000 £46,827 £35,538 £27,446 £23,163 £23,637 £30,059 £43,912 £67,053 £101,803 £151,062 £218,456 £308,513
Other Current Assets £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400 £11,400
Total Current Assets £71,400 £58,227 £46,938 £38,846 £34,563 £35,037 £41,459 £55,312 £78,453 £113,203 £162,462 £229,856 £319,913
Long-term Assets
Long-term Assets £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810 £312,810
Accumulated Depreciation £0 £3,723 £7,446 £11,169 £14,892 £18,615 £22,338 £26,061 £29,784 £33,507 £37,230 £40,953 £44,676
Total Long-term Assets £312,810 £309,087 £305,364 £301,641 £297,918 £294,195 £290,472 £286,749 £283,026 £279,303 £275,580 £271,857 £268,134
Total Assets £384,210 £367,314 £352,302 £340,487 £332,481 £329,232 £331,931 £342,061 £361,479 £392,506 £438,042 £501,713 £588,047
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 £2,500 £3,316 £4,262 £5,634 £7,351 £9,498 £12,183 £15,542 £19,741 £24,992 £31,557 £39,765 £50,026
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 £2,500 £3,316 £4,262 £5,634 £7,351 £9,498 £12,183 £15,542 £19,741 £24,992 £31,557 £39,765 £50,026
Long-term Liabilities £100,000 £99,167 £98,334 £97,501 £96,668 £95,835 £95,002 £94,169 £93,336 £92,503 £91,670 £90,837 £90,000
Total Liabilities £102,500 £102,483 £102,596 £103,135 £104,019 £105,333 £107,185 £109,711 £113,077 £117,495 £123,227 £130,602 £140,026
Paid-in Capital £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171 £310,171
Retained Earnings (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461) (£28,461)
Earnings £0 (£16,878) (£32,004) (£44,358) (£53,248) (£57,810) (£56,965) (£49,360) (£33,308) (£6,700) £33,104 £89,401 £166,311
Total Capital £281,710 £264,832 £249,706 £237,352 £228,462 £223,900 £224,745 £232,350 £248,402 £275,010 £314,814 £371,111 £448,021
Total Liabilities and Capital £384,210 £367,314 £352,302 £340,487 £332,481 £329,232 £331,931 £342,061 £361,479 £392,506 £438,042 £501,713 £588,047
Net Worth £281,710 £264,832 £249,706 £237,352 £228,462 £223,900 £224,745 £232,350 £248,402 £275,010 £314,814 £371,111 £448,021