Make it your own. Use Business Plan Pro to edit this plan or any of 500+ other sample plans.
Edit This Plan

Did you know?

Business Plan Pro Table Wizards guide you step by step through the financials to produce solid numbers, charts and tables that are preferred by banks, lenders and the SBA. It even does the math for you, just plug in your numbers and the software will do the rest.

 

Inside Tip:

Business Plan Pro Table Wizards guide you step by step through then financials to produce solid numbers, charts and tables that are preferred by banks, lenders, and the SBA. It even does the math for you, just plug in your numbers and the software will do the rest!

Get the right numbers

Get the important numbers right with Business Plan Pro's powerful tools:

Create a foundation. Automatically generate cash-flow projections with the Start-up Wizard.

Make realistic forecasts. Use the break-even analysis tool to help you understand when you'll break even and when you'll start making money.

Plan for growth. The forecaster tool automatically creates tables, charts and reports that show how your business will grow.

Proceed with confidence. The Plan Review Wizard checks all your data twice to guarantee a flawless plan.

Learn More

 

Internet Cafe Business Plan

JavaNet Internet Cafe

This business plan was created with Business Plan Pro software, the fastest way to prepare a complete business plan.

With Business Plan Pro, you can open this plan (or any of the 500 others included in the product) and quickly customize it to match your business. Or you can use the software's step-by-step wizard to easily create a custom business plan from scratch. Learn more »

previous
Next

Financial Plan


7.0 Financial Plan

Sales: JavaNet is basing their projected coffee and espresso sales on the financial snapshot information provided to them by Allann Bros. Coffee Co. Internet sales were estimated by calculating the total number of hours each terminal will be active each day and then generating a conservative estimate as to how many hours will be purchased by consumers.

Cost of Goods Sold: The cost of goods sold for coffee-related products was determined by the "retail profit analysis" we obtained from Allann Bros. Coffee Co. The cost of bakery items is 20% of the selling price. The cost of Internet access is $660 per month, paid to Bellevue Computers for networking fees. The cost of e-mail accounts is 25% of the selling price.

Fixture Costs: Fixture costs associated with starting JavaNet are the following: 11 computers = $22,000, two printers = $1,000, one scanner = $500, one espresso machine = $10,700, one automatic espresso grinder = $795, two coffee/food preparation counters = $1,000, one information display counter = $1,000, one drinking/eating counter = $500, sixteen stools = $1,600, six computer desks w/chairs = $2,400, stationery goods = $500, two telephones = $200, decoration expense = $14,110 for a total fixture cost of $50,000.

Salaries Expense: The founder of JavaNet, Cale Bruckner, will receive a salary of $24,000 in year one, $26,400 in year two, and $29,040 in year three.

Payroll Expense: JavaNet intends to hire six part-time employees at $5.75/hour and a full-time technician at $10.00/hour. The total cost of employing seven people at these rates for the first year is $7,240/month.

Rent Expense: JavaNet is leasing a 1700 square foot facility at $.85/sq. foot. The lease agreement JavaNet signed specifies that we pay $2,000/month for a total of 36 months. At the end of the third year, the lease is open for negotiations and JavaNet may or may not re-sign the lease depending on the demands of the lessor.

Utilities Expense: As stated in the contract, the lessor is responsible for the payment of utilities including gas, garbage disposal, and real estate taxes. The only utilities expense that JavaNet must pay is the phone bill generated by fifteen phone lines; thirteen will be dedicated to modems and two for business purposes. The basic monthly service charge for each line provided by US West is $17.29. The 13 lines used to connect the modems will make local calls to the network provided by Bellevue resulting in a monthly charge of $224.77. The two additional lines used for business communication will cost $34.58/month plus long distance fees. JavaNet assumes that it will not make more than $40.00/month in long distance calls. Therefore, the total cost associated with the two business lines is estimated at $74.58/month and the total phone expense at $299.35/month. In addition, there will be an additional utility expense of $800 for estimated EWEB bills.

Marketing Expense: JavaNet will allocate $5,000 for promotional expenses at the time of start-up. These dollars will be used for advertising in local newspapers in order to build consumer awareness. For additional information, please refer to section 5.0 of the business plan.

Insurance Expense: JavaNet has allocated $1,440 for insurance for the first year. As revenue increases in the second and third year of business, JavaNet intends to invest more money for additional insurance coverage.

Legal and Consulting Fees: The cost of obtaining legal consultation in order to draw up the paper work necessary for an LLC is $1,000.

