Coffee Shop Financial Plan
Key Revenue & Costs
The revenue drivers for Java Bros Coffee shop will come from its coffee offerings, bakery items, and panini and Italian soda offerings. The pricing will be upscale yet competitive with other Austin coffee shops.
The cost drivers are its ability to scale by selling local Texas coffee, salaries and wages within market range, and by offering a limited menu, the cost for supplies is minimal. Java Bros is also limited on cost because Joey and Max will take home a small salary. They would rather invest back into the company than take home inflated salaries.
Funding Requirements and Use of Funds
Java Bros is seeking $300,000 in debt financing to open its two locations. The funding will be dedicated for leasehold improvements, design, working capital, and opening inventory. The breakout of the funding is below:
Location #1
- Store design/build: $100,000
- Working capital: $25,000
- Opening inventory: $25,000
Location #2
- Store design/build: $100,000
- Working capital: $25,000
- Opening inventory: $25,000
Key Assumptions
The following table outlines the key assumptions required in order to achieve the revenue and cost numbers in the financials and in order to pay off the business loan.
- Number of Customers Per Day:Â 80
- Average Menu Item Cost:Â $3.00
- Average Order per Customer:Â $6.50
- Annual Lease (per location):Â $60,000
Financial Projections
Income Statement
| FY 1 | FY 2 | FY 3 | FY 4 | FY 5 | ||
|---|---|---|---|---|---|---|
| Revenues | ||||||
| Total Revenues | $360,000 | $793,728 | $875,006 | $964,606 | $1,063,382 | |
| Expenses & Costs | ||||||
| Cost of goods sold | $64,800 | $142,871 | $157,501 | $173,629 | $191,409 | |
| Lease | $50,000 | $51,250 | $52,531 | $53,845 | $55,191 | |
| Marketing | $10,000 | $8,000 | $8,000 | $8,000 | $8,000 | |
| Salaries | $157,015 | $214,030 | $235,968 | $247,766 | $260,155 | |
| Initial expenditure | $10,000 | $0 | $0 | $0 | $0 | |
| Total Expenses & Costs | $291,815 | $416,151 | $454,000 | $483,240 | $514,754 | |
| EBITDA | $68,185 | $377,577 | $421,005 | $481,366 | $548,628 | |
| Depreciation | $27,160 | $27,160 | $27,160 | $27,160 | $27,160 | |
| EBIT | $41,025 | $350,417 | $393,845 | $454,206 | $521,468 | |
| Interest | $23,462 | $20,529 | $17,596 | $14,664 | $11,731 | |
| PRETAX INCOME | $17,563 | $329,888 | $376,249 | $439,543 | $509,737 | |
| Net Operating Loss | $0 | $0 | $0 | $0 | $0 | |
| Use of Net Operating Loss | $0 | $0 | $0 | $0 | $0 | |
| Taxable Income | $17,563 | $329,888 | $376,249 | $439,543 | $509,737 | |
| Income Tax Expense | $6,147 | $115,461 | $131,687 | $153,840 | $178,408 | |
| NET INCOME | $11,416 | $214,427 | $244,562 | $285,703 | $331,329 |
Balance Sheet
| FY 1 | FY 2 | FY 3 | FY 4 | FY 5 | ||
|---|---|---|---|---|---|---|
| ASSETS | ||||||
| Cash | $154,257 | $348,760 | $573,195 | $838,550 | $1,149,286 | |
| Accounts receivable | $0 | $0 | $0 | $0 | $0 | |
| Inventory | $30,000 | $33,072 | $36,459 | $40,192 | $44,308 | |
| Total Current Assets | $184,257 | $381,832 | $609,654 | $878,742 | $1,193,594 | |
| Fixed assets | $180,950 | $180,950 | $180,950 | $180,950 | $180,950 | |
| Depreciation | $27,160 | $54,320 | $81,480 | $108,640 | $135,800 | |
| Net fixed assets | $153,790 | $126,630 | $99,470 | $72,310 | $45,150 | |
| TOTAL ASSETS | $338,047 | $508,462 | $709,124 | $951,052 | $1,238,744 | |
| LIABILITIES & EQUITY | ||||||
| Debt | $315,831 | $270,713 | $225,594 | $180,475 | $135,356 | |
| Accounts payable | $10,800 | $11,906 | $13,125 | $14,469 | $15,951 | |
| Total Liability | $326,631 | $282,618 | $238,719 | $194,944 | $151,307 | |
| Share Capital | $0 | $0 | $0 | $0 | $0 | |
| Retained earnings | $11,416 | $225,843 | $470,405 | $756,108 | $1,087,437 | |
| Total Equity | $11,416 | $225,843 | $470,405 | $756,108 | $1,087,437 | |
| TOTAL LIABILITIES & EQUITY | $338,047 | $508,462 | $709,124 | $951,052 | $1,238,744 |
Cash Flow Statement
| FY 1 | FY 2 | FY 3 | FY 4 | FY 5 | ||
|---|---|---|---|---|---|---|
| CASH FLOW FROM OPERATIONS | ||||||
| Net Income (Loss) | $11,416 | $214,427 | $244,562 | $285,703 | $331,329 | |
| Change in working capital | ($19,200) | ($1,966) | ($2,167) | ($2,389) | ($2,634) | |
| Depreciation | $27,160 | $27,160 | $27,160 | $27,160 | $27,160 | |
| Net Cash Flow from Operations | $19,376 | $239,621 | $269,554 | $310,473 | $355,855 | |
| CASH FLOW FROM INVESTMENTS | ||||||
| Investment | ($180,950) | $0 | $0 | $0 | $0 | |
| Net Cash Flow from Investments | ($180,950) | $0 | $0 | $0 | $0 | |
| CASH FLOW FROM FINANCING | ||||||
| Cash from equity | $0 | $0 | $0 | $0 | $0 | |
| Cash from debt | $315,831 | ($45,119) | ($45,119) | ($45,119) | ($45,119) | |
| Net Cash Flow from Financing | $315,831 | ($45,119) | ($45,119) | ($45,119) | ($45,119) | |
| Net Cash Flow | $154,257 | $194,502 | $224,436 | $265,355 | $310,736 | |
| Cash at Beginning of Period | $0 | $154,257 | $348,760 | $573,195 | $838,550 | |
| Cash at End of Period | $154,257 | $348,760 | $573,195 | $838,550 | $1,149,286 |