Stroll Net

Start your own business plan »

Wi-Fi Kiosks Business Plan

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