Depreciation: In depreciating our capital equipment, JavaNet used the Modified Accelerated Cost Recovery Method. We depreciated our computers over a five-year time period and our fixtures over seven years.

Taxes: JavaNet is an LLC and, as an entity, it is not taxed. However, there is a 15% payroll burden.

Accounts Payable: JavaNet acquired a $24,000 loan from a bank at a 10% interest rate. The loan will be paid back at $750/month over the next three years. The $9,290 short term loan will be paid back at a rate of 8%.


7.1 Start-up Funding

This business plan is prepared to obtain financing in the amount of $24,000. The supplemental financing is required to begin work on site preparation and modifications, equipment purchases, and to cover expenses in the first year of operations. Additional financing has already been secured in the form of: (1) $24,000 from the Oregon Economic Development Fund (2) $19,000 of personal savings from owner Cale Bruckner (3) $36,000 from three investors (4) and $9,290 in the form of short-term loans.


Start-up Funding
Start-up Funding
Start-up Expenses to Fund$62,290
Start-up Assets to Fund$26,000
Total Funding Required$88,290
Assets
Non-cash Assets from Start-up$2,000
Cash Requirements from Start-up$24,000
Additional Cash Raised$0
Cash Balance on Starting Date$24,000
Total Assets$26,000
Liabilities and Capital
Liabilities
Current Borrowing$9,290
Long-term Liabilities$24,000
Accounts Payable (Outstanding Bills)$0
Other Current Liabilities (interest-free)$0
Total Liabilities$33,290
Capital
Planned Investment
Cale Bruckner$19,000
Luke Walsh$12,000
Doug Wilson$12,000
John Underwood$12,000
Additional Investment Requirement$0
Total Planned Investment$55,000
Loss at Start-up (Start-up Expenses)($62,290)
Total Capital($7,290)
Total Capital and Liabilities$26,000
Total Funding $88,290

7.2 Important Assumptions

Basic assumptions are presented in the table below.


General Assumptions
General Assumptions
199920002001
Plan Month123
Current Interest Rate8.00%8.00%8.00%
Long-term Interest Rate10.00%10.00%10.00%
Tax Rate25.42%25.00%25.42%
Other000

7.3 Key Financial Indicators

Profit growth data is presented in the chart below.


Profit Monthly

Profit_Monthly

7.4 Break-even Analysis

Break-even data is presented in the chart and table below.


Break-even Analysis

Break_even_Analysis

Break-even Analysis
Break-even Analysis
Monthly Units Break-even7,904
Monthly Revenue Break-even$20,008
Assumptions:
Average Per-Unit Revenue$2.53
Average Per-Unit Variable Cost$0.63
Estimated Monthly Fixed Cost$15,013

7.5 Projected Profit and Loss

P & L data is presented in the table below.


Profit and Loss
Pro Forma Profit and Loss
199920002001
Sales$248,878$303,548$333,903
Direct Cost of Sales$62,138$75,782$83,360
Other$0$0$0
------------------------------------
Total Cost of Sales$62,138$75,782$83,360
Gross Margin$186,740$227,767$250,543
Gross Margin %75.03%75.03%75.03%
Expenses
Payroll$93,291$121,824$129,254
Sales and Marketing and Other Expenses$33,750$40,000$43,000
Depreciation$0$0$0
Utilities$9,120$9,120$9,120
Insurance$6,000$6,000$6,000
Rent$24,000$24,000$24,000
Payroll Taxes$13,994$18,274$19,388
Other$0$0$0
------------------------------------
Total Operating Expenses$180,154$219,217$230,762
Profit Before Interest and Taxes$6,586$8,549$19,781
EBITDA$6,586$8,549$19,781
Interest Expense$2,325$1,470$1,100
Taxes Incurred$584$1,770$4,748
Net Profit$3,677$5,309$13,933
Net Profit/Sales1.48%1.75%4.17%

7.6 Projected Cash Flow

Cash flow data is presented in the chart and table below.


Cash Flow
Pro Forma Cash Flow
199920002001
Cash Received
Cash from Operations
Cash Sales$248,878$303,548$333,903
Subtotal Cash from Operations$248,878$303,548$333,903
Additional Cash Received
Sales Tax, VAT, HST/GST Received$0$0$0
New Current Borrowing$2,000$5,000$0
New Other Liabilities (interest-free)$0$0$0
New Long-term Liabilities$0$0$0
Sales of Other Current Assets$0$0$0
Sales of Long-term Assets$0$0$0
New Investment Received$0$0$0
Subtotal Cash Received$250,878$308,548$333,903
Expenditures199920002001
Expenditures from Operations
Cash Spending$93,291$121,824$129,254
Bill Payments$142,648$178,392$190,537
Subtotal Spent on Operations$235,939$300,215$319,792
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out$0$0$0
Principal Repayment of Current Borrowing$9,290$2,000$0
Other Liabilities Principal Repayment$0$0$0
Long-term Liabilities Principal Repayment$9,600$5,000$4,800
Purchase Other Current Assets$0$0$0
Purchase Long-term Assets$0$0$0
Dividends$0$0$0
Subtotal Cash Spent$254,829$307,215$324,592
Net Cash Flow($3,951)$1,333$9,311
Cash Balance$20,049$21,382$30,693

Cash

Cash

7.7 Projected Balance Sheet

Our projected balance sheet is presented in the table below.


Balance Sheet
Pro Forma Balance Sheet
199920002001
Assets
Current Assets
Cash$20,049$21,382$30,693
Inventory$7,669$9,353$10,288
Other Current Assets$0$0$0
Total Current Assets$27,718$30,735$40,982
Long-term Assets
Long-term Assets$0$0$0
Accumulated Depreciation$0$0$0
Total Long-term Assets$0$0$0
Total Assets$27,718$30,735$40,982
Liabilities and Capital199920002001
Current Liabilities
Accounts Payable$14,931$14,638$15,752
Current Borrowing$2,000$5,000$5,000
Other Current Liabilities$0$0$0
Subtotal Current Liabilities$16,931$19,638$20,752
Long-term Liabilities$14,400$9,400$4,600
Total Liabilities$31,331$29,038$25,352
Paid-in Capital$55,000$55,000$55,000
Retained Earnings($62,290)($58,613)($53,303)
Earnings$3,677$5,309$13,933
Total Capital($3,613)$1,697$15,630
Total Liabilities and Capital$27,718$30,735$40,982
Net Worth($3,613)$1,697$15,630

7.8 Business Ratios

The Standard Industrial Classification (SIC) Code for the Internet Service Provider industry is "Remote data base information retrieval" 7375.9903. We used the report for "Information retrieval services" 7375 to generate the industry profile.

As we are also a food cafe we could have used the ratios based on SIC classification 5812, "Eating places". The combined nature of JavaNet Cafe makes our ratios a blend of the two industries.


Ratios
Ratio Analysis
199920002001Industry Profile
Sales Growth0.00%21.97%10.00%0.90%
Percent of Total Assets
Inventory27.67%30.43%25.10%2.17%
Other Current Assets0.00%0.00%0.00%59.34%
Total Current Assets100.00%100.00%100.00%86.95%
Long-term Assets0.00%0.00%0.00%13.05%
Total Assets100.00%100.00%100.00%100.00%
Current Liabilities61.08%63.90%50.64%28.33%
Long-term Liabilities51.95%30.58%11.22%16.21%
Total Liabilities113.03%94.48%61.86%44.54%
Net Worth-13.03%5.52%38.14%55.46%
Percent of Sales
Sales100.00%100.00%100.00%100.00%
Gross Margin75.03%75.03%75.03%100.00%
Selling, General & Administrative Expenses73.78%73.30%70.86%79.00%
Advertising Expenses6.03%8.24%8.39%1.01%
Profit Before Interest and Taxes2.65%2.82%5.92%1.62%
Main Ratios
Current1.641.571.971.90
Quick1.181.091.481.52
Total Debt to Total Assets113.03%94.48%61.86%52.45%
Pre-tax Return on Net Worth-117.95%417.22%119.52%3.74%
Pre-tax Return on Assets15.37%23.03%45.58%7.86%
Additional Ratios199920002001
Net Profit Margin1.48%1.75%4.17%n.a
Return on Equity0.00%312.92%89.14%n.a
Activity Ratios
Inventory Turnover10.918.908.49n.a
Accounts Payable Turnover10.5512.1712.17n.a
Payment Days273029n.a
Total Asset Turnover8.989.888.15n.a
Debt Ratios
Debt to Net Worth0.0017.111.62n.a
Current Liab. to Liab.0.540.680.82n.a
Liquidity Ratios
Net Working Capital$10,787$11,097$20,230n.a
Interest Coverage2.835.8217.98n.a
Additional Ratios
Assets to Sales0.110.100.12n.a
Current Debt/Total Assets61%64%51%n.a
Acid Test 1.181.091.48n.a